Data Analytics Course

Enter the world of Data Analytics. Learn ‘Data Cleaning’, Data Aggregation, SQL, Data Visualisation & Storytelling in an enjoyable and highly practical learning experience.

analytic-translation-header

Data Roles Are In (Very) High Demand

Did You Know?

0 M

Data science and analytics job openings are expected to grow to at least 2.7 million by end 2020

Source: Indeed.com

Did You Know?

0 %

65% of companies are struggling to analyse the data they store even though 89% agree that being able to analyse it would give them an advantage

Source: Deloitte

Did You Know?

100 %

Less than 0.5% of global  created data is ever used

Source: Deloitte

And many of these roles are a fit for you

Mauricio-Bernardo-Da-Silva-Data-Science-Expert-Rounded

Mauricio Bernardo da Silva

Data lover and teacher

“You don’t need to be a genius to work with Data. It’s all about matching the right person with the right skills to the right job. Data projects are a team sport. They benefit from a wide range of different skills (and skill levels). Everyone has a part to play!”

So We Built A Personal Scan
To Find Your Strengths & Weaknesses

ux-capability-scan

And A Curriculum To Guide You (Step By Step)

Build a detailed plan for how to tackle the analysis of a business problem.

Select a data cleaning strategy based on a given scenario.

Learn to use filter features, handle missing data based on industry norms, use conditional formatting to identify duplicates and much more.

Begin examining a business case, using Excel to clean, analyze and visualize data to spot trends and deliver insights

Use SQL to query a relational database, bringing the data you want to the surface. Use SQL intuitively.

Translate and communicate your data findings to technical and non-technical audiences through data visualization and data storytelling

Discover the difference between descriptive, predictive and prescriptive analytics. Begin building prediction models. Supervised and unsupervised models using regressions, forests and neural networks.

Around Tools You Will Learn To Love

data analytics tools-01
data analytics tools-02
data analytics tools-03
data analytics tools-04
data analytics tools-05
data analytics tools-08

Here's The Structure Of The Program

GT---2020---Study-Tracks-02-Crash-Course

12 Weeks of courses and exercises

12 weeks of live courses, homework (approx. 5hrs per week), exercises, reading, videos, templates, micro-learning and engaging interactions with peers

GT---2020---LifeLong-Acces-Crash-Course

4x Personal Coaching Sessions

Four personalised coaching sessions with your mentor to facilitate your learning progress based on your specific needs

Build A Personal Project To Showcase

Build multiple shared projects and a final personal project by the end of the program

Growth Tribe

Lifelong Access & Support

Lifelong access to your online learning environment: review content, videos & resources and stay connected with your community of peers

growth-tribe-course-timeline

And some of your instructors 🙂

Bernardo-F-Nunes-Data-Science-Expert-Round

Bernardo F. Nunes

PhD. Business applications of Data Science and Behavioural Science.

Judit-Szaffenauer-Data-Science-Expert-Rounded

Judit Szaffenauer

Machine Learning, Business Applications of Data Analytics and Market Research.

Mauricio-Bernardo-Da-Silva-Data-Science-Expert-Rounded

Mauricio Bernardo da Silva

Data Analysis, Machine Learning

Juan-Venegas-Data-Science-Expert-Rounded

Juan Venegas

Mathematical modelling, commercial storytelling, filmmaking, coding.

Theo-Saroglou-Data-Science-Expert-Rounded

Theo Saroglou

Behavioral Economics, Game Theory, Econometric

google logo

Google

No joke. Google will be one of your most important trainers 🙂

Learning Experience

Here Are More Details About The Program

A Personal Capability Scan Before The Course Starts

The personal assessment will give both you and your coach a clear view of your strengths and main improvement points in the topics that are relevant to this course. We can then adapt your online learning journey to better match your goals. No one-size-fits-all learning here!

GT---2020---Live-Online-Remote-Crash-Course

Live Online Workshops delivered by Expert Trainers

Our online courses are hosted live to ensure real time teaching and facilitation from our experienced Data practitioners. Class sizes are limited to ensure you get the real-time support you need.

Immersive Group Interaction with Team Breakout Sessions

Enjoy online break-out sessions for group discussion and peer-to-peer learning, all during live classes. Participants work on real business cases and share their knowledge with the group.

GT---2020---Immersive-Group-Crash-Course

Real-Time Exercise Walkthroughs, Guidance & One-to-One Coaching

You’ll stay engaged with hands-on exercise walk-throughs, and live discussions with trainers and fellow alumni using the latest educational conferencing technologies. You’ll also have regular remote coaching sessions tailored to your specific needs.

Example of a project you'll work on

Building a prediction model to predict customer lifetime value estimations. Then creating visualisations to communicate this to an online retailer.

cltv-estimation

Example of a project you'll work on

Using Analytics to unlock failure moments and points of improvement in a customer journey

Get your hands dirty with key tools of the industry

Use the latest and most important tools. We’re  addicted to tools and want to share that healthy addiction with you.

