logo


your one source for IT & AV

Training Presentation Systems Services & Consulting Cloud Services Purchase Client Center Computer Museum
Arrow Course Schedule | Classroom Rentals | Student Information | Free Seminars | Client Feedback | Partners | Survey | Standby Discounts

Excel 2016 Power Pivot: Performing Data Modeling with SMART DATA Strategies

SS Course: 3000407

Course Overview

TOP
Getting Started with Dashboard & Data Modeling Fundamentals Using Excel Power Pivot                                                                  

Scheduled Classes

TOP

What You'll Learn

TOP
  • Understand the basics of the SMARTerBI™ Dashboard & Data Analysis System for Excel Power Pivot
  • Understand how Excel Power Pivot works within the Excel Workbook environment
  • Understand the relationship between Excel Power Pivot and the Excel Data Model
  • Understand the fundamentals of data modeling concepts
  • Understand how to use Excel Power Pivot to connect to external business data sources
  • Understand how to load data into the Data Model
  • Understand how to define relationships between multiple data tables
  • Understand how Excel Power Pivot works with Excel Pivot Tables and Pivot Charts

Outline

TOP
Viewing outline for:

Module 01) Exploring Business Dashboards built using Excel Power Pivot

a) Understanding the Dashboard Components

b) Using the Dashboard to answer business questions

c) Reviewing business requirements for a dashboard

d) Exploring how the Excel Power Pivot can be used to build Business Dashboards

Module 02) Getting Started with Data Modeling Concepts of the Excel Power Pivot

a) Data Workbooks

b) Data Model

c) Data Tables

d) Data Relationships

e) Data Calculations

f) Data Hierarchies

g) Data Analysis

Module 03) Getting Started with the Excel Power Pivot Environment

a) Power Pivot Editor

b) Menu Tabs

c) Data View

d) Diagram View

e) Data Tables

Module 04) Getting Started with Basic Excel Power Pivot Operations

a) Importing Data

b) Managing Data Tables

c) Defining Relationships

d) Modifying Data Column Names

e) Adding Data Columns

f) Analyzing Data with Pivot Tables & Pivot Charts

Hands-On Labs Outline

After completing this course, students will have performed the following labs:

Exercise 01) How to build a Business Tracking Dashboard using the Excel Power Pivot

a) Review business requirements for business tracking

b) Importing and modeling data using Excel Power Pivot

c) Working with the flatten Excel Pivot Table

d) Working with the Data Slicer

Exercise 02) How to build a Business Metric Dashboard using the Excel Power Pivot

a) Review business requirements for business metrics

b) Importing and modeling data using Excel Power Pivot

c) Working with the Excel Pivot Table

d) Working with the Data Slicer

Exercise 03) How to build a Business Sales Dashboard to visualize data using the Excel Pivot Chart

a) Review business requirements for business trends

b) Importing and modeling data using Excel Power Pivot

c) Working with the Excel Pivot Table

d) Working with the Excel Pivot Chart

e) Working with the Data Slicer

Prerequisites

TOP
SMARTerBI with Excel Workbooks or equivalent experience

    Who Should Attend

    TOP

    This hands-on, 1-day course is designed for business professionals and individuals interested in learning a SMARTer way to performing data modeling, data analysis and dashboard building using Excel Power Pivot.

    Next Step Courses

    TOP