This website uses Cookies. Click Accept to agree to our website's cookie use as described in our Cookie Policy. Click Preferences to customize your cookie settings.
There are situations when your data needs to represent a many to many relationships such that your dimension members are at a lower grain than related facts; aka multivalued dimension. In these cases, a single fact record should relate to multiple d...
Overview:Many times, we'd like to analyze workload over time. The following article describes a modeling solution approach to an often asked question: "How many active items are there per day?" Analytical Need:Counting the number of open tickets per...
OverviewThis post offers food for thought in regards to how R can be used to retrieve the real-time datetime with the RDouble function. It shows how to run date comparisons using the R syntax. ChallengeNormally if you want to compare a datetime to "...
DescriptionA common visualization is a comparison between personal KPIs and the rest of the team KPI averages. The main challenge is when applying a security configuration, the other users’ data is filtered out Example A typical Elasticube for sales ...
You might want to compare MoM on a daily average, which means to take the daily average of the current month (even if the month isn’t over yet), and compare it with the previous month’s daily average. You might also want to do the same for QoQ, meani...
Analytical Need Sisense comes with a function called Median() to calculate the median of a set of values. However, this function works with one assumption: we have all the values stored in one column and each row in the table represents one occurren...
Data PreparationOrange: Borrowed from another table via lookup() Blue: Custom columnIf the first visit date is available in the dimension:Lookup the user’s First Visit Date from the dimension table in a custom column of the fact table based on the us...
If you know the size your range/bucket will increment by, this quick method will help you automatically sort your values into their respective range.This is useful when you cannot create or maintain ranges using a CASE statement. In the below example...
This expression will convert IP addresses in the quad decimal format of 'www.xxx.yyy.zzz' to integers that can be used for further analysis (eg. cross referenced to a geo-location).For example, it would convert the string '66.249.66.1' to the integer...
Data is a beautiful mess. As data heroes, we spot the mess and get rid of it to highlight the beauty. Here are a couple useful tricks to detect incorrect data. We will assume a table that describes the number of meows made by each cat in each box, o...
IntroductionSometimes when your analyzing sales you may want to look at products that are not being sold. Or maybe for a service provider you may want to see territories where you have no subscriptions. Unfortunately, data typically does not contain ...
IntroductionThis Post Explains how to create a new column that will calculate the week number of a Quarter.Business CaseIn many cases Business Analyst would like to track trends over time aggregated by quarters but broken down to the week within each...
Analytical NeedFact tables may include a wide date range. For instance, a table can have historical dates without any transaction of the current year,The Need : filter the dashboard based on the latest year in the data Modeling Challenge We need t...
For general information on types of data relationships, potential complications and how to resolve them, see the following articles: Data Relationships: Introduction to Many-to-ManyData Relationships: Check Type of relationshipData Relationships: O...
Analytical Need In many use-cases, there’s a need to measure entities throughout their life cycle which spans from their ‘Start’ date to ‘End’ date. For example insurance company wants to count how many active policies there are on any given day. ...
For general information on types of data relationships, potential complications and how to resolve them, see the following articles: Data Relationships: Introduction to Many-to-Many Data Relationships: Check Type of relationshipData Relationships: ...
Analytical NeedCohort is a group of items who share common characteristic over a certain period of time. The Cohort analysis helps us identify the relationship between their characteristic and their behavior along relative periods of time. Modeling...
Introduction Surrogate Keys are mainly used for creating a single identifier for multiple dimensions, mainly when building a Key Table. A text key can be easily generated by concatenating the text and delimiters, however, text can become very long a...
Analytical NeedData security is implemented when there is a need to prevent the users from seeing the entire set of data. Each user only needs to see a data set based on permissions that is defined in Sisense Web. Here we will discuss how to solve a...
Analytical Need When we want to measure the service level we provide our customers we can do that using many different KPIs. These differentiate between industries and management decisions. This modeling use case is focused on employees in stores...
Recommended Quick Links
Developers:
Product Feedback Forum:
Need additional support?:
The Legal Stuff
Have a question about the Sisense Community?
Email [email protected]
