Power BI Bootcamp

Power BI Bootcamp

2,775.00

This Power BI Bootcamp is a fast-paced 4 day training course designed to get students up to speed on Microsoft's evolving Power BI Platform. Learn how to understand and analyze data, create reports, use BI data queries and more. Enroll now!

Date:
Delivery Method:
Quantity:
Purchase Now

GSA Checkout → GSA

Course ID: B3706

Duration: 5 Days (9:00 am - 4:00 pm PST) 

Location: Flex - San Francisco or Live Online | Click here to schedule private course.

Overview:

Self-Service Business Intelligence is quickly gaining in popularity in all industries. The pressure to incorporate new interactive reporting and dashboarding is growing. The problem is in understanding how to add Self-Service Business Intelligence into your existing reporting solutions in the most effective manner. In this course, you will learn what it takes to plan a managed Self-Service Business Intelligence solution, how to write governance policies to support it, and how to properly plan for maintenance, security, and update needs.

+ Who Should Attend

Report Builders, Power BI Tools, Data Model Designers, and DAX Functions.

+ Course Outline

Lesson 1 : Introducing PowerPivot

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

Lesson 2 : Defining a Report

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

Lesson 3 : Understanding PowerPivot Data

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

Lesson 4 : Create Reports using PowerPivot Data

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

Lesson 5 : Creating PowerPivot Functions

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

Lesson 6 : Introducing Power BI Tools

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

Lesson 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

Lesson 8 : BI Data Query Basics

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

Lesson 9: Query Editor Transformations

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

Lesson 10 : Power Map for Excel

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

Lesson 11 : Understanding BI Data

  • Business Intelligence Data Sources
  • Data Source Types
  • Table Roles

Lesson 12 : Creating Data Models

  • Creating a Data Model from Excel Data
  • Creating a Data Model from Access Database Data
  • Creating a Hybrid Data Model

Lesson 13 : Using DAX Functions

  • Review of Syntax and Calculated Columns
  • Best Practices
  • DAX Measures
  • Creating Measures (Calculated Fields)

Lesson 14 : Using Dates Correctly

  • Why Dates are Different
  • Building Data Tables
  • Building Data Hierarchies

Lesson 15 : Appendix: Shaping Reports

  • Building Communication Worksheets
  • Controlling Item Ordering
  • PowerPivot Metadata

Lesson 16 : Basic DAX Functionality

  • Review Of Calculated Columns
  • PivotTable Functions
  • Review Of Measures
  • Rules Of DAX Measures
  • Evaluation Context
  • Formatting DAX Code

Lesson 17 : Controlling Content & Values

  • Controlling Values
  • Switch Function
  • Error Handling

Lesson 18 : Context Control Functions

  • Iterative Functions
  • Filter Function
  • All Function
  • Earlier Function
  • Calculate Function

Lesson 19 : Contexts In Relationships

  • Working With Many Tables
  • Row Context & Relationships
  • Filter Context & Relationships
  • Values Function

Lesson 20 : Time Intelligence Calculations

  • Working With Date Tables
  • Calculating Operating Periods
  • Working With Missing Periods
  • DAX Date Functions
  • Advanced Date Functions
  • Prior Year Functions
  • Moving Averages

Lesson 21 : Appendix: Advanced Concepts

  • Circular Dependencies
  • Controlling Totals
  • Advanced Hierarchy Concepts
  • Additional Uses Of The All Function

Lesson 22 : Appendix: DAX Dashboard Techniques

  • Parameter Tables
  • Banding
  • Ranking
  • Advanced Slicer Techniques

 

+ Prerequisites

Excel Introduction and Intermediate, including PivotTable & Pivot Chart skills; plus a basic understanding of database concepts.

+ Certifications

N/A