February 2009
Monthly Archive
Wed 18 Feb 2009
Posted by Kseniya Savelyeva under
Panorama NewsNo Comments
Panorama Software, the company that sold its OLAP technology to Microsoft that became SQL Server Analysis Services, is proud to introduce a new School of SQL Server OLAP BI.
Our goal is to bring our 15 years of expertise in deploying, optimizing and maintaining SQL Server Analysis Services, reporting and analytics solutions. By sharing this with you we feel confident you can get more out of Microsoft BI platform and increase your return on investment.
Join us for the special 4 part series workshop to learn more about:
- Migrating your Analysis Services 2000 and 2005 solutions to Analysis Services 2008;
- Query and processing engine internals that will help you better understand how Analysis Services work, and how to best optimize your deployments;
- OLAP design best practices.
SQL Server 2008 Development
March 10 – 13, 2009
Sign up for the Workshop Now >>
Fri 13 Feb 2009
Most users are unaware that Google Spreadsheets, a part of Google Docs, the online productivity suite that’s free for individuals, has a majority of the features users look for in Microsoft Excel. Google Spreadsheets’ analytics capability can instantly enhance your use of business, organizational or personal information. Knowledge Center contributor Oudi Antebi explains how Google Spreadsheets can satisfy virtually all of your daily spreadsheet needs, including how to use Google Spreadsheets for no-cost data analytics.
In some ways Google Spreadsheets goes beyond Microsoft Excel and can actually extend the enterprise user’s capabilities. Google Spreadsheets can help users in the enterprise with collaboration, visualization and analytics.
1. Collaboration
Google Spreadsheets allows multiple users to work together in real time on a single spreadsheet report. Even if you’re not ready to replace Excel, you will benefit from uploading your existing spreadsheet to Google Spreadsheets, then inviting people to a collaborative session. When finished, you can simply save your spreadsheet back to Excel or keep it live on Google Docs.
(more…)
Thu 12 Feb 2009
Posted by Kseniya Savelyeva under
Panorama NewsNo Comments
Partnership With Google Apps Allows Enterprise Developers, Application Partners and Others To Create Interactive Business Intelligence Tools for Powerful Salesforce.com Data Analysis
TORONTO, ON – (February 12, 2009) – Panorama Software, a global leader in Proactive Business Intelligence solutions, announced today the release of a free analytical solution for the Salesforce.com platform. Delivered through Google Apps, Panorama’s analytics solution allows programmers to easily, and at no cost, insert advanced analytics tools into the dashboards and reports of Salesforce.com users.
Panorama’s Software as a Service Business Intelligence (BI) technology currently provides powerful analytical capabilities for Google Spreadsheets, the spreadsheet component of the Google Docs online productivity suite, Excel and other data sources that allows end users to perform powerful analysis on their personal or business data. By extending analytics services natively to support Salesforce.com, users can now exploit Panorama’s powerful BI functionality to analyze any SFDC data. A sample report can be seen at http://pivot.panorama.com/Panorama/SFDC.htm.
“Salesforce.com is the leading CRM and SaaS platform today. It only makes sense for users to use the leading SaaS productivity suite with the leading SaaS BI solution to bring users new value and functionality, as well as to get more out of their investments,” said Oudi Antebi, Vice President of Marketing and Strategy for Panorama Software. “We’re pleased to be adding to this collection of capabilities by making our solution available for the Salesforce.com environment.”
(more…)
Thu 5 Feb 2009
In some of our projects, we develop the Panorama views in the development environment along with the Data Warehouse, the ETL, the Cubes, etc. That’s because the customers want to see how their product will look like before we deploy the views in the production environment. So, how do you deploy Panorama views from one environment to the other? Â
- Create the new book – If it’s a new briefing book, create it using the Panorama NovaView Administrator program. If it’s already exist you can skip this step.
- Copy the content – The book’s content is by default in c:\PanoramaFolder\E-BI\books\BookName. Copy the content of this directory from the dev machine to the production machine. This is not enought because the views are still looking at the dev environment, so:
- Change the view’s properties – You need to have a very simple program (let’s call it PanoramaDeployUtil) that iterates over all the views in the given folder (and its sub folders, recursively) and change its properties. I recommend opening the view’s file using xml reader and change the element \pnView\Root\Cube\Properties. You need to set its properties CubeAddress, CubeName & CubeDB according to the new environment’s values (CubeAddress is the server address). Just run this program and the views will look at the new environment.
- Check – check yourself and make sure everything is ok by opening Panorama Web Access or Panorama Desktop and see that the values shown are the production’s values.
Know that you can always open the Panorama Desktop and change the views one by one by hand.
Enjoy.
Tue 3 Feb 2009
Posted by Kseniya Savelyeva under
Panorama NewsNo Comments
Business Intelligence Consulting Firm to Offer Panorama’s Advanced NovaView® BI Applications Suite
TORONTO, ON and JOHANNESBURG, S.A. – (February 2nd, 2009) – Panorama Software, a global leader in Proactive Business Intelligence (BI) solutions, and Harvey Jones, a subsidiary of Avisen Plc, one of South Africa’s leading BI consulting companies, today announced a formal partnership that was started in 2008. Harvey Jones will make Panorama’s NovaView® suite of BI applications available to its enterprise customers. NovaView will be the only specialized BI front-end product offered by Harvey Jones.
Panorama NovaView is a comprehensive and integrated BI suite that spans across analytics, reporting, dashboards, scorecards, advanced visualization and modeling. Known for its intuitive, easy-to-use interface, NovaView helps both novice and experienced BI users interact with data in powerful ways to generate insights that can impact their business regardless of department or industry. With its performance management capabilities, NovaView helps link planning, budgeting and goals to dashboards and scorecards for better business decision-making.
“BI is quickly becoming a business imperative for most organizations. We believe the advanced visualization, Web-based analytics, and report formatting capabilities of NovaView will be of immense interest to clients whose needs are maturing,†said Keith Jones, Managing Director of Harvey Jones. “Panorama’s BI suite will also help set our company apart as a unique provider of high performance, scalable value-added BI products.â€
(more…)
