Designing Reports in Power BI (conducted in English) kursus

You will learn

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.

After the course you will be able to handle these tasks:
  • 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

In the section ”Course content” further down on this page, you can read all about, what will be presented on this course.
If you´re also going to work with extracting data and build a Datamodel, then instead we will suggest the course: ”Analyze and visualize data with Power BI”.
Please note that this course also exist in a conducted in Danish version: Design af rapporter med Power BI

You get

During the course
  • Teaching by the most experienced instructor team in our cozy and fully updated classrooms located in the center of Copenhagen.
  • A course that consists of a both theory and practical exercises. We know the importance of having practical exercises and hands-on is always in focus during the courses.
  • A course material you can use as an encyclopedia after the course and downloads of course exercises.
  • All meals, which includes breakfast, fresh coffee, tea, fruit, soft drinks, lunch in an Italian restaurant, cake, candy and off cause Wi-Fi to your devices.
  • A course certificate as a proof of your new skills.

After the course
  • Access to our free hotline service, which means that you up to a year after the completing of the course can contact us if you have questions regarding subjects from the course.
  • We have a unique satisfaction guarantee in order to ensure you the complete benefit from the course.

Get the best benefit from the course

This Power BI course is a part of 4D's unique collection of English conducted courses and is designed for business analytics, controllers or similar rolles, that wants to start working with Self- Service Business Intelligence.

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

Course Details

Module 1 - Introduction to Power BI
In this module, you are introduced to the tools and services related to Power BI. You are introduced to the local tool Power BI Desktop, where you can develop Reports and Dashboards.

The following will be covered:
  • Introduction to Power BI
  • Introduction to Power BI Desktop

Module 2 - Introduction to Datamodels
In this module you are introduced to different types of Datamodels and how to connect to them using Power BI Desktop. You are introduced to the structure in a Star Schema Model and the difference between Fact- and Dimensions tables.

The following will be covered:
  • Introduction to Star Schema Model
  • Data in relational databases
  • Data in a tabular data model
  • Measures and calculated columns
  • Hierarchies

Module 3 - Visuals
In this module you will learn how to implement a number of Visuals into a Power BI report. You will learn how to design- and format these Visuals.

The following will be covered:
  • Tables, Matrices and Charts
  • Plotting geographical data
  • Formatting the Visuals

Module 4 - Report layout
In this module you will learn some basic principles when designing reports. You’ll learn to use the correct Visuals when presenting certain key values. You will also learn how to create- and use themes, to secure a standardised design of your reports but also more time effective. Designing the report pages for mobile views are also presented.

The following will be covered:
  • Good principles for report/dashboard design
  • Page formatting
  • Themes
  • Mobile Layout

Module 5 - Analysis in Visuals
In this module you will learn how to use conditional formatting in visuals, making the format more dynamic, so users easily can focus on the most important key values and quickly identify deviations. You will learn how to add additional analytic lines to the visuals e.g. averages and percentiles.

The following will be covered:
  • Small Multiples
  • Sparklines
  • Analytics lines
  • Conditional formatting

Module 6 - Additional Visuals
In this module you will learn how to use more specialised visuals, amongst other Q&A, giving the option of querying data without having to build advanced DAX expressions. You will also learn how to import and use some of the many visuals from Microsoft AppSource.

The following will be covered:
  • Visuals from AppSource
  • Score Cards
  • Smart Narrative
  • Q & A

Module 7 - Filters and Slicers
In this module you will learn how to use the filters panel and slicers in reports, so end users can select the data to focus on. You will learn to implement filters on different levels and how to synchronise slicers cross different report pages.

The following will be covered:
  • Filters between visuals
  • Background filters
  • Slicers
  • Synchronising slicers between pages

Module 8 - Interactivity in reports
In this module you will learn how to implement different types of interactivities in the report. You will learn how to create page tooltips and drill-through. It is presented how to design reports with multiple pages and navigate through these pages e.g. by using buttons.

The following will be covered:
  • Tooltips and page tooltips
  • Hierarchies and drill-down
  • Drill-through

Module 9 - Bookmarks and navigation
In this module you will learn how to implement bookmarks in a report with more advanced interactivity e.g. using menus for changing between certain data or visuals on a page.

The following will be covered:
  • Introduction to bookmarks
  • Creating and updating bookmarks
  • Interactivity with bookmarks

Hvad siger vores kunder om os?

Se vores google reviewsPå Google Bussiness har vi en score på 4,8 af 5 fordelt på 256 reviews

Se vores facebook Reviews

På Facebook har vi en score på 5 af 5 fordelt på 162 reviews

 

 

Se alle vores reviews 

 

 

Hold dig opdateret med vores nyhedsbrev

Modtag nyheder, gode tilbud, tips og tricks med vores månedlige nyhedsbrev.

Vi har både et Office/Adobe nyhedsbrev og et nyhedsbrev for vores tekniske Microsoft kurser.

Her bor vi

Hovedindgang
Amagertorv 21
1160 København K
Kursusindgang
Læderstræde 22-26
1201 København K
Åbningstider
Mandag: 08.30 - 15.30
Tirsdag: 08.30 - 15.30
Onsdag: 08.30 - 15.30
Torsdag: 08.30 - 15.30
Fredag: 08.30 - 15.30

 

Kontaktoplysninger

 
Amagertorv 21
1160 København K