# Introduction to Analytics

As a Digital Marketing professional you would need to analyse a lot of data to assess your strategy’s success and Excel is the go to tool for most of these tasks. In this course, you will learn data manipulation, data cleaning, data mapping, exploratory data analysis and data modelling using Excel. This course will be ideal if you're looking to master the basics of analytics within a short period of time.

# Why you should do this?

• To develop a better grasp over data and use it efficiently to make better marketing decisions
• If you're already dealing with data in spreadsheets at work and want to learn advanced Excel capabilities

## Skills you will gain

• Data Manipulation
• Data Cleaning
• Data Mapping
• Data Visualization
• Exploratory Data Analysis
• Hypothesis Testing
• Linear Regression
• Excel
• Storyboarding
• Tableau

# Course syllabus

Module 1

## Introduction to Analytics

1:00 hr

• Course Overview
• Applications of Analytics

Module 2

## Data Wrangling using Excel

2:50 hr

• Data Manipulation
• Basic functions, If-else, date functions, table, filter, Sort, Border, useful shortcuts to all the functions
• Data Cleaning
• Concatenate, left, right, mid, trim, uppercase, lowercase, find, search, Len, replace, and, or, char, substitute, conditional formatting
• Data Mapping
• V-lookup, H-lookup, Index-Match, offset, named ranges, dropdowns, radio buttons

Module 3

## Exploratory Data Analysis using Excel

2:00 hr

• Aggregating data using Pivot
• Calculated Fields
• Data Visualization
• Box Plot, Bar Plot, Pie Chart, Line chart, Scatter plot, Histograms, Pivot Charts
• Slicers
• Case Study: EDA using Excel

Module 4

## Statistics with Excel

6:00 hr

• Descriptive Statistics
• Sample, Population
• Measures of central tendency
• Measures of dispersion
• Central limit Theorem
• Hypothesis Testing
• Test of proportion, Test of means
• T-testing- one sample, two sample, paired t tests
• Type 1 and type 2 error
• Correlation and Covariance
• Case Study: Decision making using advanced excel

Module 5

## Data Modeling using Excel

2:00 hr

• Linear Regression
• Case study: Modeling using Excel

Module 6

## Data Visualization using Tableau

2:50 hr

• Basic Charts and Reports
• Dimensions and Measures
• Dashboard design and techniques
• Storyboarding
• Case study: Dashboard designing using Tableau

# Course certificate

Get certificate from Great learning which you can share in the Certifications section of your LinkedIn profile, on printed resumes, CVs, or other documents.

# FAQ's

### How does this course work?

The course is in a Self-Paced learning environment. So the candidates are expected to go through the online videos and are expected to learn concepts at their own convenient learning time.

### What is the duration of the program?

Total program duration is 6 weeks. Out of which, 4 weeks of content & 2 weeks of project work. However, the candidates will get 8 weeks to finish the course, in order to earn the certificate.

### How long would the course content be available?

All candidates would have access to the course content of the program for 3 years from the date of their enrollment in the course.

### I do not have Microsoft Excel license, what should I do?

The candidate needs to have Microsoft Excel installed in their Laptop or Desktop as a pre-requisite for taking this course.

### I saw tableau in the curriculum, will I get tableau license to do this course?

The candidate will be working on the Tableau Public platform. So for that, there is no requirement for having a license.

### Is my course work evaluated?

The Project work at the end of the course will be evaluated, post satisfactory completion of it. You would be entitled to a certificate of completion for this program.