{"id":233,"date":"2018-05-26T18:23:33","date_gmt":"2018-05-26T18:23:33","guid":{"rendered":"https:\/\/panditaseaman.com\/infocypher\/?p=233"},"modified":"2023-06-09T18:36:54","modified_gmt":"2023-06-09T18:36:54","slug":"five-simple-steps-to-designing-great-reports","status":"publish","type":"post","link":"https:\/\/panditaseaman.com\/infocypher\/five-simple-steps-to-designing-great-reports\/","title":{"rendered":"Five Simple Steps to Designing Great Reports"},"content":{"rendered":"<p>Databases are built to store data that may be useful to somebody who owns or uses that data. Data becomes information when it is presented in a format that is useful to a viewer. There are many ways to convert data into information, and the most common is by creating a report.<\/p>\n<p>A\u00a0report organizes data into a format\u00a0that it is useful for a specific purpose. For example, sales data can be organized to discover trends in sales, rank salespeople, or find out which company promotions are generating the most income. As FileMaker consultants, database designers, and web developers, it is rare when we build a database that is not at some point used to create a report. This article describes a 5-step process for making report design simple and efficient.<\/p>\n<h2>1. Know what information you need.<\/h2>\n<p>The first step in creating a report is knowing what information you need ask yourself the following questions:<\/p>\n<ul>\n<li>What is the purpose of this report?<\/li>\n<li>What would i like to know?<\/li>\n<li>Who will need to see this report?<\/li>\n<li>How will the information on this report be used by each person or group that will see it?<\/li>\n<\/ul>\n<h2>2.\u00a0Determine the data that will be listed on the report.<\/h2>\n<p>Now it s time to design your report. Use the answers to the questions in step 1 to design the layout of your report. Ask yourself:<\/p>\n<ul>\n<li>What data needs to be listed on your report in order for it to achieve its purpose?<\/li>\n<li>Does the list of data need to be aggregated grouped and or sorted in a particular way?\u00a0If so, what groups, sorts, and aggregated calculations are needed?<\/li>\n<\/ul>\n<h2>3.\u00a0Sketch a sample report<\/h2>\n<p>Sometimes, there&#8217;s no substitute for a visual check. Validate what you&#8217;ve determined in steps 1 and 2 by sketching your report on a piece of paper, word processor, spreadsheet or your favorite graphic layout tool. You may find that you left something out in steps 1 and 2. If so, rinse and repeat until you have the sample report of your dreams.<\/p>\n<h2>4.\u00a0Ensure the appropriate data is being collected.<\/h2>\n<p>Collecting the appropriate data means making sure your database is modeled and designed properly. Questions to ask your database designer are:<\/p>\n<ul>\n<li>Is the database storing the data I need for the report\u00a0I want?<\/li>\n<li>Is my database structured properly in a way that I can use the stored data to create the report I\u00a0want? This step requires a knowledge of good database modeling and design and that topic is too big to even summarize here. If you don t know much about data modeling, you can read some good articles on the subject online or consult with a database software design expert to determine whether your database is structured properly for what you need.<\/li>\n<\/ul>\n<h2>5.\u00a0Create your report.<\/h2>\n<p>Use your sample report to create a layout with the technology you are using to present data from your database to the people who need your report. Some examples of such technology are:<\/p>\n<ul>\n<li>A web page built with php and mysql<\/li>\n<li>A\u00a0content management system like WordPress or Drupal<\/li>\n<li>A database software platform like FileMaker Pro<\/li>\n<li>A reporting tool like Tableau.<\/li>\n<\/ul>\n<p>Reports are an important and useful tool to help you understand your business and inform\u00a0your decision-making processes. Be sure that your reports stay simple, effective and purposeful using the guidelines above. If you\u00a0need more tools, hints or guidance when designing reports or databases don&#8217;t hesitate to\u00a0<a href=\"https:\/\/www.infocypher.com\/blog\/contact\">contact us<\/a>\u00a0for help.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>Databases are built to store data that may be useful to somebody who owns or uses that data. Data becomes information when it is presented in a format that is useful to a viewer. There are many ways to convert data into information, and the most common is by creating a report. A\u00a0report organizes data [&hellip;]<\/p>\n","protected":false},"author":2,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[5],"tags":[],"class_list":["post-233","post","type-post","status-publish","format-standard","hentry","category-filemaker"],"_links":{"self":[{"href":"https:\/\/panditaseaman.com\/infocypher\/wp-json\/wp\/v2\/posts\/233","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/panditaseaman.com\/infocypher\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/panditaseaman.com\/infocypher\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/panditaseaman.com\/infocypher\/wp-json\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"https:\/\/panditaseaman.com\/infocypher\/wp-json\/wp\/v2\/comments?post=233"}],"version-history":[{"count":1,"href":"https:\/\/panditaseaman.com\/infocypher\/wp-json\/wp\/v2\/posts\/233\/revisions"}],"predecessor-version":[{"id":234,"href":"https:\/\/panditaseaman.com\/infocypher\/wp-json\/wp\/v2\/posts\/233\/revisions\/234"}],"wp:attachment":[{"href":"https:\/\/panditaseaman.com\/infocypher\/wp-json\/wp\/v2\/media?parent=233"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/panditaseaman.com\/infocypher\/wp-json\/wp\/v2\/categories?post=233"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/panditaseaman.com\/infocypher\/wp-json\/wp\/v2\/tags?post=233"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}