Cracking the Data BA Code — A Cheatsheet

Analysts looking over charts, trying to make sense
What Stories Does the Data Tell? Image credits- <a href=’https://www.freepik.com/vectors/business-statistics'>Business statistics vector created by freepik — www.freepik.com</a>
Cheat Sheet Image credits- <a href=’https://www.freepik.com/vectors/paper-icon'>Paper icon vector created by rawpixel.com — www.freepik.com</a>
  1. What is the purpose of collecting or analysing this data? What are the business questions this data will help us answer?
  2. What is the source of the data? How will they send data? What is the frequency of the data? What is the expected quality of the data-at-source?
  3. Is the single source of data enough to be useful? Do we need to “blend” data in from other sources or get it from some third-party sources?
  4. Is it a go-forward ingestion or do we need to ingest history?
  5. What transformations does this data need to go through? What cleansing or validation would need to be in place?
  6. What are any applicable compliance or regulatory requirements around this data? How would we honour those requirements, when we receive requests to delete the data?
  7. How frequently and with what concurrency will the data be accessed, once we ingest it?
  8. What partitioning would we need to consider? What sort of queries are the most expected, to help guide the partitioning strategy?
  9. What should the strategies around managing governance, auditing?

--

--

--

Product analyst. Agile enthusiast. ThoughtWorker. Wrote a book. Behind 9 products gone live!

Love podcasts or audiobooks? Learn on the go with our new app.

Recommended from Medium

Requirements Creep In Software Engineering

Image Representing Creep vs Stacked Architecture

The 5 Easiest Ways to Manage Salesforce Continuous Integration

This Week in Atomist — 17th January, 2017

For Docker containers, how to choose between .Net Core or .Net framework?

What is an API?

Sniffing Creds with Go, A Journey with libpcap

Configuring Httpd server on docker container and setting up a python interpreter on docker…

Test to see if my Medium loads to my Facebook

Get the Medium app

A button that says 'Download on the App Store', and if clicked it will lead you to the iOS App store
A button that says 'Get it on, Google Play', and if clicked it will lead you to the Google Play store
Abhishek Mishra

Abhishek Mishra

Product analyst. Agile enthusiast. ThoughtWorker. Wrote a book. Behind 9 products gone live!

More from Medium

15 Best Data Lineage Tools 2022 | Reviews & Comparison

Can data quality issues be exploited as opportunities?

Data Career Growth — Needs, Skillset, Responsibilities & Roadmap

Data PM Intro