?
Solved

General Question>> Questions for folks who create Reports:

Posted on 2014-02-17
4
Medium Priority
?
170 Views
Last Modified: 2014-02-27
Hello To All Respected Gurus,
I have weird but very general question, nothing technical but more philosophical maybe :(

This question could be related to creating reports in excel, access or sql server.

The goal that i want to clarify-

•      Why we create report?
•      If someone asks for a report to be created–
o      What are some mental questions we need ask ourselves before we start creating it?
o      What is that report?
o      What is its structure and break down and why it’s needed? Etc

•      What kind of UI considerations may we think to make the report look even better
•      Report Completion and execution > Is over delivery good or under delivery bad
•      When creating a report - what is good mental flow chart that we might need to kind of get a way to create it the best way?

•      When report is already being used by the customers –
o       What we can do to make sure they get the best out of it?
o      How do we manage our priorities to make sure customers are happy and that we are settings correct expectations and standards of SLA
•      What we need to do create reports efficiently and within our time sensitive framework?


Can you guys add to the list or expand my question and points? I am just tying  bring a meaning to - why we do reporting and how best it could be done....to  maintain and sustain it

Please  - all are welcome....all feedbacks are acknowledged
0
Comment
Question by:Rayne
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 3
4 Comments
 

Author Comment

by:Rayne
ID: 39864363
you can give a generic explanation or be specific to any scenario. I would greatly like to hear your mental view points and what do you think.
0
 
LVL 33

Accepted Solution

by:
Paul Sauvé earned 2000 total points
ID: 39865487
PARTIAL ANSWER
To answer simply, reports present data with regard to specific criteria. For example:
What are the daily/monthly/yearly sales for a group of products
What are the daily/monthly/yearly sales for a group of vendors

Why would you want to know this?
To see if sales for a certain period have met sales projections
To calculate the commission to be paid to the sales staff
To make manufacturing projections for the following year, based on previous sales

If a report is already being used by the customers:
Does the report have all the required information?
Is all the required information exist in the database?
0
 

Author Comment

by:Rayne
ID: 39865778
Thank you :)
0
 

Author Closing Comment

by:Rayne
ID: 39891214
thanks Paul :)
0

Featured Post

The Eight Noble Truths of Backup and Recovery

How can IT departments tackle the challenges of a Big Data world? This white paper provides a roadmap to success and helps companies ensure that all their data is safe and secure, no matter if it resides on-premise with physical or virtual machines or in the cloud.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Having trouble getting your hands on Dynamics 365 Field Service or Project Service trial? Worry No More!!!
This article describes how you can use Custom Document Properties to store settings and other information in your workbook so that they will be available the next time you open the workbook.
The viewer will learn how to simulate a series of coin tosses with the rand() function and learn how to make these “tosses” depend on a predetermined probability. Flipping Coins in Excel: Enter =RAND() into cell A2: Recalculate the random variable…
The viewer will learn how to create a normally distributed random variable in Excel, use a normal distribution to simulate the return on an investment over a period of years, Create a Monte Carlo simulation using a normal random variable, and calcul…

752 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question