Power BI & SQL Project | Data Analyst Portfolio | End to End | Beginner to Expert |

[@VincentBjuremark]

Thank you for this video, you took your time and effort into putting this video together - step by step - so that we all could follow along. The quality of this content is something that I and probably many others would pay a considerable amount of money to be able to benefit from, and yet you did it for free! Thanks again!

[@sumijasukumaran1394]

This project looks like real time .This makes as understand how SQL and power bi works together. Please upload python ,power bi project

[@shahnawazatharkazmi2826]

Dear sir same question in my mind, what is the role of python in data analyst. Bcoz powerbi already have power query editor to cleaning data then role of python plz guide us

[@Freakouts_and_found_Insane]

@@shahnawazatharkazmi2826 here data we get clear format but most of time data we get in multiple sources in different format their python is used in which numpy and pandas library are useful

[@thanhien3282]

I think so 🤔

[@sasacademy4761]

@@shahnawazatharkazmi2826 AA vP by by by by by by by Dr ko CT CT CT

[@drbh6331]

​​@@shahnawazatharkazmi2826first of all python had less role in data analysis its more towards data science and data engineering

[@shahnawazatharkazmi2826]

One of the best project for power bi available on youtube

[@datatutorials1]

Glad you think so!

[@TiamiyuAjibola]

I'm really grateful for the immense knowledge I've gathered from you. Within 2 months I've designed 3 completely interactive dashboard with you. . 2: Please, try and always include data dictionary of each dataset for those of us that are documenting. I've documented the Ecommerce, HR and working on this pixza dataset. Thanks once again

[@terihandrick2333]

I know I am seeing your video late but wanted to thank you so much for taking all the time it took to make this video for everyone and walk step by step through your process. So very kind of you to help those of us trying to master the whole PBI project/process.

[@nilosamson5982]

I can't pay for some paid tutorials but watching this is more than enough for me to learn a lot in one video. as a way of me thanking you. I didn't skip every advertisement. I finished every ads without skipping and hoping you get paid on it. Thank you very much

[@er.sarthaksananse1704]

One of the best KZbin channel for all Aspiring Data Analyst 😊

[@haseebahmed9953]

Your dedication to sharing expertise is commendable, and your video significantly contributed to my learning journey in BI. Thank you for your valuable contribution; I look forward to exploring more of your content.

[@SamuelOlujide]

I want to appreciate you for the time spent and dedication to this work to instill the basic requirements and the needful things to know as a data analyst. I would love you to make a video on how to display our dashboard on our web page, Please.

[@AnilKumarNyatha-l8o]

Thank you so much! Your explanation is clear and easy to understand. Anyone looking to learn Power BI from beginner to end, this is the best practice. Thanks again!!

[@omotayocrownwealth4745]

I'm amazed by how proficiently you demonstrated the use of both SQL and Power BI in a single project (start to finish).Your approach makes it easy to comprehend and practicalise, yet simple to follow, even for an average user. I am happy to have encountered your work. Thank you for sharing your expertise!

[@datatutorials1]

Thabks

[@athanaaa9846]

Very good explanations and thanks you man for share your knowledge to us without any expectations ❤❤❤❤❤

[@RK-hg4ti]

At 1:20:14 select "match entire cell contents" option in advanced options. It will helps to reduce iterations.

[@fswarsi]

Incredibly insightful video on KZbin of end to end project of Data analysis.

[@InsightswithArselane]

Just wanted to take a minute to say a huge THANK YOU for all the amazing content you create! Your videos have been so helpful in my learning journey, and I'm seriously grateful for your willingness to share your knowledge with the world.

[@raymondbarnes5264]

Absolutely amazing video, I have finally realised that as a beginner in the financial investment market, you can achieve close to nothing yourself because you still have a lot to learn. Trading with a professional broker is more profitable and my advice for beginners is to always take advantage of that.

[@greenquake11931]

Instead of timing the market, you should try to diversify your portfolio in order to get a dollar-cost average when it’s time to retire. Keep in mind that you don't need a ton of money to invest. Investing in small amounts can build long-term wealth too!

[@stellamoore720]

I'm an amateur making terrible picks and I really need assistance.

[@mayacho4910]

Trading is Profitable with the help of a seasoned broker managing your trading account.

[@raymondbarnes5264]

@@stellamoore720 'BRIDGET MARY TUROW"".

[@stellamoore720]

@@raymondbarnes5264 How can i reach her?.

[@girishchavan1245]

Thank you so much Sir , I have done several dashboard by watching others tutorial. I personally felt this is the best . That too for free . I have learnt so many things.

