Power BI Project End to End | Dashboard | Beginners | Power BI Tutorial 2023
#powerbi #dataanalytics #powerbitutorial
Power BI Project Start to End | Power BI Dashboard | For Beginners | Power BI Tutorial for 2023
⭐Download data and Files: drive.google.com/drive/folder...
📱Book a 1:1 Call with me (Career Guidance, Mock Interviews, Resume Review, etc.) - topmate.io/data_tutorials
📱For Important Data Analyst Materials and Other Resources - topmate.io/data_tutorials
📱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.
⭐Data Analyst Material available at very minimal cost of Rs. 999. This will include a complete Data Analyst Syllabus with video links, important pdf's, Q&A, this will also include Complete project on Excel (2 Projects), Tableau (2 Projects) and Power BI (1 Project). And the projects will be different from that uploaded on You Tube. If you are interested to buy contact me on my mail or WhatsApp.
For More info watch this Data Analyst Roadmap 2.0 video - • Data Analyst Roadmap 2...
Details mentioned below-
email- swapnjeet555@gmail.com
WhatsApp - +91 9579005495
Do you want to become a Data Analyst or learn data analytics ? This channel is all about learning data science skills, tips and projects. My goal is to help you learn everything you need to start or switch your career into data science. I teach different Data Analyst tools like Tableau Desktop, Power BI, Excel, Advanced Excel, SQL, Postgres, python, etc.
➖➖➖➖➖➖➖➖➖➖➖➖➖
⭐Content
00:00 Dashboard Overview
03:16 Steps in Project
05:14 Requirement Gathering/ Business Problem
08:23 Stakeholders of Project
10:23 Power BI Functionalities
12:46 Data Source Overview
15:15 Connecting to Data Source
20:11 Data Cleaning
24:58 Data Processing
36:37 Data Modelling
44:13 Background Design in Power Point
48:21 Data Visualization and Dashboard Build
01:45:26 Interactive Action Filter
01:48:38 Slicers/ Filters
01:54:50 Export/ Publish Dashboard
01:55:34 Outro
➖➖➖➖➖➖➖➖➖➖➖➖➖
⭐Power BI Topics Covered
- What is Power BI
- How to install Power BI Desktop
- Import data in Power BI
- Data Cleaning in Power BI
- Data Modelling in Power BI
- Power Query Editor
- DAX in Power BI
- Measures and Calculations in Power BI
- Charts in Power BI
- Filters and Slicers in Power BI
- Dashboard in Power BI
- Insights from Dashboard
➖➖➖➖➖➖➖➖➖➖➖➖➖
Checkout my other videos on dashboards design in Tableau, Power BI and Excel below-
⭐Tableau Dashboard-
Road Accident Dashboard - • Tableau Dashboard from...
Sales Overview Dashboard - • Tableau Dashboard from...
HR Dashboard - • Tableau Dashboard from...
Ecommerce Sales Dashboard - • Build Tableau Dashboar...
IPL Dashboard - • Tableau Dashboard | IP...
Cust omer Complaint Dashboard - • Tableau Dashboard | Cu...
⭐Power BI Dashboard
HR Dashboard - • Power BI Dashboard fro...
⭐Excel Dashboard
Road Accident - • Full Project in Excel ...
HR Dashboard - • Excel Dashboard from s...
IPL Dashboard - • Excel Dashboard (Hindi...
Ecommerce Sales Analysis - • Dynamic Excel Dashboar...
➖➖➖➖➖➖➖➖➖➖➖➖➖
⭐Tableau Material available-
1. Tableau hand written notes
2. Tableau printed notes
2. Tableau important formulae print notes
3. Tableau important interview questionnaire
All these are available at very minimal cost of Rs.200 only, ping me on WhatsApp to get these.
➖➖➖➖➖➖➖➖➖➖➖➖➖
Reach out to me for any personal or Business related Dashboard/ Report development on my email- swapnjeet555@gmail.com
WhatsApp - +91 9579005495
➖➖➖➖➖➖➖➖➖➖➖➖➖
Related Keywords -
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, PowerBI Data Visualization, Power BI Data Analytics, Power BI Analysis, PowerBI Report and Dashboard Design, Power BI End to End Tutorial, PowerBI End to End Project, PowerBI Data Modeling, What is PowerBI, How to use PowerBI, Power BI Tutorial for Beginners - Basics and Beyond, Power BI Tutorial for Beginners - Getting Started, Analyze & Visualize Data with Power BI
Disclaimer: All opinions or statements in this video are my own and do not reflect the opinion of the company I work for or have ever worked for.
Data used in the video is a demo data, modified data and does not belong to any real time industry/ company/ government etc. Data used is only for practice purpose.
Пікірлер: 208
its amazing .we highly required these kind of projects . I request all viewers to share this video as much as possible .
Done Tableau, then Excel now starting Power BI. Thank You !!
Thank you very much for making this video! I made my first Power Bi Dashboard and I am planning to create a different one for my class project!!
i love that it is really detailed, and you took the time to explain.. Awesome stuff
@datatutorials1
Жыл бұрын
Glad you liked it ✨
Cool Dashboard 🤩 Thanks for sharing the knowledge bro Appreciate your work.👍
Thanks For sharing
Excellent work! you are really good. Thank you so much!
Beautifully explained, definitely the best end-to-end tutorial I have seen! Really love how you covered every step in great detail and went through the project background and stakeholders to begin with which added an interesting user experience element to the project. Really helped me with my first Power BI project 🙂
@datatutorials1
8 ай бұрын
Glad it was helpful!
This video has a wealth of useful, helpful information. Thanks for everything you do!
@datatutorials1
Жыл бұрын
Thanks for your support ✨
Great learning!
Thank you for the detailed video
Hello mate thank you so much for your effort! It means a lot and as a student I learned a lot from you. Just a little advice if I may, the sound of the video wasn't very clear. Might need to use a solild desktop mic man. :)
You Made a Good Knowledge able video
Very helpful ❤️❤️❤️❤️🙏🙏🙏🙏thank you very much.
Thank you so much👍
Great Video. Do add more such PBI videos and help us learn more about challenging projects. Appreciate your effort.
@datatutorials1
Жыл бұрын
Sure
thanks i got many ideas for my final project
Thanks
Thankyou so much sir bcz of this video my many doubt is clear and learned many new things..thanks a lot... your effort is appreciated
Great video and very well explained.Will add it to my project portfolio.
@datatutorials1
Жыл бұрын
Sure
Great video, so amazing to watch your video
Thankyou so much ❤Great video it was ..looking for more videos🎉
Great video. Just one slight correction: Casualties cannot be grouped by “fatal”, “slight” and so on. A casualty is a casualty. Those KPIs should be based on Count of Accidents, not Count of Casualties.
@saniarahman1842
10 ай бұрын
Casualty doesn't necessarily mean death. It also means a person injured or hurt. Hence, slight or fatal is correct in this context.
Awesome. Very helpful.
Thank u for perfect video ❤
Just completed it, Thank you so much.. Learned so many things through it. ❤
@datatutorials1
6 ай бұрын
Great job!
@tasneemshaikh5139
6 ай бұрын
How much time u took to complete this project?
@QatarIsmartVlogs
3 ай бұрын
30 min just need
Fantastic sir. 🙏🙏 Very helpful video for cultivating the skills in BI.
@datatutorials1
Жыл бұрын
Glad you liked it ✨
Really superb, Expecting the source as a DB (sql) it would be more helpful , generate a report by using data base pls make a video upon it
@datatutorials1
Жыл бұрын
Sure
You are just too good sir . Such awesome content from your side always . Thank you so much for all the efforts 🙂
@datatutorials1
Жыл бұрын
Thanks for watching, keep supporting 🙂
@maheshbhortakke896
Жыл бұрын
Nice to see ur prompt support. Great Work Brother.
Great job
This is the best channel for Power Bi tutorials... Thank you loved the video😊❤
@datatutorials1
Жыл бұрын
Wow, thank you!
So beautiful, so elegant, just looking like a WOW
manyyy thanxxx
it heped me lot actually
Really really I'm happy for these kind of help. I would like to join as an developer or analyst for that I spent 10K to an institute where they taught only limited feauters, but when I saw this video I'm completely happy bcz Iearnt something
@datatutorials1
Жыл бұрын
Thanks for the comment 🙂
Your way of teaching is excellent sir...we can understand the concept easily and my suggestion is take the more row data then only we can use all types of tools...thank you so much sir
@shivamshukla3448
23 күн бұрын
kzread.info/dash/bejne/ZYZrx9WhhaXOlrw.html
Thankyou a lot for the amazing video. Really helpful.
@datatutorials1
Жыл бұрын
Glad you like it ✨
Thanks for this effort. waiting for some more similar practice. 👌
@datatutorials1
Жыл бұрын
Sure
Thanks for a Wonderful video . I Learnt new feature i.e. Group
@datatutorials1
Жыл бұрын
Glad you liked 🙂
thanks, it is a great one
@datatutorials1
Жыл бұрын
Glad you liked it ✨
Excellent video helped to get a understanding of how to use Power BI correctly
@datatutorials1
6 ай бұрын
Glad it was helpful!
Sir , Kindly upload the video on Google Data Studio. Please.
Thank you so much
@datatutorials1
Жыл бұрын
Glad you liked it ✨
Amazing Content!!!!
@datatutorials1
Жыл бұрын
Glad you liked it ✨
Thank you for explaining in detail.
@datatutorials1
Жыл бұрын
Glad you liked 🙂
It was great learning from you sir
@datatutorials1
Жыл бұрын
Glad you liked it ✨
Good evening, and really amazing video and explanation is very nice and i completed it and learn good things
@datatutorials1
2 ай бұрын
Glad to hear that
Thanks first of all, To be honest you are such a great man as well as great teacher, I really cherish you Sir, today I learnt a lot in your Video thanks again, I don't have a word what I say for your appreciation.
@datatutorials1
7 ай бұрын
Thanks for your kind words 😊
Very nice and educative. Followed from start to end. But I'm having issues understanding this TotalYTD function, if it's actually to calculate the current year, we are in 2023, which is the current year, while is it calculating 2022?
God bless you bro
@datatutorials1
Жыл бұрын
Thanks for the motivation 🙂 Glad you liked it ✨
well Explained
@datatutorials1
Жыл бұрын
Thanks, keep supporting 🙂
Amazing teaching yr
@datatutorials1
Жыл бұрын
Thanks a lot 😊
super
@datatutorials1
Жыл бұрын
Glad you liked it ✨
Thank you for the awesome content
@datatutorials1
Жыл бұрын
Glad you liked it ✨🙂
Sir i practiced this project..how can i describe this project in my resume .will u pls write the description
Quick question, I’m curious as to why you used to the Number of Casualties Provided as opposed to the new measure of CY Casualties we created.
finished practicing
Great Dashboad and Insights. I was trying to change the % change with conditional formatting to appear values >=0 as red and values less than < as green with Rule but not happening somehow?
Thanks for sharing. Rebuild it. Can you make a video with a use case using drill down (up, through) ?
@datatutorials1
Жыл бұрын
Thanks for watching, sure will try the drill through function
Please make a video in which you are importing data from a Database for example importing from {Postgresql} and then making a dashboard or a report on it.
@datatutorials1
Жыл бұрын
The next video will contain connection to Postgres SQL, multiple tables join
finished watching
Amazing Video....
@datatutorials1
Жыл бұрын
Thank you so much 😀
hello sir, you explain very well. But at the time of data cleaning process there is some null value in " Road_surface_Condition" and "weather condition" so what I can do for this. can I remove those null value or replace with other road surface condition.
@Data Tutorials do you have PowerBI notes also as Tableau?
1534 rows contain blank values in road_type column and around 3000+ values contain blank values in weather condition column and still some column have blank values which didn't consider while data cleaning in this video. Can anyone explain??
1 video related for construction workplace
Great video.. thank you much for this wonderful learning. I have created the same dashboard can I upload this on Linkedin ?
@datatutorials1
Жыл бұрын
Sure
While loading the background to power bi. My all boxes in the background image is not visible. I tried even converting the image to 16:9 and then loading it again.
You can use the First date and last date functions while making a calender.
@datatutorials1
Жыл бұрын
Definitely, there are different approaches to do the date table
Great job, I have a challenge. I tried to replace the "fetal" with fatal but it is not replacing what should I do. I can further the work without the correction
@gmedia1800
11 ай бұрын
put exact case, if there is " F " is capital in "Fetal" then put in capital word .
Sir can you take coaching???
Finished watching
@kulkarnisoham
2 ай бұрын
Should I try it ? Is it worth it ?
bro make sales dashboard using power bi
Sir where we use programing language like python and R library numpy and pandas and matplotlib How we create this type of project please make a videos
Hi, can you give a brief explanation on why we have to create a new table for date? Thank you
@datatutorials1
Жыл бұрын
If you need to use time intelligence functions like total ytd, same period last year, it is recommended to create a date table to get accurate results
My only problem is the last map visualizations , I am getting an error and the map is not displaying....any help? I have put the latitude and set the longitude both to average and the legend too...but not displaying
In real time we bring data from SQL database then how edit that data?
Sir I wanted to make my career in data analyst so can we master any one Business intellegence tool like powerBi or we have to do tableau also and which one companis look for.....Thank you sir with help of your videos i created two powerbi project❤
@datatutorials1
Жыл бұрын
Hello, as per current market conditions one should know both power BI and Tableau. Also SQL and an ETL tool is a must.
How to create measure sir , bcoz my cy casualties is not working and create measure part is skipped
To calculate the PY accident, the syntax is incorrect, i need hlep to navigate this part
please provide link for background creation
Sir , what is impact of this project could you explain it ?
When I extract the file to the PDF, it became a mess. The format was all out. Any idea what happened? :(
I iam not able to create month column using same command.It's showing error (cannot find table 'mmm'
hello, do you have a video explainig how to do the background on powerpoint if i want another diferent strucutre
@datatutorials1
Жыл бұрын
Yes, the video is available on my channel
sir after load the data the date format of accident date column name was chnaged
why my number seems different from yours after taking ytd calculation
Particular, with respect to,,,ok,, 30:39 right
Can u make extensive data Cleaning video on a super messy dataset
@datatutorials1
Жыл бұрын
Surely in next video
what is a current year
Pls I am watching your video, I need the the link to download load this dataset for my practice. Am.a.begginer in data analysis. Don't forget I need more dataset to work on. Thanks
@datatutorials1
Жыл бұрын
Link available in description of this video
Hello sir, for CY Casualties, I have tried taking the sum of no. of casualties instead of using the TotalYTD function. Can you please explain what is the difference between both the methods and why am I getting different results?
@datatutorials1
Жыл бұрын
Hi, if you directly use the sum of casualties in the viz, it will show the correct value if we have a date filter in the dashboard. But if the date filter isn't in the dashboard. This method can be used. But if you are specifically asked to find CY i.e YTD casualties you must use the time intelligence function i.e totalytd
@ruhiscorner7318
Жыл бұрын
@@datatutorials1 So basically the TotalYTD is calculating the sum of no. Of casualties only for the year 2022 and not for 2021 right?
@datatutorials1
Жыл бұрын
Correct
@ruhiscorner7318
Жыл бұрын
@@datatutorials1 Got it, thanks
Please explain why do you have to divide PY casualties, after subtracting CY casualties from PY casualties to get result for YOY casualties. ([CY casualties] - [PY casualties])/[PY casualties] = YOY casualties. Many thanks in advance
@datatutorials1
Жыл бұрын
It the formula to calculate year on year growth
@ajibolaadekunle4884
Жыл бұрын
@@datatutorials1 thanks so much. I really appreciate your unflinching effort.
"CY ACCIDENTS COUNT" not showing measure
Sir, can you help me how to collect or where to find datasets like yours. Many thanks.
@datatutorials1
Жыл бұрын
Kaggle website
can i ask what exactly your comand in month nw 4x noted
Last map chart not working 😢how does it work
Connecting to models shows error
how to remove copyright information thats is appearing with map visual --@2023tom tom microsoft corporation etc. its unwanted information. please help
25:00