Launch your career as a Power BI analyst. Build job-ready skills – and must-have AI skills – for an in-demand career. Earn a credential from Microsoft. No prior experience required.
- Learn to use Power BI to connect to data sources and transform them into meaningful insights.
- Prepare Excel data for analysis in Power BI using the most common formulas and functions in a worksheet.
- Learn to use the visualization and report capabilities of Power BI to create compelling reports and dashboards.
- Demonstrate your new skills with a capstone project and prepare for the industry-recognized Microsoft PL-300 Certification exam.
-1976d2?style=for-the-badge){kind=icon}
- ACE® College Credit: Eligible for up to 5 US semester credits via ACE recommendation
- FIBAA (ECTS) Certified: Earn 8 ECTS credits recognized by European universities
- Industry-Relevant & Trusted: Microsoft-designed curriculum (used by 97% of Fortune 500 companies)
- Microsoft PL‑300 Certification: Completers receive a 50% exam voucher for PL‑300 Microsoft Power BI Data Analyst Associate
-
Preparing Data for Analysis with Microsoft Excel
- Create data in Microsoft Excel and prepare it for data analysis.
- Make use of common formulas and functions in a worksheet.
- Prepare Excel data for analysis in Power BI using functions.
-
Harnessing the Power of Data with Power BI
- How to recognize and use the key data analysis components of Microsoft Power BI.
- Understand a Power BI data analyst's skills, tasks, and tools.
- Describe the different stages in the data analysis process that result in data-driven decisions.
-
Extract, Transform and Load Data in Power BI
- How to set up a data source and explain and configure storage modes in Power BI.
- How to prepare for data modeling by cleaning and transforming data.
- How to use profiling tools to identify data anomalies.
- How to reference queries and dataflows and use the Advanced Editor to modify code.
-
Data Modeling in Power BI
- How to form a model using a Star Schema.
- How to write calculations DAX to create elements and analysis in Power BI.
- How to optimize performance in a Power BI model.
-
Data Analysis and Visualization with Power BI
- How to add visualizations to reports and dashboards.
- How to design accessible reports and dashboards.
- How to use visualizations to perform data analysis.
-
Creative Designing in Power BI
- How to create compelling and cohesive reports and dashboards.
- How to work in detail with specialist chart visualizations.
- How to add elements such as videos, streaming data and QR codes to dashboards.
-
Deploy and Maintain Power BI Assets and Capstone Project
- How to create and publish an app in Power BI.
- How to implement dynamic reports in Power BI.
- How to implement security measures and alerting in a Power BI report or dashboard.
-
Microsoft PL‑300 Exam Preparation and Practice
- Prepare the data with Power BI.
- Model, visualize, and analyze the data in Power BI.
- How to deploy and maintain Power BI assets.
This repo is open source! Feel free to:
- 👀 Browse the course readings, exercises, and case studies
- 💻 Fork/clone for your own self-study or review
- 🤝 Collaborate by submitting issues or improvements via pull requests
- 🌟 Get inspired if you’re preparing to be a data professional or want to level up your data skills
Disclaimer: All content is for educational purposes only and is shared to help aspiring data professionals. Please don’t submit this work as your own in graded assessments—let’s keep it ethical!
✨ I’m always open to networking, collaboration, or sharing insights ✨
Don’t be shy — connect with me on LinkedIn! 👋
