Showing posts with label bi software. Show all posts
Showing posts with label bi software. Show all posts

Thursday, February 28, 2008

8 amazing features in Crystal Reports 2008



Crystal Reports 2008 has now unleashed some new powerful and dynamic reporting features not previously seen in a reporting product. We have taken Crystal Reports 2008 for a test drive and we believe "this release has the potential to transform every business user's working environment". Business Objects a provider of business intelligence (BI) solutions, launched Crystal Reports 2008. Reports are the lifeblood of communication between people, business, partners, and customers. Crystal Reports is now fifteen years old. Crystal Reports 2008 continues to provide innovation for both new and existing customers. Crystal Reports 2008 delivers actionable data for any organization with a comprehensive set of new features for business users, report designers and application developers.

Juliette Sultan, Vice President of Information Discovery and Delivery at Business Objects says

"Crystal Reports 2008 brings excitement into reporting. With this release we are addressing the needs of both the report designers and the consumers of the reports. The reaction from our beta customers and partners has been overwhelmingly positive. People are telling us that the game-changing Crystal Reports 2008 has the power to transform decision-making and improve careers."


The release of Crystal Reports 2008 has definitely redefined the reporting experience. Some of the new features include:
• Flexible, interactive report viewing
• Advanced report designer
• More professional looking and persuasive reports
• Comprehensive set of deployment options
• Reduced report proliferation and maintenance
• Reduced design time
• improved designer productivity

Crystal Reports 2008 delivers advanced functionality to help build powerful reports, reduce report proliferation and maintenance, and save time with high-productivity design features. New interactive features include in-report sorting, reformatting and parameter filtering. You can now create visually compelling data presentations by easily embedding Xcelsius and Flash elements. You can save time by adding summary, variance and any other custom calculation into a crosstab row or column without any coding.


1. Xcelsius Integration


Crystal Reports 2008 Xcelsius Integration
What-if scenario like models allow you to visualise the potential outcome of your business decisions and can be built into your reports. Import Xcelsius-generated SWF files into your report and benefit from improved design-time integration. IT and developers will design fewer reports to support the decision making process. Please note: Xcelsius design tool is not included in Crystal Reports 2008.

2. Interactive Report Viewing



Business users can determine answer more business questions with fewer, more flexible reports – significantly reducing Developer and IT support dependency. On-report sorting, filtering, and report reformatting with the .NET Winform, and .NET Webform viewers allows users to explore information interactively without re-querying the database. New optional parameters provide for complex user-driven filtering scenarios.


3. Powerful Crosstabs


Add business-critical information to your reports without coding. Summary, variance, and any other customer calculations can be inserted into a crosstab row or a column – especially useful for reports that benefit from a table structure such as financial reports. The crosstab table structure makes reports much faster to build and maintain. This feature also provides powerful benefits to crosstab-based charts since custom formulas in the crosstab can be visualized within the charts.


4. Advanced Report Publishing


Expand your IT capability and deliver a better customer experience. Also known as report bursting, advanced report publishing is a platform for the mass distribution of personalized content. Multiple reports can be created based on different data sources, combined into one desired file format (such as PDF), loaded with personalized content, and then sent to a dynamic list of recipients—with a single action. The content can be archived, printed, or emailed in separate actions, or simultaneously. This makes scheduling much faster and easier, with the ability to conduct cost effective one-on-one marketing campaigns and other personalized high-volume reporting.

5. Integration with SalesForce.com


The salesforce.com driver included with Crystal Reports 2008 allows for easy access to complete customer data - turning it into actionable business information. Reports that use a salesforce.com driver will refresh when deployed to crystalreports.com.


6. Improved XML Support


Render reports in almost any format and enjoy faster and easier integration with your industry-specific business processes—without any custom coding. The XSLT transformations are embedded into the report file and will be triggered by users from within the viewer when exporting to XML. This provides a powerful, flexible hook for transforming Crystal Reports data and integrating it into other applications.


