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 live, interactive learning from the comfort of your home or office with Bilginç IT Academy's Online Instructor-Led Advanced Microsoft Power BI Training in Vancouver. Engage directly with expert trainers in a virtual environment that mirrors the energy and schedule of a physical classroom.

Live Sessions: Join scheduled classes with a live instructor and other delegates in real-time.
Interactive Experience: Engage in group activities, hands-on labs, and direct Q&A sessions with your trainer and peers.
Global Expert Trainers: Learn from a handpicked global pool of expert trainers with deep industry experience.
Proven Expertise: Benefit from over 30 years of quality training experience, equipping you with lasting skills for success.
Scalable Delivery: Accessible worldwide, including Vancouver, with flexible scheduling to meet your professional needs.

Immerse yourself in our most sought-after learning style for Advanced Microsoft Power BI Training in Vancouver. Our hand-picked classroom venues in Vancouver offer an invaluable human touch, providing a focused and interactive environment for professional growth.

Highly Experienced Trainers: Boost your skills with trainers boasting 10-20+ years of real-world experience.
State-of-the-Art Venues: Learn in high-standard facilities designed to ensure a comfortable and distraction-free experience.
Small Class Sizes: Our limited class sizes foster meaningful discussions and a personalized learning journey.
Best Value: Achieve your certification with high-quality training and competitive pricing.

Streamline your organization's training requirements with Bilginç IT Academy’s Onsite Advanced Microsoft Power BI Training in Vancouver. Experience expert-led learning at your own business premises, tailored to your corporate goals.

Tailored Learning Experience: Customize the training content to fit your unique business projects or specific technical needs.
Maximize Training Budget: Eliminate travel and accommodation costs, focusing your entire budget on the training itself.
Team Building Opportunity: Enhance team bonding and collaboration through shared learning experiences in your workspace.
Progress Monitoring: Track and evaluate your employees' progression and performance with relative ease and direct oversight.

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 Vancouver

Prerequisites

What You Will Learn

Training Outline

Why Choose Us

Online Instructor-Led Training (VILT)

Classroom Based Learning

Onsite / In-House Learning

Training Reviews

Advanced Microsoft Power BI Training Course in Vancouver Schedule