Mondo Interview Question: Given 100 million rows of dat... | Glassdoor.co.in

Interview Question

Data Analyst Interview Los Angeles, CA (US)

Given 100 million rows of data per day; tell us what you do

  next.
Answer

Interview Answer

1 Answer

0

We will need to review the following
Current data quality and format

Systems operations and hard requirements

Storage of RAW data
-how to consume and process

Data storage layer (transforms)
-how to import and what transforms to make

Data Model for analytics
-what metrics do we care about and at what grain (year, month, week, day).

Final display layer
-Power BI, Tableau etc.

Interview Candidate on 07-Sep-2016

Add Answers or Comments

To comment on this, Sign In or Sign Up.