Data Analyst – Foundations and Fundamentals Course

This course helps “Aspiring Analysts” and “Pivoting Professionals” launch a rewarding career in Data Analysis.

You’ll learn the essential skills successful data analysts use every day to deliver value to their colleagues and company.

Gain hands-on experience through practical exercises using the most common tools.

In the course, you will learn:

1. How to focus and plan for a Data Analyst Career.

• We discuss the data analytics career pathway. Including:
  • Why data analytics is a rewarding and creative career.The learning pathway you need to follow to break into a career in data analytics.
  • An understanding of the different data roles and where the Data Analyst role fits.

2. The Data Analysts’ workflow. The 5 step process all successful data analysts follow.

• We describe in-depth the 5-step process successful data analysts utilize and apply to real-world problems. From analysis through sourcing data, preparing data, and exploring data to delivering insights.
• We show you how to apply the 5 steps in an easy-to-follow, practical, real-world use case. The use case is based on our fictitious video streaming company, “GetFlix”.
• We aim to give you a framework you can apply to any toolset, confidently enter a new workplace, pick up a data analysis assignment, and run with it.

3. Make a positive difference to your company and colleagues by delivering business insights.

• We provide a grounding in visual communication and the essence of simplicity and storytelling.
• We show you how to build insightful business visualizations and analytics to help your business make data-driven decisions.
• We show you the top 5 visualization mistakes to avoid.

4. Focus on the small set of tools you need to break into Data Analysis.

• We give you a grounding in the most common tools different data roles use.
• We identify which tools you should focus on first to break into Data Analytics.

5. Standout from the crowd and get noticed by Peers and Employers

• You earn a Digital Certificate and Verifiable Badge to share on LinkedIn and other social media.
• Finally, we give you tips and tricks to capitalize on your experience and showcase your work to peers and potential employers.

Who is this course for:

• Pivoting Professionals. Professionals looking to pivot their experience and education into a Data Analytics career.
• Aspiring Analyst. Aspiring data analysts looking to build the essential foundation for a successful career in data analysis.
• Existing Data Analysts. Looking to solidify their knowledge, formalize their approach and go from good to great.

Curriculum

The career pathway to becoming a Data Analyst:

• Why become a Data Analyst?
• Understanding the data roles and where the Data Analyst role fits.
• Why the Data Analyst role is the perfect starting point.
• The Data Analyst Learning Pathway to a successful career in data analytics.

Introduction to the Data Analysis Workflow:

• The 5 phases of the Data Analysis workflow
  • Business Case, Planning and Prototyping
  • Sourcing data
  • Preparing data
  • Exploring data
  • Visualizing and Presenting Insights

Business Case, Planning and Prototyping:

• CASE STUDY: User Revenue at GetFlix Movie Streaming Service
• Understand your audience.
• Identify the key business process(es).
• Identify the Who, What, Where, When and Why associated with the business process(es).
• Define your metrics, filters and categories.
• The Power of Prototyping.

Sourcing Data:

• Types of Data sources.
• Sources to seek out and avoid (if possible).
• Profiling Data (Part 1)
• CASE STUDY: Sourcing Data at Getflix.

Preparing Data:

• Profiling the data (Part 2)
• Common data quality issues (and how to deal with them)
• Intro to ETL and data engineering
• CASE STUDY: Preparing Data at “Getflix”

Exploring Data:

• Exploring Data vs Explanatory Analysis
• CASE STUDY: Exploring Data at “Getflix”
• The 6 foundational techniques of Data Exploration
  • Introducing Pivot tables
  • Filter
  • Categorizing
  • Hierarchies
  • Drill Down, In and Across
  • Graphing

Visualizing and Presenting Insights:

• Numbers and Statistics. A primer.
• What works, what doesn’t and why (i.e., visual perception).
• When to use Tables vs Graphs.
• Fundamentals of presenting data as Graphs.
• Fundamentals of Presenting tables as Tables.
• The 5 graphs you should never use.
• The principle of storytelling with graphs.
• CASE STUDY: Visualizing User Revenue at “GetFlix”.

Features

• Follow along with our custom, downloadable, real-world case study – GetFlix streaming service.
• Graded quizzes and assignments.
• 100% money-back satisfaction guarantee.
• Verified badges and Certificates you can share on social media.
• Constant Content Updates. Updated with the latest changes to the underlying tools.