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.
Bu iş için 10 freelancer ortalamada $36 teklif veriyor
Nice to meet you. I've read the task description and can develop definitely. I'll provide you with the highly skill to complete this task in time. I'll also do my best for you. Please contact with me. Thank you ve Daha Fazla
Hello, I have checked the requirements. We can discuss further on this task in more details in PM. Thanks.
Hello, Hope you are doing well. I came across the project and liked it. I have successfully completed multiple projects in the same field. Please feel free to visit my LinkedIn profile where i have elaborated on my sk Daha Fazla
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,
Hello, I have a great experience with SQL databases(MySQL, POSTGRESQL, ORACLE). I can help you to find a solution. Regards, Tudor.
Hi,I have read your requirements of Few MySQL statements for existing MySQL database and I’m pretty confident that I will be able to get your work done within the given time your requirements conclude. I am very keen t Daha Fazla
Hi, I'm a C# Senior programmer that works for one of the Software house in Jakarta. My daily jobs is create C# application for banking company and custom application for individuals. Please take a look at my LinkedIn P Daha Fazla