Dipti

 String calculations take up a lot of processing power. When you have lots of string calcs, it can slow down a dashboard. In this article, we will show you how we reduced the time by 99%. We help clients achieve similar results through our Tableau Consulting Services. You can also look this video to see how we did it! The Dataset had 28 million Rows and 112 million Calculations It was a movie review dataset. We extracted the year in which the move was released which was embedded in the movie title. E.g., ‘The Shawshank Redemption (1994)’, with even multiple parentheses in some cases. We wrote 4 new calculated fields, using string functions, to extract the movie year. An example calculation is shown below: So, it has 112 million calcs (4 row level string calcs * 28 million rows). The Viz Loaded in 7.9 Minutes! A simple viz that shows #movies and #reviews by movie year, took 7.9 mins to load! We feel dashboards should be fast that they don’t delay the speed of our thought process. A...

Support Vector Machines (SVM) is a data classification method that separates data using hyperplanes. The concept of SVM is very intuitive and easily understandable. If we have labeled data, SVM can be used to generate multiple separating hyperplanes such that the data space is divided into segments and each segment contains only one kind of data. SVM technique is generally useful for data which has non-regularity which means, data whose distribution is unknown. Let’s take a simple example to understand how SVM works. Say you have only two kinds of values and we can represent them as in the figure: This data is simple to classify and one can see that the data is clearly separated into two segments. Any line that separates the red and blue items can be used to classify the above data. Had this data been multi-dimensional data, any plane can separate and successfully classify the data. However, we want to find the “most optimal” solution. What will then be the characteristic of this most ...

Support Vector Machines (SVM) is a data classification method that separates data using hyperplanes. The concept of SVM is very intuitive and easily understandable. If we have labeled data, SVM can be used to generate multiple separating hyperplanes such that the data space is divided into segments and each segment contains only one kind of data. SVM technique is generally useful for data which has non-regularity which means, data whose distribution is unknown. Let’s take a simple example to understand how SVM works. Say you have only two kinds of values and we can represent them as in the figure: This data is simple to classify and one can see that the data is clearly separated into two segments. Any line that separates the red and blue items can be used to classify the above data. Had this data been multi-dimensional data, any plane can separate and successfully classify the data. However, we want to find the “most optimal” solution. What will then be the characteristic of this mo...

We helped a pharmaceutical company take control of drug stability testing with a custom dashboard that made it easier to spot issues and act fast. With it, they gained: Early alerts for abnormal test results One view of data across all batches Faster decisions for better quality and compliance With real-time insights, the team sped up validation and stayed ready for audits—every step of the way.  📘 Read the Full Case Study: Drug Stability Test Analysis 📥 Download the PDF Report: Download the Stability Test Dashboard PDF

  It All Starts With The Text There is so much of information lying in the text posts made by you and me and all others about all the trending topics today. Being in our respective firms, big or small, each of us collect some data related to our respective businesses and store it to analyze for various projects. At the same time, we all need this ‘unstructured data’ to know and understand more about our clients, customers and the state of our company in the world today. However, working with this data is not easy. The data is not structured, every piece does not have all the information and each part is unique. This is how textual data is. It needs to be processed first and converted in a form that is suitable for analysis. This is very similar to our own databases which we create except that they cannot be used directly and the amount of data is very large. This article opens up the world of text mining in a simple and intuitive way and provides great tips to get started with text...

 Business heads often use KPI tracking dashboards that provide a quick overview of their company’s performance and well-being. A KPI tracking dashboard collects, groups, organizes and visualizes the company’s important metrics either in a horizontal or vertical manner. The dashboard provides a quick overview of business performance and expected growth. An effective and visually engaging way of presenting the main figures in a dashboard is to build a KPI belt by combining text, visual cues and icons. By using KPI dashboards, organizations can access their success indicators in real time and make better informed decisions that support long-term goals. What is a KPI? KPIs  (i.e. Key Performance Indicators ) are also known as performance metrics, performance ratios or business indicators. A Key Performance Indicator is a measurable value that demonstrates how effectively a company is achieving key business objectives. A sales tracking dashboard p...