Making 4 laboratory work on the subject Data Storage (MS SQL Server)Зробити 4 лабораторні роботи по предмету Сховища даних (MS SQL Server)
Laboratory work (the first laboratory work is already done, from it I will attach the report and the file with the created database, on the basis of which you need to perform the following work):
1) Take the database and rebuild it under the data warehouse. In the tables to predict the hierarchy of measurements (ready)
2) Create an OLAP-cube in Analysis Services and demonstrate the performance of the request.
3) Create the Integration Services package and download the data to the storage using ETL
4) Realizing one of the DataMining algorithms in Analisys Services
5) Publish reports in Report Services.
The result should be 4 reports and files of projects to each of them.
The deadline is 1 week, but desired faster.
Потрібно виконати 4 лабораторні роботи, оформити звіти і прикріпити файли проектів.
Лабораторні роботи (Перша лабораторна робота уже виконана, від неї я прикріплю звіт та файл зі створеною базою даних, на основі якої потрібно виконати наступні роботи):
1) Взяти базу даних і переробити її під сховище даних. В таблицях передбачити ієрархію вимірів (Готово)
2) Створити OLAP-куб в Analysis Services і продемонструвати виконання запиту.
3) Створити пакет Integration Services та завантажити дані в сховище, використовуючи ETL
4) Реалізувати один із алгоритмів DataMining в Analisys Services
5) Розгорнути звіти в Report Services.
В результаті повинно бути 4 звіти та файли проектів до кожного з них.
Термін виконання - 1 тиждень, але бажано швидше.
Applications 1
Client's feedback on cooperation with Vladislav Girdvaynis
Making 4 laboratory work on the subject Data Storage (MS SQL Server)He took the job and said everything was clear. As a result, the deadline was delayed for four days, covered by a lack of electricity. He sent half of the files in which the task was not completed. They look like they’ve done them in 10 minutes just to be. A terrible executor.
Freelancer's feedback on cooperation with Viktor Fernets
Making 4 laboratory work on the subject Data Storage (MS SQL Server)The customer did not normally complete the work, made the stickers, although the work was actually performed, and it remained quite a little, screenshots were real and corresponded to reality. I’m not “covered” by the lack of electricity, I just need a drop of understanding to have to the co-workers, and to what realities we live in. I consider his feedback a great attachment to myself and clearly no cooperation with him language can go. No methods, nothing, was given, everything was done from scratch, and all one dissatisfaction. What did he get out of that I’m doing the job in 10 minutes? The customer himself left me a picture where only signatures to screenshots and this is the whole report
-
proposal concealed by freelancer