Building a sql data warehouse, transfering test data from [login to view URL] to data warehouse + presnetating data on web
€30-250 EUR
Paid on delivery
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
Project ID: #10109663
About the project
9 freelancers are bidding on average €201 for this job
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 More
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 More
ETL Solutions Architect Activities Analyze & translate functional specifications & change requests into technical specifications. Develop, test & implement program logic. Translate business needs into end user More
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 More