SQL Portfolio Project Walkthrough | PostgreSQL + Tableau | Data Prep, Analysis and Visualisation скачать в хорошем качестве

SQL Portfolio Project Walkthrough | PostgreSQL + Tableau | Data Prep, Analysis and Visualisation

In this video, I walk through a full data analysis project from configuring the source data, analysing the data and visualising it. For the setup please see this video:    • How to Setup a Local PostgreSQL Database |...   Challenge: https://github.com/wjsutton/lego_anal... Solutions: 1 - Migrate data new schema, new data types and primary & foreign keys: https://github.com/wjsutton/lego_anal... 2 - Create analysis as a view: https://github.com/wjsutton/lego_anal... 3 - Create a data visualisation : https://public.tableau.com/app/profil... 4 - Document you work on GitHub template: https://github.com/wjsutton/lego_anal... PostgreSQL: https://www.postgresql.org/ DBeaver: https://dbeaver.io/ Tableau: https://www.tableau.com/en-gb/trial/t... Tableau Public: https://www.tableau.com/products/publ... Check out other challenges from the Summer of SQL here: https://github.com/wjsutton/the_summe... 01:30 Data Prep intro 03:34 Create new schema and table setup 04:37 Determining data types 07:37 Repeatable SQL create queries 08:51 Insert data from staging schema 10:20 Adding primary and foreign keys 16:32 Cascade 17:01 Review ERDs entity relationship diagrams 18:15 Finding a perspective for your data analysis 20:33 Determining unique parts 22:23 Finding sets by uniqueness 24:30 Aggregating dataset 25:24 Creating a view 26:58 Connecting to Tableau 27:54 Resolving permissions issues and connecting to the dataset 29:55 Exploratory analysis in Tableau 33:23 Sorting with a calc field 35:42 Creating a level of detail (LOD) calculation 36:47 Building a dashboard 38:28 Dashboard design tips 39:52 Add dashboard interactions 41:06 Bonus design tips and publishing 41:46 GitHub resources and outro