Dashboard Design Document Although you are not required to submit an actual dash

Question

Dashboard Design Document Although you are not required to submit an actual dashboard for this project, it is worthwhile to develop a document that could guide you in designing a dashboard. To begin this project read the following two presentations (along with any additional research you may need): Dashboard Design Best Practices The Nine Principles of Killer Dashboards In an actual dashboard design project, you would meet with management stakeholders to define and agree on the metrics that you wish to track with, but for this exercise, you will need to define those metrics based on your familiarity with the Adventure Works business case. Using these principles and your knowledge of Adventure Works and their business processes, you will now draw up a design document for a business dashboard for the company. Remember to address these elements in your dashboard design: Include the types and sources of data you will be using and create at least one diagram showing the dashboard layout. (NOTE: Your dashboard may have different screens so feel free to add additional diagrams as needed.) Make sure each component in a dashboard represents one report. Your dashboard should only include data that are relevant to the specific business goal(s) it was designed to support. Your dashboard should have at least three columns with up to 20 total components. Make sure you dashboard is organized to allow the user to 'drill down' and access lower level, more detailed data. Your dashboard should be clearly formatted, professional looking and easy to interpret. this is about the company As an IT employee of Adventure Works, you have access to the company's OLTP (Online Transaction Processing) data. With the use of standard business analytic techniques, you will take on many tasks including making the business case for utilizing the company's rich database, making recommendations on how to implement that data into a usable dashboard, designing a business process diagram and finally creating user documentation for your dashboard users. Please carefully the following Adventure Works Cycles Case Study summary: Adventure Works Cycles, the fictitious company on which the AdventureWorks sample databases are based, is a large, multinational manufacturing company. The company manufactures and sells metal and composite bicycles to North American, European and Asian commercial markets. While its base operation is located in Bothell, Washington with 290 employees, several regional sales teams are located throughout their market base. In 2000, Adventure Works Cycles bought a small manufacturing plant, Importadores Neptuno, located in Mexico. Importadores Neptuno manufactures several critical subcomponents for the Adventure Works Cycles product line. These subcomponents are shipped to the Bothell location for final product assembly. In 2001, Importadores Neptuno, became the sole manufacturer and distributor of the touring bicycle product group. Coming off a successful fiscal year, Adventure Works Cycles is looking to broaden its market share by targeting their sales to their best customers, extending their product availability through an external Web site, and reducing their cost of sales through lower production costs. (Microsoft Adventure Works Cycles Business Scenarios, 2015)

Explanation / Answer

The directions ar meted out by a professional DBA, totally familiar with Oracle.
A fully operating info while not XML dB exists.
All references to SID ought to get replaced with correct info name as derived victimisation the info naming customary.

STEP-BY-STEP GUIDE

Confirm XML dB isn't already put in.
SELECT username FROM DBA_USERS wherever username = 'XDB'; returns zero rows.
DESCRIBE RESOURCE_VIEW fails.
As SYS, perform the XML dB installation - Note: this can not be a whole build thanks to Oracle Bug 9818995:
@?/rdbms/admin/catqm.sql xdb <xml dB tablespace> <xdb temporary worker tablespace> <use secure files yes|no>
As SYS, grant the relevent permissions to the XDB user:
GRANT EXECUTE ON utl_file TO xdb;
GRANT EXECUTE ON dbms_lob TO xdb;
As SYS, guarantee their aren't any invalid objects:
@?/rdbms/admin/utlrp.sql
Assuming associate degree spfile is in use, as SYS put together the XDB dispatcher:
ALTER SYSTEM SET DISPATCHERS="(PROTOCOL=TCP)(SERVICE=<SID>DB)" SCOPE=both;
If init.ora is in use, edit the init.ora file instead.
As SYS, install the missing contents caused by Oracle Bug 9818995:
SHUTDOWN IMMEDIATE;
STARTUP UPGRADE
@?/rdbms/admin/xsdbmig.sql
SHUTDOWN IMMEDIATE;
STARTUP
As SYS, guarantee their aren't any invalid objects:
@?/rdbms/admin/utlrp.sql
As SYS, make sure the XML dB is currently totally put in by running the subsequent question and returning the subsequent output:
SELECT
object_value
FROM
xdb.xs$securityclass
WHERE
EXTRACTVALUE(object_value, '/securityClass/@targetNamespace')='http://xmlns.oracle.com/plsql'
AND
EXTRACTVALUE(object_value, '/securityClass/@name')='network'
/

OBJECT_VALUE

Related Questions

Navigate

• Browse (All)
• Browse D
• Subjects

Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.