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

Need advice from the forum as I am confused between the two offers. Thank you in advance.

Currently working as Business Consultant + Project Manager w midsize tech consulting firm : 12 YOE + current TC 125k

Offers :
1. Local Bank >> Business Change management role (COO org) >> 152k Base + 30k bonus(to be paid in March 2023) + challenging work culture + 3 months NP

2. Global Bank >> BA + PM role (CTO org) >> 160k Base + 20k bonus( to be paid in Mar 2023) + Regular work culture + 2 months NP

like

Has anyone moved states and changed their home office / region? (Personal choice not project driven)....If so, what's the process? What approvals are needed?

like

Most of my bowls are currently all about lay-offs and long times in between client projects, regardless of industry/function. Am curious if we sustainability folks are feeling it as much as the rest of our businesses? Have you seen steep drops in commercial activity or do you feel the upswing in ESG continues to buck the trend?

like
like

I’ve very fortunate to have a new job. I wanted WFH, but I guess it wasn’t in the cards. Do you think people who work from home are that much happier?

likesmarthelpfulupliftingfunny

Would you suggest someone pursuing an MBA if they want to get a role in HR or Project Management? And for those that want to pursue product management... are there still a decent amount of numbers similar to accounting? Thanks

like

I am the president of our school board at Franklin Country School Corporation in Brookville, In. I would like to start a NASA Stem project starting in school year 2022-2023. Does anyone know where I need to start?

likehelpful

What is one blunder you did in your project which broke something in prod? 😄

like

Hello,
I am Interior Designer & Contractor, looking for opportunity to work for Home/Office interior project

Ours is Family owned business, 3 decades of experience and personally 15 years of Experience, working on High End Luxury projects

Hoping to hear good

Thanking you

like

A quick check. How many of you got the project after joining in coforge? If you got the project is it same client which was promised while interview process? Please respond.

Telco PMs, how do you call that type of project in which you manage the End-To-End deployment? I mean from planning the electric connections for a servers rack, engineering the network, the cabling and devices installation, setting up the link (and everything in between)?

English is not my first language and I'm having trouble coming up with what we call "Llave en Mano" in Spanish... or is it just End-To-End? My mind is fried and is only Wednesday.

Thanks!

like

I've become really jaded about consulting. I find all so often you need to tell the client what they want to hear to keep their business and I feel like so much of the what I recommend doesn't actually get implemented. I'm looking to make a career switch so I can both create and execute on my strategies. A product management path seems very promising for this.

Does anyone who switched from consulting to product management have any recommendations of h helpful PM books, courses, or programs?

like

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

like

How to get released from current project in Wipro.

like

Anyone in RSM TMT TAS group? How is the exit opportunity/hours/pay/wlb/turnover? Joined B4 as an A2 in audit last year. Tired of audit hours and the industry I’m currently in. Heard about advisory having better hours but it also depends on the office and client.

like
like

I'm currently interviewing for Director of Digital Marketing and Demand Gen roles. I have all the competencies required and can demonstrate all the skills through examples from my experience.

The issue I keep getting stuck at is my lack of people management experience. I have some people management from early roles, led project teams, agencies, and currently mentor people in the company. However the feedback is always lack of people mgmt exp.

Any tips on getting how to flip the narrative?

like

Ideas please:

I’m inheriting a “team” of siloed strong individual developers who are on different work streams and are very jaded and struggling with motivation. Most are contractors. They have legit gripes about the client, but I won’t be able to solve those without getting cross-discussions going with knowledge-sharing across our “team“. Any suggestions for remote team-building that won’t just be shrugged off with cynicism, or worse, ignored?

like

More Posts

Day 1 back on the beach after 💀 project. Feel like I've lived more life in the past day than the whole last month! already so reenergized 😜😜😜

like

What's the bench policy at IBM ? For how long one can stay in bench.? How much time it will take generally to get the project/assignment. IBM Tata Consultancy

like

How is the job security in accenture, i am switching to accenture on new technology which i learnt my self. I will try my best to.perform well, if i dont meet thier expections will i be put on bench or in PIP.
Exp 4

like

I am working as React Develpor in IBM ISL(India software Labs ) with decent WLB. Recently got an offer from EY GDS with 30 percent hike. Role : Senior Technical lead .
Being a married female, i am little bit concerned about WLB in long term.
I have heard in EY they tag you in more than 1 project.
How is the quality of work and team management .
Need some inputs , do give some insight.

