BUAL 2600 GRAMLING ACTUAL FINAL EXAM
QUESTIONS AND ANSWERS SURE A+
✔✔What is a Business Intelligence (BI) Dashboard? - ✔✔-A special type of Dashboard
in business
-displays on a single screen the status of business metrics, key performance indicators
and other important data points for an organization or team, or a business process
✔✔What to look for on a dashboard? - ✔✔-Provide dynamic, real-time, real-world view
of the data with timely data refreshes; enables user to stay up to date of recent changes
in the business
-Visuals (e.g. charts, performance bars, gauges, meters) to highlight at a glance the
data trends, tracking over time, or outstanding points
-Think about the panel in your vehicle (gas level, mileage, tire pressure)•
-Transparent to the user - require minimal training to use (no programming)
-Data from a variety of sources into a single, summarized, unified snapshot of the
business
-Enable user to "drill-down" to underlying data sources or reports to provide more
detailExamples
✔✔What does a dashboard look like? - ✔✔
✔✔How to create a Dashboard via Tableau - ✔✔
, ✔✔How do Professionals use dashboard? (From Video) - ✔✔
✔✔Excel Command for Mean - ✔✔=average(a1..a12)
✔✔Excel Command for Median - ✔✔=median(a1..a12)
✔✔Excel Command for Mode - ✔✔=mode(a1..a12)
or
=mode.sngl(a1..a12)
✔✔Excel Command for Population of Standard Deviation - ✔✔=stdev.p(a1..a12)
✔✔Excel Command for Sample Standard Deviation - ✔✔=stdev.s
or
=stdev
✔✔Excel Command for Sample Variance - ✔✔=var.s(a1..a12)
✔✔Excel Command for Population Variance - ✔✔=var.p(a1..a12)
-population calculated differently than variance for a sample
✔✔Median - ✔✔a value such that 50% of all measurements, after having been
arranged in numerical order, lie above (or below) it
✔✔If the number of measurements is odd - ✔✔the median is the middlemost
measurement in the ordering
✔✔If the number of measurements is even - ✔✔the median is the average of the two
middlemost measurements in the ordering
✔✔Q1 - ✔✔median of the lower half (below the median) of the distribution
-25th percentile
✔✔Q2 - ✔✔the median of the distribution
-50th percentile
✔✔Q3 - ✔✔median of the upper half (above the median) of the distribution
-75th percentile
✔✔Mode - ✔✔population or sample of measurements is the measurement that occurs
most frequently; values that are observed "most typically"
QUESTIONS AND ANSWERS SURE A+
✔✔What is a Business Intelligence (BI) Dashboard? - ✔✔-A special type of Dashboard
in business
-displays on a single screen the status of business metrics, key performance indicators
and other important data points for an organization or team, or a business process
✔✔What to look for on a dashboard? - ✔✔-Provide dynamic, real-time, real-world view
of the data with timely data refreshes; enables user to stay up to date of recent changes
in the business
-Visuals (e.g. charts, performance bars, gauges, meters) to highlight at a glance the
data trends, tracking over time, or outstanding points
-Think about the panel in your vehicle (gas level, mileage, tire pressure)•
-Transparent to the user - require minimal training to use (no programming)
-Data from a variety of sources into a single, summarized, unified snapshot of the
business
-Enable user to "drill-down" to underlying data sources or reports to provide more
detailExamples
✔✔What does a dashboard look like? - ✔✔
✔✔How to create a Dashboard via Tableau - ✔✔
, ✔✔How do Professionals use dashboard? (From Video) - ✔✔
✔✔Excel Command for Mean - ✔✔=average(a1..a12)
✔✔Excel Command for Median - ✔✔=median(a1..a12)
✔✔Excel Command for Mode - ✔✔=mode(a1..a12)
or
=mode.sngl(a1..a12)
✔✔Excel Command for Population of Standard Deviation - ✔✔=stdev.p(a1..a12)
✔✔Excel Command for Sample Standard Deviation - ✔✔=stdev.s
or
=stdev
✔✔Excel Command for Sample Variance - ✔✔=var.s(a1..a12)
✔✔Excel Command for Population Variance - ✔✔=var.p(a1..a12)
-population calculated differently than variance for a sample
✔✔Median - ✔✔a value such that 50% of all measurements, after having been
arranged in numerical order, lie above (or below) it
✔✔If the number of measurements is odd - ✔✔the median is the middlemost
measurement in the ordering
✔✔If the number of measurements is even - ✔✔the median is the average of the two
middlemost measurements in the ordering
✔✔Q1 - ✔✔median of the lower half (below the median) of the distribution
-25th percentile
✔✔Q2 - ✔✔the median of the distribution
-50th percentile
✔✔Q3 - ✔✔median of the upper half (above the median) of the distribution
-75th percentile
✔✔Mode - ✔✔population or sample of measurements is the measurement that occurs
most frequently; values that are observed "most typically"
