Microsoft® 365 – Power BI

Unlocking Insights, Driving Decisions

2 Day(s)

2 Day(s)

Maximum of 8 Delegates for Face-to-Face / 6 Delegates for Online

Who Should Attend?

This course is ideal for both beginners and experienced users who want to leverage the potential of Power BI. Beginners will learn the essential skills to explore and understand their data, while experienced users can refine their techniques and gain deeper insights.

Microsoft® Excel knowledge is a prerequisite for this training.

About The Program

In today’s data-centric landscape, businesses thrive on informed decisions, and data analysts are in high demand. Microsoft Power BI is your key to becoming a data expert and unlocking a world of possibilities. By the end of the two-days course, you will be equipped with a solid foundation in Power BI, enabling you to create powerful reports and visualizations to drive informed decision-making.

Course Objectives

  • To understand the parts and building blocks of Power BI
  • To be able to get data from multiple sources into Power BI Desktop
  • To be able to build relationships and model your data to prepare for reports
  • To create new visualizations or build dashboards in Power BI service
  • To publish and share your dashboards
  • To be able to view and interact with shared dashboards and reports in Power BI Mobile apps
  • To learn how to find, connect to, and interact with data in Power BI
  • To be able to use Excel and Power BI together and create powerful, connected reports and visuals
  • To learn DAX basics and fundamentals – how to think about DAX, how it works, and the most useful features

What You Will Gain

  • A sound working knowledge of Power BI elements
  • An in-depth understanding of how to get data and build reports from scratch
  • An understanding of how to bring your data to life, and reveal insights by using compelling visual representation in Power BI
  • An ability to build user friendly dashboards and publish, export, share, and distribute your Power BI data insights
  • An introduction to DAX, the language used to create Power BI queries

DAY ONE 

  • Introduction
    • The Parts Of Power BI
    • The Flow Of Work In Power BI
    • Building Blocks Of Power BI
    • Understanding Power BI Service
  • Getting data
    • Install and run Power BI desktop
    • Connect to data sources in Power BI Desktop
    • Clean and transform data with Power Query Editor
    • Shape Data
    • Connect To Data
    • Combine Data
    • More Advanced Data Sources And Transformation
    • Cleaning Irregularly Formatted Data
  • Modeling
    • Introduction to modeling your data
    • How to manage your data relationships
    • Create calculated columns
    • Optimizing data models
    • Create calculated measures
    • Create calculated tables
    • Explore your time-based data
  • Visualizations
    • Introduction to visuals in Power Bi
    • Create and customize simple visuals
    • Combination Charts
    • Slicers
    • Map visualizations
    • Matrixes and tables

DAY TWO

  • Visualizations (Contd.)
    • Scatter charts
    • Waterfall and funnel charts
    • Gauges and single-number cards
    • Modify color in charts and visuals
    • Shapes, text boxes and images
    • Page layout and formatting
    • Group interactions among visualizations
    • Duplicate a report page
    • Show categories with no data
    • Summarization and category options
    • Z-order
    • Visual hierarchies and drill down
    • R integration in Power Bi desktop
  • Exploring data
    • Quick insights in Power BI
    • Create and configure a dashboard
    • Ask questions of your data with natural language
    • Create custom Q&A suggestions
    • Share dashboards with your organization
    • Edit tile details and add widgets
    • Install and configure a personal gateway
  • Publishing and sharing
    • Publish Power BI Desktop Reports
    • Print and export dashboards and reports
    • Manually republish and refresh your data
    • Introducing Power BI Mobile
    • Create groups in Power BI
    • Build, Use And Update Apps
    • Integrate OneDrive for Business with Power BI
    • Publish to web
  • DAX Fundamentals
    • DAX Calculation Types
    • DAX Functions
    • Using variables in DAX Expressions
    • Table Relationships and DAX
    • DAX Tables and filtering

Before the course each delegate will be asked to complete a Pre-Course Briefing Form to determine their individual objectives for attending the course. These objectives will be used by the Tutor to give on-target training that is focused on the individual delegates.

At the end of the course each delegate will be asked to complete a Personal Development Plan that can be used as part of future appraisals, and that will also be an important tool for management reference.

Total Investment: AED 3,450/- + VAT, which includes – Training Materials, Lunch and Refreshments. Discount available for multiple bookings.

