I used to believe in full data transparency. Put all data out there even in its rawest form with little context. If someone cares enough, they’ll ask about it. But over the years, I realized I was shirking responsibility and pushing it to others. The data team should help stakeholders get business value. And that … Read more
Fivetran and Stitch are great. They extract your data from lots of popular software tools and databases. And they load it into your data warehouse, where you can transform, model, and enrich the data. But you need data from a less popular tool. Managed ELT services like Fivetran and Stitch may not support the tool’s … Read more
You want to be a thought partner for your stakeholders. To consult on how data and analytics can solve business problems. But what if you aren’t consulted early enough? You can get stuck supporting a duct tape solution you had no input on. We’ve all been there. And it’s no fun at all. So, how … Read more
Your data and analytics team serves stakeholders from various departments. How do you choose which projects to work on?
Is it cutting corners or is it overkill?
Collaboration is important for many teams. But it’s really hard if teammates haven’t agreed on what quality looks like.
When your data team is growing, the way you did support before won’t cut it anymore. You don’t want this work to balloon and not leave enough time for the team to work on longer term important projects. When I led a small team of three, it was easy to establish a strict separation of … Read more
You want to strategically engage your stakeholders and move beyond simply responding to requests and providing a service. You want to align your project outcomes with business outcomes. But, it’s not always easy to do. You’ll need to build trust with your stakeholders – to show them the data team is capable and is aligned … Read more
Your colleagues regularly come to you for help with their SQL queries, leaving you less time than you’d like for your own projects. And, your colleagues have already done the basic online tutorials. How can you help them upskill their SQL knowledge so you can spend less time on support and more time on project … Read more