Course ID: IDAEPP

Introduction to Data Analytics with Power Pivot

About & Customize

Popular Options

  • In-Person
  • Live Webcast

  • Understand loading queries into the Data Model and the advantages of this capability
  • Navigate the creation of a basic date table via Power Pivot and building a relationship to a data query
  • Understand building relationships among queries and creating pivot tables from multiple connected data tables
  • Understand the differences, and advantages, between pivot tables and Power Pivot pivot tables
  • Build, and leverage, basic data analysis expressions (“DAX”) functions

  • In this course, we build upon the intro to Power Query session and dive into Excel’s “pivot tables on steroids” tool – Power Pivot. We will explore the basics of transforming data, the advantages of loading data into the Data Model, building relationships between queries, and building robust analysis with the more powerful Power Pivot pivot tables. The “analysis” phase of data analysis really starts to take shape in this session. Topics include:
  • Loading queries into the Data Model (in the “background” of Excel)
  • Building a date table – why they are important and the advantages of using a well-structured date table
  • Building pivot tables from multiple, related data sets – taken advantage of the “power” of power pivot
  • Creating and using DAX functions to simplify and automate calculations required for analysis purposes
  • Hands-on, interactive, session components to apply the knowledge you learn – using real data relevant to accounting and finance professionals
  • Excel workbooks will be made available for all participants to use at their leisure and further explore the topics discussed
Designed For

Any business professional responsible for, or interested in, managing and working with data and delivering insight to their organization

Field of Study
Computer Software & Applications
Prerequisites

Comfortable with Excel navigation; Understanding of data related topics – LOOKUP, Pivot Tables, Data Tables, etc. would be helpful, but not required

Course Producer
Business Learning Institute
Level
Advanced
Available Formats
In-Person, Live Webcast

This course, like all courses in the BLI catalog, is customizable for your organization. Format, length, and content customizations are available.

To get started, contact BLI:
(888) 777-7077
team@blionline.org