Duration
2 days
Overview
Power BI is part of the suite of tools from Microsoft, which enable data to be analysed and published from a variety of sources.
With Power BI Desktop, many KPI can be created for big data analysis. Furthermore, reports can then be published.
This course covers the use of Power BI to create data model, create customized calculation for various charting and publish reports.
Objective
By the end of the course, participant will be able to:
- create table relationships
- use DAX functions.
- create measures and quick measures.
- customize filters in reports.
- publish reports in Power BI Desktop.
Target Audience
This course is intended for users who have to create richer data models to enable deeper insight into their data.
Prerequisites
Before attending this course, the participant must have attended INTERACTIVE REPORTS WITH VISUAL ANALYTICS IN POWER BI (Basic-Intermediate) 2 days.
Software Needed
- Power BI Desktop
MODULE 1 – DATA MODELING IN POWER BI DESKTOP
- What is Data Model?
- Creating Data Model
- Create a Relationship with Autodetect
- Create a Relationship Manually
- Edit a Relationship
- Delete a Relationship
- Cardinality
- Cross Filter Direction
- Active vs Inactive Relationship
- Automatic Relationship Updates
- Work with Model View
- Referential Integrity
MODULE 2 – ADVANCED VISUALIZATION SETTINGS
- Conditional Data
- Hierarchy
- Sort by Column
- Grouping and Binning
- Drill Through
- Download Additional Visualizations in AppSource
- Apply Filters in Filters Pane
- Add Bookmarks to Report Pages
- Web URL Data Type
MODULE 3 – OVERVIEW OF DAX FUNCTIONS
- What is DAX?
- Excel Functions vs. DAX Functions
- Types of DAX Functions
- Syntax of DAX Function
- Example of a DAX Function
- DAX Reference from Microsoft
MODULE 4 – CREATING CALCULATED COLUMNS
- What is Calculated Column?
- Creating Calculated Columns in Power BI Desktop
- Editing a Calculated Column
- Deleting a Calculated Column
MODULE 5 – CUSTOM CALCULATIONS
- What is Measures?
- Create Quick Measures
- Create Measures
- Organizing Your Measures
MODULE 6 – CREATING CALCULATED TABLES
- What is Calculated Table?
- Create a Calculated Table
- Mark as Date Table
MODULE 7 – OVERVIEW OF QUERY PARAMETERS
- What is Query Parameter?
- Overview of Parameter Properties
- Using a Parameter
MODULE 8 – PUBLISHING AND SHARING IN POWER BI DESKTOP
- Overview of Data Source Settings
- What is Power BI Services?
- Using Power BI Desktop for Report Sharing
- Printing Power BI Dashboards
- Export Options
- Publishing Report to Web
- Using Content Pack
- Creating a QR Code for a Report
Programme scope, delivery arrangements and suitability are confirmed during enquiry.