Introduction
In Part 1 of the project you are required to create and populate a database starting from .csv files and perform different operations on it. In the following you can find a set of incremental assignments, each one with a brief description of what you are required to produce and what tools you can use for the task.
In Part 2 of the project you are required to solve some problems on the database you created in Part 1. Solve the exercises using Sequel Server Integration Services (SSIS) with computation on client side (i.e., do not use any sql command in the nodes, only standard SSIS nodes). Each group has to solve only three assignments. Look at the section with your groupid to find what assignments you need to do. Deliver your project with all the required packages in a single .zip folder, named LDS Part2 groupid.zip.
In Part 3 of the project you are required to answer some business questions on a datacube that you will create on the database you prepared. Document how you build your datacube in your report and solve the business questions using MultiDimensional eXpressions (MDX) in SQL management studio. Each group has to solve only the assignments on the corresponding group number page. Look at the section with your groupid to find which assignments you need to do. For the delivery prepare a folder with the name LDS Part3 groupid. Since this is the final delivery each student must create a single folder named LDS groupid containing the following folders:
• LDS Part1 groupid containing the solutions to the assignments of the first part
• LDS Part2 groupid containing the solutions to the assignments of the second part • LDS Part3 groupid containing the solutions to the assignments of the third part
