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

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

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

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!!

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

I have added the practice dataset in the description. If you're using SQL server, follow these steps to load it: 1. Open Microsoft SQL server, create a new database and name it BikeStores 2. Select the new database in the SQL server 3. Open the zip downloaded from the link I provided in the description 4. Open the 'create objects' query file and then execute it when it propagates in the the SQL server 5. Open the 'load data' query file and then execute it when it propagates in the SQL server

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

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

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.

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

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

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

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

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

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

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.

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.

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

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

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.

00:03 Creating a comprehensive sales dashboard for the executive team using SQL, Excel, and Tableau. 02:58 Creating comprehensive dashboards for sales activities and trends analysis. 11:24 Joining tables to gather comprehensive data 18:43 Data cleaning in SQL for analysis 24:26 Creating pivot tables and charts using SQL data 26:56 Creating separate pivot tables and charts from data 33:25 Creating map and pie charts for revenue breakdown 37:48 Creating various charts and formatting cells. 51:34 Using slicers in Tableau to filter data for gaining insights. 54:58 Interactivity through slicers enhances dashboard usability 1:00:38 Creating interactive dashboards in Excel and Tableau 1:03:46 Creating different chart types for revenue analysis 1:09:57 Customizing and organizing revenue data visuals. 1:13:17 Parametric filter control for customer display 1:18:30 Customizing dashboard elements 1:21:03 Structuring the dashboard layout 1:32:00 Dynamic filtering and dashboard interaction 1:35:04 Updating title text based on selected states Crafted by Merlin AI.

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

Well done. This is a great 👍 tutorial on data analytics. Being a newbie in the field, I wish you have used the power query on the ETL step to leverage its power on the cleaning step rather a visual checking! The concatenation of columns could have been performed on the Excel Power Query just before loading (Transformation)! Keep it up!

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

Nice tutorial you have got here. I would suggest creating a view is sql and instead make the connection via the view rather than copy and pasting the sql query like you did.

I love this video. It was great insight for my Capstone project. New subscriber here!!! Thank you and can't wait for you to make more.

You don't show how the brand_name column is created (40:22)!!! Please explain!!! Thanks!!!

Thank you for your effort to do this video. It's really helpful to people who are new to Data Analytics like me.

Great work on this! Found it really helpful to understand how a full project can be structured, thank you! :)

I have a problem or rather a confusion in the loading SQL file you have give us,in the creation of sales.staff we are having a self referencing forgein key which is based on an auto incremented primary key so won't we have the same value for primary and forgein key?If so is this a violation of primary key constraint? Perhaps I have not captured enough info , kindly excuse me if I have not analysed the code neatly.

Easy and digestible information I enjoyed watching every second of the video really amazing job thank you brother

Incredible, very good project to start your portfolio, thank you!

If anyone has imported this dataset in mysql workbench then pls guide me..

Great video, thank you so much for your effort. But I have a question for the SQL section, when you use SUM() functions for total_unit and revenue and then GROUP BY(). What if in case I don't use these 2 functions, the result will be the same. This is because the quantity in the order_items table refers to the sum quantity of each item in each order, so I think SUM() and GROUP BY() are not necessary.

53:55 what if the slicer pivot table checkboxes doesnt show every pivot table? i am specifically missing the revenue per store and revenue per brand pivot tables from the checkboxes

After the first two pivot table, all other tables are connected to the second pivot table. Therefore, the slicers of the first one cannot be applied to others. To fix this, instead of creating new pivot tables after the two seperate ones, you may first copy paste the pivot table you want to make connections between them and then change the columns.

Please make complete tutorials on power bi ,excel , tableau

Thank you so much for this video! It helped a lot for my first try at data.

Wow amazing content loved it 👍.Thank you for sharing the knowledge 🤩

26:49 Please correct, it is not (Ctrl + D + P) It is (Alt + D + P)

Hi all! I noticed that in the "order_items" table there is a discount column. Wouldn't it be correct to count the revenue, including the discount column?

