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.
17 freelancers estão ofertando em média €163 para esse trabalho
Hello Nice to meet you. I'm full stack developer with 4 years experience in sql programming. Please contact me if you are looking for a database administration expert. I can start work right now. Thanks
I'm powerful database manager. Well designed SQL will make your project useful and powerful. I can make nice SQL for your project. Please shake with me for your project.