Skip to content

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

Notifications You must be signed in to change notification settings

sanketsanap5/NYC-Arrest-DW-BI

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

Resources

Stars

Watchers

Forks

Releases

No releases published

Packages

No packages published