Power BI Desktop is part of the suite of tools from Microsoft which enable data to be analysed and published from a variety of sources.This course covers the use of Power BI Desktop to connect to data, create Visualizations, query the data and publish reports. You are already using Microsoft’s cloud reporting and business analytics suite, Power BI, to analyze your organizations data and share insights and are now ready to learn the advanced techniques that you, your business analysts, and your stakeholders need to create complex information from projects, program, and portfolio reporting to utilizing time-phased data and, potentially, data from your enterprise’s other line-of-business tools. Attendees of this course will gain practical examples from the experienced instructor who has deployed and configured Power BI reporting in a wide variety of businesses.

We can organize this training at your preferred date and location. Contact Us!

Prerequisites

The Power BI boot camp course is a pre-requisite for the course. Alternatively, delegates should have at least 3 months experience in using Power BI Desktop for creating reports and dashboards.

What You Will Learn

Create Advanced Power BI Reports
Advanced understanding of the data schemas and extracting data
Perform advanced transformations of data or any data schema
Utilize time-phased data in the creation of complex analyses
Create new measures using DAX
Filter data using row-level security
Create and deploy content packs
Explore Data Visualizations
Create and publish Reports

Training Outline

1. Introduction

What you should know
Our project: Creating an advanced Power BI dashboard

2. Working with Data

Importing online data sources
Uploading from a folder of data
Querying a database
Importing and transferring data imported from an Excel, CSV, or TXT file

3. Query Editor

Introducing Query Editor steps
Transposing data tables
Splitting fields and columns
Formatting data with text formulas
Creating conditional formulas
Creating calculated formulas

4. DAX Language

Introducing DAX
Introducing DAX measures
Understanding DAX measure logic
Evaluating DAX measures
Leveraging the CALCULATE functionality
Understand how filters work in CALCULATE function
Leveraging the ALL function
Understanding the FILTER functionality

5. Introduction to DAX Formulas

Creating a separate table for measures
Creating a table using GENERATESERIES formula
Leveraging the POWER function
Leveraging the DIVIDE function
Utilizing the X factor (SUMX, COUNTX, etc.) for ranges
Utilizing quick measures

6. Advanced DAX Calculations

Creating a date table using a formula
Filtering between tables
Utilizing IF statements with conditional functions
Introducing the DATEDIFF measure
Working with disconnected tables
Leveraging the BLANK function
Using variables in formulas
DATESBETWEEN and the X functions
Introducing the DATEADD date calculations
Introducing the MTD, QTD, and YTD date calculations

Why Choose Us

Experience Advanced Microsoft Power BI in Switzerland through Bilginç IT Academy's live and interactive virtual classroom environment, accessible from your home, office, or any location. Connect with expert trainers in real time and bring the energy of classroom learning into the digital experience.

Live Instructor-Led Sessions: Join scheduled training sessions with your instructor and fellow delegates in real time.
Interactive Learning Experience: Take part in discussions, practical exercises, group activities, and Q&A sessions throughout the course.
Expert Trainer Network: Learn from experienced trainers with strong industry backgrounds and practical field expertise.
Over 30 Years of Training Expertise: Benefit from Bilginç IT Academy's long-standing experience in delivering professional training since 1995.
Flexible and Scalable Delivery: Access live virtual classrooms from Switzerland and worldwide, with flexible planning options for individual and corporate training needs.

Experience Advanced Microsoft Power BI in a focused classroom environment in Switzerland. Bilginç IT Academy's carefully selected training venues provide a professional setting where delegates can interact directly with expert trainers and peers.

Experienced Trainers: Learn from specialists with extensive field experience and real-world knowledge.
Professional Training Venues: Attend courses in comfortable, well-equipped classrooms designed to support effective learning.
Focused Classroom Experience: Benefit from limited class sizes that encourage discussion, interaction, and personalized support.
Quality-Driven Learning: Develop practical skills through structured, up-to-date, and professionally designed training content.

Meet your team's training needs with Bilginç IT Academy's onsite Advanced Microsoft Power BI in Switzerland solution, delivered at your office or preferred location. Align your team's development with your business goals through a training experience tailored to your organization.

Tailored Course Content: Adapt the training program to your organization's projects, team structure, and specific business requirements.
Time and Cost Efficiency: Reduce travel, accommodation, and operational costs while maximizing the value of your training investment.
Team-Focused Learning: Help your employees develop around the same knowledge base and strengthen collaboration across your organization.
Simplified Planning and Tracking: Manage the training process, participant development, and organizational requirements with greater control.

