Analytics for All: Beginners to Experts

Learn Analytics from scratch- Ace Excel, cluster and factor analysis, linear and logistic regression, R and SAS.
3.9 (553 ratings) Instead of using a simple lifetime average, Udemy calculates a
course's star rating by considering a number of different factors
such as the number of ratings, the age of ratings, and the
likelihood of fraudulent ratings.
8,663 students enrolled Bestselling in Data Analytics
87% off
Take This Course
  • Lectures 244
  • Length 23 hours
  • Skill Level All Levels
  • Languages English
  • Includes Lifetime access
    30 day money back guarantee!
    Available on iOS and Android
    Certificate of Completion
Wishlisted Wishlist

How taking a course works


Find online courses made by experts from around the world.


Take your courses with you and learn anywhere, anytime.


Learn and practice real-world skills and achieve your goals.

About This Course

Published 10/2013 English

Course Description

Analytics is a huge and steadily growing industry. There is so much that can be done with the enormous amount of data available to us. The big data and analytics market will reach $125 billion worldwide in 2015, according to IDC. Ready to get on the bandwagon?

How do I increase my page’s Facebook likes? How do I know if blue or green would be good for my company’s logo? Which of the 10 methods would be most cost effective? Let analytics answer your questions and help you make data-backed, strategic and quicker decisions.

Whether you’re new to the field and want to tip toe into analytics or you’ve taken the big dive and are ready to immerse yourself in the subject, this course is for you!

Acquire a deep understanding of analytics and the tools and techniques involved.

Our content is periodically updated to make sure we give you the best. Our course material is designed in a way to ensure that you’re gripped right from the basics. Become an expert in 8 weeks! We don’t just give you 143 lectures and 23+ hours of content,we provide you lifetime access to all the material to accommodate your busy work schedule.

Additionally, you can get all your questions answered on our discussion forum and find examples and solutions uploaded by us and other students. Stay connected with your professors and peers 24*7!

Analytics propels clarity and innovative thinking. At ATI, we are committed to get your mind churning the right way.

What’s in it for you?

    ·Automate work using Excel

    ·Learn to create dashboards and make your data visually appealing

    ·Hypothesis testing: Make no assumptions

    ·Ace Linear and Logistic Regression

    ·Use Cluster and Factor analysis to find associations

    ·Master R and SAS.

    ·SQL Basics

    ·15 case studies and regular quizzes to gauge your understanding.

What after the course?

    ·Enter a Kaggle competition, get recognized and win $100,000 or more?

    ·Start your own company? Artificial intelligence maybe?

    ·Get your company acquired by the big players?

    ·Write for the Wall Street Journal?

There is so much you can do with analytics - from predicting who will win a political election to foreseeing the occurrence of an earthquake; it is a world of uncertainty that can be made certain.

Enroll now!

And oh, it doesn’t end here,

Use our Facebook page to interact with thousands of other students and professionals. Keep up with the market and network with like minds.

What are the requirements?

  • High school mathematics skills
  • Software: MS Excel, R and SAS must be installed in your system before you take up the course
  • Need to make a time frame for yourself to complete the course. As you learn at your own pace and convenience, you have to make your own deadlines and keep it
  • Start exciting discussions
  • Skype your queries to between 8.30AM to 5.30PM - IST or mail us - will respond to your queries within 24 Hrs

What am I going to get from this course?

  • By the end of this course Data won't be overwhelming anymore and you will be making great insights like a pro
  • Application! You will be be able to apply what you learn in multiple areas like HR, marketing, finance, sales, sports etc
  • You will be able to use advanced tools like R and SAS which are industry requirements in analytics
  • You will be able to build Predictive Models to like Logistic and Linear regression
  • You will be able to relate any concept with real life examples
  • You will get to interact with students and connect with instructors in our regular live sessions. If you have your own dataset you can use these sessions to help you skillfully maneuver your own data.

