Skip to content
Daran on Data
  • Services
    • Data Infrastructure
    • Campaign & Performance Analytics
    • Custom & Ongoing Analytics
    • Statistics & Predictive Modelling
    • Custom Shiny & Streamlit Apps
  • Blog
  • Github
  • About Me
  • Privacy Policy

database

Advanced SQL For Analysts

January 10, 2025January 19, 2022 by Daran J. Johnson
Advanced SQL For Analysts

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.

Read more

Categories SQL Tags advanced sql for analysts, database, query Leave a comment
  • Channel Attribution
  • Data Fundamentals
  • Experimentation
  • Forecasting
  • Hypothesis Testing
  • Marketing Measurement
  • Python
  • R
  • Regression
  • SQL

a/b testing advanced sql for analysts arima armstrong's axioms auto-correlation bigquery boyce-codd normal form closure cohort analysis correlation custom metrics data cleaning data exploration data modeling data studio data tables data visualization etl frequentist functional dependencies ga4 ggplot glmnet google ads googleanalyticsr package heath's axiom join dependencies k-fold cross-validation kendall tau media optimization modeling multi-channel attribution normalization pearson r prediction risanen's theorem rmarkdown shiny spearman rho spreadsheets stationarity time-series unit root white noise window functions

© 2025 Daran on Data • Built with GeneratePress