Power BI Training

info@identityskills.com +91 96308 72061 +91-9630872061

You are here:
Home
Power BI Training

What is Power BI?

Power BI is a business intelligence (BI) service that gives you fast, simple, and affordable ways to collect and present insights from your data. With Power BI Desktop or Online editions, you can analyze your data with live dashboards and reports.

You can even create ad hoc reports with just a few clicks. The latest Power BI service enables you to get the most out of your data by integrating with other applications and services like Salesforce, QuickBooks Online, SAP HANA, Office 365, Google Sheets, and more. When you use Power BI, you can quickly create visualizations, dashboards, and reports that bring data together into one intuitive interface.

What Identity Skills offers?

Our training program is designed for users at all levels of experience with Power BI, from those who have just learned about it to those who have been using it for years.

The goal is to make sure you understand how to navigate through the tool effectively and use its advanced features correctly so that you can get the most out of your data.

Our curriculum is focused on helping you build a personalised experience that helps you navigate the world of data visualization and reporting.

We will teach you how to use Power BI for your own business, and then show you how to apply those skills in the real world.

You will learn how to create dashboards from scratch and customize them to meet specific business needs.
You will learn how to use Microsoft Power BI for managing data and reporting.
The Power BI training program is a perfect choice for those who are looking to upgrade their skills and get themselves on the right track.
You’ll learn from real-world examples.
Our instructors are active users of Power BI, and they’re constantly looking for ways to improve the training program.

Stock Market Prediction
US-based retail industry data analysis
Report on Student Survey
Power BI Desktop, Cloud Service, and End to End Workflow

Frequently Asked Questions

HOW DO I ENROLL?

Please get in touch with us or call us at 9931297975

I’M A BEGINNER IN THE IT FIELD, WHAT DO I NEED TO KNOW BEFORE I CAN START LEARNING THIS COURSE?

There are no Pre-requisites to start learning CyberArk. Our trainers will start explaining from very basics and make things simpler for you to understand

DO I HAVE A FLEXIBILITY ON TIMING?

Yes, you tell us the timings you are most comfortable at and we’ll schedule the sessions based on that.

DO I GET A PRACTICAL HANDS-ON?

Yes, you get 5 Virtual machines hosted on cloud with required software copied along with detailed lab user guides.

WHAT IF I HAVE ANY QUERIES OR IF I’M STUCK WITH THE LABS.

Our trainers and support are available 24/7 for you. You can reach out to us anytime and we’ll help you with your issues.

DO I GET CERTIFICATION ASSISTANCE?

Yes, Certification Assistance is a part of this course. Our trainers will guide you with the requirements and preparations for certification exams.

CAN TRAINERS HELP ME WITH INTERVIEW PREPARATION?

Yes, We conduct a few mock sessions and provide feedback that can help you understand the interview process.

Support After Course Completion

RESUME BUILDING

MOCK INTERVIEWS

CAREER GUIDANCE

COMMUNITY SUPPORT

LIFETIME ACCESS TO STUDY MATERIALS

Course Curriculam

Module-1 Lesson 1 - Power BI Advanced Features Preview

1.1 Working with Data Hierarchies
1.2 In-built slicers and custom slicers • Date slicer
1.3 Working with reference lines
1.4 Dynamic Texts in Power BI • Measures for Dynamic Texts
1.5 Dynamic tooltips
1.6 Filters • Types of Filters • Visualization filters • Page Filters • Report Filters
1.7 Drill Through in Power BI • Creating Drill Through Reports in Power BI
1.8 Developing KPIs
1.9 Parameters • Types of Parameters • Linking Parameters with Datasets • Creating Parameters for Data Sources • Creating Parameters for File Paths
1.10 Power BI Templates • Difference between Reports & Templates
1.11 Key Influencers in Power BI
1.12 What-If Parameters in Power BI • Creating What-If Parameters • Case Study on What-If Parameters
1.13 Power BI Question & Answers
1.14 Interactions in Power BI • Edition Interactions in Power BI
1.15 Selection Pane in Power BI • Hiding / UnHiding Using Selection Pane

Module-2 Lesson 2 - OLAP & Power BI Preview

2.1 OLAP Data Sources in Power BI
2.2 Using Analysis service
2.3 Using MDX Queries with PowerBI
2.4 Connecting Power BI with OLAP
2.5 Understanding Import & DirectQuery
2.6 MDX SELECT and Perspective Access
2.7 MDX Expressions with Power BI
2.8 MDX Queries with Power BI
2.9 Applying Vertipaq Analyzer to analyze the structure of a data model

Module-3 Lesson 3 - DAX functions with Power BI Preview

