Dataverse 3.1.7 Released

Lavastorm have been busy moving their agile data management platform into a web based user interface, adding new functionality and improving usability. The video below highlights just some of the features available in the latest iteration:

  • Browser based interface
  • Wizard based business rules
  • Industry standard scripting language (python) so if you do need more flexibility than the wizards provide it is now even easier

Continue reading →

Posted by Michael Lowe in Dataverse, 0 comments

Linear Regression modeling with Tableau

Tableau despite being an excellent tool to quickly visualize the data can also be used for creation and verification of Linear regression models used for predictive analytics. The ability of Tableau to integrate with external statistical languages like Python or R allows it to use the Regression models built in those languages to directly be used in Tableau.

Continue reading →

Posted by Shashi Bhushan, 0 comments

SQL vs NoSQL Database

Difference between SQL and NoSQL

It is widely known that 80 percent of the world’s data is unstructured or semi-structured data, NoSQL concept has beceome more and more popular. This artical help you understand basic difference between SQL and NoSQL data and which database should you choose to use.

Continue reading →

Posted by Sun Fei, 0 comments

Choose Right Tableau Authentication Method

Authentication and Authorization

To Understand how various login method that tableau server supports. We need to understand two basic concept:

  • Authentication is the process of ascertaining that somebody really is who he claims to be.
  • Authorization refers to rules that determine who is allowed to do what

Continue reading →

Posted by Sun Fei, 0 comments

Resolve Tableau rows dropping issue

Reading data correctly from a data source is the basis of the correct and meaningful visualization! This is true for all visualization tools and Tableau is no exception.

Issue

A peculiar Issue was faced with Tableau data reading once when it suddenly started dropping the data rows that it was reading from a csv file. The environment setup was as follows:

There were ^ delimited csv files getting generated daily from Oracle database by using PL/SQL code.

The files were fairly large (700 MB).

There were more than 100 columns in the csv file with almost 20 measure columns.

These csv files were then used to be appended to the Tableau Data extract (TDE) daily.

Continue reading →

Posted by Shashi Bhushan, 0 comments
Reading TAP 3.12 (ASN1) Files with Dataverse

Reading TAP 3.12 (ASN1) Files with Dataverse

When I first worked at Lavastorm, many years ago now, it was most commonly used for Revenue Assurance and Fraud Analytics in Telecommunications companies. Today, the same visual mapping of data processes allows analysts from all industries rapidly build data models and apply analytics to data from many disparate sources.

Revenue Assurance commonly requires that you acquire data as close to the source as possible, the objective being that you would identify any discrepancy in how business rules had been applied to the data as early as possible in the data value chain. The consequence being that downstream processes, including billing, would use this information and if errors existed this could result in a financial loss or gain, rework and/or impact customer experience.

That’s where Dataverse’s ability to read complex data types, and build your own complex data readers, can come in handy. It allows you to quickly take a vendor or standard specifications (such as the GSMA’s TAP specification for sharing data about roaming customers) and read the data, converting it into records.

Continue reading →

Posted by Michael Lowe in Dataverse, Telecommunications, 0 comments
Importing global weather data since 1850 into Tableau

Importing global weather data since 1850 into Tableau

Optimizing your supply chain is a never ending task. Recently a client asked us to explore localized weather patterns with Tableau. This article shows how we were able to massage the data before importing it into Tableau.

We will use the NOAA (National Centers for Environmental Information) and GSOM (Global Summary of the Month) weather data into Tableau to do some analytics.

Continue reading →

Posted by Michael Lowe in Dataverse, 0 comments
Load more