Check if your database has them too — In my previous article, I discussed 4 BigQuery SQL shortcuts that can simplify your queries. Since then I discovered 6 more useful SQL functions I wished I had known earlier and that I’d like to share today. 1. GENERATE_ARRAY The GENERATE_ARRAY function allows you to create an array with a start and…

Check if your database has them too — The most common advice when you start learning SQL is to practice the basic statements because they’ll work across multiple databases. The downside is you may never discover database-specific syntax that can simplify your queries because there’s never any need to read the documentation. …

What’s a data mart and why data scientists should use one — As a data scientist, you can spend up to 80% of your time cleaning and transforming data in order to generate actionable insights and build machine learning models to create business impact. Now imagine a world where you can spend more time on analysis and model development instead of cleaning…

A marketing case study — In a previous article, I discussed reasons why your dashboards are ignored but how do you decide if you should create a dashboard or an ad hoc report for stakeholders. Today I’d like to discuss a marketing dashboard I created that was widely adopted by the marketing team and the…

And what to do instead — When I first became a data analyst I made my fair share of mistakes dealing with stakeholders. Today I’d like to share my experience and what I learned to give you a head start on how to work effectively with your stakeholders. 1. Don’t assume stakeholders know what they want I was once asked by a stakeholder to…

Tips to generate relevant and actionable insights — Data storytelling is an important soft skill to develop as a data professional but there’s not much information to guide you on where to start. When I first became a data analyst I didn’t have a clue how to approach this. …

What to expect as a product analyst — Gartner predicts that “by 2023, 75% of organizations selling direct to consumers will offer subscription services”. Subscription businesses aren’t going away and you’re likely to work with this type of business model in the future. …

No statistical significance can still yield valuable insights — When I first became a product analyst I assumed product experiments were similar to ones I evaluated as a marketing data analyst — but I was wrong. When a marketing A/B test wasn’t statistically significant, we moved on to the test but after working on product A/B tests, I realized…

What to expect as a product analyst — When I first became a product analyst, I thought it would be an easy transition from my prior data roles supporting marketing. Little did I realize there was a learning curve with product analytics. …