Become a Data Analyst

The structured foundations approach is the foundation you’ll use to come up with a data-oriented solution to any business problem.

No matter what industry you’re in, if you're able to master the ability to frame problems in a structured, data-driven way, you’ll always come out on top.

• Develop an understanding of the HDEIP Framework and the Five-Step Problem Solving Approaches.

• Learn how to use SMART principles to create a problem statement worksheet.

• Become comfortable creating Mutually Exclusive Collectively Exhaustive (MECE) Issue Trees.

• Develop an understanding of Value Driver Trees.

Visualization Tools are critical tools used in the Presentation Phase of the HDEIP Framework. While upfront analysis is very important work, ultimately, how this information is presented, visualized and consumed determines whether your analysis will be adopted or shelved. In this unit, students will learn how to use Tableau to craft powerful, impactful stories.

In this unit, you’ll:

1. Develop an advanced ability to use Tableau.

2. Practice using functions data analysts use on a daily basis.

While working through this section of the course, you’ll learn how to leverage Structured Query Language (SQL) to query relational database management systems. In other words, you use queries to understand the data contained in databases. Here’s one example. Let’s say you’re a data analyst assessing underperforming malls. You’d write a query to analyze daily foot traffic data stored in the malls’ databases.

In this unit, you’ll:

• Develop the ability to explain the nuances of a database and how it relates to set theory.

• Write best practice queries in SQL.

• Practice using SQL with real data to extract insights to be presented to an audience.