[@datatutorials1]

Glad it helped

[@swarupasahu700]

Beautifully explained each and every concept. As I am new to power BI ,it is so helpful for me to understand the end to end process. Great work 👍

[@BrokenButton]

This was great, thank you! One thing I did notice when adding an additional column for the day of the week (on Building the Monthly and Daily trends) is that the data on the excel sheet has a large amount of dates not formatted correctly, or different, and it shows as blank when transforming the data. When making a bar chart with this data, it shows around 29k blank spots for the day.

[@roqibahaderinto1879]

Hii I'm having this same problem Did you manage to solve it?

[@Techbruu_AI]

same problem, did you solve it?

[@cc6796]

The way you explained the concepts from begining to end, made it really easy for us to understand it. Thank you so much for sharing your knowledge and the effort that you put in is commendable.

[@richajainer]

I want to express my heartfelt gratitude for your dedication to sharing knowledge. It's evident that you have invested a lot of time and effort into creating this tutorial, and it has undoubtedly made a significant impact on my learning journey. Thanks to you, I now feel empowered to tackle SQL and Power BI projects confidently.

[@amaansiddique4759]

Definitely I have learnt a lot from this end to end project , plss make a real time project more and more atleast two in a month

[@SYEDKASHIFALY]

sir u r the greatest of all the teacher an step by step process.... Respect Respect and Respect

[@janellegomez4207]

Thank you so much for teaching us how to do this project. The dashboard is beautiful!

[@MD.ANISURRAHMAN-m9k]

Thanks, I have just completed your full tutorials. leaned a lot from your tutorials. Please give us more Power Bi and SQL Related Projects

[@vishalrathore2854]

You are a pro in terms of explaining and providing valuable content to us. I have learned many new and important steps help me to groom myself more widely. Thank you so much for the help.

[@datatutorials1]

Glad it was helpful 💐

[@ishankhanijo4591]

This project walkthrough has been very helpful. Thank you sir!

[@santhuzestvlog7330]

Thank you for sharing your knowledge. I understand you have connected the SQL server to Power BI but you didn't use the queries that you created. I see you have used only DAX functions in your visual then what's the purpose of creating queries in SQL. I just wanted to learn! But very informative session

[@RaviKumar-dc2gy]

1:51:00 for stacked graphs, how to avoid the overlap of data label

[@prratimaakaroshii5525]

Very systematic explanation and easily understandable content. Thanks for such a knowledgable video.

[@swetaswarnkar6927]

I want to express my heartfelt gratitude for your dedication to sharing knowledge..thanku somuch

[@Piku.aka.Priyanka]

Really wanna thank you to explain everything bit by bit ,it was so so helpful.Loved the video and I learned a lot through this video.

[@BignmnShop]

in the comfortable way the lesson is prepared, really helpful.

[@datatutorials1]

Glad it helped you ✨

[@gamers5153]

Best project available on KZbin thank you so much sir

[@kevinndungu4511]

Amazing Amazing this is one the best well walked through project from start to end i have learned a lot keep up the good job!!

[@datatutorials1]

Great to hear!

[@Prabhakaran-hp1to]

Thank you so much for very clean and easy way you explain all from beginning.

[@thakurarvindrasingh7093]

First of all Thanks a lot because your teaching way incredible. I have never seen and watched like this video before. I really appreciate you to do this work, Definitely you are the wonderful personality as we as wonderful human being, I pay to god gives you happiness and prosperity Thanks a trillion again.

[@karthikvijay5626]

bro have you downloaded SQL server managment Studio ?

[@thakurarvindrasingh7093]

@@karthikvijay5626 Yeah Sir

[@karthikvijay5626]

@@thakurarvindrasingh7093 brother could you help me to download ms SQL server & sql server management studio

[@mukamafrancois2776]

Wow, thank you so much for this incredible Power BI tutorial! 🙌 Your explanations are clear, and your step-by-step approach made it so easy for someone like me, who's relatively new to Power BI, to follow along. I've been struggling with some aspects of data visualization, and your video not only clarified those concepts but also gave me the confidence to dive deeper into Power BI. Your dedication to helping others learn is truly admirable. I can see the effort and time you've put into creating this tutorial, and it's greatly appreciated. Please keep up the fantastic work! Looking forward to more of your tutorials. 💪

[@Saviyu_lil_munchy]

Thank you somuch brother , I have done several dashboard by watching others tutorial. I personally felt this is the best . That too for free . I have learnt somany things. This is the first vedio I watched . As you said " I liked , subscribed and commenting ❤👏

[@datatutorials1]

