Boot Camp:Intro to Excel Power BI Tools

IntroductoryBoot Camp2 DaysVersion 365Official CPE Provider

Turn raw data into clear, interactive dashboards and reports with hands-on Power BI training.

Course Objective

• Introduction to Power BI using Power Query, Power Pivot, Power Maps, Power View and Power BI Desktop •

Prerequisites

To ensure your success, we recommend that you first take Excel Level 1, Level 2, and In-Depth PivotTables, or have equivalent knowledge and skills - such as knowledge of advanced features and functions. What is included? Hands-On Training

Course Outline

1 lessons · 56 topics

Day 3

1Day 3 - Class Times 8:30AM - 5:00PM

Power View
Getting Started with Power View
Power BI Tools Overview
Enable the Power View Add-in
Power View Environment
Power View Components
Data Sources
Tables in Power View
Add and Delete a Table
Modifying a Table
Table Types
Sort and Drill Down
Power View Visualization
Format Tiles
Insert & Delete Slicers
Themes and Backgrounds
Insert Graphics & Text Boxes
Report and Interact with Power View
Tiles
Filter Options
Insert, Delete and Modify Charts
Chart Types
Drill Down on Charts
Power BI Desktop
Introduction to Power BI Desktop
Understand the Power BI Desktop Interface
Utilize the File Types; PBIX vs. PBIT
Examine Data Sources
Data Refresh
Working with Different Data Types
Power Map
Getting Started with Power Map
Power Map Overview
Power Map Environment
Data Source
Launch and Navigate Options through Power Map
Create a Power Map
Create and Delete Tours
Scene Settings and Options
Add and Use Layers
Layer Manager
Organizing the Source Data in Power Maps
Work with Tables and Filters
Field List Options
Geography
Mapping Options (Column, Bubble, Heat, and Region)
Value, Time, Categories
Visualization for Power Maps
Work and Modify Themes
Map Display Options
Insert Graphical Contents (Charts, Text Boxes, Legends)
Play Power Map
Run Power Map Tours
Copy a Power Map Tour
Export a Power Map to Video
Save Options

Excel Solutions Team
Kirkwood Tower, 11757 Katy Fwy, Suite 1300, Houston, TX 77079
(713) 589-2655 · contactinfo@excelsolutionsteam.com · excelsolutionsteam.com

Official CPE Provider (TX State Board of Public Accountancy)
BBB Accredited since 2006 · 20+ years training Houston professionals