Adventure Works Bike Shop Dashboard in Power BI | End to End Tutorial | Hindi | Praveen Kumar

Описание: Data: https://drive.google.com/drive/folder...

Topic Covered:
00:00 - Demo of Dashboard
00:15 - Introduction of the Dashboard
03:18 - Explanation of Data Used in the Dashboard
07:23 - Showing the Version of Power BI Desktop
08:00 - Loading the Data into Power BI Desktop
08:45 - Cleaning the Data
11:15 - Appending tables and Verifying the Data Rows
14:30 - Disable the load of table which not needed in power bi desktop
14:14 - Creating New Columns in the Calendar Table using Power Query Editor
17:30 - Data Modelling for the Report (Creating Relationships between the tables)
22:45 - Saving the File
23:28 - Creating a Blank table for measures
24:18 - Creating the Dynamic Nav Bar using Bookmarks having clickable dynamic icons and slicers
39:14 - Adding Logo for the Report
40:16 - Creating Measures and Card Visual of Revenue, Profit, Orders and Return Rate
55:30 - Creating Calculated Column for Line Chart Visual
58:00 - Drill Up/Down and Formatting in Line Chart Visual
01:03:09 - Creating the Bar Chart Visual
01:05:45 - Creating the KPI Card Visuals for Monthly Revenue, Orders and Profit having Previous Month Data too
01:14:49 - Creating Matric Visual for Showing Top 10 Products also having Cell Elements and conditional formatting
01:25:36 - Cards for Showing the Most Ordered and Returned Product
01:30:00 - Showing the Visual to the Top Using Selection Pane
01:31:07 - Creating the Map Visual and Button Slicer
01:36:00 - Creating Detailed Page for Product Using Drill Through
01:38:00 - Creating the Gauge Visuals in the Product Detailed Page
01:46:00 - Creating the Dynamic Line Chart for Total Profit and Adjusted Profit using Numeric Range Parameter
01:55:00 - Creating the Dynamic Area Chart where X-Axis Changes Using Slicer (Field Paramter)
02:00:56 - AI Visuals in Power BI (Creating the Report Summary Visual Using Narrative Visual)
02:04:30 - Creating the Cards for Customer Detailed Page Using Measures
02:08:00 - Creating the Dynamic Line Chart Using the Field Paramter
02:12:00 - Creating the Calculated Column Using Switch and IF DAX Function for Donut Chart Visual
02:25:00 - Top 100 Customer Using Table Visual (Also Creating Calculated Column By Combining Multiple Columns Using DAX)
02:29:00 - Creating the Slicer for Year
02:31:00 - Creating the Card for Top Customer, Showing the Order and Revenue Generated From Him
02:34:00 - Creating the Dynamic Information Button
02:38:00 - Connecting all the pages together so that we can switch from one page to another
02:41:00 - Creating the Tooltips (In-Built and Custom)
02:48:00 - Hiding and Fitting the Pages
02:49:00 - Publishing the Dashboard to Power BI Services

Like, Share & Subscribe !!

Follow on LinkedIn -   / praveen-kumar-pal-64490a1ab  
Follow on Telegram - https://t.me/zerotohero510

================================================================================
#powerbi #powerbi #project #dashboard #dax