INTRODUCTION

• Getting Started

• Why Python?

• Installing Python

• IDLE

• Running First Python Programs

PYTHON BASICS

• Keywords and Identifiers

• Python Variables

• Statements & Comments

• Basic Data Types (Numbers, Strings, Booleans)

• Python Type Conversion

• Python Operators

PYTHON FLOW CONTROL

• Python if…else

  • Simple if statement

  • If else statement

  • Elif statement

  • Nested if statement

• Python for Loop

• Python while Loop

• Python break and continue

• Python Pass

PYTHON COLLECTION

• Python List

• Python Tuple

• Python String

• Python Set

• Python Dictionary

PYTHON FUNCTIONS

• Python Functions

  • Built-in

  • User-defined

• Scope of Variable

• Function Argument

• Python Recursion

• Anonymous Function (Lambda)

• Python Global Keyword

PYTHON MODULES

• Modules

• User Defined Modules

• Built-in Modules

• OS Module

• Math Module

• Random Module

• Date Time Module

FILE AND EXCEPTION HANDLING

• Python File Handling

  • Writing Data to File

  • Reading Data from File

• Python Exception

• Python Exception Handling

• Python User-defined Exception

PYTHON OBJECT & CLASS

• Python OOP

• Python Class

• Python Inheritance

• Multiple Inheritance

• Operator Overloading

• Polymorphism

• Encapsulation

MYSQL INTRODUCTION

• What is MYSQL

• MySQL History

• MySQL Features

• MySQL Data Types

• Install MySQL

MYSQL DATABASE

• Create Database

• Select Database

• Drop Database

MYSQL TABLE

• CREATE Table

• ALTER Table

• TRUNCATE Table

• DROP Table

• MySQL Views

MYSQL CLAUSES

• MySQL WHERE

• MySQL DISTINCT

• MySQL FROM

• MySQL ORDER BY

• MySQL GROUP BY

• MySQL HAVING

MYSQL QUERIES

• MySQL Queries

• INSERT Record

• UPDATE Record

• DELETE Record

• SELECT Record

MYSQL CONDITIONS

• MySQL AND

• MySQL OR

• MySQL AND OR

• MySQL LIKE

• MySQL IN

• MySQL NOT

MYSQL JOIN

• MySQL JOIN

AGGREGATE FUNCTIONS

• MySQL count()

• MySQL sum()

• MySQL avg()

• MySQL min()

• MySQL max()

OTHER MYSQL TOPICS

• MySQL IS NULL

• MySQL IS NOT NULL

• MySQL BETWEEN

MYSQL STRING FUNCTIONS

• MySQL String

MYSQL DATE/TIME FUNCTIONS

• MySQL Date/Time

MYSQL MATH FUNCTIONS

• MySQL Math

• Math SQRT() function

• Math SUM() function

• Math LOG() function

• Math LOG2() function

• Math MAX() function

• Math MIN() function

• Math MOD() function

• Math PI() function

• Math POWER() function

• Math POW() function

• Math RADIANS() function

• Math RAND() function

• Math ROUND() function

NUMPY

• Fundamentals of NumPy

• Types of arrays in NumPy

ARRAY CREATION

• Ones

• Empty

• Zeros

• Create Random Array

RESHAPING

• 1-D to 2-D array

• 2-D to 3-D array

• 3-D to 1-D array

OPERATIONS

• Arithmetic operations on Array

  • Addition

  • Subtraction

  • Multiplication

  • Exponential

SLICING

• How to slice array

• Change in properties during slicing

MATRIX

• Transpose of a matrix

  • How to take transpose

  • Rows and columns while taking transpose

• Dot product of the matrix

  • How to take Dot product of the Matrix

DATAFRAME

• What is Pandas Dataframe

• Different ways to create a Dataframe

• Read data from different sources and convert them to the Dataframe

SERIES

• What is panda Series

• How to create a Panda Series

