Excel BI for Analysts – Power Query & Power Pivot

When Microsoft noticed that the world of processing, analysis and visualisation of data leaves them behind, it has started working on the missing elements for Excel users. In this way, a large range of FREE ADD-INS appeared, of which most of us – Excel users – have no idea, and which can solve many of our everyday problems. From the time of running it, Microsoft refers to its Excel as BI. In their arsenal every analyst has a possibility to download and process the data automatically using Power Query, build a data model using Power Pivot and visualise it using Power BI and Power Map. During the training the users will learn what their practical applications are and how they save us time

Excel, Power BI and Dashboards

3400 EUR (2 days),

5100 EUR (3 days)

Duration

2 or 3 days

Mode

online/offline

Language

Polish or English

Max group

n/a

Participants will learn:

  • How to automate the process of data processing using Power Query
  • How to build your own data model with measures, which are not available in a standard pivot table, using Power Pivot
  • How to present graphic data on a report (Power BI) and on maps (Power Map)

For whom?

This training is for professionals who work with data in Excel and want to streamline their analysis, automation, and visualization processes using tools like Power Query, Power Pivot, Power Map, and Power BI. It’s suitable for both beginners and experienced users looking to enhance their skills.

  • Data analysts

Training program

  • What does the business need?
  • Review of the BI tool market
  • Excel BI – introduction
  • Report from A to Z
  • Append & getting the files from folder
  • Merge queries vs VLOOKUP
  • Add new columns & transform columns
  • Group data
  • Unpivot
  • Import of data from various sources
  • Creating relationships
  • Creating a hierarchy
  • DAX language
  • Creating KPIs
  • Using a data model in pivot table
  • Creating various maps
  • Filtering data
  • Geocoding
  • Refreshing data
  • Creating charts
  • Designing dashboards
  • Publishing the report
What is "BI"?
  • What does the business need?
  • Review of the BI tool market
  • Excel BI – introduction
Power Query
  • Report from A to Z
  • Append & getting the files from folder
  • Merge queries vs VLOOKUP
  • Add new columns & transform columns
  • Group data
  • Unpivot
Power Pivot
  • Import of data from various sources
  • Creating relationships
  • Creating a hierarchy
  • DAX language
  • Creating KPIs
  • Using a data model in pivot table
Power Map
  • Creating various maps
  • Filtering data
  • Geocoding
  • Refreshing data
Power BI
  • Creating charts
  • Designing dashboards
  • Publishing the report

Who will train you?

Our Training Team is versatile and constantly evolving in the ever changing world of tech. We encourage you to Get to know our Trainers in a dedicated section of our website and to explore further at Meet Our Team.

We aim for high flexibility and providing you with the up-to-date knowledge and relevant skills, hence trainers can be assigned to a particular course dynamically. Selection criteria may involve factors like preferred dates, trainer’s latest achievements in a given field or your personal view of their competence and experience. Did we mention the Get to know our Trainers section?

Additional information

The training is offered in collaboration with Bartek Czapiewski / excelbiacademy.com.

Is

Excel BI for Analysts

the right choice?

Is Excel BI for Analysts the right choice?

Misaligned training isn’t just frustrating – it’s a waste of time. Fill in the form below and ensure we can deliver exactly what your skill set requires. We’ll get back to you within a day, offering our best value for your time.

Dive deeper with these related topics

Excel, Power BI and Dashboards

Excel course

#Microsoft #Beginner #Data analysts

Excel, Power BI and Dashboards

4in1 Power courses bundle

#Microsoft #Beginner #Data analysts

Excel, Power BI and Dashboards

Power BI – prepare data, create data model, design dashboard

#Microsoft #Beginner #Data analysts

Excel, Power BI and Dashboards

Excel course

#Microsoft #Beginner #Data analysts

Excel, Power BI and Dashboards

4in1 Power courses bundle

#Microsoft #Beginner #Data analysts

Excel, Power BI and Dashboards

Power BI – prepare data, create data model, design dashboard

#Microsoft #Beginner #Data analysts