Microsoft Power BI

Official PL-300T00 Microsoft Power BI Data Analyst Course

Businesses need data analytics more than ever. In this learning path, you will learn about the life and journey of a data analyst, the skills, tasks and processes they go through to tell a story with data to make trusted business decisions. You will learn how the suite of Power BI tools and services are used by a data analyst to tell a compelling story through reports and dashboards and the need for true BI in the enterprise.

Classroom Dates 2024

  • 06.03.2024 - 08.03.2024 (ZURICH) - book now

 

Microsoft Power BI Schulung Data Analyst

 

COURSE DESCRIPTION

The PL-300T00 Microsoft Power BI Data Analyst course teaches effective methods as well as best practices for data modelling, visualisation and analysis that meet both business and technical requirements. The course also demonstrates how to access and process data from various data sources, including relational and non-relational data. Furthermore, the course comprehensively explains and implements appropriate security standards and policies across the Power BI spectrum, including datasets and groups. You will also learn how to efficiently manage and deploy reports and dashboards for optimal content sharing and distribution.

 

TARGET GROUP

The target audience for this course is data professionals and business intelligence experts who want to learn how to perform accurate data analysis using Power BI. This course is also aimed at people who develop reports that visualise data from data platform technologies that exist both in the cloud and on-premises Participants do not need to have experience with Power BI before taking this course. However, they should have a basic understanding of key data concepts, knowledge of working with relational data in the cloud, knowledge of working with non-relational data in the cloud, and knowledge of data analysis and visualisation concepts. In addition, basic knowledge of computer technology, cloud computing and the internet is assumed.

Content

  • Ingest, cleanse and transform data 
  • Model data for performance and scalability
  • Design and create reports for data analysis
  • Apply and run advanced report analytics
  • Manage and share reporting resources

 

Book your training in our E-Shop

  • COURSE REQUIREMENTS

    • Understanding of the main database concepts
    • Knowledge of working with relational data in the cloud
    • Knowledge of working with non-relational data in the cloud
    • Knowledge of data analysis and visualisation concepts
  • TECHNICAL REQUIREMENTS

    • Microsoft Power BI Desktop (free download)
    • PC or laptop with a Windows operating system
  • TARGET GROUP

    • Data professionals
    • Business Intelligence Experts
    • Data Analysts
    • Data Architects
  • LANGUAGE

    • German
    • English on request
  • TRAINING MODALITIES

    • Classroom / Virtual / On-site
    • Public / Private (for groups of up to 10 persons)
  • DURATION

    • 3 days

DETAILED PROGRAM FOR MICROSOFT POWER BI DATA ANALYST TRAINING PL-300T00

FIRST STEPS WITH MICROSOFT DATA ANALYTICS

  • Data analysis and Microsoft
  • First steps with Power BI

RETRIEVING DATA IN POWER BI

  • Preparing data

CLEANING, TRANSFORMING AND LOADING DATA INTO POWER BI

  • Shaping data
  • Loading data

DESIGNING A DATA MODEL IN POWER BI

  • Introduction to data modelling
  • Working with tables
  • Dimensions and hierarchies
  • Creating model relationships
  • Configuring tables and column properties
  • Creating hierarchies

CREATING MODEL CALCULATIONS WITH DAX IN POWER BI

  • Introduction to Power DAX
  • Creating calculated tables
  • Creating calculated columns
  • Creating key figures

CREATING REPORTS IN POWER BI

  • Designing a report
  • Creating and configuring a sync slicer
  • Creating a drill-through page
  • The use of conditional formatting
  • Creating and using bookmarks
  • Designing a report
  • Configuring visual fields and format properties

CREATING DASHBOARDS IN POWER BI

  • Creating a dashboard

IDENTIFYING PATTERNS AND TRENDS IN POWER BI

  • Advanced analytics
  • Data insights through AI visuals
  • Use the visual to predict values

 

Our Microsoft Power BI Expertise

CHOOSE THE RIGHT TRAINING PARTNER!

  • LONG-STANDING MICROSOFT PARTNER

    Informatec Microsoft Partner

  • CERTIFIED POWER BI DATA ANALYSTS

    Informatec certified Data Analyst

  • MICROSOFT CERTIFIED TRAINER 2023-2024

    Informatec Microsoft Certified Trainer

You are in good hands at the Informatec Data Intelligence Academy. Data is our passion and turning people into data experts is our vocation. In addition to Power BI training, as a Qlik Authorised Training Partner we offer official Qlik training courses.

Visit our Qlik Academy

 

REQUEST FOR MICROSOFT POWER BI TRAINING

Please fill out the form and send us your non-binding enquiry about our Microsoft Power BI training courses. Dates and costs on request.

I hereby agree to the privacy policy.

* Mandatory field to answer your request

The locations

The training courses take place at the COOP Tagungszentrum Muttenz (Basel-Land) or at the Ambassador House Zurich, where participants find the perfect setting for their training.

COOP convention center Muttenz (Basel Area)

  • COOP_Tagungszentrum
  • COOP_Tagungszentrum
  • COOP_Tagungszentrum
  • COOP_Tagungszentrum
  • COOP_Tagungszentrum

Ideal location: 15 minutes’ ride from Basel city centre (tram line 14, stop Freidorf), a few kilometers from the highway, parking available

First-class infrastructure: spacious premises, innovative working environment with modern conference facilities, all rooms with natural daylight, soundproof doors and air conditioning

Pleasant atmosphere: idyllic park, restaurant with market-fresh cuisine, professional service team

Address: COOP Tagungszentrum, Seminarstrasse 12-22, 4132 Muttenz

Route

 

Ambassador House Zürich

  • Ambassador House Zürich
  • Ambassador House Zürich
  • Ambassador House Zürich
  • Ambassador House Zürich

In the heart of Zurich North: The district offers a modern residential environment, many new restaurants, numerous shopping opportunities and a recreation area with its own lake. The Ambassador House is easily accessible by car and public transport. Underground parking available.

Hotspot for seminars: With various meeting rooms, conference rooms and auditoriums. State-of-the-art technology, first-class facilities, catering of choice and extensive services.

Hospitality at a high level: In the Ambassador House and Spaces, experience the flair of the coworking area and move around in a modern city island!

Adress: Ambassador House, Thurgauerstrasse101, 8152 Opfikon

Route