www.datavizon.

com

Our Social Networks

FULLSATCK
POWER BI WITH
MICROSOFT FABRIC TOOLS

REAL-TIME PROJECTS | GUIDANCE WITH RESUME & INTERVIEW | RICH MATERIAL WITH LIFE TIME ACCESS
 www.datavizon.com \ksrdatavizon +91 89517 96123

Course Curriculum

SQL

Power Bi

ADF

Azure Synapses

Azure DataBricks

Azure Data Lake

Logic apps

Microsoft Copilot
REAL-TIME PROJECTS | GUIDANCE WITH RESUME & INTERVIEW | RICH MATERIAL WITH LIFE TIME ACCESS
 www.datavizon.com
About KSR Datavizon
Welcome to KSR Datavizon, we are your one-stop solution for all trending technologies. We provide in-depth
knowledge about all trending courses with 100% placement guaranteed. You also will get hands-on
demonstrations, interactive live sessions to learn and grow more on current trending courses like AI, Machine
Learning, Data Science, Cloud Computing, Full stack Development, Cyber Security, Credit Risk modelling,
DevOps, Azure,AWS, PowerBi, Web Development, Data Engineer, ADF, MSBI and Snowflakes and many more

You also get career guidance, soft skills sessions and resume building and all other interview tips to get settled
in your dream career.

About Structured Query Language (SQL)

SQL is a must have skill for every data science professional. This course will
start from basics of databases and structured query language (SQL) and
teach you every thing you would need in any data science profession
including Writing and executing efficient Queries, Joining multiple tables
Getting and appending and manipulating tables

Started
with SQL

Key takeaways from Structured Query Language (SQL)

Start using MySQL – the most popular Database Management System

Learn how to perform database tasks in SQL
How to insert, update, and delete records from your database
How to create reports and perform basic analysis using SQL’s
aggregate functions
How to perform efficient joins to fetch your data from multiple tables

REAL-TIME PROJECTS | GUIDANCE WITH RESUME & INTERVIEW | RICH MATERIAL WITH LIFE TIME ACCESS
 www.datavizon.com \ksrdatavizon +91 89517 96123

Modules : SQL
Introduction What is SQL?
Brief history of SQL
Why is SQL Important
Popular Databases
What Is MySQL?
Introduction to MySQL & MySQL workbench
Install MySQL Database Server
Connect to MySQL Server

Selecting Database
MYSQL Data CREATE DATABASE
Definition DROP DATABASE
Data Types
CREATE TABLE
Sequence
ALTER TABLE
ADD COLUMN
DROP COLUMN
RENAME TABLE
DROP TABLE
TRUNCATE TABLE

SELECT
MYSQL DATA ORDER BY
MANIPULATION WHERE
SELECT DISTINCT
AND
OR
IN
BETWEEN
LIKE
LIMIT
IS NULL
Table & Column Aliases
GROUP BY
HAVING
Subquery

REAL-TIME PROJECTS | GUIDANCE WITH RESUME & INTERVIEW | RICH MATERIAL WITH LIFE TIME ACCESS
 www.datavizon.com \ksrdatavizon +91 89517 96123

SQL
MYSQL DATA Derived Tables
MANIPULATION EXISTS
UNION
MINUS
INTERSECT
INSERT
UPDATE
DELETE
REPLACE

GRANT
Data Control REVOKE
Language

Transaction COMMIT
ROLLBACK
Control Language
SAVEPOINT
SET TRANSACTION

MYSQL DATA BIT

BOOLEAN
TYPES
CHAR
DATE
DATETIME
DECIMAL
INT
TIME
TIMESTAMP
VARCHAR

REAL-TIME PROJECTS | GUIDANCE WITH RESUME & INTERVIEW | RICH MATERIAL WITH LIFE TIME ACCESS
 www.datavizon.com \ksrdatavizon +91 89517 96123

SQL
SQL Constraints Primary Key
Foreign Key
UNIQUE Constraint
CHECK Constraint
NOT NULL
DEFAULT

JOINS
SQL Joins
INNER JOIN
LEFT JOIN
RIGHT JOIN
Self-Join
CROSS JOIN

SQL Subqueries Single-row subqueries

Multiple-row subqueries
Correlated subqueries

Rank
SQL Advanced
Dense Rank
Queries Row number

REAL-TIME PROJECTS | GUIDANCE WITH RESUME & INTERVIEW | RICH MATERIAL WITH LIFE TIME ACCESS
 www.datavizon.com \ksrdatavizon +91 89517 96123

