
Duration
2 weeksWeekly study
4 hours
Power BI Masterclass: Beginners to Advanced (Legacy Edition – 2018)
Explore a strong foundation in Power BI
Explore how Power BI supports data-driven decision-making, from navigating the interface and preparing data to transforming messy information, creating relationships, and establishing reliable analytical models.
Discover powerful calculations from data models
Discover how data modelling, relationships, DAX and time intelligence work together to uncover valuable insights. Apply increasingly advanced calculations to strengthen your Power BI analysis and self-service BI capabilities.
Explore ways to shape insights into engaging reports
Explore report design and custom visualisations to communicate patterns, trends and insights clearly. Bring your data preparation, modelling, DAX and visualisation skills together to create a complete Power BI report.
Syllabus
Week 1
Build Your Power BI Foundation
Course overview
An introduction to the course objectives and a chance to think about how you will learn. There is also an opportunity to introduce yourself and meet fellow learners.
Power BI Foundations: From Data Preparation to Visual Reporting
In this activity, you will learn to navigate Power BI, clean and transform data, create date tables, apply advanced techniques, and prepare reliable data for effective modelling and reporting.
Power BI Modelling, DAX and Data Visualization
In this activity, you will learn Power BI relationships, calculations, DAX, context, time intelligence, and custom visualisations to transform data into meaningful insights and build interactive reports.
Week 2
Model, Calculate and Visualize with Power BI
Advanced Dax Section
In this activity, you will learn how to apply advanced DAX patterns to analyse data and answer increasingly specific business and performance questions.
Advanced DAX and Power BI Reporting
In this activity, you will learn advanced DAX for scenario analysis, running totals, customer rankings, contribution percentages and time-based insights, bringing your analysis together in a polished Power BI report.
Student questions and Teaser for Power BI Masterclass 2 Expand Excellence
In this activity, you will learn advanced DAX patterns for business questions, scenario analysis, and customer and sales insights, then complete the report and explore publishing and next steps.
Learning on this course
On every step of the course you can meet other learners, share your ideas and join in with active discussions in the comments.
What will you achieve?
By the end of the course, you‘ll be able to...
- Quickly create stunning reports in Power BI
- Transform messy data into the right format
- Generate valuable insights for yourself and your company
- Improve strategic decision making and create competitive advantages
- Write powerful advanced Dax calculations in Microsoft Power BI
Who is the course for?
This course is ideal for Professionals, data analysts, and freelancers seeking to master self-service business intelligence and create high-impact data visualizations. Career changers and ambitious employees aiming to advance their careers, gain high-demand skills, and extract valuable business insights from data.
Who developed the course?
Packt
Practical Tech Learning, Built for Where the Industry Is Heading
For over 20 years, Packt has helped technologists at every stage turn complex topics into real, usable skills. We’re a global technology learning publisher with a library of more than 9,000 hands-on tutorials, and we’re adding to it constantly.
What's included?
This is a premium course. These courses are designed for professionals from specific industries looking to learn with a smaller group of like-minded individuals.
- Unlimited access to this course
- Includes any articles, videos, peer reviews and quizzes
- Certificate of Achievement to prove your success when you're eligible
- Download and print your Certificate of Achievement anytime
Still want to know more? Check out our FAQs
Learning on FutureLearn
Your learning, your rules
- Courses are split into weeks, activities, and steps to help you keep track of your learning
- Learn through a mix of bite-sized videos, long- and short-form articles, audio, and practical activities
- Stay motivated by using the Progress page to keep track of your step completion and assessment scores
Join a global classroom
- Experience the power of social learning, and get inspired by an international network of learners
- Share ideas with your peers and course educators on every step of the course
- Join the conversation by reading, @ing, liking, bookmarking, and replying to comments from others
Map your progress
- As you work through the course, use notifications and the Progress page to guide your learning
- Whenever you’re ready, mark each step as complete, you’re in control
- Complete 90% of course steps and all of the assessments to earn your certificate
Want to know more about learning on FutureLearn? Using FutureLearn
Do you know someone who'd love this course? Tell them about it...
More courses you might like
Learners who joined this course have also enjoyed these courses.
Browse more in IT & Computer Science