Cart
SuperUsers image
coursePL-300

Design and manage analytics solutions using Power BI

Design and manage analytics solutions using Power BI

15.450 DKK

(excl. VAT)

This course is for you if you already know the basic features of Power BI and now want to strengthen your modeling, visualization and data analysis skills with Power BI. You'll also learn how to manage access control and content sharing in Power BI Service.

Course calendar

 
Hillerød
October
26/10
Week 44
26 - 28 Oct 2026
November
Week
December
7/12
Week 50
7 - 9 Dec 2026
January
Week
February
1/2
Week 5
1 - 3 Feb 2027
March
15/3
Week 11
15 - 17 Mar 2027
April
Week
May
18/5
Week 20
18 - 20 May 2027
Aarhus
26/10
Week 44
26 - 28 Oct 2026
23/11
Week 48
23 - 25 Nov 2026
Week
18/1
Week 3
18 - 20 Jan 2027
Week
15/3
Week 11
15 - 17 Mar 2027
12/4
Week 15
12 - 14 Apr 2027
Week
Virtual
26/10
Week 44
26 - 28 Oct 2026
23/11
Week 48
23 - 25 Nov 2026
7/12
Week 50
7 - 9 Dec 2026
18/1
Week 3
18 - 20 Jan 2027
1/2
Week 5
1 - 3 Feb 2027
15/3
Week 11
15 - 17 Mar 2027
12/4
Week 15
12 - 14 Apr 2027
18/5
Week 20
18 - 20 May 2027
Dates are start dates
Virtual classroom available
Guaranteed to run

Description

This course is for you if you work as, for example, a data analyst, BI specialist or report developer and want to build your skills in data management and data analysis in Power BI.

You'll learn to develop interactive reports and dashboards based on both cloud and on-premises data sources, and you'll get practical experience accessing and processing data from both relational and non-relational databases.

You'll also learn to implement security standards and policies and to manage datasets and groups in Power BI Service. The course also covers how to manage, deploy and share reports and interactive dashboards.

We dive into optimizing the data model, with a focus on performance, storage mode and query folding. In Power BI Service, you'll work with key elements such as:

  • Workspaces
  • Permissions
  • Apps
  • Sharing
  • Datasets

You'll learn how workspaces are used to organize and share datasets, reports and dashboards, and how the licensing model fits with that structure. Access control is a central theme, from both a technical and a business perspective, and you'll gain a solid understanding of how to control access and visibility all the way down to row level (Row-Level Security).

After the course, you'll be able to:

  • Connect, clean, transform and load data
  • Model data for performance and scalability
  • Create and design reports for data analysis and decision-making
  • Apply advanced analytical methods in reports
  • Manage and share reports and dashboards

The course includes hands-on exercises throughout, so you leave with knowledge and tools you can apply directly in your Power BI setup. It also includes exercises beyond Microsoft's official labs, including on the data gateway and model optimization.

Related exam

Prerequisites

To get the most out of the course, we recommend experience or knowledge equivalent to:

Next steps

Video teaser

Certification bundles

Module overview

Explore the role of a data analyst and how Power BI tools transform data into impactful reports and dashboards that support trusted, data-driven decisions across the business.This learning path can help you prepare for theMicrosoft Certified: Data Analyst Associate certification.

Lessons:

  • Discover data analysis
  • Get started building with Power BI
  • Introduction to end-to-end analytics using Microsoft Fabric
  • Get started with Copilot in Power BI

You'll learn how to use Power Query to extract data from different data sources, choose a storage mode, and connectivity type. You'll also learn to profile, clean, and load data into Power BI before you model your data.This learning path can help you prepare for theMicrosoft Certified: Data Analyst Associate certification.

Lessons:

  • Get data in Power BI
  • Clean, transform, and load data in Power BI
  • Choose a Power BI model framework

