What Businesses, Groups, and Professionals can do when Faced with Stagnation
What to do when Businesses and Professionals Stagnate Stagnation can happen to anyone. Whether they are businesses, nations, societies, groups, or individuals, the prospect of withering away due to lack of growth or career mobility or opportunities can make even the most resilient of the institutions to atrophy and stagnate. Indeed, the fact that there […]
Reverse Logistics & SCM – Scope and Advantages
Supply Chain Management is concerned not only with the flow of raw materials and finished goods, but scope extends beyond this to include reverse flow of unsold finished goods, parts and packaging materials from the point of consumption at customer’s end back to the organization or to rework/refurbishing vendors. Today reverse logistics has been adopted […]
The Global Economic Crisis and its Impact on India
Much has been written about the way in which India was one of the few countries that was relatively unscathed because of the global economic crisis. Most of these narratives focused on how India managed to weather the storm in the dark days following the collapse of Lehmann Brothers. However, it cannot be completely said […]
Business Process Re-Engineering – Meaning, its Need and Technology
Hammer and Champy’s concept of Business Process Re-Engineering depends on harnessing technology to optimize processes as its main driver. To understand why technology is imperative for BPR, let’s first review what BPR does. What is BPR? “BPR is the fundamental rethinking and radical redesign of business processes to achieve dramatic improvements in critical contemporary measures […]
Step 1: Selecting the Correct Variables to Monitor
Since the entire premise of having a Six Sigma process is based on measurement, comparison of measurements and setting corrective action plans, it is crucial that the variables (metrics) being measured are appropriate. Wrong measurements lead to wrong decisions which are expensive and a wastage of time and resources. As explained in the Define module, […]
One of the critical components in the information technology age is the data. Data is the source of all the information and information is valuable for decision making process.
Decision support systems are developed to support executive management and relevant decision makers. In the modern era, there is large volume of information is available. Data warehouse is required to store huge volume of data.
Since the data warehouse is supporting decision support system, therefore, it should be subject oriented, integrated, collected over a period of time and static.
Data warehouse has subject oriented data. This subject oriented data could be information such as sales, customer name, etc. Data warehouse excludes information, which is not useful for decision-making process.
Data warehouse is developed as an integration of multiple heterogeneous data sources. As the data source have their own data protocol, data processing is required while data warehousing.
Data warehouse provides information with time as function. This gives historical perspective to the information.
Once data is captured into the data warehouse, it cannot be changed.
Data within the data warehouse is maintained in form of star schema, snowflake schema and galaxy schema.
The data mart is that portion of the access layer of the data warehouse which is utilized by the end user. Therefore, data mart is a subset of the data warehouse. Data mart is usually assigned to a specific business unit within the enterprise. Data mart is used to slice data warehouse into a different business unit. Typically, ownership of the data mart is given to that particular business unit or department.
The primary utility of data mart is business intelligence. A data mart requires very less investment compared to data warehouse and therefore it is apt for smaller business. Set up time for data mart is very less again making it practical for smaller business.
The main advantages of data mart are as follows:
OLAP or Online Analytical Processing is a concept in which data is analyzed through multiple dimensions with help of structure called cube. OLAP helps in converting data into information.
The main objective of OLAP is to summarize information for decision making process from large data base. The report generated through OLAP can be presented in a format as per the requirement of end user.
The advantages of OLAP are as follows:
There are three types of OLAP multi-dimensional OLAP, relational OLAP and Hybrid OLAP. In multi-dimensional OLAP data is usually stored in proprietary structure suitable for multi-dimensional analysis. In relational OLAP data base is structure through standard database in star or snowflake schema. A combination of multi-dimensional OLAP and relational OLAP is the hybrid OLAP.
Your email address will not be published. Required fields are marked *
Communication Systems and Groupware – Information System Concepts that Apply in All Functional Areas of Business
February 12, 2025
