Assignment on bank exercise

Assignment Help Business Management
Reference no: EM133215642

Bank Exercise

A consortium of banks wants to develop a data warehouse for effective decision-making about their loan schemes. The banks provide loans to customers for various purposes, like, House Building Loan, Car Loan, Educational Loan, Personal Loan, etc. The whole country is categorized into several regions, namely, North, South, East and West. Each region consists of a set of states. Loan is disbursed to customers at interest rates that change from time to time. Also, at any given point of time, the different types of loans have different rates. The data warehouse should record an entry for each disbursement of loan to customer. With respect to the above business scenario, answer the following questions. Clearly state any reasonable assumptions you make.

a. Starting with the base, if we want to see the amount of loan disbursed during the year 2000 for the state of Florida.  Which sequence of OLAP operations would you need to perform?

Reference no: EM133215642

Questions Cloud

Work-family and gender inequality : Read the following article; The time divide: work, family, and gender inequality. Harvard University Press.
Discussion of grand narrative to your research area : How can you apply Wolters' discussion of the Grand Narrative to your research area?
Conflict among individuals can bring to an organization : Identify at least three advantages that conflict among individuals can bring to an organization.
What kind of cultural and creative products you bought : What kind of cultural and creative products you have ever bought? Please specific the item you bought. What the main intentions stimulate you to buy
Assignment on bank exercise : A consortium of banks wants to develop a data warehouse for effective decision-making about their loan schemes. The banks provide loans to customers for various
Finance entrepreneurial ventures : SBA (2008) claim that there is no such thing as one hundred percent financing and that it would be required from the entrepreneur to invest some funds into the
Philosophical backgrounds of modern psychology : What are the philosophical backgrounds of modern psychology? What is the biblical or theological basis for addressing psychological issues?
Conducting a formal meeting : What ethical and legal issues must you adhere to when conducting a formal meeting? When chairing the meeting, explain how you can stimulate discussion.
Google organizational structure and controls : Evaluate/critique your Google's organizational structure and controls. What recommendations do you have for modifying the organizational structure and controls?

Reviews

Write a Review

Business Management Questions & Answers

  Concerning cross-cultural communication

Concerning cross-cultural communication, what is the difference between verbal differences and non-verbal differences? Please give one example to support your a

  What is the cost of equity capital for gm

GM has a current stock price of $92.38. If they issued a dividend of $4.56 last week, and the dividend is projected to grow at 4% what is the cost of equity cap

  What is a marketing strategy

Explain in your own words, what is a marketing strategy and cite an example of a product you think has an effective marketing strategy.

  Concept of diminishing marginal utility

How does the concept of diminishing marginal utility explain the different distribution techniques for newspapers vs. snacks and beverages?

  Write an applet that simulates a soft drink vending machine

Write an applet that simulates a soft drink vending machine. When the applet starts, the drink machine should have a supply of 10 of each of the drinks.

  How many total people would you invite and why

Who you invite to the conference? How many total people would you invite, and why? Any other specifics planning details that you would address to ensure the success of the event?

  What are amazon major strengths

What are Amazon's major strengths?Is Jet.com a potential concern for Amazon? Why or why not?

  Impact of culture on costs of doing business in country

Show how culture, language, and religion might influence the costs of doing business in a particular country. Support your statement with examples.

  Find out career management process

If you are asked to change your career, how you will apply the Career Management Process to make a smooth career transition?

  Rate of growth and controlling interest in the firm

What are the advantages and disadvantages of have each level of stake in a firm? What implication would those advantages or disadvantages

  Reflect on your research - how to grow your business

Report and presentation must reveal that you understand your thesis, your research and utilize it in developing the analytical content of your paper

  Out of control process

Which of the following patterns on an averages chart that displayed 25 sample averages would reveal an out of control process?

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