Data modeling configures and shapes your prepared data to design a semantic model with the necessary relationships and calculations using Data Analysis Expressions (DAX). This process ensures accurate analysis and sets you up to create clear, impactful Power BI reports.This learning path can help you prepare for theMicrosoft Certified: Data Analyst Associate certification.

Lessons:

  • Configure a semantic model
  • Write DAX formulas for semantic models
  • Create DAX calculations in semantic models
  • Modify DAX filter context in semantic models
  • Use DAX time intelligence functions in semantic models
  • Create visual calculations in Power BI Desktop
  • Optimize a model for performance in Power BI

Use data visualization and storytelling techniques to create insightful, dynamic Power BI reports that engage users, highlight key findings, and help inform decisions based on data.

Lessons:

  • Scope report design requirements
  • Design Power BI reports
  • Enhance Power BI report designs for the user experience
  • Perform analytics in Power BI

Ensure content is accessible and distributed effectively in Power BI to foster collaboration and informed decision-making. Protect sensitive information with robust security, building trust across your organization.This learning path can help you prepare for theMicrosoft Certified: Data Analyst Associate certification.

Lessons:

  • Manage workspaces in Power BI service
  • Manage semantic models in Power BI
  • Choose a content distribution method
  • Create dashboards in Power BI
  • Secure data access in Power BI

Free course advice

We care a lot about helping you find the course path that creates the most value for you and your workplace. Get in touch with our course advisors — they're ready to help you, free of charge and with no obligation.

Contact image

I can't give anything less than 5 stars across the board. Either you're truly in a class of your own, or I've just been to the wrong course venues before. Fantastic place and atmosphere.... once you've learned to find your way around :-)

— Mikael Ejberg Pedersen
Cobham SATCOM

Your instructors are exceptional; skilled, competent and good at teaching - so you have everything you need to get off to a good start.

You have fantastic facilities, good food and lovely people throughout the building.

— Camilla Esper
Leita Aps

A really good, in-depth course. Your course facilities at Karlebogaard are nothing short of fantastic. A beautiful historic house with lots of fun stories and great course rooms. The course itself was very useful. I learned everything I had hoped to and then some. My instructor was damn good and really funny. He made it a pleasure, and the hours flew by.

— Henrik Thuelund
Magasin du Nord

Probably the best course I've ever taken and the best instructor I've ever had!! Really good depth and thorough explanations, and on top of that, fantastic food!!!

— Michael Hasløv
Lån & Spar Bank

Delicious food, cozy facilities, good structure and atmosphere. I'll be back when I can.

— Ea Stenberg
Oticon A/S

Absolutely the best course I've ever taken!

— Esben Salling
JN Data A/S

The course venue is so inviting and welcoming that it has been a pleasure to be here. Clean, tidy and full of charm. I attended a course where all the individual parts came together into a greater whole that can hardly be described.

— Bo Peter Jensen
Kyndryl Danmark ApS

I got a lot out of the course. It opened my eyes to possibilities I didn't know existed. I'm sure this won't be the last time we're in touch with SuperUsers.

— Christian Larsen
Siemens Gamesa Renewable Energy A/S

I never in my wildest dreams imagined that a course venue could be so beautiful. I don't know if it's true, but I have a feeling that the surroundings rub off on the people who work here, so everyone seems incredibly happy.

There's a really great atmosphere. All the way from the woman at the reception desk to the people who work in the kitchen.

— Jannik Berg Møller
Metro Service

The instructor tailored the course to my level to a very large extent and was flexible. I had very high expectations, and they were exceeded.

Great precision, good exercises, good pace, a great atmosphere and maximum learning.

— Luka Dalum
Semler

The instructor was very pleasant and the exercises were extremely good. I really learned a lot about the topics the course covered.

On top of that, really nice, calm and green surroundings with good catering - especially good food. I would like to take my courses here again next time.

— Arif Mikkelsen Yüce
Københavns Kommune

