Artetics Blog

Lets Meet Art Data v2.2.0!

Available for purchase starting monday, 4/11/2016!

We have been working behind the scenes for the last 4 months on the next generation Art Data version 2.2.0. The previous version is 1.7.6. The significant difference in version number is indicative of the scope of changes coming to Art Data. We are completely changing the way Art Data works, looks and functions in every way.

The old way

Version 1.7.6 (old version) includes 33 plugins which run from the component using a central content plugin that handles locating plugin shortcodes and calling the applicable functionality from it's location in the Art Data component. The problem with this approach is that the user must know the correct shortcode to get the result they want. The other problem is that the some of the 33 plugins featured in the old version of Art Data weren't really data related at all. There were image galleries, image effects, clocks, and more thrown in with some really cool data visualization tools. I'm sure many were confused after first installing the component and seeing the list of plugins. We decided that the ultimate Art Data would focus on what it's best at: visualizing data in various ways and from various sources.

The new way

We wanted to build the best data visualization tool on the market. Such a tool would have a UI where every part of deploying a table or chart could be controlled from an advanced administrator User Interface (UI). The new Art Data makes it easier than ever to visualize your data on a Joomla 3 web page. In the new version (version 2.2.0) we have built an elegant administrator UI to help users create 2 types of tables and 12 types of charts. You can create a dataset from a built in spreadsheet and preview how your table or chart will look while populated with it's dataset. You can choose one of 7 premade table templates or 10 premade chart templates, create new table or chart templates, customize existing table or chart templates. We've taken visualizing data to a whole new level with Art Data v2.2.0. At the bottom of this post are the types of data visualizations you can create.

For the advanced users, we didn't forget about you, with the new Art Data you can still create a visualization from a custom dataset (HTML, CSV File or SQL Query). If you're using HTML you can just enter your HTML table code in the textarea provided. If you're using CSV File you indicate the path to the file and set the delimiter. If you're using SQL Query you enter your SQL Query in the textarea provided and select the database type. The available database types are available at the bottom of this post.

If you're using a database type that isn't 'MySQL - Joomla Database' then you'll have to also enter your server connection details including host, user, password and database name.

Art Data's Parts

Visualizations

The 'visualizations' view is where you will configure your chart or table's basic options such as 'What type of visualization is this going to be? Table or Chart?', 'What type of Table or Chart?,' 'What template would you like to use with this visualization?', 'What dataset would you like to use to populate the visualization?'. You get the picture. The visualization is what ties everything together.

Templates

The 'templates' administrator view is where you can customize nearly everything about the way a table or chart looks including colors, padding, border etc. pretty much everything about the look of the data visualization.

Data

The 'data' administrator view is where you can create a dataset by entering your data into a web spreadsheet application that is built right into Art Data. This makes it quick and easy to create a dataset and populate a table or chart. You can add and remove columns and rows just like a real spreadsheet. The data view was specifically created for the purpose of easy data population because not everyone knows how to write an SQL Query. Create datasets specifically for tables or if you're using a chart then you can select either single series data or multiple series data. Formatting data for populating a visualization has never been easier.

Deploying a Visualization on your Joomla Site

Art Data consists of a component, module, and plugin so you can deploy a table or chart on your site in whatever way you prefer.

Component

The component administrator is for creating and managing your visualizations. One way to deploy a visualization on the front end is to create a new menu item of type 'Art Data Visualization'. This will use the component output to display your table or chart and using this method the visualization will be the main part of the webpage.

Plugin

Another way to deploy a visualization is to use the content plugin. Using this method you can write [artdata id="1"] using the shortcode provided for you in the component administrator and you can put this shortcode anywhere on your site and it will be transformed into a visualization.

Module

The last way to deploy a visualization is to use the module. Simply create a new module instance and select the visualization you'd like to display from the module administrator area, select a template position where you'd like the table or chart to show up and you're done. Three great ways to deploy an Art Data Visualization on your Joomla 3.x site.

Table Types
Name Description
Dynamic Table Sortable, searchable, paginated table.
Static Table Plain table that isn't dynamic in any way. Because not all situations call for a Dynamic Table.
Chart Types
Name Description
Bar Chart A bar chart or bar graph is a chart that presents grouped data with rectangular bars with lengths proportional to the values that they represent. The bars can be plotted vertically or horizontally.
Line Chart A line chart or line graph is a type of chart which displays information as a series of data points called 'markers' connected by straight line segments.[1] It is a basic type of chart common in many fields. It is similar to a scatter plot except that the measurement points are ordered (typically by their x-axis value) and joined with straight line segments. A line chart is often used to visualize a trend in data over intervals of time – a time series – thus the line is often drawn chronologically.
Area Chart An area chart or area graph displays graphically quantitive data. It is based on the line chart. The area between axis and line are commonly emphasized with colors, textures and hatchings. Commonly one compares with an area chart two or more quantities.
Stacked Bar Chart The stacked bar chart stacks bars that represent different groups on top of each other. The height of the resulting bar shows the combined result of the groups.
Stacked Area Chart The stacked area chart or displays graphically quantitive data. It is based on the area chart. The area between axis and line are commonly emphasized with colors, textures and hatchings. Areas are stacked that represent different groups on top of each other.
Pie Chart A pie chart (or a circle chart) is a circular statistical graphic, which is divided into slices to illustrate numerical proportion. In a pie chart, the arc length of each slice (and consequently its central angle and area), is proportional to the quantity it represents.
Percent Bar Chart A variation on the Bar Chart that allows you to represent data that is part of a whole across a bar chart.
Percent Area Chart A variation on the Area Chart that allows you to represent data that is part of a whole across an area chart.
Donut Chart A donut chart is a circular statistical graphic, which is divided into slices to illustrate numerical proportion. In a pie chart, the arc length of each slice (and consequently its central angle and area), is proportional to the quantity it represents.
Step Up Bar Chart
Polar Area Chart The polar area chart is similar to a usual pie chart, except sectors are equal angles and differ rather in how far each sector extends from the center of the circle. The polar area diagram is used to plot cyclic phenomena (e.g., count of deaths by month).
Waterfall Chart A waterfall chart is a form of data visualization that helps in understanding the cumulative effect of sequentially introduced positive or negative values.
SQL Query Database Types
Name
MySQL - Joomla Database
MySQL - Other Database
PostgreSQL
MSSQL (mssql extension)
MSSQL (sqlsrv extension)
Oracle
Access
SQLite
Firebird
Informix
Foxpro
ADO
Sybase
FrontBase
DB2
SAP DB
Netezza
LDAP
ODBC
ODBTP
Gone but not forgotten
The new Joomla! Shop is looking for creative minds...