While Thanksgiving is a perfect time to express gratitude to people you appreciate, Giving Tuesday is a great chance to celebrate kindness and humanity. It’s an initiative that began in 2012, with a purpose to promote acting more kindly and generously.
And with this international day of charitable just around the corner, we’ve prepared a thematic tutorial for you.
Let’s take a Kaggle’s dataset about the charities in the USA and turn it into something meaningful. To explore hidden trends in the data, our helping hand will be WebDataRocks – a universal tool for reporting and data analysis.
Can’t wait to see the results? Jump right to the demo. Otherwise, let’s get hands dirty with practice!
Prettify the data
No data analysis starts without data preparation. Take a look at your data first – does everything suit you? If not, let’s put it in good shape.
Firstly, we recommend converting CSV data to JSON since this format opens up more opportunities for customization of the way fields are displayed on the grid.
Next, define the first object in the JSON array that will be responsible for setting data types and captions for the fields. Using a separate object in the data source for defining the view and properties of the fields helps avoid manual renaming fields. You can learn more details about its structure in the Data types in JSON guide.
Create a report
It’s time to pick the hierarchies you want to see on the grid. With the Field List, place them into rows, columns, and measures. Next, apply filtering to display only those hierarchies that satisfy your goals. To see the most relevant records first, sort them in ascending or descending order.
Don’t worry – you can easily arrange the fields differently with the drag-and-drop feature and look at the data from another angle at any time.
When averaging values, the numbers will likely have a lot of digits after the comma. And this is where number formatting comes in handy. Simply select the measure of interest and set needed options to beautify it:
You can also add the currency symbol and arrange its position.
In addition to sorting, you can emphasize values that speak most. Apply conditional formatting for this:
Now it’s easy to see in which cities animal charities have the highest revenue.
Play with code?
Interact with a ready-to-use reporting solution on CodePen.
You can experience the full flexibility of the pivot table tool due to the dynamic nature of reports. Slice and dice your data to gain new insights about the data related to activities of charitable organizations across the USA.
WebDataRocks is available at no cost for any kind of web project.
To dive deeper into its functionality, check out the UI Guide – it covers every feature you have access through the interface.
If you’d like to try creating a dashboard with a pivot table, graphs, maps, and charts, we have something for you as well – a list of guides on integration with charting libraries.