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

Time series analysis, In Time Series Analysis, we try to identify and deter...

In Time Series Analysis, we try to identify and determine the pattern of changes in the data collected over regular intervals of time. The data collected can be at a periodical int

Cost principle - accounting principle, Cost Principle - Accounting Principl...

Cost Principle - Accounting Principle According to this principle all the non-monetary assets of the business are display in the books of accounts at the historical cost that

Disadvantage or redundancy of excessive working capital, Q. Disadvantage or...

Q. Disadvantage or redundancy of excessive working capital? Excessive working capital means idle funds which earns no profit for the business operation it should have nighters

Define the modigliani and miller theory of dividends, What is the Modiglian...

What is the Modigliani and Miller theory of dividends?  Explain. The Modigliani-Miller theory of dividends states that dividend theory is not relevant.  They state that it is the

Graphic presentation of organisation of finance function, Q. Graphic Presen...

Q. Graphic Presentation of Organisation of Finance Function? Graphic Presentation of Organisation of Finance Function: - The following chart describes the organization of the f

Define floating rate notes, Define Floating Rate Notes Floating-rate n...

Define Floating Rate Notes Floating-rate notes (FRNs) are commonly medium-term bonds along with their coupon payments indexed to some reference rate.  Common reference rates a

Explanation and definition of the mos, a) i = 800 units, ii = 250 units, ii...

a) i = 800 units, ii = 250 units, iii = 60% b) Explanation and Definition of the MOS. Play-it has the better MOS in absolute terms, although Tread-it has the better MOS when mea

Graphic presentation of net operating income approach, Q. Graphic Presentat...

Q. Graphic Presentation of Net Operating Income Approach ? Graphic Presentation of NOI (Net Operating Income) Approach: - NOI (Net Operating Income) approach is explained graph

Trend analysis, Do you guys provide Trend Analysis assignment help? I need ...

Do you guys provide Trend Analysis assignment help? I need writing a report on Trend Analysis and it is about 2000 words. Let me know. I need to buy your solution.

Determinants of working capital, Q. Determinants of Working Capital? D...

Q. Determinants of Working Capital? Determinants of Working Capital: - The working capital necessity is determined by a large number of factors but generally the following fa

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