What are Mash-Ups?
Mash-ups in Cloverleaf Analytics are data sources created by combining data from different sources. One example would be combining insurance policies with census data to get the average number of members in a household for each homeowner policy.
Mash-ups are powerful in that it allows you to join external data in with your insurance data for even more advanced analytics. There is no need to build ETL’s or complex processes to do it.
How Do I Add External Data?
You can simply upload a file (Excel, CSV, XML, etc) through the web or you can connect to a data source such as a relational database (Microsoft SQL, Oracle, etc), big database (Snowflake, Mongo BI CX, Apache Hive, etc) or a web service such as Saleseforce.com by defining the connection parameters. You can even script…
Can I Import Data Through the Web?
Yes, you can upload delimited text files and Excel spreadsheets. Cloverleaf Analytics will automatically parse the data into a table ready to report on or join to other data.
Can I Create Formulas with the Mash-Up Data?
Absolutely! You can create formulas, using our intuitive formula editor, with data from multiple sources as though they were from the same source.
Can I Use a Mash-up as a Data Source to Reports or Dashboards?
Yes, that is the beauty of mash-ups! You can create your mash-ups with data from multiple sources and use then as data sources for reports and dashboards. This gives you the powerful capability of joining data from many sources and producing reports, analysis and dashboards. The ways in which you can analyze and visualize your business are limitless.
Below is an example dashboard built on a mash-up of insurance data from Cloverleaf Analytics and census data from the U.S. Census Bureau.