Sunday, September 16, 2012

How to use Big Data to your company’s advantage

Big Data is all about technology and innovation. High speed networks, data sets, data marts, databases, data warehouses and softwares are all very important – these are the technologies and the technical innovations that make it all possible. Lots of companies are squandering all their investment in Big Data. They are trying to make Big Data a technology-driven vacuum.
Managers often ask themselves “Who owns Big Data?” and from the point of view of the IT department, this question is a bit foolish. We already settled the fact that Big Data is mostly about technology and innovations and that all the tools like databases, networks and software applications are what makes it possible. But this doesn’t mean that we should make it a technology-driven vacuum. Here is why we shouldn’t squander with it.
The means to an end:

Yes, the technology that surrounds Big Data is truly amazing and innovative, but in the end, it’s just the means to an end. I say this because I realize that all this technology and technical innovation is just a system of tools in the data driven decision making process. This technology is offering us the ability to process huge amounts of data in real time for decision making purposes. But this is a technical process which is not solving any business problems unless it gets insights from the analyzed data or if your company is getting valuable actionable insights.
The IT staff definitely plays a critical role in the process of analyzing and sorting Big Data. And since its nature is to give real time insights, it demands a high level of support – support from the IT staff and technologists. That’s why when it comes to Big Data, it is like we discovered the oil, but we haven’t built the cars yet.  
There are still very few people who are equipped to understand the data and the statistical machines that are used to produce actionable insights at an intimate level. This is why we cannot use all the available data to gain insights. Companies are trying to implement Big Data at an enterprise level, so every department could make use of the data, but I believe that this is a wrong approach, at least for the moment. Watching from outside, it looks like all the departments are fighting for “ownerships” and this, my friends, is a wrong tactic. Instead of doing so, all the departments should “go along with the Big Data party” and work together under the supervision of those with technical competence and flexibility. The IT department usually has a talents for Big Data project management.
Gathering and hoarding:
Business Intelligence and Data sets have been around for 50 years, since the computer was invented. (Or very soon after). Business Intelligence has been used to  analyze and interpret data, while data sets, data warehouses and databases were used for storage. Data was stored in databases and business intelligence used tools like
reporting tool, spreadsheets and dashboards to analyze this data.
The problem came when the process of gathering the data has become something more like hoarding of data. And BI has started to disappoint with its inability to access and analyze all the data. A reporting tool works only with structured data, but the amounts of data were (and still are) so huge, that it became hard to store it and structure it at the same time. The technology around Big Data makes it easy to gather a wide range of information, but software applications like reporting tools were not fast enough to analyze it.
Don’t get me wrong: a reporting tool is still a useful tool in any company. It can be used to analyze the structured data and to create reports over that data, but for Big Data a different type of tools was required. So Business Analytics stepped out with tools provided by BI developers, tools like OLAP and data-mining. It still is very hard to store all that unstructured data, but it is even harder to analyze it. But technology is continuously developing and we hope that it can keep up with all the data that is being gathered.
 
Rules:
In order for a business to be successful, it needs cross functional teams. These are teams made out of members of every department who work together and have the same purpose. Oftentimes, companies don’t pay attention to a matter like this, which is problematic. Each department has its own way of working, its own tasks and its own rules and when they try to work together, they bump heads. This is why a “cross-functional teams” relationship is required. Having teams with members from every department and data analytics experts can play a key role in the Big Data initiative. It can also contribute to the success of a company.
A complementary attitude is what a company needs – a complementary technique between Business Intelligence with its reporting tools for past insights and Analytics as predictive insights - and a complementary technique at departmental level.

Tuesday, August 21, 2012

Reporting tools – a comparison – part 2

Nowadays, there are many reporting tools available for free or in the form of an open source document. Companies have a wide array of business intelligence tools to choose from. However, most of these applications do not provide hard core corporate features such as multiple user support, integration with existing security mechanisms, ad hoc visual reporting tools or scheduling facilities.  The Part 2 of our comparison will examine some of the most popular contenders for enterprise deployment.
The criteria will include:

  • Ease of use:  the need for training should be minimal and the interface should be pleasurable to use
  • Ease of deployment:  business users should need only a standard web browser to access the tool
  • Security:  the application should work with established security mechanisms (e.g., LDAP)
  • Distribution:  it should be easy for users to have reports emailed to themselves and to others
  • Scheduling:  end users should be able to schedule future report runs (e.g., first Monday of each month)
  • Multiple formats:  users like to have options when exporting report data (e.g., XLS, PDF, CSV)
  • Availability:  users want the reporting system available 24x7 (i.e., clusterability, scalability)
  • Ease of administration:  it should be straightforward to set up and maintain the solution
  • Viability:  the tool should have a well-structured and thriving community with a reasonable license.



