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

Learning Code Readability

Hello everyone it's with pleasure I disclose to you that @CreatorCTR has partnered with @MetisDAO…

Deploy a React App on Cosmic JS in 3 Easy Steps

Why BizDevOps (DevOps 2.0) Is Not a Mere Trend

Back2Basics: Limit which classes a Trait can be mixed into!

knoldus-advt-sticker

Como monitorar o Kafka utilizando o Metricbeat

How to Create Your Own Smart Zoom Status Light

A Day in the Life of a Software Engineer at a Startup

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

Data 101: Clean data vs unclean data

Getting Started with Master Data Management

Engineering the Data World

What Exactly is Big Data?

What Exactly is Big Data? — abstract illustration