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.

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

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

[divyajeetsingh]

Pls make more videos like this. Learning by projects is very easy and interesting rather than watching tutorials.

[dendydarin]

This workflow is what I'm looking for insight as beginner data analyst student. Thanks!

[roseboutique-womensalterat]

Thank you very much. it was very helpful. One note: we need to press ALT+D+P at 26:57 instead of Cntrl+D+P

[deidara]

Brazilian sub here. While practive my english i study data science. Best way to improve 2 diferents things! 😃

[temitopefabiyi]

This is one of the best tutorials I have seen so far, well detailed and organised. I was able to flow with it from the beginning till the end.

[alexrosen]

Simply one of the best tutorials I have seen on Youtube and believe me, I have seen a lot of them!

[shamiliqbal]

Guys, those who find brand names missing. Copy and paste the brand name column from the description Excel file and paste it into your table. Also don't forget to change the data source and refresh the Pivot table to update the change. thank you!!

[pankajingale]

Bro you really did a great job than the youtuber from whom I learnt Tableau

[malikkngn]

Thank you so much for this incredible detailed project journey!!! on behalf of all the data beginners.

[mohsena.s]

You are very good at teaching, please keep up the good work.

[muammerguldemir]

This is the best all in one exercise ever, thank you sir for your effort!

[gennadias]

Thanks so much for this video! I graduate uni next year but I knew I wanted to make a portolio and this is a perfect addition to it.

[lollar]

One of the best Data Analysis videos I have come across. I learned so much from this. Thank you!!!

[ryanfarezi]

this is really good to understand as a beginner data analyst, thank you!

[tamaboy]

Today i was asking myself how does it looks to be a DA, thanks for this vid. Feel more confident now in what to expect.

[olenaandrusenko]

Thank you for so great explanation!!! Could you please do more videos like this one? It was the most helpful video so far from all I saw

[VD-cdxm]

Thank you for making this video tutorial and sharing the database, very much appreciate this!

[aishwaryapattnaik]

Double thumbs up 👍👍 ...A very good video on end to end implementation right from SQL Server to Tableau. Looking forward for more such videos

[okenwajiugoeviso]

Nice Video .
but i noticed you added another column "brand name" after you imported the dataset to excel which wasnt added to the initial query.
Took me about !0 mins to figure out
All in all, awesome video man

[jmorsejr]

Thanks for presenting this demonstration. I really enjoyed the way the created the SQL code step by step, rather than trying to build the entire query in one shot from top to bottom.