Microsoft Excel Training > Power Pivot for Excel 2013: Mining Data for Business Intelligence

Power Pivot for Excel 2013: Mining Data for Business Intelligence

Course Objectives

Transform and present sophisticated data to provide BI
Actualize a data model from multiple sources
Shape and filter tables to prepare for analyses by fixing common issues
Mine and expose hidden information with Data Analysis eXpressions
Communicate business and data insights with dashboards

Course Modules

Identifying the Role of Power Pivot in Business Intelligence (BI)
Introducing Power Pivot
Employing Power Pivot in the BI process
Building the Data Model with Power Pivot
Defining a consolidated view of data
Denormalizing data to simplify usage within other BI reporting tools
Querying SQL Server data
Fixing common data issues with Power Query
Manipulating and Analyzing Data with the Data Analysis eXpressions (DAX) Language
Defining calculated fields for business performance
Implementing DAX functions in Power Pivot
Exploiting data analytics with aggregation
Mining for information with date and time analysis
Setting key business targets with KPIs
Presenting Information with Dashboards
Articulating and analyzing data
Designing effective dashboards
Creating Team BI Solutions

Get To Know The Trainer

Trainer Shabenah

4.5

Shabenah is an experienced corporate trainer, facilitator and consultant with deep knowledge in the field of IT, soft skills, leadership and communication. She has a great passion for training, learning and development, and is able to work effectively with people of all levels. Shabenah is also an active participant in local community and social activities.

VIEW PROFILE