Learn how to make better business decisions, use fewer resources, and improve your company's bottom line by developing and using a data warehouse. This course provides an overview of business intelligence and data warehousing and gives you a look at all the major facets of developing and using a data warehouse to make effective business decisions. You'll work on a single project that allows you to develop a project plan and business case for a data warehouse, develop a dimensional model, develop a data staging process, and develop a data access process. You'll also learn about careers working with business intelligence and data warehousing as well as the educational requirements for this field.

Learn how to build a high performance dimensional data model. A good dimensional model and its physical database form the hub of a business intelligence data warehouse, serving as the target of the data integration and as the source of business intelligence data. This course provides both introductory and advanced concepts and techniques for developing effective dimensional models. Learn how to design dimensional models for extensibility, employ a proven dimensional design process, apply the process to several representative situations, and understand a variety of advanced dimensional modeling techniques.

Learn how the structured approach of business process improvement (BPI) can be performed at all levels in an organization. Through a series of training activities, you will learn how to select, design, sell, implement, and institutionalize the changes necessary for effective BPI. Determine the process flow of a project, evaluate ineffective use of time, and change the process for improved effectiveness. In addition, collaborate on a class project that will allow for application of techniques to organization's processes and procedures.

Get a conceptual framework to approaching problem-solving and decision-making situations with clarity and confidence. Gain competence in making effective decisions based on accurate assessment of a problem and preparing creative alternative solutions. Learn how to use analysis, synthesis, and positive inquiry to approach individual and organizational problems, develop and evaluate objectives, and assess likely consequences. Using case studies and on-the-job situations encountered by the class, explore successful models and proven methods that are readily transferable on-the-job.

The success of projects is dependent upon people and how effectively they work and communicate with one another. You will reflect upon your role as a manager/ leader within a project management framework. Explore concepts of human behavior, motivation, problem solving, decision-making, influence, conflict management, and organization structure. Build skills in recognizing and managing project stakeholders, communications, team development, and working with virtual team members, via presentations, case studies, readings, essays, and discussions.

Learn to apply and effectively use statistical concepts and computation in a business environment. Determine the need for descriptive or inferential statistics in a given situation. Study probability methods from a practical and applied perspective. The emphasis in this course is on data analysis and interpretation of the results, not on computation and implementation of formulas. The course assumes only basic knowledge of algebra; calculus is not required. Learn how to efficiently collect the data needed to answer statistical questions properly, and how to address the question in a rational way once the data are collected.