Thank you so very much for this awesome tutorial.

Very good tutorial but sadly like half of the people in the comments i cannot get the data set to work. I was able to lead the "create objects file" and i executed each query to get the tables into the "BikeStore" database. The tables are empty though. I tired executing the "load data" queries which were really long and it didn't not work induvially or together. It is important to remember that we are Level 1 beginners so most of us are only use to getting data sets from Excel sheets. you started the tutorial with dataset but we cant follow along because WE DONT KNOW HOW TO LOAD THE DATA SET.

Thanks for the training. Provide the link for the data so that one will be able practice with it.

the tutorial is attractive and clear to understand but i have aquestion for you if you give us the sample database and we can practice on it

I use MacOS, so I work with Mysql Workbench, have some error when I execute the file Create objects. Details: CREATE TABLE production.categories ( category_id INT IDENTITY (1, 1) PRIMARY KEY, category_name VARCHAR (255) NOT NULL have some error that: 'IDENTITY' is not valid at this position, expecting ')' what can I do ? Please help, I am a beginner. Thank U so much

@Dataset Guru Hlo sir i am facing issue during insert values commands in load file . i am using mysql so to insert multiple records i have to remove the insert into for all the remaining records other than first record for each table inserting. otherwise i have to execute each and everyline at a single time which takes so much time. do u have any other ways to insert multiple records in mysql sir using the commands which u gave in load file sql filescript.

That is cool. Thanks for your sharing. I hope you great as well

00:00 Create a comprehensive sales dashboard for a bicycle retail company using SQL, Excel, and Tableau 10:26 Data analysis process completed successfully 23:35 Creating pivot tables and charts for total revenues per year and per month 31:26 Generate five charts for revenue analysis 49:28 Dashboard made interactive using Excel feature called slicers 59:07 Generated interactive dashboard with charts for total revenues, revenues per month, revenues per state, revenues per store brand and top 10 customers. 1:08:16 Revenue breakdown by brand and product category 1:16:27 Created a dashboard with key metrics and charts 1:27:55 Dashboard made interactive with filters 1:37:50 Completed dashboard for bike store Crafted by Merlin AI.

I am sure this is useful for beginners and students. Appreciate you doing this for them. But this is very very basic, real life scenarios are much more intricate (sql-wise) and require a better, more beautiful/professional front end (dashboard)

thanks bro this was good and was my first ever portfolio

most real time work simply super😁

Hi, Great video and thank you for helping me with my project but I had a doubt- you did not add brand name column while writing the SQL query but it is shown in excel after importing.

Thank for sharing value lesson to us.

Great video! Thank you!

So Insightful

Thank you very much…..I learned new things.

How are you adding slicers for multiple charts, when the cache is not shared across all the pivot tables?

what an informative piece, i love it😊

Thank you for amazing tutorial.

Thank you! Just subscribed and liked the video. It helped a lot. :)

another question here if anyone can help, the Total Revenue pivot table is total isolated when i use the slicers it has it's own slicer that doesn't connect to any other pivot table, my guess it's because of the wizard function. any help plz?

Great job, my friend!

Amazing work! I love how you integrate SQL, Excel and Tableau. Can you please share the link to dataset?

When I try to insert the pivot table 'data source reference is not valid' error is coming. I have saved the file on my local drive. Please help

I am confused and can anyone help me ? When I tried to open the downloaded sample dataset using Mysql WORKBench, I couldn't generate the database like as the beginning of the video with the list of tables. Or am can I create that database by download the sample dataset link that you provided, and then run on SQL Workbench ?

Please help! When I tried to upload the data in SQL , the first thing on the top is CREATE SCHEMA production; go CREATE SCHEMA sales; go I am getting error as syntax error at or near "go". However, i have not done anything fromfrom my end. i just selected the file from the folder, the link which you have provided in description. Cold you please help me fix the issue. I am keen to follow along with the tutorial . Please help !!

