Analyzing Data with Power BI

Analyzing Data with Power BI course imparts knowledge and skills to analyze, visualize and report data using Power BI.

This Power BI online training covers most recent devices to screen business development and find solutions on any gadget through rich reporting components and dashboards.

In Power BI course, you will learn how to connect and import your data, author reports, publish reports, create dashboards, and share with business users so that they utilize the business intelligence gathered in dashboards through the web as well as mobile devices. This course is mainly for Business Intelligence experts who are required to generate reports and analyze data using Microsoft Power BI.

Power BI is a cloud-based business analytics service from Microsoft that enables anyone to visualize and analyze data, with better speed and efficiency. It is a powerful as well as a flexible tool for connecting with and analyzing a wide variety of data. Many businesses even consider it indispensable for data-science-related work.

What will you learn ?

• Understand essential elements of a self-benefit Power BI arrangement
• Describe Power BI desktop modeling
• Create a Power BI desktop visualization
• Consolidate, examine, model, shape, and envision information
• Report information utilizing rich dashboards

1. Power BI Desktop and Power Query

Getting Started

• • Class Introduction (BI Basics)
• • Class Introduction (Power Platform & Power BI Desktop Overview)
• • Data Discovery with Power BI Desktop

Transforming Data

• • Basic Transforms
• • Add Column From Example
• • Appending Queries
• • Merging Queries
• • Combine Files
• • M Query Basics
• • Parameters and Templates
• • Other Query Features

Creating the Data Model

• • Introduction to Modeling Data
• • Modeling Basics
• • Model Enhancements
• • What If Parameters
• • DAX Basics
• • Navigation Function
• • Calculated Tables
• • Measure Basics
• • Time Intelligence Functions

2. Power BI Service - Visualizations - Power BI Mobile

Visualizing Data - Creating Interactive Reports

• • Introduction to Visualizing Data
• • Creating Basic Reports with the Power BI Desktop
• • Creating Interactive Reports (Adding Slicers for Filters)
• • Visualizing Tabular Data
• • Visualizing Categorical Data
• • Visualizing Data Trends
• • Visualizing Categorical and Trend Data Together
• • Visualizing Geographical Data with Maps
• • Visualizing Goal Tracking
• • Using Custom Visuals
• • Digital Storytelling
• • Other Features

Usage of Power BI Service

• • Deploying to the Power BI Service
• • Creating and Sharing Dashboards
• • Using Power BI Q&A
• • Setting up App Workspaces
• • Subscriptions and Alerts
• • Excel Integration
• • Export and Embed Options

Data Refreshing

• • Overview
• • Installing the Data Gateway
• • Scheduling a Data Refresh

Power Mobile Version

• • Power BI Mobile Overview
• • Designing Reports and Dashboards for Mobile
• • Interacting with the Power BI Mobile App

3. Get Data Module

• • Excel
• • CSV
• • Flat File
• • Facebook
• • SQL Server
• • SSAS Multidimensional
• • SSAS Tabular

4. Data Analysis Expressions (DAX) - Basics

• • Getting Started
• • Data Modeling Basics (Overview & Tabular)
• • What is DAX (Overview & Tabular)
• • Creating Calculated Columns
• • Navigation Functions
• • Conditional and Logical Functions
• • Creating Calculated Measures
• • Time Intelligence Overview & Functions
• • Using X-Functions and A-Functions
• • Table Functions
• • DAX as a Query Language

5. Data Analysis Expressions (DAX) - Advanced

• • Class Introduction (Class Files)
• • Class Introduction (Why Advanced DAX)
• • Working with Variables
• • Working with Filter Context - Basics
• • CALCULATE
• • Overriding Filter Context
• • FILTER & ALL
• • Working with Filter Context (ALL EXCEPT)
• • Totals
• • CALCULATE and Time Intelligence (YTD and MTD)
• • Rolling 12 Months Total
• • Rolling 3 Month Average Total
• • Semi-Additive Measures (Overview)
• • Opening and Closing Balance
• • Understanding Row Context and Context Transition
• • Working with Iterator Functions
• • Nested Row Context
• • Error Handling
• • Implementing Basic Security
• • Dynamic Security
• • Implementing Basic Security – Tabular
• • Dynamic Security – Tabular
• • Role Playing Dimensions (Multiple Table Import)
• • USERELATIONSHIP

Advanced DAX Functions

• • CONTAINS
• • FIND
• • SEARCH and SUBSTITUTE
• • ALLSELECTED
• • RANKX

• • Data Analysts
• • Business Analysts
• • SQL professionals
• • Business intelligence developers
• • BI and reporting professionals
• • BI Professionals
• • Anyone with a genuine interest in Data & Analytics

• • Knowledge of relational databases and reporting.
• • Basic knowledge of data warehouse schema topology (including star and snowflake schemas)
• • Knowledge about programming concepts (such as looping and branching)
• • Familiar with key business priorities such as revenue, profitability, and financial accounting is desirable
• • Familiarity with Microsoft Office applications (particularly Excel)