Course Outline

Introduction

  • Overview of Power BI features and architecture
  • Advanced tools and data analysis in Power BI

Getting Started

  • Installing Power BI and other components
  • Data strategies for efficiency
  • DAX language fundamentals

Managing Data

  • Querying and aggregating data
  • R integration and M query
  • Importing and transferring data
  • Pivoting and unpivoting data
  • Transposing and joining data tables
  • Tips and tricks on advanced functionalities

Advanced Data Modeling

  • Working with tables and dimensions
  • Defining data granularity
  • Working with relationships and cardinality
  • Creating measures using DAX
  • Optimizing models for performance
  • Fixing common issues in modeling

Advanced Rules and Calculations using DAX

  • Creating tables using a formula
  • Applying conditional functions
  • Filtering multiple tables
  • Working with disconnected tables
  • Working with variables in DAX
  • Calculating and filtering context
  • Working with dynamic measures

Advanced Visualizations, Reports, and Dashboards

  • Visualization types in Power BI
  • Customizing visual elements
  • Creating Power BI maps visualization
  • Creating Power BI visuals with R
  • Using filters and slicers in reports
  • Enhancing visual elements for reports
  • Creating an automated flow with Power Automate
  • Creating Q&A visual in reports
  • Optimizing dashboards for mobile devices
  • Tips for designing effective dashboards

Working with Embedded Analytics in Power BI

  • Setting up the analytics environment
  • Exploring Power BI REST APIs and client APIs
  • Practical examples and use cases

Troubleshooting

Summary and Next Steps

Requirements

  • Experience with Power BI
  • Familiarity with DAX language

Audience

  • Business analysts
  • Data analysts
  • Developers
  21 Hours
 

Need help picking the right course?
Call us +971 4369 2815

Testimonials

Offering a more in-depth scope about Power BI more than any training institute that I came across to.

Mohammed Al Ameer

Exercises, additional tips from the trainer, flexibility to add more insights when requested.

Anna Alechno

I mostly enjoyed the power BI possibility.

British American Shared Services Europe

I generally was benefit from the power bi web- Q.

Cristina Palii

I genuinely enjoyed the visualization part.

Alexandra Grigoriu

Good coverage of all Power BI themes relevant and useful for creating reliable dashboards and reports as a beginner.

Gabriel Purghel

I liked the focus and the emphasis on self-learning, playing and reading on external resources. No Application can be taught in 2 days and self-study is very important.

Vlad Andrei Bucur

The trainer was open to answer questions and provide solutions to our real examples.

British American Shared Services Europe

I genuinely was benefit from working with DAX and reporting.

Marine Benefits, Inc.

The last part which is security.

Marine Benefits, Inc.

I really liked the dax.

Chris Amaza - Marine Benefits, Inc.

I really enjoyed the training exercise.

Edward Dan Dree Manalad - Marine Benefits, Inc.

I genuinely was benefit from the subject matter.

- Bristol City Council

The knowledge of the trainer was really good, and they were able to answer any questions asked about the product.

- Bristol City Council

Trainer is refined, he was able to play around with our data using his vast knowledge of the course, despite the 0 background with our work.

Mc Gyver Pascua - Sykes Asia, Inc.

I enjoyed the experience in learning Power BI.

- Sykes Asia, Inc.

I liked the preparation of the raw data before layout.

Ayie Delos Santos - Sykes Asia, Inc.

I like most the DAX function topic as well as the Trainer's eagerness to resolved inappropriate output, he speak based on his audience level of understanding.

Anabelle Anore - Sykes Asia, Inc.

I enjoyed the about the actual application of the lectures provided by the Jonathan.

- Sykes Asia, Inc.

The tool is very interesting.

- Pernod Ricard Hong Kong Limited

Very practical, using our internal data to practice.

- Pernod Ricard Hong Kong Limited

Clear and organized on the training topics. Good for people with who have never used PowerBI to be able create sensible dashboards and reports.

- Pernod Ricard Hong Kong Limited

I was benefit from the good Explanation and ability to Switch Topics when requested by the trainee.

- McArthurGlen

I mostly enjoyed the very lively and ease.

Rey Jasper Matias - Sykes Asia, Inc.

Training adjust the training according to our needs and knowledge. He understood participants experience with Power BI.

Cristian Tudor - Gilbarco ACIS SRL

Dax

Kristian Paul Lugtu - SYKES ASIA INC

NA

- SYKES ASIA INC

Good pace and knowledge demostrated by trainer. Exercises and examples were relevant for our line of work.

Tania Crespo - Grafton Merchanting GB

The DAX logic, very useful to know more about it

Illya Teideman - Grafton Merchanting GB

The exercises were great, really engaging and very hands on which allowed more of the information to be absorbed

Rajiv Pattar - Grafton Merchanting GB

Everything

- Sykes Asia Inc.

training itself

John Denver Virtucio - Sykes Asia Inc.

was really helpful and was willing to listen and provide what was needed. Provided card for questions to help once we use with our own data

shazad Yasin - Grafton Merchanting GB Ltd

Costas covered all of the key areas of Power BI. He was very willing to spend additional time focusing on areas that were key to our business.

Dominic Harte - Grafton Merchanting GB Ltd

As I was the only delegate on my course, the trainer was able to pace accordingly which meant we could cover more ground on each day.

- KNOWLEDGEPOOL GROUP LIMITED

The visualisation power BI is able to create with such ease!

Tom Darley - Grafton Merchanting GB Ltd

