Start with an existing database and develop a data warehouse from it.
$10-30 USD
Closed
Posted about 7 years ago
$10-30 USD
Paid on delivery
In this assignment you will start with an existing database and develop a data warehouse from it. You will take the existing data and de-normalize it, such that it is more powerful for analytical uses.
In the Week 7 Books and Resources area, locate the Microsoft Access database file named WPC Database. You will use this database as the starting point.
You need about twenty PROPERTY_SERVICE transactions in the database. Write the needed SQL statements for any needed additional PROPERTY_SERVICE transactions to the PROPERTY_SERVICE table and insert the data into your database (just make up reasonable data values on your own). Assuming you are using Microsoft Access, you may also enter these new records directly into the table.
Design a data warehouse star schema for a dimensional database named GG-DW. The fact table measure will be HoursWorked.
Create the GG-DW database in Access, using the menus: File, New, Blank Desktop Database.
What transformations of data will need to be made before the GG-DW database can be loaded with data? List all the transformations, showing the original format of the GARDEN_GLORY data and how it appears in the GG-DW database. You will include this information in the final report for the assignment.
Write the complete set of SQL statements necessary to load the transformed data into the GG-DW database.
Populate the GG-DW database, using the SQL statements you wrote to answer part F.
Write an SQL query similar to the one shown in the text on page 456 that uses the hours worked per day as the measure.
Write the SQL view equivalent of the SQL query you wrote to answer part H.
Create the SQL view you wrote to answer part I in your GG-DW database.
Create a Microsoft Excel 2013 workbook named GG-DW-BI-Exercises.xlsx.
Using either the results of your SQL query from part H (copy the results of the query into a worksheet in the [login to view URL] workbook and then format this range as a worksheet table) or your SQL view from part J (create a Microsoft Excel data connection to the view), create an OLAP report similar to the OLAP report shown in Figure 8-17. (Hint: If you need help with the needed Microsoft Excel actions, search in the Microsoft Excel help system for more information.)
Dear, we are Team of French + US.
I checked your project description, and I confirm I can develop your program.
I will focus on user friendly interface.
As you can see I have very good rate, you can be sure I am serious.
Regards,
Fabrice
Hi,
I'm a professional Ms Access and VBA developer with strong background in developing and implementing information systems with databases from scratch. I have read your project description and I'll be glad to assist you with whatever you need. I have done similar assignments previously, so check my profile for details.
I'm looking forward to hearing from you.
Regards,
Hi,
I have ~4+ years of experience of creating and operating low to very high complexity of Excel/VBA/SQL,SAS, Powerpoint based tools/processes, reports.
I can assure you of high quality and on-time deliverable from my side as that is the sole criteria from my side to work and deliver.
Hope to hear back from you soon :)
#CustomerFirst
Best Regards,
Rohit Ahuja
99.9% of satisfaction is guaranteed, for which purpose it is developed a tool developed in vb.net to perform all the functions, in such a way that it is possible through a graphical interface to execute all the commands for the Extraction, Transformation and Load.
We can make use of ETL tools for the data transformations such as SSIS.
SSIS offers various data transformations tasks which helps in formatting the data as per the requirement.