Panipat Institute of Engineering
& Technology
In Collaboration with IMS Proschool Pvt. Ltd.
Analy cs
PROGRAM HIGHLIGHTS
+ Python
Learn from Delivered using Course comple on
experienced case Study Based cer ficate by NSDC
Industry experts Methodology & Skill India
FOR REGISTRATION SCAN
BELOW QR CODE
ELIGIBILITY
Students of B.Tech, BBA, BCA,
B.Com. MBA
DURATION
100 HRS
3 Elements of
Analy cs
› Data Handling with Excel, Python & SQL
› Data Analysis with sta s cs
› Data Visualiza on with Tableau & PowerBI
Companies need people who
› Are able to do basic data pre-processing
› Are able to apply Sta s cal methods to data
› Are able to visualize findings & tell a story
Who should do this course?
Anyone who wants to
› Start a career in Analy cs
› Understand how to analyze data
› Use Analy cal & Visualiza on tools
Hiring Companies
Curriculum 100 Hours
Module 1 Module 2
Business applica on of sta s cs Introduc on to Machine
› Different types of data Learning using Linear Regression
› Frequency Table
› Simple Linear Regression
› Histogram
› Mul ple Linear Regression
› Measures of central tendency and dispersion
› Op miza on using Gradient Descent
› Skewness and kurtosis
› Basic Probability, Condi onal Probability
Module 4
› Popula on and Sampling
› Probability Distribu on Visualiza on with Tableau & Python
› Understanding Hypothesis Tes n
› Hypothesis Tests › Introduc on to Tableau and Power BI
› Hypothesis with Z-test › Difference between Tableau and Power BI
› Extrac on data into Tableau and Power BI
› Data Prepara on, connec ng with data, dimensions
Module 3 & measures.
Module
SQL 3 - SQL › Types of Visualiza on in Tableau, Power BI
› Introducing to SQL, SQL Syntax, SQL data types, › Visual Analy cs, Tableau Bin, Gio Map, LOD
SQL operators › Crea ng Views, Working with charts, and Expor ng
› Table crea on in SQL - Create, Insert, Drop, Visualiza ons.
Delete Update, Table Access and Manipula on › Dashboard, Storytelling, Projects
› Select with Where Clause
› Joins
Module 6
Module 5 Excel
› Create, Format, Insert New Worksheet
Python
› Insert and delete Row and Column into a
› Introduc on to python worksheet
› Basic Python, Variables, Variables › Create and use named range
Assignments, Strigs, List, List Stack, › Working with data - Average, Count, Sum
Dic onary, Tuples › Modify data
› Operators, Condi onal Statements, Loops
› Func ons and Methods
› Libraries in Python-Pandas, Scikit Learn,
NumPy, Matplotlib.
› Reading and wri ng files
› Projects