like

I have an interview for a remote care management nursing position today. Does anyone have any feedback relating to interviewing for this type of a nursing role? I have a lot of nursing experience but was wondering if any of you have experience in this role and any advice etc for me.

like

🐠, what are you binging on Netflix or Amazon Prime this weekend? Need new ideas. Not a big horror or sci-fi fan but willing to try if not too far out. Added Inbetweeners to my list thx to prior post.

like

currently in tax, thinking about trying to switch to advisory. anyone done this and have any advice? would i get a pay cut and/or lose my senior associate title?

like
like
like

other than Big 4, what other firms have good FDD groups??

like

I left PA earlier this year for a manager level financial reporting role. It was a lateral move but would’ve been up for senior manager promo in July had I stayed in PA. I was approached with another opportunity as Sr Manager Financial Reporting at a public company for $150k and 20% bonus with a clear path to director in time. 8 YOE and live in FL. I’m trying to get an idea if this is in line with market. TIA!

like

The last guy I was with is back with his ex girlfriend. I know he’s been unfaithful to her for years. Ways to tell her? Or just let karma get him eventually? I’d just want to know if I were her.

like

Hey guys ,
I was a fresher when i joined wipro
My manager has given me rating 1 in confirmatory appraisal on may 18 may which happened after completion of 1 year at wipro.
I raised the issue of rating with my manager immediately , he convinced me not to worry , ratings are already submitted , I asked him to resubmit cause i don't deserve rating 1
So he said he will look if that is possible but didn't changed .Now after 3 months they are pressurizing me to put a resignation,what should i do?

like

@McGraw Hill any idea on salary for academic design roles ?

likehelpful

I'm working as a servicenow qa ...I would like to learn servicenow development...please someone guide me on this..And any helpful resources to learn development.

like

Epam anywhere or Capgemini guys please suggest , Java developer having 8years of experience.

like

Starting a new fully remote role Monday with a leader that has never had their own admin, let alone an exec assistant. Any suggestions for developing the relationship or training them to properly use an exec assistant?

like

Checking to see if there are any wine & spirits label designers here. I have a call with a mom/pop restaurant tomorrow who want a redesign of one of their vodka labels. They have not supplied any hi res art yet & from what I’m assuming they will not be looking to spend big bucks. Im trying to get a sense of pricing for the front & back label. Thanks for your feedback!

like

Looking for a therapist, ideally in person, lower Manhattan and CIGNA. Any recommendations?

like

Additional Posts in Data & Analytics Consultants

Anyone in a non-technical analytical consulting roll?

like

I’m a college student studying data science. I’m interning at Deloitte currently is to become a data science consultant for non-profits. I don’t know if this is a role that even exists, let alone how I would start down that path. Any tips or advice would be greatly appreciated!!

like

This might be a long shot ... but I have a Statistics assignment due for tonight in a few hours

Does anyone know how to do Linear Discriminant Analysis with more than one predictor - by hand? I know how to compute in R but my professor wants it done by hand .... fml

likefunny

Does accenture have proper data science projects? Seems like most of projects are pretty basic analytics, reporting, and/ or ETL

likehelpfulsmart

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

Anyone have a ballpark range on dataiku price per seat or however they price? It looks like an interesting product.

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

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?

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

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

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

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

Just curious?

How many people have actually built a rigorous Model for clients? In this consulting/analytics consulting settings, do clients actually trust us as a modeling expert?

🤯🤯

could i dm someone to criticize/suggest feedback on my resume? i’d like to believe i have good experience but unsure why im not receiving any bites

like

Do any of the top consulting firms have analytics roles (preferably not super technical) that don’t require weekly travel?

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

How is the Deep Learning specialization on Coursera?

What’s so good about the Georgia Tech OMSC and OMSA? Is it just the cost? Seems to be recommended by most of reddit

likehelpful

I have created Algorithmic Product/System for the client to take out inventory not-in-demand for long time to save storage expense and also provide an approach to prioritize Work Orders based on Market Demand. It’s more like an Manufacturing Plan. I want to get into Product Analyst/Lead role. What approach I should take? Any books to start with? Any events to attend? Any groups to join?

like

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

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