You are most welcome

[@datatutorials1]

Thank you

[@owenonyango7075]

i wish i could like this a thousand times. great work.

[@datatutorials1]

Wow, thank you!

[@govnny]

Hi, thank you for the tutorials. This is my 2nd I am replicating from your channel as practice for interview. I am using mysql as I could not set up the server process for sql mgmt studio. In mysql many functions are either changed or not functioning so i got stuck at DATENAME query at 46:30. Solved this step today with DAYNAME, str_to_date and coalesce, as the order_date column was imported as text by default and the date data is formatted in 2 different ways: d/m/y and d-m-y. if someone is interested, this is the query: SELECT DAYNAME(coalesce( str_to_date(order_date, '%d-%m-%Y'), str_to_date(order_date, '%d/%m/%Y')) ) as Order_day, COUNT(DISTINCT order_id) AS Total_Orders from pizza_sales GROUP BY Order_day ORDER BY Total_Orders DESC

[@mansimahajan388]

thank u so much for ur comment...i have literally been struggling to resolve this issue and tried every possible way to fix it but failed but the code u provided worked perfectly....can u help me with one more thing that if he is using dax functions whts the use of SQL queries.

[@faranbhutta1349]

Beautifully explained each and every concept

[@slycop221]

THE BEST YT CHANNEL FOR PROJECTS

[@InnovationInflux]

A great learning and beautiful visualization. Thanks ! Small suggestion to always create a date & time table and link it to the main table. this will reduce the complexity in main table and would query the results faster.

[@mohammedgamal7509]

I truly appreciate your efforts, thank you for the clear and straightforward explanation. I comprehended everything in the video, and you've contributed to enhancing my skills.

[@abou19850]

Excellent Job, thank you very much for this clear Demo! It would be great if we could have same for Tableau and QLIK. Many thanks for your work sharing.

[@datatutorials1]

Glad it was helpful!

[@LIPIKADHAR-y6b]

Really your Dashboard is so impressive, always try to learn lots of things on Power BI dashboard creating.

[@orangiruth5158]

This is ground breaking, thanks for the dedication 🎉🎉

[@datatutorials1]

Always!

[@rafaelalomoto1595]

The best video i haev found to learn power BI and SQL , Thanks for the time and effort U have invested in this project

[@meraki2090]

This was easy to follow and amazing video on power BI and SQL. Thank you and I learned various functions through this. Thank you again!

[@truemufti]

Great tutorial, I have a lot of queries in power bi but after watching this tutorial I cleared those. Thank you so much.

[@datatutorials1]

Glad it helped

[@piero141980]

Nice video, very informative however I fail to understand why we need to use sql for this exercise. I thought we would use the formulas created at the beginning of the video in SQL while creating the dashboard in powerbi but we didn't do that. I wonder why do we need to go through that exercise instead of uploading a cvs file into powerbi directly and saving time by doing that ?

[@datatutorials1]

Whenever you are asked to build a project or dashboard in any tool you always have to validate your results shown in the dashboard. The results shown in dashboard are garbage in and garbage out, meaning it shows anything you want, how will you and client know the values are correct. It is always a best practice to test the report you build by firing SQL queries to database and validate the reports. This is explained in the video well

[@yogeshpatole9595]

Please make video on how to get job in power bi

[@netishmb761]

1:47:26 i am getting error when adding days column OLE DB or ODBC error: [DataSource.Error] Microsoft SQL: There is insufficient memory available in the buffer pool

[@bhaktikhavle9307]

Thankyou for this video, learnt many new things from just 1 video.👍🏻

[@shashankreddysai]

Best Video for PBI! Great work

[@yamkelamatomane7027]

Hi, I am getting a "input string was not in a correct format. (mscorlib)" How do I fix this, this happens on the final step when I import the flat file

[@koiroi1854]

Hi, I am experiencing the same thing , were you able to resolve this error?

[@khansalim81]

Thank you so much! Your explanation is crispy and clear. Best for anyone looking to learn Power BI from beginner to end. Thanks again!!

[@datatutorials1]

Glad it was helpful!

[@pranavsrivastava6834]

Thank you for this amazing portfolio project which will be truly helpful for mine data analyst journey. I just completed this amazing video, and I must appreciate your time & efforts behind such a great work which shows the real industry experience behind it. Glad to subscribe your channel. Much Appreciated!

[@taisiyakaripidis9828]

Thank you so much for this tutorial! You've done an excellent job teaching queries and PBI!

[@eakubzisan3072]

I have watched full video with patience. It helped me learn some new tricks that can boost my working capacity with data. Thank you so much.

