IOWA LIQUOR SALES: Using Altreyx, Google Big query, ER-STUDIO SSMS Created a dimensional data model STEPS:
- Created the Dimensional data model
- Wrote DDL statements in SSMS
- Loaded the Data in Altreyx a.Data Prep b.Data Profiling
- Output the data to Google big query 5.DML in SSMS In shorted created a Pipeline for reading the data and writing it(output)