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
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
Tilmelding til kurset:
Designing Reports in Power BI (conducted in English)
Nyhedsbrevmodtagere har ved tilmelding af nyhedsbreve hos 4D A/S accepteret, at vi udsender vores nyhedsbreve til den oplyste e-mailadresse.
Udsendelse
Hos 4D A/S udsender vi vores nyhedsbrev ca. 1 gang om måneden.
Spam
Nej, vi spammer dig selvfølgelig ikke med alt muligt irrelevant :)
Indsamling af data
Ved oprettelse af e-mail-abonnement giver du samtidig samtykke til, at 4D A/S registrerer de oplysninger, som angives ved tilmeldingen. Oplysningerne bruges udelukkende til internt brug.
Afmelding af e-mail-abonnement
Tilmeldte kan til enhver tid afmelde sit nyhedsbrevsabonnementet og ved afmelding slettes alle oplysningerne forbundet med tilmeldingen. Afmelding kan ske via nyhedsbrevene.
Dine rettigheder
Tilmeldtes rettigheder i forbindelse med 4D A/S's behandling af personoplysninger følger loven om behandling af personoplysninger, og tilmeldte har til enhver tid mulighed for at få oplyst, hvilke oplysninger 4D A/S har registreret. Oplysningerne indsamles alene til internt brug og opbevares på en sikret server. Oplysningerne hverken sælges, udlejes eller videregives til tredjemand.