In the Part 1 of our comparison we have talked about another 2 promising candidates: OpenReports and Next Reports. Make sure to check out our previous article.
But now let’s get down to business with our other two candidates:
  1.  Pentaho
  2. JasperReports
Pentaho
One of the two primary enterprise-ready open source reporting tools with significant commercial backing, Pentaho focuses on data integration and workflow automation.
The Pentaho Business Intelligence suite includes reporting (a report designer and viewer), analysis (OLAP), dashboards (portal, metrics, alerts) and data mining (relationship and trend discovery)
In terms of features, Pentaho offers what seems to be the "standard" set of open source reporting features, such as a visual report designer and editor, a web-based interface for business users to see, run, and export reports with and several reporting formats, including HTML, PDF, XLS, and CSV. The administrative functions include scheduling reports to run at certain times and the ability to email reports to a number of users.
Pentaho also offers a web-based ad hoc reporting wizard that lets technically-inclined business users point, click, drag, and drop their way to nice looking on-the-fly reports. The conditional report distribution allows users to email reports when certain conditions are met (E.g. sales are 25% below the set limit). There is also a task bar notification that notifies Windows users when a new report is ready to view.
The commercial version of the package, called Pentaho Professional, includes these additional features:
Single Sign-On (SSO) support;
LDAP and Microsoft Active Directory (MSAD) integration;
Clustering support;
Report versioning;
Audit trail collection.
However, in terms of usability, the web interface is the area in which Pentaho has the most room for improvement.  It is certainly powerful with report retrieval, parameter passing, drill-through charts, text linking, and administrative capabilities.  Unfortunately, it's not always intuitive.  Due to the partial integration of JBoss Portal, it often feels like the user has to jump between two entirely different user interfaces.  That makes it difficult for first-time users to understand where to look for certain features, how to navigate through common screens, and how to get back to places they have already been.
The visual report designer and editor is good, but a little bit quirky.  As with its competition, it will take some time to get used to the occasional strange behavior and bake the workarounds into the standard workflow.
In general, Pentaho's web interface is usable with some training and familiarization, but it leaves a lot to be desired.
Jasper Reports
Jasper Reports was created as an open source project by Teodor Danciu in 2001.  Its feature set revolves around reporting and analysis with an overall emphasis on ease of use.
The Jasper Business Intelligence suite includes: JasperReports (a report designer and viewer), JasperServer (it includes a scheduler, as well as ad hoc queries), JasperAnalysis (OLAP) and JasperETL (data integration).
In terms of technology, Jasper has a Java foundation that is based on Tomcat, Spring, and Hibernate.  It supports the standard Acegi open source package to facilitate integration with existing authentication and authorization mechanisms.  As such, it can work in a single sign-on environment with other enterprise systems.
Jasper has the "standard" set of open source reporting features, such as a visual report designer and editor, a web-based interface for business users to see, run, and export reports. You can also chose from several reporting formats, including HTML, PDF, XLS, and CSV and there are a number of administrative functions available, such as scheduling reports to run at certain times and the ability to email reports to a number of users.
Jasper's web interface is not perfect, but it's very good relative to its competition.  Most of it is a modern web 2.0 application with a clean and appealing look and feel.  It provides easy report retrieval, parameter passing, drill-through charts, text linking, and administrative capabilities.  It also allows users to export their reports in a multitude of formats, including XML and Flash in addition to the standard set (HTML, PDF, XLS, and CSV).  Jasper makes it easy for business users to schedule their own reports to run at certain times, such as the first Monday of each month.
The commercial version of the package, called JasperReport Professional, includes these additional features: end-user ad hoc querying and reporting and easy end-user created dashboards and mashups.
For developers creating reports, the Jasper report designer can be used in either stand-alone mode or as a NetBeans plug-in.  As with other open source report designers, there are quirks that need to be worked around until they become habit. For example, the hibernate queries are powerful, but they can lead to performance issues unless special care is paid to optimization.
Final thoughts:
Open source reporting tools have made great strides in the last two years and they will no doubt continue to get stronger every day.  Competition continues to drive the business intelligence developers very hard.  Our competitor’s capabilities have evolved over the years and they will continue to do so. And when it comes to the business intelligence client, whether it’s about greater data integration abilities or a better user interface, be sure to pick the reporting tool according to your business’s needs.

