#GivingTuesday: Data Analysis of Charities in the USA with WebDataRocks

Reporting and data analysisTutorial

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. 

Format values

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.

Highlight values

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.

Check results

Voila! The report is ready to be presented to the audience. You can save it in JSON to restore work later or export to Excel, PDF, PNG, or HTML and share it with your colleagues. 

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.

About WebDataRocks

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. 

You can also find more information on interacting with the component via API and integrating with frameworks in the API Reference and the Available Tutorials section.  

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.