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
Negotiating and Closing Transaction: A diverse set of skills and very thorough preparation is required for negotiating and closing a divestiture transaction. Facts and informat

The following is the existing capital structure of Company XYZ Ltd. Ordinary shares at Shs.10 par 1,000,000 Retained 800,000 12% preference shares Shs.10 par 400,000 16% loan Shs.1

Illustrate the term quality of benefits It is clear from Table that total returns associated with two alternatives are identical in a normal situation but range of variati

Saven Travel Corporation is considering several investment opportunities in order to diversify its operations. Mr. Saven, president, is trying to determine the firm''''s cost of ca

Q. Firms operation and financing decision? Firms operation and financing decision risks or the variability of returns also results for the decision make within the company. Ris

What is an annuity? An annuity is a series of equivalent cash flows, spaced consistently over time.

FACTORS INFLUENCING CAPITAL STRUCTURE/DETERMINANTS OF THE CAPITAL STRUCTURE 1. Financial leverage (or) Trading on equity it is the make use of long term fixed interest bea

Define Hedger - Market Participants A hedger desires to prevent price variation by locking in a purchase price of the underlying asset by a long position in a futures contract

What is the matching principle of working capital financing?  What are the benefits of following this principle? The matching principle is while short-term financing is used fo

Q. What is Dependent Care Expenses? Dependent Care Expenses - Qualified child care expenses would allow a taxpayer this computed credit against tax. Amounts can be found on the