MIS 2201:EXAM PREP WITH COMPLETE
SOLUTION
What is a data warehouse? - =a set of databases to support decision-making in an organization.
What is a data mart? - =database or databases focused on addressing the concerns of a specific
problem or business unit.
What are the query and reporting tools? - =Canned reports, ad hoc reporting tools, dashboards,
OLAP, data cube
What is canned reports? - =provide regular summaries of information in a predetermined format
What is ad hoc reporting tools? - =puts users in control so that they can create custom reports on
an as-needed basis by selecting fields, ranges, summary conditions, and other parameters.
What is dashboards? - =heads-up display of critical indicators that allows managers to get a
graphical glance at key performance metrics.
What is Online Analytical Processing (OLAP)? - =takes data from standard relational databases,
calculates and summarizes the data, and then stres the data in a special database called a data
cube.
What is a data cube? - =special database used to store data in OLAP reporting.
What are data fields in Tableau? - =made from the columns in your data source.
What is data type in Tableau? - =integer, string, date.
, What is dimension in Tableau? - =contain qualitative values (names, dates or geographical data)
use them to categorize, segment and reveal details in your data. Aggregated - minimum,
maximum, count, or count (distinct)
What is measure in Tableau? - =contain numeric, quantitative values. Aggregated - sum,
average, and median.
What is discrete in Tableau? - ="individually separate and distinct" mathematical terms.
What is continuous in Tableau? - ="forming an unbroken whole, without interruption"
mathematical terms.
What is big data? - =refers to the huge collections of data that are difficult to process, analyze,
and manage using conventional database tools.
What are the 5 V's of big data? - =high volume, high velocity, diversified variety. unknown
veracity, and low-density value.
What is high volume? - =the size and amounts of big data that companies manage and analyze.
What is high velocity? - =the speed at which companies receive, store and manage data - e.g., the
specific number of social media posts or search queries received within a day, hour or other unit
of time.
What is diversified variety? - =the diversity and range of different data types, including
unstructured data semi-structured data and raw data
What is unknown veracity? - =the "truth" or accuracy of data and information assets, which often
determines executive-level confidence
SOLUTION
What is a data warehouse? - =a set of databases to support decision-making in an organization.
What is a data mart? - =database or databases focused on addressing the concerns of a specific
problem or business unit.
What are the query and reporting tools? - =Canned reports, ad hoc reporting tools, dashboards,
OLAP, data cube
What is canned reports? - =provide regular summaries of information in a predetermined format
What is ad hoc reporting tools? - =puts users in control so that they can create custom reports on
an as-needed basis by selecting fields, ranges, summary conditions, and other parameters.
What is dashboards? - =heads-up display of critical indicators that allows managers to get a
graphical glance at key performance metrics.
What is Online Analytical Processing (OLAP)? - =takes data from standard relational databases,
calculates and summarizes the data, and then stres the data in a special database called a data
cube.
What is a data cube? - =special database used to store data in OLAP reporting.
What are data fields in Tableau? - =made from the columns in your data source.
What is data type in Tableau? - =integer, string, date.
, What is dimension in Tableau? - =contain qualitative values (names, dates or geographical data)
use them to categorize, segment and reveal details in your data. Aggregated - minimum,
maximum, count, or count (distinct)
What is measure in Tableau? - =contain numeric, quantitative values. Aggregated - sum,
average, and median.
What is discrete in Tableau? - ="individually separate and distinct" mathematical terms.
What is continuous in Tableau? - ="forming an unbroken whole, without interruption"
mathematical terms.
What is big data? - =refers to the huge collections of data that are difficult to process, analyze,
and manage using conventional database tools.
What are the 5 V's of big data? - =high volume, high velocity, diversified variety. unknown
veracity, and low-density value.
What is high volume? - =the size and amounts of big data that companies manage and analyze.
What is high velocity? - =the speed at which companies receive, store and manage data - e.g., the
specific number of social media posts or search queries received within a day, hour or other unit
of time.
What is diversified variety? - =the diversity and range of different data types, including
unstructured data semi-structured data and raw data
What is unknown veracity? - =the "truth" or accuracy of data and information assets, which often
determines executive-level confidence
