Related Posts
More Posts
Bowl Leader
Bowl Leader
Happy Diwali! What’s everyone making today?
Rising Star
Pro
Rising Star
Is everyone ready for Ramadan 😆🥳🙌🏽
Additional Posts in Data & Analytics Consultants
Bowl Leader
Mentor
New to Fishbowl?
Download the Fishbowl app to
unlock all discussions on Fishbowl.
unlock all discussions on Fishbowl.
When in doubt, dump it in Tableau and create a few charts. Send out for internal review and people will respond with what they want to see. Make updates, highlight your collaborative agile iteration approach, and voila.
Use trifacta for the etl. Get the mess 🧹 cleaned up
There’s only so much you’ll get from randomly exploring data, though that approach will at least orient you to the structure of it. I’d start with a basic pivot table and see how whatever key metrics you have change across different dimensions. Not the sexiest visual but might help you quickly observe some pattern and give a hint where to focus next.
You really need a shortlist of hypotheses to test. Without that you’ll be shooting in the dark
Think about it through your strategy lens - what would you want to know/act on in order to gain strategic advantages, cut costs, gain efficiencies? Then dig in the data to see what you find that supports or refutes those initiatives. Insights should be actionable, otherwise they’re just measurement. 😊 Good luck!
OP, I am a former strategy consultant, now lead analytics teams. Considering you work in strategy, you should know this already. Think hypotheses, than data.
Start with a broad problem statement. Break it down into smaller issues. Use data to validate your hypothesis.
It’s easy to get overwhelmed if you do not follow this approach.
Start with what questions you want answered. “Start making charts” is probably not great advice if you have no idea where you want to end up
Try to make each dash/visual answer a question that’s pertinent to the client
Agreed, but sounds like there is no question from the client. Hence my suggestion to make something and send out for feedback. Force that guidance since the “Strategy OP” doesn’t know where to start...
Then I’d start asking questions of what the team or client wants and then figure out if you can answer given what you have. You can’t just hit an insights button.
- What is the 48 hour shipping capacity
- is there a choke point in the supply chain
- does weather impact delivery
- etc
I have no idea what shipping data is made up of I’m just spitballing. But you need to get those kind of questions and then you can deliver your insights.
When you say huge amounts of data what does that mean in terms of the actual number of records? Maybe start with some simple forecasting, the Holt-Winters method is one of the easiest to understand and apply.
1. Establish a Current state. (Look back three+ years in your data set to illustrate a trend, find gaps/areas for improvement)
2. Identify the Future state. (What is the problem that the client is trying to solve? Where does solving that problem get them to? Perhaps support this by building a model and conducting a sensitivity analysis.)
3. Build out the tactics to get there and support with the analyses that you have done + industry trends
4. Build a business case with any financial data that is available to you. Cost, revenue, etc.
Step 1: start with the questions
Step 2: stare at the questions
Step 3: pick the right questions
...
...
Step N: show insights that answer the questions
When in doubt look for outliers and dig in
I've worked on something similar. (Transportation and shipping data graphs etc). You can ping me OP. Also, I'm curious about your project/work. Perhaps we can connect via Deloitte chat too and I can help you in any way possible.