What is the target audience?

  • If your job throws out more data than you can handle today, this course is for you.
  • If your career is slowing down, and need a shift, analytics could be for you.
  • If you are keen on getting into the analytics industry as a fresher.
  • For people who don't have a strong knowledge of statistics, but feel it would help their job productivity.
  • Absolute beginners with no prior knowledge of Analytics
  • And those who have some prior knowledge.

What you get with this course?

Not for you? No problem.
30 day money back guarantee.

Forever yours.
Lifetime access.

Learn on the go.
Desktop, iOS and Android.

Get rewarded.
Certificate of completion.


Section 1: Agenda
Why Analytics and What you will learn
How to go about learning
6 pages

You can download the fast track guide from the downloads section


More Readings:

  1. How Marketing Analytics will make $100K for charity this year
  2. Big Data, Analytics, and the Future of Marketing & Sales
  3. Demand for analytics skills outstrips supply in all sectorss
  4. Most exciting Big Data Startups
  5. 8 ways Big Data and Analytics will Change Sports
  6. Analytics at Work
Section 2: The analytics learning kit
5 pages

All the required study material are available in the respective lectures and sections, but, if you want to take a look at all of it in one go :

3 pages

PLEASE NOTE: We do not provide any software.

This guide is for your information on how you can access the software.

ATI has no affiliation with SAS

After downloading the University Edition, please go through the supplementary material " Creating Library and Uploading Files"

2 pages

You can download the Guide ( pdf document) from the downloads section

Case Studies
Section 3: Simple speak: What is analytics?
What is analytics?

So what does analytics really mean?

We're not about to overload you with math you don't need. Just keep calm and keep learning! The rest, is on us.

And don't forget to download the pdf !


This Video explains about the natural examples of the patterns derived between a cause and effect relationship.

03:00 What are the sources of information Available with us
05:10 To get to the crux of analytics there are four fundamental concepts

This video talks about the tools and the usage case for Analytics in the real time scenario

00:00 Tools used for Data Mining
01:13 Universal applications - Regression and Clustering
03:00 Evolution of Analytics
06:50 Executing Analytics Projects
08:28 Techniques of Data Mining

To go through some more articles and understand how have different industries benefitted from analytics, please Click Here

Section 4: MS Excel: Offload your work
Why you need to know Excel
What you will Learn

MS Excel: Offload your work: Agenda

In this video we are will be finalizing the steps to reach our agenda.

The video starts with the screen overview and also explains some essential starting techniques.

Please download the attached reading material.

Are you ready to offload your work?
5 questions
Section 5: Data Cleaning
Why you need to know about Data cleaning
How you can clean Data
Customize a List - NEW VIDEO

Data Cleaning: Format Numbers

This video is one of the important video in the series:

We are learning the different types on number formatting in Excel here like:

Data formats, Currency formats, etc.

Please download the Employees Data and start working with us


Data Cleaning: Coloring cells the smarter way

Have you been coloring cells the historical way? Here is a video that can help us save tremendous amount of time in coloring and highlighting the insightful data. and also helps us save time from redoing it again.

Download the Data below and start working together.

Please download the attached material for your reference.


Data Cleaning: Going beyond a simple paste

In Excel, when we copy, there are too many features that gets copied , example - Value of the cell, boder, color, font color, formula, etc.

But at the time of pasting we might want to paste only one required feature.

The video explains how can we use the option "Paste Special" in excel to do this.

Please download the attached material.


Data Cleaning: Going beyond a simple Find

This video takes us beyond a very popular concept of "CTRL + F"

Use a blank sheet to work with is, no specific data needed.

Please download the attached material.


Learn how to make use of Text to Columns and various other tips/concepts to make your data understandable.

How well have you understood Data Cleaning
4 questions
3 pages

Data Cleaning: Case Study

Do cross check your learning on the concepts by successfully solving the case study. download the data from the panel on your right and start solving.

All the very best !!!

Section 6: Organizing data in Excel
Organizing data in excel
How to organize data in Excel

Organizing data in Excel: using Shortcuts

This is a sample video on a few shortcuts in Excel and displays the trick to use shortcuts even without memorizing them by heart.

No specific data needed to work with this video so you can open a blank spreadsheet and continue working with us in the video.


