QL Server - SSIS - SSRS - SSAS
Budget: $8 – $15 CAD
Overview of the project :
The STM project is an end to end BI project using the Microsoft Stack (SSIS, SSAS, SSRS) as a foundation and public transportation data (STM) as a source system.
Scope of work :
The scope of work translates to building a full, end to end, Microsoft BI solution. This means:
Analysing source data and producing a data analysis report
Extracting data from flat files and loading them into a Sql Server Database
Loading data into a data warehouse model using SSIS
Building Operational Reports using SSRS
Building Analytical Reports using SSRS
Building an OLAP database for advanced analysis using SSAS
You will be in charge of delivering all the pieces listed above. In addition to that, and if you feel like doing it, you can tinker with data modeling and architecture and build your own data models and ETL strategies.
Should be working remotely due to connect to the server
The STM project is an end to end BI project using the Microsoft Stack (SSIS, SSAS, SSRS) as a foundation and public transportation data (STM) as a source system.
Scope of work :
The scope of work translates to building a full, end to end, Microsoft BI solution. This means:
Analysing source data and producing a data analysis report
Extracting data from flat files and loading them into a Sql Server Database
Loading data into a data warehouse model using SSIS
Building Operational Reports using SSRS
Building Analytical Reports using SSRS
Building an OLAP database for advanced analysis using SSAS
You will be in charge of delivering all the pieces listed above. In addition to that, and if you feel like doing it, you can tinker with data modeling and architecture and build your own data models and ETL strategies.
Should be working remotely due to connect to the server