Power Bi
About Microsoft Power BI
Microsoft Power BI is considered as the leader amongst the Business
Intelligence platforms, way ahead of other industry giants. With seamless
integration with other Microsoft products, Power BI gives organizations easy
access to connect to various data sources, crunch-numbers, prepare, view,
and publish interactive dashboards. Power BI comes with Power Query and
Data Modeling capabilities that allow users to clean, reshape, transform and
link data from various sources with just a click.

Key takeaways from the Course

Learn about the features of Power BI and explore how can it be integrated
into the current business intelligence framework
Know about some key concepts specific to Power BI (measures and
calculated columns) for performing your tasks
Create your first interactive business intelligence dashboard with Power BI
Storytelling and data security using PowerBI
Learn about transforming the data with Power Query in PowerBI

REAL-TIME PROJECTS | GUIDANCE WITH RESUME & INTERVIEW | RICH MATERIAL WITH LIFE TIME ACCESS
 www.datavizon.com \ksrdatavizon +91 89517 96123

Course curriculum Power Bi

Power BI basics Introduction to Reporting
History of Power BI
Power bi desktop installation
Advantages of power bi than SSRS
Tool Introduction
Creating a sample Report

Power BI Desktop What is Power BI Desktop?

Connecting / fetching the data to power bi from
SQL SERVER / EXCEL /
Tabular SSAS/text file.
Modifying the data source settings.
Understanding of Relationships view/Data
view/report view
Creating/modifying and deleting the relationships.
Manage Relationships.
Creating / deleting and renaming the reports
Data Refresh options
Table level & column level options
Delete
Rename
Hide
View Hidden
Unhide/collapse/expand all
All filter
New Hierarchy
New Measure/calculation
Datatypes, Changing the Datatype of a Column
Filters in Power Query
Auto Filter / Basic Filtering
Filter a Column using Text Filters
Filter a Column using Number
Filters Filter a Column using Date Filters
Filter Multiple Columns
Other reporting options
Cut
Copy
Paste
Format Painter

REAL-TIME PROJECTS | GUIDANCE WITH RESUME & INTERVIEW | RICH MATERIAL WITH LIFE TIME ACCESS
 www.datavizon.com \ksrdatavizon +91 89517 96123

Course curriculum
Power Bi
Adding images/Text boxes/shapes
Enter Data
Page View

Power BI Query – Table level options

Copy
Transform Data /
Paste
Edit Queries Delete
Rename
Duplicate
Reference
Move up/down/group
Create function

Column Level options Copy/rename

Rename other columns
Duplicate columns
Remove duplicate / errors
Change type
Transform
Replace
Replace error
Split column
Group by
Fill up
Fill down
Unpivot columns and other columns
Rename
Move
Drilldown
Add as a new query
Other options
Merge queries
Append queries
Use first row as a header
Sorting
Create / work with parameters

REAL-TIME PROJECTS | GUIDANCE WITH RESUME & INTERVIEW | RICH MATERIAL WITH LIFE TIME ACCESS
 www.datavizon.com \ksrdatavizon +91 89517 96123

Course curriculum
Power Bi
Append Queries: Append Queries
Append Queries as New
Append 2 or more files individually with
different queries
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

Merge 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
Transpose
Reverse columns
Count
Detect data types
Extract
Parse
Date
Time
Expand
Aggregate

Power BI Service Power BI Service Introduction, Power BI Cloud

Power BI Service Architecture
Creating Power BI Service Account, SIGN IN to
Introduction
Power BI Service
Account
Publishing Reports to the Power BI service, Import /
Getting the
Report to PBI Service
REAL-TIME PROJECTS | GUIDANCE WITH RESUME & INTERVIEW | RICH MATERIAL WITH LIFE TIME ACCESS
 www.datavizon.com \ksrdatavizon +91 89517 96123

Course curriculum
Power Bi
My Workspace / App Workspaces Tabs
DATASETS, WORKBOOKS, REPORTS, DASHBOARDS
Working with Datasets, Creating Reports in Cloud
using Published Datasets
Power BI Datasets Live Connection using Desktop
Working with Workbooks, working with Reports,
Sharing Reports

Publishing Reports to the Power BI service, Import

Dashboards / Getting the Report to PBI Service
My Workspace / App Workspaces Tabs
Development
DATASETS, WORKBOOKS, REPORTS, DASHBOARDS
Working with Datasets, Creating Reports in Cloud
using Published Datasets
Power BI Datasets Live Connection using Desktop
Working with Workbooks, working with Reports,
Sharing Reports 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

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
REAL-TIME PROJECTS | GUIDANCE WITH RESUME & INTERVIEW | RICH MATERIAL WITH LIFE TIME ACCESS
 www.datavizon.com \ksrdatavizon +91 89517 96123

Course curriculum
Power Bi
Refresh On Premise Data
Configuring Automatic Refresh using Schedules

Collaboration in Introduction to App Workspaces

