Syllabus

Data Analytics
Program

01
Contents

What is Data Analysis 02

Course Structure 03

Module 1. Fundamentals of Business Analytics 04

Module 2. Data Visualization and Storytelling 05

Module 3. Python Fundamentals 06

Module 4. Data Analysis with Python 07

Module 5. Intro to Data Science 08

Module 6. Applying Analytics for the Final Project 09

Employment Preparation 10 01
What is Data
Analysis
The Data Analytics Program by Practicum is a 7-month course designed for people
with little to no programming knowledge. You can come from any possible background
and join our course to re-skill and become a high-paid professional.

The aim is to equip you with all the skills needed to land a job in the tech industry.

You will learn everything from exploring data with Python and Pandas to data
visualization, using advanced tools like Plotly and Tableau. By the end of the program,
you will have up to 14 projects in your portfolio to show future employers the exceptional
specialist you have become.

And while getting to grips with a collection of professional tools and technical skills,
you will train those soft skills required for success. You’ll learn time management, goal
setting, teamwork, and much more. You’ll also learn the best practices used in the tech
industry — such as cohort analysis and metrics for sales funnels — skills you’ll need
to ace interviews in your quest for a job.

02
Course
Structure
Your journey will be divided into sprints, two-to-three week long work intensive periods
grouped into thematic modules. Each sprint will have a particular learning objective,
reinforced through quizzes and tasks. Most tech companies work in this format,
so you will come prepared. At the end of the sprint, you will take the skills you’ve learned
and combine them with your existing skills to work on a project that will be assessed
by industry experts.

We provide some rough time estimates to help you plan and manage your schedule,
and we recommend spending around 20 hours per week studying. However,
we understand that everyone has different commitments and people learn at different
speeds. We also understand you may need a break at times, so we have some
suggested breaks scheduled in too.

03
Module 1 6 weeks

Fundamentals
of Business Analytics
Building an impactful analysis starts with understanding how to use SQL Databases to access and filter
data. This module will explore industry best practices for choosing and calculating the right metrics
and how to efficiently execute an analysis using spreadsheets.

Sprint 1 Sprint 2
Advanced Spreadsheets SQL Databases
• Data Cleaning • What is SQL?
• Pivot Tables • Query Fundamentals
• Spreadsheet Best Practices • Relationships Between Tables
• Graphs and Charts • Functions
Project • Advanced Queries
• Creating Tables, Views
and Temp Tables
Project

Total: Total:
3 weeks 3 weeks
60 hours 60 hours

04
Module 2 4 weeks

Data Visualization
and Storytelling
An analysis is only effective when you can clearly communicate it to your stakeholders. This module will
focus both on how to build interactive data visualizations in Tableau and the best practices in developing
persuasive stories for your presentations.

Sprint 3 Sprint 4
Data Visualization Storytelling with Data
with Tableau
• Introduction
• Fundamentals of Tableau • Building Your Story
• Interface • Choosing the Right Visualizations
• Building Charts • Dashboards in Tableau
• Making Interactive Charts • Tableau Stories
Project • Presentation Best Practices
Project

Total: Total:
2 weeks 2 weeks
40 hours 40 hours

05
Module 3 4 weeks

Python Fundamentals
Data analysis continues to become more sophisticated and some of the most advanced and powerful
techniques utilize the Python programming language. This module is focused on building a solid
foundation in Python and important software development tools used with Python.

Sprint 5 Sprint 6
Python Fundamentals Software Development Tools
• Introduction • Setting Up Your Personal
• Variables, Printing, Data Types, and Dev Environment
Arithmetic Operations • Intro to Command Line
• Strings • Version Control with Git and Git Hub
• Lists • Virtual Environments
• Dictionaries • Documentation
• Conditional Statements Project
• Loops
• Functions
• Pandas Library
• Intro to Data Preprocessing and
Exploratory Analysis
Project

Total: Total:
2 weeks 2 weeks
40 hours 40 hours

06
Module 4 6 weeks

