Power BI Basics (English)

Power BI Basics course (English)

Learn the fundamentals of Power BI! After following this Power BI Basics course you can, among other things, make advanced analyzes, interactive reports and data models. You get direct access to all important data from local and cloud-based sources such as Excel, AFAS, SharePoint, Dynamics 365 and hundreds of other programs. Do you want to share this data directly with your colleagues? Then we help you get to know the many possibilities of Power BI Desktop, so you can do everything simpler and faster. In this course you will also learn how to set up a Power BI model with Dim and Fact tables.

You will be guided through recognizable examples through the first basic formulas of the DAX formula language. DAX is a formula language with which you can perform all kinds of calculations with your data in Microsoft Power BI. The language is comparable, sometimes even identical, to Excel formulas. But with DAX even more is possible and the usage is a bit more complex. You use the Power Query and Power Pivot functions to collect, clean and enrich business data via standard tools and the start of DAX. After you have designed a BI (Business Intelligence) model, you can start analysis and reporting via the Pivot Table function. Finally, you learn how you can publish your reports to PowerBI.com and how you can share them with your colleagues.

What will I learn?

During this 2-day Power BI Basics course in English, you will receive, in addition to many exercises, various practical examples to work with. As a result, after the courses you know how to make effective, efficient analyzes, interactive reports and dashboards instantly. This allows you to apply multiple components of Power BI after following this course. For example: Advanced Analytics, Interactive reports, Data models, Dashboards, Set up a Power BI model with Dim and Fact tables, Basic formulas of DAX

Who should attend?

Experienced Excel users who want to build BI dashboards and want to learn more about Microsoft Power BI Desktop.

Skills gained

• Fundamentals of Power BI
• Power BI Desktop & Online introduction
• Retrieving data from various data sources
• Linking various sources and creating relationships
• Modeling data and date tables
• Visualization of data in Power BI Desktop:
• Various shapes
• Power BI Online

Prerequisites

To be able to follow this Power BI training course, knowledge at Excel Advanced level and knowledge of pivot tables is required. Are you unsure whether your knowledge is sufficient for this training? Contact us for free advice, call (+31) 020 - 820 83 62 or use our contactform.

Language

The standard language during the course is English. This basic Power BI training is also available in Dutch. Looking for an inhouse Power BI training? Our inhouse course will be tailor-made and is available in English, Dutch and German.

Power BI courseware

SignOn always provides all participants with the comprehensive current Power BI course material. As a result, you also have a handy reference work 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 Advanced training course (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 an answer almost immediately with extra explanation; by phone or e-mail. This aftercare service is exclusively for participants of our training courses.

Course outline

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

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.

STAP-budget

In this training you can use the STAP budget. With this, the Dutch government makes €1,000 available to everyone for a training budget. You can use this amount for 1 training course. More information about STAP.

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.