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
What are some of the factors which common stockholders consider while deciding how much, if any, cash dividends they desire from the corporation in which they have invested? Comm

Question. 1 Using D to assess the interest rate risk of a financial institution's balance sheet Background: Point 1. A business is 'insolvent' when it has negative eq

What is the Value of the security to an investor Value of the security to an investor is directly proportional to the return that he is expected to get from that security. Hig

Q. What is Capital recovery? sometimes one may be interested to find out the annual amount paid in the order to redeem a loan of a specific amount over a specific period togeth

QUESTION 1 [25 marks] Xelo Ltd, whose current sales consist of fixed operating costs of R140 000 and variable operating costs equal to 22% of sales, has made the following two sale

Types of Efficiency    Efficient market theory can be described in three ways: 1) Allocative Efficiency: A market is allocatively proficient when it directs savings tow

Financial management is that division of managerial process which is concerned with the planning and controlling of firm's financial resources. It is concerned with the procurement

Discuss the relationship between financial decision making and risk and return. Would all financial managers view risk-return tradeoffs similarly

Differences in working capital for different industries   Manufacturing Retail Service Inventories H

Hedge Fund Indices Substantial increase in the use of Hedge Funds in recent times has created demand for appropriate indices that can offer a good tool to assess and benchmark