SiSense is pleased to announce the implementation of a new Help Desk System. As our customer base has been growing rapidly, we want to ensure that we remain able to provide first-class support and a terrific user experience for all of our customers. The...

Hi There, I recently see many of you request for a calculation between some date and today. Using the formula Editor you can use the DDIFF function with two parameters to solve this: 1. Now( [Day Level] ) - Returning Today 2. [Day Level] - The day dimension...

Hello, Designing attractive dashboards can sometimes take even longer than preparing the analysis itself. With SiSense Prism, however, it’s fast and easy! Check out this PSM dashboard template inspired by the design of the new Google+. Design Concepts...

In the past few years analysts trying to measure user stickiness in web or desktop apps, The data exist but they found it very hard to calculate the DAU and MAU. First, what are DAU and MAU? DAU Refers to the number of unique users of your application...

Some businesses need to see the same results in a different currencies, for example a sales manager needs to see the same regional sales by different currencies for each region. First, create a simple conversion table in Excel: Now add this as a table...

Creating dashboards requires placeholders in many cases, in today's post I will show you some use cases for parameters Get the products that did not sold on a selected date range: First we need a date picker with date dimension and a pivot with products...

Today I will answer a very interesting question from Anthony. Anthony need to know how many days pass from one sale to the other from a specific type of sale, lets say the sale type is [Code] field and sale date is [DATE SOLD] The table looks like that...

How to get the total out of a max aggregation?

We frequently want to compare the current month-to-date (MTD) Sales to the sales of the same period in previous month(s), rather than to the sales of entire previous months. For example, if today is the n th day of the month, we would want to compare...

How to implement exception highlighting/Conditional Formatting in the Pivot

We often receive questions from users who need to create special/custom fields. Here, I am happy to share with you the way you can convert an INT field [Seconds] into HH:MM:SS string format First, we will need to add three custom INT fields ( Hour , Min...

We just posted a new customer case study to the site, and since it is one of the coolest so far, I wanted to drop a word or two in our blog: Roy Man, the CTO of saveanalien.com , has strong opinions about web analytics. He is also in the business of saving...

This morning I discovered the existence of the Business Intelligence Index . It is a stock index of Business-Intelligence related companies published by Rick Sherman, the founder of Athena IT solutions . Rick says the index has been treading water, but...

Forrester research just published a report titled "BI Belt-tightening in a tough economic climate". In it Forrester Analyst Boris Evelson discusses the role of business intelligence in tough economic times. "As an economic downturn becomes...