Prism Business Intelligence Tools - Tips and How-to's

New Help Desk System

2011-08-02T07:55:00Z

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 new Help Desk system is now up and running, and will help us efficiently handle all the end-user support requests that we receive. We invite you to try it now ! The new system includes: • Ticketing System – When a new support request is received,...(read more)

How many Days from Today

2011-07-11T09:30:00Z

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 you want to calculate with Example: DDiff( Now([CreateDate (Days)]) , [CreateDate (Days)] ) This function returns the amount of days from CreateDate till today. Have an amazing day!...(read more)

Prism Goodies - a Dashboard Inspired by Google+

2011-07-07T08:27:00Z

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: The dashboard enables sales reps to have complete control over the lead pipeline Reps can click a lead to get information about them from social networks Reps can see if leads from the same domain/IP already exist in the system Reps can filter leads...(read more)

Application Insights: How to calculate MAU and DAU in Prism

2011-05-05T11:16:00Z

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 per day by some event (i.e. # unique users that clicked on video) MAU Refers to the number of unique users per the past 30 days by some event. The main problem is to calculate the MAU due to the fact you need to count the number of unique users for...(read more)

Pivot Values - Change Currency Values

2010-11-14T14:45:00Z

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 in the ElastiCube manager. (You don't need to connect it to any other table) Select Build Schema Changes and open Prism Create a Pivot, then drag a dimension onto the rows and drag some amount Measure onto the columns. Now, add the two dimensions...(read more)

Example of how to implement Chart zooming in BIStudio

2010-10-24T09:53:00Z

...(read more)

Placeholders Sample

2010-10-20T08:28:00Z

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 on the rows and some measure on the columns Rename the Date Picker to Date1 Make sure that the date picker is not connected to the Pivot Create a duplicate count aggregation on the Products call it # Products Create a new custom measure ( # Products...(read more)

How many days from sale to sale

2010-04-27T17:24:00Z

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: First I duplicated this table using the duplicate item when hovering a table, now we have two identical tables: [Daily Sales By Code] and [Daily Sales By Code2] Next step is to Add an SQL statement that will combine this tables together: SELECT a...(read more)

Sum of Max

2010-03-02T08:35:00Z

How to get the total out of a max aggregation?...(read more)

Period to Date Calculations

2010-03-01T10:36:00Z

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 sales of the first n days in the current month (or quarter or year) to the first n days in the previous month (or quarter or year). PrismCubed has some built-in period-to-date functions that make this comparison very easy to implement. The basic function...(read more)

Exception Highlighting / Conditional Formatting in the Pivot

2010-01-21T11:21:00Z

How to implement exception highlighting/Conditional Formatting in the Pivot ...(read more)

Converting seconds field to HH:MM:SS format in ElastiCube

2010-01-20T12:42:00Z

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 , Sec ) to our table: Hour Field = div([Seconds],3600) Min Field = div(Mod([Seconds],3600),60) Sec Field = Mod([Seconds],60) Finally, we will create a fourth field to contain the final HH:MM:SS string ( HourRep ). We do this by concatenating the three...(read more)

Saving Aliens, Web Analytics and Business Intelligence

2009-06-30T18:59:00Z

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 aliens. Roy is one of the founders of a virtual alien (pet) site called saveanalien.com . Save an alien has 10 million unique aliens (each alien is one of a kind) and they are all up for adoption. The reason so many aliens are looking for a home...(read more)

A Look at the Business Intelligence Index

2009-03-17T12:56:00Z

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 compared to what's going on in the market, I'd say it is holding its head ABOVE water. He concludes that the "The software companies in the BI index, although many being in the middle of the performance rankings YTD, are likely to fare...(read more)

We're featured by Forrester in their Business Intelligence for a tough economic climate report.

2009-02-24T12:37:00Z

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 a sobering reality, enterprises look for various ways to increase revenues and reduce costs. While overall IT budgets become targets for cost cutting, business intelligence applications and infrastructure need not fall into the same category. Smart...(read more)