DATA INSPECTION

• Using Count, info, head, tail

• Using Shape, describe, unique, value

DATA SLICING

• Data Slicing loc and iloc

DATAFRAME OPERATIONS

• How to create a column or row

• How to delete a column or row

OPERATIONS ON ROWS & COLUMNS

• Drop

• Rename

• Replace

ARITHMETIC OPERATIONS

• Min

• Max

• Sum

• Mean

• Count

DATA CLEANING

• Handle Duplicate value and Null value

• Drop Duplicates

• NaN values

OUTLIERS

• Handle outlier data

  • Dropping the outliers

ADVANCED

• Group by Operations

• Data Reshaping

• Merging, Joining, Concatenation and append

• Time series

MATPLOTLIB

• Matplotlib for 3-D visualization

• Bar

• Pie

• Line

• Histogram

• Countplot

• Boxplot

• Heatmap

STATISTICS

• Scalar and vector

• Introduction to linear algebra

• Measure of central tendency mean

• Measure of central tendency mode

• Measure of central tendency mode

• Variance

• Standard deviation

• Measure of shape skewness

• Measure of shape kurtosis

• Covariance and correlation

PROBABILITY

• Importance of probability

• Discrete and continuous variable

• Bayes Theorem

• Central Limit theorem

• Normal Distribution

• Bernoulli distribution

• Uniform Distribution

LINEAR REGRESSION

• Types of variables

• Types of Linear variables

• Mathematics Behind it

• Implementation of the model

• Testing and Check Performance of the model

• Assumptions of the Linear Regression

POLYNOMIAL REGRESSION

• Need of polynomial Regression

• Types of Variables in the Polynomial regression

• Mathematics behind it

• Implementation of the model

• Testing and check performance of the model

MULTIPLE REGRESSION

• Need of multiple Regression

• Mathematics behind it

• Implementation of the model

• Testing and check performance of the model

INTRODUCTION TO POWER BI

• Overview of BI concepts

• Why we need BI?

• Introduction to SSBI

• SSBI Tools

• Why Power BI?

• What is Power BI?

• Building Blocks of Power BI

• Getting started with Power BI Desktop

• Get Power BI Tools

• Introduction to Tools and Terminology

• Dashboard in Minutes

• Refreshing Power BI Service Data

• Interacting with your Dashboards

• Sharing Dashboards and Reports

POWER BI DESKTOP

• Power BI Desktop

• Extracting data from various sources

• Workspaces in Power BI

DATA TRANSFORMATION

• Data Transformation

• Measures and Calculated Columns

• Query Editor

DATA ANALYSIS EXPRESSIONS (DAX)

• What is DAX?

• Data Types in DAX

• Calculation Types

• Syntax, Functions, Context Options

• DAX Functions

Types of Functions

• Date and Time

• Time Intelligence

• Information

• Logical or Mathematical

• Statistical

• Text and Aggregate

Advanced DAX

• Measures in DAX

• ROW Context and Filter Context in DAX

• Operators in DAX – Real-time Usage

• Quick Measures in DAX – Auto validations

• PowerPivot xVelocity & Vertipaq Store

• In-Memory Processing: DAX Performance

MODELLING WITH POWER BI

• Introduction to Modelling

• Optimize Data Models

• Setup and Manage Relationships

• Cardinality and Cross Filtering

• Default Summarization & Sort by

• Creating Calculated Columns

• Creating Measures & Quick Measures

POWER BI VISUALISATIONS

Basics

• How to use Visual in Power BI?

• What Are Custom Visuals?

• Creating Visualisations and Colour

• Formatting

• Setting Sort Order

Charts & Visuals

• Scatter & Bubble Charts & Play Axis

• Tables, Matrices & Conditional Formatting

• KPI’s, Cards & Gauges

• Map Visualizations

Filters & Interaction

• Tooltips and Slicers

• Timeline Slicers & Sync Slicers

