Delivering Dashboards as Code: A Case Study Using dbt and Preset

Preset offers a user-friendly interface for managing databases, datasets, charts, and dashboards, catering to both technical and non-technical users. The article illustrates how Preset's integration with dbt allows for managing Apache Superset assets as code, encouraging version control, code review, and continuous deployment. It presents a case study involving a bike-sharing company, which utilizes dbt to transform raw trip data into actionable insights through dashboards, helping the company optimize services and increase subscriptions. The process entails connecting databases to Preset, conducting a discovery phase to decide on dashboard content, and using dbt to create transformed datasets that are synchronized with Preset for visualization. The integration of Preset with dbt enhances the ability to manage data and dashboards systematically, as assets can be exported as YAML files, enabling source control and collaborative management. This approach ensures insights are built on a trustworthy data infrastructure, supporting better decision-making and organizational efficiency.

Use this post, company, and trend context to find content marketing opportunities, perform competitive analysis, or address product feature gaps via the Plushcap MCP server or the Plushcap API.