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
Drill Through
Adding Slicers to Reports
Utilize themes.

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

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