Power BI Desktop for Business Users Training in Finland

  • Learn via: Classroom
  • Duration: 3 Days
  • Level: Fundamentals
  • Price: From €2,281+VAT
We can host this training at your preferred location. Contact us!

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.

With Power BI Desktop, you get a report authoring tool that enables you to connect to and query data from different sources using the Query Editor. From the datasets you build with Query Editor you can create reports and add visuals within Power BI Desktop. Reports can then be published.

This course covers the use of Power BI Desktop to connect to data, query the data, add visuals and prepare to publish a report.

Please Note: This course does not cover the use of Power BI in the Power BI Service

  • Please note that this course is not suitable for new Excel or database users
  • An understanding of basic data concepts
  • Ability to create, format chart outputs
  • Be able to create formulas using standard aggregate functions
  • Able to apply data processing techniques such as filtering and pivot creation

For learners without access to the software required for this event, a remote PC can be provided using GoToMyPC. If you have any questions, contact our Virtual team.

Target audience

Anyone who is familiar with Microsoft Office applications and who needs to work with data to be able to connect, process and analyse the data to produce suitable output at all levels within an organisation.

It is assumed that attendees on the course are already familiar with charts and PivotTable concepts.

  • Power BI Desktop Concepts and Main Features
  • Data Sources compatible with Power BI Desktop
  • Connecting to Data with Power BI Desktop
  • Apply Common Query Tasks to Shape Data in Power BI Desktop
  • Explore Data Visuals
  • Work with Report formats and elements

Module 1: Getting Started with Power BI Desktop

  • Power BI concepts and overview
  • Introduction to main features
    • Imports
    • Visualisations
    • Filters and queries
    • Reports

Module 2: Connecting to Data Sources with Power BI Desktop

  • Data sources power BI desktop will connect to
  • Data types and properties in power BI desktop
  • Importing and entering data
  • Connecting to data with the query editor
    • Introducing the query editor
    • Using the query editor to connect to data
    • Editing the query before loading
  • Combining data sources
    • Use append queries
    • Merge data tables

Module 3: Querying and Shaping the Data

  • Filters
  • Text transforms
  • Column from example
  • Unpivot data
  • Creating custom calculated columns
  • Adding conditional columns

Module 4: Data Modelling in Power BI Desktop

  • Relationships – the fundamentals
  • Working with relationships
    • Creating relationships
    • Editing a relationship
  • Working in the model view
  • Drill visuals to see underlying data
    • Visual table and data point table
    • Create reusable field hierarchies
    • Date hierarchies
    • Drillthrough filters
  • Introduction to DAX expressions
    • Calculated columns
    • Dax function to create a measure
    • Creating tables using DAX

Module 5: Data Visualisations

  • Overview of visuals
  • Tables and matrix views
  • Applying conditional formats
  • Charts
    • Types
    • Creating a chart visual
    • Reference lines
  • Interactive slicers
    • Slicers as lists or dropdowns
    • Edit interactions
    • Number slicers with value ranges
    • Date or time slicers
    • Sync slicers
  • Bookmarks
  • Data analysis visuals
    • Insights
    • Decomposition tree
  • Data groups and binning in visuals
    • Data groups as lists
    • Data groups as bins
    • Data groups with dates
  • Ask a question with Q&A
  • Data categories, geo-data and maps

Module 6: Reports and Output Options

  • Report elements and options
  • Working with pages
    • Adding and renaming pages
    • Canvas size and view options
    • Wallpaper
    • Filter pane
  • Visual enhancements
    • Custom tooltip
    • Insert graphics
    • Arranging objects
    • Built-in report themes
  • Report level filters

QA reserves the right to improve the specification and format of its courses for the benefit of its customers without notice to the customer.



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

Upcoming Trainings

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

Classroom / Virtual Classroom
16 joulukuuta 2024
Helsinki, Espoo
€2,281 +VAT Book Now
Classroom / Virtual Classroom
08 tammikuuta 2025
Helsinki, Espoo
€2,281 +VAT Book Now
Classroom / Virtual Classroom
16 joulukuuta 2024
Helsinki, Espoo
€2,281 +VAT Book Now
Classroom / Virtual Classroom
20 tammikuuta 2025
Helsinki, Espoo
€2,281 +VAT Book Now
Classroom / Virtual Classroom
29 tammikuuta 2025
Helsinki, Espoo
€2,281 +VAT Book Now
Classroom / Virtual Classroom
08 tammikuuta 2025
Helsinki, Espoo
€2,281 +VAT Book Now
Classroom / Virtual Classroom
10 helmikuuta 2025
Helsinki, Espoo
€2,281 +VAT Book Now
Classroom / Virtual Classroom
20 tammikuuta 2025
Helsinki, Espoo
€2,281 +VAT Book Now

Related Trainings

Power BI Desktop for Business Users 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.
By using this website you agree to let us use cookies. For further information about our use of cookies, check out our Cookie Policy.