covered basics as well as more advanced features. Finished a bit ahead of scheduled which allowed some time for real world questions from participants

Philip Morris Products SA OC Division

Relevant info and tips

Bandeira Adrien - Philip Morris Products SA OC Division

The exercises made sense and they were well prepared

Philip Morris Products SA OC Division

Learning basic DAX and dash boarding.

Rhodes Food Group Pty Ltd

The second day was very interesting. It was a good training to see some possibilities within Power BI; but mostly you learn then while you work with Power BI. Fact is also that the training base has all access rights and everything works, but as soon as you try to connect to the live system, it does not work and this makes the knowledge transfer a bit difficult.

Marco Iuliano

some of the best practices on charts

AIG SHARED SERVICES-BUSINESS PROCESSING, INC.

What I enjoyed most in this training was the number of exercises that helped us a lot to understand the topic. Also, Karthik is very helpful and approachable. He answered all of our questions without any doubts.

Mary Louise Lizano - DHL Summit Solutions Inc.

exploring the different charts in the visualizations

Luvilyn Panol - DHL Summit Solutions Inc.

His patience in teaching us one by one fast but understandable. His patience in teaching again the topics that we did not understand.

DHL Summit Solutions Inc.

Being able to follow the trainer and replicate the steps his was performing in the virtual desktop tool Trainer was very friendly and took the time to answer our specific questions over the 3 days

sean reyford - PepsiCo International

Instructors were very friendly and helpful. They made personal connections which made them more engaging.

Bryn Parsons - Environment and Climate Change Canada

I liked the mix between theory and hands-on work, the small class size, and how knowledgeable and fun the instructors were. Both instructors were always smiling and very personable. Even though each training session was long, the time (for me at least) often passed quickly because I found the material quite engaging.

Environment and Climate Change Canada

practicing

Thomas Dandres - Environment and Climate Change Canada

Being able to follow along with hands-on examples

Robin White - Environment and Climate Change Canada

Related Courses

Big Data Business Intelligence for Govt. Agencies

 35 hours

Advances in technologies and the increasing amount of information are transforming how business is conducted in many industries, including government. Government data generation and digital archiving rates are on the rise due to the rapid growth of

Big Data Business Intelligence for Criminal Intelligence Analysis

 35 hours

Advances in technologies and the increasing amount of information are transforming how law enforcement is conducted. The challenges that Big Data pose are nearly as daunting as Big Data's promise. Storing data efficiently is one of these

Business Intelligence in MS SQL Server 2008

 14 hours

Training is dedicated to the basics of create a data warehouse environment based on MS SQL Server 2008. Course participant gain the basis for the design and construction of a data warehouse that runs on MS SQL Server 2008. Gain knowledge of

Big Data Business Intelligence for Telecom and Communication Service Providers

 35 hours

Overview Communications service providers (CSP) are facing pressure to reduce costs and maximize average revenue per user (ARPU), while ensuring an excellent customer experience, but data volumes keep growing. Global mobile data traffic will grow

Datameer for Data Analysts

 14 hours

Datameer is a business intelligence and analytics platform built on Hadoop. It allows end-users to access, explore and correlate large-scale, structured, semi-structured and unstructured data in an easy-to-use fashion. In this instructor-led,

Power BI Dashboards

 14 hours

Learn how to Get & Transform Data to Prepare Interactive Dashboards Power BI is one of the most popular Data Visualization tool, and a Business Intelligence Tool. Power BI is a collection of data connectors, apps, and software services, which

Data Analytics Process, Cloud Solutions, and Power BI Solutions

 35 hours

Data analysis refers to the process of obtaining, cleaning, and analyzing data, often times in a visual manner, to derive insights for better decision making. More and more data is being stored in databases in the cloud so it is important to have a

Excel to Power BI

 7 hours

Microsoft Excel is the world's most popular business analysis, reporting, and strategy software. Power BI is a business intelligence tool for visualizing data at the operating level of business. This instructor-led, live training (online

Power BI for Business Analysts

 21 hours

Microsoft Power BI is a free Software as a Service (SaaS) suite for analyzing data and sharing insights. Power BI dashboards provide a 360-degree view of the most important metrics in one place, updated in real time, and available on all of their

Creating Dashboards Using Microsoft Power BI

 14 hours

About the Course: Microsoft Power BI transforms your company data into rich visuals that facilitate new ways of thinking about and organizing your data, so that you can focus on what is important to achieving your goals. This course covers both

Power BI Dashboard Design

 7 hours

Microsoft Power BI is a free Software as a Service (SaaS) suite for analyzing data and sharing insights. Power BI dashboards provide a 360-degree view of the most important metrics in one place, updated in real time, and available on all of their

Analyzing Data with Power BI

 28 hours

This course will discuss the various methods and best practices that are in line with business and technical requirements for modeling, visualizing, and analyzing data with Power BI. The course will also show how to access and process data from a

Power BI

 14 hours

Power BI is a business analytics service created by Microsoft.

Power BI for Developers

 28 hours

Microsoft Power BI is a free Software as a Service (SaaS) suite for analyzing data and sharing insights. Power BI dashboards provide a 360-degree view of the most important metrics in one place, updated in real time, and available on all of their

SHOW MORE

PL-300T00: Microsoft Power BI Data Analyst

 21 hours

This course will discuss the various methods and best practices that are in line with business and technical requirements for modeling, visualizing, and analyzing data with Power BI. The course will also show how to access and process data from a