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
What are the main flaws of the profit maximisation criterion The main technical flaws of this criterion are i) ambiguity, ii) quality of benefits and iii) timing of be

Explain about the Interest payments Debenture interest is generally paid semi-annually however annual payments aren't uncommon.  Usually there are registered debentures on whic

We can also express Modified duration as follows:                                                                                               ...Eq. (3) The

Why do businesses spend time, effort, and money to produce forecasts?  Explain. Businesses succeed or fail relies on how well organized they are to deal with the situations they

Suggestion regarding Credit limit. Should it be approved or not, what should be the amount of credit limit that electronics give to Booth Plastics.

Calculate the present value and determine the npv, Financial Management. Assume today is 3 December 2009. Helen is 30 years old and has a Bachelor of Business. She is currently em

You have $20 to spend on high quality pens and low quality pens. High quality pens cost $5 each and low quality pens cost $2 each.    (a) Suppose that you will spend your entire

Q. What do you mean by Average Cost and Marginal cost? Average Cost and Marginal cost: the average cost is the combined cost as explain above, but for the difference in the for

Full, Fair and Adequate Disclosure The architecture of business has evolved from proprietorship to partnership to joint stock companies or publicly held companies. Except fro

A brief scenario for each of two different organisations is presented. You are advised to read both scenarios before answering the questions that follow. Use the scenario details t