Course Highlights
🧠 In-Depth Curriculum
💻 100% Practical Training
📊 Weekly Learning Plan
🧩 Capstone Project
👨🏫 Mentor Support
🎓 Career Assistance
Power BI
Duration 3 Months
WEEK 1
PBI Introduction
- Power BI Introduction
- Data Visualization, Reporting
- Business Intelligence (BI), Traditional BI, Self-Serviced BI
- Cloud Based BI Cloud Service vs On-Premise BI
- Power BI Products
- Power BI Desktop
- (Power Query - Transformation, Power Pivot - Modeling, Power View - Reports)
- Flow of Work in Power BI Desktop
- Server, Power BI Service, Power BI Mobile
- Flow of Work in Power BI / Power BI Architecture
- A Brief History of Power BI
WEEK 2
PBI Desktop Installation, PBI Desktop & Service Overview
- Power BI Desktop Installation
- Building Blocks of Power BI
- Datasets, Visualizations, Reports, Dashboards, Tiles
- Power BI Desktop User Interface
- Fields Pane, Visualizations Pane, Ribbon, Views, Pages Tab, Canvas
- Overview of Power Query / Query Editor - Extract, Transform & Load Data
- Connecting to Data Sources, Establish Connection to the Excel Source
- Importing Data into Power BI or Query Editor
- Transforming the Data using Power Query
- Model the Data using Power Pivot – Relationship View
- Creating New Measures and New Columns using DAX – Data View
- Visualizing the Data using Power View and Power Maps – Report View
- Saving and Publishing the Visuals or Reports
- Logon to Power BI Service
- View the Reports in PBI Service and Share the Reports (Power View)
WEEK 3
Report View / Power View
- Report View User Interface
- Fields Pane, Visualizations Pane, Ribbon, Views, Pages Tab, Canvas
- Visual Interactions
- Interaction Type (Filter, Highlight, None)
- Visual Interactions Default Behavior, Changing the Interaction
- Bookmarks, Drill Through, Drilldown, Slicer, Hierarchy, Groupings
WEEK 4
Filters in Power View
- Filter Types
- Visual Level Filters, Page Level Filters, Report Level Filters, Drill Through Filters
- Filter Sub Types
- Basic Filtering, Advanced Filtering, Top N, Relative Date Filtering
- Numeric Field Filters, Text Field Filters, Date and Time Field Filters
WEEK 5
Grouping, Binning & Sorting
- Grouping and Binning Introduction
- Using Grouping, Creating Groups on Text Columns
- Using Binning, Creating Bins on Number Columns and Date Columns
- Sorting Data in Visuals
- Changing the Sort Column, Changing the Sort Order
- Sort using Column that is not used in the Visualization
- Sort using the Sort by Column Button
WEEK 6
Hierarchies and Drill-Down Reports
- Hierarchy Introduction, Default Date Hierarchy
- Creating Hierarchy, Creating Custom Date Hierarchy
- Change Hierarchy Levels
- Drill-Up and Drill-Down Reports
- Data Actions: Drill Down, Drill Up, Show Next Level, Expand Next Level
- Drilling Filters Other Visuals Option
WEEK 7
Visuals for Filtering
- Slicer Visualization
- When to Use a Slicer
- Create and Format Slicer Visualization
- Hierarchy Slicer (Custom Visualization)
- When to Use a Hierarchy Slicer
- Create and Format Hierarchy Slicer
- Advantages of Hierarchy Slicer
WEEK 8
Visualizing Categorical Data
- Create and Format Bar and Column Charts
- Create and Format Stacked Bar Chart, Stacked Column Chart
- Create and Format Clustered Bar Chart, Clustered Column Chart
- Create and Format 100% Stacked Bar Chart, 100% Stacked Column Chart
- Create and Format Pie and Donut Charts
- Create and Format the Tree Map Visual
- Create and Format Scatter Charts
WEEK 9
Visualizing Trend Data
- Line and Area Charts
- Create and Format Line Chart, Area Chart, Stacked Area Chart
- Combo Charts
- Create and Format Line and Stacked Column Chart, Line and Clustered Column Chart
- Create and Format Ribbon Chart, Waterfall Chart, Funnel Chart
WEEK 10
Visualizing KPI Data
- Create and Format Gauge Visual, KPI Visual
- Create and Format Card Visualization, Multi Row Card
Power Module
- Apache Spark Project
- Top Apache Spark Interview Questions
- Data Structures & Algorithms
Profile Optimisation
- Resume Building
- LinkedIn Optimisation
- Naukri Profile Optimisation
M1 Completed
Power Query
WEEK 1
Introduction to Power Query – Extract, Transform & Load
- Power BI Introduction
- Data Visualization, Reporting
- Business Intelligence (BI), Traditional BI, Self-Serviced BI
- Cloud Based BI Cloud Service vs On-Premise BI
- Power BI Products
- Power BI Desktop
- (Power Query - Transformation, Power Pivot - Modeling, Power View - Reports)
- Flow of Work in Power BI Desktop
- Server, Power BI Service, Power BI Mobile
- Flow of Work in Power BI / Power BI Architecture
- A Brief History of Power BI
WEEK 2
Data types and Filters in Power Query
- Data Transformation, Benefits of Data Transformation
- Shape or Transform Data using Power Query
- Overview of Power Query / Query Editor, Query Editor User Interface
- The Ribbon (Home, Transform, Add Column, View Tabs)
- The Queries Pane, the Data View / Results Pane, The Query Settings Pane, Formula Bar
- Advanced Editor – Complete ETL Code
- Saving Your Work – Appling ETL Changes – Loading into Power Pivot Model
- Power Query Conceptually
WEEK 3
Inbuilt Column Transformations
- Header Row or Use First Row as Headers
- Keep Top Rows, Keep Bottom Rows
- Keep Range of Rows
- Keep Duplicates, Keep Errors
- Remove Top Rows, Remove Bottom Rows, Remove Alternative Rows
- Remove Duplicates, Remove Blank Rows, Remove Errors
- Group Rows / Group By
WEEK 4
Combine Queries (Append Queries & Merge Queries) Append Queries / Union Queries
- Append Queries
- Append Queries as New
- Append 2 or more files individually with different queries
- Appending multiple files of same type from a folder using single query
- Query Options
- Copy Query, Paste Query
- Delete Query, Rename Query
- Enable Load, Include in Report Refresh
- Duplicate Query, Reference Query
- Move to Group, Move Up, Move Down
WEEK 5
Merge Queries / Join Queries
- Merge Queries, Merge Queries as New
- Default Types of Joins / Join Kinds / Merge Type
- Left Outer (all from first, matching from second)
- Right Outer (all from second, matching from first)
- Full Outer (all rows from both)
- Inner (only matching rows)
- Left Anti (rows only in first)
- Right Anti (rows only in second)
- Cartesian Join or Cross Join
Power Module
- Apache Spark Project
- Top Apache Spark Interview Questions
- Data Structures & Algorithms
Profile Optimisation
- Resume Building
- LinkedIn Optimisation
- Naukri Profile Optimisation
M1 Completed
Power Pivot
WEEK 1
Power BI Data Modeling – Relationship View
- Data Modeling Introduction
- Relationship, Need of Relationship
- Relationship Types / Cardinality in General
- One-to-One, One-to-Many (or Many-to-One), Many-to-Many
- AutoDetect the Relationship, Create a New Relationship, Edit Existing Relationships
- Make Relationship Active or Inactive
- Delete a Relationship
- Cross Filter Direction (Single, Both), Assume Referential Integrity
WEEK 2
Enhancing the Data Model - DAX
- What is DAX, Calculated Column, Measures?
- DAX Table and Column Name Syntax
- Creating Calculated Columns, Creating Measures
- Implicit Vs Explicit Measures
- Calculated Columns Vs Measures
- DAX Syntax & Operators
- DAX Operators
- Types of Operators
- Arithmetic Operators, Comparison Operators, Text Concatenation Operator, Logical Operators
Power Module
- Apache Spark Project
- Top Apache Spark Interview Questions
- Data Structures & Algorithms
Profile Optimisation
- Resume Building
- LinkedIn Optimisation
- Naukri Profile Optimisation
M1 Completed
DAX Functions Categories
WEEK 1
DAX Functions
- Date and Time Functions
- Logical Functions
- Text Functions
- Math & Statistical Functions
- Filter Functions
- Time Intelligence Functions
WEEK 2
DAX Functions
- DAX Date & Time Functions
- YEAR, MONTH, DAY
- WEEKDAY, WEEKNUM
- Month Name, Weekday Name <> FORMAT (Text Function)
- DATE, TODAY, NOW
- HOUR, MINUTE, SECOND, TIME
- DATEDIFF, CALENDAR
- Creating Date Dimension Table
WEEK 3
DAX Logical Functions
- IF
- TRUE, FALSE
- NOT, OR, IN, AND
- IFERROR
- SWITCH
WEEK 4
DAX Text Functions
- LEN, CONCATENATE (&)
- LEFT, RIGHT, MID
- UPPER, LOWER
- TRIM, SUBSTITUTE, BLANK
WEEK 5
DAX Math and Statistical Functions
- INT
- ROUND, ROUNDUP, ROUNDDOWN
- DIVIDE
- EVEN, ODD
- POWER, SIGN
- SQRT, FACT
- SUM, SUMX
- MIN, MINX
- MAX, MAXX
- COUNT, COUNTX
- AVERAGE, AVERAGEX
- COUNTROWS, COUNTBLANK
WEEK 6
DAX Filter Functions
- CALCULATE
- ALL
- RELATED
WEEK 7
DAX Time Intelligence Functions
- Time Intelligence Introduction
- TOTALMTD, TOTALQTD, TOTALYTD
- PREVIOUSDAY, PREVIOUSMONTH, PREVIOUSQUARTER, PREVIOUSYEAR
- NEXTDAY, NEXTMONTH, NEXTQUARTER, NEXTYEAR
- SAMEPERIODLASTYEAR
- YOY Growth
- MOM Growth
WEEK 8
Visualizing Tabular Data, Geographical Data
- Create and Format Table Visual, Matrix Visualization
- Create and Format Map Visual, Filled Map Visual, Arc GIS Maps Visual
- Create and Format R Script Visual
Power Module
- Apache Spark Project
- Top Apache Spark Interview Questions
- Data Structures & Algorithms
Profile Optimisation
- Resume Building
- LinkedIn Optimisation
- Naukri Profile Optimisation
M1 Completed
Power BI Service
WEEK 1
Power BI Service Introduction
- Power BI Service Introduction, Power BI Cloud Architecture
- Creating Power BI Service Account, SIGN IN to Power BI Service Account
- Publishing Reports to the Power BI Service, Import / Getting the Report to PBI Service
- My Workspace / App Workspaces Tabs
- DATASETS, WORKBOOKS, REPORTS, DASHBOARDS
WEEK 2
Dashboards Development
- Creating Dashboards
- Pin Visuals and Pin LIVE Report Pages to Dashboard
- Advantages of Dashboards
- Interacting with Dashboards
- Adding Tiles to Dashboards
- Web Content, Image, Text Box, Video
- Formatting Dashboard
- Sharing Dashboard
WEEK 3
Data Gateways
- Introduction to Data Gateways
- How Data Gateways Work
- Connect to an On-Premise Data Source by Using a Data Gateway
- Download Data Gateway
- Installing a Data Gateway
- Types of Gateways
- On-Premises Data Gateway, On-Premises Data Gateway (Personal Mode)
- Manage Data Gateway
- Add and Remove Administrators
- Add Data Source, Add or Remove Users to a Data Source
- Refresh On-Premise Data
- Configuring Automatic Refresh using Schedules
WEEK 4
Collaboration in Power BI using App Workspace
- Introduction to App Workspaces
- Create an App Workspace
- Add Members to App Workspace to Collaborate
- App Workspace Access
- Admin, Member, Contributor
WEEK 5
Sharing Power BI Content using Apps and Content Packs
- Introduction to App
- Publish an App
- Update a Published App
- Include in App, Exclude in App
- Sharing App
- Entire Organization, Specific Individuals or Group
- Un-publishing an App
- Specific Groups, My Entire Organization
- Selecting the Content / Items to Publish or Share
WEEK 6
Row Level Security in Power BI
- Introduction to Row Level Security
- Row Level Security (RLS) with DAX
- Manage Roles, Creating Roles, Testing Roles
- Adding Members to Roles in Power BI Service
- Dynamic Row Level Security
- Creating Users Table and Adding to the Model
- Capturing Users using UserName() or UserPrincipalName() DAX Functions
Power Module
- Apache Spark Project
- Top Apache Spark Interview Questions
- Data Structures & Algorithms
Profile Optimisation
- Resume Building
- LinkedIn Optimisation
- Naukri Profile Optimisation
M1 Completed
SSAS Tabular Model Cube
WEEK 1
Introduction to SSAS Tabular
- Creating a Project
- Relationship and Measures
- Measures and Their Usage
- Advantages of Tabular Model
- Limitations
WEEK 2
Tabular Model Basics
- Tabular – Development Server
- Workspace Server configuration
- SSAS Configuration management
- Project, Model – Properties
WEEK 3
Tabular Model – Design
- Creating new model
- Importing data from different sources
- Create and Maintain relationship across data sources
- Creating measures and their usage
- Creating calculated columns
- Creating Hierarchies based on data sources
- Deployment
WEEK 4
Deploy Tabular Model using SSMS
- Managing Server Properties
- Managing Cube properties
- Deploy the Cube
WEEK 5
ADD ON
- Real-time Project Explanation
- Resume Preparation
- Interview Questions Discussions
- Mock Interviews
Power Module
- Apache Spark Project
- Top Apache Spark Interview Questions
- Data Structures & Algorithms
Profile Optimisation
- Resume Building
- LinkedIn Optimisation
- Naukri Profile Optimisation
M1 Completed
SQL Server
WEEK 1
Introduction to DBMS
- File Management System and Its Drawbacks
- Introduction to Database Management System (DBMS)
- Types of DBMS Systems
- Network DBMS (NDBMS)
- Hierarchical DBMS (HDBMS)
- Relational DBMS (RDBMS)
WEEK 2
Introduction to SQL Server
- SQL Server Versions and History
- Connecting to Server
- Authentication Modes
- SQL Server Authentication Mode
- Windows Authentication Mode
- SQL Server Management Studio and Tools
WEEK 3
SQL Server Database Design
- Database Creation using GUI
- Database Creation using T-SQL Scripts
- DB Design using Files and File Groups
- Pages and Extents
- Data File and Log File and Its Features
WEEK 4
Business Integrity
- Why Business Integrity
- Features of Business Integrity
- Null / Not Null
- Default
- Candidate Keys
- Primary Key
- Unique Key / Alternate Keys
- Foreign Key
- Check Constraints
- Identity
WEEK 5
SQL Server Data Types
- Unicode Vs. Non-Unicode
- Char, Varchar and Varchar (Max)
- nChar, nVarchar and nVarchar (Max)
- Numerical Data Types
- Currency Data Types
- Binary Data Types
- GUID Data Type
- Timestamp Data Type
- Bit Data Type
- Spatial Data Type
WEEK 6
SQL Server Data Types
- Unicode Vs. Non-Unicode
- Char, Varchar and Varchar (Max)
- nChar, nVarchar and nVarchar (Max)
- Numerical Data Types
- Currency Data Types
- Binary Data Types
- GUID Data Type
- Timestamp Data Type
- Bit Data Type
- Spatial Data Type
WEEK 7
Introduction to SQL
- Types Of SQL Commands
- Data Definition Language (DDL)
- Data Manipulation Language (DML)
- Data Control Language (DCL)
- Transaction Control Language (TCL)
WEEK 8
Queries
- Simple Queries
- Filter Rows using Where Clause
- Filter Columns using Select Clause
- Sorting Data
- Concatenate Strings and Columns
- Working with Columns and Constants
- Group By and Aggregations
- Having Clause
- Top (n) and Top (n) Percent
- Union and Union All
- Intersect and Except
- ISNULL()
-
Joins
- Inner Join
- Outer Join (Left, Right, Full)
- Self Join
- Cross Join
-
Sub Queries
- Single Row Sub Queries
- Nested Sub Queries
- Co-Related Sub Queries
- Exists and Not Exists Functions
- Derived Tables
- Cube and Rollup Operators
Power Module
- Apache Spark Project
- Top Apache Spark Interview Questions
- Data Structures & Algorithms
Profile Optimisation
- Resume Building
- LinkedIn Optimisation
- Naukri Profile Optimisation
M1 Completed
SQL Server
WEEK 1
Introduction to DBMS
- String Functions
- Data Conversion Functions
- Date and Time Functions
- Aggregate Functions
- Ranking Functions
- Common Table Expressions (CTE)
WEEK 2
Indexes
- Heap Vs Indexes
- Clustered Index
- Non-Clustered Index
- Filtered Index
- Covered Index
- Create, Alter and Drop Indexes
- Statistics
- Performance Tuning of Queries
WEEK 3
Views
- Purpose of Views
- Creating, Altering and Dropping Views
- Updateable and Non-Updateable Views
- Encryption and SchemaBinding With CheckOption in Views
- Indexed Views
WEEK 4
Intro to T-SQL Programming
- Declaring Variables
- Local and Global Variables
- Local and Global Temp Tables
- IF… ELSE
- While Loop
- Return Statement
- Table Variable Vs. Temp Tables
- Exception Handling with Try… Catch Blocks
WEEK 5
Stored Procedures
- Need for Stored Procedures
- Creating, Altering and Dropping Stored Procedures
- Optional Parameters
- Input and Output Parameters
- Nested Stored Procedures
- Re-Compiler Stored Procedures
- Advantages and Disadvantages of Stored Procedures
- Writing Complex Stored Procedures
- Writing Stored Procedures with Cursors
WEEK 6
Cursors
- Need for Cursors
- Types of Cursors
- Forward_Only and Scroll Cursors
- Static, Dynamic and Keyset Cursors
- Visibility of Cursors
WEEK 7
User Defined Functions (UDFs)
- Need for UDFs
- Creating, Altering and Dropping UDFs
- Types of User Defined Functions
- Scalar Functions
- Inline Table Valued Functions
- Multi-Statement Table Valued Functions
WEEK 8
Triggers
- Purpose of Triggers
- Creating, Altering and Dropping Triggers
- Types of Triggers
- For or After Triggers
- Instead Of Triggers
- Magic Tables (Inserted, Deleted)
- Rollback in Triggers
WEEK 9
Triggers
- Purpose of Triggers
- Creating, Altering and Dropping Triggers
- Types of Triggers
- For or After Triggers
- Instead Of Triggers
- Magic Tables (Inserted, Deleted)
- Rollback in Triggers
WEEK 10
Transactions
- Introduction
- Begin Transaction
- Commit Transaction
- Rollback Transaction
- Save Transaction
- Role of Log File in Transaction Management
- Implicit Transactions
- Explicit Transactions
- Locks and Concurrency
Power Module
- Apache Spark Project
- Top Apache Spark Interview Questions
- Data Structures & Algorithms
Profile Optimisation
- Resume Building
- LinkedIn Optimisation
- Naukri Profile Optimisation
M1 Completed
SSIS – SQL SERVER INTEGRATION SERVICES (ETL)
WEEK 1
SSIS – SQL Server Integration Services (ETL)
- SSIS Framework/Architecture
- SSIS Package Architecture Overview
- Development and Management Tools
- The Import and Export Wizard
WEEK 2
Introduction to Data Flow
- Data Flow Overview
- Data Sources
- Data Destinations
- Data Flow Transformations
- Data Viewers
WEEK 3
Data Sources
- Excel Source
- Flat File Source
- OLE DB Source
- XML Source
WEEK 4
Data Flow Transformations
- Aggregate Transformation
- Audit Transformation
- Character Map Transformation
- Conditional Split Transformation
- Copy Column Transformation
- Derived Column Transformation
- Data Conversion Transformation
- Multicast Transformation
- OLE DB Command Transformation
- Percentage Sampling Transformation
- Row Count Transformation
- Sort Transformation
- Union All Transformation
WEEK 5
Advanced Data Flow Transformations
- Lookup Transformation
- Merge Transformation
- Merge Join Transformation
- Slowly Changing Dimension Transformation
- Pivot Transformation
- Export Transformation
- Import Transformation
- Unpivot Transformation
WEEK 6
Data Flow Destinations
- Data Reader Destination
- Excel Destination
- Flat File Destination
- OLE DB Destination
WEEK 7
User Defined Functions (UDFs)
- Need for UDFs
- Creating, Altering and Dropping UDFs
- Types of User Defined Functions
- Scalar Functions
- Inline Table Valued Functions
- Multi-Statement Table Valued Functions
WEEK 8
Introduction to Control Flow
- Control Flow Overview
- Precedence Constraints
- The Execute SQL Task
- The Bulk Insert Task
- The File System Task
- The FTP Task
- The Send Mail Task
- Bulk Insert Task
- Data Flow Task
- Execute DTS 2000 Package Task
- Execute Package Task
- Execute Process Task
- Web Service Task
- XML Task
WEEK 9
Advanced Control Flow
- For Loop Container
- For Each Loop Container
- Sequence Container
WEEK 10
Variables and Configurations
- Variables Overview
- Variable Scope
- SSIS System Variables
- Using Variables in Control Flow
- Using Variables in Data Flow
- Using Variables to Pass Information Between Packages
- Property Expressions
- Configuration Overview
- Configuration Options
- Configuration Discipline
WEEK 11
Debugging, Error Handling and Logging
- SSIS Debugging Overview
- Configuring Package Logging
- Breakpoints in SSIS
- Event Handler in SSIS
- Configure Error Output in Data Flow
- Data Viewers
- Configure Check Points
- Transactions in SSIS
- SSIS Security
WEEK 12
Extending SSIS through Custom Code – Scripting
- Introduction to SSIS Scripting
- The SSIS Script Editor
- The SSIS Object Model
- Script in Control Flow: The Script Task
- Script in Data Flow: The Script Component
- Introduction to SSIS Component Development
WEEK 13
SSIS Deployment
- Create Configuration Files
- Implement Logging
- Different Deployment Options
- Executing Packages using Utilities – DTExec and DTExecUI
- Schedule SSIS Packages with SQL Server Agent Jobs
- Monitoring Jobs in SQL Server
- Call SSIS Packages in Stored Procedures
- Call SSIS Packages in Command Prompt
WEEK 14
Data Warehouse Concepts
- Introduction to Data Warehousing
- What is a Dimension?
- What is Fact or a Measure?
- Star Schema
- Snowflake Schema
- Difference between Star and Snowflake Schema
- Data Mart vs Data Warehouse
- Types of Dimensions
- Types of Facts
- Role Playing Dimension
- Junk Dimension
- Conformed Dimension
- Normalization vs De-normalization
- Slowly Changing Dimension (SCD Types)
Power Module
- Apache Spark Project
- Top Apache Spark Interview Questions
- Data Structures & Algorithms
Profile Optimisation
- Resume Building
- LinkedIn Optimisation
- Naukri Profile Optimisation
M1 Completed
WEEK 1 – 3
- Big Data – The Big Picture
- Distributed Storage & Processing Fundamentals
WEEK 4 - 9
- Apache Spark In-Depth
WEEK 10 - 11
- Apache Spark Optimizations
WEEK 12 - 13
- Apache Spark Optimizations
Course Fee
For Students accessing the course from India
(Duration: 7 Months – Validity: 2 Years)
Students Say’s About Our Institute

Harikrishna K.
I attended MSBI(SSIS,SSAS),SQL Server ,Power BI ,Data Warehouse Courses by Under Bhaskar Jogi Sir Training. Bhaskar ,for MSBI and power BI learners very good platform Go online Trainings Institute .I learned a lot from Bhaskar sir’s teaching ,Thank You So Much Sir.

Arjun Sudheer
I am really impressed with the way Bhaskar sir teaches each and every concept! He is very passionate about teaching and that can be experienced with the way he teaches each topic, with his teaching anyone can learn any technology with ease! He teaches each and every concept .

Rajsekhar Koneru
I have completed power bi ,SQL server, Data Warehouse and SSIS with Bhaskar Jogi sir. The training is fabulous. I never seen this kind of training in my life. Thanks a lot Bhaskar sir. I recommend this training to all students who wanted a job in IT sector.

Sai Kumar Reddy
Am attending the PBI, DWH, SQL Server by Bhaskar Jogi Sir. I strongly recommend this course and the teaching by Bhaskar Jogi is very easy to understand with real time case study. Even non IT people can learn with the teachings of Bhaskar Jogi and get into the IT Industry.
Request Call back

Contact Us

Address
Hyderabad, Telangana, 500072
























