You can even use usual static CSV files with exported business data to create a simple business intelligence report to demonstrate the power of Pivot tables and charts.
If you already have your data on the page and simply want to pass them to the component, JSON can be used in this case. The main difference between JSON data source and CSV data source is that CSV data is always loaded by the component. You provide the URL to CSV data and the component starts from loading it. JSON can be passed via API.
Pivot Component allows additional control by providing meta-data to CSV and JSON data. You can define which fields are dates, numbers or compose multilevel hierarchy from several fields for the desired visualization.