PowerPivot: Powerful Data Analysis and Data Modelling in Microsoft Excel

by Pentawise Sdn Bhd

This course is relevant to data analysts, business analysts, financial analysts and anyone who wants to better manage their data.

Price : Enquire Now

Contact the Institutes

Fill this form

Advertisement

Pentawise Sdn Bhd Logo

img Duration

Course Details

With PowerPivot, Microsoft brings the dynamism of Business Intelligence tools to Excel, transforming enormous amount of data/records into meaningful information. It helps to generate rich and interactive analysis solutions. It is an extension to things you already know about Excel and it comes FREE with the software (Excel 2010 and above).

  • Data from Different Sources: With PowerPivot, you can import data virtually from any data source e.g. from SQL Server, XML and even web based data. These mixed and mashed up data from different data sources are combined. Relationships of data from these different data sources can be easily be created and be generated into a single report or a data model. There is no need to use any Excel Functions e.g. VLookup to `join’ these data.
  • Large Volume of Data: Microsoft Excel 2010 has a maximum of about 1 million rows of data. PowerPivot can store and process unlimited capacity of data.
  • Create Visually Appealing Analytical Models: Analysis will be made easier by presenting the output in variety of visual forms. You can present your data in PivotTable and PivotCharts. PowerPivot allows further enhancement of data analysis into Business Intelligence Dashboards.
  • Use the powerful new analytical capabilities, the Data Analysis Expressions (DAX)

 

In this training you will learn:

  • Introduction to PowerPivot
  • Load Data into PowerPivot
  • Table Relationships
  • PowerPivot Windows
  • Calculated Column
  • PivotTables
  • Create Measures (DAX)
  • Case Study
  • Mid Valley City Branch

    37-8, The Boulevard, Lingkaran Syed Putra, Mid Valley City, Kuala Lumpur

© 2025 coursetakers.com All Rights Reserved. Terms and Conditions of use | Privacy Policy