A. K. - Yedek Parça Müdürü / VOLVO GROUP OTOMOTIV

The instructor was knowledgeable and expert on the subject. The explanations and examples were clear. Thank you.

H. K. - Monitoring and Service Management Team Leader / Bimsa Uluslararası İş, Bilgi ve Yönetim Sistemleri (SabancıDx)

Thanks

M. D. - Girdi Kalite Kontrol Yöneticisi / MENDERES TEKSTİL SAN. ve TİC. A.Ş.

In my opinion, it was a useful training. The practical application of this training is very high in our field. However, extending the training period and delving deeper into the topics would be more beneficial for those who received it. Thank you.

H. Y. - Bilgi Teknolojileri ve Yazılım Yöneticisi / Menderes Tekstil San. ve Tic. A.Ş.

Throughout the training, we learned many useful and real-world applications of Power BI; it was a very helpful training. Thank you. We are eagerly awaiting the next training.

M. M. - Süreç Yönetimi Uzman Yrd. / MENDERES TEKSTİL SAN. ve TİC. A.Ş.

We learned many great things. We learned about an app that can provide most of what we want. The instructor's communication was excellent, their answers to questions were very good, and their explanations were excellent. Thank you.

R. G. - İşletme şefi / MENDERES TEKSTİL SAN. ve TİC. A.Ş.

Thank you

S. P. - FBA Specialist / DHL

Our professor's knowledge of the subject and his way of conveying it to us were excellent. He managed to keep our attention throughout the lesson, and his teaching style clearly showed his mastery of the subject and his passion for it.

E. A. - Finansal Raporlama / DHL

Thank you so much, it was a very productive training. We look forward to more.

A. Ş. - FBA Uzmanı / DHL

It was great, we were able to start using it actively.

B. C. - IT Application Specialist / DHL

I would like to thank our instructor. I learned about a tool I hadn't used before and was able to complete the examples provided during the training.

Y. K. - OMS Champion / DHL

The instructor was very polite and explained all the questions in detail.

S. Ö. - Operasyon Müdürü / DHL

Thank you

S. A. - Metot Mühendisi - Magna Otomotiv

Rated the training 5 stars.

M. Ö. - Satınalma - MAGNA OTOMOTİV SAN TİC A.Ş.

Rated the training 5 stars.

T. S. - Malzeme Planlama Uzmanı - MAGNA OTOMOTİV SAN TİC A.Ş.

Rated the training 5 stars.

E. S. - Business Systems Manager - MAGNA OTOMOTİV SAN TİC A.Ş.

Rated the training 5 stars.

G. G. - Raporlama Uzmanı - DMY ELEKTRONİK YATIRIMLAR

Rated the training 5 stars.

H. K. - BT IS ZEKASI VE VERI ANALIZI UZMANI - Şişecam

Rated the training 5 stars.

M. D. - IT Business Intelligence & Data Analysis Asisst.Specialist - Şişecam

Rated the training 5 stars.

M. H. - BT İş Zekası Uzmanı - Şişecam

Rated the training 5 stars.

B. K. - MECA Bölge İnsan Kaynakları Yöneticisi - Lesaffre Turquie

Rated the training 5 stars.

G. Y. - S&OP - Lesaffre Turquie

Rated the training 5 stars.

L. K. - Export Sales Manager - Lesaffre Turquie

Rated the training 5 stars.

A. Y. - Yeni Ürün Geliştirme ve İhracat Satış Analiz Yöneticisi Lesaffre MECA - Lesaffre Turquie

Rated the training 5 stars.

A. T. - S&OP Executive - Lesaffre Turquie

Rated the training 5 stars.

Why have you chosen us?

I have attended a training from Bilginc IT Academy before and I was satisfied.

I have attended a training from a different provider and it was not helpful.

Other

How many employees do you have in your IT department?

0 – 50

50 – 250

250 – 1000

1000+

Advanced Microsoft Power BI Training in Switzerland

Prerequisites

What You Will Learn

Training Outline

Why Choose Us

Advanced Microsoft Power BI Training Course in Switzerland Schedule

Advanced Microsoft Power BI Training in Switzerland

Prerequisites

What You Will Learn

Training Outline

Why Choose Us

Online Instructor-Led Training (VILT)

Classroom-Based Training

Onsite / In-House Training

Training Reviews

Advanced Microsoft Power BI Training Course in Switzerland Schedule