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

Project, Starbucks future cash flows

Starbucks future cash flows

Capital structure, Modi Wires and Cable Ltd intends to finance its INR 20 m...

Modi Wires and Cable Ltd intends to finance its INR 20 million modernization plan for which it is trying to decide between debt and external equity. The management feels that the e

Examine the concepts related to financial management, Assume you are a prof...

Assume you are a professional financial analyst working for a wealthy investor.  Your client has $2.6 million to invest and wants to sink it into a single stock (diversification is

Find the nominal rate of interest, (a) Find the nominal rate of interest j ...

(a) Find the nominal rate of interest j compounded quarterly which is equivalent to a 5% e ective rate of interest. (b) Which one will deliver a higher future value on a deposit

What do you mean by variable working capital, Q. What do you mean by Variab...

Q. What do you mean by Variable working capital? Permanent or fixed: Permanent or fixed working capital is the minimum amount which is required to ensure effective utilization

Payback period, Payback Period It is an amount of time, mainly measured...

Payback Period It is an amount of time, mainly measured in years; it takes previously the undiscounted cash inflows from a project equal the cash outflow. It indicates the leng

Explain the major types of audit plans, Explain the major types of audit pl...

Explain the major types of audit plans Three major types of audit plans Strategic -this the long term forward looking audit, it continually gets updated and identifies are

Show internal business risk, Internal business risk associated with the ope...

Internal business risk associated with the operational efficiency of the firm. The operational efficiency differs from company to company. The efficiency of operation is reflected

#pseudocode.., #pseudocode for finance class ..

#pseudocode for finance class ..

Illustrate the method of appraising capital investments, Q. Illustrate the ...

Q. Illustrate the method of appraising capital investments? One of the potency of internal rate of return (IRR) as a method of appraising capital investments is that it is a di

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