11 Types of Reports Flashcards

1
Q

What are the main categories of reports covered in the exam?

A

Static and dynamic reports, ad hoc and research reports, self-service reports, recurring reports

These categories encompass the types of reports a data analyst may encounter in their career.

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
2
Q

What is the difference between static and dynamic reports?

A

Static reports are fixed and do not update automatically, while dynamic reports have a live connection to data and update in real-time

Static reports are sometimes called point-in-time reports, and dynamic reports are sometimes referred to as real-time reports.

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
3
Q

What are the characteristics of point-in-time reports?

A

They provide a snapshot of data at a specific moment and do not update automatically

Point-in-time reports can be compared over time to analyze changes.

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
4
Q

What are the pros of static reporting?

A
  • Can use more in-depth and complicated analyses
  • Can answer more complex questions
  • Can pre-empt follow-up questions
  • Can be generated faster

Static reports are beneficial for detailed analyses and answering complex inquiries.

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
5
Q

What are the cons of static reporting?

A
  • Data is a fixed point and not up to date
  • Often needs to be generated multiple times

Static reports can become outdated quickly if the data changes frequently.

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
6
Q

What are the pros of dynamic reporting?

A
  • Data is always as up to date as possible
  • Often saves time in the long run

Dynamic reporting is useful for scenarios where real-time data is critical.

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
7
Q

What are the cons of dynamic reporting?

A
  • Limited to relatively simple analyses
  • Limited to answering relatively simple questions
  • Can take a long time to set up

Dynamic reports may not provide the depth needed for complex decision-making.

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
8
Q

When is dynamic reporting preferred over static reporting?

A

When having the most recent data is more important than detailed analyses

This is particularly true in fast-paced environments like stock trading.

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
9
Q

What is an ad hoc report?

A

A short, quick report that answers a simple question

Ad hoc reports are typically static and have a short turnaround time.

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
10
Q

What distinguishes research reports from ad hoc reports?

A

Research reports are large, in-depth, and answer complex business questions, while ad hoc reports are short and answer simple questions

Research reports often require extensive data analysis.

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
11
Q

What are self-service reports?

A

Reports that allow non-data specialists to access and analyze data independently

Dashboards are a common form of self-service reports.

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
12
Q

What is the main advantage of self-service reports?

A

They enable users to answer their own questions without needing to consult a data analyst

This is especially useful in roles where quick access to data is critical.

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
13
Q

What are recurring reports?

A

Reports that are generated at regular intervals

These reports can vary in complexity and are often static.

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
14
Q

What are the three common categories of recurring reports?

A
  • Compliance reports
  • Risk and regulatory reports
  • Operational reports (KPI reports)

These reports are essential for ongoing monitoring and decision-making.

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
15
Q

What are the three common categories of recurring reports?

A
  • Compliance reports
  • Risk and regulatory reports
  • Operational reports (KPI reports)

These reports are all considered recurring reports.

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
16
Q

What is the primary purpose of compliance reports?

A

To ensure compliance with a set of regulations.

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
17
Q

What levels can regulations come from?

A
  • Internal
  • Third-party
  • Industrial
  • Governmental
18
Q

What are internal regulations?

A

Requirements set up by the company itself.

19
Q

What are third-party regulations?

A

Optional requirements imposed by another company for certification.

20
Q

What are industrial regulations?

A

General rules and requirements specific to an industry.

21
Q

What are governmental regulations?

A

The strictest set of rules that must be followed.

22
Q

What is the focus of risk and regulatory reports?

A

Identifying risks of regulations changing and their potential impact.

23
Q

How often are operational reports typically generated?

A

Quarterly.

24
Q

What do operational reports primarily focus on?

A

Key Performance Indicators (KPIs).

25
List some data analytics tools you need to know for the exam.
* SQL * Python * Microsoft Excel * R * RapidMiner * IBM Cognos * IBM SPSS Modeler * IBM SPSS * SAS * Tableau * Power BI * Qlik * MicroStrategy * BusinessObjects * Apex * Dataroma * Domo * AWS QuickSight * Stata * Minitab
26
Which tool is the only query language on the list?
SQL.
27
What is the main purpose of spreadsheet tools?
To work with basic flat files.
28
What is the most common spreadsheet software mentioned?
Microsoft Excel.
29
Name some programming language tools used for statistical analyses.
* Python * R * SAS * Stata
30
What are visualization tools primarily used for?
To create visualizations quickly and easily.
31
List some visualization tools.
* Tableau * Power BI * Qlik * AWS QuickSight
32
What are business services in the context of data analytics tools?
Companies that offer data services.
33
Name some all-purpose tools for data analytics.
* RapidMiner * IBM Cognos * IBM SPSS Modeler * IBM SPSS * MicroStrategy * BusinessObjects * Domo * Minitab
34
What should you consider when choosing tools to learn for data analysis?
The tools used in the specific field you want to enter.
35
Fill in the blank: The correct answer is to learn one ______, one programming language, one spreadsheet software, and one visualization software.
query language.
36
True or False: All-purpose tools are typically inexpensive and easy to learn.
False.
37
What is the main purpose of recurring reports?
To regularly check and report on specific metrics.
38
What type of report is most appropriate for tracking team metrics against regulations?
Recurring report.
39
What type of report is suitable for analyzing significant financial risks?
Research report.
40
Which tool is not a data analytics tool: A. SAS B. SPSS C. STS D. Stata?
C. STS.
41
Which data analytics tool is specifically designed for visualizations and reports?
Power BI.