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
 

Testimonials

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

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