Identify an analytic theme for fictitious business, Financial Management

Assignment Help:

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

 


Related Discussions:- Identify an analytic theme for fictitious business

Condition market to book value ratios be misleading, Under what circumstanc...

Under what circumstances would market to book value ratios be misleading?  Explain. The Market to Book ratio is helpful, but it is just only a rough approximation of how liquid

Budget classification on the basis of functions, ON THE BASIS OF FUNCTIONS ...

ON THE BASIS OF FUNCTIONS •Functional / Subsidiary budgets: A subsidiary budget is a budget of income or expenditure appropriate to or the responsibility of functions, like

Aggressive approach of financial management, Q. Aggressive Approach of fina...

Q. Aggressive Approach of financial management? A -firm may be aggressive in financing its assets. An aggressive policy is said to be followed by the firm when it uses short-te

Convexity measure , We can measure the convexity with the help of following...

We can measure the convexity with the help of following formula:                                                                              ...Eq. (4) Where,          Δ

Computation of the cost of capital, Q. Computation of the cost of capital? ...

Q. Computation of the cost of capital? Computation of overall cost of capital of the firm invoices Cost of debts: debt may be issued at par , at premium or discount it may

Examine about the risk-based auditing, Examine about the Risk-based auditin...

Examine about the Risk-based auditing A risk based audit will be reviewing the risk management process and considering main risks of the organisation as a whole. Risk manage

Net present Value, Given below are the cash flows of a project. Find out th...

Given below are the cash flows of a project. Find out the net present value of the project. Cost of capital is 18% and initial investment is Rs. 2,00,000. Year Cash Flows (lakhs)

Capital investment decisions, what are the key stages in capital investment...

what are the key stages in capital investment decision-making process and the role of investment appraisal in this process?

International financial management - a European perspective , To whom it ma...

To whom it may concern, I wanna someone to help me to get prepared for my exam. is it possible to work together? 1. Managerial Aspects of the Market for Foreign Exchange

Write Your Message!

Captcha
Free Assignment Quote

Assured A++ Grade

Get guaranteed satisfaction & time on delivery in every assignment order you paid with us! We ensure premium quality solution document along with free turntin report!

All rights reserved! Copyrights ©2019-2020 ExpertsMind IT Educational Pvt Ltd