Monday, August 20, 2012

Reporting tools – a comparison – part 1

Business intelligence reporting tools have been around for a number of years.  They provide functionality ranging from developer-only libraries that help organize relational data to visual report designers for IT professionals to web-based ad hoc querying applications targeted at business users.  But only during the past two years have some of these packages matured and evolved to a point where an enterprise can reasonably select one as a significant piece of technology to be deployed throughout the organization.
 
Today we are going to compare some of the most popular reporting tools based on a set of criteria which will include:
 
  • Ease of use:  the need for training should be minimal and the interface should be pleasurable to use
  • Ease of deployment:  business users should need only a standard web browser to access the tool
  • Security:  the application should work with established security mechanisms (e.g., LDAP)
  • Distribution:  it should be easy for users to have reports emailed to themselves and to others
  • Scheduling:  end users should be able to schedule future report runs (e.g., first Monday of each month)
  • Multiple formats:  users like to have options when exporting report data (e.g., XLS, PDF, CSV)
  • Availability:  users want the reporting system available 24x7 (i.e., clusterability, scalability)
  • Ease of administration:  it should be straightforward to set up and maintain the solution
  • Viability:  the tool should have a well-structured and thriving community with a reasonable license.
 
And the candidates are:
  1. OpenReports
  2. Next Reports
  3. Pentaho
  4. JasperReports




OpenReports
Not to be confused with OpenReport, OpenReports (oreports.com) provides enterprise wrappings around a number of reporting engines that include:  BIRT, JasperReports, JFreeReport/Pentaho, and jXLS.  It offers a web-based interface with support for scheduling, security integration, and administration.  

The primary benefit of OpenReports is that it allows users to mix and match reporting engines.  In this fashion, different groups within an enterprise are able to use different report design tools yet share the same server platform.

OpenReports is licensed under the GPL, version 2.  It is based on enterprise Java technology, supports OLAP functionality, and offers many report formats that include HTML, PDF, CSV, XLS, RTF, and image.  
It allows reports to be scheduled and sent to users via email.  It also has both SOAP- and REST-based API's.
 
The Professional version of OpenReports adds the following features:  user dashboards that can display multiple reports, charts, or graphs simultaneously; drilldown charts; and report usage statistics.  The list price for this version is approximately $500 per server.


NextReports


Another interesting approach to business intelligence comes from a fairly small vendor - and that is NextReports. NextReports is offering their customers three distinct tools: NextReports Designer, NextReports Engine and NextReports Server.
 
NextReports Designer is an application able to design in-grid reports using a connection to some of the most popular databases like Oracle, MySql, MSSQL, PostgreSQL, Firebird and Derby. It has an intuitive interface that makes report creation a quick and easy task.

Using NextReports Designer you can design or create your own SQL, create reports from stored procedures and export data to various formats. And these are just the top of the iceberg. By employing unique features, like in-spreadsheet design, Next Reports Designer aims to speed up reporting tasks.
 
NextReports Engine is a lightweight Java platform development library which can be used to run NextReports inside your application. This library is very easy to use: the reports can be integrated with just a few lines of code. And what’s even better is the fact that business developers, value added resellers and ISVs can embed the Reporting Engine into their applications free of charge.

NextReports Server allows scheduling NextReports and Jasper Reports and automatically delivering them via e-mail, FTP, SSH, etc, in all sorts of formats like HTML, EXCEL, PDF, RTF, CSV, TSV, TXT or XML. Featuring a fast and efficient web interface, NextReports Server makes use of advanced Web 2.0/Ajax technologies to provide speed and ease of use normally experienced in desktop applications. NextReports Server shows your charts, table reports and alarm reports in real time inside dashboards.
 
What is interesting in their approach is that they are offering the reporting software applications for free and the only one which requires a fee is NextReports Server. And it is quite cheap considering its usability.
 
To be continued
 
I have just realized that this articole is going to be longer than I have previously anticipated. So I will draw the line here. But stay in touch for the second part of our comparison. We will cover the reporting capabilities of the Jasper Reports system and the Pentaho business intelligence suite.

Tuesday, August 7, 2012

The complete list of reporting software - Part 4




