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

Cerrado Publicado hace 7 años Pagado a la entrega
Cerrado Pagado a la entrega

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 Wahrehousing SQL

Nº del proyecto: #10109663

Sobre el proyecto

9 propuestas Proyecto remoto Activo hace 7 años

9 freelancers están ofertando un promedio de €201 por este trabajo

websoftseo

Dear! I am really interested to work on this project, i am sure do quality work. I can start the work now , and can provide the best services from my end. Please come on chat to discuss more about the project. Than Más

€147 EUR en 3 días
(17 comentarios)
5.6
baddesigner

I am arif from Pakistan, having 7 years of experience in software house in the IT-Programming and Graphic Design. I can realize almost everything you need databases and languages - it does not matter because they ar Más

€350 EUR en 3 días
(0 comentarios)
0.0
rdkaran

API framework DWH design ETL framework Reports

€255 EUR en 20 días
(0 comentarios)
0.0
vw6796164vw

ETL Solutions Architect Activities Analyze & translate functional specifications & change requests into technical specifications. Develop, test & implement program logic. Translate business needs into end user Más

€250 EUR en 9 días
(0 comentarios)
0.0
VishnuPatel

Having 5 + year of ezp. On database and last one year on azure database

€155 EUR en 3 días
(0 comentarios)
0.0
parulSurjeet

I will provide end to end solution on data warehouse including data visualization. I am working on BI Tool and attached ppt here. Please have a look. I was a professional but now I am a freelancer. Please let me kno Más

€277 EUR en 3 días
(0 comentarios)
0.0