Microsoft Power BI Bootcamp: Transforming Data to Dashboards

Enroll in this training and receive a one-month complimentary e-learning subscription with access to 40+ courses.

This course is provided by Big Data Trunk for Stanford Technology Training Program but a limited few seats available to the public.

Students of this class may have opportunity to be considered for Internship with Big Data Trunk.

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