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
Do you guys provide Profitability Index Method assignment help? I need writing a report on Profitability Index Method and it is about 2000 words. Let me know. I need to buy your so

In the Index Amortizing note, the principal is repaid according to an amortization schedule linked to a specific reference rate. It is structured in such a manner

Explain the structure of financial systems In direct finance borrower-spenders borrow funds straight from lenders in the financial markets by selling them securities. In indire

Aims of FSA The aim of FSA is to promote efficient, orderly and fair markets, and to help retail consumers to get a fair deal. In fact, FSA has set out its aims under three bro

Explain the concepts of Planning the work Determine scope and objective of the audit (to verify assets, to check adequacy of internal controls etc...). Ensuring appropr

Question: Consider the following information:   Stock A Stock B Beta 0.8 1.4 Share price, $

Cash vs. Accrual Accounting: While it is beyond the scope of this module to assess accounting systems against all types of accounting styles, it is important that managers unde

Types of Treasury Bills Treasury bills are issued at various maturities, generally up to one year. Thus, they are useful in managing short-term liquidity. At present, the GOI (

Give two examples of types of companies that would be best able to handle high debt levels. Companies that manage local telephone service and those that manage natural gas deli

Determine the amounts to be recognised in profit or loss and in other comprehensive income in respect of the property for the year ended 31 December 2010.   Evaluate the compliance