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
Q. Evaluate of Risk-Adjusted Discount Rate? Illustration: - From the following date state which project is preferable: Year Project A Proj

• Prepare a Trend Analysis for the Balance Sheet, Income Statement and Cash Flow Statement • This should include about 12 accounts in the Balance Sheet and about 10 Income Statemen

Operating Leverage Operating leverage define the degree to which an organization cost of operation is fixed as opposed to variable. Therefore, it is a measure of how much a fir

Why do investors invest the lion’s share of their funds in domestic securities? Answer: Investors invest greatly in their domestic securities since there are major barriers to in

A company borrows $1,500,000 at LIBOR plus a lending margin of 1.25 percent per year on a six-month rollover basis from a London bank.  If six-month LIBOR is 4 ½ % over the first s

discuss the applicability of an operating cycle of a vegetable growing business

What is a financial ratio? A financial ratio is a number that convey the value of one financial variable relative to another.  Put more easily, a financial ratio is the final

Gross dividend At the ending of the financial year companies will announce the profits or losses that they have earned and a figure for net profit after tax. A company is able

There are fixed as well as floating rate asset-backed securities. A floating rate asset-backed security is one whose underlying pool consists of loans or receivab

Sinking fund provisions is a pool of funds set aside to repay the debt. Under this, certain amount of money is kept aside every year form profit. It is then used