Course Outline
Lesson 1: Analyzing Data and Reporting with Power BI
- Data Analysis and Visualization for Business Intelligence
- Interact with Reports in Power BI
Lesson 2: Connecting to Data
- Create Data Source Connections
- Configure and Manage Data Relationships
- Save Files in Power BI
- Secure and Troubleshoot Connections
Lesson 3: Cleaning, Transforming, and Loading Data
- Load, Clean, and Shape Data with the Query Editor
- Profile Data with the Query Editor
- Shape Data with the Query Editor
- Transform Data with the Query Editor
Lesson 4: Visualizing Data with Power BI
- Create Visualizations in Power BI
- Select Visualization Types with Power BI
Lesson 5: Enhancing Visuals for Data Analysis
- Customize Visuals and Pages
- Incorporate Tooltips in Visualizations
Lesson 6: Modeling Data with Calculations
- Create Calculations with DAX
- Create Calculated Measures and Conditional Columns
Lesson 7: Customizing and Filtering Reports
- Create Data Hierarchies
- Filter Reports
- Discover Time-Intelligence Insights
- Configure Slicers for Interactive Filtering
Lesson 8: Performing Advanced Analysis
- Create Calculated Tables, Variables, and Parameters
- Perform Statistical Analysis
- Analyze Data with Advanced Power BI Features
Lesson 9: Sharing Reports and Creating Dashboards in the Power BI Service
- Publish and Explore Reports in the Power BI Service
- Create Dashboards
- Add Q&A to Dashboards
Lesson 10: Managing and Collaborating in the Power BI Service
- Manage Workspaces and Share Content
- Collaborate with the Power BI Service
Lesson 11: Enhancing Reports and Dashboards
- Optimize Usability and Performance
- Create Mobile Reports for Power BI
Learner Outcomes
After completing this course, you will be able to:
- Analyze data with self-service business intelligence.
- Connect to data sources.
- Perform advanced data modeling and shaping.
- Visualize data with Power BI.
- Enhance data analysis.
- Model data with calculations.
- Customize and filter visualizations.
- Use advanced analysis techniques.
- Share reports and create dashboards in the Power BI service.
- Manage and collaborate in the Power BI service.
- Enhance reports and dashboards.
Suggested Prerequisites
- Experience managing data with a spreadsheet program such as Microsoft Excel.
- An understanding of relational databases is recommended.
Questions? Speak with our team today—email info@workforcecenter.slu.edu or call 314-977-3226.
Certificate Pathway
Want to Earn the Data Analyst I Professional Certificate?
In addition to Microsoft Power BI: Data Analysis Professional | MSO140, enroll in two of the following electives: