Data engineering & analytics
Turn analysis into a decision-ready story
Frame the question, pick metrics, present insights and recommendations to stakeholders.
~10 focused hours·beginner
Tools: PowerPoint/Google Slides, Power BI/Tableau, structured writing frameworks (Pyramid Principle)
Market relevance — share of job ads asking for this
What employers mean
You should be able to…
- Frame a fuzzy business question into a specific, answerable analytical question
- Pick 2-3 metrics that actually matter instead of dumping every number available
- Lead a slide/doc with the recommendation, not the methodology
- Choose the right chart for the claim and strip chartjunk that distracts from it
- Anticipate and pre-empt the first three questions a stakeholder will ask
- Distinguish correlation from causation and flag it honestly when uncertain
- Write a one-paragraph executive summary that stands alone without the deck
Needs first: Build dashboards that answer business questions
Learn — free, link-checked
The few resources that matter
Read · beginner · 40 min · storytellingwithdata.com
storytelling with data — blog
Before/after chart makeovers that train you to cut clutter and lead with the takeaway, not the data dump. — Cole Nussbaumer Knaflic / SWD
Watch · beginner · 240 min · youtube.com
Data Analysis with Python - Full Course for Beginners (Numpy, Pandas, Matplotlib, Seaborn)
End-to-end messy-CSV-to-chart workflow that doubles as practice for turning a wrangled dataset into a visual story. — freeCodeCamp.org
Course · beginner · 300 min · khanacademy.org
Statistics and probability
Free, self-paced stats foundation so the claims in your story (and your A/B test readouts) survive scrutiny. — Khan Academy
Practice
One-page decision memo from a churn dataset
Take a public churn dataset (e.g. Telco churn) or your own cleaned NBFC/loan data, run the analysis, then produce a single-page executive memo (not a 20-slide deck) that states a recommendation, the 2-3 metrics backing it, one honest caveat about data limitations, and a proposed next experiment.
Done when
- Memo fits on one page/slide and leads with the recommendation in the first sentence
- Exactly 2-3 supporting charts, each with a title that states the takeaway, not just the metric name
- Includes one explicit caveat about a confound or data limitation
- A different person (peer review) can read it in under 2 minutes and repeat back the recommendation correctly
Prove it
Evidence a recruiter can check
- Public repo or PDF of the one-page memo alongside the analysis notebook that produced it
- Before/after chart examples showing a raw chart vs. your cleaned-up, story-led version
- A recorded 2-minute 'present this to a VP' video walkthrough
Interview
Questions you'll get asked
- Tell me about a time your analysis changed a business decision. What was the recommendation?
- How do you structure a slide when the data doesn't support the answer stakeholders want?
- Walk me through how you'd present a metric that dropped 20% last month to a nervous VP.
- What's the difference between a report and a story, in your own words?
- How do you decide which chart type to use for a given claim?
- Give an example of an analysis where you had to say 'we don't have enough data to conclude X.'
- How do you handle a stakeholder who wants every number on one slide?