Level 1

Level 2

Level 3

Data Analyst Level 1: Excel and Tableau 2 Week

Learn how to use Excel and Tableau to manipulate and visualise data to help businesses make smart, data-driven decisions that stand them out above the competition.

💻 A laptop is required for this course.

YOUR INSTRUCTOR

Nabeel Siddiqui

Lead Analyst at Wise

WORLD CLASS MENTORS

📖 Who is this for?

This is for you if you're...

✨

A complete beginner

Never touched a spreadsheet in your life? No problem - we’ve got you.

🚀

A startup founder or PM

Make sense of data quickly to improve your product. You’ll also learn to make better decisions.

💻

A marketer

Get to your marketing insights faster by learning Excel formulas. Plus, impress your boss with your data dashboards.

❗️ Must-knows

2,292+ peers

In the Discord community - so you don't have to learn alone.

Flexible

Asynchronous courses with hands-on projects.

Online

We have students from all over the world.

6 weeks

To learn the foundations of a new tech skill.

2 deadlines

Submit your portfolio and peer review before the end of the course.

1 portfolio

Create a portfolio to impress recruiters by the end of the course.

📖 Course overview

What's data analysis?

Data Analysts help us make sense of all the information that is around us and find important insights that drive big decisions. In the Data Analyst program, you will learn how to use Excel and Tableau to manipulate and visualise data to help businesses make smart, data-driven decisions that stand them out above the competition.

Data is the future of tech careers. No matter which company or role you work in, gathering insights from data is a skill that will lead to career growth.

📖 Learning outcomes

What will you learn?

Create a stunning data dashboard in Tableau - you might even want to print and frame it!

Understand how to clean data using Excel formulas

Use Root Cause Analysis to think critically about data problems

📖 Mentor

Learn from experienced data analysts

Lead Analyst

Nabeel Siddiqui

Nabeel started off as an accountant and left its corporate side after finishing his CPA to start teaching it. He enjoys making complex topics engaging for young adults.

Nabeel's curiosity and love for solving problems led him towards the world of data. He taught himself the power of SQL, Python and data visualisation tools and uses them to make people's lives easier, whether that means automating operational reports or building a chatbot to assist with his personal meditation routine.

He currently works as a Senior Product Analyst in Singapore.

Alan Truong

Head of Engineering

Alol Elba

Research and Evaluation Officer at Relationships Australia

Hasintha Attanayake

Data Analyst at Yellow Canary

Oscar Lukersmith

Senior Analytics Engineer at Safety Culture

❤️ Why LearnHub

Why learn with us?

"LearnHub makes learning fun and engaging. I got hands-on practical experience and am so proud of my portfolio project."

Check out our Trustpilot reviews for more.

Learn together and have fun

Our programs are cohort based. Get allocated to a team of friends who are doing the course too. Exchange ideas, support each other and ask questions.

Everything is flexible and asynchronous, so you'll learn on your own time while still feeling supported by a community.

Build portfolios, not resumes

Create a portfolio project you can be proud of.

Confidently show off your projects to companies, who'll be blown away by your amazing work.

📚 Curriculum

Build real experience, with accountability and structure.

Our 6-week cohort-based method will ensure you get the program done.

Unlike other online programs who teach the same PowerPoint-heavy curriculum for years, we consistently develop our programs with leading industry experts to ensure they have the latest tools, workflows, and best practices.

Week 0

Pre-Work

Program Start

Week 1 - 3

Modules Unlocked

Week 4 - 5

Final Submission

Week 6

Peer Review

Graduate

Module 1 - Week 1

Introduction to Data Analysis

Understand the day in the life of a data analyst and the different tools they use in their trade.

Lorem ipsum dolor sit amet, consectetur adipiscing elit. Suspendisse varius enim in eros elementum tristique. Duis cursus, mi quis viverra ornare, eros dolor interdum nulla, ut commodo diam libero vitae erat. Aenean faucibus nibh et justo cursus id rutrum lorem imperdiet. Nunc ut sem vitae risus tristique posuere.

Enter the analysis world
The role of a data analyst
Framing the problem

Module 2 - Week 1

Preparing data for analysis

