Sales Record Reporting and Analysis

Traditionally, chain stores used Excel to report daily sales data, and each store needed to build its worksheet. Only the names of each worksheet are different while the structures are the same in data management. Creating multiple sheets causes a waste of resources, and it isn't easy to manage, update, and view data in real-time.

In Jodoo, you can report data from chain stores with only one form. So, this chapter describes how to collect and analyze data through a case of reporting and analyzing sales data in Jodoo.

How to Collect and Analysize Data in Jodoo?

Step 1 Figuring out the Label of Data to be Collected

We need to figure out what statistical analysis is to be carried out and what permissions need to be set when reporting sales data:

Given this, the label which can aggregate data is "date" and "store name".

When we enter all data into a form, we can easily differentiate them through the labels attached to each record and retrieve them for analysis when needed.

Step 2 Creating a Form for Data Collecting

1. Each store needs to enter daily sales data, so you can design a form as follows.

2. After the managers of each store submit the daily sales data through the form, the data will be aggregated in Manage Data for viewing.

Step 3 Configuring Permission Set to Manage Data

1. Set different permissions in Publish > To Members for each store manager so that these managers can manage the data of their stores.

2. The store manager can add, delete, or update the sales data when accessing the form.

Step 4 Analyzing Data through Dashboards

1. Based on reported data, you can make daily and monthly reports of each store through detail tables in a dashboard, where the aggregated data of all stores can be displayed.

2. Store data can also be aggregated monthly as follows.

3. The sales ratio of each store can be counted in a pie chart in a dashboard, making data management more efficient.

Step 5 Configuring Permission Set for Dashboards

You can set Access for the form as the data source in the dashboard. If you select All Form Data, members can view all data after the dashboard is published to them. If you select Same As Member, members can only access data according to the permission set in the form.

Once the above settings are completed, the data entered later can be automatically stored in Manage Data. Members can query the latest data within their permissions in real-time on mobile/PC.

How to Import Data from Excel to Jodoo?

If there is an Excel sheet, you can import data into Jodoo as follows. For details, see Importing Data.

Note:

Before importing data, you need to organize the Excel file properly, with the title on the first row and the data arranged below them. Otherwise, data will not be imported smoothly.

I have finished reading. 🏆

👉I can't wait to COLLECT DATA.

👉I need more HELP in Discord Forum.