Ask Dan! about DSS

Frequently Asked Questions about Decision Support Systems by Dan Power

Search

50 results for "data warehouse"

Question	Category	Date
What are the advantages of building and using a data warehouse? by Daniel J. Power Editor, DSSResources.com Major advantages include: 1. Developing a data warehouse (DW) forces an organization to better un...	DSS Foundations	Oct 15, 2016
What are advantages and disadvantages of data warehouses? by Dan Power Editor, DSSResources.com The concept of a data warehouse for decision support traces back to about 1990 and the works of Bill Inmon...	Data-driven DSS	Dec 03, 2008
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 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 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 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
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
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 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
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
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 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
Who manages decision support capabilities in an organization? by Daniel J. Power Editor, DSSResources.COM The Director of Decision Support or the Chief Information Officer (CIO) or the IT manager or the Data ...	DSS Foundations	Jul 16, 2018
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
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 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 factors impact decision support project implementation risk? by Dan Power Editor, DSSResources.com Managers should contemplate a wide range of decision support projects. Perhaps an enterprise-wide, data wa...	Evaluating DSS Projects	Aug 15, 2008
What software can help implement the Basel accords? by Dan Power Editor, DSSResources.com Identifying and evaluating software for a very broad purpose like supporting the Basel capital accords (htt...	DSS Foundations	Sep 03, 2011
What are examples of database project failures? by Daniel J. Power Editor, DSSResources.COM Database centered projects for decision support and transaction processing do fail. How often? Acco...	DSS Foundations	Aug 18, 2013
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
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 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
How can we provide Web access to a Data Warehouse and DSS database? Some database software directly supports Web access, with other database management systems (DBMSs) you will need to use an intermediary application p...	Data-driven DSS	Aug 06, 2005
What is self-service business intelligence? by Daniel J. Power Editor, DSSResources.COM Managers and staff need access to data and decision support tools. Also, they need direct access to d...	DSS Foundations	Jun 15, 2018
What is a database? by Dan Power Editor, DSSResources.com Database is a fundamental concept for information technology professionals. While some lay people have an ...	DSS Foundations	Jul 09, 2017
Is decision support outsourcing a mistake? by Daniel J. Power Editor, DSSResources.COM Outsourcing of any organization capability, function or task should be driven by strategy not simply ...	DSS Foundations	Apr 26, 2015
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
What is a data lake? by Daniel J. Power Editor, DSSResources.COM Data lake is a metaphor for a data storage structure. In the physical world, a lake is a basin filled...	DSS Foundations	Aug 10, 2018
What are sources of data for building a data-driven DSS? by Dan Power Editor, DSSResources.com Managers and IT staff who are thinking about opportunities for building innovative, data-driven decision su...	DSS Foundations	Jun 20, 2014
What is the potential size of the NSEERS database? The U.S. Immigration and Naturalization Services (INS) is creating a number of very large databases to support a variety of operations and processes. ...	DSS Applications	Aug 07, 2005
How does a Web-based DSS differ from a Web-enabled DSS? by Dan Power Editor, DSSResources.com In 1998, I noted that “when vendors propose a Web-based DSS they are referring to a computerized system...	DSS Foundations	Aug 06, 2005
What is analytics? by Dan Power Editor, DSSResources.COM Analytics refers to quantitative and statistical analysis of data. Analytic capabilities are important in...	DSS Foundations	Oct 07, 2020
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 are examples of decision support systems in global enterprises? Dan Power Editor, DSSResources.COM This Ask Dan! continues the discussion of decision support in global enterprises (see DSS News of January 29,...	DSS Applications	Oct 22, 2006
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 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 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 is your analysis of the history and current status of DSS? The introduction of the personal computer in the early 1980s led some people to conclude that technology had reached the level where we could do just ...	DSS Foundations	Aug 07, 2005
What increases success for data-based decision support? by Daniel J. Power Editor, DSSResources.com Data-based decision support development is a company-wide effort and requires many resources, includi...	DSS Foundations	Jul 09, 2017
What is the process for designing decision support software? by Dan Power Editor, DSSResources.COM Recently, I received an email from Michael Brito asking if I "could explain the process for designing deci...	Building DSS	Oct 22, 2006
What companies have gained a competitive advantage by building a DSS? by Daniel J. Power Editor, DSSResources.COM Software vendor salespeople and their sales materials often claim that a specific software product lik...	Building DSS	Jul 25, 2015
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
What vendors dominate the DSS product space? In terms of Ask Dan! email, questions about DSS software and DSS vendors ranks near the top. What DSS product is best? What is the largest DSS softwar...	Evaluating DSS Projects	Aug 07, 2005
Is it feasible to track all visitors to the United States and then build a Data-driven DSS? In response to the September 11, 2001 World Trade Center and Pentagon attack, the U.S. Congress required Attorney General John Ashcroft and the U.S. I...	DSS Applications	Aug 07, 2005
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 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 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
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
How do data storage strategies differ among uses? by Daniel J. Power Editor, DSSResources.COM Everything that happens is being digitized. Customers are data, processes are data, supply chains are...	DSS Foundations	Aug 13, 2018

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.