Enable Technology

Data Analytics 

Microsoft Power Graphics




Course Overview


The course is targeted towards business analysts, business intelligence developers and reporting professionals. Participant will learn how to combine the functionality of Power View, PowerPivot, Power Query and Power BI into graphs, charts, KPIs, reports and other data visualisations.

Duration: 2 day course



Course Content


Topics include –

Power View
Exploring the Power View Interface
Visualizing Power View Reports
Working with Tables
Understanding Aggregations
Utilizing Matrix
Configuring Drill Through
Using Cards
Applying Filters
Creating Charts
Examining Tiles
Adding Slicers to Reports
Theming Reports
Aggregations
Matrix
Drill Through
Cards
Filters
Charts
Tiles
Adding Slicers to Reports
Utilize themes.

PowerPivot
Introduction to the PowerPivot Interface
Importing Data
Importing Large Datasets
Importing Data with a Query
Creating Relationships
Creating a Cascading Relationship
Hiding Columns, Change Data Type, Sorting, and Filtering
Creating PivotTables
Understanding DAX
Utilizing DAX Functions
Calculated Columns and Calculated Fields
KPIs
Hierarchies
Perspectives

Power Query
Navigate the Power Query interface.
Load data.
Filter data.
Merge datasets.
Manage modifications.
Perform data cleaning.

Power Map
Navigate the Power Map interface.
Use Bing maps.
Examine map data.
Configure tours, scenes, and layers.
Add time to a presentation.

Introduction to Power BI
Navigate the Power BI interface.
Utilise data sources.
Understand querying with natural language


Email us about this courses


Telephone on 01952 305730