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: https://www.sqlservertutorial.net/wp-content/uploads/SQL-Server-Sample-Database.zip

If you're using SQL server, follow these steps to load the database:

1. Open SQL server, create a new database and name it BikeStores
2. Select the new BikeStores database in the SQL server
3. Open the zip downloaded from the link I provided
4. Open the 'create objects' query file and then execute it in the SQL server for the BikeStores database
5. Open the 'load data' query file and then execute it in the SQL server for the BikeStores database

If you have problems setting up the database and writing the SQL query, here is the Excel version of the dataset. Make a copy of it to your Google Drive or download it to your computer in the file section of the Google Sheets interface: https://docs.google.com/spreadsheets/d/1ESMiCguVJjUzjVNxLffngDrHsQcMFHrt/edit?usp=sharing&ouid=104184278293925862670&rtpof=true&sd=true

Chapters:

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 charts
1:10:58 Using parameters and sets to make Top N chart
- 1:15:19 Creating banner and action filters for dashboard
- 1:20:33 Creating the executive dashboard
- 1:29:46 Making executive dashboard interactive
1:35:41 Using calculated field to make text contextual
- 1:38:42 Saving dashboard to the Tableau Public server