Power BI training course

 Cont ...

• Query Editor in brief
• Query Design explained
• Query editors tabs and menus
• Best Practice for Queries
• Applied Steps
• Advanced Query Editor
• Data Transformations
• Data cleaning
• Dataset merges
• Unpivoting
• Accessing data from a Folder
• Appending techniques
• Columns
• Dynamic Fiscal Calendar Tables

Data Modelling

• Tables & Columns - Understanding basic data structure.
• Data View - Seeing your underlying data values
• Exploring Data - Easy data profiling
• Managing Schema & Data Changes - Dealing with issues of change control
• Connections & Tables - Data lineage.
• Data Refresh - Optimising new data acquisition.
• Relating Tables - Telling Power BI how your data relates internally.
• Rules & Limitations - Filter flow options and consequences.
• Auto-Detecting - Pros and cons of saving design time
• Relationship View - Working on your data model structure.
• Introduction to Facts & Dimensions

• Creating Relationships Between Tables
• Relationship types
• CrossFilter Relationships
• Handling Multiple Relationships with the Fact Table
• Custom Sorting of Columns
• Data Types & Formatting

Reports/Dashboards

• Reading View - Seeing what users see.
• Editing View - Customising user experience.
• Visualisations and Custom Visualisations - Telling a compelling story.
• Dashboards - The easy-read overall summary ‘at a glance’
• Creating & formatting Dashboards
• Creating visuals
• Choosing the best visual
• Interactivity between visuals
• Visuals in Preview and Custom Visuals
• Formatting visuals
• Types of Conditional Formatting
• Optimizing the Matrix Layouts
• Adding Drill-Downs
• Viewing the Underlying Data Driving a Visualization
• Understanding Row Level Security
• Creating and Testing Security Roles

DAX & Calculations

•     Data Analysis Expressions - Powerful versatility at your command.
•     Calculated Columns - Extending data tables.
•     Measures - How your data is summarised.
•     DAX Syntax - Learning the basic grammar of formula writing.
•     DAX Functions - Building blocks for data manipulation.
•     Advanced Relationships - Data model design trade-offs.
•     Dax Operators
•     Calculated Measures & Calculated Columns
•     Implicit Vs Explicit
•     Base Measures & Metrics
•     Commonly Used DAX Functions
•     DAX Aggregate functions
•     Iterators: SUMX, MAXX, AVERAGEX
•     IF conditional statements
•     Cross Table Lookups
•     Evaluating Context in the relationship
•     CALCULATE: the magic function
•     USERELATIONSHIP function
•     Time Intelligence prerequisites
•     Time intelligence functions (MTD, QTD, YTD, Prior Year)
•     Create a time Intelligence report

Publishing & Sharing Dashboards & Reports

• Sharing Dashboards - Who gets to see what?
• Creating Workspace - Organising structure around people.
• Publish App - Making it available online.
• Security - Restricting access to the ‘need to knows'
• Publishing Models to the Cloud Service

• Adding Users to Security Defined Roles
• Basic Sharing of Dashboards & Reports
• Multiple ways of sharing reports and Dashboards
• Creating App Workspaces
• Collaborating on Reports
• Publishing Organisational Apps for Distribution of Content
• Adding Users & Editing Workspaces
• Connecting to Apps

Data Refreshing

• The Data Gateway
• Data Refreshe schedules
• On-Demand Refresh

Power BI Mobile

•     Native Applications (iOS/Android/Windows)
•     Optimising deployment on different platforms.
•     Viewing Content, How phone view works.
•     Sharing & Collaboration - Encouraging appropriate teamwork.
•     Configuring Alerts - How to notify users of important new data.
•     Configure reports for Mobile view
•     Configure Dashboard for Mobile view
•     Viewing Content
•     Sharing & Collaboration
•     Configuring Alerts