Power BI Basic (English) - Classroom

Power BI Course – Basic (English)

After completing this 2-day Power BI Basics training, you will be able to create advanced analyses, build interactive reports, and develop data models in Power BI. This is an ideal course for people who are starting with Power BI.

Importing Data

You will learn how to import data using queries from local and cloud-based sources such as Excel, SharePoint, AFAS, and SQL databases using Power BI.

Sharing data with colleagues
Would you like to share this data with your colleagues in a quick, easy, and safe way? We will help you gain extensive knowledge of the many possibilities of Power BI Desktop and Power BI Online. In this training, you will also learn how to set up a solid Power BI data model with Dim (dimension) and Fact tables. This ensures your report not only looks good but also performs well. Even with millions of rows of data.

DAX formula language
Power BI uses the advanced formula language DAX (Data Analysis Expressions) for calculations. This language is similar to Excel but offers more possibilities and is slightly more complex. Our trainers guide you through the most important basic functions of DAX using practical examples of easy-to-understand examples.

Power Query
With the Power Query Editor, you will learn how to gather data, clean it up, and enrich it. After designing a data model, you can start creating an interactive report. Finally, you will learn how to publish your created reports in Power BI online and how to share them securely with your colleagues

What will I learn?

During the 2-day Power BI Basics course, you will work on many exercises and practical examples. After completing this course, you will be able to apply all key components of Power BI.

• The different components and basic usage of Power BI
• Importing data from different data sources
• Connecting various data sources and creating relationships
• Building an efficient and simple data model
• The importance of date tables and how to create them
• Visualizing information and creating reports
• Publishing and sharing reports via Power BI Online

Who should attend?

This course is suitable for business consultants, HR staff, marketers, sales, logistics and finance employees, analysts, registered controllers (RC), business controllers, accountants (RA and AA), financial specialists, BI specialists, financial professionals, and other experienced Excel users who want to build BI dashboards.

It is also suitable for users who want to learn more about Microsoft Power BI Desktop, combine and analyze various datasets, visualize data outside of Excel, share data visualizations online, and work with larger datasets.

Prerequisites

To get the most out of this Power BI Basics course, you should have an advanced level of Excel knowledge. For example, you should be able to create pivot tables and use (basic) formulas in Excel. Unsure whether to choose the Power BI Basics or the Power BI Advanced training in English? Contact us for free advice, call (+31) 020 – 820 83 62 or use our contactform.

Blended Learning at SignOn

The classroom and online Power BI training is supported by the digital SignOn Learning Environment, which includes an introduction video, up-to-date course materials, various exercises, and a handy Power BI installation guide to help you prepare for your training.

At SignOn, learning doesn’t stop after completing this two-day training. You can ask questions to our trainers for up to one year, gain access to the learning portal with extra exercises and useful tips & tricks, receive monthly update videos about the latest Power BI features, and get invited to a free webinar. This unique teaching method enhances your learning results.

Language

This course is taught in English. This basic Power BI training is also available in Dutch. Looking for an in-house Power BI training? Our inhouse course will be tailor-made and is available in English, Dutch and German.

Power BI courseware

SignOn provides all participants with comprehensive and up-to-date digital Power BI course materials. This also serves as a useful reference after the training.

Certificate of Completion

After the training you will receive a certificate of completion that proves your newly aquired Power BI knowledge.

Follow-up course

Power BI Course – Advanced (also in English)

Exclusive aftercare

Any questions after the Power BI Basic training course? Please contact your trainer at support@signon.nl. You will receive a quick response with extra explanation; by phone or e-mail. This aftercare service is exclusively for participants of our training courses.

Meet your trainer

This training is delivered by one of our Power BI experts. They have years of experience and up-to-date knowledge. They understand the challenges you face in your daily work and provide practical tips and tricks. In addition to delivering training, they also work as Power BI consultants. Meet our Power BI trainers:

Jeroen

Freddy

Bart

Course outline

The following topics are covered during the 2-days Power BI course:

