Ask Dan! about DSS

Frequently Asked Questions about Decision Support Systems by Dan Power

Search

50 results for "data warehousing"

Question	Category	Date
What is data warehousing? by Dan Power Editor, DSSResources.com For at least a hundred years, warehousing has referred to the short or long term storage of items in a spec...	DSS Foundations	Feb 18, 2010
What are the basics of data warehousing? by Daniel J. Power Editor, DSSResources.COM For at least one hundred years, warehousing has referred to the short- or long-term storage of items ...	DSS Foundations	Apr 24, 2014
How has data warehouse usage evolved? by Daniel J. Power Editor, DSSResources.COM It seems managers have accepted the idea of creating a separate data warehouse. Analytical and decisi...	DSS Foundations	Apr 30, 2014
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 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
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 staffing is needed for DW/BI/DSS? by Dan Power Editor, DSSResources.com Some Ask Dan! questions are more difficult for me to answer than others. On July 6, 2006, Aileen MacKay se...	Building DSS	Oct 22, 2006
Is parallel database technology needed for data-driven DSS? by Dan Power Editor, DSSResources.COM Few managers have heard of parallel computer processing and parallel databases. Nonetheless the desire of ...	Data-driven DSS	Mar 02, 2007
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 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 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
Who originated the term Business Intelligence (BI)? by Dan Power Editor, DSSResources.com Decision support and data warehousing sources agree that Howard Dresner coined and popularized the term Bu...	DSS Foundations	Jun 29, 2016
Are Executive Information Systems (EIS) needed? by Dan Power Editor, DSSResources.com At least 30 years ago, Chief Executive Officers (CEOs) began going online for information (cf., Rockhart, ...	Data-driven DSS	Sep 17, 2008
What technologies are used for managing big data? by Daniel J. Power Editor, DSSResources.COM Data-driven DSS and predictive analytics frequently need to access and process very large data sets ...	DSS Foundations	Nov 10, 2016
What is a data warehouse appliance? by Dan Power Editor, DSSResources.com In general, a data warehouse (DW) appliance is an integrated hardware and software bundled application. A...	Data-driven DSS	Feb 19, 2012
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 are the similarities and differences between Data-Driven and Document-Driven DSS? Document-Driven DSS is a relatively new category of Decision Support. There are certainly similarities to the more familiar Data-Driven DSS, but there...	Document-driven DSS	Aug 06, 2005
What was the DSS News in October 2000? by Daniel Power Volume 1, issue number 12 of DSS News was published October 9, 2000. Then as now DSS News was a bi-weekly publication of DSSResourc...	DSS Foundations	Oct 11, 2020
Is ETL software needed to build a model-driven DSS? by Daniel J. Power Editor, DSSResources.COM ETL refers to software used in the process of extracting data from a data source, transforming or alt...	Model-driven DSS	Apr 15, 2017
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
Who should participate in building decision support capabilities? by Daniel J. Power Editor, DSSResources.COM Building decision support capabilities requires varied expertise. More complex data, parallel process...	DSS Foundations	May 11, 2013
What is the job of a datawarehouse administrator? by Daniel J. Power Editor, DSSResources.COM The Data Warehouse Administrator supports the ongoing development and maintenance of data warehousing ...	DSS Foundations	Oct 25, 2018
How many DSS related pages are on the Web? One means of finding Web sites relevant to DSS is to use a search engine. Another way is to use a Web index. AltaVista (URL http://www.altavista...	DSSResources.com	Aug 25, 2005
How is BPM related to DSS? by Dan Power Editor, DSSResources.com Those of us in the field of IS/IT really seem to like our acronyms. Sometimes however different sets of ve...	DSS Foundations	Mar 21, 2009
What is the history of computerized decision support? by Dan Power Editor, DSSResources.com Supposedly, if we study history we are less likely to make the same mistakes again. Decision support was on...	DSS Foundations	Jun 10, 2009
Can decision support provide a competitive advantage? by Dan Power Editor, DSSResources.COM Some software vendors claim their decision support, analytics or business intelligence applications will ...	DSS Theory	Oct 02, 2012
Why study computerized decision support? by Dan Power Editor, DSSResources.com Using information technologies to improve decision making is interesting and important. Sadly, we seem to ...	DSS Foundations	Feb 05, 2012
Is it advantageous to outsource development and operation of Decision Support Systems? Sometimes! Currently, outsourcing and especially global outsourcing of information technology services is one of the most controversial business, econ...	Evaluating DSS Projects	Aug 07, 2005
What is the technology adoption curve? Is it relevant to DSS? by Daniel J. Power Editor, DSSResources.COM The technology adoption curve (TAC) is a theory about how individuals and organizations behave in impl...	DSS Theory	Dec 31, 2019
What is an enterprise-class translytical database? by Daniel J. Power and Ciara Heavin Translytical is a portmanteau word, in that parts of the words transaction and analytical are combined to form...	DSS Foundations	Oct 02, 2017
What is next generation BI? by Dan Power Editor, DSSResources.com Most of us recognize that we need better software and systems to get better business intelligence. We also...	DSS Foundations	Jan 14, 2011
What is DSS 2.0? by Daniel J. Power Editor, DSSResources.COM Discontinuities and major technology change can result in improving and significantly altering the sc...	DSS Foundations	Jul 19, 2014
How has and will Moore's Law impact computerized decision support? by Daniel J. Power Editor, DSSResources.COM Predictive “natural” laws provide some comfort in a complex, volatile and uncertain world. The "l...	DSS Theory	Jun 08, 2014
What is a data warehouse? by Dan Power Editor, DSSResources.com A data warehouse is a database designed to support decision making in organizations. It stores historical o...	DSS Foundations	Nov 28, 2010
How does a document management system differ from a Document-Driven DSS? Vannevar Bush's 1945 vision of a memex that stores everything one has seen and read for fast retrieval is the goal for document management systems. Su...	Document-driven DSS	Aug 06, 2005
What are the "hot" DSS research topics? Academic research in the U.S. often seems as susceptible to trends and "hot" topics as other segments of our culture. For the past 10 years ...	Evaluating DSS Projects	Aug 07, 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 is an appropriate DSS deployment strategy? by Dan Power Editor, DSSResources.com Decision support system (DSS) development often follows a sequence of awareness, plan, analysis, design, b...	Building DSS	Oct 14, 2008
What is the actual usage of DSS? This Ask Dan! column tackles a difficult question, but one that many of us have asked in one way or another over the years. I'm focusing on usage of D...	Building DSS	Aug 06, 2005
What is Hadoop? by Dan Power Editor, DSSResources.com Data-driven DSS may need to access and process very large data sets to support decision-making. One way to...	DSS Foundations	May 26, 2013
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 criteria should be used to evaluate BI/DW vendor solutions? by Dan Power Editor, DSSResources.com Selecting an enterprise business intelligence (BI)/data warehouse (DW) vendor solution is an important deci...	DSS Foundations	Dec 26, 2013
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
What are some use cases with expanded data sources? by Daniel J. Power Editor, DSSResources.COM Data volume is expanding rapidly, data variety is increasing and is coming from new sources, and data...	DSS Foundations	Dec 21, 2014
What is a Planning Support System? by Dan Power Editor, DSSResources.com Reading the trade press, academic articles and web sites forces those of us interested in computerized supp...	DSS Foundations	Aug 06, 2005
What is real-time decision support? The question of "real-time" decision support has been addressed in articles and books for almost 30 years, but as computing, sensor, and net...	Building DSS	Aug 06, 2005
What is evidence? by Daniel J. Power Editor, DSSResources.COM Evidence is an abstract idea that plays a significant role in human thinking and decision making. The...	DSS Foundations	Apr 16, 2018
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
When is "real-time" decision support desirable and needed? My Ask Dan! column “What is ‘real-time’ decision support in DSS News (Vol. 3, No. 24) struck a chord with some readers. This column is a follow-...	Building DSS	Aug 06, 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.