Dubnica nad Vahom, Slovakia
Stagraph is a full-featured, professional tool for producing statistical graphics in publishing quality and visual exploration of large multidimensional data.
Import your data from multiple sources, combine, pre-process and display. Simple data import, the best approach to data visualization.
Stagraph uses the R runtime in the background. Use the tools and techniques of professional data scientists without programming.
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.
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.
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.
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.
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.
Quick start guide for Reshape.XL add-in for data wrangling. Learn how to work with the add-in in 7 minutes.
Add-in Reshape.XL includes 130 basic combinable functions. Using them you can quickly and easily make very complicated data transformations and processing. Their architecture and basic definition were strongly inspired by languages SQL and R.
Introduction of new Excel add-in for data wrangling.
How to use your R skills for data wrangling in Stagraph.
How to wrangle data from CSV files, Excel files, databases, web services using SQL language.