Page 255 - DCAP603_DATAWARE_HOUSING_AND_DATAMINING

Unit 13: Metadata and Data Warehouse Quality

In figure below illustrates the dimensions and measures in a report. notes

Task Discuss the various factors behind the measures of data warehouse quality.
Why its so important?

13.1.4 analyzing your Data

To analyze data about user activity on your site, you use the Analysis modules in Business Desk.
You can use the Analysis modules to run reports against the Data Warehouse, or to view and
analyze Segment models, which identify segments of the user population visiting your site.

Reports

Commerce Server provides two types of reports that you can use to analyze user data:
1. Dynamic reports are created at runtime: Each time the report is run, it gathers the most
recent data in the Data Warehouse. Only the report definition, which remains the same
over time, is stored. Commerce Server does not save completed dynamic reports; however,
you can export dynamic report results to Microsoft® Excel and store them there. For
information about exporting the results of a dynamic report to Microsoft Excel.
2. Static reports are run immediately upon request, and then stored, with the data, in
Completed Reports: The reports appear in a browser window in HTML format. You can
export static report results to the List Manager module, and then use the list in a direct mail
campaign. You can send these reports to others using e-mail, post them on your Web site,
and edit them in other applications. For example, using Microsoft Internet Explorer, you
can export the report into a Word document, and then edit it.

LoveLy professionaL university 249