Indeed, the main contribution of this paper is to propose a decision-making solution combining multicriteria analysis, fuzzy analysis, and OLAP systems, in order to generate an advanced analysis process adapted to the needs of decision makers.
Using Analytical Data to Support Decision-Making | Moody's Analytics
The development of this solution is performed according to two main axes. The first axis aims to provide an analytic context, which is different from the classical analysis cycle presented in Fig. Open image in new window. The proposed data model, which is based on the multidimensional modeling of the data warehouse, is a star dimensional structure that provides a fact table representing the new OLAP cube.
This fact table contains observable, measurable, and numerical data Kimball and Ross , derived from a structured business datamart. The abstract representation of the new proposed data cube model is shown in Fig. The general architecture of the software prototype, allowing us to take into consideration the new data cube model presented previously Figs. The proposed prototype represents a simplified implementation of our decision-making approach proposed in our previous contributions Boutkhoum et al.
It is divided into two layers: first, the Data warehouse containing the datamart that feeds the proposed data cube model; and second the interrogation and presentation layer that consists of the Mondrian OLAP server, allowing the exploration and interrogation of cube data via MDX queries. These queries are sent from the user interface to view and visualize the different analysis results. Description of the case study Issues related to the Green Supply Chain Management at the level of mining activities have serious social—environmental consequences and underlying economic implications Hilson and Nayee ; Poulton et al.
In this illustrative example linked to the field of green logistics, potential itineraries for the transport of chemicals in Casablanca industrial region see Fig. It examines several itineraries and controls their evolution during a period of time beginning from to , according to several evaluation criteria as shown in Fig.
The criteria presented in Fig. This segmentation aims to simplify the selection of these criteria and consider only those with a high final score. In this context, the evaluation of these criteria via the AMCD interface is carried out according to six complementary steps as illustrated in Fig. The first step consists in specifying the number of criteria to be considered in the evaluation. This is used by the AMCD interface to generate the comparison matrix corresponding to the number of criteria already specified.
At the beginning of the evaluation, according to the number of criteria set by decision makers using the AMCD interface step 1 presented in Fig. The role of decision makers is to complete the criteria evaluation matrix by their assessments for each criterion in relation to the others Fig. After finalizing the evaluation matrix by the linguistic appreciations of the decision group, we transform this qualitative data into numerical ones via fuzzy triangular numbers, in order to aggregate them as shown in Fig. Then, based on the geometric mean already obtained, we calculate the fuzzy weights of the criteria which are in the form of a triangular fuzzy number using Eqs.
The final step of MCA process is to make the defuzzification of the fuzzy weight obtained in Fig. The final standardized weight resulting from this defuzzification is then obtained via Eq. Consequently, we execute MDX queries via the Mondrian OLAP server Pentaho in order to illustrate the final results of the evaluation of all itineraries selected from the data cube as presented in Fig. These alternatives result from the aggregation of the values of the criteria versus the alternatives during the period — Linguistic variables Fuzzy triangular scale Good G 0.
MP 0, 0, 0. In the same context, the V-shape preference function see Fig. MP Itinerary-Ref L. The geometrical analysis for interactive aid GAIA integrated in Visual Promethee program is used as a visualization method complementing the PROMETHEE ranking methodology, which will help to display graphically the relative position of itineraries in terms of contributions to the selected criteria Fig. To sum up, the positive flow, negative flow and net outranking flow allowing to provide the final ranking of itineraries are obtained as shown in Fig.
The results obtained at this level may be sufficient, taking into consideration the objective of the decision. Acknowledgements The authors wish to thank Mr. Competing interests The authors declare that they have no competing interests. Funding There was no funding for this study. Decis Support Syst — Arab J Sci Eng 40 8 — Boutkhoum O, Hanine M, Boukhriss H, Agouti T, Tikniouine A a Multi-criteria decision support framework for sustainable implementation of effective green supply chain management practices.
Buckley JJ Fuzzy hierarchical analysis. J Parallel Distrib Comput.
Decision-Making and Problem-Solving
Environ Syst Decis. Inf Syst e-Bus Manag.
Hilson G, Nayee V Environmental management system implementation in the mining industry: a key to achieving cleaner production. Comput Sci Appl — Google Scholar.
Kaya M, Alhajj R Development of multidimensional academic information networks with a novel data cube based modeling method. Kimball R The data warehouse toolkit: practical techniques for building dimensional data warehouses. Wiley, New York.
- 2052: A Global Forecast for the Next Forty Years.
- Decision Support Systems (DSS).
- How Each Job Thinks About Data?
- Remote instrumentation for eScience and related aspects!
- Data Driven Decision Making – See 10 Tips For Your Business Success?
- Navigation menu?
Kimball R, Ross M The data warehouse toolkit: the complete guide to dimensional modeling, 2nd edn. Wiley, Hoboken Google Scholar. Scientometrics 2 — CrossRef Google Scholar.
Promethee Multicriteria decision aid methods, modeling and software. TransparentChoice helps you make decisions that are better aligned with business goals and that enjoy strong support from stakeholder. Learn more about TransparentChoice. A powerful, stand-alone application for visual quantitative modeling, leading to greater insight for analysts and decision-makers.
Learn more about Analytica.ignamant.cl/wp-includes/44/474-software-espias.php
EasyKost is a software and data publishing company that specializes in cost estimating and product design data exploration and analysis Learn more about EasyKost. EasyKost is a software and data publishing company that specializes in cost estimating and product design data exploration and analysis. Software to help organizations make better group decisions. Learn more about Paramount Decisions.
Decision-making software for prioritization, group decision-making, conjoint analysis, MCDM and maximizing value for money. Free trial. Learn more about minds Decision Making. Learn more about Apex. Collective[i] hosts one of the largest networks of sales data that is combined with AI and predictive analytics to create intelligence. Learn more about Collective[i]. Automates the selection and quoting for IT projects by aggregating information about the cost, capacity and capability of your company.
- One Anothering: Biblical Building Blocks for Small Groups!
- Decision Support Systems and Processes for Groundwater.
- Archetypes And Motifs In Folklore And Literature: A Handbook.
Learn more about opTEAMize. Supports decision and risk analysis by simulating future performance.
Learn more about GoldSim. Strategy Management and Strategic Prioritization software that structures, quantifies and simplifies executive and business decisions. Learn more about Allovance. Easy-to-use decision tree that automatically sifts large, complex databases for significant patterns and relationships.
Learn more about CART. Integrated set of programs for risk analysis and decision making under uncertainty. Learn more about DecisionTools Suite. Piik helps retailers and restaurants make profitable decisions by recommending data-driven actions using AI and advanced analytics. Learn more about Piik. A decision support tool for professionals using multi criteria decision analysis MCDA.
Collaboration software that helps organizations make better decisions that achieve alignment and buy-in with speed and transparency. Learn more about Expert Choice.
- Reunions of the Heart: Romantic Short Story (Short Stories by CJ Grant Book 1);
- Conquistador in Chains: Cabeza de Vaca and the Indians of the Americas.
- Decision support system - Wikipedia?
- Processing and Managing Complex Data for Decision Support.
FICO Blaze Advisor is the world's leading decision rules management system, maximizing control over high-volume operational decisions. Datahug is a predictive forecasting solution for CRM that helps sales teams to increase sales velocity and reduce pipeline risk. Learn more about Datahug. Helps you make a comprehensive qualitative model which can be analyzed to help develop strategy, decision making and business problems. Learn more about Decision Explorer. Decision support solution that helps staff to make decisions within a framework of policy and principles.
Learn more about Assisstum. Learn more about AVDecision. Our Best Offer Advisor updates you each time you receive an offer with all the necessary data needed to make a smart decision. Learn more about Best Offer Advisor. Decision support software for large-scale and all hazard incidents; critical tools, guides, forms, checklists and incident reporting. Learn more about CoBRA. Project and portfolio management software used by hundreds of organizations to optimize projects and resources. Learn more about Concerto.
Cloud-based software solutions for portfolio prioritization and selection, focused on modelling, scenario comparison, and analytics. Learn more about Decision Lens. Learn more about Decision Optimizer. Rules based, decision system for extending enterprise application functionality without burden to resources, budgets, project time.