Power BI Training in OMR Chennai

Technologies is a leading provider of PowerBI Training in Chennai. India’s Top Rated PowerBI Training Institute offers realtime practical PowerBI Training with realtime project, job orientation and certification guidance. Our trainings are 100% job assured.

Complete Real-time and Practical Power BI Training with Real-time Project. Power BI is a cloud-based, elegant end-to-end business analytics tool that enables anyone to visualize, analyze, forecast any type of data with greater speed and efficiency. Our Power BI course include Basic to Advanced Report Design with DAX and Custom Visualizations with M Language for your day to day corporate business needs!

Microsoft Power BI Training in Chennai with Real-time Project. Power BI is a cloud-based, elegant end-to-end business analytics tool that enables anyone to visualize, analyze, forecast any type of data with greater speed and efficiency. Our Power BI course in Chennai include Basic to Advanced Report Design with DAX and Custom Visualizations with M Language for your day to day corporate business needs!.

All Trainings are completely practical and real-time, paired with 24 X 7 LIVE Server Access and Real-time databases.

Courses Offered:

SQL Server Training
SQL DBA Training
PowerBI Training
SQL BI and DWH [SSIS/SSRS/SSAS] Training
DAX and Power View
DQS and MDS with Powershell

Benefits of Microsoft PowerBI Training:

Completely Practical and Realtime
Theory Material provided in Advance
Highly Interactive and Interesting
Certification Guidance and FAQs
24×7 Server Access with Realtime DBs
Beneficial for Microsoft Exams

After our Microsoft PowerBI Training participants should:

Design End-End Reports & Various Visualizations
Develop Custom Visualizations with Power BI & Filters
Design Reports with Advanced DAX Expressions, Models
Design Reports with MDX Queries and R Language, Insights
Publish Reports, Perform Q & A on Dashboards, Pins
Implement Data Refresh & Data Gateway with Mobile Reports

Pre-requisites for this Power BI Course:

None. This course is for starters as well as for experienced professionals. Course includes Study Material, Interview & Certification guidance along with one Real-time Project.

Power BI Training course syllabus

Every case study gives you a chance to work on large, real-life business data sets in the advanced Power BI lab.

Class 1 : INTRODUCTION TO POWER BI (Free Demo)

Introduction to Power BI – Need, Imprtance
Power BI – Advantages and Scalable Options
History – Power View, Power Query, Power Pivot
Power BI Data Source Library and DW Files
Cloud Colloboration and Usage Scope
Business Analyst Tools, MS Cloud Tools
Power BI Installation and Cloud Account
Power BI Cloud and Power BI Service
Power BI Architecture and Data Access
OnPremise Data Acces and Microsoft On Drive
Power BI Desktop – Instalation, Usage
Sample Reports and Visualization Controls
Power BI Cloud Account Configuration
Understanding Desktop & Mobile Editions
Report Rendering Options and End User Access
Power View and Power Map. Power BI Licenses
Course Plan – Power BI Online Training

Class 2 : CREATING POWER BI REPORTS, AUTO FILTERS

Report Design with Legacy & .DAT Files
Report Design with Databse Tables
Understanding Power BI Report Designer
Report Canvas, Report Pages: Creation, Renames
Report Visuals, Fields and UI Options
Experimenting Visual Interactions, Advantages
Reports with Multiple Pages and Advantages
Pages with Multiple Visualizations. Data Access
PUBLISH Options and Report Verification in Cloud
“GET DATA” Options and Report Fields, Filters
Report View Options: Full, Fit Page, Width Scale
Report Design using Databases & Queries
Query Settings and Data Preloads
Navigation Options and Report Refresh
Stacked bar chart, Stacked column chart
Clustered bar chart, Clustered column chart
Adding Report Titles. Report Format Options
Focus Mode, Explore and Export Settings

Class 3 : REPORT VISUALIZATIONS and PROPERTIES

Power BI Design: Canvas, Visualizations and Fileds
Import Data Options with Power BI Model, Advantages
Direct Query Options and Real-time (LIVE) Data Access
Data Fields and Filters with Visualizations
Visualization Filters, Page Filters, Report Filters
Conditional Filters and Clearing. Testing Sets
Creating Customised Tables with Power BI Editor
General Properties, Sizing, Dimensions, and Positions
Alternate Text and Tiles. Header (Column, Row) Properties
Grid Properties (Vertical, Horizontal) and Styles
Table Styles & Alternate Row Colors – Static, Dynamic
Sparse, Flashy Rows, Condensed Table Reports. Focus Mode
Totals Computations, Background. Boders Properties
Column Headers, Column Formatting, Value Properties
Conditional Formatting Options – Color Scale
Page Level Filters and Report Level Filters
Visual-Level Filters and Format Options
Report Fields, Formats and Analytics
Page-Level Filters and Column Formatting, Filters
Background Properties, Borders and Lock Aspect

