Power BI Fundamentals Course in English

Niveau
Tijdsduur
Locatie
Op locatie, Online
Startdatum en plaats
Logo van SignOn ICT Trainingen+
Opleiderscore: starstarstarstarstar_half 9,2 SignOn ICT Trainingen+ heeft een gemiddelde beoordeling van 9,2 (uit 851 ervaringen)
Beste opleider van Nederland

Winnaar Beste opleider van Nederland 2020: #2 in Automatisering & ICT/IT en #3 beste grote opleider.

Winnaar Beste opleider van Nederland 2018: #2 in Automatisering & ICT/IT.

Winnaar Beste opleider van Nederland 2017: #1 in Automatisering & ICT/IT.

Lees meer over Beste Opleider van Nederland 2020.

Tip: meer info over het programma, prijs, en inschrijven? Download de brochure!

Startdata en plaatsen

computer Online: Online training (from home or work)
15 sep. 2021 tot 22 sep. 2021
check_circle Startgarantie
Toon rooster
event 15 september 2021, 09:00-16:00, Online training (from home or work)
event 22 september 2021, 09:00-16:00, Online training (from home or work)
computer Online: Online training (from home or work)
24 nov. 2021 tot 1 dec. 2021
check_circle Startgarantie
Toon rooster
event 24 november 2021, 09:00-16:00, Online training (from home or work)
event 1 december 2021, 09:00-16:00, Online training (from home or work)

Beschrijving

SignOn ICT Trainingen+ verzorgt al ruim 18 jaar ICT trainingen en consultancy in heel Nederland.

  • Beste ICT Opleider van Nederland 2017, 2018 en 2020
  • Hoge opleiderscore 9.4/10
  • Microsoft Partner Silver Data Analytics
  • CEDEO gecertificeerd
  • PE- erkend
  • Cursuslocaties van topkwaliteit
  • Klassikaal op locatie | Klassikaal online | In-company / Maatwerk | Individeel | E-Learning
  • Unieke switchgarantie
  • Unieke nazorg en consultancy 

Onze cursuslocaties zijn vanaf 1 maart  2021 weer geopend voor essentiele trainingen. Neem voor meer informatie contact met ons op.

Power BI Course (in English)

After following this Power BI Fundamentals 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, 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 that 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 …

Lees de volledige beschrijving

Veelgestelde vragen

Er zijn nog geen veelgestelde vragen over dit product. Als je een vraag hebt, neem dan contact op met onze klantenservice.

Nog niet gevonden wat je zocht? Bekijk deze onderwerpen: Power BI, Business intelligence, Splunk, Microsoft Power Platform en Microsoft PowerPivot.

SignOn ICT Trainingen+ verzorgt al ruim 18 jaar ICT trainingen en consultancy in heel Nederland.

  • Beste ICT Opleider van Nederland 2017, 2018 en 2020
  • Hoge opleiderscore 9.4/10
  • Microsoft Partner Silver Data Analytics
  • CEDEO gecertificeerd
  • PE- erkend
  • Cursuslocaties van topkwaliteit
  • Klassikaal op locatie | Klassikaal online | In-company / Maatwerk | Individeel | E-Learning
  • Unieke switchgarantie
  • Unieke nazorg en consultancy 

Onze cursuslocaties zijn vanaf 1 maart  2021 weer geopend voor essentiele trainingen. Neem voor meer informatie contact met ons op.

Power BI Course (in English)

After following this Power BI Fundamentals 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, 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 that 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 are the benefits for you?

During the 2-day Power BI Course (Fundamentals) 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

For whom?

For Employees of HR, Sales, Logistics, Finance, ICT Analysts, Controllers, Accountants, Financial Specialists, BI specialists and other experienced Excel users who want to build BI dashboards, Users who want to know more about Microsoft Power BI Desktop, Users who have to combine and consult various data collections, Users who want to visualize data outside of Excel, Users who have to share data visualization and overviews online, Users who want to learn how to edit larger data collections.

Foreknowledge

  • To be able to follow this Power BI course, knowledge at Excel Advanced level and knowledge of pivot tables is required.

Are you unsure whether this training suits your knowledge and skills? Then contact us for advice or call us on 020-820 83 62.

After following this course you will have knowledge of:

  • 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

Preparation

We ask you to create a Power BI account immediately upon registration via Powerbi.com with your business e-mail address. During the Power BI course you work with your personal account. Do you not have a business e-mail address? Then you can register here for a free Microsoft 365 trial and create a work account. Then use that new work account to register for the Power BI service. You can still use Power BI after the trial version of Microsoft 365.

Language

The standard language during the course is English. An In-company tailor-made training can also be given in other languages. This basic training is also given in Dutch, see Power BI Basic course in Dutch.

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

After the training you will receive a certificate.

Permanent Education: Achieve 12 PE-points

The Power BI Basic Course in English is accredited by the Royal Dutch Professional Association of Accountants (NBA). The training is good for 12 PE points/PE hours.

Follow-up course

Do you want to follow a follow-up course after this Power BI Fundamentals course? Then the Power BI Advanced Course (in English) course is highly recommended.

Exclusive aftercare

If you have questions after the Power BI Fundamentals training? Please contact your trainer at support@signon.nl. You will receive an answer almost immediately with extra explanation; by phone or e-mail. This unique aftercare service is exclusively for participants of our training courses. SignOn has the statusstatus 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.

Course outline

The following topics are covered during the 2-day training Power BI Fundamentals:

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

Blijf op de hoogte van nieuwe ervaringen

Er zijn nog geen ervaringen.
  • Vraag informatie aan over deze cursus. Je ontvangt vanaf dan ook een seintje wanneer iemand een ervaring deelt. Handige manier om jezelf eraan te herinneren dat je wilt blijven leren!
  • Bekijk gerelateerde producten mét ervaringen: Power BI.

Deel je ervaring

Heb je ervaring met deze cursus? Deel je ervaring en help anderen kiezen. Als dank voor de moeite doneert Springest € 1,- aan Stichting Edukans.

Er zijn nog geen veelgestelde vragen over dit product. Als je een vraag hebt, neem dan contact op met onze klantenservice.

Download gratis en vrijblijvend de informatiebrochure

Aanhef
(optioneel)
(optioneel)
(optioneel)
(optioneel)
(optioneel)
(optioneel)
(optioneel)
(optioneel)
We slaan je gegevens op, en delen ze met SignOn ICT Trainingen+, om je via e-mail en evt. telefoon verder te helpen. Meer info vind je in ons privacybeleid.