Si Blog

Frequency of values and distinct count of values

Elad (SiSense) — Thu, 11 Dec 2008 19:45:00 GMT

Have you ever wanted to see how many times a value appears in the data, so you casually dropped the 'Value' dimension onto the rows panel of a pivot widget and the 'Count Value' measure onto the columns panel and get the value '1'...(read more)

Filter a Widget With a Click Of a Button

Elad (SiSense) — Mon, 08 Dec 2008 11:14:00 GMT

Have you ever wanted to give your viewers the possibility to filter a widget with a single click? Somewhat like the image below, that lets a user click on either the Best Selling Products or Least Selling Products and see the appropriate products in the...(read more)

Question Composition - Quickly Create Filters and Segmentation in a Flowchart Manner

Elad (SiSense) — Tue, 18 Nov 2008 17:27:00 GMT

Some of you may have probably noticed that apart from sheets, a Prism document may also contains 'questions'. Unlike a sheet that is used to visualize data, a question is a special type of canvas used to visually create filters and segment data...(read more)

Pivot-like Excel Data to Flat Excel Data for Better Analysis and Reporting (Unpivot)

Elad (SiSense) — Fri, 14 Nov 2008 16:05:00 GMT

Sometimes, data in an Excel file is not structured ideally to be imported by Prism. Occasionally, the data is presented in a Pivot-like manner that is more readable and takes up less storage space. A good example for this is marketing survey data that...(read more)

Surviving tough economic times in IT

Adi — Thu, 30 Oct 2008 13:51:00 GMT

Dennis Howlett quotes Sun Microsystems' Tim Bray on surviving the tough economic times . John Doerr lists ten points for companies to stay afloat on Venture Beat . Being frugal has become hip, there's no doubt about that. Both people quoted above...(read more)

Re-using Filters in Widgets and Custom Measures

Elad (SiSense) — Sun, 24 Aug 2008 13:05:00 GMT

If you’ve dug around the product and/or the online documentation, you must have encountered the filtering and segmentation features Prism offers. If not, this is a good time to get acquainted with this powerful feature here . The first advantage of a...(read more)

SiSense Prism for Google Spreadsheets or: Now you can create a dashboard with Google Spreadsheets

Adi — Mon, 04 Aug 2008 08:56:00 GMT

For some time now, we've been looking at including Google spreadsheets as one of the data sources that SiSense Prism supports. We've just launched this, in a public beta, and I wanted to tell you why I think this is an important move. Our philosophy...(read more)

From Business Intelligence to Domestic Intelligence - Manage your personal expenses

Boaz — Wed, 16 Jul 2008 16:33:00 GMT

We're used to think about BI in terms of business use only. But BI is applicable at home too. If we have the tool to analyze any sort of data, why not use it at home? Here's an example: Most credit card companies let you download your personal...(read more)

Private beta for Amazon S3

Elad (SiSense) — Tue, 01 Jul 2008 16:09:00 GMT

We've just released a private beta for Amazon S3 users. The idea is that if you use Amazon's Simple Storage Service (that's where the S3 comes from) you get information about what you're using, why and how much it costs you. However, all...(read more)

Customers who bought this book, also bought... Hmm... Basket Analysis.

Elad (SiSense) — Wed, 07 May 2008 14:09:00 GMT

One day I was browsing around Amazon looking for a book about some boring technical stuff (diving into the company pocket is always a good way to start a lazy morning). When I finally found the book I was looking for, I immediately got a list of products...(read more)

Handling currency conversions

Elad (SiSense) — Wed, 07 May 2008 11:59:00 GMT

Ok, this one isn't from me, it's from one of our users who wanted to show us how he handled currency conversions with Prism. Thank you! I've simplified his scenario, just to get the main point across. Note that this user was working with Excel...(read more)

Showing the most recent data in a Dashboard

Elad (SiSense) — Wed, 07 May 2008 10:56:00 GMT

Prism dashboards often contain a Date Picker or a Drop-down List that affects the entire dashboard. This is very useful when you wish to go back and forward in time, and see the figures for the selected time period(s). Usually, when I refresh the entire...(read more)

Using "Actions" to reduce database workload

Elad (SiSense) — Tue, 06 May 2008 21:56:00 GMT

A typical dashboard or report has several widgets that require query execution in order to present up-to-date results. Some widgets may need to be updated frequently, some on a daily basis, or on a weekly basis - and so on. After you are done creating...(read more)

Analyzing website user activity, disregarding your own company and/or fake users

Elad (SiSense) — Tue, 06 May 2008 18:17:00 GMT

Hi everyone, Since the Web 2.0 boom, many of our users are companies that have websites which are the foundation of their business. These users often use Prism to analyze user activity on their site. The table(s) they use to perform this analysis usually...(read more)

Data Field Types and the Dimensional Model

Elad (SiSense) — Tue, 06 May 2008 17:29:00 GMT

How does Prism decide what the data type of each field is when I connect to a data source? This is a question that keeps popping up, usually because it has direct implications on the type of analysis you can later perform on these fields. More specifically...(read more)