Advanced SQL for analysts is different than advanced SQL for other tasks (like DBAs). I will be concentrating on SQL that will be useful to you as an analyst. This is not an exhaustive list of SQL functions and features, but ones that I have found useful in my work as an analyst.
Getting Started With BigQuery
With BigQuery, you can store data securely with high performance and nearly unlimited growth. It is perfect for data analysis.
Multi-Channel Attribution R Shiny App For Google Analytics
Not everyone needs to be concerned with multi-channel attribution. If it makes up a very small part of your business, it might not be worth it. However, if you want to get a better understanding of the value of your traffic channels and the transactions/revenue they bring in, you might want to give it a go.
How to Analyze Your A/B Tests Using R
A/B tests are one of the best ways to optimize your website. However, it is not a magical cure for websites that are:
- Poorly Conceived – Website is off-brand or there is a major disconnect with users.
- Poorly Designed – Website is designed in a way that is hard to maintain/confusing.
- Poorly Developed – Website has a lot of code bloat or inefficient code.
- Using Sub-Par/Inflexible Technology – Website is created with technology that allows for very little optimisation or growth.
Creating a Predictive R Shiny App For Google Ads
In this post I am going to go through the code for a relatively simple R Shiny app. It will predict Google Ads transactions and CPA (cost per acquisition). This will be for three months plus the current month. I will add a graph and a table of values, as well as four sliders. These are to adjust spend for the current month and the following three months. You’ll have to experiment with the app to get it to run the way you would like.