David ValenciaFeb 11, 20211 min readAdobe Analytics Implementation Interview QuestionsAre you familiar with a global reporting suite -have you ever been involved in that transition? Do you have any experience in Adobe...
David ValenciaFeb 11, 20212 min readWeb Analytics Interview QuestionsAnalytical Skills How would you model the estimated monthly visits on [insert domain].com for 2021 to 2025? How would you calculate...
David ValenciaFeb 11, 20211 min readHow to Parse URL Query Parameters using SQLThis is a simple pseudo code template for parsing query parameters from URLs. SELECT url, substr(url, locate('qsp1', url, 1) + x,...
David ValenciaFeb 9, 20211 min readQuality Assurance for Data & Analytics ProjectsCheck if your results are sensible: Does your data, insight, or graph makes sense? Based on what you know about your data and/or business...
David ValenciaFeb 6, 20211 min read4 Maxims for Analytics TeamsDon't suffer in silence: As soon as you get stuck, ask for help! It's likely someone else on your team has encountered the problem...