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






Sales Agent


Acquiring Car































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 is Capital Budgeting Capital Budgeting is probably the most financial decision for a firm. It relates to selection of an asset or investment proposal or course of action

operating cycle in vegetable growing business in uganda..

QUESTION 1 Assuming perfect capital mobility under Mundell-Fleming Model, clearly explain the effectiveness of- i) an expansionary fiscal policy under a fixed exchange rate

discuss the applicability operating cycle considering broilers in uganda?

Settlement Mechanism: Nifty index futures and option contracts are cash settled. All CMs are required to open a separate bank account with NSCCL designated clearing banks. T

Offshore Financial Center It is a location with banking facilities to accept deposits and make loans in currencies various from the currency's country of origin. Banks located

Define the importance of mutual funds in the investment intermediaries. Mutual funds: Mutual funds pool resources by several companies and individuals and invest these re

Measuring volatility is very important as it is a critical input in valuation models. In subsequent chapters we will see the importance of assumed volatilit

Benefits of Going private company A public company has its shares purchased by a small group of people and ceases to be listed on stock exchange. This has many benefits includ

Pension Reforms On January 1, 2004, Pension Funds have come into force in India. Government servants will have to subscribe to them. The new pension fund system is primarily dr