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
Odin School PL300 Power BI Certification Course - hubs.la/Q02xXcNc0
⭐For Important Data Analyst Materials and Projects visit my website - topmate.io/data_tutorials
Data Download - drive.google.com/drive/folder...
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.
📱Follow me on Facebook - profile.php?...
📱 Follow me on LinkedIn - / swapnjeet-s-58a673273
⭐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-
✅Data Modelling - • Data Modeling in Power...
✅Data Cleaning - • Data Cleaning in Power...
✅Data Analyst Portfolio Projects - • SQL & Excel Portfolio ...
✅Power BI Projects - • Power BI Dashboard fro...
✅Tableau Projects - • Tableau Dashboard from...
✅Excel Projects - • Dynamic Excel Dashboar...
✅SQL Projects - • Data Analysis SQL Proj...
✅Power BI Interview Questions with Answers - • Power BI Scenario base...
✅Tableau Interview Questions with Answers - • Tableau Scenario Based...
=
➖➖➖➖➖➖➖➖➖➖➖➖➖
Reach out to me for any personal or Business related Dashboard/ Report development on my email- [e-mail]
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

[@datatutorials1]

Odin School PL300 Power BI Certification Course - hubs.la/Q02xXcNc0

[@sathyamanikantabk4483]

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

[@sathyamanikantabk4483]

what is the solution for this

[@sathyamanikantabk4483]

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")

[@funa2939]

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!

[@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 🙏🙏

[@uchiha_sasuke_48]

Where have you used MySQL? Please make a video how to get the MySQL table data into PowerBI. I've explored many videos in KZbin. No one showed a proper tutorial.

[@oluwaseyirotimi-jimoh9253]

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

[@TussharPatnaik]

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

[@tariqhussain1497]

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 .

[@mikichan1040]

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

[@user-hd1ve4cx9e]

Thank you for this great tutorial! I learnt a lot !

[@mikichan1040]

I learned lot from your tutorial, keep it up mate!

[@mrbartuss1]

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

[@VINODkumar-gz8tt]

Interesting Questions waiting for answers 😊

[@mrbartuss1]

@@VINODkumar-gz8tt It seems we won’t get them

[@alexrosen8762]

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

[@Sanj20101]

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

[@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.

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

[@datatutorials1]

Thanks bro, glad you liked it 😃

[@user-eh1mj7lb2p]

Thank you so much very useful..

[@pranalialaspure1833]

Nice Dashboard..nice information you are giving

[@amartyajena9175]

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

[@ibehchibuikekingsley6045]

Man, this content is very good, and I learnt a lot of new ideas on visualisation

[@addhyasumitra90]

thank you for the dashboard :)

[@KN-dv4be]

Thank you

[@Jreltaweel]

thank you for powerful tutorials

[@swerve9380]

Great video

[@ExcelTechnologyVijay]

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

[@datatutorials1]

Glad to hear that

[@nikhildhongade291]

good job keep it up brother.😇

[@himanshumandal9561]

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)

[@sathyamanikantabk4483]

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

[@sreelalithagudimetta]

Awesome explanation💯 , cleared my doubts on DAX🙏

[@yonatanabrham5865]

it is amusing course,i learnd a lot from your channel keep working,this is from Ethiopia . when will you start making tutorial on python

[@pavanr6100]

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

[@datatutorials1]

Glad to hear that

[@OlaobajuOluwajoba]

Why am i having issues with this colorsl for bars. All the bars keep having the same color

[@Mughrabi97]

Thank you so much for the great lesson sir , indeed learned a lot & boosted one confidence with all the DAX manipulation shown in this video . i just have a question regards the last visual Sales by Hours | Days whenever you use any of the filters of other visuals the stacked column chart above the [Day Names] will be filtered but not synched with the heat map , i wonder if you can tell me how to synch them together.

[@43_jaymohitepatil47]

great explanation but my doubt is what is the reason to use SQL in this project since everything depends on DAX queries to make different metrics like total orders , total sales etc in power BI

[@datatutorials1]

It’s mentioned in part one

[@kunalrajkashyap4904]

