Microsoft Power BI Bootcamp: Transforming Data to Dashboards

Most Technology Training classes will be delivered online until further notice.

Before each sesson, Tech Training will provide a Zoom link for live online classes, along with any required class materials.

This course covers everything from the basics to practical projects. Our hands-on labs ensure you gain real-world experience, and you will leave with the ability to connect to organizational data and create impactful dashboards.

Prerequisites:

- Basic understanding of Databases

Learning Objectives:

- Understand the Power BI ecosystem, including its tools and workflow.
- Extract data from diverse sources such as Excel, CSV, SQL, and the web.
- Master data cleaning and transformation using the Power Query Editor.
- Create reports and visualizations in Power BI Desktop.
- Develop data models with relationships and calculated measures.
- Explore advanced visualizations like maps and custom visuals.
- Utilize filters, slicers, and drill-through options for data exploration.
- Build and format dashboards for effective data storytelling.
- Participate in hands-on project labs to apply your skills.
- Learn about security, app creation, and data connections in Power BI.

Course Outline:
Day-1
Introduction
- What is Power BI?
- What are the Key Tools?
- Typical Workflow
- Power BI Terminology

Extracting Data
- Extracting the data (Excel, .csv, SQL, web)
- Transforming the Data
- Exploring the Power Query Editor
- Applied Steps
- Working With Queries
- Applying Transformations
- Loading Queries

Power BI Desktop Interface
- Report
- Visualizations
- Fields and Filtering
- Formatting and Analytics

Exploring the Data View
- Categorizing Geographical Data
- Formatting Dates
- Controlling Summarization Behavior

Reviewing the Data Model
- What is a Data Model?
- Examine Existing and Creating New Relationships

Measures and Calculated Columns
- Creating Calculated Columns
- Creating simple DAX measures
- Creating a Date Table
- Creating a Dates Table

Day-2
Explore the Visualization Menu

Review a Sample Report
Develop a Report Storyboard
Create and Format Visuals and Pages
- Column and Bar
- Pie
- Adding Pages
- Line
- Matrix
- Formatting Pages
- Maps
- Other Available Visuals

Drill Through Relationships
Using Filters and Slicers
Using Custom Visuals & the Marketplace

- Organizational Visuals
- Additional Page Elements

Create Other Objects in Reports
- Buttons
- Shapes
- Images
- Bookmarks

Publishing the Report
- Establishing a Workspace
- Personal and App Workspaces

Introducing Power BI Service
- App Workspaces
- Create and Format Dashboards
- Get Data
- Update Dashboard

Create and Maintain Apps
- Setting Security
- Finding other Apps
- Connect to organizational data
- Project Labs