MORE THAN JUST A COURSE
Power BI Beginner
Course Overview
This Beginner’s Power BI course is designed to give new and prospective Power BI users the skillset and experience necessary to create Power BI data models, reports, and dashboards. During this class students will connect to a data source, transform data, organize a data model, create measures to summarize their data, and express their data using Power BI visualizations. At the end of this course, attendees will have a playbook for tackling a full end-to-end Power BI project. This course can be taught over a 2-day period.
Course Objective
- Consuming example Power BI reports and dashboards
- Extracting, transforming, and loading data using the Power Query Editor tool
- Setting up a Star Schema data model
- Creating, formatting, and organizing basic measures using DAX language
- Selecting and formatting visuals according to practical and aesthetic best practice
- Pushing a report to Power BI services and creating a dashboard
- Connect to various data sources
- Module 1: Exploring PBI Services Service
-
- Key Power BI Concepts and Terms
- Power BI Report Capabilities and Features
- Power BI Dashboard Capabilities and Features
- Module 2: Making A Report and Dashboard
-
- Data Storytelling Best Practices and Mistakes to Avoid
- Report editing and building
- Visual selection and page formatting
- Dashboard Use Cases
- Tile Pinning
- Guided Report and Dashboard Building Exercise
- Module 3: Power BI Desktop Tour
-
- Desktop Views
- Report
- Data
- Model
- Taskbar
- Home
- Insert
- Modeling
- View
- Module 4: Import and Transform Data
-
- Power Query Editor Capabilities
- Extract
- Transform
- Load
- Common connectors
- Power Query Panes
- Query
- Data
- Query Settings
- Taskbar Review
- Home
- Transform
- Add Column
- View
- Module 5: Star Schema Table Relationships
-
- Manage Relationships
- Star Schema Breakdown
- Configuring Relationships
- Cardinality
- Direction
- Module 6: Creating, Formatting, and Organizing DAX Measures
-
- Create Measures Using DAX
- Create Columns Using DAX
- Using Quick Measures Feature
- Filtering
- Key Aggregations
- Totals
- Averages
- Counts
- Formatting
- Organizing IN Measures Folder
- Module 7: Visual Selection and Report View Creation
-
- Fundamental Report Visuals and Their Use Cases
- Unguided Report Creation
- Show and Tell: Report Build Idea Pooling
- Module 8: Publish Report To PBI Services and Make Dashboard
-
- Develop Dashboard From Report Build
- Module 9: Capstone
-
- End to End Build From Dataset
- Data Model
- Report
- Dashboard
have any questions or concerns?
Start Today With A Free Quote
As you are reading this, the world of data analytics is evolving. Make sure your team is up to date with our practical, insights-focused data analytics training. Start now with a free, no-obligation quote.
Other Courses
