Certification Course Python & SQL MasterClass by CA Shubhangi Jain

Session Plan

What is Business Analytics
Types of Business Analytics
Tools to Analyse Data
Logistics to get started

Introduction to Python
Data Types in Python
Data Structures in Python

Hands-on Descriptive Analytics using Python
Pandas: Concat v/s Merge

What is Machine Learning
Types of Machine Learning
Steps in Classification Model
Hands-on: Outlier Treatment, Feature Selection
Case study

Designing Effective Dashboards - Best Practices
Variable Types
Hands-on: Conversion of variable types, Feature Scaling
Hands-on: Model Prediction, Model Accuracy Measurement
Overfitting v/s Underfitting

Introduction to SQL
SQL Joins
SQL Aggregate and Window Functions
Hands: Descriptive Analytics using SQL

How to create Power Pivot in Excel
Hands-on: Descriptive Analytics using Power Pivot

MCQs Based Exam Online - Practical Exam based on Course Module

Meet Your Instructor

CA Shubhangi Jain

CA Shubhangi Jain - is a graduate from SRCC, Chartered Accountant and Chartered Financial Analyst. With over 5 years of experience, Shubhangi has handled analytics assignments in multiple big consulting organizations involving intensive data analytics and model building to provide practical and focused business decisions. Her consultancy experience spans across diverse industries.