Exam (elaborations)
MIS 2201:EXAM PREP WITH COMPLETE SOLUTION
- Course
- Institution
MIS 2201:EXAM PREP WITH COMPLETE SOLUTION
[Show more]
Seller
Follow
Content preview
MIS 2201:EXAM PREP WITH COMPLETESOLUTION
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
The benefits of buying summaries with Stuvia:
Guaranteed quality through customer reviews
Stuvia customers have reviewed more than 700,000 summaries. This how you know that you are buying the best documents.
Quick and easy check-out
You can quickly pay through credit card or Stuvia-credit for the summaries. There is no membership needed.
Focus on what matters
Your fellow students write the study notes themselves, which is why the documents are always reliable and up-to-date. This ensures you quickly get to the core!
Frequently asked questions
What do I get when I buy this document?
You get a PDF, available immediately after your purchase. The purchased document is accessible anytime, anywhere and indefinitely through your profile.
Satisfaction guarantee: how does it work?
Our satisfaction guarantee ensures that you always find a study document that suits you well. You fill out a form, and our customer service team takes care of the rest.
Who am I buying these notes from?
Stuvia is a marketplace, so you are not buying this document from us, but from seller hurryben. Stuvia facilitates payment to the seller.
Will I be stuck with a subscription?
No, you only buy these notes for $10.49. You're not tied to anything after your purchase.
Can Stuvia be trusted?
4.6 stars on Google & Trustpilot (+1000 reviews)
79373 documents were sold in the last 30 days
Founded in 2010, the go-to place to buy study notes for 14 years now