Microsoft Power BI Super User MS-55400 Training Plan: Detailed Modules
Module 1: An Introduction to Power BI
- What is business intelligence?
- Introducing Power BI
- Power BI tools and services
- Power BI Report Server
- Power BI (Online)
- Power BI Desktop
- Case studies
- Support and information
- Data stories
Module 2: Requirements Gathering
- Welcome to House Rules Board Games
- Beginning a BI project
- Grain statements
- Data discovery
- Refining information
- Modeling data
Building reports - Roles
- Publishing
- Creating dashboards
- Choosing workspaces
- Create and share a report in Power BI
- Lab A: Build a report in Power BI web
Module 3: Extract, transform and load data
- Creating a project with Power BI desktop
- Pinning an active project
- What is in a PBIX file?
- Connecting to data sources
- Managing data connections
- Refine data with Power Query
- Applied steps
- M code language
- Designing your query
- Choose columns
- Rename columns
- Moving columns
- Formatting columns
- Replacing values
- Expanding related columns
- Star schemas
- Merge columns
- Split columns
- Custom and conditional columns
- Lab B: Starting a project in Power BI desktop
Module 4: Creating a data model
- Understanding relationships
- Cardinality
- Cross filter direction
- Hiding tables and columns
- Formatting columns
- Introducing DAX
- Designing calculated columns
- Creating measures
- Adding lookup tables
- Structuring data with dimensional hierarchies
- Roles and row level security
- Lab C: Designing a data model
Module 5: Designing Reports
- Adding pages and navigation buttons
- Using shapes, text and images
- Creating a theme
- Adding visualizations
- Using filters and slicers
- Controlling filters
- Adding drill throughs
- Adding custom visualizations
- Configure phone layouts
- Report tips
- Lab D: Creating a report
Module 6: Using workspaces and dashboards
- Power BI licensing
- My workspaces
- App workspaces
- Premium capacity workspaces
- Creating a new workspace
- Publishing a project
- Parallels with Microsoft Excel
- Publishers and viewers
- Reconnecting with data sources
- Introducing the on-premises data gateway
- Scheduling the data refresh frequency
- Assigning security roles
- Creating and populating dashboards
- Customising dashboard tiles
- Creating tiles using Q&A and quick insights
- Creating a mobile dashboard
- Sharing reports and dashboards
- Publishing apps in a workspace
- Publishing content to websites
- Lab E: Publish and share reports and dashboards
Recommended prerequisite knowledge
- Basic Data Management: Prior experience manipulating and analyzing data with spreadsheets such as Microsoft Excel or Google Sheets is recommended (using simple formulas, filters, and tables).
- Awareness of Decision-Making Logic: A general understanding of business needs and the value of leveraging data to guide decision-making within an organization.
- No Power BI Prerequisites Required: No prior knowledge of Microsoft Power BI or complex data modeling is required. This 2-day course is designed to take users from the basics to an expert (Super User) level.
Power BI Training for Super Users
The Microsoft Power BI Super User course (MS55400) provides professionals, analysts, and managers with hands-on, in-depth training in Microsoft Power BI, one of the most powerful business intelligence tools for data visualization and analysis. This course teaches you how to leverage the entire Power BI ecosystem to transform raw data into actionable insights to drive your business and make informed strategic decisions.
Ideal for users aspiring to become Super Users, this course focuses on data extraction and transformation with Power Query, modeling using DAX, and creating impactful interactive reports to optimize organizational performance and foster a true data-driven culture.
Why choose the Microsoft Power BI Super Users (MS55400) training?
In a data-driven world, the ability to effectively analyze and interpret information is essential for staying competitive. Power BI simplifies data collection, transformation, and visualization, enabling decision-makers to better understand trends, identify opportunities, and make informed decisions. This training provides you with the tools you need to leverage data and improve your organization’s results.
Skills developed during training
Our MS55400 course provides an in-depth understanding of Microsoft Business Intelligence tools and enables you to develop essential practical skills:
Understanding the Power BI ecosystem and requirements gathering
Learn how Power BI tools (Desktop, Web Service, Report Server) work and clearly define the decision-making objectives of your projects (Grain statements).Extracting, cleaning, and transforming data (ETL)
Connect to a wide variety of data sources (Excel, SQL databases, Azure) and use Power Query to structure, transform, and enrich your raw data.Data modeling and DAX calculations
Build powerful data models by organizing relationships between tables (star schema) and create calculated columns and custom measures using the DAX language.Visual and interactive report design
Create engaging report pages with responsive charts, slicers, dynamic filters, navigation buttons, bookmarks, and mobile-optimized layouts.Row-level security (RLS) deployment
Apply role-based security policies to control data visibility based on user profiles.Publish, manage, and share in the Power BI service
Publish your projects to workspaces, create interactive dashboards, configure automatic refresh via gateways, and securely share your analyses.
Interactive, Instructor-Led Training
This MS55400 course is led by data experts who combine theory, practical demonstrations, and interactive workshops. Through real-world case studies and guided hands-on sessions using Power BI Desktop and the online service, you’ll learn to immediately apply data extraction, DAX modeling, and report creation methods in business scenarios.
Upon completion of the course, you’ll have the practical skills to structure reliable data models, design impactful decision-making dashboards, and support your organization’s adoption of Power BI.
Who is this training for?
This training is for any professional who wants to leverage the potential of Power BI to explore, model, and visualize data to inform decision-making:
- IT professionals and support technicians: Those wishing to gain complete mastery of the Power BI suite and support the deployment of business intelligence tools within their organization.
- Data analysts and junior consultants: Those wanting to structure their data extraction methods and master modeling and creating measures using the DAX language.
- Managers and decision-makers: Those seeking to better leverage business data, design their own interactive reports, and make decisions based on reliable analysis.
- Super Users and project managers: Those wishing to bridge the gap between business needs and technical modeling while fostering a data-driven culture within their teams.
Put data at the heart of your decisions
The Microsoft Power BI Super User course (MS55400) equips you with the skills to master the Power BI ecosystem, transform raw data into powerful models, and gain immediate actionable insights. By learning how to clean your data sources with Power Query, design custom DAX measures, and publish interactive dashboards, you’ll be able to effectively manage your business and accelerate your organization’s digital transformation.
Register today to acquire the essential skills of an expert user and propel your career as an analyst or decision-maker!
Frequently Asked Questions - Microsoft Power BI Super User Training (MS55400) (FAQ)
The course covers the introduction to the Power BI ecosystem, BI requirements gathering, data extraction and transformation with Power Query, data modeling (star schema, calculations and measures in DAX language), designing interactive reports with advanced filters and visuals, implementing row-level security (RLS), and publishing and sharing dashboards via the Power BI web service.
This training is aimed at IT professionals, junior analysts, managers, decision-makers and users wishing to become experts (Super Users) in the use of Power BI to explore data and design their own decision-making reports.
No prior experience with Power BI is required. Basic experience in data manipulation using a spreadsheet program such as Microsoft Excel or Google Sheets is simply recommended.
You will primarily use Power BI Desktop for preparing, modeling and creating reports, the Power BI (Online) Service for publishing, managing workspaces and dashboards, as well as Power Query Editor and the DAX language.
Yes. The course combines theory and guided practical workshops (labs). You will complete exercises in data connection, query cleaning, DAX measure creation, and interactive dashboard design based on real-world use cases.
It allows you to develop complete autonomy over the entire Power BI decision-making chain, to improve the quality and reliability of your data analyses, and to enhance your professional skills by becoming a key Business Intelligence contact within your organization.