Power BI: Intermediate

Course Outline PBI003IW.pdf
PowerPoint Slides
  • Day1.pptx
  • DayModulesSharing
    1
    • An introduction to the different Power BI Products
    • When to use Power BI Desktop Free, Pro and Premium
    • Online services and databases that Power BI can connect to
    • Power BI in the business intelligence industry
    • A day in the life of Power BI
    • Data transformation principles
    • Data normalisation
    • Fact and dimension tables
    • The data model
    • Star schema
    • Snowflake schema
    • Optimising the data model
    • Data sources
    • The dataset
    • Get data from a SharePoint list
    • Get data from an Excel worksheet
    • Get data from an Azure SQL database
    • Import vs DirectQuery
    • Power Query user interface
    • Queries pane
    • Data pane
    • Ribbon
    • Query Settings
    • Filter data
    • Rename queries
    • Group queries
    • Remove top rows
    • Use first row as headers
    • Rename columns
    • Duplicate columns
    • Split columns
    • Rename Applied Steps
    • Format data
    • Unpivot columns
    • Conditional columns
    • Fill values
    • Reorder columns
    • Combine queries
    • Append
    • Merge
    • Replace values
    • Custom columns
    • Remove columns
    • Evaluate and change column data types
    • Column quality
    • Column distribution
    • Column profile
    2
    • Auto Date/Time
    • Create a date dimension table
    • Dynamic date dimension tables
    • Extract date components as columns
    • Fiscal quarter and fiscal year
    • Include in report refresh
    • Enable load
    • Query dependencies
    • Advanced Editor
    • Close and Apply
    • The importance of a good data model
    • Manage relationships
    • Relationship cardinality
    • Cross-filter direction
    • Typical cardinality and cross filtering
    • The dataset Modify data formats
    • What is DAX?
    • M (Power Query) language vs DAX
    • Calculated columns
    • Create and use a calculated column
    • Measures
    • Create and use measures
    • Implicit vs explicit measures
    • Filter context and measures
    • Referring to measures and calculated columns
    • Simple DAX functions
    • Calculating values row-by-row in a measure
    • X functions vs aggregators and calculated columns
    • Quick measure categories
    • Aggregate per category
    • Filters
    • Totals
    • Mathematical operations
    • Text
    • Auto date/time option
    • Mark as date table
    • Visuals for date/time reporting
    • Quick measure using an existing measure
    • Online sharing
    • Introduction to row-level security (RLS)
    • Multi-row cards
    • Testing row-level security
    • Power BI workspaces
    • Apps
    • Add users to RLS roles
    • Unpublish an app
    • Delete a workspace
    • Combo charts
    • Small multiples
    • Waterfall charts
    • Drill-down charts
    • What if
    • Bookmarks
    • Buttons to navigate bookmarks

    Recommanded Books
    TitleTeach Yourself Visually Power BI
    ISBN978-1-119-90377-2
    AuthorAlexander Loth
    Year2023
    Publisher Visual
    TitleData Cleaning with Power BI: The definitive guide to transforming dirty data into actionable insights
    ISBN978-1-805-12640-9
    AuthorGus Frazer
    Year2024
    Publisher Packt Publishing
    TitlePro Power BI Architecture: Development, Deployment, Sharing, and Security for Microsoft Power BI Solutions
    ISBN978-1-484-29537-3
    AuthorReza Rad
    Year2023
    Publisher Apress
    TitleUp and Running with DAX for Power BI: A Concise Guide for Non-Technical Users
    ISBN978-1-484-28187-1
    AuthorAlison Box
    Year2022
    Publisher Apress
    TitlePro Power BI Dashboard Creation: Building Elegant and Interactive Dashboards with Visually Arresting Analytics
    ISBN978-1-484-28226-7
    AuthorAdam Aspin
    Year2022
    Publisher Apress
    TitlePower BI Data Modeling: Build Interactive Visualizations, Learn DAX, Power Query, and Develop BI Models
    ISBN978-9-389-32883-7
    AuthorNisal Mihiranga
    Year2022
    Publisher BPB Publications
    TitleExpert Data Modeling with Power BI: Get the best out of Power BI by building optimized data models for reporting and business needs
    ISBN978-1-800-20569-7
    AuthorSoheil Bakhshi
    Year2021
    Publisher Packt Publishing
    TitleData Analysis with Microsoft Power BI
    ISBN978-1-260-45862-6
    AuthorBrian Larson
    Year2020
    Publisher McGraw-Hill Education
    TitleLearn Power BI: A Beginner’s Guide to Developing Interactive Business Intelligence Solutions Using Microsoft Power BI
    ISBN978-1-838-64448-2
    AuthorDeckler, Greg
    Year2019
    Publisher Packt Publishing, Limited
    TitleMaster Your Data with Power Query in Excel and Power BI: Leveraging Power Query to Get & Transform Your Task Flow Second edition
    ISBN978-1-615-47358-8
    AuthorKen Puls, Miguel Escobar
    Year2021
    Publisher Ken Puls, Miguel Escobar
    TitleCollect, Transform and Combine Data using Power BI and Power Query in Excel (Business Skills)
    ISBN978-1-509-30795-1
    AuthorGil Raviv
    Year2018
    Publisher Microsoft Press