3.1 Working with DAX Functions
3.2 Calculated Measures by using DAX
3.3 Parameters with DAX
3.4 Dynamic Report Filters, Expressions • Variables
3.5 Date functions • String functions • Arithmetic Functions
3.6 Understanding Calculated Column • Creating Calculated Columns
3.7 Understanding Measures • Creating Measures • Difference between Columns & Measures
3.8 Logical Functions • Relationship functions • Math/Statistics function • Information functions

Module-4 Lesson 4 - DAX Expressions & DAX Functions Preview

4.1 Scope Altering Functions (ALL, ALLEXCEPT, ALLSELECTED, KEEP FITLERS etc.)
4.2 Table Functions in DAX – CALCULATETABLE etc.
4.3 Time Intelligence (YTD, MoM, Rolling Window i.e. Moving Average calculations etc.)
4.4 Iterator Functions like SUMX, COUNTX, AVERAGEX ..
4.5 Many to Many Relationships and Bi directionality i.e. non Star Schema
4.6 Composite Models • Calculation Groups
4.7 DAX Patterns – Top N Pattern, ABC Pattern etc.
4.8 Using Path Function for Hierarchal Role based Access
4.9 Using DAX for SVG Animations
4.10 Time intelligence function
4.11 YTD, QTD, MTD Calculations with DAX
4.12 DAX Calculations and Measures
4.13 Using TOPN, RANKX, RANK.EQ • SAMPLE Function, COUNTALL, ISERROR • ISTEXT, DATEFORMAT, TIMEFORMAT
4.14 Time Intelligence Functions with DAX
4.15 Data Analysis Expressions and Functions
4.16 DATESYTD, DATESQTD, DATESMTD • ENDOFYEAR, ENDOFQUARTER,ENDOFMONTH • FIRSTDATE, LASTDATE, DATESBETWEEN
4.17 CLOSINGBALANCEYEAR,CLOSINGBALANCEQTR • SAMEPERIOD and PREVIOUSMONTH,QUARTER
4.18 PARALLEL PERIOD • FILTER FUNCTIONS
4.19 How to use DAX Studio • Creating and Utilizing Variables
4.20 Understanding Nested Evaluation Context • Dynamic Bucketing/Binning using Lookup Functions

Module-5 Lesson 5 - Power BI Custom Visuals& Advanced Forecasting Analysis Preview

5.1 Adding Custom Visuals in Power BI
5.2 Word Cloud • Text Filters • Tornado • Zebra BI Tables • Hierarchy Charts
5.3 Creating Automatic Forecasts • Time Series Forecasting • ARIMA Forecasting
5.4 Interactive Pareto Charts
5.5 Regression – Linear,Multiple Logistic • Correlation • Clustering Analysis

Module-6 Lesson 6 - Power Query / MQuery Preview

6.1 What is Power Query • When to Use Power Query
6.2 Connecting Data Sources using Power Query • Manipulating Data using Power Query
6.3 Power Query Functions • Applying Power Query Functions
6.4 Connecting to data sources using Power Query • Functions in Power Query
6.5 Importing and parsing JSON, XML Data, Web and API Data
6.6 Using Advanced Editor for the M Query Language
6.7 Difference in List, Record and Tables and their respective functions
6.8 M Language Basics (Text, Number, Date, Time, Duration Functions) , Conditional Functions IF then, Each Function
6.9 Creating and Using Lists and Records • Converting Lists to Tables and Using Tables
6.10 Different Join Types especially Self Joins
6.11 Creating Custom FUNCTIONS and using them in the CUSTOM COLUMN
6.12 Using Parameters and Parameter Tables in Power Query • Creating and Using Date Tables for Time Intelligence

Module-7 Lesson 7 - Power BI Deployment & User Management Preview

7.1 Understanding PowerBI Cloud Architecture • Power BI Server Configuration
7.2 PowerBI Cloud Account and Workspace • Creating Account in Power BI Services
7.3 Power BI Users • Types of Users -> Free, Pro, Premium
7.4 Creating Workspaces
7.5 User Management • Workspaces Management
7.6 Deployment Power BI Desktop Reports • Managing report in Power BI Services
7.7 Editing Reports in Power BI Servers • Downloading PBIX files from Server
7.8 Share dashboards to Client /Users
7.9 Gateways • PowerBI Gateway -Download and Installation
7.10 Data Refresh with Power BI Architecture
7.11 PowerBI Settings : Dataset -Gateway Integration
7.12 Configuring Dataset for Manual Refresh of Data • Configuring Automatic Refresh and Schedules
7.13 Subscriptions in Power BI • Power BI Alerts
7.14 Dataset Actions and Refresh Settings with Gateway
7.15 Security Features in Power BI • Implementing Row Level Security (RLS) • Security Roles and Role Members.
7.16 Power BI Mobile Apps • Viewing Reports in Power BI Mobile Apps • Testing Power BI Reports for Mobile Views
7.17 Deployment Pipeline • Power BI WorkFlows