7. Advanced Paging


Facilitate better online report viewing to your end users. Report designers can customize page size and easily control page breaking after N records/groups. A single report can combine portrait and landscape oriented pages and the white space at the end of groups can be removed by compressing the page footers. Online report consumption is improved because reports are easier to read.



8. Adobe Flash & Flex Integration




Execute business decisions from within the report file. Integrate your reports with operational workflows by embedding Adobe Flex (SWF) applications into your reports. Using Adobe Flex Builder you can create any business-user UI to access report data and integrate with external web services. Data in your report can be passed to the Flex application via Flashvars, making it easy to create a flexible UI even when you don't have access to your data via web services. The Flex applications can do tasks like database write-back - invoking operational workflows directly within Crystal Reports. IT and Developers benefit from instant, coding-free integration of Crystal Reports with your business processes. Please note: Adobe Flex Builder is not included in Crystal Reports 2008.

You can create stunning visualisations with dynamic charts, graphics and video to your reports. A variety of flexible data presentation options are included via Flash. Flash (SWF) files can be integrated into a report, providing interactive and information-rich reports. Flash files can be easily embedded in a report or linked via a website avoiding the need for IT and development time.

Tuesday, January 1, 2008

The benefits of Business Intelligence

The Benefits of Business Intelligence

I am often asked what can Business Intelligence do for my business. So my response is usually ...

Business Intelligence (BI) is both a management process as well as a collection of software applications and underlying technology that enables organisations to make better business decisions by exposing key metrics that drive the organisation
.

Business Intelligence is sometimes confused with Competitive Intelligence but they are not the same concepts. This is true even though BI technology does give management a methodology for getting a better grasp on the internal and external forces that are driving their organisation as well as a way to measure their organisation’s performance against the performance of their competitors.

Properly used, BI systems assist management in developing a data-based decision making model that provides more consistent results when compared to non-BI methods. Organisations that have successfully implemented BI systems have better and timelier access to customer activities, marketplace trends, supply chain issues and a host of other key performance indicators (KPIs) that are not able to be easily measured in a non-BI environment.


The Technology Behind The Business Intelligence Process

All of the data that BI systems access comes from the organisation’s data warehouse which is a specially-designed database that stores integrated data from various sources from within the organisation.

Business intelligence analysts perform data mining, which is the process of analyzing the data in the data warehouse to uncover patterns and relationships, using specialised BI tools such as Microsoft BI, Oracle BI and Business Objects BI.

Because BI needs vary among business sectors, many BI tools are highly industry-specific. Even so, most BI tools provide a similar core suite of capabilities which include executive reporting tools and a management dashboard that aggregates data and provides a high-level view of the organisation from a BI perspective.

Many organisations employ BI strategies in order to support the Balanced Scorecard (BSC) success measurement program. Unlike traditional measurements which are solely financial-based, the BSC approach measures both the financial lagging indicators as well as well as a variety of future performance indicators which are called leading measures. The BSC approach works so well because it not only provides a means for analyzing financial indicators, it also provides a way to quantify an organisation's other value drivers including its learning and growth perspective, business process perspective and its customer perspective.

Companies such as Exxon/Mobile and Cigna Insurance credit their profitability and explosive growth to implementing a BI/BSC strategy that enabled them to precisely gauge their market opportunities and position their companies to become financial and performance leaders in their market niches.

Business Intelligence is a process that works for any size organisation that is dedicated to gaining a competitive edge and raise their visibility in a crowded marketplace.

Friday, December 28, 2007

Business Intelligence - Vendor Consolidation

The OLAP report says

The BI industry has seen a wave of acquisitions since the mid 1990s, with takeovers occurring every few months. The first wave was mainly other companies who were attracted by the higher growth rates in the BI industry and preferred to buy an existing vendor rather than to develop their own product. These changes of ownership did not produce any ‘consolidation’ because there was no net reduction in the number of BI vendors or products. There was also no reduction in competition as market shares were not concentrated in fewer and fewer hands.