Gather and extract data to Google Sheets and standardise it by cleaning and removing unnecessary details.

Data collection
Data cleaning

Module 3 - Week 1

Conducting data analysis using Google Sheets

Understand the theory behind descriptive statistics and pivot tables and then use the power of Google Sheets to uncover insights for your business problem.

First, some theory
Calculating descriptive statistics
Pivot tables

Module 4 - Week 2

Data visualizations using Sheets and Tableau

Create charts and graphs in Google Sheets. Learn to connect your data to Tableau and build a dashboard for your case study.

Introduction to visualization
Creating visualizations in Google Sheets
Introduction to Tableau
Creating visualizations in Tableau

Module 5 - Week 2

Data storytelling

Learn the power of data storytelling, the final step in the data analysis process. You will understand the root cause analysis and how to use narrative, data and visuals to tell a compelling story.

Root cause analysis
Using data to tell a story

Module 6 - Week 3

Capstone project

Find a dataset of your choice, frame a problem and apply the skills you learned through the experience for your capstone project.

Building a capstone project

Module 7 - Week 6

Offboarding

Graduate as an LearnHub alumnus!

Offboarding (action needed)

Don't understand a term here as a beginner? Don't worry - we'll teach you all about it.

🥰 Our alumni

Our students are confident in their skills

We help students like you fall in love with learning again - and discover what they're passionate about.

"I made an outstanding portfolio."

Thank you LearnHub for this very practical experience of data analysis using Excel and Tableau. Thank you especially for teaching me to make a very concise data analysis report and an outstanding portfolio.

Marybeth Ubanwa

Data Analyst student

"It exposed me to how Data Analysts work in the real world."

I completed the LearnHub Data Analyst 6-week Internship. It was definitely fun and exposed me to how the Data analyst works in the real life world. I worked with Googlesheets and Tableau. I also submitted a nice report on the projects I did. Thank you LearnHub for this opportunity 🎉

Princess Amadi

Data Scientist

"Ideal setting for a Data Analytics job."

I just completed the Entry Level Data Analytics certification course. This program has been a wonderful experience for me to develop and deepen my skills more into the world of data. It appears to be the ideal setting for a Data Analytics job.

Aina Ajibola

Data Analyst

"Trainings mirrored real life experiences of a Data Analyst."

I believe the trainings mirrored part of the real life experiences of a Data Analyst as it was really hands on. One of the projects I did during the training can be viewed on my portfolio.

Alexandra Ighodaro

Data Analyst

Alumni portfolios

Check out amazing work by previous LearnHub students.

Jennifer Chou’s personal data dashboard

Canada 🇨🇦

A dashboard for tracking personal life data, from sleep to exercise.

View work →

Azubuike Ejike's video game sales report

Nigeria 🇳🇬

A data report on video game sales.

View work →

🌐 Global community

Educating learners from 182+ countries

Since launch, we have educated 30,000+ learners from all over the world and we’re trusted by learners coming from industry leading teams like Canva, Microsoft and more!

📚 FAQs

Your questions, answered

Here are some of the questions we get a lot. If you have a question that’s not here, hit us up on support.

How much is the course?

It will depend on your local currency. Check out the page for the course you're interested in to get the most up-to-date pricing.

Will I get a certificate?

Yes, if you finish our course before the deadline, you will get a certificate. All deadlines are emailed to you and on our website - you will have 6 weeks to complete course tasks. If you complete everything on time, you will even get an "on time" badge on your premium certificate, which you can talk about in interviews to showcase your reliability to employers.

Are classes live? What's the course structure like?

Classes are not live - everything is flexible and can be done on your own time. However, there are deadlines you need to meet in order to earn your certificate.

There are 2 deadlines you must meet: portfolio submission and peer review (at the end of the 6 weeks).

Each module will unlock every few days. There is a 2-week buffer period in which you can catch up and submit your work before the deadline. You can expect a mixture of videos, images, and hands-on tasks in every module.

📚 Support

Any other questions?

We’re confident you’ll love the program (hence our cash back policy). But if you’re still on the fence, we’ll be happy to answer your questions.

Write to us

Heading

Data Analyst Level 1: Excel and Tableau 2 Week