LIVE ONLINE COURSE
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.
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.
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.
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
COURSE INTRODUCTION
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
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
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.
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.
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 a popular ride-sharing service and providing insights and recommendations to fuel their growth
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.
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
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.
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).
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
What our students say
"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."
"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."
"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."
"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."
"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!"