Data Science and Machine Learning
Data Analysis with Python and Pandas
Analyze data like a pro. Use Python, Pandas, and NumPy to clean, transform, and explore datasets and extract meaningful…
USD 39
Data Science and Machine Learning
Power BI for Business Intelligence
Turn raw company data into clean models, accurate DAX measures and clear interactive Power BI reports that managers can rely on and use every day.
About this course
Transform raw company data into interactive reports executives actually use. Master Power Query, DAX and dashboard design in Microsoft Power BI.
What you will learn
- Clean and reshape messy data with repeatable Power Query steps.
- Design a star schema model with correct relationships and a marked date table.
- Write DAX measures using CALCULATE, iterators and time intelligence functions.
- Choose and format visuals that answer business questions clearly.
- Build interactive navigation with slicers, drill-through and bookmarks.
- Publish, share and schedule refresh for reports and dashboards in the Power BI Service.
Curriculum
Module 1Power BI Foundations4 lessons
- 1The Power BI Ecosystem Free preview
- 2Getting and Transforming Data with Power Query
- 3Data Models and Relationships
- 4Your First Report
- QModule quiz (4 questions)
Module 2DAX Essentials4 lessons
- 5Calculated Columns vs Measures
- 6Core DAX Functions
- 7Time Intelligence Basics
- 8Common DAX Patterns
- QModule quiz (4 questions)
Module 3Visualisation Craft4 lessons
- 9Choosing the Right Visual
- 10Slicers, Filters and Drill-Through
- 11Formatting for Clarity
- 12Bookmarks and Navigation
- QModule quiz (4 questions)
Module 4Sharing Insights4 lessons
- 13Publishing to the Service
- 14Dashboards vs Reports
- 15Refresh and Gateways Basics
- 16Course Project: Company KPI Report
- QModule quiz (4 questions)
PFinal project: Company KPI Report
Who this course is for
- Analysts, accountants and administrators who prepare regular reports in Excel.
- Managers who want to build their own reports instead of waiting for them.
- Career changers aiming for junior business intelligence or data analyst roles.
Requirements
- A Windows computer (or Windows virtual machine) able to run the free Power BI Desktop.
- Working knowledge of Excel, such as sorting, filtering and simple formulas.
- Optional: a work or school account for the Power BI Service to practise publishing and sharing.
What is included
Written lessons
16 lessons, each with a practical exercise and key points to remember.
Module quizzes
A short quiz at the end of each module. Pass mark 70%, and you can retake it.
Final project
Company KPI Report. A practical brief with steps and a way to check your own work.
Certificate
A certificate of completion from EMFAD Courses with a unique code anyone can verify.
How the certificate works
Complete every lesson and pass every module quiz with 70% or more. Your certificate then appears in your learner area, ready to print or save as PDF. It shows your name, the course title, the completion date and a unique code. It is a certificate of completion from EMFAD Courses, not an accredited qualification.
More in Data Science and Machine Learning
All →Data Science and Machine Learning
Data Science Fundamentals
Enter the world of data. Learn the data science workflow, tools, and thinking needed to turn raw data into valuable insights.
USD 49
Data Science and Machine Learning
Data Visualization with Tableau
Tell stories with data. Build interactive dashboards and charts in Tableau that make complex information clear and…
USD 39