This is the final part of the complete list of reporting software. It’s been a long way down the list, but now it’s done. There are lots of characteristics that you might find important when choosing a reporting software and based on those characteristics, you must choose the right reporting software for you and for your company. I have compiled this list in order to help you with that decision. I also wrote a few things about each reporting tool so you might have a better understanding over them.
Enjoy Part 4 of the complete list of reporting software:

  • OBIEE
Oracle Business Intelligence Enterprise Edition Plus, also termed OBIEE Plus, is Oracle Corporation's set of business intelligence tools consisting of former Siebel Systems business intelligence and Hyperion Solutions business intelligence offerings.
Components:
Oracle BI server
Oracle BI Admin Tool
Oracle BI Answers
Oracle BI Marketing
Oracle BI Interactive Dashboards
Oracle BI Delivers
Oracle BI Disconnected Analytics
Oracle BI Publisher
Oracle BI Briefing Books
Oracle BI Office Plug-In
Oracle Hyperion Financial Reporting
Hyperion Interactive Reporting
Hyperion SQR Production Reporting
Hyperion Web Analysis

  • Oracle Discoverer
Oracle Discoverer is a tool-set for ad-hoc querying, reporting, data analysis, and web-publishing for the Oracle Database environment. Oracle Corporation markets it as a business intelligence product. It was originally a stand-alone product, however it has become a component of the Oracle Fusion Middleware suite, and renamed Oracle Business Intelligence Discoverer.
Components
The Discoverer product comprises:
Discoverer Administrator
Discoverer Catalog
Discoverer Desktop
Discoverer End-User layer
Discoverer Plus
Discoverer Portlet Provider
Discoverer Portlets
Discoverer Viewer
  • Oracle Reports
Oracle Reports is a tool for developing reports against data stored in an Oracle database. Oracle Reports consists of Oracle Reports Developer (a component of the Oracle Developer Suite) and Oracle Application Server Reports Services (a component of the Oracle Application Server).
The report output can be delivered directly to a printer or saved in the following formats: HTML, RTF, PDF, XML, Microsoft Excel
  • Oracle XML Publisher
Oracle XML Publisher (XMLP) is Oracle Corporation's latest reporting technology. It was originally developed to solve the reporting problems faced by Oracle Applications. When XML Publisher became part of the Oracle BI Enterprise Edition Suite it was re-branded as Oracle BI Publisher.
  • SAS, as part of the BI Server suite
SAS (Statistical Analysis System) is an integrated system of software products, which enables programmers to perform:
- retrieval, data management, and data mining
- report writing and graphics
- statistical analysis
- business planning, forecasting, and decision support
- operations research and project management
- quality improvement
- applications development
- data warehousing (extract, transform, load)
- platform independent and remote computing
  • SQL Server Reporting Services
SQL Server Reporting Services (SSRS) is a server-based report generation software system from Microsoft. Administered via a web interface, it can be used to prepare and deliver a variety of interactive and printed reports. SSRS competes with Crystal Reports (see above) and other business intelligence tools.
  • Stimulsoft Reports
Stimulsoft Reports is an application used to design and generate reports from a wide range of data sources.
Stimulsoft Reports product line includes the following products:
- Stimulsoft Reports.Net,
- Stimulsoft Reports.Web,
- Stimulsoft Reports.Web for MVC,
- Stimulsoft Reports.Wpf,
- Stimulsoft Reports.Silverlight,
- Stimulsoft Reports Designer.Web,
- Stimulsoft Reports Designer.Silverlight,
- Stimulsoft Reports.Ultimate is a kit of products mentioned above.
  • Tableau
Tableau Software offers three main products: Tableau Desktop, Tableau Server and Tableau Reader. Tableau's products have been incorporated into product suites of multiple independent software vendors, including Oracle for its Oracle Essbase Visual Explorer product
  • Telerik Reporting
Telerik Reporting is a .NET reporting software for Microsoft Visual Studio 2010. The product is developed and sold by the .NET solutions provider Telerik.
Features:
- Interactive reports (drill-through, hyperlinks, bookmarks)
- Embedding reports in Silverlight, Windows Presentation Foundation, Windows and ASP.NET applications
- WYSIWYG Design Surface
- Export to PDF, Excel, RTF, CSV, MHTML, and all graphic formats supported by GDI+ (JPEG, PNG, GIF, BMP, TIFF, etc.)
- Convert reports from XtraReports, Crystal Reports and Active Reports.
  • Windward Reports
