Improving data skills

How could you improve with information? As in, when you fabricate dashboards or do investigations, how do you have any idea about what to search for?

I’ve been attempting to get these abilities, so when I google, the general prompt is to learn SQL or sort out some way to utilize Amplitude. I know to utilize both, so the issue isn’t the device, however much it is me being a deer caught before the headlights.

This is influencing my capacity to precisely evaluate the accomplishment of the stories I’ve as of now sent off. I’m apprehensive this would be a major blocker as I scale in my profession too.

It would be truly extraordinary if you would assist with directing me on this. I’m confounded.


At a high level, you have to understand what you are trying to drive… are you looking to increase sales? Are you looking to drive customer engagement etc.? Now, how can you measure how your product impacts whatever it is you’re trying to drive? How can you work with Eng/data to ensure you’re measuring the right things to get this data? This is a collaborative discussion. Your job is to ask the right questions to get all these answers. Start at the top and figure out what the business needs and work from there. You don’t need technical chops - you need to be able to talk to people and let them guide you to where you’re trying to go.

  1. Look at success metrics for your product - this could be revenues, costs, MAUs etc.
  2. Segment your metrics into one or more segments - could be based on user age, demographics. This is both for ease of understanding and communication to your stakeholders.
  3. Every time a metric moves up or down, construct an issue tree that lets you deconstruct which segment is moving up/down and why. Look into how McKinsey does their issue trees, you can find some insights there.
  4. The “what” you are looking for is the collection of mutually exclusive and collectively exhaustive metrics that eventually drive your success metrics up/down based on your issue tree. Basically, the numbers that you end up on should you ask “why” for everything and keep moving deeper.
  5. Edit: The metrics that you choose for analyses are a “larger” pool than what you make a dashboard on. If 80% of your success metrics can be tracked with 10 features, then those 10 features are what you build your dashboard with. It will not answer all your questions, but will provide an easy way to answer most of your questions.

Find the metrics that drive the initiatives you’re currently pushing. That could be anything from CAC to MAU. Using these metrics establishes a baseline, what success looks like, and what failure looks like in relation to your initiative. Track these metrics as you go along to gauge your performance using the system you have laid out. Does doing X move the metric into the positive? Keep at it! Does doing X move it into the negative? Reevaluate or dig deeper into why that is the case.

1 Like

Agree, the key is understanding the bigger picture first and what outcome you’re trying to achieve. Afterwards, use the appropriate method for you/company to query the data.

Here’s an article that might help with the bigger picture thinking when it comes to analytics -

This topic was automatically closed 180 days after the last reply. New replies are no longer allowed.