Power BI
A visual perspective from a vantage point
Power BI Models - PK1
These three modules can be chosen independently but the three are designed to engage learners who are new to reporting or needs to develop sophisticated reports
It will take the user on a journey of data imports, understanding the Power BI web architecture, data querying, transformation, pivots and various kinds of visualisation.
Module 1 [GBI01]
History of Power BI and Power Query
PowerBI data sources
Architecture
Installing PowerBI
Understanding the web interface
Sample reports and visual controls
PowerBI cloud account setup
Power View, Power Map and BI license
(60 mins)
Friday
Module 2 [GBI01]
Connecting to various data sources
Improting data
Understanding the query editor
Transforming Data types
Pivot and unpivoting data
Relational data
Calculated columns, appending data, indexing and clean up
(60 mins)
Friday
Module 3 [GBI03]
Visualisationa and Reporting
Understanding the visualisation interface
Creating visualisations
Card and Matrix
Chart visuals
Use of slicers
Tabbs and Pages
Map and custom visuals
(60 mins)
Friday
Power BI Models - PK2
These three modules can be chosen independently but the three are designed to equip data analysts with the tools to query data using expressions and DAX formula.
It will take the learner on a journey of configuring security models to publishing data into various workspaces. The learner will begin to master the use of the query by example grid and DAX formula
Module 1 [XBI01]
Security models
Roles and groups
Publishing data to the PowerBI service
Public and private workspaces
Refreshing datasets
Sharing reports
(60 mins)
Friday
Module 2 [XBI02]
Understanding DAX formula
Using DAX to create calculated columns
Calculated tables
Creating Measures in PowerBI
Using What IF parametres
(60 mins)
Friday
Module 3 [XBI03]
PowerBI Governance
Structure of governance
Setting the measures of success
Working with various stakeholders
Delivery approaches
Ownership of reports
Branding Techniques
Roles and Responsibilities
Architecture and Licenses
(60 mins)
Friday
@ 2024 SYS
We need your consent to load the translations
We use a third-party service to translate the website content that may collect data about your activity. Please review the details in the privacy policy and accept the service to view the translations.