scholarly journals Decision making based on data analyses using data warehouses

2017 ◽  
Author(s):  
Valdrin Haxhiu
2018 ◽  
Vol 6 (3) ◽  
pp. 1-6
Author(s):  
Valdrin Haxhiu

Data warehouses are a collection of several databases, whose goal is to help different companies and corporations make important decisions about their activities. These decisions are taken from the analyses that are made to the data within the data warehouse. These data are taken from data that companies and corporations collect on daily basis from their branches that may be located in different cities, regions, states and continents. Data that are entered to data warehouses are historical data and they represent that part of data that is important for making decisions. These data go under a transformation process in order to accommodate with the structure of the objects within the databases in the data warehouse. This is done because the structure of the relational databases is not similar with the structure of the databases (multidimensional databases) within the data warehouse. The first ones are optimized for transactions on daily basis like: entering, changing, deleting and retrieving data through simple queries, the second ones are optimized for retrieving data through multidimensional queries, which enable us to extract important information. This information helps to make important decisions by learning which are the weak points and the strong points of the company, in order to invest more on the weak points and to strengthen the strong points, increasing the profits of the company. The goal of this paper is to treat data analyses for decision making from a data warehouse by using OLAP (online analytical processing) analysis. For this treatment we used the Analysis Services of Microsoft SQL Server 2016 platform. We analyzed the data of an IT Store with branches in different cities in Kosovo and came to a conclusion for some sales trends. This paper emphasizes the role of data warehouses in decision making.


2019 ◽  
Vol 22 ◽  
pp. S834
Author(s):  
S. Brodinova ◽  
M. Ihl ◽  
V. Hormayer ◽  
F. Miksch ◽  
S. Böhm ◽  
...  

2016 ◽  
Vol 8 (2) ◽  
Author(s):  
Arif Hasan ◽  
Dedi Budiman Hakim ◽  
Irdika Mansur

This study aims to analyze causes of the low uptake of the budget and formulate a strategy of maximizing the absorption of expenditure on Balai Penelitian dan Pengembangan Lingkungan Hidup dan Kehutanan Manokwari. Respondents involved are 20 people that consist of: treasury officials and holder output of activity. The data used were secondary data in the form of reports on budget realization (LRA) quarter I, II, III and IV of the fiscal year 2011 to 2015, and the primary data were in the form of interviews with the help of a questionnaire. While the analysis of the data used was descriptive analysis using data tabulation, and the analysis of the three stages strategy of the decision making used IFE and EFE matrix, SWOT matrix and QSPM matrix.The results showed that there are 19 factors causing low of budget absorption until the end of the third quarter, and there were 10 drafts of policy as a strategy for maximizing the absorption of the budget on Balai Penelitian dan Pengembangan Lingkungan Hidup dan Kehutanan Manokwari.ABSTRAKPenelitian ini bertujuan untuk menganalisis penyebab rendahnya penyerapan anggaran belanja dan merumuskan strategi maksimalisasi penyerapan anggaran belanja pada Balai Penelitian dan Pengembangan Lingkungan Hidup dan Kehutanan Manokwari. Responden yang terlibat adalah 20 orang yaitu pejabat perbendaharaan dan pemegang output kegiatan. Data yang digunakan adalah data sekunder berupa laporan realisasi anggaran (LRA) triwulan I, II, III dan IV tahun anggaran 2011 sampai 2015, dan data primer berupa wawancara dengan bantuan kuesioner. Sedangkan analisis data yang digunakan adalah analisis deskriptif menggunakan analisis tabulasi, dan analisis analisis strategi tiga tahap pengambilan keputusan menggunakan matriks IFE dan EFE, matriks SWOT dan matriks QSPM. Hasil penelitian menunjukkan bahwa terdapat 19 faktor penyebab rendahnya penyerapan anggaran belanja sampai akhir triwulan III, dan terdapat 10 rancangan kebijakan sebagai strategi maksimalisasi penyerapan anggaran belanja di Balai Penelitian dan Pengembangan Lingkungan Hidup dan Kehutanan Manokwari.


2020 ◽  
Vol 48 (7) ◽  
pp. 1-12
Author(s):  
Ran Xiong ◽  
Ping Wei