It was a real pleasure to take a course at SuperUsers. The week we spent on the course was worth the money and means that we can now save many consultant hours. It's always nice to have the knowledge in-house.

There is a relaxed atmosphere in the classroom, lovely surroundings in the building itself, and skilled instructors who do a really good job.

I started using all the knowledge I soaked up on the course almost right away, and now we are well underway with developing our future cloud solution.

There is no doubt about who we will turn to if we need other courses.

— Maksym Bilyk
KVM A/S

This is my first time at SuperUsers. It has been a really good experience. The instructor seems very experienced and competent.

The instructor's strong technical background made the course and the in-depth answers to questions a good experience.

— Thomas Gram
Nic. Christiansen Gruppen A/S

A really nice course venue in pleasant surroundings that make for a good setting for focused learning. The instructor came across as well prepared, with extensive knowledge of the relevant topics.

The instructor also showed a strong ability to answer any questions that came up during the course.

— Simon Schmidt Eriksen
Norlys

I'll be back the next time I need to take a course. It's a lovely place, the food is fantastic, and the instructor is very knowledgeable and happy to share that knowledge!

— Jan Christiansen
TV2 Danmark A/S

The technical depth of the course was really good. The instructor's knowledge went much deeper than the curriculum necessarily requires.

You could throw all kinds of curveballs at the instructor, and he had it all under control - he also made the content exciting.

— Nicolai Bæklund
Danish Crown

We have now completed Microsoft 365 courses for a total of 5 people here in our department. Everyone agrees that it was an excellent course with a skilled instructor and communicator who could discuss and explain things at the right level, while also being efficient and bringing humor.

It has been a really good experience.

— Henrik Dyrhøj
Nyborg Kommune

It's calm and quiet at SuperUsers' country venue. Good atmosphere and catering. Some thought has gone into healthy eating when it comes to food and cake, so it doesn't get completely out of hand.

The instructor is knowledgeable about the topics and readily puts them in a broader perspective by relating them to other relevant areas. It's rewarding that this is possible too, and it gives you ideas for further study.

In addition, the instructor was engaged and entertaining to have presenting the content.

— Kenneth Middelboe Carlson
Svend Hoyer A/S

As always, it was a great experience, and you learn a lot in a short time from some very skilled instructors.

I work in Azure almost every day, and both courses have been really good at helping me understand Azure better.

— Marthin Lundquist
DEAS A/S

The instructor is very presentation-oriented and gets you involved in the teaching and the material. He is good at varying the teaching so it never gets monotonous.

It is clear that the instructor has hands-on experience and not just the theory, with many good examples that related to real-world challenges we might encounter.

Good facilities and good food, without drowning in unhealthy habits.

— Kenneth Middelboe Carlson
Svend Hoyer A/S

Very good course, the instructor was the best. I've been here at SuperUsers before, now I'm here again, and hopefully coming back another time.

— Mads From
Sampension Administrationsselskab A/S

The instructor seemed very competent and has extensive knowledge of his field. He was good at explaining things in a clear and humorous way. There were also simple exercises that gave a good understanding. 

— Jeppe Hvelplund
Vattenfall Vindkraft A/S

The instructor was really good at going in depth while still making sure everyone was keeping up. A really nice venue and room, and great food.

There was no doubt that the instructor knew exactly what he was talking about, and even the simplest questions were answered gladly, without anyone being made to feel stupid.

— Jesper Nederby
Rudersdal Kommune

A lovely, cozy place where the receptionist, the kitchen and the instructors make you feel at home. A good setting makes for good learning. Really good food that helps round out the whole experience of taking a course at SuperUsers.

— Henrik Valentin Eltang
Privatperson

Really happy with the venue and the stay over in the horse stable. I'll see if I can come back here for the next course I take. A really beautiful building, and great to experience a place like this. A fantastic place to hold a course.

— Mads-Ejnar Kehlet
Herningsholm IT-center