Advanced Microsoft Power BI Training in Finland

  • Learn via: Classroom
  • Duration: 2 Days
  • Price: Please contact for booking options

Power BI Desktop is part of the suite of tools from Microsoft which enable data to be analysed and published from a variety of sources.This course covers the use of Power BI Desktop to connect to data, create Visualizations, query the data and publish reports. You are already using Microsoft’s cloud reporting and business analytics suite, Power BI, to analyze your organizations data and share insights and are now ready to learn the advanced techniques that you, your business analysts, and your stakeholders need to create complex information from projects, program, and portfolio reporting to utilizing time-phased data and, potentially, data from your enterprise’s other line-of-business tools. Attendees of this course will gain practical examples from the experienced instructor who has deployed and configured Power BI reporting in a wide variety of businesses.

Read more +
We can host this training at your preferred location.

Prerequisites

The Power BI boot camp course is a pre-requisite for the course. Alternatively, delegates should have at least 3 months experience in using Power BI Desktop for creating reports and dashboards.

Read more +

What You Will Learn

  • Create Advanced Power BI Reports
  • Advanced understanding of the data schemas and extracting data
  • Perform advanced transformations of data or any data schema
  • Utilize time-phased data in the creation of complex analyses
  • Create new measures using DAX
  • Filter data using row-level security
  • Create and deploy content packs
  • Explore Data Visualizations
  • Create and publish Reports
Read more +

Outline

1.  Introduction

  • What you should know 
  • Our project: Creating an advanced Power BI dashboard

2. Working with Data

  • Importing online data sources
  • Uploading from a folder of data 
  • Querying a database
  • Importing and transferring data imported from an Excel, CSV, or TXT file

3. Query Editor 

  • Introducing Query Editor steps  
  • Transposing data tables 
  • Splitting fields and columns         
  • Formatting data with text formulas
  • Creating conditional formulas
  • Creating calculated formulas

4. DAX Language              

  • Introducing DAX               
  • Introducing DAX measures          
  • Understanding DAX measure logic           
  • Evaluating DAX measures             
  • Leveraging the CALCULATE functionality               
  • Understand how filters work in CALCULATE function       
  • Leveraging the ALL function
  • Understanding the FILTER functionality

5. Introduction to DAX Formulas               

  • Creating a separate table for measures 
  • Creating a table using GENERATESERIES formula
  • Leveraging the POWER function
  • Leveraging the DIVIDE function
  • Utilizing the X factor (SUMX, COUNTX, etc.) for ranges
  • Utilizing quick measures

6. Advanced DAX Calculations

  • Creating a date table using a formula
  • Filtering between tables               
  • Utilizing IF statements with conditional functions
  • Introducing the DATEDIFF measure         
  • Working with disconnected tables           
  • Leveraging the BLANK function 
  • Using variables in formulas
  • DATESBETWEEN and the X functions       
  • Introducing the DATEADD date calculations         
  • Introducing the MTD, QTD, and YTD date calculations
Read more +

Training Reviews

Contact us for more detail about our trainings and for all other enquiries!

Avaible Training Dates

Join our public courses in our Finland facilities. Private class trainings will be organized at the location of your preference, according to your schedule.

22 huhtikuuta 2025 (2 Days)
Helsinki, Espoo
Classroom / Virtual Classroom
24 huhtikuuta 2025 (2 Days)
Helsinki, Espoo
Classroom / Virtual Classroom
09 toukokuuta 2025 (2 Days)
Helsinki, Espoo
Classroom / Virtual Classroom
24 heinäkuuta 2025 (2 Days)
Helsinki, Espoo
Classroom / Virtual Classroom
25 heinäkuuta 2025 (2 Days)
Helsinki, Espoo
Classroom / Virtual Classroom
01 elokuuta 2025 (2 Days)
Helsinki, Espoo
Classroom / Virtual Classroom
02 elokuuta 2025 (2 Days)
Helsinki, Espoo
Classroom / Virtual Classroom
04 elokuuta 2025 (2 Days)
Helsinki, Espoo
Classroom / Virtual Classroom
Advanced Microsoft Power BI Training Course in Finland

Finland is a country located in northern Europe. Helsinki is the capital and largest city of the country. The majority of the people are Finns but there is also a small Lapp population in Lapland, where the country is famous for the Northern Lights. Finland's national languages are Finnish and Swedish.

Known for its vast forests, lakes, and natural beauty, Finland is one of the world's largest producers of forest products, such as paper, pulp, and lumber. One of the world's largest sea fortresses Suomenlinna, Rovaniemi with the "White Nights", dogsled safaris and of course the Northern Lights are what makes Finland so popular for tourists. Finland is one of the best places in the world to see the Northern Lights and attracts millions of tourists during its seasons.

Finland is home to a thriving technology industry and is widely recognized as one of the world's leading technology hubs. Companies such as Nokia and Rovio (creator of the popular game Angry Birds) are based in Finland. Some of the key factors that have contributed to Finland's success in technology include; strong investment in research and development, a highly educated workforce and fundings.

Finland has a strong educational system, and is widely regarded as one of the world's most literate countries. In fact, Finland's literacy rate is one of the highest in the world, and its students consistently perform well in international tests of math and reading ability.

Also, as a pioneer in environmental sustainability, Finland is known for its efforts to reduce its carbon footprint and promote clean energy. This Nordic country is also famous for its unique and distinctive cultural heritage, including its traditional folk music and its elaborate traditional costumes.

Helsinki, Finland's capital city, is the country's business center. Helsinki is Finland's largest city, and it is home to many of the country's major corporations and organizations, including many of the country's leading technology firms. The city is also a commercial, trade, and financial center, as well as one of the busiest ports in the Nordic region.

Take advantage of our diverse IT course offerings, spanning programming, software development, business skills, data science, cybersecurity, cloud computing and virtualization. Our knowledgeable instructors will provide you with practical training and industry insights, delivered directly to your chosen venue in Finland.

Bilginç IT Academy All Rights Reserved

By using this website you agree to let us use cookies. For further information about our use of cookies, check out our Cookie Policy.