nd
Flat No: 208, 2 Floor, Annapurna Block,
Ameerpet, Hyderabad – 500038
+91-9985-177-188
+91-9985-177-188
info@[Link]
/kalyanithub /kalyanit [Link]
/kalyanithub #kalyanithub
DATA ANALYTICS
Statistics:
Descriptive Statistics
Mean
Median
Mode
Skewness
Distributions:
What are Distributions?
Normal Distribution
Probability Theory:
Probability Basics
Calculate Simple Probabilities
Regressions:
Linear Regression
Correlation Coefficient
Root Mean Square error
Advanced Analysis:
Pivot tables:
Displaying Pivot table
Formatting Pivot Table
Creating Vlookups and HlookUP
Using Vlookup
Using Hlookup
Using Functions in Excel
nd
Flat No: 208, 2 Floor, Annapurna Block,
Ameerpet, Hyderabad – 500038
+91-9985-177-188
+91-9985-177-188
info@[Link]
/kalyanithub /kalyanit [Link]
/kalyanithub #kalyanithub
Power BI
Get data from different Data sources:
Identify and connect to a data source
Change data source settings
Select a shared dataset or create a local dataset
Select a storage mode
Profile the Data:
Identify data anomalies
Examine data structures
Interrogate column properties
Interrogate data statistics.
Clean, Transform, and Load the Data – Power Query Editor:
Resolve inconsistencies, unexpected or null values, and data quality issues
Apply user-friendly value replacements
Identify and create appropriate keys for joins
Evaluate and transform column data types
Apply data shape transformations to table structures
Combine queries
Apply user-friendly naming conventions to columns and queries
Leverage Advanced Editor to modify Power Query M code
Configure data loading
Resolve data import errors
Design a Data Model:
Define the tables
Configure table and column properties
Define quick measures
Flatten out a parent-child hierarchy
Define role-playing dimensions
Define a relationship’s cardinality and cross-filter direction
Design the data model to meet performance requirements
Resolve many-to-many relationships
Create a common date table
Define the appropriate level of data granularity
nd
Flat No: 208, 2 Floor, Annapurna Block,
Ameerpet, Hyderabad – 500038
+91-9985-177-188
+91-9985-177-188
info@[Link]
/kalyanithub /kalyanit [Link]
/kalyanithub #kalyanithub
Apply or change sensitivity label
Create Measures by using DAX:
Use DAX to build complex measures
Use CALCULATE to manipulate filters
Implement Time Intelligence using DAX
Replace numeric columns with measures
Use basic statistical functions to enhance data
Create semi-additive measures
Create Reports:
Add visualization items to reports
Choose an appropriate visualization type
Format and configure visualizations
Import a custom visual
Configure conditional formatting
Configure small multiples
Apply slicing and filtering
Add an R or Python visual
Add a Smart Narrative visual
Configure the report page
Design and configure for accessibility
Configure automatic page refresh
Create a paginated report
Create a PivotTable from a Power BI dataset in Excel
Create Dashboards:
Set mobile view
Manage tiles on a dashboard
Configure data alerts
Use the Q&A feature
Add a dashboard theme
Pin a live report page to a dashboard
Manage Datasets:
Configure a dataset scheduled refresh
Configure row-level security group membership
Provide access to datasets
nd
Flat No: 208, 2 Floor, Annapurna Block,
Ameerpet, Hyderabad – 500038
+91-9985-177-188
+91-9985-177-188
info@[Link]
/kalyanithub /kalyanit [Link]
/kalyanithub #kalyanithub
Configure incremental refresh settings
Promote or certify Power BI datasets
Identify downstream dataset dependencies
Configure large dataset format
nd
Flat No: 208, 2 Floor, Annapurna Block,
Ameerpet, Hyderabad – 500038
+91-9985-177-188
+91-9985-177-188
info@[Link]
/kalyanithub /kalyanit [Link]
/kalyanithub #kalyanithub
SQL
Introduction to SQL:
Introduction
Work with Schemas
Explore the structure of SQL Statements
Examine the SELECT statements
Work with data types
Handle NULLs
Sort and filter results in SQL:
Sort your results
Limit the sorted results
Page results
Remove duplicates
Filter data with predicates
Combine multiple tables with JOINs in SQL
Understand joins concepts and syntax
Use Inner joins
Use Outer joins
Use Cross joins
Use Self joins
Write Subqueries in SQL
Understand Subqueries
Use scalar or multi-valued subqueries
Use self-contained or correlated subqueries
Use built-in functions and GROUP BY in SQL
Categorize built-in functions
Use aggregate functions - AVG SUM MIN MAX COUNT
Use Mathematical functions - ABS, COS/SIN, ROUND RAND
Use Ranking functions - RANK, DENDE-RANK
Use Analytical function - LAG, LAST_VALUE, LEAD, PERCENTILE_CONT, PERCENTILE_DISC,
PERCENT_RANK
nd
Flat No: 208, 2 Floor, Annapurna Block,
Ameerpet, Hyderabad – 500038
+91-9985-177-188
+91-9985-177-188
info@[Link]
/kalyanithub /kalyanit [Link]
/kalyanithub #kalyanithub
Use Logical functions - CHOOSE, GREATEST, LEAST
Summarize data with GROUP BY
Filter groups with HAVING
Modify data with SQL
Insert data
Generate automatic values
Update data
Delete data
Merge data based on multiple tables
Stored Procedure:
Stored procedures, Create, Modify, Delete, Execute, Specify parameters
Indexes:
Heaps (Tables without Clustered Indexes)
Clustered & Non-clustered Indexes
Columnstore indexes
nd
Flat No: 208, 2 Floor, Annapurna Block,
Ameerpet, Hyderabad – 500038
+91-9985-177-188
+91-9985-177-188
info@[Link]
/kalyanithub /kalyanit [Link]
/kalyanithub #kalyanithub
PYTHON
Introduction to Python
Setting up python on your computer
Why python is important for non-IT Professional
Running python code using an IDE or a text editor
Installing and setting up python
Writing your very first program in python
Printing Hello World
Operators and Expressions
Slicing
Negative slicing
Using step in slicing
Slicing backwards
Strings
String operators
String formatting
Program Flow control in Python
if statement
elif
for loop
continue and break
while loop
List and Tuples
mutable vs Immutable objects
List
Sorting a list
Removing items from list
Replacing items in list
What are tuples
Performing basic functions to a tuple
Dictionary and Sets
Functions
Defining a function
Parameters and arguments
Returning values
Docstring
nd
Flat No: 208, 2 Floor, Annapurna Block,
Ameerpet, Hyderabad – 500038
+91-9985-177-188
+91-9985-177-188
info@[Link]
/kalyanithub /kalyanit [Link]
/kalyanithub #kalyanithub
*args
Input and Output in python
Reading and writing to a text file
Appending to a file
Object persistence using shelve
Object oriented programming
Exception handling in python
Using Database in python
Generators, Decorators and lambda expression
API
Business Analyst & Data Analyst Roles & Responsibilities
Real-Time Scenarios
Real-Time Projects
Experienced Level Resume Preparation Support
Placement Assistance
Multiple Capstone Projects will be covered in this course
Hands-on Exercises in Every concept
