Details
Power BI Course E-Learning
- Language: English or Dutch
- Audience: Anyone who processes and analyses large amounts of data to create efficient and relevant dashboards with Power BI Desktop.
- Level: Basic
- Required knowledge level: Good Excel skills are a useful prerequisite for this course.
- Course duration: 5 hours (depending on personal speed)
- Online access: 24/7, 365 days after activation
- Certificate of Attendance included
The goal of this video course is to learn to connect to one or more data sources, prepare the raw data, extract something meaningful from it and build a modern-looking and attractive dashboard. At the end of the main modules, you can practice and go through one or more exercises. The files needed to create the exercises and the solution files can be downloaded.
Outline
Course Content
Estimated time to study the essential module
Duration of the videos: 3 hours and 22 minutes Duration of the practical exercises: 1 hour and 45 minutes
- Presentation of the course
- Power BI Desktop presentation
- Work process and key concepts
- How this course is organised
- 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
- 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 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
- The 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
- 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
- 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
- An overview of publishing on Power BI Service
- Publishing a dashboard and using it
Special Offer
Check website
Reviews
Be the first to write a review about this course.
Write a Review
What is OEM Office Elearning Menu?
OEM Office Elearning Menu provides ICT training to businesses and individuals, for end users or ICT professionals of all skill levels. From Microsoft Office to Certified Ethical Hacker, with over 200 brands of training we are sure we can get you started. By responding to new technology, we can always keep our training offerings relevant. Plus, we employ our own instructors, all of whom are certified and have years of hands-on experience.
What does OEM Office Elearning Menu do?
We offer comprehensive, customized ICT training from a variety of major A-brands to certification. For Microsoft Office, we can provide training in five languages: Dutch, English, French, German and Spanish. For Microsoft Office, we also take the exams. In addition to Microsoft Office, we offer customized training for all kinds of other software. This makes us the one-stop shop for all ICT training. Our goal is to teach people how to work with software in a goal-oriented and efficient way. We find good communication very important. We offer short lines of contact. Our customers always have a fixed point of contact with us.
How does a training course at OEM Office Elearning Menu work? ...
OEM Office Elearning Menu provides ICT training to businesses and individuals, for end users or ICT professionals of all skill levels. From Microsoft Office to Certified Ethical Hacker, with over 200 brands of training we are sure we can get you started. By responding to new technology, we can always keep our training offerings relevant. Plus, we employ our own instructors, all of whom are certified and have years of hands-on experience.
What does OEM Office Elearning Menu do?
We offer comprehensive, customized ICT training from a variety of major A-brands to certification. For Microsoft Office, we can provide training in five languages: Dutch, English, French, German and Spanish. For Microsoft Office, we also take the exams. In addition to Microsoft Office, we offer customized training for all kinds of other software. This makes us the one-stop shop for all ICT training. Our goal is to teach people how to work with software in a goal-oriented and efficient way. We find good communication very important. We offer short lines of contact. Our customers always have a fixed point of contact with us.
How does a training course at OEM Office Elearning Menu work? ...