PowerBI course

The main purpose of the PowerBI basic course is to get users familiar with modern Microsoft technology. 

This technology greatly facilitates the processing and analysis of large amounts of data coming from a number of different sources.

PowerBI can be used to connect to over 200 data sources, merge them in a single model, and create a stable reporting system as the base for making better, faster, and more quality decisions.

This course is most often combined with PowerQuery and DAX courses, the 2 most important tools used for automation and data modeling within the PowerBI system.

Courses that are most often taken in adition to the PowerBI basic course:

Course goals

Introduce the participants with the possibilities of the PowerBI platform and PowerBI desktop version. Participants will be presented with the possibilities of the basic data imports from different sources, how to create interactive reports and the possibilities of report sharing through the application or by publishing to the web page.

Participants

This course is intended for all the participants who have little to no experience with PowerBI desktop or platform application.

Notes

In order to attend this course, you will need to have the latest PowerBI desktop application installed (installation is free). For certain parts of the course it is advisable to use business e-mail to access PowerBI platform (PowerBI prohibits logins coming from private e-mail addresses eg. someone@gmail.com).

Course content

Intro

  • What is PowerBI?
  • PowerBI desktop basics
    • Visual, Data, Relationship view
    • Tables, columns, calculations
  • PowerBI web service basics
    • My Workspace vs App Workspace
    • Datasets, Reports, Dashboards
    • Types of report and application sharing
    • Types of user licensing

PowerBI Desktop First Part

  • Data import
    • .CSV, Excel
    • Basics of PowerQuery interface
    • Data transformations using PowerQuery
  • Development of a basic data model
    • What does the data model mean?
    • Loading data
    • Merging data
    • Star Schema
  • Basics of calculations
    • The way each calculation in the data model works?
    • Data filtering
    • Making basic DAX calculations
  • Basics of calculation columns
    • Columns vs Measures-  when to use which type?
    • Columns in PowerQuery vs columns in the data model
    • Making conditional calculation columns

PowerBI Desktop Second Part

  • Data visualization
    • Adding visuals and fields
    • Main characteristics of each visual
  • Interaction between different visuals
    • Filter, highlight, cross filter, slicers
  • Interaction between different report pages
    • Drillthrough
    • Sync Slicers
    • Tooltip page
    • Report level filter
  • Bookmarks&Selection pane
    • Achieving additional interactivity within the report
  • Report topics
  • Performance analyzer
    • Finding slow calculations or parts of models that reduce the speed of interaction

PowerBI Web Service

  • Uploading a report to a web service
    • App workspace
    • Application development
    • Sharing the app with users
  • Collaboration on web service
    • Access to reports
    • Commenting and subscriptions
  • Setting up automatic data refreshes
    • Data Gateway
    • Schedule refresh options

Extra Elements

  • Row-level security
    • Defining a granular approach to reports depending on the employee position in the company.
  • Alerts
  • Analyze in Excel
    • Merging Excel into a data model and making ad-hoc analysis
  • Q&A, quick insights
  • Dataflows introduction (optional)
  • Admin portal options (optional)

For more guidance about general course structures and ways of course handling please follow this link.

Why choose us?

So far, we have held over 20 training in larger or smaller groups of participants. During courses, we share our experience that we have acquired through 9+ years working with PowerQuery and DAX technologies, and we have been working with PowerBI since its initial launch in 2015.

In addition to training, our company is also actively involved in the implementations of PowerBI solutions (15+ successfully implemented), so we are always head to head with the latest technologies related to the PowerBI ecosystem.

We share our knowledge!

We love to show our knowledge as transparently as possible, so that you know what you are getting for your investment! That is why we regularly publish new blog articles, record videos on the same topics (Youtube channel), and additionally we have created an online video course about the fundaments of the PowerQuery tool!

Course information
Course duration

8h

Course difficulty
basic to intermediate
Minimal attendees

4

Maximal attendees

25

Price per attendee (netto) *

230,00 €

Course first time held:
2017.

*Additional discount is offered for each new attendee. If you have more attendees to apply for the course, or you would like to combine multiple courses, please contact us through the form below. Based on your inquiry, we will send you a more personalized offer.

Lecturer

Krešimir Ledinski

More than 6 years of experience with PowerBI.
Holds Microsoft MCSA Certificate in the field of BI reporting.
Learn more about Krešimir

Get a special quote for your group

By submitting a form you accept Exceed's Privacy Policy
+
Users
+
Workshops
+
Educational videos
+
Educational blogs
Scroll to Top