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

Risk return relationship, RISK RETURN RELATIONSHIP A business operates...

RISK RETURN RELATIONSHIP A business operates in a market environment, which is not within its control. It is exposed to several dangers from the internal with external sources

Terms of maturity date very short term, 1. (a) A barbell is a approach of...

1. (a) A barbell is a approach of maintaining a portfolio of securities concentrated at two extremes in terms of maturity date very short term and very long term. A positive

Obtain the break even rate, Question 1 (a) These are merely the diffe...

Question 1 (a) These are merely the differences of the two prices. Consequently the mark to market losses are given by { Q 1 - Q 0 ,Q 2 - Q 0 ,Q 3 - Q 0

State the rate of return of a bond - debt securities, Rate of return of a B...

Rate of return of a Bond In case of bonds, rather than dividends, investor is entitled to payments of interest yearly or semi-annually. Investor also benefits if there is an ap

Explain the capital market process, Question 1 State the key functions of ...

Question 1 State the key functions of the financial market. Question 2 Define "Bill of exchange". What are its features? Give different types of cheques. Question 3

Calculate the net present value-investment proposal, As you checked the Ans...

As you checked the Answer Key to Question 6 in the Mastery Check from this lesson you may have noted that each year's net cash flows are calculated by adding depreciation back to n

Decision making, Write a report to the Board of Directors of Solvent Ltd to...

Write a report to the Board of Directors of Solvent Ltd to analyse the performance of companies X and Y and to give recommendation as which of those two investment opportunities is

Estimate the npv of the project?, Wing Yin Tsui, CEO of Lian Huang & Wong B...

Wing Yin Tsui, CEO of Lian Huang & Wong Bin Dean Hwang Manufacturing Limited is considering a four year project. The project requires an initial investment of $10,000,000 to buy ne

Explain vernon’s product life cycle theory of fdi, Explain Vernon’s product...

Explain Vernon’s product life-cycle theory of FDI. What are the strength and weakness of the theory? Answer:  As to the product life-cycle theory, companies undertake FDI at a ce

Global economy, Global Economy: The size of the world stock market grew...

Global Economy: The size of the world stock market grew steadily in the 1970s and 1980s and crossed the $12 trillion figure in 1993. The share of the US market decreased tremen

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