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

Explain the types of debt securities, Explain the Types of Debt Securities ...

Explain the Types of Debt Securities There are many types of debt securities available in market.  The range includes Government Securities, Deep discount bonds, Deben

ABF, HOW TO CALCULATE ASSESSED BANK FINANCE

HOW TO CALCULATE ASSESSED BANK FINANCE

What is rectification of errors, Principles of Financial Accounting and Man...

Principles of Financial Accounting and Management 1. Define Accounting. Briefly explain the ‘Entity Concept' and ‘Money Measurement Concept' of accounting. 2. What is rectif

Define the conversion ratio and conversion value, Define the following term...

Define the following terms that relate to a convertible bond:  conversion ratio, conversion value, and straight bond value. The term conversion ratio is the number of shares of c

Consolidations of merger - amalgamation, Consolidations of Merger - amalgam...

Consolidations of Merger - amalgamation A consolidation is a combination of two or more companies into a new company. In this form of merger all the existing companies which co

Show the limitations of participation, Limitations of participation: 1...

Limitations of participation: 1. Technology and organization today are so complex that specialized work roles are required making it difficult for people to participate succes

Describes the techniques of work breakdown structure, Due to the complexity...

Due to the complexity of the tasks involved in many projects, communication of responsibility for those tasks is often helped by means of graphical planning techniques.

Venn diagram, d iscuss the relationship between finance management,economic...

d iscuss the relationship between finance management,economics,accounting, and mathematics. illustrate/show through a venn diagram

Operating cycle, application of the operating cycle to a vegetable company

application of the operating cycle to a vegetable company

State the different accounting policies, State the different accounting pol...

State the different accounting policies Different accounting policies which can be adopted will have an influence on the ratios calculated and hence make comparisons more diffi

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