What Is Data Analytics?
Data analytics turns raw numbers into decisions. Here's what it actually means, the tools professionals use, and how to start — no math degree required.
The coffee shop that saved itself with a spreadsheet
In 2022, a small coffee chain in Portland was bleeding money. Three locations, all busy, but profit was shrinking every quarter. The owner assumed it was rising milk prices. The manager blamed staffing costs. The baristas said it was the new competitors on the block.
Then an employee — a part-time barista finishing a business degree — asked a simple question: "Can I see the sales data?"
She exported three months of transaction records into a spreadsheet. No fancy software. No algorithms. Just Excel.
What she found: 38% of revenue came from drinks sold between 6:30 and 8:30 AM. But the shops were staffed equally across all hours. The afternoon shift had three baristas serving an average of 11 customers per hour. The morning rush had the same three baristas serving 47.
She also found that the highest-margin item — a seasonal oat milk latte at $6.50 — was never promoted on the menu board. And one location was throwing away $400 of pastries per week because they ordered the same amount every day regardless of foot traffic.
The owner shifted staffing to match demand, promoted the high-margin latte, and tied pastry orders to a rolling average of daily sales. Within two months, profit was up 23%.
No machine learning. No AI. Just someone who looked at the numbers and asked the right questions.
(Illustrative scenario based on patterns common in small business data analysis. Specific figures are representative of the leverage available from basic operational analytics.)
That's data analytics.
By the end of this module, you'll know the four types of analytics, the five-step process behind every analytics project, and the exact tool stack that gets analysts hired — starting from zero.
So what IS data analytics?
Data analytics is the process of examining raw data to find patterns, answer questions, and support decisions.
That's it. It's not magic, and it's not reserved for data scientists. Every time you check your bank statement to figure out where your money went, you're doing a basic form of data analytics.
What makes it powerful in business is scale and discipline. Instead of one person checking one bank statement, it's a team examining millions of transactions to find patterns no human could spot manually.
Every analytics project follows this loop. The data is useless without the cleaning. The analysis is useless without the visualisation. And the visualisation is useless without the action.
There Are No Dumb Questions
"Is data analytics the same as data science?"
Not exactly. Data analytics focuses on examining existing data to answer known questions — "What happened last quarter? Why did sales drop?" Data science goes further: building predictive models, running experiments, and creating algorithms. Think of analytics as the microscope and data science as the laboratory. Most professionals need the microscope first.
"Do I need to know math?"
You need to be comfortable with percentages, averages, and basic arithmetic. You do NOT need calculus, linear algebra, or statistics at a university level. If you can calculate a tip at a restaurant, you can learn data analytics.
"Isn't this just what accountants do?"
Accounting records what happened and ensures compliance. Analytics asks why it happened and what to do next. An accountant tells you revenue was $2M. An analyst tells you revenue was $2M because the Q3 campaign drove a 14% lift in repeat purchases, and if you scale that campaign, you could hit $2.4M next quarter.
The four types of data analytics
Not all analytics asks the same question. There are four levels, each building on the last:
| Type | Question it answers | Example | Difficulty |
|---|---|---|---|
| Descriptive | What happened? | "We sold 12,000 units last month" | Easiest |
| Diagnostic | Why did it happen? | "Sales dropped because our top product was out of stock for 9 days" | Moderate |
| Predictive | What will happen? | "Based on trends, we'll sell ~14,000 units next month" | Hard |
| Prescriptive | What should we do? | "Increase inventory by 20% and run a promo on day 15 to hit 16,000" | Hardest |
✗ Descriptive & Diagnostic
- ✗Looks at the past
- ✗Answers 'what' and 'why'
- ✗Uses historical data
- ✗Most companies start here
- ✗Tools: spreadsheets, SQL, dashboards
✓ Predictive & Prescriptive
- ✓Looks at the future
- ✓Answers 'what next' and 'what should we do'
- ✓Uses models and algorithms
- ✓Where the highest business value lives
- ✓Tools: Python, R, ML models
Most organisations are stuck at descriptive. They produce weekly reports full of numbers — revenue was X, traffic was Y, churn was Z — but never ask why or what to do about it. Moving from descriptive to diagnostic is where analytics starts paying for itself.
The analytics process: from mess to decision
Let's walk through each step of the process using a real scenario.
Scenario: An e-commerce company wants to understand why customer returns spiked 40% last quarter.
Step 1: Collect
Gather every relevant dataset: order records, return records, product reviews, customer service tickets, shipping logs.
The trap: collecting data is easy; collecting the right data is hard. If you don't have data on which products were returned and why, aggregate return numbers are nearly useless.
Step 2: Clean
This is the unglamorous step that takes 60-80% of an analyst's time. Real data is messy:
- Duplicate records (same return logged twice)
- Missing values (return reason left blank)
- Inconsistent formats ("US", "U.S.", "United States" in the country field)
- Outliers (one return for $45,000 — was it real or an error?)
If you skip cleaning, your analysis will be wrong. Garbage in, garbage out is the first law of data analytics.
Step 3: Analyse
Now you look for patterns. In our scenario, you might find:
- 72% of returns came from a single product category (shoes)
- Returns spiked after a supplier change in week 6
- Customers who used the size guide returned 15% less often
Step 4: Visualise
Turn findings into charts humans can act on. A single bar chart showing returns by product category tells the story faster than a 50-row table.
Step 5: Act
The analysis means nothing if nobody does anything. The recommendation: revert to the previous shoe supplier, and make the size guide more prominent on product pages. Projected impact: 30% reduction in returns, saving $180K/year.
The tools of the trade
You don't need to master every tool. You need to know what each one does and when to use it.
| Tool | What it does | Who uses it | Learning curve |
|---|---|---|---|
| Excel / Google Sheets | Basic analysis, pivot tables, charts | Everyone | Low |
| SQL | Query databases to extract and filter data | Analysts, engineers | Medium |
| Tableau / Power BI | Build interactive dashboards and visualisations | Analysts, managers | Medium |
| Python (pandas, matplotlib) | Advanced analysis, automation, ML | Data scientists, engineers | High |
| R | Statistical analysis and academic research | Statisticians, researchers | High |
| Google Analytics 4 | Website and app behaviour tracking | Marketers, product teams | Medium |
Start with Excel. Seriously. You can do 80% of business analytics in a spreadsheet. Pivot tables, VLOOKUP, conditional formatting, and basic charts cover most use cases.
Learn SQL next. It's the universal language of databases. Every company stores data in databases, and SQL lets you pull exactly what you need. You can learn enough to be useful in 2-3 weeks.
Add a visualisation tool. Tableau or Power BI turns your analysis into dashboards that executives actually look at. Pick one — they do the same thing.
Python is optional but powerful. If you want to automate repetitive analysis, work with huge datasets, or build predictive models, Python is the next step. Not required for most analyst roles.
There Are No Dumb Questions
"Should I learn Tableau or Power BI?"
If your company uses Microsoft products, learn Power BI — it integrates natively with Excel and the Microsoft ecosystem. If you're freelancing or at a startup, Tableau has a stronger community and more public learning resources. Both are listed on job postings interchangeably. Pick one, get good, and the other will take a day to learn.
"Can't AI just do all of this now?"
AI tools like ChatGPT can write SQL queries, generate charts, and suggest analyses — and they're getting better fast. But AI can't define the right question, judge data quality, or make a business decision. The analyst's job is shifting from "write the query" to "ask the right question and validate the answer." That makes analytics skills more valuable, not less.
Data analytics in the real world
Analytics isn't confined to tech companies. Every industry runs on data now.
| Industry | Analytics use case | Business impact |
|---|---|---|
| Healthcare | Predicting patient readmission rates | Hospitals typically report 10–25% reductions in readmission rates (published analytics programmes; results vary by patient population and intervention) |
| Retail | Analysing purchase patterns for inventory planning | Significant reductions in stockouts and overstock (McKinsey/Gartner retail estimates; typically 15–30% improvement; varies by retailer maturity and implementation) |
| Finance | Detecting fraudulent transactions in real time | Banks use analytics to prevent billions in annual fraud (industry-wide estimates vary widely; no single authoritative figure; directional only) |
| Sports | Player performance and opponent analysis | Moneyball: Oakland A's (2002) competed with roughly one-third the payroll of top-spending teams (e.g., ~$41M vs. Yankees' ~$125M) — using data to compensate for spending disadvantage |
| Marketing | Attribution modelling to allocate ad spend | Companies shift budget to channels with 2-3x better ROI |
| Logistics | Route optimisation for delivery fleets | UPS reportedly saved over $400M/year by eliminating left turns — the company confirmed fuel and emissions savings, but the financial figure comes from media reports rather than official filings |
Spot the Analytics Opportunity
25 XPThink about your current job, studies, or daily life. Identify three decisions you or your organisation make regularly that could be improved with data: 1. **Decision:** ___ | **Data you'd need:** ___ | **Question analytics could answer:** ___ 2. **Decision:** ___ | **Data you'd need:** ___ | **Question analytics could answer:** ___ 3. **Decision:** ___ | **Data you'd need:** ___ | **Question analytics could answer:** ___ *Example: Decision: "How many staff to schedule on Saturday." Data needed: foot traffic by day and hour for the past 6 months. Question: "What's the average and peak customer volume on Saturdays, and how does weather affect it?"*
Sign in to earn XPCareer paths and salaries
Data analytics is one of the fastest-growing career fields. And it's accessible — most entry-level roles don't require a degree in data science.
| Role | Experience | Salary range (US) | Key skills |
|---|---|---|---|
| Junior Data Analyst | 0-2 years | $55K-$75K | Excel, SQL, basic visualisation |
| Data Analyst | 2-5 years | $75K-$110K | SQL, Tableau/Power BI, statistics |
| Senior Data Analyst | 5+ years | $110K-$140K | Python, advanced SQL, stakeholder communication |
| Analytics Manager | 5-8 years | $120K-$160K | Team leadership, strategy, executive communication |
| Data Scientist | 3-7 years | $120K-$200K | Python, ML, statistics, experimentation |
| Analytics Engineer | 3-5 years | $110K-$160K | SQL, dbt, data modelling, ETL pipelines |
The path from junior analyst to data scientist or analytics manager typically takes 3-5 years. The secret to advancing quickly: combine technical skills with business context. An analyst who can write SQL AND present insights to executives is worth twice as much as one who can only do one.
How to get started — this week
You don't need to enrol in a bootcamp or buy a course. Start now, for free.
Day 1-2: Get comfortable with data. Open a public dataset (Google "Kaggle datasets for beginners"). Download a CSV. Open it in Google Sheets. Sort, filter, and look for patterns.
Day 3-5: Learn pivot tables. Pivot tables are the single most powerful feature in spreadsheets. They let you summarise thousands of rows into meaningful groups in seconds. YouTube has hundreds of free tutorials.
Week 2: Write your first SQL query. Use a free interactive SQL tutorial (SQLBolt or Mode Analytics SQL tutorial). Learn SELECT, WHERE, GROUP BY, and ORDER BY. That's 80% of what analysts use daily.
Week 3-4: Build your first dashboard. Sign up for Tableau Public (free) or Power BI Desktop (free). Connect a dataset. Build 3-4 charts. Publish it online. You now have a portfolio piece.
Build Your First Analysis
50 XPDownload the "Superstore" sample dataset from Tableau Public (or any beginner dataset from Kaggle). Using Excel, Google Sheets, or any tool you like: 1. **Describe:** What were total sales and profit last year? Which region performed best? 2. **Diagnose:** Which product category has the lowest profit margin? Why? (Look at discounts, return rates, or shipping costs) 3. **Predict:** Based on the monthly trend, what do you estimate next month's sales will be? (Hint: plot monthly sales on a line chart and extend the trend) 4. **Prescribe:** Write one specific recommendation the company should act on, backed by the data you found Share your findings in a single slide or screenshot. Bonus: post it on LinkedIn with #DataAnalytics. *This exercise walks you through all four types of analytics on a single dataset — the exact same process analysts use at Fortune 500 companies, just at a smaller scale.*
Sign in to earn XPBack to the coffee shop
Six months after the barista's spreadsheet analysis, the Portland coffee chain opened a fourth location. This time, they didn't guess — they pulled foot traffic data from the city, analysed competitor density within a half-mile radius, and modelled projected revenue based on the performance patterns of their existing stores.
The owner never did hire a data scientist. But she did promote the barista to operations manager and bought the team a Tableau license.
The numbers didn't change the coffee. They changed the decisions.
Key takeaways
- Data analytics is the process of turning raw data into decisions. It's not about tools or algorithms — it's about asking the right questions and letting data answer them.
- Four types build on each other: descriptive (what happened), diagnostic (why), predictive (what will happen), prescriptive (what to do). Most organisations are stuck at descriptive.
- The process is always the same: collect, clean, analyse, visualise, act. Cleaning takes the most time. Action creates the most value.
- Start with Excel and SQL. These two tools cover 80% of real-world analytics work. Add Tableau or Power BI for visualisation. Python is optional for most roles.
- Analytics careers are booming. Entry-level roles start at $55K+ and don't require a data science degree. Business context + technical skills = high value.
What's next
Now that you know what data analytics is, it's time to learn the tools. In the next module, SQL Basics, you'll write your first database queries — the skill that appears in over half of all data job postings. After that, you'll learn to visualize data in Data Visualization, master spreadsheets in Excel & Google Sheets, and build interactive dashboards in Power BI and Tableau.
Knowledge Check
1.A retail company generates a weekly report showing total revenue, number of orders, and average order value for the past 7 days. No further analysis is performed. Which type of analytics is this?
2.An analyst spends 3 days preparing data for a project: removing duplicates, standardising date formats, filling in missing values, and flagging outliers. A colleague says this is wasted time and the analyst should 'just start analysing.' What's the best response?
3.A marketing team wants to determine which advertising channel to invest more budget in next quarter. They have historical spend and revenue data for Google Ads, Meta Ads, email, and organic search. Which type of analytics would directly answer their question?
4.Someone with no technical background wants to break into data analytics. They have 4 weeks of focused learning time. What's the most effective learning path?
Want to go deeper?
🧠 AI & Machine Learning Master Class
Understand AI, use it in your job, and build AI-powered products.
View the full program