Hey folks, I’m a strategy person who just got put on a data project. Can someone sum up the key strategies in generating insights from data in a couple sentences? We’re looking at huge amount of shipping data and SM wants me to come up w/ daily insights. No clue where to start.

like
Posting as :
works at
You are currently posting as works at

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.

likehelpful

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

likehelpful

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!

like

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.

like

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

like

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...

like

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.

like

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.

like

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.

smart

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

like

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.

Related Posts

Hi! I’ve been in hospitality & management for over 10 years and desperate for a career pivot. As anyone in restaurants knows, the work is ~80 hours a week and often making less on salary than your own tipped-wage employees. I have experience with training, team building, HR, financial analytics, client needs, communications and so much more. Does anyone have recommendations on a new career path or job listings to investigate??

like

got email some days back. “We are pleased to have you join us at IBM and I welcome you to the IBM Client Innovation Center”. is cic different than gbs? where are our locations in india?

like
like

Hi! I could use an accountability buddy for two things: learning Portuguese and finishing my outside of work client work. Any takers?

Confession: I used my hospital client ID today to get discounts on donuts. 😐

like

Hi Fishers,

43 days has passed in PDP with Timeline for me and there are still no projects avaliable on TMP based on my current skill set. I am upskilling my self as my Home manager asked me but this long period on PDP with Timeline is really making me nervous.
Should I be prepared for the worst and start looking for job change?
Anyone faced such an situation please suggest.
Thanks in Advance!

Post Photo
like

KPMG requiring client facing colleagues to work together for 2 days in the office and only spend '1 or 2 days wfh'....erm that works out as 3 days in the office?

likefunny

What is the average salary for analyst for client onboarding in investment banking in india

like
like

Hi need suggestions, i just joined HCL technologies noida , as a tech lead, its been 2 months only , and my reporting is to group tech manager, and he's giving me hard time to settle in and understand the project. Feeling like being pressurized to do things fast.
What should i do, i am very confused, when i start liking the project he again made some sarcastic comments and pressures me , even i am utilizing my weekends to unterstand it faster.

like

What does client facing YES means?

Post Photo
like

Anyone know any decent web developers that can quote for a project?

How to avoid immediate staffing after completing the one project?
Somebody advice on this please.
I literally need 1-2 weeks bench/off time.

like

Hi fishes,

My friend in Dxc getting calls for libertymutual , does this project is good pick

Yoe - 3.5
Tech stack - Java dev

likefunny

When you try to BS the client but they once studied history

Post Photo
likefunny

Hi all,

I am serving my notice period, I want to get released from the project. Is it possible to get released when serving notice period?

Hi Fishes,

Could someone help answer this.
I have a offer from CTS and I'm considering joining here but I've heard a lot of bad remarks regarding bench policy.

Now I'm worried whether i will get a project once I join here or will I get kicked out in 30 days if not.

Tech stack: Mulesoft

This is the first time I'm switching companies so I'm really worried about how life will be if I take the risk and join here.

like
like

I was interviewed for Angular. In JD it was mentioned Angular + Node.
I was told it's a second shift project, with MEAN technology stack.
Client is AT&T.
Anyone having idea about this?

I am a contract employee that was just brought on a month ago. I have done well with onboarding and learning their tech. I have now been asked to design an architecture for an upcoming project, and document it all. Nothing at this company has been well documented before. I have a feeling they just planning to use my previous experience and then let me go since my pay is high. Is there a way I can safeguard against this?

More Posts

Found a random engagement ring.

Hi all, so I found a platinum ring (which I assumed it's an engagement ring as it has dates and initials engraved on top.) And a Divvy tag (I have no idea what it was until I googled it. Apparently it's a bike sharing service in Chicago) in a briefcase I ordered online. I was thinking of returning the item back to the store but that wouldn't help the person who lost the ring. Attached is a picture of them.

What should I do now?

**I'm not in Chicago

Post Photo
like

What would be percentage in Bonus this year for Rating :- strategic impact in Tech consulting.
And what would be the hike percentage in salary.

like

Hi everyone! I’m trying to get into the tech field. I have some customer service experience with a tech company. I also have a certificate for IT support. Any leads or suggestions to get a job would be appreciated.

like

Can anyone give a salary range for EAs in DC? Thanks!

Going to name our first son Del, thinking about throwing in Loitte as middle name. As in Del Loitte Jones. Thoughts?

funnylikeuplifting

In dell emc, What are the things we have to declare for basket allowance as it a part of CTC. and how to declare.

Bump is now getting bigger at 16 weeks and planning on adding a moisturizer for belly. Any recommendation?Just saw an ad for Frieda mom’s pregnancy moisturizer. Anyone tried it and is it pregnancy safe?

like

