Templates
tDS Project Brief
Google Docs
For each potential project, we create a Research Brief that outlines the goals, context, and requirements to successfully complete the project. This is the first step to ensure each project is completed effectively and on time.
tDS Quickstart Notebook
Google Colab
We use our Quickstart Notebook to start and complete ad hoc analysis efficiently. I created this template in Google Colab, making it easy to export to Jupyter Notebook and connect to GCP and Google services.
The purpose of this notebook is to make several common data science tasks simple, including:
Notebook setup, installations, and authentication
Importing and exporting from Google BigQuery, Cloud Storage, and Sheets
Profiling and visualizing data
More features coming soon!
tDS Catalog: Events, Data, Metrics
Google Sheets, BigQuery
We use theDataStrategist Catalog to track the events, datasets, columns, and metrics we create for your organization. We can also partner with Data Catalog SaaS, such as Atlan and CastorDoc. However, this simple workbook will provide the same core value of those services — providing a central repository for your company's data assets and ensuring they are produced, organized, and understood consistently.
dbt Pipeline & Looker Report
dbt, BigQuery, Looker
At theDataStrategist, we build custom reporting solutions for e-commerce and consumer companies. I've used data from a fictitious e-commerce company, TheLook, to demonstrate how we approach analytics engineering.
This project leverages frameworks from theDataStrategists' dashboard development process, including:
I built the data pipelines and dashboards using dbt, Google BigQuery, Looker Studio, and Github.
About
At theDataStrategist, we help companies become data-driven, through fractional (part-time) data analytics support and data strategy advisory.
Contact