I do things with professionally. Occasionally, I write about things here.
Less than 1 minute
PreQL/Trilogy
Better SQL for the lazy
Fundiverse
Custom index-based stock portfolios
pygsuite
Pythonic wrapper for all Gsuite APIs
pyterraformer
Python wrapper for authoring/editing HCL files
Mandatory EVE Disclaimer
This is about EVE Online, a space MMORPG I haven't played in years. It had a unique sandbox and relatively unforgiving nature. I enjoyed my time with EVE, but but if you're not familiar with it, posts in the EVE Online category may not be as interesting to you.
About 4 min
Monthly Active Users Calculation
Given a table with the definition below:
user_actions table: Column Name Type user_id integer event_id integer event_type string ("sign-in", "like", "comment") event_date datetime
Write a query that will return "Monthly Active Users" (MAU) for each month in the table.
About 2 min
Around 2010, were a common way to support analytics. They were the fastest way to do interactive analysis over a fixed set of "dimensions". They could be connected to Excel, Power BI, or custom dashboards.
One of the popular solutions was Microsoft's SQL Server Analysis Services, or SSAS. SSAS was well integrated with the Microsoft ecosystem (SQL Server, SSIS, etc.) and so was a popular default choice for companies using the SQL Server stack.
About 2 min
Context
At Wayfair (they've got what you need!) from 2015-2020, I led teams that both built and leveraged Kronos, a generalized orchestration engine for data warehouses. The engine ended up having quite significant adoption, though it was too tightly coupled to Wayfair technology to be a viable open-source option. Post Wayfair, I realized that though I had a good sense of how Kronos fit into the broader landscape of data orchestration tools - of the time Oozie, Airflow, Luigi, SSIS, and more - and the tools of the future - DBT, etc - there were many who probably ran into it as a weird internal elephant. This post is intended to be a map of where it fit into the overall landscape of data tooling at the time, and how tools like DBT evolved past it.
About 5 min