Identify an analytic theme for fictitious business, Financial Management

1. identify an analytic theme or goal for a fictitious business or something that you are working on (e.g. Maximize revenue in a car dealership)

2. Build an Enterprise Bus Matrix to identify the business processes that needs to be looked at and the dimensions

 

Vehicle

 

Time

Accessories

Sales Agent

Customer

Acquiring Car

x

x

x

 

 

Inventory

x

x

 

 

 

Marketing

x

x

x

 

x

Sales

x

x

x

x

x

Service

x

x

 

 

x

 

3.   Identify Measures and Granularity, Identify Dimensions, Identify fact Tables 

(e.g.) Profit, Cost, Inventory Turnover by day - Vehicle : OEM, Brand, Model etc.)

4.   Create a blank database in SSMS and use it as a source

5.   Build a Reverse Cube

6.   Modify the dimensions and attributes as required and create hierarchies (Time hierarchy, OEM, Brand, Model hierarchy etc..)

7.  Create the schema once all the attributes of the dimensions are defined and facts tables are identified with the measures and measure groups

8.  Your cube should have at least two measure groups with a minimum of two measures in each, 3 or more hierarchies , 3 or more dimensions including Time.

9.  Generate the schema in the database

10. Populate the data using Integration Services (At least two dimensions and one fact table must be populated using SSIS - You can enter data manually beyond that)

11. Build , process and deploy the cube.

12. Your output should include these:

o   Business Process

o   Enterprise Bus Matrix

o   Solution File

o   Screenshots of the following

  • Integration Services Project to show data population (
  • Empty Cube (Measures and Dimensions)
  • Dimensions with attributes, hierarchies and their relationships
  • Drilldown of dimensional hierarchies and measures in the browser (It is not necessary to do the screenshots for all dimensions and measures - show two dimensions and a measure group)
  • Reports generated using the cube

 

Posted Date: 2/26/2013 2:36:28 AM | Location : United States







Related Discussions:- Identify an analytic theme for fictitious business, Assignment Help, Ask Question on Identify an analytic theme for fictitious business, Get Answer, Expert's Help, Identify an analytic theme for fictitious business Discussions

Write discussion on Identify an analytic theme for fictitious business
Your posts are moderated
Related Questions
Reston, Inc., has asked your corporation, Pruro, Inc., for financial assistance. As a long-time customer of Reston, your firm has decided to give that assistance. The question you

Need to Widen and Deepen the Government Securities Market The importance of the Government Securities markets can be evaluated from three angles as follows: From the Gove


The production department in any firm is concerned with provision of production facilities, production cycle, skilled and unskilled labor, storage of finished goods, capacity utili

Evaluate the tools commonly used in estate planning, including trusts, life insurance, and annuities. Compare the tools as to how they would apply for a couple in their mid-50s who

The exchange rate uncertainty may not essentially mean that firms face exchange risk exposure. Describe why this may be the case. Answer:  A firm can comprise a natural hedging p

Discuss the process of bringing a new international bond issue to market. Answer:  A borrower desiring to increase funds by issuing Eurobonds to the investing public will conta

Leverages 'Leverages' are of prime importance in the analysis of a companies' risk. They give a good picture of the business, financial and the overall risk of a company's oper

Accounts receivable are sometimes not collected.  Why do companies extend trade credit when they could insist on cash for all sales? Extending trade credit almost all the time le

Determine the example of Future Value of an Annuity An annual payment of 7000 $ is invested at 5% per annum compounded yearly. What will be the amount after 20 years? Solut