Microsoft Power BI Desktop 2-Day
Embark on a comprehensive journey to master Microsoft Power BI Desktop with our intensive 2-day course, available both in-person and virtually.
Audience
This comprehensive two-day course is designed for business professionals, analysts, and data enthusiasts who want to become proficient in Microsoft Power BI Desktop.
Pe-requisites
No specific prerequisites are required, but participants should have a basic understanding of data concepts and be familiar with Microsoft Office applications. Access to a computer with Power BI Desktop installed is necessary
Duration
12 hours (over 2 days)Delivery Method
Face to face or VirtualCourse Objectives
By the end of this two-day course, participants will have acquired a comprehensive skill set in Microsoft Power BI Desktop, enabling them to confidently design, analyze, and visualise complex datasets.
Course Content
Day 1: Power BI Desktop Fundamentals
- Introduction to Power BI Desktop
- Overview of Power BI and its components.
- Understanding the role of Power BI Desktop in the data analysis process.
- Getting Started with Power BI Desktop
- Installing and configuring Power BI Desktop.
- Exploring the Power BI Desktop interface and workspace.
- Importing and Loading Data
- Connecting to various data sources.
- Importing and transforming data for analysis.
- Transforming and Cleaning Data
- Utilizing the Power Query Editor for data transformations.
- Cleaning and shaping data for analysis.
- Modeling Data in Power BI
- Understanding data relationships.
- Creating and managing relationships between tables.
- Building Basic Visualizations
- Creating basic charts, tables, and matrices.
- Formatting and customizing visualizations for clarity.
Day 2: Advanced Power BI Desktop Features
- Advanced Data Modeling and Analysis
- Implementing advanced data modeling techniques.
- Utilizing DAX for complex calculations and measures.
- Time Intelligence in DAX
- Implementing time-based calculations.
- Building dynamic reports with date and time functions.
- Advanced Data Transformations
- Advanced Power Query transformations.
- Combining and merging queries for comprehensive data shaping.
- Advanced Chart Types and Interactive Reports
- Creating advanced charts and visuals.
- Building interactive reports with drill-through and bookmarks.
- Power BI Desktop and Power BI Service Integration
- Publishing reports from Power BI Desktop to Power BI Service.
- Managing and updating reports in the Power BI Service.
- Best Practices for Power BI Desktop
- Guidelines for efficient report design and organization.
- Tips for optimizing performance and user experience.
Stakeholder Management: Influence, Engagement and Control
Develop advanced stakeholder management skills to navigate complex environments, influence without authority, and sustain effective engagement across the full project or change lifecycle.
Stakeholder Management Essentials
Build the skills to identify, analyse, and engage stakeholders effectively, driving better outcomes across projects, change initiatives, and operational delivery.
How to be Assertive
Develop the confidence to communicate clearly, set boundaries, and handle challenging interactions professionally while maintaining empathy and positive relationships.
Becoming an Effective Manager
Develop the skills, confidence and strategies needed to lead people, manage performance, and build a high-performing team in your organisation.
Finance for Non-Financial Managers
Gain the financial confidence to interpret accounts, manage budgets, and make informed decisions that drive profitability and organisational success.
Strategy for Advanced Senior Leaders
Strengthen strategic thinking and decision making using practical frameworks to evaluate options and drive organisational performance.
Influencing Tactics
Build practical influencing skills to gain buy in, strengthen relationships and shape thinking without relying on authority.
Introduction to Interview Skills (For Interviewers)
Build confidence and structure in interviewing through practical techniques for fair, consistent and effective candidate assessment.
Advanced Interview Skills
Develop fair, structured and inclusive interviewing skills to improve candidate experience and selection decisions.
From Policy to Practice: Implementing Menopause Support at Work
Turn menopause policies into practical, consistent workplace support through confident conversations and effective implementation.
