ITEC871 Information System Design and Management
Added on 2020-05-01
9 Pages1403 Words47 Views
|
|
|
Running head: ITEC871 INFORMATION SYSTEM DESIGN AND MANAGEMENTITEC871 INFORMATION SYSTEM DESIGN AND MANAGEMENTASSIGNMENT 3Name of the StudentName of the UniversityAuthor Note
1ITEC871 INFORMATION SYSTEM DESIGN AND MANAGEMENT Table of ContentsTask A........................................................................................................................................2Task B........................................................................................................................................2Dimensions:................................................................................................................................2Measures:...................................................................................................................................3Task C........................................................................................................................................31..................................................................................................................................................32..................................................................................................................................................43..................................................................................................................................................5Explanation for the choice of Dashboard...................................................................................54..................................................................................................................................................65..................................................................................................................................................6Bibliography...............................................................................................................................8
2ITEC871 INFORMATION SYSTEM DESIGN AND MANAGEMENT Task AThe data sets, which has been used for the development of this report, are:saleHistory.xlsx employees.txt products.csvThe products data set provides the description of the different products that theorganization sell. The employee data set provides the overview of all the employees who areworking with the organization and has a hand in the assessment of the orders being requestedto the organization. The sale History data set provides the complete set of details based on thesale of the products by the organization. There are details of all the deductions and therevenues, which the organization faces for the sale of a single product from the products dataset. The connection between the three data set has to be done for the complete analysis of thedata source. The different attributes can be connected among from the three data set and thebest possible connection can be established. The Employee ID from the employee data setcan be connected to the Employee ID of sale History data set thus making the connectionbetween them successful. The Product Name from the products data set can be used toconnect to the Product Name of the sale History data set thus completing the connectionbetween the three data sets. Task BDimensions:The group by option was used for the expansion of the data sets, which were initiallylisted under the data source names. The first name and the last name were merged together
End of preview
Want to access all the pages? Upload your documents or become a member.
Related Documents