Differences
This shows you the differences between two versions of the page.
| Both sides previous revision Previous revision Next revision | Previous revision Next revision Both sides next revision | ||
|
en:mervis-analytics:00-start [2019/04/15 16:52] j.siroky [Carpet charts] |
en:mervis-analytics:00-start [2019/04/15 16:53] j.siroky [Electrical heating] |
||
|---|---|---|---|
| Line 4: | Line 4: | ||
| Carpet chars do represent an efficient way for first visual data analysis. Beside classical carpet chart (or heatmap) we do use more sophisticated charts with aggregations. The basic principle is similar to pivot tables and pivot charts. User defines columns, rows and fold function. Each cell's value then represents aggregation of all values that do belong to the particular cell (e.g. average of of all values that were measured on Mondays between 2 and 3 am). | Carpet chars do represent an efficient way for first visual data analysis. Beside classical carpet chart (or heatmap) we do use more sophisticated charts with aggregations. The basic principle is similar to pivot tables and pivot charts. User defines columns, rows and fold function. Each cell's value then represents aggregation of all values that do belong to the particular cell (e.g. average of of all values that were measured on Mondays between 2 and 3 am). | ||
| - | Here are examples of useful carpet chars applications. | + | Below are examples of useful carpet chars applications. |
| ==== Electrical heating ==== | ==== Electrical heating ==== | ||
| - | Charts capture average electrical energy consumption during a week. In this case, electricity is used for heating | + | Charts capture average electrical energy consumption during a week. In this case, electricity is used for heating, as can be seen from the first chart (horizontal axis: hour in day, vertical axis: month). There is clear start and end of heating season. |
| {{ : | {{ : | ||
| Detailed look at weekly schedule shows that heating starts at 4 am during working days, except of Monday, when it starts at midnight, see next chart (horizontal axis: hour in day, vertical axis: day of week). There is a clear end of working hours, as expected in case of this office building. | Detailed look at weekly schedule shows that heating starts at 4 am during working days, except of Monday, when it starts at midnight, see next chart (horizontal axis: hour in day, vertical axis: day of week). There is a clear end of working hours, as expected in case of this office building. | ||