please make a project on marketing domain and pharma/healthcare domian please

[@sumitpaul3481]

Whenever I am trying to import the data into MySQL only the columns are getting imported and not the rows kindly assist

[@sudeepachanda8790]

Could you please add the SQL queries which you have shown in word document in here as well

[@saiky_111]

Can you bring some Postgre SQL projects?

[@debabrataroy1777]

🙏🙏🙏🙏

[@NITINBISHT-mz3bp]

Hello Data Tutorials, I wanted to know why you wrote that cm_sales. Isn't this also the right DAX formula? DAX Cm_sales = CALCULATE(TOTALMTD([Total Sales], Date_table[Date])) It is providing the same results.And as i know that every thing which is in dashboard is interlinked so why the cm_sales ?

[@VINODkumar-gz8tt]

worth it 😍🙂 can you please share data modeling link

[@datatutorials1]

Check description

[@mohduvaissaleem1921]

Hello Sir, DSA padhna important hai data science ya Analyst field mein?

[@VINODkumar-gz8tt]

Hello , as given assignment in project is this correct way or any changes needed MOM Change = IF ( ISBLANK ( [Previous Month Sales] ), "No sales in previous month", [Total Sales] - [Previous Month Sales] )

[@lokeshmoolya5569]

MoM_Growth & Difference_Sales = VAR month_difference=[Current_Month_Sales]-[Previous_Month_Sales] VAR mom=([Current_Month_Sales]-[Previous_Month_Sales])/[Previous_Month_Sales] VAR _sign=IF(month_difference > 0,"+", "") VAR _signtrend=IF(month_difference > 0,"▲","▼") RETURN IF(ISBLANK([Previous_Month_Sales])||[Previous_Month_Sales]=0,"No Previous Sales", _signtrend & " " & _sign & FORMAT(mom,"#0.0%" & " | " &_sign & FORMAT(month_difference/1000, "0.0K")) & " " & "vs LM") I tried this one and this is working

[@anshugangwar5442]

Can anyone plzz tell me how we solve the error while data importing....Because it doesn't responded anything right now

[@vibithas87]

Can I get Requirement of document and Data sheet for practice

[@puneethmadakari1220]

Not able to dowload the data

[@shubhamjoshi449]

Sir can you please provide link of 1st part ?

[@kishan0705]

Please someone reply this : In my bar chart, When i place Label for Store Location above each bars , at placeholders, I can not see it , it doesn't appear above each bars , what i can do here??????

[@anishdutta1758]

Same thing happened for me, any solution you got.

[@sathyamanikantabk4483]

2:07:20 ASSIGNMENT MoM Growth & Diff Sales = VAR month_diff = [1CM Sales] - [1PM Sales] VAR mom = IF(NOT(ISBLANK([1PM Sales]) && [1PM Sales] 0), month_diff / [1PM Sales], BLANK()) VAR _sign = IF(month_diff > 0, "+", "") VAR _sign_trend = IF(month_diff > 0, "▲", "▼") RETURN IF( ISBLANK([1PM Sales]) || [1PM Sales] = 0, "No Previous sales", _sign_trend & " " & _sign & FORMAT(mom, "#0.0%") & " | " & _sign & FORMAT(month_diff / 1000, "0.0K") & " vs LM" ) PS: change accordingly for Mom Orders and Quantities 😊

[@genie68]

2:38:31

[@sumanroychowdhury4014]

❤

[@ruchithtalanki4543]

sir the website to buy meterials realted to data analysis is not working is there any alternative way to get the materials

[@datatutorials1]

Its under maintenance, please try in morning

[@SanketWade-z5s]

hey my tooltip not work while on tooltip but can't get page option to select i have only page auto wht i do?

[@datatutorials1]

Thats not possible, if you are using updated version it should be there.

[@SanketWade-z5s]

@@datatutorials1 i made a mistake while creating the tooltip it's my fault thanks for the content

[@josefsedlacek2439]

I don't understand this: Why we did these SQL queries in previous video? Because there is no use for them, or am I wrong ? Everything for dashboard is done in PowerQuery and DAX. Or can I somehow use these queries ?

