End-To-End Power BI Dashboard Tutorial for everyone | Data Storytelling in 2023 | Data Visualization

▶ Dataset & PBIX file

▶ Evaluate yourself if you can become a successful Business Analyst.

▶ Steps Covered in this Project:
1. Connecting Database with Power BI Desktop. (From CSV file)
2. Creating custom & Calculated columns in the sales table
3. Creating the DATE table
4. Analyzing the tables and relationships
5. Data Cleaning using Power Query Editor with DAX (Data Analysis Expressions).
6. Developing an Interactive Power BI Dashboard / Report.

▶ After watching this video, you will know:
1. How to create Power BI reports in 2023
2. Various PowerBI Concepts
3. Data modelling in the BI tool
4. End-to-end Project in Power BI

▶ TIMESTAMPS:

00:30 Dashboard Overview
02:42 Five Power BI Stages
03:55 Import the Data
06:25 Fact Table vs Dimension Table (Masters)
07:18 Calculated Columns (Using Joins)
12:10 Understanding the datatypes issue
13:40 Working on Power Query Editor
16:45 Create a DATE table
25:40 Total Sales (DAX)
26:40 YTD Sales (DAX)
27:50 LY YTD Sales (Last Year Year-till Date Sales)
29:16 MTD Sales (Month-till Date)
29:50 LY MTD Sales
32:20 YTD Percentage Growth
35:00 Working on the Dashboard
01:03:10 RESET Button (Using Bookmark)
01:05:00 Summary of the steps
01:06:00 Pro Tip for Power BI Users

📁 Data Analyst Resume:
================
Data Analyst Resume with No Work Experience | Step by Step Guide | Templates + Tips + Examples

🛑Data Analyst Journey:
=====================
How I would Study Data Analytics in 2023 (If I had to start over) | Schedule | Salaries | Skill Set?

Timetable And Efficient Strategy to Learn Data Analytics while Working | Improve Productivity

💡 LEARN MORE
========================

💡 LET'S TALK
========================
☮Any specific query? Want to get an Interview ready? Ask me anything!

▶ Data Visualization using Power BI in 2023
▶Data Storytelling in Power BI using various graphs
▶Generate insights from the raw data

#powerbi #powerbitutorial

[kavitadasari]

Because of ur video i prepared a dashboard, and this video ultimate to learn more content on bi, thank you so much for making this video

[mrtharunprao]

Thank you sir... Will be waiting for a Healthcare Or medical related project.. 😁

[jyotsnasarode]

Thanks for such projects it will be very helpful for learners. Please share the same data set which was used in video to explain

[ojjdata_analyst]

This is a very detailed lecture, please i want to know how you create the filters under Toy Financial Year, Month Year, Product category, product name, store Name, Store location and Store City. Thank you

[ashishchitra]

Hello sir,
I need your quick suggestion on which country (between UK & Ireland) to choose for MS in Business Analytics. Ireland has all the MNCs headquarter but it is hard to get rented house there. UK is moving to recession and we never know what will be scenario in 2024. Please suggest me with quick comment or a video for those who is planning for Sep 2023 intake.

Thanks & Support you

[anshulverma]

Thank you so much sir for the knowledge you are sharing with us it is really helpful. Could you please make a report or dashboard on which more KPIs are used as I want to understand about the KPIs from basic to advance level.

[gauravrajpal]

If Default is selected as FY 2122 in reset we saw (Blank) in LY YTD sales KPI card how to handle it or set to 0 please could you let me know ?

[avirajankitjain]

Dashboard and explanation is very good but sound quality not perfect.

[ahmetcanerus]

Why shared sales data for 2017-2018 ? the training is with 2020-2021 etc...Can you check your sales dataset via link ?

[darshanchaudhari]

Bro i got one easy solution for that month sort problem
.1 create month column by using month dax function we will get output as 1
2.sort month year column on the basis of month column that we have created

[aishwaryapattnaik]

Nice illustration but the dataset shown here and dataset provided are totally different😪

[Florianengineering]

when i change the data type into fixed decimal, the 9.99 suddenly become 999, all is messed and no way to continue

[Ramesh]

Hi, what may be the reason that the start of the year column showing three date i.e 01-01-2017, 01-04-2017, 01-04-2017 for the data set shared by you in the description.

I have used below formula for creating new column in date table Start of year = STARTOFYEAR('Date Master'[Date], "31/3") .

(Date master is the new table in which date is the column created using the formula Date Master = CALENDAR(MIN(sales[Date]), Max(sales[Date])) .

[kunal]

I have one question like why we didn't user quater function to calculate the the quarter??

[becbagalkot]

The Calculated columns which you created in fact table will lead to poor performance. Can create measures instead.

[suhasvlogs]

Can you please do video on retail domain

[darshanchaudhari]

Please add data cleaning also In your videos

[kavitadasari]

YTD growth % measure, why you add 0 in the dax formulae

[sudhirjoshi]

Please upload Power BI dashboard of Ipl Data to understand everything

[samirhajiyev]

date starts from 01/01/2017 on the file you shared.