Year Acquirer Price Company acquired Product
2007 SAP Pilot Software PilotWorks
2007 Oracle $3.3bn Hyperion Solutions Essbase, Hyperion Planning, HFM, former Brio
2007 Business Objects €225m (~$300m) Cartesis Cartesis Finance, Planning and Analytics
2007 SAP $375m? OutlookSoft OutlookSoft 5 (formerly Everest)
2007 Cognos $339m, $306m net Applix TM1 and Executive Viewer
2007 Exact Software $51.5m Longview Solutions Khalix
2007 SAP $6.8bn Business Objects BusinessObjects, Crystal, Cartesis
2007 IBM $5bn Cognos Cognos 8, Planning, Controller, TM1
2006 Golden Gate Capital (Extensity) Geac MPC
2006 Microsoft ~$50m ProClarity Corporation ProClarity
2006 Applix $14.5m Temtec Executive Viewer
2006 Infor (Golden Gate Capital) MIS DecisionWare (including Alea)
2006 Infor (Golden Gate Capital) Extensity MPC and DecisionWare
2006 Business Objects $56m ALG EPO
2005 Cartesis INEA
2005 Business Objects $100m SRC
2005 Oracle Siebel Siebel Analytics
2004 Apax Partners Funds Cartesis Magnitude
2004 IBM Alphablox
2004 Cognos $52m Frango Controller, Consolidator
2004 Sage Group IntelligentApps
2003 Cognos $157m Adaytum e.Planning
2003 Geac $52m Comshare MPC and Decision
2003 China Development Corporation CIP Executive Suite
2003 Hyperion Solutions $142m Brio Software Intelligence
2003 Business Objects $1.2bn Crystal Decisions Analysis, Holos
2003 Systems Union $42m MIS AG DecisionWare (including Alea), onVision, Plain and DeltaMiner
2002 Open Ratings Gentia
2002 SymphonyRPM WhiteLight
2002 Pilot Software Acquisition Corporation $1.5m Pilot
2001 SPSS $94m Showcase Strategy
2001 Microsoft ~$15m Maximal Max (later renamed to Data Analyzer)
2001 IBM Informix MetaCube
2000 Business Objects $15m OLAP@Work
2000 CA Sterling EUREKA:Suite
2000 Accrue $19m Pilot Software
2000 Broadbase $10m Decision·ism Aclue
1999 Brio Technology, subsequently renamed to Brio Software $250m SQRIBE
1999 Hyperion Solutions $15.5m Sapling
1999 PwC Cartesis Carat
1999 CA Platinum Technology InfoBeacon (later renamed DecisionBase)
1999 Sterling $168m Information Advantage MyEureka!
1999 Business Objects $8m Next Action Technology AnswerSets (later renamed to Set Analyzer)
1998 Arbor Software, immediately renamed to Hyperion Solutions $600m Hyperion Software Enterprise, Pillar
1998 Information Advantage $36m IQ Software Data-Vision
1997 Platinum Equity Holdings ~$5m? Pilot Software
1997 Hummingbird Andyne PaBLO
1997 Arbor Software $6.7m AppSource WIRED for OLAP
1996 Seagate Software $84m Holistic Systems Holos
1996 Applix $11m Sinper TM1
1996 Microsoft ~$15m? Panorama relaunched as OLAP Services
1995 DecisionWorks IOC Track
1995 Oracle $100m IRI Software Express
1995 IQ Software $5.2m Soft Systems Data-Vision
1995 Informix $16.5m STG MetaCube
1995 Platinum Technology $36m Prodea Beacon
1994 Dun & Bradstreet ~$28m Pilot LightShip
1994 Speedware Info-Innov Media


I have worked with Microsoft, Business Objects (now owned by SAP) and Oracle. Some of the vendors I have never heard of but now there is a very small list of vendors.

They include:

  • SAP

  • Oracle

  • Microsoft

  • IBM