Consulting Training Blog Careers About Us Contact Us

Power BI for Excel 2016 - Level 1 - Report Builders Training

Upcoming Classes

Sorry, nothing scheduled right now. Click the Get Notified button below to be alerted when a class is scheduled.

Get Notified

On Site/Private

Can't find a class that fits right for you? Contact us to inquire about scheduling your own private class

Contact Us

Description

This is the first course in the Power BI for Excel 2016 training series. This course lays the foundation for all Power BI for Excel Designers. It is the first of several courses an Advanced Power BI Designer would require. Power BI Report Writers will learn everything they need to create highly effective PivotTable and PivotChart reports using data models created by more advanced Power BI Designers. Topics covered include an overview of the PowerPivot add-in, creating effective and professional reports, creating data driven narratives, effectively applying different chart styles, using data hierarchies, and creating simple custom data calculations. 

Bring This Course To You

For groups of 5 or more, let Intertech bring this course to your location. Customized versions tailored towards your objectives are also available.

Learn More

Prerequisites

Excel levels 1 & 2, including PivotTable & Pivot Chart skills; plus a basic understanding of database concepts. 

Course Outline

Introducing PowerPivot

  • What Is PowerPivot?
  • PowerPivot Key Features
  • The Self-Service BI Model
  • PowerPivot Components

Defining a Report

  • What is a PowerPivot Report?
  • Defining a Report
  • Data-Driven Storytelling

Understanding PowerPivot Data

  • Data Terminology
  • Understanding Tables
  • Understanding Relationships
  • Diagnosing Data Models
  • Data Model Schemas

Create Reports using PowerPivot Data

  • Making Changes to PowerPivot Data
  • Creating PowerPivot PivotTables
  • Creating PowerPivot PivotCharts
  • Creating Slicers
  • Graphing Data

Understanding PowerPivot Functions

  • Calculated Columns
  • What is DAX?
  • Understanding DAX Functions
  • Common DAX Functions
  • Dates and Date Functions
     

Free Resources from Intertech

Free On-Demand Video Bundle: IoT, Agile/Scrum, and Leadership

Free Whitepaper: Design and Code Review Checklist

UX Design: 4 Key Factors to Know Before Starting

X