Virtual Power BI Bootcamp

Start: Dec 09, 2024 9:00 AM EST
End: Dec 12, 2024 5:00 PM EST
Cost: $1,995.00
Instructor: Emily Taylor
Event Categories:
Available Seats: 5
Missed your change to sign up, but still want to get in on the fun? Contact us!
Need help convincing your boss? We can help.

Event description

Creating Business Intelligence solutions no longer has to be a long, arduous process reserved exclusively for IT professionals. Power BI empowers you to build beautifully designed reports and dashboards independently, providing instant satisfaction for your data needs. This course introduces you to the Power BI ecosystem, guiding you from data discovery to developing solutions and solving complex business problems. You’ll start by importing data and applying business rules, then organize the results into a data model with relationships and calculations. Finally, you’ll learn the best practices for visualizing your data through various charts, graphs, maps, and gauges. Additionally, you’ll explore how to deploy solutions to the Power BI Service and create dashboards accessible from any device.

Prerequisites

No prior experience with Power BI is required, but a basic understanding of data concepts will be beneficial. Ideally students should have a basic understanding of terminology such as tables, views, columns, rows, etc. This bootcamp is ideal for data analysts, business intelligence professionals, and anyone interested in leveraging Power BI for data-driven decision-making.

System Requirements

Windows 11, Windows 10, Windows 8, or Windows 7
Microsoft Power BI Desktop requires Internet Explorer 10 or greater
Microsoft Power BI Desktop is available for 32-bit (x86) and 64-bit (x64) platforms
Power BI Desktop (https://aka.ms/pbiSingleInstaller)
**Optional** Power BI Pro Subscription

Course Outline:

Module 01 – Class Introduction
- Self-Service BI Lifecycle
- Understanding the Role Self-Service BI Plays with IT
Module 02 – Data Discovery with Power BI Desktop
- Querying Overview
- Data Source Flexibility
Module 03 – Transforming Data
- Add Column From Example
- Appending Queries
- Basic Transforms
- Combine Files
- M Query Basics
- Merging Queries
- Other Query Features
Module 04 – Introduction to Modeling Data
- Why it is Important to put Data in a Data Model
- Understanding the Modeling Engine
Module 05 – Creating the Data Model
- Model Enhancements
- Modeling Basics
- What If Parameters
Module 06 – Creating Calculated Columns
- Calculated Tables
- DAX Basics
- Navigation Function
Module 07 – Creating Calculated Measures
- Measure Basics
- Time Intelligence Functions
Module 08 – Introduction to Visualizing Data
- Data Visualization Overview
- Data Visualization Best Practices
Module 09 – Creating Basic Reports in Power BI Desktop
- Creating Bar and Line Charts
- Combining Charts
- Using Filters
- Editing the Interactions Between Visuals
Module 10 – Creating Interactive Reports
- Adding Slicers for Filters
- Digital Storytelling
- Other Features
- Using Custom Visuals
- Visualizing Categorical and Trend Data Together
- Visualizing Categorical Data
- Visualizing Data Trends
- Visualizing Geographical Data with Maps
- Visualizing Goal Tracking
- Visualizing Tabular Data
Module 11 – Using Power BI Services
- Creating and Sharing Dashboards
- Deploying to the Power BI Service
- Excel Integration
- Export and Embed Options
- Setting up App Workspaces
- Subscriptions and Alerts
- Using Power BI Q&A
Module 12 – Refreshing the Data
- Installing the Data Gateway
- Refreshing Data Overview
- Scheduling a Data Refresh
Module 13 – Mobile BI (Optional)
- Designing Reports and Dashboards for Mobile
- Interacting with the Power BI Mobile App
- Power BI Mobile Overview

Add an event to your calendar

Instructor – Emily Taylor

Emily graduated from Indiana University with a bachelor's degree in elementary education and the University of North Florida with a master's degree in educational leadership. After 11 years of teaching varying grades (K-5) in Indiana and Florida, she joined the Pragmatic Works team as a Power BI Trainer. Emily's primary goal is to provide engaging trainings that help customers gain confidence using Power BI. When not in the office, Emily enjoys camping, the beach, cheerleading, and visiting family in Indiana.