Applied Statistics for Analytics using Excel



Duration: 2 months

Price: CAD 500

Program Overview

Statistics is a critical element in successful decision making that all analysts and managers should master to be a successful professional. Our program aims to create a solid understanding of how statistics works and its relevance in various business contexts using a simple yet powerful tool like Excel. We use a unique KPI based approach to help you quickly connect with the application of statistics from a practical perspective instead of focusing on the formulae alone. The course will make you appreciate statistics, help you use the core principles and apply them to your business problems right after the course completion. This course will serve as an ideal foundation for those aspiring to become top analytics professionals.

Course Coverage

Thinking in Analytics

– Ace our proprietary learning techniques (TiA) to understand how to find hidden patterns in data. The approach is scalable and highly recommended for professionals interested in analytics consulting.

Probability

– Understand how to apply the basic concepts of probability using a simple case study on how a retail store decides to give combo offers.

Descriptive Statistics

–Experience our amazing KPI based learning approach where we articulate the reasons behind the formulation of critical concepts in statistics.

Hypothesis Tests

– Learn to convert your business problem into a statistical framework and evaluate them to take scientific decisions with well defined confidence levels.

Statistical Tests

–Understand the appropriateness of tests like T-test, F-test and Chi-Square and implement the same using Excel

ANOVA

– Understand the key statistical terminologies like ANOVA, repeated measures, correlation and regression and move ahead confidently in your analytics journey.

Trainer Profile

Srikanth Balasubramanian has about 14 years of experience in training, consulting and software. He is a corporate trainer and an analytics consultant for Fortune 500 and MNC firms like VISA, Credit Suisse, Cisco, Honeywell, NXP, Metro, KPMG, PWC Analytics Advisory, Skoruz & Brillio technologies. He also has an extensive Machine Learning and Data Analytics consulting experience with SME firms like Merit Group and RVS Group, where he helped them set up new lines of business based on analytics despite constrained budgets and resources. He has a strong understanding of issues in analytics in the retail, marketing, and finance areas and hasend-to-end capabilities to link analytical models to business goals and outcomes. He works closely with mid-career and senior folks in MNCs around the globe; Canada, USA, Singapore, Hong Kong, and India.

Program Details

  • Weekday Sessions (In-class or Live Online)
  • Introductory Fee: CAD 500 plus any applicable taxes
  • Course start dates [Nov 5, Nov 26, Dec 13, Dec 27]
  • Venue: SDL,5200 Dixie Rd #114, Mississauga, ON L4W 1E3 [LIVE ONLINE also available]

Early Registration Benefits

  • Free Implementation of Key statistical concepts in R and Python
  • Unlimited course access (Live online sessions) for a life time.

Refund Policy

  • 100 % Refunds less $25 administration charges for cancellations until the program start date.
  • No refunds after the program start date.
Ask an expert