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.

For corporate groups, we can organize this training as an on-site private group.

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

Leading UK-based global training provider since 1995.

Experience Advanced Microsoft Power BI in Global through Bilginç IT Academy's live and interactive virtual classroom environment. Join a Public course as an individual delegate or arrange a dedicated Private / In-house online training program exclusively for your organization.

Delivery Method: Online Instructor-Led
Participation Model: Public / Private (In-house)
Live and Interactive Training: Connect with your instructor in real time and actively participate through discussions, Q&A sessions, practical exercises, and group activities.
Flexible Participation: Join the training from your home, office, or any location with a suitable internet connection.
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 professional training experience since 1995.
Worldwide Access: Join our live virtual classrooms from Global or anywhere else in the world, or arrange a dedicated online training program for your organization.

Experience Advanced Microsoft Power BI through face-to-face Classroom Based training in Global. Training can be delivered as a Public course open to individual delegates or as a dedicated Private / In-house class for your organization.

Delivery Method: Classroom Based
Participation Model: Public / Private (In-house)
Face-to-Face Learning: Interact directly with your instructor and fellow delegates in an engaging classroom environment.
Experienced Trainers: Learn from specialists with extensive industry experience and practical real-world knowledge.
Professional Training Environment: Attend training in comfortable, well-equipped classrooms designed to support effective learning.
Practical Learning: Depending on the course, reinforce your knowledge through hands-on exercises, scenarios, case studies, and instructor-led activities.

Arrange Advanced Microsoft Power BI in Global as a dedicated Onsite training program for your organization. Bilginç IT Academy trainers can deliver the training at your office or another location of your choice, with the program planned around your team's requirements and business objectives.

Delivery Method: Onsite
Participation Model: Private (In-house)
Training at Your Preferred Location: Organize the training at your company's office or another location selected by your organization.
Tailored Course Content: Adapt the training program to your projects, team structure, existing skill levels, and specific business requirements.
Team-Focused Learning: Develop your team around a shared knowledge base while strengthening internal collaboration and knowledge transfer.
Flexible Scheduling: Plan the training dates, location, and program according to your organization's operational requirements.
Worldwide Onsite Delivery: Arrange the training in Global or at another preferred location worldwide. Bilginç IT Academy trainers can travel to your selected location to deliver the dedicated training program.

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

E. S. A. - IT Bussiness Partner / DHL Supply Chain

The instructor provided a very enjoyable and productive two-day training session. Their teaching style and the equipment they provided were excellent. It could have been even more effective if it had been a bit more advanced.

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.

Advanced Microsoft Power BI Training in Global

Prerequisites

What You Will Learn

Training Outline

Why Choose Us

Advanced Microsoft Power BI Training Course in Global Schedule

Advanced Microsoft Power BI Training in Global

Prerequisites

What You Will Learn

Training Outline

Why Choose Us

Online Instructor-Led Training

Classroom Based Training

Onsite Training

Training Reviews

Advanced Microsoft Power BI Training Course in Global Schedule