Power BI + My SQL Project | Power BI Project from start to end | Power BI tutorial 2024

#powerbi #mysql #dataanalytics
Power BI + My SQL Project | Power BI Project from start to end | Power BI tutorial 2024

Welcome to this comprehensive Data Analyst Project tutorial! In this tutorial, I will guide you through the complete process of building a data analysis project using popular tools such as Power BI, Tableau, SQL, and Excel.

Whether you are a beginner or an experienced data analyst, this tutorial will provide you with the necessary knowledge and hands-on experience to successfully complete a data analysis project. Join me on this journey and unlock the power of these essential data analysis tools.

⭐For Tableau, Power BI and Excel Projects contact me on my mail id or WhatsApp number mentioned at the end of description box.
➖➖➖➖➖➖➖➖➖➖➖➖➖
⭐Content
Project Preview 00:00
Odin School 03:07
Power BI Functionalities 06:38
Problem Statement 13:50
Raw Data Walkthrough 21:50
Data Import in Power BI 30:14
Data Quality Check / Cleaning 36:47
Date / Calendar Table 46:43
Data Modeling 53:55
Dashboard Setup 56:53
Total Sales Analysis KPI 01:06:08
Sales Sparkline 01:25:35
MoM Increase or Decrease/ MoM Diff DAX 01:30:28
Total Order Analysis 01:56:06
Total Qty Analysis 02:02:00
Calendar Heat Map 02:11:13
Tool Tip for Calendar Heat Map 02:32:56
Weekday / Weekend Sales 02:45:58
Analysis by Store Location 02:52:43
Daily Sales Analysis using Average Line 03:03:41
Sales by Product Category 03:17:32
Sales by Product 03:25:55
Sales by Days & Hours 03:30:31
Adding Slicer 03:50:06
Interactive Filters 03:54:04
Outro 03:56:11
➖➖➖➖➖➖➖➖➖➖➖➖➖
Checkout my other videos on dashboards design in Tableau, Power BI and Excel below-

=

➖➖➖➖➖➖➖➖➖➖➖➖➖
WhatsApp - [phone]

➖➖➖➖➖➖➖➖➖➖➖➖➖
Related keywords:
data analyst project,
data analyst project for beginners,
data analyst portfolio project,
data analysis project,
data analyst projects for resume,
data science project,
data analyst excel project,
excel tutorial,
excel tutorial for beginners,
end to end project for data analyst,
excel project for data analyst,
excel project,
report in excel,
dashboard in excel,
data analyst portfolio project
data analyst project
data analysis project
data analyst projects for resume
data analyst sql project
end to end project for data analyst
sql project for data analyst
project for beginners
sql portfolio project
data analyst sql project
data analyst full project
data analyst resume project
sql project
power bi tutorial ,power bi desktop tutorial ,power bi tutorial for beginners ,power bi desktop ,power bi dashboard ,power bi training ,power bi demo ,power bi for beginners ,power bi dashboard tutorial ,power bi tutorial for beginners excel ,power bi ,tutorial ,desktop ,dashboard ,excel ,microsoft excel ,power bi vs tableau ,tableau vs power bi ,mspowerbi ,Power BI Pro ,PowerBIPro , swapnjeet, Microsoft PowerBI, Microsoft Power BI, PowerBI, Power BI, PowerBI Tutorial, Power BI Tutorial, PowerBI Dashboard, Tableau, tableau dashboard, tableau tutorial, SQL, SQL project

[sathyamanikantabk]

2:47:38

IN FUture if there are too many things to consider for certain condition to be met

thne we can just use IN operator instead of || operators

DAX:
Weekday / Weekend = IF( 'Date Table'[Day] IN {"Sat", "Sun"}, "Weekend", "Weekday")

[funa]

I can’t believe you had done it in 4 hours only. It’s so tiring, but I’m glad I could complete my first own sales dashboard. OMG Thank you so much! God bless u!

[oluwaseyirotimi-jimoh]

Greetings from Nigeria. Your videos have helped me learn new stuff in data analysis. thank you for the effort,

[DatawithHimanshu]

This channel has many end to end projects across the domains that one can learn to become a Data Analyst. Really amazing stuff. Thanks and regards 🙏🙏

[tariqhussain]

Good afternoon, i learn so many things in this dashboard and enhanced my knowledge on DAX and insights and also the interactions between all charts and KPIs, and hope that you are going to make some more Dashboards with new ideas .

[uchiha_sasuke_]

Where have you used MySQL?

Please make a video how to get the MySQL table data into PowerBI.
I've explored many videos in YouTube. No one showed a proper tutorial.

[mrbartuss]

1. Shouldn't we create dim_Product and dim_Store tables to make a star schema?
2. What is your opinion on creating a design by inserting shapes, which makes refresh slower, instead of using PowerPoint?
3. 1:09:00 Why calculated column instead of a measure? Performance will definitely suffer
4. What's the point in creating CM Sales? It is exactly the same as Total Sales
5. 1:45:53 Why did you create month-diff variable and then did not use it in mom?
6. 2:36:40 This pie chart doesn't make any sense. How can you compare Total Sales in $ with Total Orders? These are different units

[AlbertDataAnalyst_sp]

Hello man, your content is awesome. Learned a ton of new stuff through your long video tutorials. Greetings from Spain. Keep it up!

[saivaibhav]

weekday/weekend = IF(Date_Table[Week Day Number]<=5, "Week Day", "Week End")

[TussharPatnaik]

This was very interesting and learned a lot of new stuff. Keep posting such new projects.

[ExcelTechnologyVijay]

I Learned lot from your videos.Thanks Lot for you videos and Effort.

[TheBestMrSam]

@DataTutorials, thank you so much for this highly insightful and well curated teachings. Your magnificent dexterity is highly commendable.
I have decided to add this project to my portfolio and I am almost completing it. However, I figured that each time I format the constant line section to select the new measure calculated(Daily Avg Sales), as soon as I click ok, the bars(columns) in the stacked column chat, disappears. I tried to increase the value to 1, the column then re-appeared but as soon as I proceed to select the new measure calculated, it vanishes again. I have tried to unselect and re-select to troubleshoot the error, still proved futile. I will appreciate your assistance. Thank you in anticipation.

[sathyamanikantabk]

1:19:00 I am getting this error(**Error **
Circular dependency detected: Date Table[Month No], Date Table[Month Year], Date Table[Month No].)

[pavanr]

Sir, Huge fan of you, you are the driving force behind my love to data analytics🤩🤩🤩🤩

[mikichan]

THIS IS AWESOM!! I leaned a lot from this tutorial. Good Job! Keep up the good work Friend !

[alexrosen]

Extremely useful tutorial. Thank you very much. I learned a lot 🙏🙏🙏

[Sanj]

Great, Thanks for this project. Appreciate your efforts, hard work, patience and communication style. Keep it up bro!!

[amartyajena]

Thankyou bro...its bit lengthy but covers all topics and concepts

[himanshumandal]

The project is superb and very helpful.. Thank you for taking the initiative .. Just one suggestion .. I think if you make the project in Hindi ... it would be more impactful and easy to understand (especially the DAX functions and the exact purposes for making the DAX function)

[pranalialaspure]

Nice Dashboard..nice information you are giving