Implement a timecard Application Based on SharePoint 2013 (below)

Now, you can analyze a little data based on the timecard data.

 

Application Requirements

For timecard, the following two aspects are analyzed:

1. For a single project, analyze the labor ratio of each Member to understand the workload allocation and provide reference for inter-group personnel scheduling.
2. For the entire company, analyze the change trend of timecard's total working hours every week to understand the utilization rate of the company's staff. Too high, such as 100% (or even more than 100%), or too low utilization is not desirable.

 

Application Design

For the first analysis, it is more appropriate to select a pie chart. Because it is for each project, you also need to provide an option to select a project. For example:

 

From the design diagram, we can see that we need a data structure as follows:

• Project
  • Personnel; working hours

 

For the second analysis, it is appropriate to select a stacked bar chart to show the trend of data changes and reflect the resource usage distribution between various projects. For example:

• Project
  • Time Window; Work Hour

 

Application Implementation

Highcharts is the best choice for displaying charts on a web page. This tool has been being upgraded and maintained, and the price of the commercial version is reasonable.

The application is also very simple. You can find examples of various graphics on the highcharts demo, as long as you replace the data.

 

After finishing the job, it will look like this:

 

The last is the Demo Video: