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 Sweden. 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 Sweden, with flexible scheduling to meet your professional needs.

Immerse yourself in our most sought-after learning style for Advanced Microsoft Power BI Training in Sweden. Our hand-picked classroom venues in Sweden 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 Sweden. 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.

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 Sweden

Prerequisites

What You Will Learn

Training Outline

Why Choose Us

Online Instructor-Led Training (VILT)

Classroom Based Learning

Onsite / In-House Learning

Advanced Microsoft Power BI Training Course in Sweden Schedule