Ask Dan! about DSS

Frequently Asked Questions about Decision Support Systems by Dan Power

Search

48 results for "pivot tables"

Question	Category	Date
How important are pivot tables in data-driven decision support? by Dan Power Editor, DSSResources.com Some analysis tools are used more and are used more effectively than others. For example, pivot tables hav...	DSS Foundations	Jun 25, 2011
What is analytical processing? by Dan Power Editor, DSSResources.com Transforming data and summarizing it is a key task in many decision making situations. Once this task is co...	DSS Foundations	Feb 12, 2010
What are examples of routine decision support queries? by Dan Power Editor, DSSResources.com In the mid-1980s, the introduction of powerful relational database management systems (RDBMS) like Oracle ...	DSS Foundations	Jul 22, 2009
What are the features of a data-driven DSS? by Daniel J. Power Editor, DSSResources.COM Data-driven DSS are the most common of the five types of decision support systems in the expanded DSS...	Data-driven DSS	Mar 02, 2007
What SQL knowledge do managers need for decision support queries? by Dan Power Editor, DSSResources.com Structured Query Language (SQL)is considered difficult for most managers to learn and use. SQL is a complex...	Data-driven DSS	Mar 18, 2011
What should managers know about business intelligence and data-driven decision support? by Dan Power Editor, DSSResources.COM Most managers want to make fact-based decisions. Many large organizations have implemented database syste...	DSS Foundations	Aug 13, 2012
What are concerns about end-user DSS development? by Dan Power Editor, DSSResources.com End-user development of decision support systems (DSS) puts the responsibility for building and maintaining...	Building DSS	Jun 02, 2010
Is a Data Warehouse a DSS? What is a star schema? No, a data warehouse is not a Decision Support System. A data warehouse is however usually the "driver" and dominant component for a Data-dr...	Data-driven DSS	Aug 06, 2005
What is a columnar database? by Daniel J. Power Editor, DSSResources.COM A columnar database stores data tables as sections of columns of data rather than as rows of data. Ch...	DSS Foundations	May 02, 2013
What are the most common database design mistakes? by Daniel J. Power Editor, DSSResources.COM In a 2008 eWeek slide show, Brian Prince identified "The Most Common Database Design Mistakes." The l...	DSS Foundations	Aug 03, 2013
What is a spreadsheet-based DSS? by Dan Power Editor, DSSResources.com Most managers are familiar with spreadsheet packages like Microsoft Excel. If a decision support system (D...	Model-driven DSS	Jan 30, 2017
How does DSS data differ from operational data? by Daniel J Power Editor, DSSResources.com Decision support data used for analytics and data-driven DSS is related to past actions and intentions...	DSS Foundations	Aug 07, 2016
What are physical database design tradeoffs for decision support data? by Dan Power Editor, DSSResources.com Implementing a decision support database involves tradeoffs. A designer needs to transform an ideal, logi...	DSS Foundations	Oct 01, 2008
What is business intelligence? by Dan Power Editor, DSSResources.com Business intelligence (BI) is often viewed as a term similar to military or competitive intelligence. And h...	DSS Foundations	Aug 06, 2005
What is reporting software? by Dan Power Editor, DSSResources.com Reports organize data to create information that can be shared with others. For example, a quarterly financi...	DSS Foundations	Jan 09, 2016
What should be taught in a Business Intelligence/Data-Driven DSS course? by Dan Power On Tuesday, December 13, 2005, Michael Lane, Lecturer Information Systems Department, Faculty of Business, University of Southern ...	Data-driven DSS	Aug 01, 2006
What are best practices for BI reports? by Dan Power Editor, DSSResources.com Structured, periodic reports remain at the center of data-driven decision support for managerial decision...	Building DSS	Nov 15, 2007
How does sensitivity analysis differ from "What if?" analysis? by Dan Power Editor, DSSResources.COM In the early days of decision support deployment, one of the major "selling points" of vendors and academ...	Model-driven DSS	Aug 30, 2014
What method is best for building an enterprise-wide, data-driven DSS? by Dan Power Editor, DSSResources.com Agile, SDLC, rapid prototyping, Spiral, RAD? Or some combination of methods? Information Technology manager...	Building DSS	Aug 31, 2009
What is a document database? by Dan Power Editor, DSSResources.com Increasingly unstructured or semi-structured documents are the drivers of new, novel decision support syst...	DSS Foundations	Nov 26, 2011
What is the best approach for organizing data? by Daniel J. Power Editor, DSSResources.COM In an information technology context, organizing means to arrange data in a coherent form and to syst...	DSS Foundations	Jul 25, 2013
What are design elements in a DSS user interface? by Dan Power Editor, DSSResources.com A design element is a discreet, identifiable component that appears in the user interface of computerized...	Building DSS	Feb 13, 2019
What is a computer supported special decision study? by Dan Power Editor, DSSResources.com Frequently, computerized tools are used to prepare one-time special studies and reports in unstructured, ...	DSS Foundations	Dec 23, 2015
What kind of DSS does Mr. X need? by Daniel J. Power Editor, DSSResources.com There are many "kinds" of decision support for diverse decision making situations. Both IS/DSS softw...	Building DSS	Aug 03, 2014
What are key database concepts for managers? by Dan Power Editor, DSSResources.com Managers need a basic understanding of computerized databases. Why? Because database systems provide the ke...	DSS Foundations	Jan 01, 2011
What role does a data steward have in providing decision support? by Daniel J. Power Editor, DSSResources.COM All varieties of data-driven decision support, whether an integrated application, a business intellig...	DSS Foundations	Apr 27, 2013
What Data Warehouse software and configurations are used in universities? The best source for finding information on this topic is on the Higher Education Data Warehouse Configurations page at http://www.georgetown.edu/users...	Data-driven DSS	Aug 06, 2005
How can organizations keep data-driven DSS and data warehouses current with changes in source systems? by Daniel J. Power Editor, DSSResources.COM In my Ask Dan column of October 22, 2006 (Vol. 7, No. 22), I answered some of the challenging questi...	Data-driven DSS	Mar 02, 2007
Why do organizations need databases? by Dan Power Editor, DSSResources.com A data base or database is an organized collection of data. Data is stored and it continues and persists. ...	DSS Foundations	Jun 12, 2016
What is the relationship between DSS and BAM? by Dan Power Editor, DSSResources.com Business Activity Monitoring (BAM) is the "real-time" evolution or descendant of the Executive Information...	Building DSS	Jul 09, 2016
What is ETL software and how is it related to DSS? Data warehousing practitioners have all experienced the frustration of creating a large data store from existing operating data bases built using a va...	Data-driven DSS	Aug 06, 2005
What do I need to know about Data Warehousing/OLAP? by Daniel J. Power Editor, DSSResources.COM A data warehouse is a central, integrated repository for historical, enterprise data from multiple bus...	Data-driven DSS	Oct 12, 2014
What is a data modeler? by Daniel J. Power Editor, DSSResources.COM In the era of rapidly expanding, diverse data, someone needs to identify patterns and regularities in...	DSS Foundations	Sep 21, 2015
What is machine data? by Dan Power Editor, DSSResources.com Machine data can be used to provide decision support for relevant decision tasks in organizations. Machine ...	Data-driven DSS	Feb 27, 2013
What are the features of a model-driven DSS? by Dan Power Editor, DSSResources.com This is the final column about features of computerized decision support systems. The focus is on mod...	Model-driven DSS	Aug 09, 2008
What is the output of a decision support system? by Dan Power Editor, DSSResources.com Traditionally, one would answer the output of a DSS is "relevant information". Correct, but DSS designers ...	Building DSS	Feb 06, 2008
How does MDM impact data-driven DSS? by Dan Power Editor, DSSResources.com Master data management (MDM) is a complex process made up of a number of interrelated tasks. In general, MD...	DSS Foundations	Aug 05, 2010
What do managers need to know about IS/IT, MIS and DSS? In the academic field of Information Systems we have repeatedly asked the question “What do managers need to know about IS/IT, MIS and DSS?” All o...	DSS Theory	Aug 06, 2005
What Wikipedia resources are useful for a database management course? by Daniel J. Power Editor, DSSResources.COM Managing data is a fundamental need in organizations. More complex data, parallel processing and inex...	DSS Foundations	Aug 13, 2013
What are common data mining tools? by Dan Power Editor, DSSResources.com As it became possible and affordable to store large amounts of data, managers wanted to access and analyze ...	DSS Foundations	Dec 06, 2009
What are ethical issues associated with building and using DSS? by Daniel J. Power Editor, DSSResources.com Decision support builders and users face ethical challenges and issues. Some people think that bui...	Evaluating DSS Projects	May 10, 2019
What is a "performance" dashboard? A few days ago, I received a very nice promotional brochure from iViz Group (ivizgroup.com) about their "innovative Dashboard and Scorecard software...	Data-driven DSS	Feb 05, 2006
How does data mining provide knowledge? by Daniel J. Power Editor, DSSResources.com In the 1970s, companies employed business analysts who used statistical packages like SAS and SPSS to...	DSS Foundations	Jan 17, 2021
What software tools should be used to build Web-based DSS? by Dan Power Editor, DSSResources.com Many Information Systems people, including students and managers, want to do more that try a Web-based DSS...	Building DSS	Mar 18, 2009
What is a Management Information System? by Daniel J. Power Editor, DSSResources.COM Broadly defined, a Management Information System (MIS) refers to any computer-based system or applica...	DSS Foundations	Aug 05, 2017
What theories are especially relevant to decision support? by Daniel J. Power Editor, DSSResources.COM Decision support is an applied field of study like accounting, engineering, and medicine. Design scie...	DSS Foundations	Dec 16, 2018
How should Decision Support Systems present apparently "Bad News"? On Saturday, January 22, 2005, a special issue of DSS News was sent to all 1066 subscribers. The purpose of the special mailing was to showcase some...	Building DSS	Aug 16, 2005
What is the design concept for PlanningDSS.com? In the Ask Dan! in DSS News of May 22, 2005, I introduced PlanningDSS.com and indicated that in a future column I might explain the overall concept an...	Planning DSS	Aug 07, 2005

DSS Home \| About Us \| Contact Us \| Site Index \| Subscribe \| What's New
	Copyright © 1995-2021 by D. J. Power (see his home page). DSSResources.COM^sm was maintained by Daniel J. Power of PowerEnterprises.net. See disclaimer and privacy statement.