Data Warehousing
Data Warehousing
Embedded Files
To analyze the crime rate based on socio-economic factors such as employment factor, education, wages, we have created a data warehouse integrating different data sources including JSON, XML, CSV, API
To analyze the crime rate based on socio-economic factors such as employment factor, education, wages, we have created a data warehouse integrating different data sources including JSON, XML, CSV, API
Process Flow
Selected topics such as Economic Factors such as Educational Statistics, Employment and Unemployment rate, Labor statistics along with Estimated Crimes and Wages by Education across the United States of America from year to build the data warehouse
Formulated Business Questions to answer for Analytics
Browsed through different sources to avail datasets for Data Warehouse
Downloaded CSV file from kaggle.com and extracted datsets from Alpha Vantage using API key
Cleaned and standardized files to our requirements
Created tables in MS SQL Server with Primary and Foreign Key references
Loaded (SSIS) all the integrated files from different sources into the designated tables in MS SQL Server using Export /Import Wizard
Performed Data Mapping
Finally Ran SQL Queries to answer business questions
The screenshot below is the diagram flow showcasing the data mapping (including dimension tables and fact tables ) of the data warehouse from the Microsoft SQL Server to create a data warehouse
The screenshots below showcase few of the SQL queries using Data Manipulation Language (DML) to analyze the datasets inside the Data Warehouse
Page updated
Google Sites
Report abuse