Organizing data in Excel: Sorting and Filtering

This video will explain about the best practices from data arrangement. and Talks about the difference in sorting and filtering as well. Do look for quick shortcuts to the same here.

Download the Employee data given below to start off with the video.


Organizing data in Excel: Deciding what others Enter

We all know the problems and discrepancies in entering of the data by different people. the best way is to restrict them to type the way we need it. Data validation talks about the same in this video.

Please download the file and then continue with the video.


Organizing data in Excel: Creating Subtotals

This video is based on the concept of Subtotal, where we derive calculations on the data and present them within the data itself. (below the data mostly). very useful when we need to segment the data and take printouts.

Please download the attached material.


Organizing data in Excel: Consolidating Tables

Summary from a summary.

This is exactly what a Consolidate tool does.

If you have two cross tabs displaying similar information, and you need them to be clubbed together, do switch on the video once you download the given data, and we can start together then?

Please download the attached material.

How well have you understood Organizing Data
5 questions
Section 7: Using Excel as a decision tool
Using Excel as a decision tool
Goal Seek - NEW VIDEO

Using Excel as a decision tool: Solver Optimization

This video explains a tool - SOLVER that is available as an add in in Excel. it can do much more advanced than what a goal seek can do.

00:01 Explaining the question and selecting a Tool
01:30 where goal seek can go back and change one input,Solver can change multiple inputs at a time.
02:20 What are Add Ins and how do we install them
03:00 Explaining the need and Usage of Solver
13:02 Explaining the practice Question. (Download the practice data from the material below.
Data Table: Decision Table

Using Excel as a decision tool: What if Analysis

This video is an extension of What If Analysis , and explains how can we create tables automatically by just adding scenarios to scenario manager.

02:40 Scenario Manager Tool Explanation
07:40 Automatically created Table using Scenario Manager
Section 8: writing smart Functions in Excel
Writing smart functions in Excel
How Functions can help

writing smart Functions in Excel: Tricks

This video is to explain the symbols important to work with functions, and help you self suffice yourself to get any new function by yourself.

this shall be treated as the foundation of all the functions, based on which every function in excel works, and will help us understand any new functions by ourselves -easily.


writing smart Functions in Excel:Arguments

This video is a continuation of the last video and explains some trial usage of functions. some sample functions will also be displayed in this video.

00:01 how to identify optional Arguments and usage.
01:38 Absolute/ Fixed cell references (using $ Symbols)
03:20 to make dynamic(smarter) functions

writing smart Functions in Excel: Creating Templates from Summaries

This Video explains how do we create a summary of the data and then how do we convert it into a self learning template.

a self learning template is a kind of report which is generated one and automatically adopts itself on any changes made on the data

00:35 Creating Summary
01:40 Formula of summary to template conversion

Please download the Data for working with this video. you can continue with the same data for the next videos, untill we complete counting.


writing smart Functions in Excel: Count Functions

We start touching upon functions from this video. carrying an idea of learning various aspects of a function and be able to crack functions concept as a whole.

we are hereby starting with some counting functions used in summarizing data sets.

00:20 Logic comes from the historical ways of doing things (strange but true)
02:40 Thinking about the name of the functions
03:15 learning to Explore functions
04:25 CountA function ( difference between CountA and Count Function)
05:55 Popularly made mistakes while selecting a range in Excel
07:14 Correcting  the mistake by selecting a bigger range

writing smart Functions in Excel: Countif Functions

This video explains the practical usage of the functions in a correct manner and filling arguments step by step.

   00:01 COUNTIF Function to conditionally calculate the summary of the data based on values in the columns. 
   04:22 using COUNTIFS function  to work with multiple conditions at a time. 
   09:35 how to name ranges and whats  the usage of the same in functions 
   11:30 naming multiple columns at a   time using their headings as names 
   14:00 Creating charts to present the template 

writing smart Functions in Excel: Text functions

This video talks about some random data cleaning text functions. you don't need any specific data sets to be downloaded, just open up a blank sheet and start working on it with the video.

The presentation theory Material is under revamp and shall update it asap.

Section 9: Segmenting Data in Excel
Segmenting data in Excel preview
How to segment your Data

Segmenting Data in Excel: IF Functions

Before we can think of a summary, we need to divide the data into meaningful segments by using some logical functions.

basically to create categorical variables in the data.

Download the data to start with the video and replicate as when i explain.


Segmenting Data in Excel: Nested IF, AND and OR Functions

This video is a continuation of the logical functions itself where the advanced logical function is used.

Nested Ifs
Section 10: Why create reports the tedious way
Why create reports the tedious way?
10 pages

Why create reports the tedious way: Presentation on Pivots

This lecture introduces Pivot Table concept in excel to us, the next 4 videos are the implementations of this information. get the basic understanding from this video and continue to the next lecture to see the video.


Why create reports the tedious way: Introduction to Pivots

See how a Pivot table makes our life simpler by generating awesome reports in no time.

Download the data and lets start.


Why create reports the tedious way: Generating Pivot Reports

This video is a continuation of the previous video and talks further about generating reports. some more problems have been picked up in the video on report generation.


Why create reports the tedious way: Slicing the Report

In this video we specifically going to focus on data segmentation and slicing of the reports based on different criterias.


Why create reports the tedious way: Pivots on Dates

Lecture video explains the use of Group option in Pivot tables to make the report generation based on the time factor user friendly.

Section 11: Showcasing your data with Excel
Excel dashboards: Preview for the section Showcasing your data with Excel
13 pages

Showcasing your data with Excel: Presentation on Dashboard

How to create a Dashboard

Showcasing your data with Excel: Ways to Present

Starting from this lecture , we talk about presenting the information that we have.

the current video talks about some trial and error approaches that we follow.


Showcasing your data with Excel: Creating a template

A self learning template is a kind of information that keeps getting updated by itself and also accommodates the output based on changes in the requirement.


Showcasing your data with Excel: Making Templates Smarter

Using index and Match functions , you will notice how the output becomes smarter and smarter.

the standard step to making anything smarter is to:

identify constants and replacing them by variables

Showcasing your data with Excel: Creating Dashboard from Templates

In this video we are discussing how to create controllable charts.


Showcasing your data with Excel: using Controls

This video cements the concepts we have learnt and based on it creates a dynamic and well managed information dashboard which can be controlled from a single point.

Section 12: Case Study
Excel- Case study preview
6 pages

Showcasing your data with Excel: Case Study

Section 13: Advanced Excel (VBA & MACROS) - The A, B, Cs
Introduction to VBA Programming
Hierarchy as a vocabulary of the language
Communication among objects
Examples to justify the communication techniques
Introducing Intangible Hierarchy
Section 14: Grammar
Sentence creation : Connections in Excel
Rules of writing sentences in VBA
Section 15: Learn more with hands-on : Introducing the platform to write and automate
Introducing the platform : VBA window
Section 16: Small exercises to connect our learning so far
Applying Functions in VBA
Applying properties in VBA
Applying methods in VBA
Various ways of executing a Macro
Section 17: Implementation on a case study
Explaining case study for hands on learning
Understanding the IF statements
Converting constants to variables

Students Who Viewed This Course Also Viewed

  • Loading
  • Loading
  • Loading

Instructor Biography

ATI - Analytics Training Institute, Committed to creating a difference

We are an Analytics firm committed to developing intellectual property that will help individuals and their organisation take smarter decisions every day. ATI, the education arm of Redwood Associates has helped 200 companies and over 15000 individuals speak the language of DATA

The founder Gautam Munshi has nearly two decades of high performance analytics experience. His strong belief that anyone can become an analyst has led him to build a team of 12 - a group of math geeks, techies, musicians, comedians, beer enthusiasts, agriculturists, geneticists, teachers and bankers,who have the gumption that they can make a difference and truly believe that analytics can influence and make a huge impact on a day-day basis. It is this diverse lot that brings Analytics to the mind space of every individual. You can view their moments in the lime light here and follow them on Facebook

Ready to start learning?
Take This Course