Nice one sir, Thank you very much, this tutorial is really helpful. though i'm having issues with the number of rows, mine is reading 15,172

I love the video, thank you!

The great project ever

Thank you sir, wonderful. Great video!

Nice work . Can you somehow integrate python for full circle analysis. It would be extremely perfect❤

This is really good... thank you for sharing 👍

Hi, thank you so much for the tutorial. However, I cannot download the excel file. Can you check this?

Please can show how you uploaded the file on SSMS, am having difficulty in importing the bike purchased dataset please thanks

Awesome training 👍👍👍

9:22 when calculating revenue, you didn't minus discount ? just quantity * list_price?

Not all pivots tables are showing in report connections in slicers. Anybody know why?

I have a question. I am not using states filter, using only year filter. For the year 2018, Top 10 customer are showing but for year 2017 only top 6 customers are showing and for 2016 only top 4 customers are showing. This problem is only on Tableau not in Excel. Also, Tableau is showing different data for top customers than from Excel. If anyone could help?

Thank u so much learned a lot !!!!!

I've followed the steps but it won't open. then I open downloaded but in sql can not be excute. please guide 🙏

This is an interesting tutorial. I really like the step by step explanation and the context. Could you please conduct another one with s different scenario using MS SQL, Excel and PowerBI? 🙂🙂🙂

Simple. To the point. Thank you.

I don't see a comment for this so perhaps I am being stupid lol.. but when I do the slicer for the order date it puts like everyday of each year instead of just the year?? Anyone know what I need to do?

thanks for all the work, while making the chart for Brand/revenue i found out that i didn't actually extract the brand from the database although i could see in the sheet in the description that tha brand is there so probanbly i did a mistake there. Quick question here: so i adjusted the code and imported in to a new sheet name Query2 in the same way we did the Query1 sheet to be able to complete the work. my question here is, is there a way to update the same exact sheet in case i change the code in the original SQL query?

Hello! Thank you so much for such a thorough tutorial. At around 11:00 you grouped by and used agg function to get quantity and revenue. Why couldn't we just get quantity and revenue without agg function and group by. Wouldn't it give the same results as each order_id already has the quantity and revenue is simply just quantity*price. Why did we use an aggregate function there ?

in your sql query you never add any brand name but your excel query can see brand name. How can that happen?

at 1:07:55 you dropped in "Brand Name" into the Columns pane...But that was never a field that we grabbed in SQL. People following along are not going to have that field available in Tableau. Edit: You also clearly created aliases for your measure names at about 1:15 that you never showed the viewer how to do.

You are an icon man

Didn't anyone experience difficulty during the process? At first, I was stuck on how to open a sql file, then there were errors when I tried to execute the files (I don't even know what amendment I should do) When that problem was finally solved, I was not able to retrieve the data after writing out the same query. I am just 9min into the video and I am about to smash my laptop!! Not sure how am I able to finish watching it :'(

quantity * list_price isn't the revenue ..

how to load database....?

Hey thanks for the video. how to load this dataset to MySQL Workbench.

I have a question! I finished the work. But my dashboard seems a little bit weird in terms of the Top customers and Revenue per sales rep. ex. 2017, NY - i can see 6 top customers, 2 sales reps. vs 2017 CA, Zero top customers, 2 sales reps. => Is it a correct result? Zero top customers seems to not make sense to me... Could anybody help me?

How to get years in slicers by selecting order date….I am getting day wise not years

Thanks for providing this nice video But, I am unable to get any value back when running the queries. Even when execute the basic select statement, no value is coming back Please advise

@1:38:08 Great insight!!!!

Can you provide road map to learn data analysis for a beginner ..

36:08 you say "right there" @36:10 and it sounds like you clicked on some keys on your keyboard for some sort of short cut. What keys did you press on to enlarge the Legend?

Great video!

good video thk u so much. but i have one question ! why don't u use a temp table on sql ?