Confucian culture has had a deep-rooted influence on Chinese thinking and behavior for more than 2,000 years. With a manually created Confucian culture database and the 2017 China floating population survey, we used empirical analysis to test the relationship between Confucian culture and individual entrepreneurial choice using data obtained from China's floating population. After using the presence and number of Confucian schools and temples, and of chaste women as instrumental variables to counteract problems of endogeneity, we found that Confucian culture had a significant role in promoting individuals' entrepreneurial decision making among China's floating population. The results showed that, compared with those from areas of China not strongly influenced by Confucian culture, individuals from areas that are strongly influenced by Confucian culture were more likely to choose entrepreneurship as their occupation choice. Our findings reveal cultural factors that affect individual entrepreneurial behavior, and also illustrate the positive role of Confucianism as a representative of the typical cultures of the Chinese nation in the 21st century.


2021 ◽  
Vol 3 (6) ◽  
Author(s):  
César de Oliveira Ferreira Silva ◽  
Mariana Matulovic ◽  
Rodrigo Lilla Manzione

Abstract Groundwater governance uses modeling to support decision making. Therefore, data science techniques are essential. Specific difficulties arise because variables must be used that cannot be directly measured, such as aquifer recharge and groundwater flow. However, such techniques involve dealing with (often not very explicitly stated) ethical questions. To support groundwater governance, these ethical questions cannot be solved straightforward. In this study, we propose an approach called “open-minded roadmap” to guide data analytics and modeling for groundwater governance decision making. To frame the ethical questions, we use the concept of geoethical thinking, a method to combine geoscience-expertise and societal responsibility of the geoscientist. We present a case study in groundwater monitoring modeling experiment using data analytics methods in southeast Brazil. A model based on fuzzy logic (with high expert intervention) and three data-driven models (with low expert intervention) are tested and evaluated for aquifer recharge in watersheds. The roadmap approach consists of three issues: (a) data acquisition, (b) modeling and (c) the open-minded (geo)ethical attitude. The level of expert intervention in the modeling stage and model validation are discussed. A search for gaps in the model use is made, anticipating issues through the development of application scenarios, to reach a final decision. When the model is validated in one watershed and then extrapolated to neighboring watersheds, we found large asymmetries in the recharge estimatives. Hence, we can show that more information (data, expertise etc.) is needed to improve the models’ predictability-skill. In the resulting iterative approach, new questions will arise (as new information comes available), and therefore, steady recourse to the open-minded roadmap is recommended. Graphic abstract


2021 ◽  
Vol 24 (1_part_3) ◽  
pp. 2156759X2110119
Author(s):  
Brett Zyromski ◽  
Catherine Griffith ◽  
Jihyeon Choi

Since at least the 1930s, school counselors have used data to inform school counseling programming. However, the evolving complexity of school counselors’ identity calls for an updated understanding of the use of data. We offer an expanded definition of data-based decision making that reflects the purpose of using data in educational settings and an appreciation of the complexity of the school counselor identity. We discuss implications for applying the data-based decision-making process using a multifaceted school counselor identity lens to support students’ success.


2021 ◽  
Vol 80 (15) ◽  
Author(s):  
Elham Rafiei Sardooi ◽  
Ali Azareh ◽  
Tayyebeh Mesbahzadeh ◽  
Farshad Soleimani Sardoo ◽  
Eric J. R. Parteli ◽  
...  

2020 ◽  
pp. 096366252097856
Author(s):  
Matthew C. Nowlin

The use of technocratic decision-making, where policy decisions are made by elite experts, is an important aspect of policymaking in the United States. However, little work has examined public opinion about technocracy. Using data from a representative sample of the United States ( n = 1200), I explore differences in support for technocracy and the implications of that support for views about politically controversial energy sources and climate policies. Overall, I find that liberal Democrats, moderate/conservative Democrats, and moderate/liberal Republicans were more likely than conservative Republicans and moderate independents to support technocratic decision-making. In addition, I find that as support for technocracy increases, so does support for energy sources and climate policies; however, there are significant interaction effects across political beliefs.


2021 ◽  
Vol 11 (3) ◽  
pp. 129
Author(s):  
Gabrielle Wilcox ◽  
Cristina Fernandez Conde ◽  
Amy Kowbel

There are longstanding calls for inclusive education for all regardless of student need or teacher capacity to meet those needs. Unfortunately, there are little empirical data to support full inclusion for all students and even less information on the role of data-based decision making in inclusive education specifically, even though there is extensive research on the effectiveness of data-based decision making. In this article, we reviewed what data-based decision making is and its role in education, the current state of evidence related to inclusive education, and how data-based decision making can be used to support decisions for students with reading disabilities and those with intellectual disabilities transitioning to adulthood. What is known about evidence-based practices in supporting reading and transition are reviewed in relationship to the realities of implementing these practices in inclusive education settings. Finally, implications for using data-based decisions in inclusive settings are discussed.


Sign in / Sign up

Export Citation Format

Share Document