Class 4 : CHART AND MAP REPORT PROPERTIES

CHART Report Types and Properties
STACKED BAR CHART, STACKED COLUMN CHART
CLUSTERED BAR CHART, CLUSTERED COLUMN CHART
100% STACKED BAR CHART, 100% STACKED COLUMN CHART
LINE CHARTS, AREA CHARTS, STACKED AREA CHARTS
LINE AND STACKED ROW CHARTS
LINE AND STACKED COLUMN CHARTS
WATERFALL CHART, SCATTER CHART, PIE CHART
Field Properties: Axis, Legend, Value, Tooltip
Field Properties: Color Saturation, Filters Types
Formats: Legend, Axis, Data Labels, Plot Area
Data Labels: Visibility, Color and Display Units
Data Labels: Precision, Position, Text Options
Analytics: Constant Line, Position, Labels
Working with Waterfall Charts and Default Values
Modifying Legends and Visual Filters – Options
Map Reports: Working with Map Reports
Hierarchies: Grouping Multiple Report Fields
Hierarchy Levels and Usages in Visualizations
Preordered Attribute Collection – Advantages
Using Field Hierarchies with Chart Reports
Advanced Query Mode @ Connection Settings – Options
Direct Import and In-memory Loads, Advantages

Class 5 : HIERARCHIES and DRILLDOWN REPORTS

Hierarchies and Drilldown Options
Hierarchy Levels and Drill Modes – Usage
Drill-thru Options with Tree Map and Pie Chart
Higher Levels and Next Level Navigation Options
Aggregates with Bottom/Up Navigations. Rules
Multi Field Aggregations and Hierarchies in Power BI
DRILLDOWN, SHOWNEXTLEVEL, EXPANDTONEXTLEVEL
SEE DATA and SEE RECORDS Options. Differences
Toggle Options with Tabular Data. Filters
Drilldown Buttons and Mouse Hover Options @ Visuals
Dependant Aggregations, Independant Aggregations
Automated Records Selection with Tabular Data
Report Parameters : Creation and Data Type
Available Values and Default values. Member Values
Parameters for Column Data and Table / Query Filters
Parameters Creation – Query Mode, UI Option
Linking Parameters to Query Columns – Options
Edit Query Options and Parameter Manage Entries
Connection Parameters and Dynamic Data Sources
Synonyms – Creation and Usage Options

Class 6 : POWER QUERY & M LANGUAGE – Part 1

Understanding Power Query Editor – Options
Power BI Interface and Query / Dataset Edits
Working with Empty Tables and Load / Edits
Empty Table Names and Header Row Promotions
Undo Headers Options. Blank Columns Detection
Data Imports and Query Marking in Query Editor
JSON Files & Binary Formats with Power Query
JavaScript Object Notation – Usage with M Lang.
Applied Steps and Usage Options. Revert Options
creating Query Groups and Query References. Usage
Query Rename, Load Enable and Data Refresh Options
Combine Queries – Merge Join and Anti-Join Options
Combine Queries – Union and Union All as New Dataset
M Language : NestedJoin and JoinKind Functions
REPLACE, REMOVE ROWS, REMOVE COL, BLANK – M Lang
Column Splits and FilledUp / FilledDown Options
Query Hide and Change Type Options. Code Generation

Class 7 : POWER QUERY & M LANGUAGE – Part 2

Invoke Function and Freezing Columns
Creating Reference Tables and Queries
Detection and Removal of Query Datasets
Custom Columns with Power Query
Power Query Expressions and Usage
Blank Queries and Enumuration Value Generation
M Language Sematics and Syntax. Tranform Types
IF..ELSE Conditions, TransformColumn() Types
RemoveColumns(), SplitColumns(),ReplaceValue()
Table.Distinct Options and GROUP BY Options
Table.Group(), Table.Sort() with Type Conversions
PIVOT Operation and Table.Pivot(). List Functions
Using Parameters with M Language (Power Query Editor)
Advanced Query Editor and Parameter Scripts
List Generation and Table Conversion Options
Aggregations using PowerQuery & Usage in Reports
Report Generation using Web Pages & HTML Tables
Reports from Page collection with Power Query
Aggregate and Evaluate Options with M Language
Creating high-density reports, ArcGIS Maps, ESRI Files
Generating QR Codes for Reports
Table Bars and Drill Thru Filters

