Search Training
X

Data Analysis using Excel 2016 – Level 1

Course Overview

Report Builders will learn everything they need to create highly effective PivotTable and PivotChart reports using data sources that are created using Excel. 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, creating simple custom data calculations, effectively applying new visualization techniques using Power View, creating geospatial Power Map tours, using data transformations to prepare for data modeling, and creating simple custom data calculations. Students will also learn how to build 3D geospatial reports using Power Map as well as how to transform and query data sources using Power Query.​

Who Should Attend

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

Course Objectives

Students will learn:

  • How to create highly effective PivotTable and Pivot Chart reports using data models created by more advanced Power BI Designers.
  • Day one topics covered include an overview of PowerPivot, creating effective and professional reports, creating data driven narratives, effectively applying different chart styles, using data hierarchies, and creating simple custom data calculations.
  • Day two topics include learning how to use the Power View, Power Map, and Power Query add-ins. Power BI Report Writers will learn how to use Power View to create highly effective interactive reports using data models created by more advanced Power BI Designers.
  • How to build 3D geospatial reports using Power Map as well as how to transform and query data sources using Power Query.

    Course Outline

    1 - INTRODUCING POWER BI FOR EXCEL

    • What Is Power BI for Excel?
    • What is Power Pivot?
    • Power BI Key Features
    • The Self-Service Bi Model
    • Power Pivot Components

    2 - DEFINING A REPORT

    • What is a Power BI Report?
    • Defining a Report
    • Data-Driven Storytelling

    3 - UNDERSTANDING POWERPIVOT DATA

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

    4 - CREATE REPORTS USING POWERPIVOT DATA

    • Making Changes to PowerPivot Data
    • Creating PowerPivot PivotTables
    • Creating PowerPivot Pivot Charts
    • Creating Slicers
    • Graphing Data

    5 - CREATING POWERPIVOT FUNCTIONS

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

    6 - INTRODUCING POWER BI TOOLS

    • Microsoft’s Self-Service Power BI Model
    • What Is Power BI for Excel?

    7 - POWER VIEW FOR EXCEL

    • What Is Power View?
    • Creating Power View Reports
    • Power View Interface Components
    • Understanding Table Visualizations
    • Chart Visualizations
    • Power View Tiles, Slicers, & Multiples

    8 - BI DATA QUERY BASICS

    • What Is a BI Data Query?
    • Power BI Interface
    • Planning a BI Data Query

    9 - QUERY EDITOR TRANSFORMATIONS

    • Basic Transformations
    • Merging & Appending Queries
    • Calculated Columns
    • Grouping and Summarizing Data
    • Unpivoting Data
    • Dealing with Malformed Data
    • Finalizing Queries

    10 - APPENDIX: POWER MAP FOR EXCEL

    • What Is Power Map?
    • Preparing a Power Map Tour
    • Power Map Designer
    • Power Map Formatting Tools
    • Finalizing a Power Map Tour

  • Enroll Today

    This is a 2-day class

    Price: $990.00
    Payment Options

    ILT Instructor‑Led Training

    OLL Online LIVE

    GTR  Guaranteed to Run

    Class times are listed Eastern time. This class is available for Private Group Training

    To sort by location or date, click the ‘When’ and ‘Where’ column headings.

    Cart When Time   Where How
    08/07/2019 9:00AM - 5:00PM GTR Online LIVE OLL
    10/16/2019 9:00AM - 5:00PM GTR Online LIVE OLL
    12/09/2019 9:00AM - 5:00PM GTR Online LIVE OLL

    Class times are listed Eastern time
    This class is available for Private Group Training