Menu
Menu
PREMIUM COURSE

Power Pivot for Excel 2013: Mining Data for Business Intelligence

0

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.

Chat with us LIVE to get a

FREE QUOTATION!

COURSE INCLUDES

  • 2 Days of training
  • E-Certificate of Completion
  • E-Training manual
  • Trainer logistic to client`s place

COURSE BENEFITS

  • 1 or 20 pax, same price
  • Confirmed-to-run even for 1 pax
  • Cheapest available (*we will price match!)
  • Money-Back-Guaranteed Quality
  • HRDF Certified & Claimable

ALL IN FROM ONLY

RM2,000/DAY

RRP RM2,860/DAY   SAVE RM860

*T&C Applies

PARTICIPANT REVIEWS FOR THIS COURSE

What Other People Bought

LOGIN

Login with your social account

or

Don’t have an account with us?

Edit Profile

FREE FOR LIFE

Sign Up to Bookmark your Favourite Course
or Request for a Quotation instantly

Sign in with your social account

or

By signing up, you agree to our Terms of Use and Privacy Policy

Have an account with us already?