INTRO TO ANALYTICS | A live online course with a Data Science Specialist at McKinsey & Company | ELVTR

LIVE ONLINE COURSE

INTRO TO ANALYTICS

Dates: 16 FEB 2023 - 21 MAR 2023
Duration: 5 WEEKS TUESDAYS & THURSDAYS 5 PM PST / 8 PM EST
UDIT MEHROTRA
MCKINSEY & COMPANY
lector photo

LIVE ONLINE COURSE

ENROLL
LIVE ONLINE COURSE ON FINDING CONNECTIONS IN DATA
Dates:
16 FEB 2023 - 21 MAR 2023
Duration:
5 WEEKS
TUESDAYS & THURSDAYS
5 PM PST / 8 PM EST

Learn to collect, explore, analyze, and present data like a pro, using industry tools like Excel and Python.

Join Udit Mehrotra, Data Science Specialist at McKinsey & Company, to dive into the world of data manipulation, analysis, and visualization.

 

THIS COURSE IS FOR YOU, IF…

  • YOU WANT TO TAKE YOUR ANALYTIC SKILLS TO THE NEXT LEVEL

     

    Discover the world of advanced data analytics and learn how to do more with your data. Explore how predictive analytics, data visualization, and tools such as Python can help you communicate findings with confidence.

  • YOU WANT TO PRESENT DATA IN AN ENGAGING WAY

     

    Want to wow your colleagues and stakeholders in future meetings? Learn how to tell a story through data and present findings in a visual and interactive way.

  • YOU WANT TO EXPLORE A CAREER IN DATA ANALYTICS

     

    Are you an aspiring data analyst? Gain hands-on skills in data manipulation and visualization and get familiar with industry tools like Excel and Python.

Your Ascent Starts Here

Find what works for you.

Udit will provide hands-on demos for a variety of industry tools, including Python and Excel, so you can find one that suits your needs. See how they are used by those in the business and start trying out the techniques for yourself.

See your data come to life.

Rather than focusing on one step in the data analytics process, you’ll be introduced to the full journey – from data collection to analysis, visualization, and presentation. This way, you’ll understand how to both gather findings and pitch them to stakeholders.

 
ABOUT THE COURSE
Real-world tools
Learn how to use industry tools such as Excel, Google Sheets, and Python. You’ll discover how to prepare datasets, analyze findings, and present data in an engaging and visual way.
Presentation practice
Gain confidence presenting your ideas with a video pitch and in-class presentation. Benefit from tips and tricks on presenting plus feedback from an industry professional.
Charts and visuals

Discover different types of charts and visuals you can use in data storytelling – and those to avoid. You’ll learn to develop compelling and polished presentations that deliver key insights to stakeholders.

Instructor
 
UDIT
MEHROTRA
LinkedIn Profile
  • Data Science Specialist at McKinsey & Company

  • Experienced in solving a wide variety of industry problems across sectors, including biomedical, finance and fraud, human resources, and sales and customer operations

  • Passionate about instructional design, curriculum design, and bridging cross-cultural gaps in teaching

  • Has lived in Thailand, India, Singapore, Canada, and the US

  • Enjoys choreographing, writing poetry, and cooking in his free time
Kevin Hartman
UDIT MEHROTRA
COURSE INTRODUCTION
SYLLABUS
01
THU (2/16) at 5 PM PST/8 PM EST
Data Analytics in the Modern World

Udit will introduce you to the information/data age and the important role analytics plays in the world we live in.

  • What is data analytics?
  • The role of a data analyst in business
  • Skills needed to be a good analyst
  • Case studies: Business + analytics
more
02
TUE (2/21) at 5 PM PST/8 PM EST
Data as the Core of Analytics

Deep dive into the importance of data as the focal point in analytics and AI as you discover different types of data.

  • Classifications of data and data sources
  • Types of data: flat, audio, video files
  • The data lifecycle
  • Data ethics, security, and bias
more
03
THU (2/23) at 5 PM PST/8 PM EST
Data Collection and Preparation