GT---2020---Study-Tracks-02-Crash-Course

Learn at your own pace with brand new self-study tracks

These brand new study tracks allow you to apply your learnings, expand your knowledge and up your skills at your own pace.

Get certified

Graduate with a Growth Tribe certification of competence. You’ll also receive a virtual certificate which alumni add to their Linkedin profile.

growth-tribe-certification
GT---2020---LifeLong-Acces-Crash-Course

Lifelong access to content & alumni community support

You’ll receive lifelong access to the course material through our online learning environment as well as lifelong support from our trainers & your peers through our exclusive online communities.

See What An Online Growth Tribe Course Feels Like

This is a video.. .click play

Play Video

Detailed Course Curriculum

Before the course starts

We’ll run a complete capability scan in these key capability areas:

  • Mindset & Professional skills
  • Data Science Role-Specific Capabilities (e.g. Data Analytics, Data Wrangling, Machine learning and Data Storytelling…)
  • Baseline of outcomes (success KPIs we define for the program)
  • Prep work to get you up to date if needed

Week 1 - Data Analytics Fundamentals

  • Explain the value of data.
  • Describe the data framework and how it’s used by analysts.
  • Write a specific and testable question given a scenario
  • Outline goals, expectations, and logistics.
  • Identify the skills and mindset of a successful data analyst.
  • Discuss the discipline of data analytics, including topics such as data formats and data ethics.
  • Describe the data sources available for analysis.
  • Evaluate data sets and their variables
  • Determine if a data set can be used to solve a business problem
  • Use VLOOKUP and HLOOKUP.
  • Use INDEX MATCH.
  • Distinguish between the three functions

Week 2 - Project & Focus on Specific Skills

Focus on key capabilities to strengthen your T-shape Depending on your skills assessment these could be:

  • Data Analytics
  • Data Wrangling
  • Machine Learning
  • Data Storytelling
  • Coding & Automation
  • Business & Strategy
  • Marketing & Branding
  • Stakeholder Management
  • Another capability adapted to your needs
  • Reflect on your progress and learnings
  • Discuss blockers & questions
  • Receive feedback

Week 3 - Data Cleaning and Aggregation

  • Build relationships between cells in Excel
  • Manipulate data sets using VLOOKUP
  • Look up values in other tables using INDEX and MATCH
  • Apply Excel aggregation functions to data sets.
  • Use PivotTables to summarize data
  • Identify common problems and solutions for PivotTables.
  • Modify data structures with regular tables for efficient workbooks
  • Identify the appropriate visualization types for the
  • data set at hand.
  • Create analytics visuals such as bar charts, pie charts, line graphs, histograms, and scatterplots.
  • Explore data using conditional formatting for categorization and analysis.

Week 4 - Project & Focus on Specific Skills

  • Data preparation and cleaning
  • SQL
  • Task and proof of concept development
  • Defining success and evaluating a data analysis
  • Matching the right chart to a given data type
  • Data visualisation best practices and quality checklist
  • Causal inference: A/B tests and multivariate test
  • Data Storytelling
  • Business & Strategy
  • The character, insight and obstacle framework 
  • Generating analogies to keep stakeholders engaged
  • Critical evaluation of visuals and narrative
  • Machine learning models
  • Another capability adapted to your needs
  • Work on your project(s)
  • Receive feedback
  • Iterate

Week 5 - SQL: Querying and Organizing Data

  • Navigate a relational database. • Practice writing and executing SQL queries, including SELECT, FROM, WHERE, and DISTINCT SELECT.
  • Work with logical and comparison operators in SQL.
  • Work with CASE to handle multiple conditions.
  • Practice writing aggregate functions: MIN, MAX, SUM, AVG, and COUNT.
  • Use advanced SQL commands such as GROUP BY and HAVING to group and filter data
  • Combine data from multiple sources using INNER and LEFT JOINs.
  • Compile data using UNION and UNION ALL.
  • Compare use cases for JOINs and UNIONs
  • Practice the concepts and syntax of advanced
  • JOINs such as EXCEPT, FULL, and OUTER.
  • Handle NULLs in SQL • Practice query optimization techniques
  •  
  • Construct subqueries for multi-step operations.
  • Identify subquery use cases for various business scenarios.
  • Practice common table expressions (CTEs) with SELECT statements
  • Explain what subqueries are and why analysts use them.
  • Distinguish between the three types of subqueries and write your own
  • Apply string, math, and date functions in SQL to prepare and analyze data.
  • Practice writing SQL queries with advanced functions to solve business problems.
  • SQL Aggregate Functions
  • SQL Scalar functions

Week 6 - Project & Focus on Specific Skills

  • Data preparation and cleaning
  • SQL
  • Task and proof of concept development
  • Defining success and evaluating a data analysis
  • Matching the right chart to a given data type
  • Data visualisation best practices and quality checklist
  • Causal inference: A/B tests and multivariate test
  • Data Storytelling
  • Business & Strategy
  • The character, insight and obstacle framework 
  • Generating analogies to keep stakeholders engaged
  • Critical evaluation of visuals and narrative
  • Machine learning models
  • Another capability adapted to your needs
  • Work on your project(s)
  • Receive feedback
  • Iterate