Class 8 : DAX EXPRESSIONS – Level 1

Purpose of Data Analysis Expresssions (DAX)
Scope of Usage with DAX. Usabilty Options
DAX Context : Row Context and Filter Context
DAX Entities : Calculated Columns and Measures
DAX Data Types : Numeric, Boolean, Variant, Currency
Datetime Data Tye with DAX. Comparison with Excel
DAX Operators & Symbols. Usage. Operator Priority
Parenthesis, Comparison, Arthmetic, Text, Logic
DAX Functions and Types: Table Valued Functions
Filter, Aggregation and Time Intelligence Functions
Information Functions, Logical, Parent-Child Functions
Statistical and Text Functions. Formulas and Queries
Syntax Requirements with DAX. Differences with Excel
Naming Conventions and DAX Format Representation
Working with Special Characters in Table Names
Attribute / Column Scope with DAX – Examples
Measure / Column Scope with DAX – Examples

Class 9 : DAX EXPRESSIONS – Level 2

YTD, QTD, MTD Calculations with DAX
DAX Calculations and Measures
Using TOPN, RANKX, RANK.EQ
Computations using STDEV & VAR
SAMPLE Function, COUNTALL, ISERROR
ISTEXT, DATEFORMAT, TIMEFORMAT
Time Intelligence Functions with DAX
Data Analysis Expressions and Functions
DATESYTD, DATESQTD, DATESMTD
ENDOFYEAR, ENDOFQUARTER,ENDOFMONTH
FIRSTDATE, LASTDATE, DATESBETWEEN
CLOSINGBALANCEYEAR,CLOSINGBALANCEQTR
SAMEPERIOD and PREVIOUSMONTH,QUARTER
KPIs with DAX. Vertipaq Queries in DAX
IF..ELSEIF.. Conditions with DAX
Slicing and Dicing Options with Columns, Measures
DAX for Query Extraction, Data Mashup Operations
Calcualted COlumns and Calculated Measures with DAX

Class 10 : POWERBI DEPLOYMENT & CLOUD

PowerBI Report Validation and Publish
Understanding PowerBI Cloud Architecture
PowerBI Cloud Account and Workspace
Reports and DataSet Items Validation
Dashboards and Pins – Real-time Usage
Dynamic Data Sources and Encryptions
Personal and Organizational Content Packs
Gateways, Subscriptions, Mobile Reports
Data Refresh with Power BI Architecture
PBIX and PBIT Files with Power BI – Usage
Visual Data Imprts and Visual Schemas
Cloud and On-Premise Data Sources
How PowerBI Supports Data Model?
Relation between Dashbaords to Reports
Relation between Datasets to Reports
Relation between Datasets to Dashbaords
Page to Report – Mapping Options
Publish Options and Data Import Options
Need for PINS @ Visuals and PINS @ Reports
Need for Data Streams and Cloud Intergration

Class 11 : POWER BI CLOUD OPERATIONS

Report Publish Options and Verifications
Working with Power BI Cloud Interface & Options
Navigation Paths with “My Workspace” Screens
FILE, VIEW, EDIT REPORTS, ACCESS, DRILLDOWN
Saving Reports into pdf, pptx, etc. Report Embed
Report Rendering and EDIT, SAVE, Print Options
Report PIN and individual Visual PIN Options
Create and Use Dashboards. Menu Options
Goto Dashboard and Goto LIVE Page Options
Operations on Pinned Reports and Visuals
TITLE, MEDIA, USAGE METRICS & FAVOURITES
SUBSCRIPTION Options and Reports with Mobile View
Options with Report Page : Print and Subscribe
Report Actions: USAGE METRICS, ANALYSE IN EXCEL
Report Actions: RELATED ITEMS, RENAME, DELETE
Dashboard Actions: METRICS, RELATED ITEMS
Dashboard Actions: SETTINGS FOR Q & A, DELETE
PIN Actions: METRICS, SHARE, RELATED ITEMS
PIN Actions: SETTINGS FOR Q & A, DELETE
EDIT DASHBOARD (CLOUD), On-The-Fly Reports
Dataset Actions: CREATE REPORT, REFRESH
SCHEDULED REFRESH & RELATED ITEMS
Dashboard Integration with Apps in Power BI

