Jun 26, 2018
Dubnica nad Vahom, Slovakia
Oct 27, 2018   |  By Milos Gregor
This month I released new tool. Reshape.XL is a general purpose tool for effective data processing (wrangling) in Excel. This tool is released as a small installable add-in for Excel.
Jun 18, 2018   |  By Milos Gregor
If you are working with data, you probably have them stored in Excel files, databases or in CSV files. This post is about CSV files, their import and use in the Stagraph environment.
Jun 7, 2018   |  By Milos Gregor
To access data from databases, we use in Stagraph the data_database function. Since databases are an important source of data, we have paid much attention to developing the visual interface for database connection and data retrieving.
May 15, 2018   |  By Milos Gregor
Programming language R is a favored environment for working with data. The number of R users is already reported in millions. Thanks to its capabilities and functionality it can be used in many forms. Selection from the current options is provided by the following article.
Apr 20, 2018   |  By Milos Gregor
In the previous article, we have shown how to link the Stagraph with Power BI Desktop. In this article we will show you some practical examples. If you want to create professional statistical graphics in Power BI and you do not have R programming skills, integration with Stagraph can be very useful for you.
Mar 10, 2019   |  By Milos Gregor
Video tutorial describes ways how you can rename dataset columns (variables) in the Reshape.XL add-in.
Mar 8, 2019   |  By Milos Gregor
Description of two useful functions in the Reshape.XL add-in that can be used for Excel tables sorting.
Feb 24, 2019   |  By Milos Gregor
This tutorial introduces options of Excel table columns selection / removing and horizontal reordering.
Feb 7, 2019   |  By Milos Gregor
This video-tutorial introduces the #Pack function for removing empty rows and/or columns in Excel using the Reshape.XL add-in.
Feb 7, 2019   |  By Milos Gregor
Intro tutorial for group / ungroup functions in #Reshape.XL.