Windward is a suite of enterprise-level reporting software, document generation software, and business intelligence software for business teams. Windward software is used for stand-alone reporting, custom reporting applications, and as the basis for OEM, VAR and other integrated data presentation needs.
  • Zoho Reports (as part of the Zoho Office Suite)
An online business intelligence and reporting application in the suite. It can "create charts, pivots, summary and other wide-range of reports through a powerful drag & drop interface"

And that was the last one of the reporting softwares that I wanted to present to you. I hope that this list will be of good help to everyone who is searching for a reporting tool. Each company has certain requirements from a specific software, this is why you should consider them all before taking a decision. Choosing a reporting tool or a business tool is not an easy thing, so you should go through all the 4 articles and then make an informed decision. Good luck!

Monday, August 6, 2012

The complete list of reporting software - Part 3



In the previous articles I’ve talked about reporting software and a complete list of reporting software applications. In the first article I have talked about the open source reporting software applications. In the second article I started to share the list I have of all the commercial reporting software. This list is kinda long, so I decided to split it in three parts. This is the third part of the reporting software list, but the second part of the commercial reporting software applications available:

  • FOCUS and WebFOCUS
FOCUS is a computer programming language. It is a language used to build database queries, and is regarded as a fourth-generation programming language (4GL). FOCUS resembles other data access and analysis languages such as SQL and SAS, but also includes report and chart display and presentation features. FOCUS assumes a default file structure, and automates the process of identifying files to the operating system, opening the input file, reading the next record, opening the output file, writing the next record, and closing the files. FOCUS has been designed for servers and personal computers and when they extended to world wide web, they named it WebFocus.
  • Infragistics NetAdvantage Reporting
Their products enable developers to create UIs that are then become the foundation for developing applications with data visualization in line of business applications for platforms that include - Windows Forms, Windows Presentation Foundation (WPF), ASP.NET and Silverlight, as well as jQuery/HTML5 and mobile controls for the Windows Phone, iOS (iPhone and iPad) and Android.
  • Izenda Self-Service Reports
Their reporting software supports SQL Server, Oracle, DB2 and MySQL and exports to all file formats.
  • JReport
JReport is a java-based business intelligence application that can be deployed as an embedded reporting engine in other applications, as a stand alone system, or in any cloud environment.
  • List & Label
List & Label is a reporting tool for developers to enable the design and print of reports in Microsoft Windows applications. It supports data sources and development environments such as Microsoft Visual Studio, Embarcadero RAD Studio. Reports are designed once in the interactive Designer and can then be exported to formats such as PDF, Excel, XHTML and RTF. For the custom preview format, a free viewer application is available. The Designer can be used by end-users royalty free with all paid editions of List & Label.

  • LogiXML
LogiXML offers the following Web-based BI reporting and analysis products:
-Logi Info - A complete BI platform for developers to create customized, web-based dashboards, reports, and analysis applications powered by LogiXML's elemental approach that eliminates the need to write code. Logi Info comes with pre-built elements and super elements that deliver application-style end-user capabilities.
-Logi Ad Hoc - A self-service web application that enables business users to create, manage, and share dashboards, reports, and analyses.
-A bundle of Logi Info, Logi Ad Hoc, and Logi ETL, which enables developers to bring data together from diverse sources and perform data transformations.

  • MicroStrategy Reporting Suite
MicroStrategy Reporting Suite is a free, commercial reporting tool for developing and delivering operational and analytical reports. Report outputs are HTML, PDF, Microsoft Excel, and text. Data can be presented in tabular grid reports, graphs and charts, and combination grid-and-graph displays.
The package is composed of server software for core analytical processing and job management, an end-user Web interface, Web-based reporting software, desktop reporting software, and a data architecting product. It is part of the unified MicroStrategy business intelligence architecture. The package includes a license for 100 users, and two free licenses for the other MicroStrategy products, including MicroStrategy Mobile, OLAP, and Distribution Services.
MicroStrategy Reporting Suite can also integrate with Microsoft Analysis Services (SSAS)
  • m-Power
m-Power is software which automates enterprise web application development and modernizes legacy business applications. m-Power uses a point-and-click interface to create enterprise web applications. Applications created by m-Power run on any database or platform that supports Java.
  • QlikView
Its in-memory associative search technology makes calculations in real-time, enabling business professionals to gain insight through intuitive data exploration. QlikView can be deployed on premise, in the cloud, or on a laptop or mobile device for a single user to a large global enterprise.
  • Proclarity
ProClarity's products integrate tightly with Microsoft SQL Server, specifically Microsoft Analysis Services.