Ad Sales - Revenue and Projected Revenue Grid

Intended Use

Replicate Revenue and Projected Revenue Grid (reports in Pivotal SFA) in Looker.

People

Business Owner: Lauren Brozyna
Technical Lead: Abe Ahn

Tools and Technologies

Pivotal SFA: Original data source
Fivetran: Data Sync tool for extracting and loading Pivotal SFA data with Snowflake
Snowflake: Cloud data warehouse; Looker data source
Looker: Data modeling, visualization, dashboard

System Architecture

Open

Calculations and Formulas

Open

Data Model Designs