Overview

1 What does an analyst do?

This chapter introduces analytics as the practice of using data to uncover and communicate patterns, trends, and insights that inform decisions. It highlights the many paths into the field and the blend of mathematics, programming, and business context required to deliver value. Beyond technical capability, the chapter emphasizes communication, stakeholder alignment, and practical judgment as essential skills that are often under-taught but crucial to an analyst’s effectiveness and growth.

It surveys common analytics domains and their typical deliverables. Business intelligence focuses on defining metrics and KPIs, producing dashboards and reports, and tailoring communication for non-technical stakeholders. Marketing analytics applies experimentation (such as A/B testing), attribution modeling, and competitive analysis to optimize acquisition and engagement. Financial analytics tracks core financial metrics, quantifies risk, and builds forecasts to guide planning. Product analytics supports R&D and product teams with opportunity sizing and rigorous experimentation to improve user experience and business outcomes. The chapter underscores that these domains overlap and evolve, and individual roles often blend responsibilities.

The chapter also outlines an analyst’s core toolkit: spreadsheets for quick manipulation and sharing; SQL and data warehouses for accessing and shaping tabular data; a statistical programming language (commonly R or Python) for analysis and modeling; and visualization tools for creating static visuals and dynamic, self-serve dashboards. It encourages choosing tools that match team norms and stakeholder needs, and continuously augmenting the toolkit to reduce manual work. Finally, it prepares readers for real-world expectations—varied career trajectories, demonstrating value, managing ad-hoc demands, and avoiding the “analytics fallacy” where simple outputs mask complex effort—setting the stage for building both technical and interpersonal skills that drive impact.

Welcome, fellow data human! We have a lot of great topics to cover together, and we’ll do so in as light-hearted and fun a manner as possible.
Line graph of a support team KPI with a threshold for the service level agreement (SLA) for resolving tickets in less than 12 hours. Metrics and KPIs generate value when tracked over time.
A dashboard typically contains summary information and the highest-value visualizations for quick interpretation.
Example of two conditions in an A/B test varying the location of the Subscribe button. Small, iterative variations like this can significantly improve user engagement and revenue.
Attribution model showing first/last touch and example intermediary steps. Each model breaks down the sources at the touchpoint to understand which is most successful at generating new customers.
A revision of Figure 1.2, with a 3-month rolling average forecast. Forecasting methods range from simple calculations such as this one to more complex time series modeling approaches. A simple forecast like the above will typically have less variability than the actual data.
Concentric circles showing common areas of overlap according to categories of deliverables provided by different analytics teams.
Don’t underestimate the value of a spreadsheet for easy analysis and sharing!

Summary

  • There is a wide range of analytics domains (e.g., marketing analytics, product analytics). Each has a standard set of workflows and deliverables and unique methods to solve problems within the function.
  • Analysts typically use spreadsheet tools, querying languages, programming languages, and data visualization tools to complete their work and develop deliverables for stakeholders.
  • Being successful as an analyst involves more than producing the output assigned to you; it involves strategic stakeholder communication and alignment to create value over time.

FAQ

What is analytics?Analytics is the practice of using data to discover and communicate patterns, trends, and insights that inform decisions. Analysts apply methods such as descriptive and inferential statistics, statistical or financial models, and domain-specific techniques to interpret data and guide action.
How do business intelligence (BI) and business analytics differ?Business analytics focuses on applying analysis and statistical methods to business questions, while BI is often a broader umbrella that can include data engineering, governance, mining, and machine learning. In practice, organizations use the terms interchangeably. A key distinction is that BI primarily supports internal operational decision-making.
What are the core responsibilities of a business intelligence team?Common responsibilities include defining and tracking metrics and KPIs, producing reports and presentations that surface actionable insights, building interactive dashboards for self-serve consumption, and tailoring communication to stakeholders’ data literacy. Teams often use BI tools (e.g., Tableau, Power BI) with regularly refreshed data.
What is A/B testing and why is it used?A/B testing is an experiment that splits users into control and variant groups to test a specific change (e.g., button color, copy, layout). It helps teams measure causal impact on outcomes like clicks, conversions, or engagement using standard statistical tests, enabling iterative, evidence-based improvements.
What is attribution modeling?Attribution modeling estimates how much credit each touchpoint (e.g., ad click, landing page, free trial) gets for a conversion. Approaches range from simple first-touch or last-touch models to multi-touch and algorithmic methods. Results highlight which channels or steps contribute most to acquisition.
What does a financial analytics team typically do?They monitor core financial metrics (revenue, profitability, customer lifetime value), assess risks via simulations and forecasting (e.g., churn, cost increases), and build financial forecasts using historical trends, seasonality, organizational factors, and economic indicators. Specializations vary by industry (e.g., risk analysis in finance).
How distinct are BI, marketing, financial, and product analytics?These fields significantly overlap in methods, deliverables, and stakeholders. Boundaries often blur and evolve within organizations. Early-career analysts may work across domains; over time, they tend to specialize based on team needs and accumulated domain expertise.
What tools belong in a data analyst’s toolkit?Essential categories include: spreadsheets (for quick manipulation, sharing, and lightweight visuals), a querying language like SQL (to access and shape data in warehouses with tables, views, and schemas), a statistical computing language (e.g., R or Python; or SAS/SPSS in some orgs), and visualization tools for static charts and dynamic dashboards. Over time, automation and additional tooling amplify impact and efficiency.
When should I build dashboards versus static reports?Use dashboards when stakeholders need to revisit the same analyses over time with updated data, drill into subsets interactively, or answer predictable recurring questions. Static reports and presentations suit one-off narratives, formal readouts, or when interactivity isn’t required.
What career trajectories can data analysts pursue, and what should they expect?Analysts can grow as technical specialists or managers and branch into areas like data science, data engineering, research, or technical communication. Success also depends on soft skills: managing stakeholder expectations, communicating timelines and processes, and articulating value (avoiding the “analytics fallacy” that simple outputs imply simple work).

pro $24.99 per month

  • access to all Manning books, MEAPs, liveVideos, liveProjects, and audiobooks!
  • choose one free eBook per month to keep
  • exclusive 50% discount on all purchases
  • renews monthly, pause or cancel renewal anytime

lite $19.99 per month

  • access to all Manning books, including MEAPs!

team

5, 10 or 20 seats+ for your team - learn more


choose your plan

team

monthly
annual
$49.99
$399.99
only $33.33 per month
  • five seats for your team
  • access to all Manning books, MEAPs, liveVideos, liveProjects, and audiobooks!
  • choose another free product every time you renew
  • choose twelve free products per year
  • exclusive 50% discount on all purchases
  • renews monthly, pause or cancel renewal anytime
  • renews annually, pause or cancel renewal anytime
  • Effective Data Analysis ebook for free
choose your plan

team

monthly
annual
$49.99
$399.99
only $33.33 per month
  • five seats for your team
  • access to all Manning books, MEAPs, liveVideos, liveProjects, and audiobooks!
  • choose another free product every time you renew
  • choose twelve free products per year
  • exclusive 50% discount on all purchases
  • renews monthly, pause or cancel renewal anytime
  • renews annually, pause or cancel renewal anytime
  • Effective Data Analysis ebook for free
choose your plan

team

monthly
annual
$49.99
$399.99
only $33.33 per month
  • five seats for your team
  • access to all Manning books, MEAPs, liveVideos, liveProjects, and audiobooks!
  • choose another free product every time you renew
  • choose twelve free products per year
  • exclusive 50% discount on all purchases
  • renews monthly, pause or cancel renewal anytime
  • renews annually, pause or cancel renewal anytime
  • Effective Data Analysis ebook for free