{"id":3349,"date":"2024-07-17T14:03:11","date_gmt":"2024-07-17T06:03:11","guid":{"rendered":"https:\/\/five.co\/?p=3349"},"modified":"2024-07-23T09:05:31","modified_gmt":"2024-07-23T01:05:31","slug":"build-a-data-analysis-tool","status":"publish","type":"post","link":"https:\/\/preview-php85.dzine.org\/five\/blog\/build-a-data-analysis-tool\/","title":{"rendered":"How to Build a Data Analysis Tool (Quick &#038; Easy Guide)"},"content":{"rendered":"\n<h2 class=\"wp-block-heading\">How to Build a Data Analysis Tool In 4 Steps<\/h2>\n\n\n\n<p class=\"wp-block-paragraph\">Data analysis can be tricky. First you need a you need to actually collect your data. But an issue many people struggle with is presenting this data in a comprehensible form. Many turn to Excel and use Excel&#8217;s charting features to display their data but it often turns into an ugly mess. Another thing is Excel struggles with larger datasets which means your spreadsheet just turns into a slow and cumbersome headache. <\/p>\n\n\n\n<p class=\"wp-block-paragraph\">That&#8217;s why there&#8217;s now tools to help you take your data and present it in a way which is easy to understand and also professional.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">In this article, we&#8217;ll show you how to build a data analysis tool in just a few steps.<\/p>\n\n\n\n<hr class=\"wp-block-separator has-alpha-channel-opacity\"\/>\n\n\n<div class=\"root-eb-toc-t484n wp-block-essential-blocks-table-of-contents\"><div class=\"eb-parent-wrapper eb-parent-eb-toc-t484n \"><div class=\"eb-toc-container eb-toc-t484n  eb-toc-is-not-sticky eb-toc-not-collapsible eb-toc-initially-not-collapsed eb-toc-scrollToTop style-1 list-style-none\" data-scroll-top=\"false\" data-scroll-top-icon=\"fas fa-angle-up\" data-collapsible=\"false\" data-sticky-hide-mobile=\"false\" data-sticky=\"false\" data-scroll-target=\"scroll_to_toc\" data-copy-link=\"false\" data-editor-type=\"\" data-hide-desktop=\"false\" data-hide-tab=\"false\" data-hide-mobile=\"false\" data-itemcollapsed=\"false\" data-highlight-scroll=\"false\"><div class=\"eb-toc-header\"><h2 class=\"eb-toc-title\">Table of Contents<\/h2><\/div><div class=\"eb-toc-wrapper \" data-headers=\"[{&quot;level&quot;:2,&quot;content&quot;:&quot;How to Build a Data Analysis Tool In 4 Steps&quot;,&quot;text&quot;:&quot;How to Build a Data Analysis Tool In 4 Steps&quot;,&quot;link&quot;:&quot;how-to-build-a-data-analysis-tool-in-4-steps&quot;},{&quot;level&quot;:2,&quot;content&quot;:&quot;Why Build a Data Analysis Tool&quot;,&quot;text&quot;:&quot;Why Build a Data Analysis Tool&quot;,&quot;link&quot;:&quot;why-build-a-data-analysis-tool&quot;},{&quot;level&quot;:2,&quot;content&quot;:&quot;Steps to Build a Data Analysis Tool&quot;,&quot;text&quot;:&quot;Steps to Build a Data Analysis Tool&quot;,&quot;link&quot;:&quot;steps-to-build-a-data-analysis-tool&quot;},{&quot;level&quot;:3,&quot;content&quot;:&quot;Step 1: Choose the Right Tool&quot;,&quot;text&quot;:&quot;Step 1: Choose the Right Tool&quot;,&quot;link&quot;:&quot;step-1-choose-the-right-tool&quot;},{&quot;level&quot;:3,&quot;content&quot;:&quot;Step 2: Import Your Data&quot;,&quot;text&quot;:&quot;Step 2: Import Your Data&quot;,&quot;link&quot;:&quot;step-2-import-your-data&quot;},{&quot;level&quot;:3,&quot;content&quot;:&quot;Step 3: Previewing Your Data Analysis Tool&quot;,&quot;text&quot;:&quot;Step 3: Previewing Your Data Analysis Tool&quot;,&quot;link&quot;:&quot;step-3-previewing-your-data-analysis-tool&quot;},{&quot;level&quot;:3,&quot;content&quot;:&quot;Build Your Data Analysis Tool: Next Steps&quot;,&quot;text&quot;:&quot;Build Your Data Analysis Tool: Next Steps&quot;,&quot;link&quot;:&quot;build-your-data-analysis-tool-next-steps&quot;}]\" data-visible=\"[true,true,true,true,true,true]\" data-delete-headers=\"[{&quot;label&quot;:&quot;How to Build a Data Analysis Tool In 4 Steps&quot;,&quot;value&quot;:&quot;how-to-build-a-data-analysis-tool-in-4-steps&quot;,&quot;isDelete&quot;:true},{&quot;label&quot;:&quot;Why Build a Data Analysis Tool&quot;,&quot;value&quot;:&quot;why-build-a-data-analysis-tool&quot;,&quot;isDelete&quot;:false},{&quot;label&quot;:&quot;Steps to Build a Data Analysis Tool&quot;,&quot;value&quot;:&quot;steps-to-build-a-data-analysis-tool&quot;,&quot;isDelete&quot;:false},{&quot;label&quot;:&quot;Step 1: Choose the Right Tool&quot;,&quot;value&quot;:&quot;step-1-choose-the-right-tool&quot;,&quot;isDelete&quot;:false},{&quot;label&quot;:&quot;Step 2: Import Your Data&quot;,&quot;value&quot;:&quot;step-2-import-your-data&quot;,&quot;isDelete&quot;:false},{&quot;label&quot;:&quot;Step 3: Previewing Your Data Analysis Tool&quot;,&quot;value&quot;:&quot;step-3-previewing-your-data-analysis-tool&quot;,&quot;isDelete&quot;:false},{&quot;label&quot;:&quot;Build Your Data Analysis Tool: Next Steps&quot;,&quot;value&quot;:&quot;build-your-data-analysis-tool-next-steps&quot;,&quot;isDelete&quot;:false}]\" data-smooth=\"true\" data-top-offset=\"\"><div class=\"eb-toc__list-wrap\"><ul class=\"eb-toc__list\"><li><a href=\"#why-build-a-data-analysis-tool\">Why Build a Data Analysis Tool<\/a><li><a href=\"#steps-to-build-a-data-analysis-tool\">Steps to Build a Data Analysis Tool<\/a><ul class=\"eb-toc__list\"><li><a href=\"#step-1-choose-the-right-tool\">Step 1: Choose the Right Tool<\/a><li><a href=\"#step-2-import-your-data\">Step 2: Import Your Data<\/a><li><a href=\"#step-3-previewing-your-data-analysis-tool\">Step 3: Previewing Your Data Analysis Tool<\/a><li><a href=\"#build-your-data-analysis-tool-next-steps\">Build Your Data Analysis Tool: Next Steps<\/a><\/li><\/ul><\/ul><\/div><\/div><\/div><\/div><\/div>\n\n\n<hr class=\"wp-block-separator has-alpha-channel-opacity\"\/>\n\n\n\n<h2 class=\"wp-block-heading\">Why Build a Data Analysis Tool<\/h2>\n\n\n\n<p class=\"wp-block-paragraph\">Today, we&#8217;ll explore how to build a data analysis tool and discuss why you might need one. Whether you&#8217;re an academic presenting a data study, someone looking to present data more efficiently, or just entering the world of data sciences (PS: for data entry jobs, check out <a href=\"https:\/\/jooble.org\/jobs-online-data-entry\" target=\"_blank\" rel=\"noreferrer noopener nofollow\">Jooble<\/a>), modern tools can help you achieve this effectively. <\/p>\n\n\n\n<p class=\"wp-block-paragraph\">In this tutorial, we&#8217;ll focus on using one of these tools called Five.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">Five is a modern data analysis tool that allows you to import your dataset, create custom visualizations, and add various features. Unlike traditional data visualization tools, Five lets you build a full-blown web application hosted on a domain of your choice. This means you can incorporate more web application-type features compared to traditional data visualization tools.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">Depending on your needs, this could be either a benefit or a drawback. If you&#8217;re simply looking for beautiful charts and don&#8217;t need additional features to enhance your data presentation, Five may not be the right fit for you. However, if you want to add custom features that can transform your dataset into a professional web application, you should consider signing up for a free trial of Five.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">Five excels at creating data-driven web applications capable of handling complex and large datasets, something that traditional tools like Excel often struggle with. With Five, you can easily customize your web frontend using CSS and add code logic with JavaScript. The data import process is also straightforward; you can connect existing databases like MySQL or Excel\/Google Sheets spreadsheets to Five and build your data analysis around them.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">Security is another aspect where Five stands out. It offers advanced security features, including user authentication, data encryption, and access control, addressing concerns often overlooked by simple visualization tools.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">Turning your data presentation into a modern web application, means you can customize your analysis to include specific features that meet the unique needs of your audience or project. Plus you can customize the look and feel of your application to align with your brand, creating a professional and cohesive presentation.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">While traditional data analysis tools are excellent for quickly creating charts, they often fall short when building data-driven web applications which level up your analysis. Five bridges this gap, providing a solution for those who need to manage and display large amounts of dynamic data efficiently.<\/p>\n\n\n\n<hr class=\"wp-block-separator has-alpha-channel-opacity\"\/>\n\n\n\n<h2 class=\"wp-block-heading\">Steps to Build a Data Analysis Tool<\/h2>\n\n\n\n<h3 class=\"wp-block-heading\">Step 1: Choose the Right Tool<\/h3>\n\n\n\n<p class=\"wp-block-paragraph\">We&#8217;re assuming you already have your dataset. If that&#8217;s the case then you can dive straight in. Firstly, you need to select the correct tool such as Five.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">Make sure to sign up for free access to Five and build your data analysis right inside your browser. Click the button below to get started!<\/p>\n\n\n\n<div style=\"background-color: #001524;\"><hr style=\"height: 5px;\">\n<pre style=\"text-align: center; overflow: hidden; white-space: pre-line;\"><span style=\"color: #f1ebda; background-color: #4588d8; font-size: calc(18px + 0.390625vw);\"><strong>Build Build a Data Analysis Tool<\/strong><br><span style=\"font-size: 14pt;\">Rapidly build and deploy your data tool<\/span><\/span><\/pre>\n<p style=\"text-align: center;\"><a href=\"https:\/\/preview-php85.dzine.org\/five\/get-started\" target=\"_blank\" rel=\"noopener\"><button style=\"background-color: #f8b92b; border: none; color: black; padding: 20px; text-align: center; text-decoration: none; display: inline-block; font-size: 18px; cursor: pointer; margin: 4px 2px; border-radius: 5px;\"><strong>Get Instant Access<\/strong><\/button><br><\/a><\/p>\n<hr style=\"height: 5px;\"><\/div>\n\n\n\n<hr class=\"wp-block-separator has-alpha-channel-opacity\"\/>\n\n\n\n<p class=\"wp-block-paragraph\"><strong>You don\u2019t have to pay anything to develop applications with Five.<\/strong>&nbsp;You only have to subscribe to one of our paid plans if you decide to host your application on Five\u2019s managed cloud, which gives you a custom URL to access your application or share it with your application users. This makes Five a great tool for learners or those who simply want to explore a data analysis software.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">Let\u2019s start developing: launch Five using your personal development environment URL (contained in the email you have received after signing up).<\/p>\n\n\n\n<figure class=\"wp-block-image\"><img width=\"1024\" height=\"649\" src=\"https:\/\/preview-php85.dzine.org\/five\/wp-content\/uploads\/2023\/08\/Five.Co-Landing-Page-1024x649.png\" alt=\"Five.Co - Landing Page\" class=\"wp-image-2085\" srcset=\"https:\/\/preview-php85.dzine.org\/five\/wp-content\/uploads\/2023\/08\/Five.Co-Landing-Page-1024x649.png 1024w, https:\/\/preview-php85.dzine.org\/five\/wp-content\/uploads\/2023\/08\/Five.Co-Landing-Page-300x190.png 300w, https:\/\/preview-php85.dzine.org\/five\/wp-content\/uploads\/2023\/08\/Five.Co-Landing-Page-768x487.png 768w, https:\/\/preview-php85.dzine.org\/five\/wp-content\/uploads\/2023\/08\/Five.Co-Landing-Page.png 1080w\" sizes=\"(max-width: 1024px) 100vw, 1024px\" \/><\/figure>\n\n\n\n<hr class=\"wp-block-separator has-alpha-channel-opacity\"\/>\n\n\n\n<p class=\"wp-block-paragraph\"><strong>TIP<\/strong>:<strong>&nbsp;Our User Community<\/strong><\/p>\n\n\n\n<p class=\"wp-block-paragraph\">If at any point you are hitting a roadblock or don\u2019t know how to continue,&nbsp;<a href=\"https:\/\/five.org\/\" target=\"_blank\" rel=\"noreferrer noopener nofollow\">check out our user community.<\/a>&nbsp;Here you can find answers to the most common questions that people have when using Five. And, of course, you can get advice from our experts on how to develop applications with Five.<\/p>\n\n\n\n<hr class=\"wp-block-separator has-alpha-channel-opacity\"\/>\n\n\n\n<h3 class=\"wp-block-heading\">Step 2: <strong>Import Your Data<\/strong><\/h3>\n\n\n\n<p class=\"wp-block-paragraph\">Click on&nbsp;<strong>Applications<\/strong>&nbsp;near the top left corner of the screen, and right below the hamburger menu icon.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">Now, click on the yellow&nbsp;<strong>Plus&nbsp;<\/strong>icon. A new window \u201cNew Applications Record\u201d will appear.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">Give your application a&nbsp;<strong>Title<\/strong>, such as \u201c<strong>Data Analysis Tool\u201d.<\/strong><\/p>\n\n\n\n<p class=\"wp-block-paragraph\">Save by clicking the&nbsp;<strong>Tick Mark<\/strong>&nbsp;in the top right corner.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">Here\u2019s what your screen should now look like. If \u201c<strong><strong>Data Analysis Tool<\/strong>\u201d<\/strong>&nbsp;is your first application, you will not see any other applications in the list on the left:<\/p>\n\n\n\n<figure class=\"wp-block-image\"><img width=\"1024\" height=\"646\" src=\"https:\/\/preview-php85.dzine.org\/five\/wp-content\/uploads\/2024\/02\/Five.Co-Excel-to-Web-App-Manage-1-1024x646.png\" alt=\"\" class=\"wp-image-2344\" srcset=\"https:\/\/preview-php85.dzine.org\/five\/wp-content\/uploads\/2024\/02\/Five.Co-Excel-to-Web-App-Manage-1-1024x646.png 1024w, https:\/\/preview-php85.dzine.org\/five\/wp-content\/uploads\/2024\/02\/Five.Co-Excel-to-Web-App-Manage-1-300x189.png 300w, https:\/\/preview-php85.dzine.org\/five\/wp-content\/uploads\/2024\/02\/Five.Co-Excel-to-Web-App-Manage-1-768x485.png 768w, https:\/\/preview-php85.dzine.org\/five\/wp-content\/uploads\/2024\/02\/Five.Co-Excel-to-Web-App-Manage-1-1536x969.png 1536w, https:\/\/preview-php85.dzine.org\/five\/wp-content\/uploads\/2024\/02\/Five.Co-Excel-to-Web-App-Manage-1-2048x1292.png 2048w\" sizes=\"(max-width: 1024px) 100vw, 1024px\" \/><\/figure>\n\n\n\n<p class=\"wp-block-paragraph\">It\u2019s time to build your database and import your data.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">1. To start click the blue&nbsp;<strong>Manage&nbsp;<\/strong>button on the top right of the screen near the Five logo.<\/p>\n\n\n\n<figure class=\"wp-block-image\"><img width=\"1024\" height=\"646\" src=\"https:\/\/preview-php85.dzine.org\/five\/wp-content\/uploads\/2024\/02\/Five.Co-Excel-to-Web-App-Manage-1-1024x646.png\" alt=\"Five.Co - Build a data analysis tool - Manage Button\" class=\"wp-image-2344\" srcset=\"https:\/\/preview-php85.dzine.org\/five\/wp-content\/uploads\/2024\/02\/Five.Co-Excel-to-Web-App-Manage-1-1024x646.png 1024w, https:\/\/preview-php85.dzine.org\/five\/wp-content\/uploads\/2024\/02\/Five.Co-Excel-to-Web-App-Manage-1-300x189.png 300w, https:\/\/preview-php85.dzine.org\/five\/wp-content\/uploads\/2024\/02\/Five.Co-Excel-to-Web-App-Manage-1-768x485.png 768w, https:\/\/preview-php85.dzine.org\/five\/wp-content\/uploads\/2024\/02\/Five.Co-Excel-to-Web-App-Manage-1-1536x969.png 1536w, https:\/\/preview-php85.dzine.org\/five\/wp-content\/uploads\/2024\/02\/Five.Co-Excel-to-Web-App-Manage-1-2048x1292.png 2048w\" sizes=\"(max-width: 1024px) 100vw, 1024px\" \/><\/figure>\n\n\n\n<hr class=\"wp-block-separator has-alpha-channel-opacity\"\/>\n\n\n\n<p class=\"wp-block-paragraph\">2. Now click on&nbsp;<strong>Data<\/strong>&nbsp;and then on&nbsp;<strong>Table Wizard<\/strong>.<\/p>\n\n\n\n<figure class=\"wp-block-image\"><img width=\"1024\" height=\"649\" src=\"https:\/\/preview-php85.dzine.org\/five\/wp-content\/uploads\/2023\/08\/Five.Co-Table-Wizard-1024x649.png\" alt=\"Five.Co - Table Wizard\" class=\"wp-image-2087\" srcset=\"https:\/\/preview-php85.dzine.org\/five\/wp-content\/uploads\/2023\/08\/Five.Co-Table-Wizard-1024x649.png 1024w, https:\/\/preview-php85.dzine.org\/five\/wp-content\/uploads\/2023\/08\/Five.Co-Table-Wizard-300x190.png 300w, https:\/\/preview-php85.dzine.org\/five\/wp-content\/uploads\/2023\/08\/Five.Co-Table-Wizard-768x487.png 768w, https:\/\/preview-php85.dzine.org\/five\/wp-content\/uploads\/2023\/08\/Five.Co-Table-Wizard-1536x974.png 1536w, https:\/\/preview-php85.dzine.org\/five\/wp-content\/uploads\/2023\/08\/Five.Co-Table-Wizard-2048x1298.png 2048w\" sizes=\"(max-width: 1024px) 100vw, 1024px\" \/><\/figure>\n\n\n\n<hr class=\"wp-block-separator has-alpha-channel-opacity\"\/>\n\n\n\n<p class=\"wp-block-paragraph\">Let\u2019s go ahead and create our first database table.<\/p>\n\n\n\n<ol class=\"wp-block-list\">\n<li>Give your table a&nbsp;<strong>Name<\/strong>. Let\u2019s go with&nbsp;<strong>Inventory.<\/strong><\/li>\n\n\n\n<li>Now click on the&nbsp;<strong>Plus&nbsp;<\/strong>icon on the right side of the screen. Click the plus icon four times to create four database fields:<br><strong>Field 1<\/strong>&nbsp;will hold information about our products, so we give it the name&nbsp;<strong>Product&nbsp;<\/strong>and select text as its data type. We also give it a size of 100.<br><strong>Field 2<\/strong>&nbsp;will hold information about&nbsp;<strong>Price<\/strong>. Its data type is float and its display type is float.2.<br><strong>Field 3<\/strong>,&nbsp;<strong>Quantity<\/strong>&nbsp;is an integer for its data and display type.<br><strong>Field 4, Total<\/strong>&nbsp;will be used to&nbsp;<a href=\"https:\/\/preview-php85.dzine.org\/five\/blog\/add-a-calculation-to-your-web-app\/\">perform a calculation in the second part<\/a>&nbsp;of the application development process.<\/li>\n\n\n\n<li>Save by clicking the&nbsp;<strong>Tick<\/strong>&nbsp;mark. Before you save, make sure that your table looks exactly like this:<\/li>\n<\/ol>\n\n\n\n<figure class=\"wp-block-image\"><img width=\"1024\" height=\"626\" src=\"https:\/\/preview-php85.dzine.org\/five\/wp-content\/uploads\/2024\/02\/Five.Co-Excel-to-Web-App-Database-Fields-1024x626.png\" alt=\"\" class=\"wp-image-2345\" srcset=\"https:\/\/preview-php85.dzine.org\/five\/wp-content\/uploads\/2024\/02\/Five.Co-Excel-to-Web-App-Database-Fields-1024x626.png 1024w, https:\/\/preview-php85.dzine.org\/five\/wp-content\/uploads\/2024\/02\/Five.Co-Excel-to-Web-App-Database-Fields-300x183.png 300w, https:\/\/preview-php85.dzine.org\/five\/wp-content\/uploads\/2024\/02\/Five.Co-Excel-to-Web-App-Database-Fields-768x469.png 768w, https:\/\/preview-php85.dzine.org\/five\/wp-content\/uploads\/2024\/02\/Five.Co-Excel-to-Web-App-Database-Fields-1536x939.png 1536w, https:\/\/preview-php85.dzine.org\/five\/wp-content\/uploads\/2024\/02\/Five.Co-Excel-to-Web-App-Database-Fields-2048x1252.png 2048w\" sizes=\"(max-width: 1024px) 100vw, 1024px\" \/><\/figure>\n\n\n\n<hr class=\"wp-block-separator has-alpha-channel-opacity\"\/>\n\n\n\n<p class=\"wp-block-paragraph\">Now let\u2019s import our data from our Excel spreadsheet.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">First, go to&nbsp;<strong>Data &gt; Tables.<\/strong><\/p>\n\n\n\n<p class=\"wp-block-paragraph\">Now click on the&nbsp;<strong>Import CSV into Table&nbsp;<\/strong>icon to get started. It\u2019s located to the left of the yellow plus icon with a small arrow pointing down into a box. See the image below to locate it:<\/p>\n\n\n\n<figure class=\"wp-block-image\"><img width=\"1024\" height=\"650\" src=\"https:\/\/preview-php85.dzine.org\/five\/wp-content\/uploads\/2023\/08\/Five.Co-Data-Import-1024x650.png\" alt=\"Five.Co - Data Import\" class=\"wp-image-2089\" srcset=\"https:\/\/preview-php85.dzine.org\/five\/wp-content\/uploads\/2023\/08\/Five.Co-Data-Import-1024x650.png 1024w, https:\/\/preview-php85.dzine.org\/five\/wp-content\/uploads\/2023\/08\/Five.Co-Data-Import-300x191.png 300w, https:\/\/preview-php85.dzine.org\/five\/wp-content\/uploads\/2023\/08\/Five.Co-Data-Import-768x488.png 768w, https:\/\/preview-php85.dzine.org\/five\/wp-content\/uploads\/2023\/08\/Five.Co-Data-Import-1536x976.png 1536w, https:\/\/preview-php85.dzine.org\/five\/wp-content\/uploads\/2023\/08\/Five.Co-Data-Import-2048x1301.png 2048w\" sizes=\"(max-width: 1024px) 100vw, 1024px\" \/><\/figure>\n\n\n\n<hr class=\"wp-block-separator has-alpha-channel-opacity\"\/>\n\n\n\n<p class=\"wp-block-paragraph\">To import your data make sure it is stored in a CSV file. If you\u2019d like to use the data provided above,&nbsp;<a href=\"https:\/\/preview-php85.dzine.org\/five\/download\/source\/Inventory.csv\" target=\"_blank\" rel=\"noreferrer noopener\">download our CSV file here<\/a>.<\/p>\n\n\n\n<ol class=\"wp-block-list\">\n<li>Five\u2019s&nbsp;<strong>Import<\/strong>&nbsp;<strong>Data<\/strong>&nbsp;feature lets you select the database table you\u2019d like to import data into.<br>In our case, there is only one table: our&nbsp;<strong>In<\/strong><strong>ventory<\/strong>&nbsp;table. So go ahead and select it from the dropdown box.<\/li>\n\n\n\n<li>Next, click on&nbsp;<strong>Choose File<\/strong>&nbsp;and find the Inventory.csv file. Upload it.<\/li>\n\n\n\n<li>Five will automatically map the fields of your CSV file to your database fields, provided you have been following this tutorial and your database fields have the same name as the top row of your CSV file.<\/li>\n\n\n\n<li>For&nbsp;<strong>InventoryKey<\/strong>&nbsp;select&nbsp;<strong>Generated.<\/strong>&nbsp;Five will now automatically generate a unique primary key for every record in your CSV file.<\/li>\n\n\n\n<li>For&nbsp;<strong>Total,&nbsp;<\/strong>select&nbsp;<strong>Not Imported<\/strong>&nbsp;from the dropdown box.<\/li>\n\n\n\n<li>Click on the&nbsp;<strong>Tick<\/strong>&nbsp;mark to upload your data.<\/li>\n<\/ol>\n\n\n\n<figure class=\"wp-block-image\"><img width=\"2282\" height=\"1440\" src=\"https:\/\/preview-php85.dzine.org\/five\/wp-content\/uploads\/2024\/02\/Five.Co-Excel-to-Web-App-CSV-Import.png\" alt=\"\" class=\"wp-image-2346\" srcset=\"https:\/\/preview-php85.dzine.org\/five\/wp-content\/uploads\/2024\/02\/Five.Co-Excel-to-Web-App-CSV-Import.png 2282w, https:\/\/preview-php85.dzine.org\/five\/wp-content\/uploads\/2024\/02\/Five.Co-Excel-to-Web-App-CSV-Import-300x189.png 300w, https:\/\/preview-php85.dzine.org\/five\/wp-content\/uploads\/2024\/02\/Five.Co-Excel-to-Web-App-CSV-Import-1024x646.png 1024w, https:\/\/preview-php85.dzine.org\/five\/wp-content\/uploads\/2024\/02\/Five.Co-Excel-to-Web-App-CSV-Import-768x485.png 768w, https:\/\/preview-php85.dzine.org\/five\/wp-content\/uploads\/2024\/02\/Five.Co-Excel-to-Web-App-CSV-Import-1536x969.png 1536w, https:\/\/preview-php85.dzine.org\/five\/wp-content\/uploads\/2024\/02\/Five.Co-Excel-to-Web-App-CSV-Import-2048x1292.png 2048w\" sizes=\"(max-width: 2282px) 100vw, 2282px\" \/><\/figure>\n\n\n\n<hr class=\"wp-block-separator has-alpha-channel-opacity\"\/>\n\n\n\n<p class=\"wp-block-paragraph\">Congratulations! You have now created a database table in a MySQL database and have populated it with data!<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">In the third and last step, we will add a form to our data analysis tool and launch and preview it.<\/p>\n\n\n\n<hr class=\"wp-block-separator has-alpha-channel-opacity\"\/>\n\n\n\n<h3 class=\"wp-block-heading\" id=\"step-3-adding-a-form-and-previewing-your-application\">Step 3: Previewing Your Data Analysis Tool<\/h3>\n\n\n\n<p class=\"wp-block-paragraph\">We have already created our application backend: a relational database with a single table that stores information about our products, prices, and quantities. But a database is not a web app. Our database needs a front-end or graphical user interface so that users can interact with the data.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">Five makes it easy to build a form for your end-users. To get started, click on&nbsp;<strong>Visual<\/strong>&nbsp;and then on&nbsp;<strong>Form<\/strong>&nbsp;<strong>Wizard.<\/strong><\/p>\n\n\n\n<figure class=\"wp-block-image\"><img width=\"1024\" height=\"650\" src=\"https:\/\/preview-php85.dzine.org\/five\/wp-content\/uploads\/2023\/08\/Five.Co-Form-Wizard-1024x650.png\" alt=\"Five.Co - Form Wizard\" class=\"wp-image-2091\" srcset=\"https:\/\/preview-php85.dzine.org\/five\/wp-content\/uploads\/2023\/08\/Five.Co-Form-Wizard-1024x650.png 1024w, https:\/\/preview-php85.dzine.org\/five\/wp-content\/uploads\/2023\/08\/Five.Co-Form-Wizard-300x191.png 300w, https:\/\/preview-php85.dzine.org\/five\/wp-content\/uploads\/2023\/08\/Five.Co-Form-Wizard-768x488.png 768w, https:\/\/preview-php85.dzine.org\/five\/wp-content\/uploads\/2023\/08\/Five.Co-Form-Wizard-1536x976.png 1536w, https:\/\/preview-php85.dzine.org\/five\/wp-content\/uploads\/2023\/08\/Five.Co-Form-Wizard-2048x1301.png 2048w\" sizes=\"(max-width: 1024px) 100vw, 1024px\" \/><\/figure>\n\n\n\n<hr class=\"wp-block-separator has-alpha-channel-opacity\"\/>\n\n\n\n<p class=\"wp-block-paragraph\">There\u2019s only one thing you need to do in the form wizard. Select&nbsp;<strong>Inventory<\/strong>&nbsp;as your Main Table.<br>Save by clicking the&nbsp;<strong>Tick<\/strong>&nbsp;mark.<\/p>\n\n\n\n<figure class=\"wp-block-image\"><img width=\"1024\" height=\"656\" src=\"https:\/\/preview-php85.dzine.org\/five\/wp-content\/uploads\/2023\/08\/Five.Co-Form-Wizard-Creating-a-form-1024x656.png\" alt=\"Five.Co - Form Wizard - Creating a form\" class=\"wp-image-2092\" srcset=\"https:\/\/preview-php85.dzine.org\/five\/wp-content\/uploads\/2023\/08\/Five.Co-Form-Wizard-Creating-a-form-1024x656.png 1024w, https:\/\/preview-php85.dzine.org\/five\/wp-content\/uploads\/2023\/08\/Five.Co-Form-Wizard-Creating-a-form-300x192.png 300w, https:\/\/preview-php85.dzine.org\/five\/wp-content\/uploads\/2023\/08\/Five.Co-Form-Wizard-Creating-a-form-768x492.png 768w, https:\/\/preview-php85.dzine.org\/five\/wp-content\/uploads\/2023\/08\/Five.Co-Form-Wizard-Creating-a-form-1536x985.png 1536w, https:\/\/preview-php85.dzine.org\/five\/wp-content\/uploads\/2023\/08\/Five.Co-Form-Wizard-Creating-a-form-2048x1313.png 2048w\" sizes=\"(max-width: 1024px) 100vw, 1024px\" \/><\/figure>\n\n\n\n<hr class=\"wp-block-separator has-alpha-channel-opacity\"\/>\n\n\n\n<p class=\"wp-block-paragraph\">It is time to preview our application! Click deploy to development in the top right or if you&#8217;ve already done that press the play button.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">Here\u2019s what your application looks like:<\/p>\n\n\n\n<figure class=\"wp-block-image\"><img width=\"1024\" height=\"655\" src=\"https:\/\/preview-php85.dzine.org\/five\/wp-content\/uploads\/2024\/02\/Five.Co-Excel-to-Web-App-First-Look-at-the-Application-1024x655.png\" alt=\"\" class=\"wp-image-2347\" srcset=\"https:\/\/preview-php85.dzine.org\/five\/wp-content\/uploads\/2024\/02\/Five.Co-Excel-to-Web-App-First-Look-at-the-Application-1024x655.png 1024w, https:\/\/preview-php85.dzine.org\/five\/wp-content\/uploads\/2024\/02\/Five.Co-Excel-to-Web-App-First-Look-at-the-Application-300x192.png 300w, https:\/\/preview-php85.dzine.org\/five\/wp-content\/uploads\/2024\/02\/Five.Co-Excel-to-Web-App-First-Look-at-the-Application-768x491.png 768w, https:\/\/preview-php85.dzine.org\/five\/wp-content\/uploads\/2024\/02\/Five.Co-Excel-to-Web-App-First-Look-at-the-Application-1536x982.png 1536w, https:\/\/preview-php85.dzine.org\/five\/wp-content\/uploads\/2024\/02\/Five.Co-Excel-to-Web-App-First-Look-at-the-Application-2048x1310.png 2048w\" sizes=\"(max-width: 1024px) 100vw, 1024px\" \/><\/figure>\n\n\n\n<hr class=\"wp-block-separator has-alpha-channel-opacity\"\/>\n\n\n\n<p class=\"wp-block-paragraph\">Five gives you a fully auto-generated front-end, including the form that you have just developed using Five\u2019s Form Wizard, as well as:<\/p>\n\n\n\n<ol class=\"wp-block-list\">\n<li>A menu on the left,<\/li>\n\n\n\n<li>A&nbsp;<strong>search bar<\/strong>&nbsp;on the top,<\/li>\n\n\n\n<li>A&nbsp;<strong>filter&nbsp;<\/strong>next to your search to filter through your data, and<\/li>\n\n\n\n<li>The ability to&nbsp;<strong>add, edit, or delete records from your databas<\/strong>e through the graphical user interface.<\/li>\n<\/ol>\n\n\n\n<p class=\"wp-block-paragraph\">In short, we have just created the first prototype of a web application that runs on a searchable online database.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">To keep building this application, follow the next steps of this tutorial below.<\/p>\n\n\n\n<hr class=\"wp-block-separator has-alpha-channel-opacity\"\/>\n\n\n\n<h3 class=\"wp-block-heading\" id=\"excel-to-web-app-next-steps\">Build Your Data Analysis Tool: Next Steps<\/h3>\n\n\n\n<p class=\"wp-block-paragraph\">Well done! You have successfully built and deployed your first web application in Five. Instead of managing your data in a spreadsheet, you can now use a modern data analysis tool to store, retrieve, and process your data. And it took only three steps to go from data to web app!<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">Five\u2019s prebuilt user interface has automatically created an&nbsp;<strong>Inventories&nbsp;<\/strong>menu item for you. You can also see your&nbsp;<strong>Products<\/strong>&nbsp;in the list to the left of the screen. Last, by selecting one of the products, you can see its details, and make changes to them as necessary. Five also comes with a pre-built&nbsp;<strong>search and filtering<\/strong>&nbsp;feature.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">Check out this screenshot of a finished application to get a sense of what\u2019s possible:<\/p>\n\n\n\n<figure class=\"wp-block-image\"><img width=\"1280\" height=\"720\" src=\"https:\/\/preview-php85.dzine.org\/five\/wp-content\/uploads\/2023\/05\/Five.Co-SQL-Dashboard.png\" alt=\"Build a data analysis tool\" class=\"wp-image-959\"\/><\/figure>\n\n\n\n<p class=\"wp-block-paragraph\">Next, check out Part 2 of this guide and learn how you can add calculations to your application. For example,&nbsp;<a href=\"https:\/\/preview-php85.dzine.org\/five\/blog\/add-a-calculation-to-your-web-app\/\">let\u2019s calculate the&nbsp;<strong>Total<\/strong>&nbsp;field in our form<\/a>.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">You can also change the design of your application by&nbsp;<a href=\"https:\/\/preview-php85.dzine.org\/five\/blog\/make-your-application-look-good-themes\/\">adding a theme to it. This will make your web app look more professional and unique.<\/a><\/p>\n\n\n\n<p class=\"wp-block-paragraph\">You can also add a&nbsp;<a href=\"https:\/\/preview-php85.dzine.org\/five\/blog\/how-to-make-a-multiuser-app-in-2-steps\/\">login and terms &amp; conditions consent screen to your application<\/a>&nbsp;and give users different roles and permissions to access data.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\"><strong>With&nbsp;<a href=\"https:\/\/preview-php85.dzine.org\/five\/blog\/charts-dashboards\/\">charts or dashboards<\/a>, you can let users perform analytics &#8211; this one is especially relevant.<\/strong><\/p>\n\n\n\n<p class=\"wp-block-paragraph\">Last, you can show your data in an&nbsp;<a href=\"https:\/\/preview-php85.dzine.org\/five\/blog\/free-microsoft-access-alternative\/\">editable grid by following our Northwinds tutorial.<\/a><\/p>\n\n\n\n<p class=\"wp-block-paragraph\">Remember how at the top we spoke about capturing clean data? Why not add a few&nbsp;<a href=\"https:\/\/preview-php85.dzine.org\/five\/blog\/powerful-sql-data-validation-techniques\/\">data validation rules<\/a>&nbsp;to your application?<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">In short, we have barely scratched the surface of what\u2019s possible in Five! For further inspiration on what can be built in Five,&nbsp;<a href=\"https:\/\/preview-php85.dzine.org\/five\/use-cases\/\">visit our Use Cases<\/a>&nbsp;or keep following our tutorial by&nbsp;<a href=\"https:\/\/preview-php85.dzine.org\/five\/blog\/add-a-calculation-to-your-web-app\/\">adding a calculation to your application.<\/a><\/p>\n","protected":false},"excerpt":{"rendered":"<p>How to Build a Data Analysis Tool In 4 Steps Data analysis can be tricky. First you need a you need to actually collect your data. But an issue many people struggle with is presenting this data in a comprehensible form. Many turn to Excel and use Excel&#8217;s charting features to display their data but [&hellip;]<\/p>\n","protected":false},"author":11,"featured_media":3361,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"_acf_changed":false,"_eb_attr":"","_uag_custom_page_level_css":"","footnotes":""},"categories":[21],"tags":[],"class_list":["post-3349","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-blog"],"acf":[],"uagb_featured_image_src":{"full":["https:\/\/preview-php85.dzine.org\/five\/wp-content\/uploads\/2024\/07\/Five.Co-How-to-Build-a-Data-Analysis-Tool-.png",1280,720,false],"thumbnail":["https:\/\/preview-php85.dzine.org\/five\/wp-content\/uploads\/2024\/07\/Five.Co-How-to-Build-a-Data-Analysis-Tool--150x150.png",150,150,true],"medium":["https:\/\/preview-php85.dzine.org\/five\/wp-content\/uploads\/2024\/07\/Five.Co-How-to-Build-a-Data-Analysis-Tool--300x169.png",300,169,true],"medium_large":["https:\/\/preview-php85.dzine.org\/five\/wp-content\/uploads\/2024\/07\/Five.Co-How-to-Build-a-Data-Analysis-Tool--768x432.png",768,432,true],"large":["https:\/\/preview-php85.dzine.org\/five\/wp-content\/uploads\/2024\/07\/Five.Co-How-to-Build-a-Data-Analysis-Tool--1024x576.png",1024,576,true],"1536x1536":["https:\/\/preview-php85.dzine.org\/five\/wp-content\/uploads\/2024\/07\/Five.Co-How-to-Build-a-Data-Analysis-Tool-.png",1280,720,false],"2048x2048":["https:\/\/preview-php85.dzine.org\/five\/wp-content\/uploads\/2024\/07\/Five.Co-How-to-Build-a-Data-Analysis-Tool-.png",1280,720,false]},"uagb_author_info":{"display_name":"Ryan Forrester","author_link":"https:\/\/preview-php85.dzine.org\/five\/author\/f1v5_ed9_au\/"},"uagb_comment_info":0,"uagb_excerpt":"How to Build a Data Analysis Tool In 4 Steps Data analysis can be tricky. First you need a you need to actually collect your data. But an issue many people struggle with is presenting this data in a comprehensible form. Many turn to Excel and use Excel&#8217;s charting features to display their data but&hellip;","_links":{"self":[{"href":"https:\/\/preview-php85.dzine.org\/five\/wp-json\/wp\/v2\/posts\/3349","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/preview-php85.dzine.org\/five\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/preview-php85.dzine.org\/five\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/preview-php85.dzine.org\/five\/wp-json\/wp\/v2\/users\/11"}],"replies":[{"embeddable":true,"href":"https:\/\/preview-php85.dzine.org\/five\/wp-json\/wp\/v2\/comments?post=3349"}],"version-history":[{"count":0,"href":"https:\/\/preview-php85.dzine.org\/five\/wp-json\/wp\/v2\/posts\/3349\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/preview-php85.dzine.org\/five\/wp-json\/wp\/v2\/media\/3361"}],"wp:attachment":[{"href":"https:\/\/preview-php85.dzine.org\/five\/wp-json\/wp\/v2\/media?parent=3349"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/preview-php85.dzine.org\/five\/wp-json\/wp\/v2\/categories?post=3349"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/preview-php85.dzine.org\/five\/wp-json\/wp\/v2\/tags?post=3349"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}