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

Foreign exchange - maximum loss, Q. Foreign exchange - Maximum loss? Fr...

Q. Foreign exchange - Maximum loss? From Marton's point of view an adverse outcome is depreciation of the dollar against sterling as this lowers its income when converted into

Determine rates that company enter into a $/£ currency swap, Suppose a comp...

Suppose a company is quoting swap rates as follows:  7.75 - 8.10 percent yearly against 6-month dollar LIBOR for dollars and 11.25 - 11.65 percent yearly against six-month dollar L

Prepare a statement of financial position, Brown has been in business for s...

Brown has been in business for some years and has kept her drawings slightly below the level of profits each year. You are her accountant, and she has passed you the following list

Show the transaction risk, Q. Show the Transaction risk? This is the ri...

Q. Show the Transaction risk? This is the risk occur on short-term foreign currency transactions that the actual income or cost may be different from the income or cost expecte

Calculate the net present value of a purchase of earthmover, Your construct...

Your construction company is evaluating the proposed acquisition of a new earthmover. A consulting company you hired developed the following analysis last year at a cost to you of

How does continuous compounding benefit an investor, How does continuous co...

How does continuous compounding benefit an investor? The effect of enhancing the number of compounding periods per year is to increase the future value of the investment.  The

Specialized stock indexes, Specialized Stock Indexes The most regularly...

Specialized Stock Indexes The most regularly quoted market indices are those that include the stocks of the largest listed companies on a nation's largest stock exchange. Examp

Above the line deduction, Above the line deductions are certain kinds of de...

Above the line deductions are certain kinds of deductions that are deducted from your income before the adjusted gross income is computed for tax purposes. Above the line deduct

Brief on mistakes in linton’s evaluation, Mistakes in Linton's evaluation ...

Mistakes in Linton's evaluation (1) The preliminary investment in working capital should be offset by a working capital release in the final year, assuming a constant level of

Segment margin, Segment Margin This is the amount in which a business s...

Segment Margin This is the amount in which a business segment in a company contributes toward the common or indirect cost of the company. Therefore, it represents that segment'

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