Learn how to clean and set up data for ease of analysis after collection, using common tools and techniques.

  • Common tools for working with data
  • Data collection and exploration 
  • Preparing data in Excel/Google Sheets and Python
  • Aggregating data and performing calculations 

Assignment #1: Prepare a dataset for analysis.

more
04
TUE (2/28) at 5 PM PST/8 PM EST
Lab #1: Manipulating Data

In this first lab, you’ll explore the idea of data manipulation with a hands-on demo.

  • Thinking about a dataset as an analyst
  • Exploring hunches, ideas, and theories using data
  • Demo: Dataset analysis in Excel/Google Sheets and Python

Assignment #2: Try preparing the dataset shown in the lab for yourself.

more
05
THU (3/2) at 5 PM PST/8 PM EST
Analyzing data

Learn to explore and analyze data with a data-driven approach to a case study.

  • Types of analytics
  • Formulating the question and hypothesis
  • Techniques for analysis
  • Case study: conducting Exploratory Data Analysis (EDA) on Uber ride pickups and providing insights and recommendations to fuel their growth
more
06
TUE (3/7) at 5 PM PST/8 PM EST
Data visualization

Dive into the basics and rules of data visualization and learn how to communicate insights in a visual manner.

  • Types of charts and their applications
  • Building charts in Excel/Google Sheets and Python
  • The keys to effective data visualization 
  • Storytelling using data

Assignment #3: Visualize the findings from the mock dataset provided.

more
07
THU (3/9) at 5 PM PST/8 PM EST
Lab #2: Answering Questions Using Data

In this interactive session, you’ll learn to hone the art of Exploratory Data Analysis (EDA) and develop hypotheses.

  • The skills needed to create hypotheses
  • Demo: Using data to analyze a business question
more
08
TUE (3/14) at 5 PM PST/8 PM EST
Regression Analysis

Understand the intuition behind regression, including how to implement it, check for assumptions, and interpret beta coefficients.

  • Predictive, prescriptive, and descriptive analytics
  • Predictive analytics in different industries
  • Predictive analysis techniques in Python
  • Regression analysis and forecasting

Assignment #4: Build a regression model as shown in class.

more
09
THU (3/16) at 5 PM PST/8 PM EST
Communicating Data Findings to Stakeholders

Learn to communicate and present insights to non-technical audiences and add polish to earn the trust of clients and stakeholders.

  • Storytelling using data
  • Types of stakeholder communications
  • Presenting your findings in a clear way
  • Activity: Mock presentations

Assignment #5: Present your findings from course assignments in a short video pitch (7 minutes).

more
10
TUE (3/21) at 5 PM PST/8 PM EST
Next Steps and Wrap Up

Start thinking about your future in data analytics and get wired into the world of AI.

  • Tools to explore
  • New trends in analytics
  • The future of analytics
more

What our students say

Beth Saunders DATA VISUALIZATION

"I absolutely love the format! Working through real life scenarios makes it super applicable and easy to translate the learning into practical takeaways. I also enjoy that the assignments are straightforward enough to get through but you can make them more complex to get more learning out of the course. It really is a format where you get out what you put in."

Carlos Andres BECOME AN ART DIRECTOR

"The group activities, they allow us to interact and exchange ideas, plus the way it is structured is challenging and mind twisting as we collaborate in different parts of the ideation."

Hayley Smith BRANDING 101

"Overall I'm impressed with the level of detail and explanation around particular topics and subjects. There's a real depth to each module which for learning allows the information to stay in your brain."

Rebecca Kouwe HUMAN RESOURCES ANALYTICS

"I really enjoy the format of the course. Lectures with real life examples and an ongoing case study. Also built in 20 minutes at the end of each class for questions is helpful."

Courtney Fulton WOMEN IN LEADERSHIP

"I enjoyed the structure of the class. I like how we learned about a topic and practiced it in the workshops. It’s helped me to apply what I learned!"

 
ENROLL
First name
This is required field!
Last name
This is required field!
Email
This is required field!
This is required field!
By registering and clicking “ENROLL”, you agree to our
Terms of Use, Privacy policy and Cookie Policy
 
 
 
 
ONE MOMENT...