Designing Reports in Power BI (conducted in English) kursus

This Power BI course is designed for those who are going to create user friendly and interactive reports in Power BI. We will learn you how to use Power BI Desktop and take advantage of many Report options.

Kursusmål

  • Create reports using data from existing Datamodels (Cubes)
  • Design and format Reports and Dashboards - to get a better overview of your data
  • Implement filters and interactivity in Reports and Dashboards - so users can search and navigate to needed data.
  • Share Reports and Dashboards with others

Kurset henvender sig til

Is designed for business analytics, controllers or similar rolles, that wants to start working with Self- Service Business Intelligence.

Forudsætninger

    It is expected that you have tried designing Reports e.g. in Excel.

Kursusindhold

Module 1 - Introduction to Power BI

We will start by informing you about the tools and services in Power BI. You’ll get an introduction to Power BI Desktop, that you will use on this course to design reports.

The following will be covered:

  • Introduction to Power BI
  • Introduktion to Power BI Desktop

 

Module 2 - Introduction to Datamodels

You’ll be introduced to different types of Datamodels and how to create connection to them from inside Power BI Desktop - and after that design reports.

You’ll obtain an understanding of the difference between cubes created with SQL Server Analysis Services, and data in relationel databases. Also you’ll get aquainted with star-schema models, measures and hierarchies.

The following will be covered:

  • Introduction to star-schema
  • Data in relationel databases
  • Introduction to SQL Server Analysis Services and cubes
  • Measures and hierarchies
  • Quick Measures

Module 3 - Reports and Visuals

We will present good principles in designing reports and how to take advantage of the buildin Visuals. After this module you’ll be able to insert, configure and format Visuals.

The following will be covered:

  • Good design principals for reports
  • Cards, Tables, Matrices and Charts
  • Plotning geographical data
  • Formatting the different Visuals
  • Conditional formatting
  • Import additional Visuals from Marketplace (Appsource)

Module 4 - Filters and Slicers

You learn how to implement filters on different levels and design Slicers to make users able to select data in a friendly user interface. You’ll be able to decide how filters interacts between different Visuals and syncronise Slicers across multiple report pages.

The following will be covered:

  • Filters between Visuals
  • Background filters
  • Slicers
  • Syncronising Slicers between pages

Module 5 - Interactivity

In this module you will learn how to create interactive reports containing e.g. tooltips, drill-down and bookmarks, making users able to navigate in the reports and search for data e.g. by using buttons.

The following will be covered:

  • Tooltips and Page Tooltips
  • Drill-Downs
  • Drill-Through
  • Bookmarks and navigation

Module 6 - Layouts

Here you will learn how to adjust layouts in the report. Preparing them for different platforms, such as a webbrowser or mobile views.

The following will be covered:

  • Page sizes
  • Backgrounds
  • Themes
  • Layouts

 


Kursusdato


Praktiske oplysninger
Pris:
kr. 4.500,- (ekskl. moms)
Varighed:
1 dag


Er I flere fra samme virksomhed, som skal på kursus? Så kan der være penge at spare med et virksomhedskursus

Læs mere om virksomhedskurser her

Andre populære kurser


Aktuelt

IT Executive Masterclass
En praktisk orienteret it-lederuddannelse. Få værktøjerne, erfaringerne og metoderne til at navigere effektivt i krydsfeltet mellem ledelse, teamet, kunderne og digitaliseringskrav.
Læs mere og tilmeldt dig her

Teamlederkursus
Som leder står du måske til tider i en udfordrende, og muligvis vanskelig, leder-position. Vi har sammensat dette kursusforløb, hvor du bliver trænet i ledelsesmetoder med udgangspunkt i situations-bestemt ledelse og kommunikation, der er tilrettet teamleder-rollen.
Læs mere og tilmeld dig her

Excel Udvidet - online kursus
Du arbejder i Excel, men vil gerne være skarpere på formler og funktioner. Du vil gerne vide, hvordan Excel automatisk kan visualisere resultater og nøgletal, og så vil du gerne lære at oprette drop down lister til at foretage nemme valg.
Læs mere og tilmeldt dig her

Excel kursus til regnskab og bogholderi
Få en målrettet undervisning i hvordan Excel kan anvendes til regnskab og bogholderi. Vi giver tips og tricks til at lette arbejdet og sikrer at du får praktisk øvelse i typiske opgaver som afstemning af konti, budgetlægning og -opfølgning på dette kursus.
Læs mere og tilmeldt dig her

Kursuslokaler udlejes med og uden PC
Har du brug for et undervisningslokale med plads til op til 15 deltagere, så kan vi tilbyde fuldt udstyrede lokaler. Pris pr. dag 3.500.- kr. Forplejning 250.- kr. pr. person pr. dag.
Inkl. i prisen er teknisk support og service. Interesseret?
Kontakt os på telefon 77 300 123 og hør mere.


Hørkær 18
2730 Herlev
Tlf: 77 300 123
Email: idgkurser@idg.dk
CVR: 65970414