Kurser

2 dages kursus 

Power BI Advanced

Kontakt os på tlf. 7220 3000 eller skriv til  kurser@teknologisk.dk for at høre mere.

Ingen planlagte afholdelser.
DKK  9.999
ekskl. moms
Nr. 91914 A

Would you like to dive deeper into Power BI’s functionalities and gain the necessary tools to handle complex data preparation tasks, data modeling, data visualization, and use of the Power BI service?

Having these skills will make you invaluable to your employer. You will be able to save time, money, and resources by knowing the more advanced features in Power BI.

Participant Profile:

This course is for those who have attended or are familiar with Power BI Fundamentals. It is ideal for those working with data reports and those who need to work more efficiently using Power BI.

Prerequisites:

We recommend that you have worked with Power BI for about a year to get the most value from the course, and have built a data model in Power BI before.

Udbytte

  • Gain an understanding of data modeling and learn to create effective data models in Power BI.
  • Understand Slowly Changing Dimensions (SCD) and how to handle data with varying levels of detail.
  • Learn how to set up automatic data refresh.
  • Understand error handling with Power Query.
  • Learn more about design principles for effective data visualization.
Data Preparation
  • From flat Excel file to star schema
  • Error handling in connection with Power Query
  • Using data from a data warehouse (SQL)
  • Use of aggregation tables and dual mode storage mode
Data Modeling
  • Handling historical data (SCD)
  • Handling data with different levels of detail
  • Advanced DAX formulas
Data Visualization
  • Design principles
  • Choosing the right visualization
  • Tips and tricks for a better user experience
Power BI Service
  • Dynamic row-level security with organizational hierarchy
  • User roles and permissions
  • Installation and use of gateway
  • Automatic data refresh

This course is conducted as classroom teaching and a mix of practical examples and exercises.

Firmakurser_web

Firmakurser - få et tilbud

Er I flere, der har samme behov for kompetenceudvikling, så er et firmakursus ofte den rette løsning, der kan skabe fælles fundament og økonomisk besparelse.