Maximum of 8 Delegates for Face-to-Face / 6 Delegates for Online

Who Should Attend?

This course is ideal for both beginners and experienced users who want to leverage the potential of Power BI. Beginners will learn the essential skills to explore and understand their data, while experienced users can refine their techniques and gain deeper insights.

Microsoft® Excel knowledge is a prerequisite for this training.

About The Program

In today’s data-centric landscape, businesses thrive on informed decisions, and data analysts are in high demand. Microsoft Power BI is your key to becoming a data expert and unlocking a world of possibilities. By the end of the two-days course, you will be equipped with a solid foundation in Power BI, enabling you to create powerful reports and visualizations to drive informed decision-making.

Course Objectives

  • To understand the parts and building blocks of Power BI
  • To be able to get data from multiple sources into Power BI Desktop
  • To be able to build relationships and model your data to prepare for reports
  • To create new visualizations or build dashboards in Power BI service
  • To publish and share your dashboards
  • To be able to view and interact with shared dashboards and reports in Power BI Mobile apps
  • To learn how to find, connect to, and interact with data in Power BI
  • To be able to use Excel and Power BI together and create powerful, connected reports and visuals
  • To learn DAX basics and fundamentals – how to think about DAX, how it works, and the most useful features

What You Will Gain

  • A sound working knowledge of Power BI elements
  • An in-depth understanding of how to get data and build reports from scratch
  • An understanding of how to bring your data to life, and reveal insights by using compelling visual representation in Power BI
  • An ability to build user friendly dashboards and publish, export, share, and distribute your Power BI data insights
  • An introduction to DAX, the language used to create Power BI queries

DAY ONE 

  • Introduction
    • The Parts Of Power BI
    • The Flow Of Work In Power BI
    • Building Blocks Of Power BI
    • Understanding Power BI Service
  • Getting data
    • Install and run Power BI desktop
    • Connect to data sources in Power BI Desktop
    • Clean and transform data with Power Query Editor
    • Shape Data
    • Connect To Data
    • Combine Data
    • More Advanced Data Sources And Transformation
    • Cleaning Irregularly Formatted Data
  • Modeling
    • Introduction to modeling your data
    • How to manage your data relationships
    • Create calculated columns
    • Optimizing data models
    • Create calculated measures
    • Create calculated tables
    • Explore your time-based data
  • Visualizations
    • Introduction to visuals in Power Bi
    • Create and customize simple visuals
    • Combination Charts
    • Slicers
    • Map visualizations
    • Matrixes and tables

DAY TWO

  • Visualizations (Contd.)
    • Scatter charts
    • Waterfall and funnel charts
    • Gauges and single-number cards
    • Modify color in charts and visuals
    • Shapes, text boxes and images
    • Page layout and formatting
    • Group interactions among visualizations
    • Duplicate a report page
    • Show categories with no data
    • Summarization and category options
    • Z-order
    • Visual hierarchies and drill down
    • R integration in Power Bi desktop
  • Exploring data
    • Quick insights in Power BI
    • Create and configure a dashboard
    • Ask questions of your data with natural language
    • Create custom Q&A suggestions
    • Share dashboards with your organization
    • Edit tile details and add widgets
    • Install and configure a personal gateway
  • Publishing and sharing
    • Publish Power BI Desktop Reports
    • Print and export dashboards and reports
    • Manually republish and refresh your data
    • Introducing Power BI Mobile
    • Create groups in Power BI
    • Build, Use And Update Apps
    • Integrate OneDrive for Business with Power BI
    • Publish to web
  • DAX Fundamentals
    • DAX Calculation Types
    • DAX Functions
    • Using variables in DAX Expressions
    • Table Relationships and DAX
    • DAX Tables and filtering

Please contact us for specific details on the courses we are running. Our Business Development Team will be happy to provide you with further details.

Before the course, each delegate will be asked to complete a Pre-Course Briefing Form to determine their individual objectives for attending the course. These objectives will be used by the Tutor to give on-target training that is focused on the individual delegates.

At the end of the course, each delegate will be asked to complete a Personal Development Plan that can be used as part of future appraisals, and that will also be an important tool for management reference.

Total ONLINE Investment: AED 2,550 + VAT

More Courses

Need Help?

In-Company Inquiry