• Cross Filtering and Highlighting

• Visual, Page and Report Level Filters

Advanced Features

• Drill Down/Up

• Hierarchies and Reference/Constant Lines

• Custom Visuals

• Managing and Arranging

• Drill through and Custom Report Themes

• Grouping and Binning and Selection Pane

• Bookmarks & Buttons

• Data Binding and Power BI Report Server

POWER BI Q&A & DATA INSIGHTS

• Why Dashboard? and Dashboard vs Reports

• Creating Dashboards

• Configuring a Dashboard (Dashboard Tiles, Pinning Tiles)

• Power BI Q&A

• Quick Insights in Power BI

• Power BI Embedded and REST API

DIRECT CONNECTIVITY

• Custom Data Gateways

• Exploring live connections to data with Power BI

• Connecting directly to:

  • SQL Azure

  • HD Spark

  • SQL Server Analysis Services

  • MySQL

• Introduction to Power BI Development API

• Excel with Power BI

  • Connect Excel to Power BI

  • Power BI Publisher for Excel

• Content packs

• Update content packs

PUBLISHING AND SHARING

• Introduction and Sharing Options

• Overview

• Publish from Power BI Desktop

• Publish to Web

Sharing

• Share Dashboard with Power BI Service

• Workspaces and Apps (Power BI Pro)

• Content Packs (Power BI Pro)

Export & Security

• Print or Save as PDF

• Row Level Security (Power BI Pro)

• Export Data from a Visualization

• Publishing for Mobile Apps

• Export to PowerPoint

• Sharing Options Summary

REFRESHING DATASETS

• Understanding Data Refresh

• Personal Gateway (Power BI Pro and 64-bit Windows)

• Replacing a Dataset and Troubleshooting Refreshing

INTRODUCTION TO EXCEL

• What is Excel

• Why to use Excel

• Introduction of Spreadsheet

FORMATTING & PROOFING

• Font

• Alignment

• Number

• Border

MATHEMATICAL FUNCTIONS

Basic Functions

• Sum

• Average

• Countnumber

• Max

• Min

• Absolute

Counting Functions

• Count

• Counta

• Countblank

• Countif

• Countifs

Conditional Functions

• Sum

• Sumif

• Averageif

• Averageifs

TEMPLATES IN EXCEL

• Templates usage

SECURITY IN EXCEL

• File-level protection

• Workbook level protection

• Worksheet level protection

ADVANCE PASTE TECHNIQUE

• Paste formulas

• Paste formats

• Paste validation

TEXT FUNCTIONS

• Upper

• Lower

• Proper

• Left

• Mid

• Right

• Trim

• Len

• Concatenate

• Find

• Substitute

DATE & TIME FUNCTIONS

• Today

• Now

• Day

• Month

• Year

• Date

• Date if

• Date Add

• EOMonth

• Weekday

FILTERING

• Filter

• Advance Filter

SORTING

• Sorting

• Advance Sorting

SHORTCUTS

• Various Shortcuts

CONDITIONAL FORMATTING

• Conditional Formatting

OFFSET FUNCTION

• Offset Function combined with Sum or Average

ARRAY FORMULAS

• Array Formulas

EXCEL TABLES

• Excel Table and their use

DATA VALIDATION

• Number validation

• Date and time validation

• Text and list validation

• Custom validation based on formula

• Dynamic dropdown list creation

CONSOLIDATION

• Consolidation

WHAT-IF ANALYSIS

• Goal Seek

• Scenario Analysis

• Data Table

LOGICAL FUNCTIONS

• If function

• Nested if function

• Complex if and/or function

LOOKUP FUNCTIONS

• Vlookup

• Hlookup

• Index and Match

PIVOT TABLE

• Pivot Table in Excel

GROUPING

• Group

• Ungroup

• Subtotals

CHARTS & SHAPES

• Chart in Excel

• Shape in Excel

MACROS

• Macros