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
You are the chief financial office (CFO) of Gaga Enterprises, edgy fashion design firm. Your firm needs $10 million to expand production. How do you think the process of raising th

What is behind the wave of mergers in the banking industry? A: Various economic factors have caused banking institutions to merge over the past various years. These factors inclu

Basics of Convertible Bonds The provision of conversion in a corporate bond entitles the bondholder the right to convert the bond into a predetermined number of shares of commo

In the case of dual currency bonds, the interest is paid in one currency, while the principal repayment is made in another currency. Deep Di

Suppose the bid-ask spot prices for one British pound are $1.50 and $1.60 respectively. 1. Compute the bid-ask prices for one US dollar in terms of British pound. 2. Suppose

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

Question 1: You hold a diversified portfolio consisting of a Rs.5,000 investment in each of 20 different common stocks. The portfolio beta is equal to 1.15. You have decided t

My company paid an extremely high price for the acquisition of another company; the price was recommended by the valuation of an investment bank. We now have financial crisis. Is t

Ratio Calculation:   A 'Financial Ratio' is an index that relates two accounting numbers and is obtained by dividing one number by the other. Various Ratios are - 1. L

DEFINITION OF FINANCIAL MANAGEMENT The term financial management has been described by management experts in several ways reflecting the duties and responsibilities of a financ