Skip to content
/ NYC-Arrest-DW-BI Public

Designed and developed Dimensional Model and performed data profiling, ETL operations for staging using Alteryx. Created data integration workflow in Talend to load data in AzureSQL and BigQuery DW and visualized analytical data reports dashboard using Tableau and PowerBI to get the insights and single truth story of the data

1 star 0 forks Branches Tags Activity
Star
Notifications You must be signed in to change notification settings

sanketsanap5/NYC-Arrest-DW-BI

BranchesTags

Repository files navigation

NYC-Arrest-DW-BI

Technology Used

  1. Talend (Integration)
  2. Alteryx (Processing)
  3. BigQuery
  4. AzureSQL
  5. Tableau
  6. PowerBI

Summary

Designed and developed Dimensional Model and performed data profiling, ETL operations for staging using Alteryx. Created data integration workflow in Talend to load data in AzureSQL and BigQuery DW and visualized analytical data reports dashboard using Tableau and PowerBI to get the insights and single truth story of the data

NewYork Arrests Insights

Screen Shot 2022-05-10 at 12 57 23 PM

Screen Shot 2022-05-10 at 12 58 06 PM

Screen Shot 2022-05-10 at 12 58 21 PM

Screen Shot 2022-05-10 at 12 58 41 PM

Screen Shot 2022-05-10 at 12 59 31 PM

About

Designed and developed Dimensional Model and performed data profiling, ETL operations for staging using Alteryx. Created data integration workflow in Talend to load data in AzureSQL and BigQuery DW and visualized analytical data reports dashboard using Tableau and PowerBI to get the insights and single truth story of the data

Topics

bigquery integration etl talend bigdata staging ada tableau powerbi datawarehouse azuresql datamodeling alteryx-workflow

Resources

Readme
Activity

Stars

1 star

Watchers

1 watching

Forks

0 forks
Report repository

Releases

No releases published

Packages

No packages published