User Account

All Pages

Data sets and associated dictionaries

Assignment Help Basic Computer Science
Reference no: EM133246011

This task defines a report as a collection of data that answers a real-world business question. The report contains two distinct sections that differ in the granularity of the data they present and how directly they support the answering of the business question of interest. The Detailed section will contain all data that informs the answers to the question, and the Summary section will include contains relevant aggregated data that provide the answer to the business question. For example, if the business question of interest in the context of a computer factory is focused on the number of the computers manufactured in the past six months, the detailed portion of a report could contain details on each individual computer made, while the summary portion contains only the total number of computers made in each factory.

A. Summarize one real-world business report that can be created from the attached Data Sets and Associated Dictionaries.

1. Describe the data used for the report.

2. Identify two or more specific tables from the given dataset that will provide the data necessary for the detailed and the summary sections of the report.

3. Identify the specific fields that will be included in the detailed and the summary sections of the report.

4. Identify one field in the detailed section that will require a custom transformation and explain why it should be transformed. For example, you might translate a field with a value of 'N' to 'No' and 'Y' to 'Yes'.

5. Explain the different business uses of the detailed and the summary sections of the report.

6. Explain how frequently your report should be refreshed to remain relevant to stakeholders.

Reference no: EM133246011

Questions Cloud

Discuss the transmission mechanisms : Discuss the five transmission mechanisms of the key market (country) and how it affects the company's profitability.
Increase in price of liquid detergent : If consumers switch to buying more powdered detergent in response to an increase in the price of liquid detergent does this mean
Display the trackid and track name : Display the trackid, the track name, the composer, the genreid, and the genre name for each track.
Create block containing variable : Challenge 2-2 create a block containing a variable that can hold a y or an n to indicate whether a newsletter should be mailed
Data sets and associated dictionaries : Summarize one real-world business report that can be created from the attached Data Sets and Associated Dictionaries. Describe the data used for the report.
Good for hosting microbrewery tours : Find which cities would be good for hosting microbrewery tours. A city must have at least 10 breweries to be considered.
Describe briefly database application : Describe briefly a database application case of your choice and represent your data in terms of 3 linked (via foreign key/s) tables.
Find the names of actors who have worked in titanic movie : Find the names of actors who have worked in Titanic movie. Find the name of top 10 actors which have been casted maximum no. of times.
Each employee who works for bigbank. : Find the ID and name of each employee who does not work for "Big Bank" Find the ID and name of each employee who works for "BigBank".

Reviews

Write a Review

Basic Computer Science Questions & Answers

  Can you think of reasons for this contrast

In contrast, such changes became frequent in the interwar period. Can you think of reasons for this contrast

  Double the number of workers and ingredients

If you double the number of workers and ingredients, but don t add a second vat, would you expect your output (gallons per hour) to double? Explain.

  What harm can be done by the unlawful intrusion

Describe a case that has been in the news recently and describe what harm can be done by the unlawful intrusion into the computer of another.

  Difference between and implicit and explicit cost

What is the difference between and implicit and explicit cost?

  Provides server authentication-data confidentiality

Transport Layer Protocol, provides server authentication, data confidentiality, and data integrity with forward secrecy (i.e., if a key is compromised during one session, the knowledge does not affect the security of earlier sessions).

  Clearly and formatted with appropriate indentation

The codes must be commented clearly and formatted with appropriate indentation. Submit the souirce codes, a sample output and the class diagram.

  Secure the network and protect access to the web

Describe the significant reasons to secure the Network and protect access to the Web - What are some of these advantages, and from an Information Security perspective, what are some of the common practices in securing these networks?

  Discuss the rationale for this robust behavior

Discuss the rationale for this robust behavior.

  Function that counts occurrences of a word in a string

Write the function so that it works with either a String argument or a StringBuilder object.

  What is a data warehouse

Describe the characteristics of a data warehouse. Divide them into functionality of a warehouse and advantages users derive from it.

  Question regarding the constrain decisions

How do you think these trends might constrain decisions made by managers at the movie theater chains?

  What is the irr of the project

Let's suppose a project costs $500 and produces cash flows of $100 over each of the following six years. What is the IRR of the project?

Free Assignment Quote

Assured A++ Grade

Get guaranteed satisfaction & time on delivery in every assignment order you paid with us! We ensure premium quality solution document along with free turntin report!

Submit Assignment

Academics

Major Subjects

Majors

Get In Touch

whatsapp: +1-415-670-9521

Phone: +1-415-670-9521

Email: [email protected]

TERMS & POLICIES

HELP & SUPPORT

All rights reserved! Copyrights ©2019-2020 ExpertsMind IT Educational Pvt Ltd