Power BI Desktop (via e-learning)
Deze cursus in het kort
- Locaties door heel Nederland
- Professionele docenten
- Inclusief certificaat
- 9.4 op Springest.nl
- Ook bij u op locatie
Microsoft Power BI Desktop is designed for analysts. Advanced interactive visualizations are combined with industry-leading built-in data queries and modeling. Create and publish your reports in Power BI. This way you can provide others with timely insights anywhere, anytime.
Omschrijving
The aim of the course Power BI Desktop (via e-learning) is to learn to connect to one or more data sources, to prepare the raw data, to make sense out of it, and to build a modern-looking and engaging dashboard. By the end of the main modules, you will be able to practice and go through one or more exercises. The files required to do the exercises, and the solution files, can be downloaded.
The course is self-study. You can decide for yourself what, where, when and how fast you want to learn. This form of learning is particularly suitable for people who want to learn what they need at their own pace. Of course, this requires some self-discipline.
Because it concerns self-study, you determine the duration of the course yourself. You have twelve months to complete the course.
The expected duration of the training is approximately 6 hours.
Inhoud
During the course Power BI Dekstop the following modules will be covered:
Connecting and preparing data
- Connecting to an Excel workbook
- Preparing the imported Excel data
- Importing an Excel file cross-table
- Exercise 1: Importing orders from an Excel file
- Connecting to a database
- Extracting, cleansing and filtering data from the imported base
- Creating columns from examples and adding conditional columns
- Connecting to other data sources (txt, csv, pdf, SharePoint list)
- Exercise 2: Importing the tables from the French Books Sales file
- Solution 1: Importing orders from an Excel file
- Solution 2: Importing the tables from the French Books Sales file
Setting up the model
- Introduction and steps
- Setting up the relationships
- Creating the calendar table
- Creating the explicit measures
- Organising the fields in the Model view
- Exercise 3: Setting up the Financial file model
- Exercise 4: Setting up the Fench Books Sales file model
- Solution 3: Setting up the Financial file model
- Solution 4: Setting up the Fench Books Sales file model
Creating a dashboard and visuals
- Creating a dashboard page
- Creating a bar chart
- Creating a line chart
- Creating a pie chart
- Displaying summary data with a card
- Displaying geographical data
- Creating a table
- Creating a cross-table
- Using slicers
- Exercise 5: Creating charts using the French Books Sales file
- Exercise 6: Creating a table and a cross-table using the French Books Sales file
- Solution 5: Creating charts using the French Books Sales file
- Solution 6: Creating a table and a cross-table using the French Books Sales file
Creating DAX formulas
- filter context and its propagation: Dax’s key concept
- Using the CALCULATE function
- Using the ALL function
- Counting with the COUNTROWS and the DISTINCTCOUNT functions
- Analysing trends using the DATEADD function
- Exercise 7: Use the CALCULATE, COUNTROWS and DATEADD functions to create a table using the French Books sales file
- Solution 7: Use the CALCULATE, COUNTROWS and DATEADD functions to create a table using the French Books Sales file
Interactions
- Mastering natural interactions
- Drilling into detailled data
- Exercise 8: Adjusting interactions in the French Books Sales file dashboard
- Solution 8: Adjusting interactions in the French Books Sales file dashboard
Applicative design: dashboard design example
- The principles of applicative design (user experience design)
- Preparing the page backgrounds and the theme
- Adding visuals
- Adding buttons to the tabs
- Using bookmarks
- Adding slicers and dynamic titles
- Adding tooltips
- Using conditional formatting in tables
- Overview of the process
Publication
- An overview of publishing on Power BI Service
- Publishing a dashboard and using it
Plaats en data
Voor deze cursus zijn momenteel geen data gepland. Neem via onderstaand formulier contact met ons op voor meer informatie over de mogelijkheden.
