MY SQL + Power BI Complete Project | End to End Power BI Project | Power BI tutorial | Part 1 | SQL

#powerbi #mysql #dataanalytics
MY SQL + Power BI Complete Project | End to End Power BI Project | Power BI tutorial | Sql Tutorial

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
Intro 00:00
Project Overview 02:00
MS SQL Overview 08:09
Business Requirements 14:18
Data Walkthrough 28:22
Creating Database in My SQL 34:45
Preparing Files for Import 36:42
Import Data in My SQL DB 38:33
Data Cleaning in MY SQL 43:30
Total Sales Analysis 56:26
Total Orders Analysis 01:10:59
Total Quantity Sold Analysis 01:16:21
Calendar Heat Map 01:21:35
Sales Analysis by Weekdays and Weekends 01:29:31
Sales Analysis by Store Location 01:36:07
Daily Sales Analysis with Average Line 01:40:00
Sales Analysis by Product Category 01:55:08
Top 10 Products by Sales 01:57:36
Sales Analysis by Days and Hours 02:01:19
Documenting the Project 02:14:08
Outro 20:15:20
➖➖➖➖➖➖➖➖➖➖➖➖➖
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

[AtulKumar-lj]

i was facing issue while updating the transaction_date to date but then i used this query:-
SET SQL_SAFE_UPDATES = 0;

UPDATE sales
SET transaction_date = STR_TO_DATE(transaction_date, '%d-%m-%Y');

SET SQL_SAFE_UPDATES = 1;
and it went perfectly and format was changed to date forat after altering the table.

[alexrosen]

There are a lot of SQL courses out there but nothing like this because SQL codes are used in real life/project based forum which makes it more clear on how you can benefit from SQL codes. The documentation makes it even more understandable and you can connect the dots in a much easier way. More project like this please 🙏

[navyakatakam]

It was an excellent explanation of every requirement with Mysql and Powerbi. It helps a lot for practicing and learning more. Thank you! Please also do a video on the most essential useable DAX queries and Snowflake. It will be helpful again.

[ajithmathew]

Sir, pls do a video on complete dax tutorial as early as possible

[meghalohar]

Really appreciate your hard work ..helpful video

[shubhabratadey]

I have the following questions:

1. In this scenario we are manually importing a file in SQL and then will get this data in PBI to show various KPIs. What if I could have used Excel files hosted on SharePoints and do the same? It would become dynamic without manual interventions. I would be able to import multiple files then based on my criteria.

2. Is it possible to auto import files in SQL Tables along with file names which'll make our imported data dynamic and will allow the user to play around?

3. Is it possible to automatically delete certain imported data portions. E.g - Lets say I would only like to keep data for the last 30 days and remove the rest from SQL table.

4. Can we use Power Automate to answer my above queries?

I would certainly wait or your next video if all or any of them can be addressed. Thanks for this wonderful video.

[sathyamanikantabk]

ONE MORE SUGGESTION

NEXT TIME PLEASE use Snowflake to load the data and teach because it took me more than hour to load the data in MYSQL(i use 16gb ram latest laptop)
but where as in SNowfalke it took me just 5 seconds to load the data and now I was good to

[tariqhussain]

Good noon, you have nice way to explain, and waiting for the part 2

[vamshikrishnareddy]

thank you so much brother, I have wasted alot of time that how to change date format but now I learned through this, before tried alot of videos, chat gpt, googling etc but I forgot "Y" instead "y" used🥵

[VINODkumar-gztt]

Thanks for new project, time to learn advance dax

[beingrishi]

Im very lucky to get this channel, exceptional video covering power bi sql and excel

[ruchikarajvansh]

For Last question we can use this also right ? Its giving same output

select dayname(transaction_date) as names_of_days, round(sum(transaction_qty * unit_price), 0) as total_sales
from coffee_shop
where month(transaction_date) =5
group by dayname(transaction_date);

[sathyamanikantabk]

2:10:58

INSTEAD OF WRITING OR COPYING EVERYTHING into group by statement

U can just say 1 (i.e., in select statement i have written the case statement in 1st place so IN GROUP BY MENTION 1 )
to make the query look readable and easy

[TheSudp]

Sir, Can you do a video on Power App as well and show how the data can be connected through it with our Power Bi desktop version.

[kishan]

Can someone please let me know what are the other steps to import the data into mysql, it's taking crazy amount of time like seriously 😳, There should be some alternative ways to wrap thi process up in few minutes.

Help if someone knows.

[sathyamanikantabk]

for me its taking more than 1 hour to load the data into Mysql and why

[gstinge]

Thanks for making this video really helped me to revise me sql concept, keep postting

[kota.]

Great video waiting for part2 plz upload as soon as possible

[SagarsDataJourney]

Thanks for this amazing project. Learned a lot of things

[rahulttripathi]

ETL have been common prerequisite in all data science jobs