Curriculum
- 11 Sections
- 168 Lessons
- 8 Hours
Expand all sectionsCollapse all sections
- Introduction1
- Seting up Power BI Desktop3
- Power BI Lifecycle3
- Get or Connect to Data29
- 4.1Connecting to a CSV File
- 4.2Power Query Interface
- 4.3Renaming Fields and Data Types
- 4.4Column Data Quality
- 4.5Column Profile and Distribution
- 4.6Dropping and Preserving Rows and Columns
- 4.7Split Columns
- 4.8Format Tool
- 4.9Merge Columns
- 4.10Transform vs. Add Column
- 4.11Extract Tool
- 4.12Conditional Columns
- 4.13Duplicating Columns and Adding Indexes
- 4.14Date Tool
- 4.15Numerical Tools
- 4.16Statistics and Count Rows
- 4.17Append Queries
- 4.18Group
- 4.19Pro Tip – Connect to a Folder!
- 4.20Change the Data Source Settings
- 4.21Loading a JSON File
- 4.22Creating Calculated/Custom Columns
- 4.23Quick Note on Custom Columns
- 4.24Enable / Disable Load
- 4.25Understanding Duplicate vs. Reference Queries
- 4.26Resolve data import errors
- 4.27Pro Tip – Wheel Icon in Applied Steps!
- 4.28Configure Data Loading Settings
- 4.29Bringing it all together!
- Data Modelling28
- 5.1Normalization
- 5.2Primary Keys
- 5.3Foreign Keys
- 5.4Fact and Dimension Tables
- 5.5Star Schema
- 5.6Snowflake Schema
- 5.7What’s a Join?
- 5.8Merge Queries
- 5.9Cardinality
- 5.10Configuring our Data Model – Part 1
- 5.11Configuring our Data Model – Part 2
- 5.12Create our own Fact and Dimension Tables from a De-normalized dataset
- 5.13Understanding Data Source Privacy Levels
- 5.14Practical: Setting Privacy Levels
- 5.15Connecting to a Database
- 5.16Change Data Source Settings: Credentials
- 5.17Creating Parameters
- 5.18Choose between DirectQuery and Import Modes – Part 1
- 5.19Choose between DirectQuery and Import Modes – Part 2
- 5.20Composite Models and Dual Storage Mode
- 5.21Practical – DirectQuery, Import and Dual Storage Modes
- 5.22Configure table properties
- 5.23Configure column properties
- 5.24Understanding the Filter Direction – Theory
- 5.25Understanding the Filter Direction – Practical
- 5.26Auto-Date Time & Common Date Tables – Theory
- 5.27Common Date Tables – Practical
- 5.28Implement Role Playing Dimensions
- Visualization and Formatting33
- 6.1Looking at our new semantic model
- 6.2Canvas Settings
- 6.3Cards for KPIs
- 6.4Pro Tip – Use the format painter
- 6.5Clustered Column/Bar Chart – Part 1
- 6.6Clustered Column/Bar Chart – Part 2
- 6.7Stacked Bar Chart + Ribbon Charts
- 6.8Line Charts – Part 1
- 6.9Line Charts – Part 2
- 6.10Line & Clustered Bar Chart
- 6.11Line & Stacked Bar Chart (Combo Chart)
- 6.12Area Chart & Stacked Area Chart
- 6.13Stacked Area Chart – Variation
- 6.14Pie Chart
- 6.15Donut Chart
- 6.16Treemap
- 6.17Gauge
- 6.18Scatter, Bubble and Dot Plot Chart
- 6.19Tables
- 6.20Matrix
- 6.21Apply conditional formatting
- 6.22Conditional Formatting – Imp. Note
- 6.23Format – Properties Tab
- 6.24Filters
- 6.25Glimpse of Power BI Service for Header Icons and Filters
- 6.26Slicers
- 6.27New Slicers – List, Button and Text
- 6.28Sync Slicers
- 6.29Apply and customize a theme
- 6.30Apply sorting to visuals
- 6.31Create custom tooltips
- 6.32Paginated Reports
- 6.33Summary of the different visuals
- DAX31
- 7.1What is DAX?
- 7.2Taking a look at DAX resources
- 7.3Calculated Columns using DAX
- 7.4Text functions – Part 1
- 7.5Text functions – Part 2
- 7.6Logical Functions – Part 1
- 7.7Logical Functions – Part 2
- 7.8RELATED() Function
- 7.9Understanding Implicit Measures
- 7.10Implicit Measures – Practical
- 7.11Explicit Measures – Theory
- 7.12Explicit Measures – Practical
- 7.13Create single aggregation measures – Part 1
- 7.14Create single aggregation measures – Part 2
- 7.15Use basic statistical functions
- 7.16Understanding Iterator Functions
- 7.17Use the CALCULATE() function
- 7.18KEEPFILTERS()
- 7.19REMOVEFILTERS() and ALL()
- 7.20ALLSELECTED()
- 7.21USERELATIONSHIP()
- 7.22Create calculated tables using DAX – Part 1
- 7.23Create calculated tables using DAX – Part 2
- 7.24Introduction to Time Intelligence in Power BI
- 7.25Implement Time Intelligence measures – Part 1
- 7.26Implement Time Intelligence measures – Part 2
- 7.27Implement Time Intelligence measures – Part 3
- 7.28Create Semi-additive measures
- 7.29Create Calculation groups
- 7.30Create a measure by using quick measures
- 7.31Create visual calculations by using DAX
- Visualize and Analyse the Data11
- 8.1Drill Down
- 8.2Edit and configure interactions between visuals
- 8.3Configure bookmarks
- 8.4Group and layer visuals by using the Selection pane
- 8.5Configure navigation for a report
- 8.6Configure drill through navigation
- 8.7Configure export settings
- 8.8Design reports for mobile devices
- 8.9Enable personalized visuals in a report
- 8.10Design and configure Power BI reports for accessibility
- 8.11Configure automatic page refresh
- Optimization4
- Identify Pattern and Trends5
- Manage and Secure Power BI20
- 11.1Power BI Licensing
- 11.2Power BI Service interface walkthrough
- 11.3Create and configure a workspace
- 11.4Practical – Deploy a new workspace
- 11.5Assign workspace roles
- 11.6Configure item-level access
- 11.7Looking at semantic model configurations
- 11.8Connect to Sharepoint and trigger a refresh
- 11.9Identify when a gateway is required
- 11.10Download the On-Prem Data Gateway
- 11.11Configure a semantic model scheduled refresh
- 11.12Using Shared / Published semantic models
- 11.13Publish, import, or update items in a workspace
- 11.14Create dashboards
- 11.15Configure and update a workspace app
- 11.16Promote or certify Power BI content
- 11.17Apply sensitivity labels
- 11.18Implement row-level security roles (Static RLS)
- 11.19Implement row-level security roles (Dynamic RLS)
- 11.20Configure subscriptions and data alerts