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
Complete the financial reporting for each period and develop recommendations using the templates provided. Procedure 1. Read the case study. 2. Complete the financial reports

discuss the applicability of financial management in respect to poultry farming in uganda

Q. Evaluate Earning Yield plus Growth in Earning Method? Earning Yield plus Growth in Earning Method: - If the EPS of a company is likely to grow at a constant rate of growth t

Evaluate the importance of leverage in financial management of a small scale company

Assembling the Divestiture Team: Divestment of a business requires a team of functional experts under the direction of an experienced project manager. The first and foremost ac

State the concept of Overtrading Overtrading can result in insolvency which means companies have severe cash flow problems. This means that a thriving company, which may look v

What risks are associated with direct foreign investment? How do these risks differ from those encountered in domestic investment?

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

Putable bonds can be redeemed prior to maturity at the initiative of the bondholder. These bonds are more advantageous to the investors as they get an opportunity to re

Compound options are usually cheaper than vanilla options and we know that there are four main types of compound options: a call on a call; a put on a call; a call on a put; a put