Modeling data using dbt Cloud

With the raw data in BigQuery, you might want to jump right in and start uncovering those key business insights. But before you start building those queries, take a moment to think about the tools and strategies available. Remember, there is often more than one way to tackle data analysis.

The shortcomings of conventional analytics

BigQuery and platforms of its kind are built to manage massive data volumes at impressive speeds. Still, this does not iron out every hurdle for analysts. They frequently receive ad hoc requests for data queries, such as dissecting sudden changes in sales patterns, forecasting next week’s inventory requirements, or explaining yesterday’s customer behavior. Analysts address these tasks diligently aiming to enhance business insights. Often, they might pull SQL from one of their past analyses and repurpose it for a new one. This new analysis could be stored away in a Word document on a shared network drive or...