Strategic Business IT Planning, Deployment & Management Courses


Power BI: The Basics Course

Introduction to Power BI:

Microsoft Power BI is a business analytics service that provides tools for analyzing data and sharing insights. This advanced Power BI training course is a comprehensive introduction. It explores Power BI's capabilities, including dataflows, custom connectors, and dashboard visuals.

Those who wish to validate their skills in this area can aim for the Power BI fundamentals certification. This Power BI introduction training course caters to participants of various skill levels, with basic training and advanced training to obtain a Power BI Data Analyst Professional Certificate.

With a focus on practical usage, the course will guide you through creating dashboards in Power BI, understanding workspace roles, and leveraging Power BI solutions for business needs to obtain the best Power BI certification available for developers and analysts.

Upon completion, attendees at this Power BI training will grasp Power BI best practices and sample reports, which can help shape their learning path toward becoming Certified Power BI Data Analyst Associates.

Targeted Groups:

  • Power Users.
  • Developers.
  • BI Developers.
  • Business Analysts.
  • Technical Specialists.

Course Objectives:

At the end of this Power BI training course, participants will be able to:

  • Analyze, transform, and present data rapidly.
  • Understand the Power BI platform and its advantages.
  • Set up queries to extract and transform data efficiently.
  • Create effective data models and calculated tables.
  • Design and publish interactive reports and dashboards.
  • Use DAX calculations confidently for analysis and forecasting.
  • Grasp the concepts of Power BI data flow and development.

Targeted Competencies:

By the end of this Power BI training course, participants competencies will:

  • Loading data and data modeling.
  • DAX fundamentals.
  • Logical functions.
  • Power BI service.
  • Power BI visualizations.

Course Content:

Unit 1: Introduction to the Power BI Platform:

  • Power BI Platform Architecture.
  • Datasets and External Data Sources.
  • Power BI Integration with SaaS Applications.
  • Understanding Power BI Workspaces and their roles.
  • Creating Reports and Dashboards with Power BI.
  • Benefits of using Power BI in corporate environments.

Unit 2: Shape and Extract Data using Power Query:

  • Power Query and its Essential Training.
  • Power Query Editor for Beginners.
  • Connecting to External Data Sources.
  • Transforming and Reshaping Data.
  • Publishing Queries to the Data Catalog.

Unit 3: Modeling Data for Analytics using Power Pivot:

  • Data Modeling with Power Pivot and the Tabular Model.
  • Understanding Tables and Table Relationships.
  • Introduction to Data Analysis Expression Language (DAX).
  • Extending Tables with Calculated Columns and Measures.
  • Creating Dimensional Hierarchies and Power BI Calculated Tables.

Unit 4: Support Time Intelligence by Extending Datasets:

  • Understanding Evaluation Contexts.
  • Creating a Time Dimension Table.
  • DAX Time Intelligence Support.
  • DAX Time Intelligence Functions and Forecasting.

Unit 5: Building Dashboards and Reports with Power BI:

  • Designing Reports using Power BI Visualizations.
  • Creating Interactive Reports using Filters and Slicers.
  • How do you create a dashboard in Power BI?
  • Power BI Sample Reports and Best Practices.

Unit 6: Building Dashboards for Mobile Devices:

  • Power BI Architecture for Mobile Devices.
  • Power BI Apps and Supported Mobile Platforms.
  • Configuring Mobile Devices for Power BI.
  • Dashboard Design Principles for Mobile Devices.

Unit 7: Building and Deploying Power BI Content Packs:

  • Content Packs and the Content Gallery.
  • Organizational Content Packs.
  • Customizing and Personalizing Content Packs.
  • Data Security with Content Packs.

Unit 8: Utilizing the New BI Features in Excel 2016:

  • Data Model Support in Excel 2016.
  • Power Query Enhancements in Excel 2016.
  • Power Pivot Enhancements in Excel 2016.
  • Creating PivotTables, Graphs, and Charts from a Data Model.
  • Designing Dashboards with Excel 2016.
  • Analyze in Excel and Export Power BI to Excel Features.

Dubai (UAE)
07 - 11 Jul 2024
4500 Euro
Online
07 - 11 Jul 2024
2500 Euro
Amsterdam (Netherlands)
08 - 12 Jul 2024
5500 Euro
Rome (Italy)
08 - 12 Jul 2024
5500 Euro
Sharm El-Sheikh (Egypt)
14 - 18 Jul 2024
4500 Euro
Amsterdam (Netherlands)
15 - 19 Jul 2024
5500 Euro
Lisbon (Portugal)
22 - 26 Jul 2024
5200 Euro
Istanbul (Turkey)
28 Jul - 01 Aug 2024
5000 Euro
Barcelona (Spain)
29 Jul - 02 Aug 2024
5500 Euro
Sharm El-Sheikh (Egypt)
04 - 08 Aug 2024
4500 Euro
Amman (Jordan)
04 - 08 Aug 2024
3200 Euro
Casablanca (Morocco)
19 - 23 Aug 2024
4000 Euro
Cairo (Egypt)
25 - 29 Aug 2024
3500 Euro
Cairo (Egypt)
15 - 19 Sep 2024
3500 Euro
London (UK)
23 - 27 Sep 2024
5800 Euro
Kuala Lumpur (Malaysia)
29 Sep - 03 Oct 2024
4500 Euro
Vienna (Austria)
07 - 11 Oct 2024
5200 Euro
Amman (Jordan)
13 - 17 Oct 2024
3200 Euro
Manama (Bahrain)
03 - 07 Nov 2024
5500 Euro
Madrid (Spain)
18 - 22 Nov 2024
5500 Euro
Barcelona (Spain)
25 - 29 Nov 2024
5500 Euro
Madrid (Spain)
25 - 29 Nov 2024
5500 Euro
Munich (Germany)
02 - 06 Dec 2024
5200 Euro
Brussels (Belgium)
09 - 13 Dec 2024
5200 Euro
Paris (France)
09 - 13 Dec 2024
5500 Euro
Istanbul (Turkey)
22 - 26 Dec 2024
5000 Euro
Rome (Italy)
30 Dec 2024 - 03 Jan 2025
5500 Euro
Dubai (UAE)
19 - 23 Jan 2025
4500 Euro
Kuala Lumpur (Malaysia)
02 - 06 Feb 2025
4500 Euro
Kuala Lumpur (Malaysia)
09 - 13 Feb 2025
4500 Euro
Boston (USA)
10 - 14 Feb 2025
9000 Euro
Paris (France)
17 - 21 Feb 2025
5500 Euro
Online
23 - 27 Feb 2025
2500 Euro
London (UK)
24 - 28 Feb 2025
5800 Euro
Vienna (Austria)
03 - 07 Mar 2025
5200 Euro
Geneva (Switzerland)
17 - 20 Mar 2025
5200 Euro
Cairo (Egypt)
30 Mar - 20 Apr 2025
3500 Euro
Manama (Bahrain)
30 Mar - 20 Apr 2025
5500 Euro
London (UK)
31 Mar - 20 Apr 2025
5800 Euro
Dubai (UAE)
27 Apr - 20 May 2025
4500 Euro

Strategic Business IT Planning, Deployment & Management Courses
Power BI: The Basics Course (B)

 

Mercury dynamic schedule is constantly reviewed and updated to ensure that every category is being addressed at least once a month, if not once every week. Please check the training courses listed below and if you do not find the subject you are interested in, email us or give us a call and we will do our best to assist.