Diploma in Data Analysis

Do the Diploma in Data Analysis

Diploma in Data Analysis

Category:

Professional Courses/

₹0.00

Data Analysis vector colorful modern banner

Price ₹0.00

Duration: 5 Months

Course Fee: 24500/-

Lectures: 60

Certificate of Completion

Download Curriculum

CURRICULUM

Module 1

Introduction to MS Excel, Quick review on MS Excel Options, Ribbon, Sheets and

Difference between Excel 2003, 2007, 2010 and 2013

Saving Excel File as PDF, CSV and Older versions

Using Excel Shortcuts with Full List of Shortcuts

Copy, Cut, Paste, Hide, Unhide, and Link the Data in Rows, Columns and Sheet

Using Paste Special Options

Formatting Cells, Rows, Columns and Sheets

Protecting & Unprotecting Cells, Rows, Columns and Sheets with or without Password

Page Layout and Printer Properties

Inserting Pictures and other objects in Worksheets

Lookup and Reference Functions: VLOOKUP, HLOOKUP, INDEX, MATCH, etc

Logical Function: IF / ELSE, AND, OR, NOT, TRUE, NESTED IF/ELSE etc

Database Functions

Date and Time Functions: DATE, DATEVALUE, DAY, DAY360, SECOND, MINUTES, HOURS, NOW, TODAY, MONTH, YEAR, YEARFRAC, TIME, WEEKDAY, WORKDAY etc

Information Functions :

Math and Trigonometry Functions: RAND, ROUND, CEILING, FLOOR, INT, LCM, MOD, EVEN, SUMIF, SUMIFS etc

Statistical Functions: AVEDEV, AVERAGE, AVERAGEA, AVERAGEIF, COUNT, COUNTA, COUNTBLANK, COUNTIF,FORECAST, MAX, MAXA,MIN, MINA, STDEVA etc

Text Functions: LEFT, RIGHT, TEXT, TRIM, MID, LOWER, UPPER, PROPER, REPLACE, REPT, FIND, SEARCH, SUBSTITUTE, TRIM, TRUNC, CONVERT, CONCATENATE, DOLLAR etc

And More

Using Conditional Formatting

Using Conditional Formatting with Multiple Cell Rules

Using Color Scales and Icon Sets in Conditional Formatting

Creating New Rules and Managing Existing Rules

Sorting Data A-Z and Z-A

Using Filters to Sort Data

Advance Filtering Options

Creating Pivot Tables

Using Pivot Table Options

Changing and Updating Data Range

Formatting Pivot Table and Making Dynamic Pivot Tables

Creating Pivot Charts

Types of Pivot Charts and Their Usage

Formatting Pivot Charts and Making Dynamic Pivot Charts

Advanced Filtering

Data validation

Consolidation

Groups

Subtotal

What is Excel Macro ?

How to Record / Run Excel Macro ?

How Add Developer’s Tab in Excel 2007 / 2010

How to add different types of controls like Text Box, Radio button, button etc. in Excel

Module 2

Mathematical Function (Using Case Studies)

Logical Function (Using Case Studies)

Text Function (Using Case Studies)

Flash Fill (Using Case Studies)

Data Lock & Protection

Area Charts

Surface Charts

Trend line Charts

Candle Stick Charts

Pie Charts

XY (Scatter Charts)

Time Series Charts

Bubble Charts

Radar Charts

Doughnut Charts

Rotating 3D Excel Charts

More Case Studies

Add-On Tools (Analytical Tools)

Basic Python

Introduction to Python

Python - The Universal Language

Installing Python

Python - *Hello World*

Using the Interpreter

iPython - a better Python interpreter

Types - Dynamic v/s Static Typing - tstrong v/s Weak Typing

Numbers

Strings

Unicode

Complex Types

Operators - Operator Overloading

Variables

Scopping And Expressions

Use of tabs and whitespaces as indent

Conditionals - for...else

The general syntax

Default values for arguments

Returning and receiving multiple values

Variable number of arguments - args, kwargs

Scope revisited

Primitive v/s Composite Types

Lists

Tuples

Maps (or Dictionaries)

Sets

Enums

Looping Techniques

Data Analysis with Python

Installing Anaconda and Jupyter Notebook

Jupyter Notebook overview

Importing data from a csv, text file or another database

Overview of various methods and attributes of Numpy

Array

Creating 1 dimensional arrays

Creating 2 dimensional arrays

Array indexing

