Panorama Business Intelligence

In-memory business intelligence has gotten a lot of traction over the last few years and Microsoft is now revolutionizing the BI market with PowerPivot, it’s new in-memory engine that allows quick, “on the fly” analytics.

With PowerPivot, users can integrate data from multiple sources including corporate databases, Excel spreadsheets and external sources, using familiar tools but gaining greater power and analysis capacity. Many organizations have shown interest in extending this new in-memory platform with a complete business intelligence suite and making it ready for enterprise wide deployments.

Join us for a webinar, featuring a special guest – Derek Comingore, a SQL Server MVP, speaker at national SQL Server user groups and a published author on SQL Server topics. You will learn more about PowerPivot and how you can enhance it with unique self-service BI capabilities like intuitive web interface, advanced analytics and a data level security layer, enabling a secured team, departmental and corporate wide collaboration.
(more…)

As Microsoft drives business intelligence through SharePoint and Office, thousands of Microsoft partners can now deliver a complete BI solution to their customers. Join us for a webinar, featuring Microsoft and Panorama teams, to learn how you can offer a complete end-to-end BI solution that brings together the best of SQL, Office and SharePoint with Panorama NovaView suite, enabling users to perform even deeper analysis in a web environment.

Panorama Software is the only ISV to natively support Microsoft PowerPivot (Microsoft’s new in-memory engine) that enables users to perform even more sophisticated analysis, build interactive reports or create executive dashboards – all in a fully secure and collaborative manner for teams and groups. So with the upcoming release of NovaView for Office 2010, Panorama partners will also be able to extend PowerPivot and SharePoint 2010 to the enterprises.
(more…)

We are happy to announce a major partner initiative that will revolutionize the world of BI on Microsoft. In response to a high volume of partnership inquiries following the platform’s tight technological alignment with the upcoming launch of Microsoft Office/SharePoint 2010, Panorama has greatly simplified registration process for VARs and consultants interested in joining the Microsoft BI eco-system.

While it usually takes months with other vendors to verify and complete partnership registration, the new accelerated Panorama Software’s partner initiative is a simple process that can be filled out in minutes, putting resellers on the fast track to BI excellence.

(more…)

An interesting review of Panorama for PowerPivot / SharePoint 2010 from Ella Maschiach’s BI Blog:

A while ago, I saw Panorama was advertising a webcast detailing how Panorama gives a complete solution for the entire Microsoft BI platform, including PowerPivot. I have to admit, just seeing Panorama and PowerPivot in the same sentence seemed odd to me, as PowerPivot seemed like a completely full solution for its purpose. I didn’t see what Panorama had to add to the equation. And so I began asking Panorama a few questions…

So where does Panorama offer any added value?

Well, if your organization is considering using SharePoint 2010 Enterprise Edition along with PowerPivot. If you are going to deploy your PowerPivot workbooks to SharePoint 2010, and you’d like to look at them on the SharePoint platform (and not download it to your desktop), then you’ll probably be using Excel Services . This would probably be the case if your organization hasn’t moved completely to Office 2010. For instance, your organization may decide to integrate Office 2010 on the IT department workers desktops first and only later move the rest of the organization to Office 2010. Actually, something similar happened in the municipality with Office 2007 and so, I know that can and will happen…

Read more on Ella Maschiach’s BI Blog

Panorama Software’s thought leadership article featured in Microsoft Momentum Magazine:

We’ve all heard the industry call: “Let’s get BI on every desktop.” Managers everywhere have been transfixed on putting more relevant data in the hands of information workers because they know that the right facts and data empower users to make impactful decisions with positive results. To do this, they must have access to analytical tools to interact with data in a more meaningful way.

As the first phase of bringing BI to the masses, canned reports with data extracted from line-of-business systems have had some success. Today’s information worker uses reports to create a snapshot of aggregated data that gives them the initial information to do their jobs correctly.

Sadly, many businesses never realize the full potential of the rich data collected by business intelligence software, for the simple reason that a typical user can’t make heads or tails of it. If more BI vendors realized this, the whole concept of business intelligence wouldn’t have come under so much scrutiny over the years.

Microsoft is pulling through in the clutch. MS Office is one of the most widely used tools in the world and enables users to perform analysis and generate key insights for their businesses. Microsoft has taken an open approach, allowing third-party contributors to extend and build on top of the Office platform, taking the innovation to the next level.
(more…)

I knew for a long time that measures can have text and not only numbers, but last week I had a scenario where it was the perfect solution for my problem.

Let’s say that I work in number of jobs. In every job I got some tasks that I need to do. The fact table looks like this:

Summarizing the “Tasks To Do” column will get the total tasks that I need to do. Summarizing the “Tasks Completed” column will get the tasks that I did. Note that in the Therapist job I didn’t get any tasks.
In the OLAP cube, I created a calculated measure which is the percent of the completed tasks (for every job or for any other dimension). The problem is: What is the answer in case that there are no any tasks to do? Some will say 0% and some will say 100%. That’s why a text measure such as “There are no tasks” can be a perfect solution for this kind of problem. This is the calculation of the calculated measure:

(more…)