Outcomes
- Understanding Power business intelligence
- Enabling participants to build reports
- Enabling participants to make merging, summarizing, and calculating data
- Enabling participants to work with CSV, TXT, and Excel Worksheets
·
Target Group
This programme is a designed for analysts, business seniors and financials who are interested in preparing financial and managerial reports, building dash boards, and cleaning and transforming data
Contents
· Understanding Relationships
LOOKUP, VLOOKUP & HLOOKUP
XLOOKUP & XMATCH
PIVOT TABLES
POWER PIVOT
RELATIONSHIPS
What is Power BI?
DATA ANAYSIS EXPRESSIONS (DAX)
Examining Power BI Suite of Products
Identifying Differences Between Products
Understanding Power BI Updates
Installing Power BI Desktop
Exploring the Power BI Desktop Interface
Utilizing File Types; PBIX vs PBIT
Examining Data Sources
Discussing Data Refresh
Understanding Data Types
Importing, Transforming, and Loading Data
Appending Operations
Working with Folders and Files
Using Pivot Tables
Working with Relational Data
Understanding Relationships
Importing from SQL Server Analysis Services Multidimensional and Tabular
Understanding the Issues with Merges
Performing Merges
Grouping Options
Summarizing
Calculating
Creating Reports
Utilizing the Matrix Visualization
Utilizing the Map Visualization
Utilizing the Card Visualization
Utilizing the Chart Visualization
Utilizing Slicers
Publishing to Power BI Online
Introduction to Power BI Online
Importing Data
Creating Reports
Configuring Dashboards
Sharing Reports and Dashboards
Exploring Power BI Mobile