PinnedMember-onlyWelcomeIt’s nice to meet you — About Me Hello and welcome! My name is Vicky and I’ve worked as a data engineer, data scientist, and most recently a data analyst. I started writing to discuss my experiences and provide advice I found lacking during my data analytics journey. …Data Science3 min readData Science3 min read
Published in Towards Data Science·Jan 26Member-only4 Useful BigQuery SQL Functions You May Not KnowAnd how to use them — As a long-time SQL user, I’m always looking for ways to make it easier to analyze data with SQL. In a previous article, I reviewed 6 BigQuery SQL functions I wish I had known earlier, and today I want to share 4 more functions I hope you’ll find useful. 1. PERCENTILE_CONT PERCENTILE_CONT…Sql4 min readSql4 min read
Published in Towards Data Science·Nov 22, 2022Member-onlyBigQuery SQL Procedural Language to Simplify Data EngineeringAn introduction — As a long-time SQL user, I’ve often had to run the same code over and over with minor changes in my where statement. In programming languages such as Python, this copy and replacement wouldn’t be necessary because I could create a function to pass in different parameter values to rerun…Bigquery4 min readBigquery4 min read
Published in Towards Data Science·Sep 23, 2022Member-onlyBigQuery SQL Functions For Data CleaningUse cases and functions to apply — Data cleaning is an essential part of any data-related position whether you’re a data engineer, data scientist, or data analyst. Today I want to share a few BigQuery SQL functions for data cleaning and a use case I would’ve used them for. Invisible Special Characters In String Values String values can contain special characters that don’t…Sql5 min readSql5 min read
Published in Towards Data Science·Jul 27, 2022Member-only6 BigQuery SQL Functions Every User Should KnowCheck 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…Sql4 min readSql4 min read
Published in Towards Data Science·Jun 8, 2022Member-only4 BigQuery SQL Shortcuts That Can Simplify Your QueriesCheck 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. …Sql4 min readSql4 min read
Published in Towards Data Science·May 21, 2022Member-onlyHow Data Scientists Can Reduce Data Wrangling Time with a Data MartWhat’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…Data Science5 min readData Science5 min read
Published in DataDrivenInvestor·Apr 30, 2022Member-onlyHow to Create a Dashboard Stakeholders Want To UseA 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. …Business Intelligence4 min readBusiness Intelligence4 min read
Published in DataDrivenInvestor·Apr 16, 2022Member-only3 Mistakes Data Analysts Should Avoid With StakeholdersAnd 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…Data Science3 min readData Science3 min read
Published in Towards Data Science·Mar 28, 2022Member-onlyMy 3-Step Method to Create a Story With DataTips 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. …Data Science4 min readData Science4 min read
