Microsoft® Power BI® for Data-Driven Decision Makers
As data acquisition, access, analysis, and reporting are interwoven with our businesses and lives, more and more data is collected about business and personal activities. This abundance of data and the computing power to analyze it has increased the use of data analysis and data visualization across a broad range of job roles. Decision makers of all types, including managers and executives, must interact with, interpret, and develop reports based on data and analysis provided to them.
Microsoft® Power BI® software is designed for data analysis and the creation of visualizations. Data analysts prepare data, perform initial analysis, and create visualizations that are then passed to business data decision makers. These decision makers can use Power BI's tools to explore the data, perform further analysis to find new insights, make decisions, and create customized reports to share their findings.
In this course, you will explore, analyze, and customize reports and visualizations in Power BI to discover new insights, showcase those insights, and share them. You will:
- Explore Power BI reports.
- Analyze data to get answers and insights.
- Sort and group data for analysis and reporting.
- Filter visualizations.
- Prepare reports.
- Troubleshoot, collaborate, and share reports.
To ensure your success in this course, you have experience managing data with Microsoft® Excel® or Google Sheets™, which you could obtain by taking the following United States Career Campus courses:
- Microsoft® Excel® for Office 365 (Desktop or Online): Part 1
- Using Google G Suite™
- Microsoft® Windows® 10
- Microsoft® 365 Business Premium (Trial)
NOTE: Students will need to be provided with a Microsoft 365 Business Premium trial email address that they can access during the course.
- Microsoft® Excel® for Office 365™/2019
- Microsoft® PowerPoint® for Office 365™/2019
- Microsoft® Power BI® Desktop, latest version
- Any web browser.
- Students will need a valid work or school email address that they can access during the course.
- If necessary, software for viewing the course slides. (Instructor machine only.)
For this course, you will need one computer for each student and one for the instructor. Each computer will need the following minimum hardware configurations:
- Sufficient processor speed, RAM, and storage space for good system performance when running Windows.
- Mouse, keyboard, and monitor.
- High-speed, stable Internet connection.
- For the instructor's computer, a method to project and/or share the screen as needed for local and remote class participants.
Lesson 1: Exploring Power
BI Reports
Topic A: Data Analysis
Workflow with Power BI
Topic B: Explore
Reports in the Power BI Service
Topic C: Edit Reports
Lesson 2: Analyzing Data
to Get Answers and Insights
Topic A: Configure
Data Visualizations
Topic B: Ask New
Questions by Changing Aggregation
Topic C: Find Answers
with Calculations
Lesson 3: Sorting and
Grouping Data for Analysis and Reporting
Topic A: Sort Data
Topic B: Group Data
Lesson 4: Filtering
Visualizations
Topic A: Filter Data
to Refine Analysis
Topic B: Create
Slicers for Reports
Lesson 5: Preparing
Reports
Topic A: Format and
Annotate Reports
Topic B: Emphasize
Data in Reports
Lesson 6: Troubleshooting,
Sharing, and Collaborating
Topic A: Troubleshoot
Data Issues
Topic B: Collaborate
in Power BI
Topic C: Collaborate
with Non-Power BI Users
Appendix A: Best Practices
for Visual Design