This course provides a comprehensive introduction to Power BI Desktop, covering Power Query for data import, DAX formulas and relationships for data modeling, dashboard creation, and report publishing.
By the end of the course, learners will be able to import and transform data using Power Query, create relationships and data models using DAX formulas, design interactive dashboards, and publish reports for sharing.
The course teaches skills such as data importing, data modeling, dashboard creation, report publishing, DAX formula creation, visualization design, and data refreshing.
The teaching method involves a video lesson with practical demonstrations and step-by-step instructions on using Power BI Desktop features and functionalities.
This course is intended for individuals interested in learning how to use Power BI Desktop for data analysis, visualization, and reporting, regardless of their prior experience level with the tool.
Power BI Desktop Comprehensive Introduction - Power Query, DAX, Dashboards, Publishing
ExcelIsFun via YouTube
Overview
Syllabus
) Introduction of what we will do in this video..
) Overview of Excel Power Pivot & Power BI Desktop.
) Approximate History of Power BI Desktop :.
) Different Versions of Power BI (Different Power BI Products) Available from Microsoft.
)Download Power BI Desktop (link to Avi’s video: https://www.youtube.com/watch?v=5Fv-I9xQkcc).
) List of Charts and Visualizations for your Dashboard (Review from prerequisite classes Busn 216 & 218).
) Overriding Steps for our Project.
) Open a blank Power BI File.
) Introduction to Power BI Window and User Interface.
) Power Query to Import Multiple CSV Files and Clean and Transform Data.
) Why we do NOT use Number or Date Fields from a Fact Table.
) Import Dimension Tables from a Single Excel File.
) Merge Snow Flake Dimension Tables into dProduct Table.
) Do NOT import to Data Model (Uncheck Enable Load).
) Old Relationship View & New Relationships View with Properties & Better Selection Capability.
) Steps to create Date Table using CALENDAR DAX Table Function & Calculated Columns. See many DAX Functions such as CALENDAR, FORMAT and others..
) Sort By Column to get Months to Sort correctly..
) Create Fiscal Periods for Data Table, including Helper Column for Sorting Fiscal Period correctly..
) Hide Columns from Report View.
) Create DAX Measures and see why we do not use Implicit Measures..
) SUMX DAX Function.
) Row Context (how formula calculates for each row in a table or Iterator Function).
) Filter Context (How Measures Calculate and how Tables are Filtered when Measures Calculate).
) Measure for Average Daily Revenue. Learn about Context Transition. See AVERAGEX Function to iterate at the Daily level..
) Conventions for DAX Formulas with a great tip from Marco Russo and Albetro Ferrari.
) More About Filter Context and Context Transition.
) Gross Profit Measures.
) Refine Data Model in Power Query by Removing Columns in dProduct Table.
) Learn about how to Create & Format Visualizations.
) Create “Ave Daily GP” Dashboard..
) Create Matrix and add Conditional Formatting.
) Create Column Chart and add Conditional Formatting.
) Hierarchies.
) Drill Down Icons in Power BI.
) Create Line Chart.
) Create Card.
) Edit Interactions between visualizations.
) Create “Fiscal Report” Dashboard.
) Bookmark to save views of a Dashboard.
) Create “Ave Last 12 Months” Dashboard.
) DAX Measure for Average Transactional Revenue. See AVERAGEX Function to iterate at the transaction line item level..
) Visual of how we change the Filter Context to get dates for a full year backwards..
) CALCULATE & DATESINPERIOD & LASTDATE DAX Functions to calculate Measure for Rolling 12 Month Average for Transaction Level Data..
) Create “Question” Dashboard. Learn about Ask A Question feature..
) Publish Report to powerbi.com.
) Edit at powerbi.com.
) Publish to Web with Free Power BI Desktop version and allow public to review Report.
)Publish and Share with Power BI Pro Account.
) Source Data Changes and Refresh.
) Summary.
Taught by
ExcelIsFun