[@datatutorials1]

You did not watch the complete part 1 , i have answered this in part 1 video. Please watch again to know.

[@kishan0705]

It was just for cross checking with real SQL data with power bi findings

[@vineetkhairwal7149]

1:33:18 it shows .. the syntax for ')' is incorrect

[@datatutorials1]

For you or in video?

[@bolajiadedasola6369]

Less is better but it’s cool though

[@faisalirshad9403]

which PowerBI version are you using? I don't seem to have much of the formatting options in my version of PowerBI

[@Sumankumari-hw9qb]

same here if you get the solution please reply

[@datatutorials1]

@Sumankumari-hw9qb latest version June 2024

[@Sumankumari-hw9qb]

@@datatutorials1 Thank you for your project video

[@faisalirshad9403]

@@Sumankumari-hw9qb i dont think it is due to just the latest version but perhaps the difference is due to free and purchased version

[@beingrishi6450]

Is this all in one or part 3 will come as well?

[@datatutorials1]

This is last bro

[@beingrishi6450]

@@datatutorials1 Ok

[@nagarajupullur6489]

telegram link ....

[@kulkarnisoham]

Starting with the video

[@mdwamik409]

Can I direct start from part 2 ?

[@datatutorials1]

Yes you can

[@mdwamik409]

@@datatutorials1 brother there is last question can u make Microsoft SQL basic to advanced because there is no such good video on yotube for Microsoft SQL server and your all videos in mostly use tool is Microsoft SQL ??

[@bolajiadedasola6369]

Too much information makes it difficult

[@mohammadfurquan241]

📌PLEASE PROVIDE HOW TO MENTION THIS PROJECT IN RESUME WITH DESCRIPTION AND BULLET POINTS. Please Reply

[@revalladhanunjay8690]

I am also waiting for that only....if U know any method....please share me

[@MadVocalVibes]

Did you get something to write? Help..

[@mohammadfurquan241]

@@MadVocalVibes no, not yet

[@s.s616]

My friend, explain me something. i'm learning from your channel, but how a begginers can create by himself this dax formula? MoM Growth & Difference Sales = VAR month_diff = [CM Sales] - [PM Sales] VAR mom = DIVIDE([CM Sales] - [PM Sales], [PM Sales]) VAR _sign = IF(month_diff > 0, "+", " ") VAR _sign_trend = IF(month_diff > 0, "▲", "▼") RETURN _sign_trend & " " & _sign & FORMAT(mom, "#0.0%") & " | " & _sign & FORMAT(month_diff / 1000, "0.0K") & " vs LM" 1) Just explain me how, because it's very hard to understand. are you using chatgpt? for example if a company asks you for this specific measure, you take in advange usign chatgpt or you create this formula by yourself without help?? 2) all the case study that you're publishing in your channel they could be considerated as real case or not? Thanks for your work.

[@datatutorials1]

First of all these are projects with data available on kaggle or any other website. The requirements are created by myself based on my 10+ years of experience in this field. When you create requirements and based on that you create these logic, and I have not used chat gpt. I have gained enough experience in DAX that I can create these set of logics by myself. In realtime requirements and data come from clients, which are somewhat similar as these.

[@s.s616]

@@datatutorials1 I KNOW, but i don't have your experience, how can i work for a company if i don't have this padronance with dax?? i do practice every day, but i don't have much confidence with dax, you know what i mean? i can use chat gpt for learning fast? whatsapp the big advice for a begginners like me? thanks a lot, you're the best.

[@datatutorials1]

@s.s616 you have to work on such projects, create your own reports. Practice will only make u perfect. Even I didn’t had much knowledge when I started to work in this field. You have to work on multiple scenarios. Building and practising 2 or 3 projects won’t get u to this level of understanding. Work as much as you can on such projects, then and then u will gain knowledge and confidence.

[@s.s616]

@@datatutorials1 if I follow all your project's tutorial, I will able in some moth to understand a lot? Just to have the necessary skills to send a CV to some companies. What do you think?