Data Visualization and Dashboards with Excel and Cognos

Data Visualization and Dashboards with Excel and Cognos | Coursera

Enroll Course

---

Graded Quiz : Visualizing Data using Spreadsheets

1. What is a capability of line charts?

• Compare different, but related data sets
• Compare the frequency of data sets
• Compare similar, unrelated data sets
• Compare different, unrelated data sets

2. Each portion of a pie chart represents static values or categories. What is the sum of the categories equal to?

• 100%
• 99%
• 75%
• 50%

3. According to the ‘Introduction to Charts’ video, which chart is one of the most commonly used?

• Bubble chart
• Funnel chart
• Bar chart
• Scatter chart

4. In the ‘Expert Viewpoints: Using Visualizations to Tell a Data Story’ video, one expert mentioned two software programs that help highlight the important information. Which were the two software programs?

• Db2 and SQL
• PowerPoint and Excel
• Google Docs and Word
• Google and Bing

5. In the ‘Creating Basic Charts in Excel’ video, which type of chart shows the relative contribution of unit sales from Ford car models?

• Line chart
• Pie chart
• Funnel chart
• Bar chart

6. How does a pivot chart differ from a standard chart in Excel?

• A pivot chart contains data series, categories, and chart axes
• A pivot chart cannot be a line, pie or bar chart
• A pivot chart uses data from a pivot table
• A pivot chart always has its data arranged in columns and rows

7. What is the main difference between Area and Column charts?

• An area chart uses horizontal bars, and a column chart uses rows
• A column chart uses vertical bars, and an area chart uses data points
• An area chart makes sense of complicated data and a column chart shows chart axis like basic charts
• A column chart uses data points, and an area chart uses vertical bars

Graded Quiz: Updating Advanced Charts

1. What do treemaps use to represent hierarchical data categories?

• Treemaps use data points on a line.
• Treemaps use color, size, and closeness of shapes.
• Treemaps use different shapes.
• Treemaps use interconnected circles.

2. Histograms can look like a bar chart, what’s the key difference?

• Histograms use Axis Options to display different bin sizes.
• Bar charts use horizontal bars.
• Bar charts compare data and histograms display the distribution of data.
• Histograms use bins.

3. What kind of data works best with filled map charts?

• Complicated data
• Data containing geographical regions
• Scientific data
• Raw data

4. What are sparklines typically used for?

• To contrast numerical values.
• To show data trends.
• To highlight a data range.
• To show regional information.

Graded Quiz: Creating Dashboards using Spreadsheets

1. Which one of the following statements best describes the main purpose of a digital dashboard?

• To display all your charts in one location.
• To provide a static data-findings report of your business data.
• To display the most important or relevant information in a single place.
• To analyze different types of data.

2. According to the ‘Creating a Simple Dashboard using Excel’ video, what did subject matter experts advise when building dashboards?

• Use numbers as much as possible to help focus users on your key points.
• Bright colors highlight key points.
• Displaying too much information means your key points can get lost.
• Having as many visualizations as possible can help you clearly define your key points.

3. Which feature in Excel enables you to precisely control what information is displayed in a visualization such as a chart?

• Sorting
• Filters
• Pivot Tables
• Sparklines

4. Which of the following tasks should you perform before creating a dashboard? (Select all that apply)

• Format the data as a table first
• Remove blank data rows
• Format the data as a CSV file first
• Create visualizations

Graded Quiz: Creating Visualizations and Dashboards with Cognos Analytics

1. How can you filter on a particular data field in Cognos Analytics?

• Type in the name of the field in the 'Filters' area at the top of the page.
• Drag the 'Filter' field at the top of the page on to the relevant data field area.
• Drag the data field to the 'This tab' area at the top of the page.
• Drag the data field to the 'All tabs' area at the top of the page.

2. In Cognos Analytics what is the first thing you must do when creating  a new dashboard?

• Upload a spreadsheet or workbook
• Select visualizations
• Provide questions and answers to the assistant
• Choose a template layout for your dashboard

3. Which of the following methods can be used in Cognos Analytics to create visualizations? (Select all that apply)

• By manually populating by dragging and dropping.
• By using widgets.
• By automatic recommended visualizations.
• By using the Assistant to suggest questions and suggested visualizations.

4. How can you create infographics in Cognos Analytics?

• Modify navigation paths.
• Ask the Assistant different questions.
• Use Exclude to filter out some data.
• Drag and drop a widget shape icon onto a visualization.

Related Articles