Create an App Workspace
Power BI using App
Add Members to App Workspace to Collaborate
Workspace App Workspace Access
Admin, Member, Contributor

Sharing Power BI Introduction to App

Publish an App
Content using Apps Update a Published App
and Content Packs Manage Content in App
Include in App, Exclude in App
Sharing App
Entire Organization, Specific individuals or group

Row Level Security in Introduction to Row Level Security

Row Level Security (RLS) with DAX
Power BI
Manage Roles, Creating Roles, Testing Roles
Adding Members to Roles in Power BI Service

Power BI Mobile App How to install Power BI Mobile App

How to sign in to mobile app
How to customize reports / visuals only for mobile
apps specific.

Power BI Licensing Introduction to power bi licensing model

What is Power BI Pro
Models (Pro)
What Is Power BI Premium
Difference between those two Pro and Premium

REAL-TIME PROJECTS | GUIDANCE WITH RESUME & INTERVIEW | RICH MATERIAL WITH LIFE TIME ACCESS
 www.datavizon.com \ksrdatavizon +91 89517 96123

Course curriculum
Power Bi
Enhancing the Data Model - DAX
DAX – Data Analysis
What is DAX, Calculated Column, Measures
Expressions DAX Table and Column Name Syntax
Creating Calculated Columns, Creating Measures
Calculated Columns Vs Measures
DAX Syntax & Operators
DAX Operators
Types of Operators
Arithmetic Operators, Comparison Operators, Text
Concatenation
Operator, Logical Operators
Filter & value functions
Logical functions
Mathematical functions
Statistical functions
Text functions
Time functions

DAX Date & Time YEAR, MONTH, DAY

WEEKDAY, WEEKNUM
Functions FORMAT (Text Function) Month Name, Weekday
Name
DATE, TODAY, NOW
HOUR, MINUTE, SECOND, TIME
DATEDIFF, CALENDAR
Creating Date Dimension Table

DAX Text Functions LEN, CONCATENATE (&)

LEFT, RIGHT, MID
UPPER, LOWER
TRIM, SUBSTITUTE, BLANK

DAX Logical IF
TRUE, FALSE
Functions NOT, OR, IN, AND
IFERROR
SWITCH

REAL-TIME PROJECTS | GUIDANCE WITH RESUME & INTERVIEW | RICH MATERIAL WITH LIFE TIME ACCESS
 www.datavizon.com \ksrdatavizon +91 89517 96123

Course curriculum
Power Bi
INT
DAX Math and
ROUND, ROUNDUP, ROUNDDOWN
Statistical Functions DIVIDE
EVEN, ODD
POWER, SIGN
SQRT, FACT
SUM, SUMX
MIN, MINX
MAX, MAXX
COUNT, COUNTX
AVERAGE, AVERAGEX
COUNTROWS, COUNTBLANK

DAX Filter Functions CALCULATE

CALCULATETABLE
ALL
RELATED
ALLSELECTED
ALLCROSSFILTERED
DISTINCT
EARLIER
FILTER
HASONEFILTER
HASONEVALUE
ISFILTERED
ISCROSSFILTERED
SELECTEDVALUE
USERRELATIONSHIP

DAX Time Time Intelligence Introduction

TOTALMTD, TOTALQTD, TOTALYTD
Intelligence
PREVIOUSDAY, PREVIOUSMONTH
Functions PREVIOUSQUARTER, PREVIOUSYEAR
NEXTDAY, NEXTMONTH
NEXTQUARTER, NEXTYEAR
SAMEPERIODLASTYEAR
PARALLALPERIOD

REAL-TIME PROJECTS | GUIDANCE WITH RESUME & INTERVIEW | RICH MATERIAL WITH LIFE TIME ACCESS
 www.datavizon.com \ksrdatavizon +91 89517 96123

Course curriculum
Power Bi
PBI certified Visuals
Power BI Custom
Word Cloud
Visualizations Infographic Designer
Drill down pie chart
Histogram

Pagination Reports
What are paginated reports in Power BI?
Introduction
Installation

Pagination Compare Power BI reports and paginated reports

Create reports in Power BI Report Builder
Reports Report Design
Page Layout
Create paginated reports with matrix, chart, and
free-form layouts

Deployment pipelines with paginated reports

Deployment &
Embed Power BI paginated reports limitations
Embed

REAL-TIME PROJECTS | GUIDANCE WITH RESUME & INTERVIEW | RICH MATERIAL WITH LIFE TIME ACCESS
 www.datavizon.com \ksrdatavizon +91 89517 96123

Course curriculum Microsoft Fabric

Introduction What is Microsoft Fabric?
Components of Microsoft Fabric

Microsoft Fabric Trial Types

(Preview) trial Limitations

