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

What difference does it make ordinary annuities, If you are doing PVA and F...

If you are doing PVA and FVA problems, what difference does it make if the annuities are "ordinary annuities" or "annuities due"? In PVA or a FVA of annuity due trouble, annuit

How could we project exchange rates, How could we project exchange rates in...

How could we project exchange rates in order to be able to forecast exchange differences? If someone knew how to predict exchange rates, they would be a millionaire and would n

What are retained earnings, What are retained earnings?  Why are they impor...

What are retained earnings?  Why are they important? Retained earnings represent the total of all the earnings available to common stockholders of a business during its complet

First, how do you calculate the current ratio

how do you calculate the current ratio

Monte carlo simulation model, Monte Carlo Simulation Model Monte Carlo...

Monte Carlo Simulation Model Monte Carlo simulation is used to analyse to what extent the valuation of the chosen company is dependent on the assumptions. Monte Carlo simulati

How to calculate annual yield for security?, Illustration  The mo...

Illustration  The monthly yield of a mortgage backed security is 0.75%. Find out the annual yield for this security. Solution Annual yield = 2 [(1 + 0

Importance of mutual funds in the investment intermediaries, Define the imp...

Define the importance of mutual funds in the investment intermediaries. Mutual funds: Mutual funds pool resources by several companies and individuals and invest these re

Calculate profitability index, XYZ Ltd is a manufacturer and distributor of...

XYZ Ltd is a manufacturer and distributor of agricultural equipment. XYZ produces milking machines and supplies as well as being the sole Australian distributor of machinery from t

Illustrate coefficient of correlation, Q. Illustrate Coefficient of Correla...

Q. Illustrate Coefficient of Correlation? The square of the correlation co-efficient is the co-efficient of determination. It gives the percentage of variation in the stock's r

Advantages and disadvantages of investing in gilts, Advantages and Disadvan...

Advantages and Disadvantages of Investing in Gilts Advantages As the security is issued by the GOI, it has a minimal default risk. Investors have the opportunity to inves

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