OC has an issue with a financing term that deal teams worked out. Is it unethical to ask deal teams to discuss these terms and instruct us how to proceed? These seems to be business term where counsel can’t work out the differences, without business agreeing.

likehelpful

I completed all rounds of interviews with capgemini. HR took all the documents about 10 days ago. However, offer letter is not yet released. HR stating that she is waiting for client project confirmation. Anyone faced such delays ? Ans what was the final outcome?

Tag line for Monday

I want to be qualified / informed enough to be able to reasonably brand myself as an ML or/and IoT expert. (Consultant) what's the fastest way?

like

How much can you eventually make with long term career in cloud consulting? $180k-$250k?

like

After document verification how many days it takes to release offer letter in TCS

like

I'm struggling. people places and things. the place is work and the person is a co-worker. I had a few drinks yesterday. ill hit an AA mtg tomorrow. I'll keep trying.

like

How much should a shift lead make west coast

like

How much time did hsbc will take to release offer letter after 2 rounds of technical discussion?

like

Has anyone had successful using the c0ff3e thing on LinkedIn? Landed interviews/gigs?

like

Recommendation between Italy vs Spain for a 5 day family trip in late November. First time in either of the places and would like to plan based on weather and places that are open during that time

like

Additional Posts in Data & Analytics Consultants

Has anyone created live dashboards via Data Studio instead of Tableau? Thoughts?

New data offering: name.co, or namesoftware.com for the main domain? I’m leaning toward name.co, but I worry about not having the .com.

like

How would you recommend to find a data analytics job in the US? Currently a Sen Con at a big 4 in Aus

like

Any recommended courses or books on customer care/cust success analytics or marketing analytics in general?

like

Anybody interviewed for a data engineer role for Facebook? I have a SQL and Python coding interview next, any idea on what to expect?

like

What are the dream companies to work for to pursue data analytics/ engineering jobs

like

Anyone good in MySQL?? I’m struggling

like

I'm non US citizen and thinking of moving back to EU. My plan is getting remote opportunities across the world and work as a freelancer. My speciality is Data analytics and BI (Qlikview, Tableau). 1) How likely I can get a gig from the US? 2) if a job looking for a remote 2-3 months contract do they care what country I'm in? 3) how can I compete Indian rates as I'm in Europe 60-70$ per hour as a BI consultant is a good rate but I see online rates as low 10$😫?

like

Anyone works/heard of DMV Group? Mind if i shoot some questions about them?

Anyones firm still hiring entry level, under 1 YOE. In Chicago?

like

Is it realistic to join KPMG Lighthouse or Gamma without a Masters degree but with previous experience as a data scientist at a big data startup?

Anyone in a non-technical analytical consulting roll?

like

Docket + R - I have an container running a rocker image and I’m trying to launch a bash terminal and the RStudio server (/init) at the same time. Is this possible? I tried adding CMD [“/init”] too.

like

What approaches have you used to enforce data consistency for ML services? System and conf tests can be written definitively for SW applications but it becomes challenging when Data variability exists ?

like

How advanced in SQL are users here? I feel like I’ve “plateaued” and am worried about not developing further in SQL skills.

like

What are the top sales & marketing metrics that tech companies track? I have an interview for a Data architect role and the data aspect is my strength but need to brush up on the business insight part

like

EY is hiring for various senior level positions in Data & Analytics practice. (Staff-2, Senior, Manager etc). Please DM me in case you have any questions and I’ll be happy to refer in case you have a relevant experience.

like

Can anyone at Ford Motor Company tell me more about the “Learning Analytics and Engagement Specialist” remote position? Very curious and would love a referral!

like

In the most unnecessarily complicated phrasing worthy a dissertation, what are you working on this week?

like

What’s the different between business analyst and data analyst? Sometimes I see them merged or people say “business/data analyst”

like

New to Fishbowl?

Download the Fishbowl app to
unlock all discussions on Fishbowl.
That was just a preview…
Sign Up to see all discussions
  • Discover what it’s like to work at companies from real professionals
  • Get candid advice from people in your field in a safe space
  • Chat and network with other professionals in your field
Sign up in seconds to unlock all discussions on Fishbowl.

Already a user?
Login here

Share

Embed this post

Copy and paste embed code on your site

Preview

Download the
Fishbowl app

See what’s happening in your industry
from the palm of your hand.

A phone with Fishbowl app

Scan your QR code to download
Fishbowl app on your mobile

Download app

Sign up for free to view this conversation on Fishbowl

By continuing you agree to Terms of Use and Privacy Policy

Already have an account? Log in

Sign up for free to continue using Fishbowl

By continuing you agree to Terms of Use(New) and Privacy Policy(New)
Messaging rates may apply

Already have an account? Log in

For account settings, visit Fishbowl on Desktop Browser or

General

Legal