Features of Fabric
Microsoft Fabric Latest Updates
preview Known limitations and Future Scope

Synapse Data Engineering

Microsoft Fabric a. Lakehouse
terminology b. Notebook

Data Factory
a. Connector
b. Data pipeline
c. Dataflow Gen2

Synapse Data Science

a. Data Wrangler
b. Model

Synapse data warehousing

a. Data Warehouse

Synapse Real-Time Analytics

a. KQL database
b. Event stream

REAL-TIME PROJECTS | GUIDANCE WITH RESUME & INTERVIEW | RICH MATERIAL WITH LIFE TIME ACCESS
 www.datavizon.com \ksrdatavizon +91 89517 96123

Azure(Azure
Course curriculum Analytics)&ADF
What is Cloud Computing?
Induction to Cloud
Different cloud platforms
Computing Could Services

Overview of AZURE
Azure AZURE Free Account
Introduction Azure Portal
Azure Services and Applications

Azure Services Introduction to Blob and ADLS

Creation of storage accounts

Why and what is ETL with its components.

ADF (ETL) ADF introduction
Components of ADF
Linked Services
Datasets
Activity
Pipelines
Dataflow
Parameters
Variables
Triggers
Data Transformation
Integration runtime and types
Real time Use Cases
Scenario based Dataflows
a. Add email notification in Azure Data Factory
b. Azure - Incremental load using ADF Data Flows
c. Refresh Power BI Datasets with ADF
End to End Pipeline (ADLS-> ADF -> Azure SQL)

REAL-TIME PROJECTS | GUIDANCE WITH RESUME & INTERVIEW | RICH MATERIAL WITH LIFE TIME ACCESS
 www.datavizon.com \ksrdatavizon +91 89517 96123

Course curriculum
Azure
Synapse Analytics
Introduction to Azure What is Azure Synapse Analytics?
Synapse Analytics Components of Azure Synapse Analytics.
Difference between ADF and Synapse.
Concepts of Pools (Dedicated and Serveries).
Analyse and Monitor Data in Serveress and
Dedicated Pool.
Create Pipelines in Azure Synapse.
Creation of Synapse Notebooks.
Synapse with Power BI

Azure
Data Bricks
Azure Data Bricks What is Data bricks.
Components and Environments in Databricks.
Create and run Data bricks Notebook.
Jobs and automation of Notebooks in Databricks.
Creating Scopes in Databricks key vault integration.
Creation of clusters and spark use cases.
Spark Architecture and Master Slave mechanism in
spark.

REAL-TIME PROJECTS | GUIDANCE WITH RESUME & INTERVIEW | RICH MATERIAL WITH LIFE TIME ACCESS
 www.datavizon.com \ksrdatavizon +91 89517 96123

Azure
Course curriculum DataLakes
What are Storage account/Data lake in Azure.
Azure DataLakes What are storage services and why Data lake in
Storage Accounts Azure.
How to create the Data lake sevices in Azure.
Gen1 vs Gen2 Datalake difference.
Creation of containers and folders.
Use case in storing large data and integration of ADF
copy activities in DataLakes.

Azure
Logic Apps
Azure Logic Apps What are Logic Apps.
Logic Apps and Power Automate Differences.
Connectors in Logic Apps.
How Logic Apps are useful for automation or
notification purpose.
Send an email notification using Logic Apps.

REAL-TIME PROJECTS | GUIDANCE WITH RESUME & INTERVIEW | RICH MATERIAL WITH LIFE TIME ACCESS
 www.datavizon.com

Our Social Networks

WHAT YOU WILL GET AFTER COMPLETION OF THIS COURSE

Course Completion Buliding an impressive Client handling Resume Forwarding to

certificate LINKEDIN and Techniques Recruitment Team & Support
NAUKRI Proflie till you get Interview Calls

Building an Impressive Interview Interview Preparation Tips and LMS Platform Access for
ATS Friendly Resume Preparation Tips and Mock Soft Skills and Corporate 365 Days (All Recorded
Mock Interviews Office Etiquette’s Sessions)

100% Job Assistance

Attend 1 Week Free Online & Offline
Sessions Classes

REAL-TIME PROJECTS | GUIDANCE WITH RESUME & INTERVIEW | RICH MATERIAL WITH LIFE TIME ACCESS
 Our Social Networks

To Join our Courses in

KSR Datavizon

Register Now

Get In Touch

R.J.Gardens, Anand Nagar,Aswath Nagar,

Marathahalli, Bengaluru, Karnataka 560037

+91 89517 96123

www.datavizon.com

Mon-Fri: 9AM –9PM

REAL-TIME PROJECTS | GUIDANCE WITH RESUME & INTERVIEW | RICH MATERIAL WITH LIFE TIME ACCESS