Building a sql data warehouse, transfering test data from [login to view URL] to data warehouse + presnetating data on web

1 .Build a dataware house

The DBMS is a relational database that is hosted in Azure. Azure SQL is based on Microsoft SQL

server with some limitations. These restrictions do not affect this task when Azure SQL

meets all requirements necessary to perform the task.

2 .Transferring data from [url removed, login to view] ([url removed, login to view])

By using Figs its open APIs, the candidate should bring out all the information provided by the system

and who is available. The solution must connect to Fikens endpoints and authenticate themselves according to

described procedure documentation. The data will then be retrieved and transferred to the data warehouse. This important to note that this transfer task will have to be run frequently, so that the data in data warehouse at any time reflects the actual numbers in Figs. In practice this means that the system must

could handle scenarios

 Fetch new data that does not exist in the data warehouse

 Updating the data that already exists in the data warehouse, if them have been altered in Figs

 Removing data that exists in the data warehouse if those have been deleted in Figs.

3 Presentation

The data in the data warehouse should be presented on a separate website. It aims to provide the end user opportunity to immerse themselves in the data found in the data [url removed, login to view] shows that a customer like to be

interested in a high-level and more detailed picture on the lower level in the data.

The website must take advantage of modern web technologies. Websites should be designed for HTML5 and

CSS3 standard and make use of JavaScript, happily ES6 as JavaScript standard. Type Script is

also an option to use. When using client-side framework encouraged to use Angular

1.5 / 2.0

AngularJS ASP.NET Azure Data Warehousing SQL

Project ID: #10109663

About the project