All tagged Alteryx

Finding Business Age in Alteryx

Age calculation in one of the most widely used features in reports. All tools by default provide Calendar Age between a Start Date and an End Date through Date Difference or Time Difference type of functions. But end users in many cases request for the difference between two dates in Business days. This blog aims at calculating this value in Alteryx. The idea is to eliminate the Saturdays and Sundays in the calculation..

Split file into equal outputs using Alteryx – 4 Methods

Data staging is a very important phase during database upgrades or database migration or for use in parallel processing. Some architects take the dump of entire data either as JSON format or Text format. Then the file is cut into multiple pieces so that the new data warehouse can be populated in small incremental steps. This helps in identifying errors and is also easy for debugging if the process fails at any stage. In this blog, we will be discussing different methods to split a sample file into equal pieces.

Converting JSON data into flat structure using Alteryx

JSON or JavaScript Object Notation is an open-standard text-based storage format derived from JavaScript. The data is stored in Name-Value pairs. Some architects and developers prefer data in JOSN format because of its simple syntax.

But sometimes to analyze the data or do some testing or manipulation, we might need this data in a tidy Two – Dimensional flat structure where the column headers are on the top followed row level values like a standard Excel or CSV format. IN this blog, we will discuss about using Alteryx to convert the JSON file into a flat structure.

Extracting Latitude and Longitude from a KML file using Alteryx

With Tableau’s instant geocoding, it is very easy to build visually rich interactive maps for fields that have a specified geographic role. For most of the developers, Geo Spatial data for geo mapping is big requirement. With Tableau 10.2, a new native spatial data connector was introduced. Tableau at this point (10.5) will not be able to represent Points and Lines and Polygons together. We may expect them in the near future. To show points and lines and polygons together, we need to extract the Latitude and Longitude.

 

Why do "Self-Service BI"​ projects fail?

Even though self-service BI has proved to be a boon but it’s no fairy tale. There have been a lot of shortcomings in adopting self-service BI and it has not been an easy road. According to a report by Gartner 70 to 80 percent of BI projects fail. A lot of these projects are self-service BI projects. How to pevent BI projects from failing?

Self-service analytics less challenging for IT than traditional?

A debate which most of the practitioners of traditional BI tend to engage in is that the self-service BI comes with reduced number of challenges.  Most argue that the self-service tools are ‘drag-n-drop’, and are like a ‘black-box’ which do not give a complete control of the data and its depiction. However, I feel that the challenges are different and complicated in the self-service space.

BI Trends to watch out for in 2017

Even though BI experts pretty much seem to be in total awareness of where are things headed in 2017, backed by the opinions of USEReady's BI experts who have helped numerous companies succeed with data - here are top 5 trends that we think will dominate 2017.  

Top 10 data challenges in BI and tackling those using Alteryx

While there’s been rapid adoption of BI, there have been concerns about the issues related to the most crucial element that fuels these BI initiatives i.e. Data. Data is too often ignored for impurities and flaws, eventually leading to unsuccessful, unsatisfactory and low ROI BI projects.

In this document, we discuss the various pain points that decision makers face and the solutions to overcome them.