Boot Camp: Intro to Excel Power BI Tools
A hands-on boot camp on the Power BI tools built into Excel. Turn worksheet data into interactive Power View reports and striking 3-D map visualizations, and get your first real look at Power BI Desktop.
Scheduled dates
This course is available for private and onsite training - delivered for your team anywhere in the U.S., or virtually on your schedule. You can also ask us to add it to the public calendar, or let us know you’re interested and we’ll reach out when a date is set.
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
- 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