Dive into a comprehensive 38-minute tutorial on Power BI Desktop, focusing on data modeling and interactive visualizations. Learn to import Excel files from folders using Power Query, build DAX formulas, create a complete data model, and develop data model visualizations. Explore topics such as Power BI's history, different versions, and user interface. Master techniques for importing data, creating relationships between dimension and fact tables, and generating date tables with DAX functions. Discover how to create DAX measures for financial metrics, hide unused tables and fields, and design interactive visualizations for gross profit and units analysis. Gain practical skills in creating hierarchies and optimizing your Power BI reports for effective data analysis and business intelligence.
Overview
Syllabus
) Introduction to Power BI and Interactive Visuals.
) Download Files.
) Overview of Power BI project.
) Excel PowerPivot or Power BI Desktop?.
) Power BI History.
) Different Versions of Power BI.
) Download Free Power BI.
) Open Blank File and name “.pbix” file..
) First Look at Power BI Desktop User Interface..
) Import Data into Power BI Desktop. Import many Excel files from a folder. Use Excel.Workbook Function..
) Import Dimension tables from single Excel Workbook..
) Create Relationships between Dimension & Fact Tables.
) Create Date Table with DAX Formulas. See the DAX Functions: CALENDAR, MIN, YEAR, DATE, MAX,.
) Create DAX Measures for Total Revenue, Total COGS, Total Gross Profit, and Total Units. See the DAX Functions, SUMX, ROUND, RELATED and SUM..
) Hide Tables and Fields that are not used in Reports and Visualizations.
) Add new Tabs, Sheets, Pages (all synonyms).
) Create Gross Profit Interactive Visualization.
) Create Units Analysis Interactive Visualizations..
) Create Hierarchy.
) Summary.
Taught by
ExcelIsFun
