Full Data Analysis Portfolio Exercise (SQL, Excel, Tableau)

A complete data analytics project walkthrough using SQL, Excel, and Tableau. Watch generate a dataset using SQL and use the dataset to create a Tableau dashboard, as well as an MS Excel dashboard. Download sample dataset: Timestamps: 0:00 Introduction 2:03 Data analysis process SQL Section - 4:06 - 4:25 Writing SQL query - 17:44 SQL query results (dataset) Excel Section - 19:29 - 19:32 Connecting SQL dataset to Excel Workbook - 24:11 Creating PivotTables and PivotCharts 25:40 Stopping PivotTable Grouping from affecting another PivotTable 29:24 Creating a graph with multiple lines (series) 35:07 Creating map chart - 32:22 Setting up Excel dashboard - 50:52 Adding slicers to make Excel dashboard interactive Tableau Section - 1:00:35 - 1:01:12 Connecting Excel dataset to Tableau Workbook - 1:02:08 Setting default properties - 1:02:49 Making