Data analysis

Welcome! It is great to have you here. Before we dive into the world of data, I would love to learn a little bit more about what brings you here so I can tailor everything to your goals.

To help me customize this session for you, could you tell me a bit more about your background? Are you looking to build a career in data, or are you hoping to use these skills in your current role or for personal projects?

I want to start a new career as a data analyst

It is wonderful to have you here! Starting a career as a data analyst is an incredibly exciting journey, and you are getting in at a time when organizations have more data than ever before.

Your path

Key Data Skills

Practical Application

What is Data Analytics?

At its core, is the systematic process of taking raw, messy information and turning it into clear, actionable insights. Think of a data analyst as a translator. Businesses speak one language, and raw databases speak another; your job is to bridge that gap to help teams make smart, evidence-based decisions rather than relying on guesswork.

To make this concrete, let's look at a simple scenario. Imagine you are working for a local coffee shop chain that wants to increase its sales. Without data, the owner might just guess and say, "Let's launch a new lavender latte!" But as their data analyst, you would look at the actual transactional data to find out what is actually happening.

You might discover that while lavender lattes are trendy, 80% of morning customers actually order simple drip coffee, but they face a long wait time. By identifying this pattern, you could recommend pre-brewing the popular drip options to speed up service. That decision is driven by real evidence, not just a hunch.

Continue to why data analytics is important for decision-making

You've got it! Now let's explore exactly why data analytics has become the ultimate game-changer for in modern organizations.

To understand its value, let's look at the three main ways data transforms how businesses operate. First, it removes bias and guesswork. Instead of relying on whoever has the loudest voice in the meeting room, teams can look at concrete metrics. Second, it helps companies spot hidden inefficiencies that are invisible to the naked eye. Finally, it allows businesses to predict future customer behaviors rather than just reacting to past mistakes.

Decision Type	The Old Way (Guesswork)	The New Way (Data-Driven)
Product Inventory	Order stock based on what "feels" popular.	Analyze historical sales trends to predict seasonal demand.
Staff Scheduling	Schedule the same number of employees every day.	Track hourly foot traffic to staff up only during peak hours.
Customer Support	Wait for customers to complain to fix an issue.	Monitor system error rates to resolve bugs before users notice.

When you work as a data analyst, you are the person who turns raw data into these competitive advantages.

Next, let's look at the actual step-by-step process analysts use to make this happen, starting with how we gather the data in the first place.

Continue to the steps of the data analysis process

Let's walk through the life cycle of a data project, using our local coffee shop as a guide. The process always kicks off with gathering data, which is all about finding and centralizing the raw information you need to solve a specific problem.

The Data Analysis Lifecycle

Think of this process like cooking a gourmet meal. Before you can start cooking, you have to go shopping for the raw ingredients. In our coffee shop example, gathering data might mean pulling digital receipts from the point-of-sale system, exporting customer loyalty program records, or even downloading local weather data to see if rainy days boost pastry sales. Once you have your raw ingredients, you will quickly notice they are rarely ready to use. Your receipts might have missing entries, duplicate transactions, or weird formatting errors (like "latte" spelled three different ways). This brings us to the most time-consuming step in an analyst's daily life: .

A horizontal sequence of four icon-based steps in the data analysis lifecycle: gathering, cleaning, analyzing, and communicating.

Now that our ingredients are prepped, we get to the fun part: analyzing the clean data to spot trends, and then communicating those insights. During the analysis phase, you might run calculations to find that morning rush-hour sales spike when temperatures drop below 50 degrees. But those insights are useless if they stay locked in your spreadsheet. The final, critical step is translating your findings into simple visual dashboards or reports that the coffee shop owner can easily understand at a glance.

Make me a worksheet on the data analysis lifecycle

I would love to set that up for you! Practice is the absolute best way to cement these concepts, especially when you are preparing for a brand new career in the field.

SHEET

Worksheet

I have queued up a practical, scenario-based worksheet for you to test your skills on the lifecycle. While that is being built, let me know if you would like to tackle a quick, interactive practice question right here, or if you feel ready to dive into the core tools in the !

Continue to the Data Analyst Toolkit

It is great to have you back! Now that you've got a feel for the data lifecycle, let's open up the and look at the actual software you will use every single day to get the job done.

The Four Pillars of the Toolkit

When you start working as an analyst, you don't need to know every piece of software ever created. Instead, you'll focus on mastering four distinct categories of tools, which we call the pillars. Each of these pillars has a specific, super-focused job to do during your projects:

Spreadsheets (Excel/Google Sheets): The undisputed entry point. Spreadsheets are your quick-reaction tools, perfect for opening small datasets, sorting information on the fly, and performing basic math calculations.
SQL (Structured Query Language): The direct hotline to databases. When data is too massive for Excel to handle, you'll write SQL queries to pull exactly what you need out of huge corporate storage systems.
BI Tools (Tableau/Power BI): The digital canvas. These tools let you drag and drop charts together to turn rows of boring text into living, interactive visual dashboards for your company's leadership.
Programming (Python/R): The heavy-duty automation engines. When you need to clean incredibly messy datasets, run advanced statistics, or automate a repetitive daily report, you'll use code to script the entire process.

Make me a diagram of when to use each tool

I'd be happy to map this out for you! Visualizing how these tools hand off data to one another is the absolute best way to understand how a professional data analyst actually structures their day-to-day workflow.

A horizontal data analysis workflow illustrating tool usage with a cylindrical database node on the left, a central spreadsheet table node, and two terminal branches representing business intelligence dashboards and programming code.

I have started generating an interactive diagram that maps out this tool workflow. It shows how data flows from big storage databases through SQL, gets refined in Excel or Python, and finally lands in beautiful dashboards.

Now that you see where all these tools fit, let's dive into detailing the specific role and use case of each tool, starting with the classic workhorse: spreadsheets.