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.
Previous
Play
Next
Rewind 10 seconds
Move forward 10 seconds
Unmut...
What is a data warehouse? - ANSWER- a set of databases to support decision-
making in an organization.
What is a data mart? - ANSWER- database or databases focused on addressing
the concerns of a specific problem or business unit.
What are the query and reporting tools? - ANSWER- Canned reports, ad hoc
reporting tools, dashboards, OLAP, data cube
What is canned reports? - ANSWER- provide regular summaries of information in
a predetermined format
What is ad hoc reporting tools? - ANSWER- 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? - ANSWER- heads-up display of critical indicators that
allows managers to get a graphical glance at key performance metrics.
What is Online Analytical Processing (OLAP)? - ANSWER- 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? - ANSWER- special database used to store data in OLAP
reporting.
What are data fields in Tableau? - ANSWER- made from the columns in your data
source.
What is data type in Tableau? - ANSWER- integer, string, date.
, What is dimension in Tableau? - ANSWER- 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? - ANSWER- contain numeric, quantitative values.
Aggregated - sum, average, and median.
What is discrete in Tableau? - ANSWER- "individually separate and distinct"
mathematical terms.
What is continuous in Tableau? - ANSWER- "forming an unbroken whole, without
interruption" mathematical terms.
What is big data? - ANSWER- 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? - ANSWER- high volume, high velocity, diversified
variety. unknown veracity, and low-density value.
What is high volume? - ANSWER- the size and amounts of big data that
companies manage and analyze.
What is high velocity? - ANSWER- 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? - ANSWER- the diversity and range of different data
types, including unstructured data semi-structured data and raw data
What is unknown veracity? - ANSWER- the "truth" or accuracy of data and
information assets, which often determines executive-level confidence
What is low-denisty value? - ANSWER- large volumes of data containing
unimportant details. comes from insight discovery and pattern recognition that
lead to more effective operations, stronger customer relationships and other
clear and quantifiable business benefits
What is Hadoop? - ANSWER- Big database, made up of half-dozen separate
software pieces and requires the integration of these pieces to work. - popular.
Advantages: flexibility, scalability, cost effectiveness, fault tolerance.
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 tuition. 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.
