- Level Foundation
- Duration 14 hours
- Course by Knowledge Accelerators
-
Offered by
About
New Power BI users will begin the course by gaining a conceptual understanding of the Power BI desktop application and the Power BI service. Learners will explore the Power BI interface while learning how to manage pages and understand the basics of visualizations. Learners can download a course dataset and engage in numerous hands-on experiences to discover how to import, connect, clean, transform, and model their own data in the Power BI desktop application. Learners will investigate reports, learn about workspaces, and practice viewing, creating, and publishing reports to the Power BI service. Finally, learners will become proficient in the creation and utilization dashboards.Modules
Welcome to Week 1
2
Videos
- Welcome to Data-Driven Decisions with Power BI!
- Introduction to Power BI
3
Readings
- A Note on Power BI Email Compatibility
- Introductory Material
- STOP: Retrieve a Course Sample Dataset
Lesson 1: Understand Power BI
2
Discussions
- Dive Into the Data: Reflect on What You Have Learned
- Dive Into the Data: Check Your Power BI License
2
Videos
- Overview of Power BI
- Understand Power BI Licenses
1
Readings
- Understand Power BI
Lesson 2: Import Data into Power BI
1
Peer Review
- Get Started on Your Own Power BI Report!
7
Videos
- Import Data or Connect to a Data Source
- Import a File from Excel
- Import Data from a Web Page
- Use Get Data to Connect to Data Sources
- Connect to a Power BI Dataset
- Try a Sample Dataset from Power BI Desktop
- Practice with Sample Datasets from Power BI Service
Lesson 3: Understand the Table/Data View
1
Assignment
- Review: Lessons 1-3
1
Discussions
- Dive Into Your Data: View and Edit a Report in Data View
3
Videos
- Understand the Table View
- Overview of the Data View in Power BI
- Week 1 Check-In
Lesson 4: Clean and Transform Data
1
Assignment
- Final Quiz: Week 1 Review
1
Discussions
- Dive Into the Data: Replace Errors, Clean Data and View the Applied Steps List
6
Videos
- Clean and Transform Data
- Access the Power Query Editor
- Overview of the Applied Steps List in Power Query Editor
- Execute Basic Math Operations to a Column
- Round Values in a Column
- Replace Errors in a Column
Welcome to Week 2
1
Videos
- Introduction to Data Modeling, Report View, and Visualizations
Lesson 1: Understand the Model View
1
Discussions
- Dive Into the Data: Observe Relationships Between Tables
2
Videos
- Understand the Model View
- Overview of the Model View in Power BI
Lesson 2: Work with Relationships in Model View
1
Assignment
- Model View Knowledge Check
1
Peer Review
- View a Report in Model View
4
Videos
- View Relationships in the Model View
- Edit or Remove Relationships
- Add a New Relationship Between Tables and Columns
- Week 2 Check-In
1
Readings
- View, Add and Edit Relationships in Model View
Lesson 3: Understand the Report View and Visualizations
1
Discussions
- Dive Into the Data: Customize Report Visualizations in Report View
5
Videos
- Understand the Report View
- Overview of the Report View in Power BI
- Add a Visualization
- Overview of Format Features for Visualizations
- Change the Visualization Type
1
Readings
- Adding Visualizations to Report Canvases
Lesson 4: Understand, Create and Format Text Visualizations
1
Assignment
- Week 2 Final Review
4
Discussions
- Dive Into the Data: Create and Format a Visualization Card
- Dive Into the Data: Create and Format a Table Visualization
- Dive Into the Data: Create and Format a KPI Chart
- Dive Into the Data: Create and Format a Key Influencers Chart
9
Videos
- Understand Text Visualization Types
- Create a Visualization Card
- Format a Visualization Card
- Create a Table Visualization
- Format a Table Visualization
- Create a KPI Chart
- Format a KPI Chart
- Create a Key Influencers Chart
- Format a Key Influencers Chart
Welcome to Week 3!
1
Readings
- Introduction to Navigating Reports and Visualizations
Lesson 1: Create and Format Chart Visualizations
6
Discussions
- Dive Into the Data: Create and Modify a Scatter Chart
- Dive Into the Data: Create a Gauge Chart
- Dive Into the Data: Create and Modify a Funnel Chart
- Dive Into the Data: Create and Modify a Ribbon Chart
- Dive Into the Data: Create and Modify a Map Visualization
- Discussion Prompt: Reflect on Data-Driven Decision Making
12
Videos
- Intro to Chart Visualizations
- Create a Scatter Chart
- Modify Scatter Chart Analytics
- Create a Waterfall Chart
- Create a Gauge Chart
- Create a Funnel Chart
- Format a Funnel Visualization
- Create a Ribbon Chart
- Format a Ribbon Chart
- Use Geospatial Map Visualizations
- Use Map Visualizations
- Week 3 Check-In 1
Lesson 2: Connecting Visualizations and Queries
1
Assignment
- Week 3 Lessons 1 and 2 Review
2
Discussions
- Dive Into the Data: Practice Creating a New Table Query
- Dive Into the Data: Experiment with Q&A Visualizations
5
Videos
- Turn Questions into Answers with Custom Visualizations
- Create a New Table Query
- Turn a Question into a Visualization
- Create and Teach a Q&A Visualization
- Add Suggested Questions to a Q&A Visualization
Lesson 3: Gain Insights with Filters and Drillthroughs
1
Assignment
- Filters Review
4
Discussions
- Dive Into the Data: Create a Slicer
- Dive Into the Data: Perform a Filter Task
- Dive Into the Data: Practice Data Drilling
- Dive Into the Data: Practice Exporting Data From Visualizations
8
Videos
- Filters, Slicers, and Data Drilling
- Create a Slicer
- Explore the Filters Pane
- Filter a Field
- Analyze Your Visualization
- Drill Down and Drill Up in a Visualization
- Format a Matrix
- Export Data from Visualizations
Lesson 4: Publish Reports
1
Assignment
- Final Quiz: Week 3 Review
1
Discussions
- Dive Into the Data: Publish Your Report
3
Videos
- Introduction to Report Publishing
- Publish a Dataset or Report
- Week 3 Check-In 2
Welcome to Week 4
1
Videos
- Introduction to Power BI Service
Lesson 1: Get Started with Workspaces
3
Discussions
- Dive Into the Data: Check Out Your My Workspace!
- Dive Into the Data: View Access Permissions
- Dive Into the Data: Explore Your Workspaces
5
Videos
- Introduction to Workspaces
- View My Workspace in the Power BI Service
- View Workspaces in the Power BI Service
- View the Access Permissions
- Share a Workspace
Lesson 2: Work with Dashboards
1
Assignment
- Lesson 1 and 2 Review
3
Discussions
- Dive Into the Data: Explore Dashboards
- Dive Into the Data: Add or Pin a Tile to a Dashboard
- Dive Into the Data: Practice Pinning and Subscribing
10
Videos
- Introduction to Working with Dashboards
- Overview of Dashboards
- Create a New Dashboard
- Add a Tile to a Dashboard
- Pin a Tile from a Report
- Pin a Live Page
- Pin the Whole Report Page as a Live Tile
- Subscribe to a Power BI Dashboard
- Share a Report Via Email
- Week 4 Check-In
Lesson 3: Datasets and Reports
3
Videos
- Change the View in a Dataset
- Download a Copy of a Report
- Generate Quick Insights for a Report
1
Readings
- Use Datasets and Reports
Lesson 4: Work with Apps
1
Discussions
- Dive Into the Data: Practice with Apps
3
Videos
- Introduction to Apps
- Connect to Apps
- Create App Workspaces
1
Readings
- App Creation Additional Reading
Lesson 5: Integrate with Microsoft Suite
1
Assignment
- Week 4 Review
1
Peer Review
- Reflect on Power BI Service
3
Discussions
- Dive Into the Data: Practice Integrating Power BI and Teams
- Dive Into the Data: Embed Reports in SharePoint Online
- Dive Into the Data: Download and Install Analyze in Excel
7
Videos
- Power BI and Microsoft Integration
- Understand Power BI and Microsoft Teams Integration
- Share a Report To a Teams Channel
- Start a Teams Chat From a Slicer in Power BI
- Embed Reports in SharePoint Online
- Export a Report to PowerPoint
- Power BI: Download and Install Analyze in Excel
1
Readings
- The Power Platform
Final Review
1
Assignment
- Final Course Review
1
Videos
- Congratulations!
2
Readings
- Note: Final Review
- Final Note
Auto Summary
Unlock the power of data-driven decision-making with "Data-Driven Decisions with Power BI," a comprehensive course designed for new Power BI users. This foundational course, offered by Coursera, falls under the Business & Management domain and provides a detailed exploration of both the Power BI desktop application and the Power BI service. Throughout the course, learners will develop a solid conceptual understanding of Power BI, including its user interface, page management, and visualization basics. The course is rich with hands-on experiences, allowing learners to download a course dataset and practice importing, connecting, cleaning, transforming, and modeling data within the Power BI desktop application. Participants will delve into report investigation, workspace management, and the processes involved in viewing, creating, and publishing reports to the Power BI service. The ultimate goal is to enable learners to become proficient in both creating and utilizing dashboards effectively. Spanning approximately 840 minutes, this course is ideal for anyone looking to build a strong foundation in Power BI, from business professionals to data enthusiasts. With the Starter subscription option, learners can access all the necessary tools and resources to enhance their data analysis skills and make informed business decisions with confidence.

Keith Gibson