Week 7 - Data Stories and Visualization Using Tableau

  • Prepare data for import into Tableau
  • Navigate the Tableau interface to build visualizations
  • Aggregate measures and dimensions.
  • Work with Marks Card and discrete versus continuous date
  • Connect to the PostgreSQL server.
  • Create calculated fields to analyze data.
  • Apply filters to single or multiple worksheets
  • Apply visual analytics best practices.
  • Design interactive dashboards with parameters, advanced filters, and layout containers
  • Story structure. Telling a story with a clear beginning, middle and end. Highlighting conclusions and takeaways. Selecting the right level of detail, from helicopter view to deep dive
  • Use of character. Finding relatable elements. Bringing data to life
  • Use of analogies. Removing jargon and explaining models in simple language
  • Slide design. Conveying concise messages without distracting your audience from your speech
  • Presentation tips. Mastering the connection with the audience to take them on a data journey

Week 8 - Project & Focus on Specific Skills

  • Data preparation and cleaning
  • SQL
  • Task and proof of concept development
  • Defining success and evaluating a data analysis
  • Matching the right chart to a given data type
  • Data visualisation best practices and quality checklist
  • Causal inference: A/B tests and multivariate test
  • Data Storytelling
  • Business & Strategy
  • The character, insight and obstacle framework 
  • Generating analogies to keep stakeholders engaged
  • Critical evaluation of visuals and narrative
  • Machine learning models
  • Another capability adapted to your needs
  • Work on your project(s)
  • Receive feedback
  • Iterate

Week 9 - No-Code Machine Learning

  • The 3 steps of data analytics
  • Finding quick insights with descriptive analytics
  • When to use predictive modelling
  • Data-driven experimentation
  • Machine learning for predictions.
  • Types of predictions: binomial and continuous
  • Metrics for evaluating models.
  • Assessing costs and opportunities of predictions
  • The 3 families of algorithms: Regressions, Forests, Neural Networks
  • Uncovering data from structured and unstructured data
  • PCA
  • K-means clustering

Week 10 - Project & Focus on Specific Skills

  • Data preparation and cleaning
  • SQL
  • Task and proof of concept development
  • Defining success and evaluating a data analysis
  • Matching the right chart to a given data type
  • Data visualisation best practices and quality checklist
  • Causal inference: A/B tests and multivariate test
  • Data Storytelling
  • Business & Strategy
  • The character, insight and obstacle framework 
  • Generating analogies to keep stakeholders engaged
  • Critical evaluation of visuals and narrative
  • Machine learning models
  • Another capability adapted to your needs
  • Work on your project(s)
  • Receive feedback
  • Iterate

Week 11 - Final Presentations & Certification

  • Understanding your audience
  • Structuring a riveting story
  • Mastering the use of character
  • Generation of analogies
  • Slide design
  • Working with your voice and your body
  • Constructive feedback
  • Communicating results 
  • Integrating feedback

Week 12 - Project & Focus on Specific Skills

  • Data preparation and cleaning
  • SQL
  • Task and proof of concept development
  • Defining success and evaluating a data analysis
  • Matching the right chart to a given data type
  • Data visualisation best practices and quality checklist
  • Causal inference: A/B tests and multivariate test
  • Data Storytelling
  • Business & Strategy
  • The character, insight and obstacle framework 
  • Generating analogies to keep stakeholders engaged
  • Critical evaluation of visuals and narrative
  • Machine learning models
  • Another capability adapted to your needs
  • Work on your project(s)
  • Receive feedback
  • Iterate
  • Get your certificate
  • Nominate an alumni lead
  • Get ready for next steps!

Some Of The Companies Our Alumni Work At

3d-hubs-logo
linkedin logo
booking-logo
ing logo
tomtom logo
IBM Logo
spotify logo
vanmoof-logo
deloitte logo
wetransfer-logo
mollie-logo
tomtom logo
takeaway-logo

Flexible Payment Options Available!

Pay in Full

€ 2997

  • If you would like to opt in to pay by instalment, please note this under the “MORE INFO / EXTRA ON INVOICE” section and indicate the number of instalments you prefer (2, 3 or 4). From here, please click on “request an invoice” and we will follow up directly to set up your payment.

Dates

Pick a date to start learning!

Online Live

October 20th – January 19th

GT-2DCC

Every Tuesday, 6:30 pm - 9:30 pm, CEST

€2997

Gain access to our exclusive alumni community

As a Growth Tribe alumni, you will join a community of over 15,000 professionals and gain exclusive access to:

  • Events, roundtables & workshops
  • Online Slack & Facebook groups
  • Online Content
  • New Courses
  • Networking opportunities

And much more…

circles 2

Business Solutions

Part of a company? Looking to learn as a team? We do that too...

circles 3
0 +
Alumni globally
0 +
Companies trained
0
Average Course Rating