Strategic Business IT Planning, Deployment & Management Courses


Business Intelligence with Power BI

Introduction

You will learn the basics of Power BI's capabilities in this course, "Getting Started with Power BI." You'll first discover how fast and simply you can collect data from many sources, then quickly and simply clean and transform that data with a few clicks. You'll then discover how to improve the outcomes by combining several data sources and including straightforward computations. Then, you'll discover how to use straightforward dashboards and visualizations to investigate your data.By the time you finish this Power BI training, you'll be well-versed in the fundamental abilities needed to use Power BI to gather and convert data, improve the data for analysis, and create reports and dashboards.

Targeted Groups

Anyone interested in learning Power BI to analyze and visualize data effectively. This Power BI training is ideal  if you want to gather, convert, and enhance data in order to create useful reports and dashboards.

Course Objectives

  • You will learn about Power BI in this course, which covers subjects like:
  • Power BI report viewing
  • Obtaining information from files, databases, and the web
  • data purification and transformation
  • Utilizing rows, columns, and queries
  • data modeling for analysis
  • Making connections with Power BI Desktop
  • improving, displaying, and updating the data

Course Content

Unit 1: Introducing Power BI

  • Learning More About Power BI
  • Making Datasets from Data Models and Data Files Exploring Datasets with Quick Insights Viewing Reports
  • Investigating a Power BI Dashboard's History
  • Using Power BI Desktop with Excel to Select a Development Tool

Unit 2: Getting Data

  • Data Collection Data Collection Databases
  • Accessing Databases for Data (Excel)
  • Internet and other resources
  • Software as a Service and Azure
  • Manual Entry

Unit 3: Data transformation

  • Query renaming
  • Combining queries Fixing Metadata Append
  • Rows Filtering
  • Columns are Gone
  • Combining queries Merge
  • Inserting a Column

Unit 4: Modeling Data for Analysis

  • Modeling Data for Analysis
  • Creating Relationships
  • Defining New Columns
  • Concatenating Columns
  • Performing a Lookup to a Related Table
  • Translating a Value
  • Adding a Date Table

Unit 5: Improve the Data Model

  • Improved Data Models
  • Laying Out Hierarchies
  • Setting Up Properties
  • Setting New Standards

Unit 6: Displaying data

  • Data Visualization
  • Adding Visuals
  • Slicer Filtering
  • Highlighting
  • Setting Properties

Unit 7: Updating Data

  • Using the Power BI Gateway to Refresh Imported Data and Publishing Datasets
  • Understanding Power BI Gateway for Businesses

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

Strategic Business IT Planning, Deployment & Management Courses
Business Intelligence with Power BI (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.