Power BI desktop introduction

• What are dashboards, reports and data sets
• Demo several examples: on laptop, website, iPad.
• Installing the Desktop tool
• Create an Account on PowerBI.com• First encounter with PowerBI desktop
• Using reports, filters etc.
• 5 minutes to wow: Create a report within 5 minutes

Retrieving data from different data sources

• Importing from various sources: CSV, TXT, Access, Excel, SAP, SQL, ORACLE, Microsoft Dynamics, etc.
• Merging several source files
• Import and merge files from folders
• Restructuring of data, splitting columns
• Unpivotting of excel tables to make them useable
• Retrieving data from Websites
• Basic knowledge of M language within Power BI desktop

Linking various sources and creating Relationships

• Linking to relational models in Excel, Access, Databases
• Creating links between CSV and Excel files
• Difference between Dim and fact tables

Modeling data and date tables

• Restructuring of columns
• Customize field types
• Create hierarchies
• Preparation for calculations
• Setting up a date table using Dax, with hierarchies
• Setting up multiple calculated measures for the OLAP cube, beginning of DAX.With functions likeSum, Count, DistinctCount, Related, Calculate
• Understanding the difference between calculated columns and measures:
• Understanding the difference between implicit and explicit measurements

Visualization of data in Power BI Desktop: various ways

• Visuals by using tables, matrices, shapes, charts, map shapes
• Building reports with slicers, filters
• Creating 3D slicers
• Use internal date hierarchies for matrices and graphs
• Formatting of reports, tables
• Filters on page or report level
• Conditional formatting
• Importing additional Visual AidsS
  • TreeMap charts, Slicers, Funnels, Gauges s, KPI meters, Time Slicers

Power BI On line

• Working directly in Power BI Online
• Linking data from OneDrive
• Analysis of restrictions in Online environment
• Instantly publish from PowerBI desktop
• Dashboards (switchboards) vs. Reports
• Linking pages and cards to dashboards
• Using Q & A within Power BI desktop
• Extra possibilities with tiles
• Customizing Visual interactions within reports
• Searching of reporting information on website

Delivery formats

Choose a delivery format that suits you best. The following delivery formats are available for this course:

• Classroom live

  A face-to-face training on a location in the Netherlands. Employees from different companies are present during this classroom training. Fully catered for, including an extensive lunch.

• Virtual classroom

  Attend a the virtual classroom course from any location (workplace or home). You learn from a live instructor and are in contact with other participants. The instructor has the possibility to look at your screen (if necessary) to answer all your questions. This training will take place via Microsoft Teams (free of use).

• In-company course

  Our in-company training is tailored to your company. The specialized trainer only deals with what is important for your company and work situation. That makes our tailor-made training very effective. We provide these training courses in Dutch, English and German. The choice for an in-company training provides an attractive discount. Depending on the number of participants, the discount can be as much as 50% compared to participation in an open training. More information or request a quote.

Microsoft Partner – Silver Data Analytics

SignOn has the status Microsoft Partner – Silver Data Analytics and thus demonstrates that the knowledge, skills and performance are of a high level. We show that we are fully aware of the latest techniques in Microsoft Power BI and Big Data.

Microsoft Certified Trainers

Our Microsoft Certified Trainers (MCT) are experts in their field and are certified according to Microsoft’s terms and conditions. In addition to providing training, they also work in projects and know daily practice like no other. As a result, they know what students have to deal with and encounter daily. They use their practical experience to enrich the theory in the classroom.

Cedeo Recognition: What Does It Mean for You?

Cedeo is a household name when it comes to education. There are approximately 300 Cedeo-recognized institutes in the Netherlands. By choosing a Cedeo-approved supplier, you can therefore be sure that you are choosing one of the better education institutes.

SignOn and the UWV

SignOn ICT Training+ is a recognized training partner of the UWV. SignOn ICT Training+ is one of the few ICT educational organizations recognized by the UWV to provide training to help people return to the labor process.