[@uzoamakaogbonna]

You’re such a good teacher

[@heavyvloggers7710]

Excellent explanation,bole toh maaza aagya ❤❤❤❤

[@RxBrooks]

Great work. A slight mistake I noticed was how for the 2nd page, in the worst sellers section, its suppots to written that the Brie Carre Pizza contributes to the minimum Total Orders instead of the "maximum".

[@softskills6]

It is really an excellent tutorial in an easy way, which is very helpful for beginners

[@mathewmburu4920]

Many thanks so much for you time🧑‍🏫🧑‍🏫🧑‍🏫🧑‍🏫🧑‍🏫

[@chanil1950]

I have learned many things from this video. Thank you for sharing.

[@sunithakumari8297]

sir wonderful explaination...hand off for your patience and clear explanation of complete report. even a person how is using power BI for the first time can also understand and practice .....I was expecting dynamic text box in the project....like if we select category showing text box with highlights for the selected tenure or category. If possible can you please help us with dynamic text box.

[@datatutorials1]

I will do it in next project

[@nishujain2443]

thank you....best content ever i watched...waiting for SQL tutorial

[@netishmb761]

1:47:25 when we add up day column I am getting error OLE DB or ODBC error: [DataSource.Error] Microsoft SQL: There is insufficient memory available in the buffer pool can anyone please help regarding this thankyou in advance 😢

[@aywinter6046]

First, thank you for this video which I find very helpful and easy to understand. But, I have one quick question. What if I have new data come in next year lets say 2016. How do I automatically pull in new data and update the KPI to include the 2016? Thank you.

[@ketanshrivastava]

you make it so simple ..... thankyou for making these kind of videos ..........to the point videos .....very systematic.😇

[@manaspattanaik2345]

Thanks But my request is instead of one table use 10 more table so that it is useful. my request is to show dashboard using more table with join option

[@datatutorials1]

Noted! Will try

[@sahilkhanna5640]

Sir pls one project on python so many videos on utube but your explanation is very simple and easy to adopt...

[@datatutorials1]

As soon as possible, thanks

[@akshay-zb4vs]

Thankyou soo much sir. Thankyou for helping us build this amazing Dashboard

[@datatutorials1]

Glad you liked it

[@insanegamer6649]

Boss genuinely acha content banate ho AAP ❤❤

[@ektasingh1314]

Wow what a video….You really cover most of my doubts….thank you so much for making this video

[@mahekgupta-o7r]

This is really informative. Can you also provide the link for ppt or upload it on same folder as of data provided link of drive for the problem statement that u had made

[@dominicatuahene7303]

Hello Sir, this is an amazing project with an awesome BI visualization. I do have a question though. do you have any video on automation of project? for instance how can we connect this SQL commants and the Dashboard to the data source such that whenever there is and additional transaction or change in the data, then the SQL query and the Dasboard can update by refresing it? Thank you for this wanderfull presentation

[@shahidgulzar2062]

server name ?

[@dominicatuahene7303]

@@shahidgulzar2062 MySQL server

[@TAOFEEKABDULMALIK]

Wow, this video is fantastic, good presentation and very explicit. Thank you

[@datatutorials1]

Glad it was helpful!

[@PaulJenniferZigwai]

This work has impacted my data analytical journey. Keep up the good work, Sir. Seeing how excellent the work is, I tried making a replicate but had difficulties in returning the names of the week days and months to answering the chart requirement of 'Daily Trend for Total Orders' & ' Monthly Trend for Total Orders'. Please🙏, what could be the possible solution? I used MYSQL to run the queries. THANK YOU IN ADVANCE!!!

[@datatutorials1]

Did you convert the datatype of date to date format

[@reemazabdull5623]

Best video ever!!!!!! I have learned these two program but I didn't know how to start a project it took 3 hours from me but I really benefited and I will watch your other videos thank you very very much for this work! everything is perfect and clear even that the Word file thank you again. I just hope that you will make a video on how I can determine the KPI so that I can work with dataset and know how to clean it because it was really easy for SQL and visualization when you explained that, and no one has clarified this point. I was always asking how I can find out that columns I need in order to implement the queries.

[@MaansiWakekar]

THANK YOU VERY MUCH for describing it so clearly

[@abdulbasit6334]

I did learn SQL a few days ago but could not find any useful SQL project and luckily ur this project came in front of my eyes. The SQL queries u performed were a mix of beginner and intermediate difficulty and ur power BI skills are really phenomenal. I learnt a lot. Thank you and God Bless!

[@joefla5134]