Data Analysis
with Python
Learn to use powerful Python libraries for data analysis like Pandas for cleaning data and Matplotlib
for visualizing data. Apply python to execute A/B tests and build dashboards for reporting.

Sprint 7 Sprint 8 Sprint 9

Exploring and Cleaning Data Visualization with Python Business Analytics
Data with Pandas
• Why use Python • Introduction to Business Analytics
• Intro to DataFrames and Series for Data Visualization? • Metrics and Funnels
• Importing and Exporting Data • Building Charts with Matplotlib • Cohort Analysis
• Exploratory Data Analysis and Seaborn
• Unit Economics
• Cleaning Data • Building Dashboards with Plotly
• User Metrics
Project Project
• Soft Skills
Project

Total: Total: Total:

2 weeks 2 weeks 2 weeks
40 hours 40 hours 40 hours

07
Module 5 4 weeks

Intro to Data Science

Learn how to apply Machine Learning (ML) algorithms to building predictive models.
Using the scikit-learn Python library, you’ll learn how to train a ML model, measure
it’s performance and implement the algorithm.

Sprint 10 Sprint 11
A/B Testing Intro to Machine Learning
• Course Introduction • What is Machine Learning?
• The Basics of Testing Hypotheses • Intro to Classification Algorithms
in Business • Model Evaluation with
• Choosing an Experimental Method Crossvalidation
• Prioritizing Hypotheses • Intro to Regression Algorithms
• Preparing for an A/B Test • Model implementation
• Analyzing the Results of A/B Test Project
Project

Total: Total:
2 weeks 2 weeks
40 hours 40 hours

08
Module 6 3 weeks

Applying Analytics
for the Final Project
After building a comprehensive set of skills in you data analytics toolkit, it’s time to combine different
techniques together to accomplish larger projects. This module will focus on choosing the right
combination of tools to accomplish a job. The final step in this course is a Final Project where students
can demonstrate their mastery of data analytics.

Conclusion Final Project

Applying All of Your
Analytics Tools
• Review of the Full Analytics Toolkit
• Comparing Tools and Choosing the
Right Technique for the Job

Total: Total:
1 week 2 weeks
20 hours 40 hours

09
Employment Preparation
In addition to the main educational course, our career help is divided into four parts:
the Career Prep Course, the Career Acceleration Program, Tech interview practice,
and Apiary projects.

Career Prep Course Career Acceleration Program Tech interview practice Apiary Projects
Dedicated course on the platform Dedicated course on the platform An additional lesson to prepare for + 1–∞ real projects
This is a course devoted to preparing + online events and 1-1 coaching the technical part of a job interview. for your portfolio.
for life after Practicum. During this In this lesson, students or graduates
Prepare for real-world interviews You’ll gain confidence in solving work
course, you’ll learn how to create face a real-world case and will provide
and gain experience through tasks that use a real company’s data
a resume, a LinkedIn profile, possible solutions to check the
authentic practice. This program hypothesis. It’s a great opportunity to provide them with valuable insights.
and a GitHub account, along with
is designed to help you find a real to refresh their knowledge and gain Learn to communicate with clients,
improving networking and interview
job and also provides some work insight into similar cases. meet their expectations, exchange
skills. This course is self-paced
with technical skills. peer reviews with colleagues, and
and includes homework tasks. • SQL knowledge
present results to the company.
We’ll also perform a review of your • Attend mock interviews • Business oriented thinking
Apiary projects become available
career resources. • Receive 1:1 career coaching for participants sometime between
• Prepare your job search strategy the 8-10th Sprint, depending on the
• Compile a ready-to-use resume
• Get a bi-weekly review of your project. They are also available after
• Produce a production-ready application funnel
graduation.
portfolio • Write technical articles to exhibit
• Launch your LinkedIn profile your knowledge
• Assemble a portfolio project based
• Boost your soft skills
on actual data
• Produce demo videos of your work
• Get a recommendation on LinkedIn
• Participate in extracurricular
activities by a real company
• Join the LinkedIn community • Gain experience with freelance
project workflow

10–20 hours in total Up to 6 months 10–15 hours in total 5–6 weeks

after graduation

10
11