Class 12 : IMPROVING POWER BI REPORTS

Publish PowerBI Report Templates
Import and Export Options with Power BI
Dataset Navigations and Report Navigations
Quick Navigation Options with “My Workspace”
Dashboards, Workbooks, Reports, Datasets
Working with MY WORK SPACE group
Installing the Power BI Personal Gateway
Automatic Refresh – Possible Issues
Adding images to the dashboards
Reading & Editing Power BI Views
Power BI Templates (pbit)- Creation, Usage
Managing report in Power BI Services
PowerBI Gateway – Download and Installation
Personal and Enterprise Gateway Features
PowerBI Settings : Dataset – Gateway Integration
Configuring Dataset for Manual Refresh of Data
Configuring Automatic Refresh and Schdules
Workbooks and Alerts with Power BI
Dataset Actions and Refresh Settings with Gateway
Using natural Language Q&A to data – Cortana

Class 13 : INSIGHTS AND SUBSCRIPTIONS

Data Navigation Paths and Data Splits
Getting data from existing systems
Data Refresh and LIVE Connections
pbit and pbix : differences. Usage Options
Quick Insights For Power BI Reports
Quick Insights For PowerBI Dashboads
Generating Insights with Cloud Datasets
Generarting Reports with Cloud Datasets
Using relational databases on-premises
Using relational databases in the cloud
Consuming a service content pack
Creating a custom data set from a service
Creating a content pack for your organization
Consuming an organizational content pack
Updating an organizational content pack
Adding Tiles : Images, Videos, DataStreams
Creating New Reports from Cortana, Advantages

Class 14 : POWERBI INTEGRATION ELEMENTS

SSRS Integration with Power BI
SSRS Report Portal URL to Power BI Cloud
Power BI KPI Reports Vs SSRS KPI Reports
Convering and Working with Mobile Reports
Report Buidler Reports to Powert BI
Generating QR Codes and Report Security
Reporting JSON Files, Bulk Data Loads
Creating high-density Reports in Power BI
OLAP DataSources in Power BI
Using MDX Queries with PowerBI Queries
MDX SELECT and Perspective Access
KPIs and MDX Expressions with Power BI
MDX Queries and Filters with Power BI
Linked Servers and T-SQL SPROCs with MDX
YTD, PARALLELPERIOD,SCOPE, ALLMEMBERS
WHERE, EXCEPT, RANGE, NONEMPTY
CURRENT & EMPTY, AND / OR, LEFT / RIGHT
Implementing Row Level Security (RLS)
Security Roles and Role Members. Tests
Using R for Power BI, Streaming DataSets
Azure Connections with PowerBI Desktop
PowerBI Reports using SQL Azure DBs

About this Microsoft Power BI Training course

The main purpose of the power bi course in Greens Technology is to give students a good understanding of data analysis with Power BI. The course includes creating visualizations, the Power BI Service, and the Power BI Mobile App.

After completing this Microsoft Power BI Training course, students will be able to:

Perform Power BI desktop data transformation.
Describe Power BI desktop modelling.
Create a Power BI desktop visualization.
Implement the Power BI service.
Describe how to connect to Excel data.
Describe how to collaborate with Power BI data.
Connect directly to data stores.
Describe the Power BI developer API.
Describe the Power BI mobile app.
Design End-End Reports & Various Visualizations
Develop Custom Visualizations with Power BI & Filters
Design Reports with Advanced DAX Expressions, Models
Design Reports with MDX Queries and R Language, Insights
Publish Reports, Perform Q & A on Dashboards, Pins
Implement Data Refresh & Data Gateway with Mobile Reports

Power BI Training Highlights

M Language, Data Mashups
Basic to Advanced DAX
Custom Power BI Tools
Azure Workspace
Data Gateways & Security
Dynamic RLS & Cloud
MCSA 70-778 Certification
Real-time Project

Power BI Training Benefits

Complete Practical and Real-time Scenarios
Session wise Material and Practice Labs
Session wise Notes & Doubts Clarifications
Certification Material & Resume Preparation
24×7 LIVE Server Access with Real-time Databases
Interview Preparation and Guidance
Technical Support and Placements Assistance
One Real-time Project and FAQs with Answers
Mock Interview and Course Completion Certificate

+91 89399 82288

Free enquiry

Software Training