Overview

Save Big on Coursera Plus. 7,000+ courses at $160 off. Limited Time Only!

Grab it

Dive into a comprehensive 80-minute video tutorial on Power BI Desktop, covering essential aspects of data analysis and visualization. Learn to use Power Query for importing and transforming data, create DAX formulas and relationships to build a robust data model, design interactive dashboards, and publish reports. Explore topics such as importing multiple CSV files, merging dimension tables, creating date tables with DAX functions, and implementing various visualizations like matrices, column charts, and line charts. Master advanced concepts including row context, filter context, and context transition in DAX measures. Discover how to create fiscal periods, implement hierarchies, and utilize bookmarks for saving dashboard views. Gain insights into publishing reports to powerbi.com, sharing with Power BI Pro, and refreshing data sources. Perfect for those looking to enhance their data analysis skills using Microsoft's powerful business intelligence tool.

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.