Data Analytics Foundations

1

Business solutions

Take a business problem, and translate it into a qualified data solution.

2

Investigative analytics

Explore your data to reveal patterns and outliers.

3

Data agility

Take data from different sources and combine them: csv and Excel files, Google Analytics, Salesforce, BigQuery, AWS Redshift or any other SQL databases.

4

Insights delivery

Build reports, create interactive dashboards, or prepare a presentation to your stakeholders.

Week 1

Approach to Analytics

Data analytics is not only about crunching numbers. Learn the framework that enables you to tackle any data question.

Formulate the appropriate data questions to a business question and find the best data to find solutions and insights.
Find and prepare the data sets to build the foundation of your analysis.
Analyze and visualize data to unravel insights, to finally present them and convince your stakeholders.

Analytics Methodology PyData Data Structures

Week 2

Analysis in Excel

One of the cheapest yet most powerful tools available to all analysts, let's cover:

Prepare and clean data through Excel functions.
Pivot your data to quickly and efficiently slice and dice small data sets.
Plot and apply trend analysis to your data.

Excel Date Preparation Data Pivot

Week 3

Interacting with a SQL Database

Access a whole new world of datasets by directly querying databases of millions of records.

Understand the client-server architecture.
Select and filter data through SQL queries.
Aggregate millions of records into simple insights.

SQL Filter Aggregate

Week 4

Slice & Dice with SQL

Databases are a lot more efficient than spreadsheet at digging through millions of records. By using more advanced queries, let's:

Group to pivot your data.
Join data across different tables to enhance your insights.
Use subqueries and logic build specific measures and dimensions.

Group Join Subqueries

Week 5

Data Visualisation with Tableau

Tableau is one of the most popular visualization tools for data analysts. Through this software, you will learn different visualization techniques to give a voice to your data.

Use measures and dimensions to isolate your insights.
Explore your data to find outliers and discover trends.
Learn the techniques to make your visualization stand out in reports.

Data Visualization Trends Data Exploration

Week 6

Exploratory Dashboards

Very often, combining visualizations into interactive dashboards brings a deeper understanding of the relationships within our data set.

Create interactive dashboards through dynamic filtering.
Build compelling stories which call for action.

Dashboards Interactive Exploration

Week 7

Advanced Topics in Analytics

A few techniques that help you access insights faster.

Regular expressions: the magic tool to solve your text cleaning and analytics.
Use window functions to build more complex aggregations.
Compare your user cohorts to improve retention or marketing strategy.

Cohort Analysis Window Functions

Week 8

Capstone Project

Start building your portfolio of analytics projects by working on the dataset of your choice with the guidance of our instructor.

Formulate a question and find data.
Build a dashboard or report with recommendations.
Present your data product and learn from the other projects.

Project: Final Project

Connect Data Communicating Results

Max Della Libera

Max Della Libera Senior Analytics Manager, Chengbao

Max is a veteran in data analytics and Business Intelligence. He is currently leading the analytics effort in a tech company with 900K+ active users. He is also a passionate data analytics instructor and trainer with 350+ hours of in-person classes and corporate trainings.

Data analytics foundations is aimed at professionals and recent graduates who want to:

Supercharge an existing skill-set (e.g. finance, marketing, software development) with a data analytics approach.
Carve out a niche for themselves in organisations which stand to benefit from adopting data-driven processes.
Gain an advantage over their peers through exposure to real-world challenges, data sets and best practices.

In order to get the most out of the course, students should have a laptop (less than 4 years old) and be familiar with the following:

OS familiarity (files and folders organization, app installation…)
Basic Excel functions (sum, average, pivot tables…)

Spectrum offers flexible payment options to ensure that nothing gets in the way of beginning your learning journey. From payment plans to earning your way through spectrum points - we've got your back. Please refer to our application page for full details on the enrolment process and payment options.