Which SQL software do you use for this application ? Which do u recommend to download?

[@nutz3594]

this is content really helpfull for me as beginner which who want learn Data Analyst process.. i hope u cant keep update about simillar things coz i will follow ur update for further 👍🙏

[@datatutorials1]

I will try my best, thank you

[@ansariozair8459]

I have a question, as you are using distinct order id while retrieving the average order value, there might be same order id on different date or time. Is it counting that order also? And one more question can we use group by function in this case? If not, why?

[@mohamedlashin4462]

Thank you for this video, but I have a question: what is the use of SQL queries? I feel that we can go directly to Power BI, or is this just for practice?

[@abhishekkunte2482]

Thank You So much. Learning a lot from you

[@datatutorials1]

Glad to hear that!

[@sonalwandhare8039]

Hi please help to run this command in my sql as it is giving me an error for SELECT DATENAME(DW, order_date) AS order_day, COUNT(DISTINCT order_id) AS total_orders FROM pizza_sales GROUP BY DATENAME(DW, order_date) in my sql to run it please help

[@RaviYadav-zi7eb]

alter table pizza_sales modify order_date date SET SQL_SAFE_UPDATES = 0; update pizza_sales set order_date=str_to_date(order_date,"%d-%m-%Y"); select dayname(order_date) as order_day, COUNT(DISTINCT order_id) AS total_orders from pizza_sales GROUP BY dayname(order_date) order by count(distinct order_id)desc

[@rayaneBENAKSAS]

SELECT EXTRACT(DOW FROM order_date) AS order_day FROM pizza_sales;

[@alishachhabra9414]

Many Thanks for such a detailed video

[@datatutorials1]

Glad it was helpful !

[@Datamaventech]

Very well explained! Thanks for sharing such a great content. 😊❤

[@vasanthkumarcroos8605]

Just awesome Thank you so much sir.

[@sreenath2830]

Excellent videos..Quality content.

[@datatutorials1]

Much appreciated!

[@harshvardhandhayapule59]

did you do the project?

[@TugbaKrac]

Çok Faydalı,teşekkürler :) Emeğinize sağlık

[@marcina5284]

@Data Tutorials Can u add img of economic.png into drive google folder coz is missing

[@sharonnwanne5098]

Thank you so much for your incredible work here. It was really amazing. Thank you...

[@Mokshtak]

It's showing me error when i run this query in MySQL Server. if anyone suggest what's wrong into it ? or another query to run. SELECT DATENAME(DW, order_date) AS order_day, COUNT(DISTINCT order_id) AS total_orders FROM pizza_sales GROUP BY DATENAME(DW, order_date)

[@RaviYadav-zi7eb]

alter table pizza_sales modify order_date date SET SQL_SAFE_UPDATES = 0; update pizza_sales set order_date=str_to_date(order_date,"%d-%m-%Y"); select dayname(order_date) as order_day, COUNT(DISTINCT order_id) AS total_orders from pizza_sales GROUP BY dayname(order_date) order by count(distinct order_id)desc

[@R1_Rover]

@@RaviYadav-zi7ebI tried this and it still didn’t work for me

[@RaviYadav-zi7eb]

@@R1_Rover what's the error?

[@siddhantkhairnar7519]

I want to express my heartfelt gratitude for your dedication to sharing knowledge. It's evident that you have invested a lot of time and effort into creating this tutorial, and it has undoubtedly made a significant impact on my learning journey. Thanks to you, I now feel empowered to tackle SQL and Power BI projects confidently.

[@Kishormurade02]

Hey, can you please tell me if interviewer asked question that, what the actual use of SQL in this project, then what should be the expected answer can i give, please let me know, I`m confused in this?

[@nishantnandkeolyar13289]

Absolutely right 😊

[@UtkarshShukla-m8g]

@@Kishormurade02 SQL databases are more suited for handling large volumes of data with complex querying, transformation, and real-time access capabilities, while Excel sheets are useful for smaller datasets, manual analysis, and simpler reporting tasks. The choice between the two depends on the specific requirements of the BI project, including data volume, complexity, collaboration needs, and the desired level of automation and performance.

[@mrbartuss1]

If only in real life it was that easy

[@RajKumar-bl2pk]

Hi, Really appreciate your efforts on this. Could you also add how we deploy this to client or end users. How they access ?

[@kumarsathya250]

Great presentation. I have a question on insight section though. The text in that section is static. What if after a data refresh another pizza/ category/date range becomes best seller . Is there a way we can make it dynamic? like defining best sellers in each section and make Insight section pick those ? I guess that is my home work, will update here if I find any solution.