Accessing array elements

Concatenating Numpy arrays

Arithmetic operations with arrays

Covariance

Correlation

Linear Regression

Overview of various methods and attributes of Pandas

Introduction

Working with various Series attributes

Introduction

Pivoting

Sorting

Aggregation

Descriptive statistical analysis with Pandas

Introduction to Matplotlib

Various Matplotlib methods

Creating Line, Scatter, Bar, etc. charts

Customising charts using: X and Y labels, Limits, Ticks, Legends

Introduction to Pyplot

R Programming

R–OVERVIEW

R – ENVIRONMENT SETUP

R - BASIC SYNTAX

R – DATA TYPES

R – VARIABLES

R – OPERATORS

R – DECISION MAKING

R – LOOPS

R – FUNCTION

R – STRINGS

R – LISTS

13.R – MATRICES

R – ARRAYS

R – FACTORS

R – DATA FRAMES

R – PACKAGES

R – DATA RESHAPING Melt

The Data

R – CSV FILES

R – EXCEL FILE Input as xlsx

File

R – BINARY FILES

R – XML FILES

R – JSON FILE

R – WEB DATA

R – DATABASES

R – PIE CHARTS

R – BAR CHARTS

R – BOXPLOTS

R – HISTOGRAMS

R – LINE GRAPHS

R – SCATTERPLOTS

R – MEAN, MEDIAN & MODE

R – LINEAR REGRESSION

R – MULTIPLE REGRESSION

R – LOGISTIC REGRESSION

R – NORMAL DISTRIBUTION

R – BINOMIAL DISTRIBUTION

R – POISSON REGRESSION

R – ANALYSIS OF

COVARIANCE

R – TIME SERIES ANALYSIS

R – NONLINEAR LEAST

SQUARE

R – DECISION TREE

R – RANDOM FOREST

R – SURVIVAL ANALYSIS

R – CHI SQUARE TEST

SQL

Introduction

Creating New Tables

SQL SELECT Statements

Manipulating Data(Insert, Delete, Update)

Distinct, Order By, Join clauses and Aggregate Functions

Using Primary keys, Foreign keys

Get Data from Multiple Tables

Using DDL Statements

Restricting and Sorting Data

Using Single-row Functions

Conversion Functions

Conditional Expressions

Using the Group Functions

Subqueries to solve queries

Linking SQL file with Python

Accessing database

Description

Diploma in Data Analysis

The use of Excel & Python is widespread in the industry. They are very powerful data analysis tools and almost all big and small businesses use Excel in their day to day functioning. All business uses data analysis in excel and python.This is a diploma course in the use of Excel & python which is designed to give you a working knowledge of Excel with the aim of getting to use it for more advance topics in Business Statistics later.Any student can do the diploma in data analysis course in surat.

The course is designed keeping in mind two kinds of learners – those who have very little functional knowledge of Excel & Python and those who use Excel & Python regularly but at a peripheral level and wish to enhance their skills. In diploma in data analysis you will learn data analysis in excel and data analysis in python. What you learn in this course will give you a strong foundation in all the areas that support analytics and will help you to better position yourself for success within your organization.

You’ll develop skills and a perspective that will make you more productive faster and allow you to become a valuable asset to your organization. This course also provides a basis for going deeper into advanced investigative and computational methods, which you have an opportunity to explore in future courses of the Data Analytics by python and excel. With this Course you can easily build interactive tools for yourself or for less technical users that pull data from multiple sources and analyze it in the very familiar Excel environment. Once the structure is set up, it is really useful to put all your complex logic and data analysis in the python file and harness all the tools available in the python ecosystem. I hope that once you start to play with this, you will find lots of opportunities to use this approach to bring python solutions to some of your less technical users who are stuck using Excel as their only tool for data analysis.

Roles and Responsibilities of a Data Analyst:

1) Collect data from various sources

2) Organize the data that holds value

3) Generate & present detailed reports

4) Look for patterns, correlations, trends

5) Provide ideas for process improvement

Why to go for a Diploma in Data Analysis Certification?

Data analysis is a fast growing field, and as more and more companies are recognizing the need to implement data analytics into their daily operations, more positions in this industry are opening up.

Reasons to get into data analytics:

1) High demand for analytics professionals

2) Huge Job Opportunities & Meeting the Skill Gap

3) Big data analytics is a top priority in a lot of organizations

4) Flexibility of working in any sector

5) Structured learning approach

6) Multiple Specializations