I need the following for a basic DB with dummy data project
Using ERD and Database which will be provided, I need to develop and populate a real life Relational Database (with dummy data) to hold business data and ALSO a Data Mart to support the reporting requirements of the Databse that I will provide. In order to implement this Data Mart I need you to automate the loading of the data from the live production database to the Data Mart. This should be done by scripting.
documentation needs to be break down as follows:
Project Report Document
a. Background Information Document and relevant graphs connected via Excel to each report defined below.
b. Script File to Create the Data Mart database and tables
c. Script file to populate the Data Mart tables
d. Scripts to complete the following reports
Reports and scripts for the following queries need to be provided
1. Show all transactions for a given week in your business. (Stored Procedure)
2. Create a trigger that stores stock levels once a sale takes place.
3. Create a View of stock (by supplier) purchased by you.
4. Total stock sold to general public (by supplier). (A Group By with Roll-Up)
5. Detail and total all transactions for the month-to-date. (A Group By with Roll-Up)
6. Detail and total all revenue for the year-to-date. (A Group By with Roll-Up)
7. Detail & total transactions broken down on a monthly basis for 1 year. (A Group By with Roll-Up)
8. Display the growth in sales/services (as a percentage) for your business, from the 1st month of opening until now.
9. Use a reporting tool of your choice to connect to your data and create a graphical representation of each of your previous SQL report results.
10. Add both the SQL statements and graphs into a Word document report.
10 freelancer đang chào giá trung bình $36 cho công việc này
Hi, Hope you are doing well. I have 2+ years experience with this and I can do this easily. just contact me to do this asap. looking forward for your response. regards,