Power BI for Desktop

This program is in high demand.  It facilitates large datasets from multiple file types to come into one visual – enabling the user to get results with a simple drag and drop. This indispensable course will equip the participants with the proper tools to create multiple data analysis reports with useful illustrations. The participants will be able to create measures to get key performance indexes of their organization’s products and services.  They will be able to create matrixes to compare data in time segments, as in month over month and year over year. 

Benefits

• Automate reporting with a simple refresh
• Work with different data types
• Display sophisticated dynamic dashboards
• Get real-time data
• Share data with others
• Manage large data sets
• Create measures to get real-time performance of your products and services

Course Content

• Learn about DAX
• Understand Data Modeling
• Understand data connection
• Understand Lookup Tables and Data Tables
• Create matrixes
• Create measures
• Learn functions, such as SUMX, AVERAGEX, CALCULATE, IF, SWITCH, FIND, VALUES, FILTER, RELATED, RELATEDTABLE, HASONEVALUE, SELECTEDVALUE AND CONCATENATEX
• Create calculated columns
• Create dynamic visualizations

Recommended Duration

24 hours conducted in 3-hour sessions

Target Audience

Employees with a solid Excel PivotTable and Pivot Chart experience and job classifications that would benefit using visualizations for data analysis and reporting.  And, have a need to connect to large data collections.