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

How is present value affected by a change in discount rate, How is present ...

How is present value influenced by a change in the discount rate? Present value is oppositely related to the discount rate.  Alternatively, present value moves in the reverse dire

What do you meant by common stocks in the financial term, What do you meant...

What do you meant by common stocks in the financial term? Common Stocks: Common stocks illustrate ownership interests into the firm. Common stockholders obtain dividends (wh

Define why it is difficult to forecast future exchange rates, Researchers f...

Researchers found that it is extremely difficult to forecast the future exchange rates more precisely than the forward exchange rate or the current spot exchange rate. How would yo

Create a financial institution’s balance sheet, Question. 1 Using D to...

Question. 1 Using D to assess the interest rate risk of a financial institution's balance sheet Background: Point 1. A business is 'insolvent' when it has negative eq

Secured versus unsecured bonds, Along the dimension of security, bond...

Along the dimension of security, bonds can be classified into unsecured (straight) bonds and secured (mortgage) bonds. Unsecured bonds have no charge on any speci

Calculate average annual return, Q. Calculate Average Annual Return? An...

Q. Calculate Average Annual Return? An investor buys a bond in 1978 maturity in 1980 at Rs.900. It has a maturity value of 10 years and par value of Rs. 1000. It fetches RS.90

Valuation using forward rates, We can discount cash flows either by u...

We can discount cash flows either by using spot rates or forward rates, because a spot rate is simply a package of short-term forward rates. Assume that the cash

Bond indenture, Bond Indenture An indenture builds the formal conditio...

Bond Indenture An indenture builds the formal conditions of a lending relationship between a borrower and a lender. It is a written record, and it outlines most important func

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