Đã Đóng

Start with an existing database and develop a data warehouse from it.

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 [url removed, login to view] 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.)

Kĩ năng: Microsoft Access, SQL

Xem nhiều hơn: extract data webpages insert database, sql server 2000 data move oracle database, extracting data html pages database, data extraction access database, integrating joomla existing database, insert data form sqlite database, viewing data arabic langauge database english, upload data web page database, convert existing database modx, asp getting data form mysql database, search data fields mysql database, import existing database folder mysql, data swing forms database, add existing database mysql, need develop membership database web

Về Bên Thuê:
( 0 nhận xét ) Kenya

ID dự án: #13248522

13 freelancer đang chào giá trung bình $57 cho công việc này

fabest

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 ser Thêm

$24 USD trong 1 ngày
(68 Nhận xét)
6.9
alaeddindhahri

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 Thêm

$50 USD trong 1 ngày
(18 Nhận xét)
4.4
ashupathania

I have 5 + years of experience in MSBI Technology (SQL Server 2008/2012, SSIS, SSRS, and SSAS) Worked with the reputed clients like Microsoft, HCL, and Dicks Sporting Goods etc. Worked on various types of ER diagram Thêm

$100 USD trong 2 ngày
(21 Nhận xét)
4.7
$111 USD trong 1 ngày
(1 Nhận xét)
3.0
shaheen23

Hello, Greetings from Passionate Futurist Solution Pvt. Ltd As per your project description you want an existing database and develop a data warehouse from it. The idea sounds good, we will provide you fully Thêm

$30 USD trong 1 ngày
(0 Nhận xét)
0.0
jss2017

Thanks for opening my profile. I have been administrator of Website and Database for 5 years. I have developed many sites using PHP frameworks such as Wordpress, smarty, CodeIgniter, Larabel, Yii and so on. Availa Thêm

$10 USD trong 1 ngày
(0 Nhận xét)
0.0
$60 USD trong 2 ngày
(0 Nhận xét)
0.0
maxpl

Hi, Please let me know if you are available, I will show you demo of similar project, front end and backend system. Please check my profile : I am a full stack web developer from Poland, I have 5+ years of Thêm

$222 USD trong 4 ngày
(0 Nhận xét)
0.0
fb57e1f6608abfb

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 Thêm

$30 USD trong 0 ngày
(0 Nhận xét)
0.0
shubham10789

A proposal has not yet been provided

$25 USD trong 1 ngày
(0 Nhận xét)
0.0
raskarlitos

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 command Thêm

$30 USD trong 10 ngày
(0 Nhận xét)
0.0
suvithasqldev

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.

$25 USD trong 1 ngày
(0 Nhận xét)
0.0
$25 USD trong 1 ngày
(0 Nhận xét)
0.0
$25 USD trong 1 ngày
(0 Nhận xét)
0.0