In our regular BI Tools News feature, Passionned Group, publisher of the popular Business Intelligence Tools Survey 2019, walks you through a selection of the most interesting announcements made by BI vendors over the last two months. This is the May 2019 edition of our BI Tools News Alert. During the SAS Global Forum 2019 in Dallas, SAS made several announcements. Key among these is the company's praiseworthy (if not entirely selfless, of course) attempt to democratize the field of (big) data analytics further. The software vendor is offering free AI software to teachers; launching a new analytics simulation game (at a price); and awarding AI certificates and badges. SAS is also investing in the Boys & Girls Clubs to teach kids the tricks of the programming trade.
Software developers and analysts are experts at coming up with new acronyms and exotic-sounding names for their platforms, BI tools, features, plug-ins, and add-ons. NLG, VBD, MOLAP, BIaaS, federated analytics, augmented intelligence, the Prep Conductor, Vizzes, smart analytics, the list goes on. End-users have the unenviable task of looking past the jargon and trying to judge all new announcements on their own merits. A critical attitude, focusing on the promised functionality, will get you far.
Software developers and analysts are experts at coming up with new acronyms and exotic-sounding names for their platforms, features, plug-ins, and add-ons. NLG, VBD, MOLAP, BIaaS, federated analytics, augmented intelligence, the Prep Conductor, Vizzes, smart analytics, the list goes on. End-users have the unenviable task of looking past the jargon and trying to judge all new announcements on their own merits. A critical attitude, focusing on the promised functionality, will get you far.
The world around you is changing. Your organization is changing. The demands the organization places on management information is also changing. There comes a point where you realize that your current tools are inadequate in this new moment. You need newer, modern Business Intelligence tools. But what should this tool be able to do? Polling the organization reveals a diverse set of needs and wants from the various employees, depending on their role in the organization. You may begin to wonder if there are any tools that meet all your needs.
The Gemiva-SVG Group aids people with a mental, physical, or multiple disability, and people with non-inborn brain damage. Gemiva asked Passionned Group for advice on the architecture and organization of its data warehouse, plus advice on which ETL tool to use. The advice project was completed to great satisfaction, and was rated a 9 out of 10 by Gemiva. There were four main questions plaguing Gemiva that they wanted Passionned Group to answer.
Passionned Group has closely watched the market for Business Intelligence & Analytics for many years. Every year we release more updates of our globally used Business Intelligence Tools Survey and the Passionned Parabola for BI & Analytics. The current edition of the survey has again been completely updated in March 2016 with the latest versions of the available BI tools. The main changes: Yellowfin
The Passionned Parabola™, a part of the annual Business Intelligence Tools Survey by Passionned Group, has revealed that the large traditional IT companies risk losing their position as BI market leader. They lack focus. The vendors who occupy the best positions in the Parabola, namely SAS, MicroStrategy, Qlik, Tableau and Yellowfin BI, are all companies that focus completely on Business Intelligence and Analytics.
Business Intelligence and innovation are two concepts that belong together. However, practice shows that little has changed in the BI world for the last 25 years. We've been building data warehouses for decades with Kimball stars, and most organizations use business intelligence exclusively for reports and ad hoc queries. The real added value of these traditional Business Intelligence applications has disappeared because its technology is hopelessly behind and remains complex for end-users. Where are the promising innovative BI tools that would really align with the market demand?
In this article I’m going to share some of my experiences from the SAS Analyst Conference, May 27 - 29, 2015, in Marbella. I had a one-on-one meeting with Scott Gidley, senior director Research and Development, and we had an interesting discussion about the future of data management, Hadoop, Big Data, data warehouses, and Data Lakes. I see a clear trend in data management and integration: the role of the data warehouse is changing rapidly and a lot of analytics will be done without it. Data warehouse developers should be warned!
With the acquisition of three major BI suites, the BI market is again experiencing a remarkable phase. For a market that has been consolidating for years, it is not something special but, in this particular case, it concerns open source software. This makes it remarkable. The first major question is of a general nature: how can you adopt a product that consists of open source code and a loose, alternative community? This can be achieved by commercializing the support and assigning it to a company, capable to ensure durability.
A decade ago the vast majority of data warehouse systems were hand crafted, but the market for ETL software has steadily grown and the majority of practitioners now use ETL tools in place of hand-coded systems. Does it make sense to hand-code (SQL) a data warehouse today, or is an ETL tool a better choice? What are the 7 biggest benefits of using an ETL tool? We now generally recommend using an ETL tool, but a custom-built approach can still make sense, especially when it is model-driven. This publication summarizes the seven biggest benefits of ETL tools and offers guidance on making the right choice for your situation.
The maximum number of points awarded in our ETL tools & Data Integration Survey to an ETL tool for its ease-of-use was eleven. A maximum of two points was awarded for each of the four attributes, indicated by one or more plus (+) signs, and points were allocated depending on the number of days of training suggested by the vendors (less training required – more points for Ease of Use).If the verdict was negative indicated by one or more minus (-) signs, points were deducted. If, for example, ease of use, WYSIWYG, and logical order earned a plus sign and screen design a minus sign, the tool was awarded two points (one point for each plus sign, minus one point for the minus sign). Since it can take considerable time to improve the usability of a product we have compared the product (where possible) over a three year period. The maximum number of points was 11.
Over more than a decade SAS Institute, a US-based vendor of BI solutions, is a top player in this field. SAS’ roots are at North-Carolina State University and since 1976 the company is managed by its inspiring chairman Dr James (Jim) Goodnight. Today SAS is still a privately held company with an annual turnover of more than 3 billion dollars. A couple of years ago SAS started profiling itself as a vendor of Analytics solutions. Ever since its foundation the company had a strong preference for Data Mining and today it claims the Analytics market as its own. Although the main part of SAS’s turnover emanates from license sales of the SAS BI-platform – which includes ETL, data warehousing, data quality, reporting and analysis – the full focus is on Analytics.
You can still hand-code an extract, transform and load system, but in most cases the self-documentation, structured development path and extensibility of an ETL tool is well worth the cost. Here's a close look at the pros and cons of buying rather than building. The Extract, Transformation, and Load (ETL) system is the most time-consuming and expensive part of building a data warehouse and delivering business intelligence to your user community.
Ab Initio has been around now for a long very time in the ETL market space to make a name for themselves. Their marketing approach appears to be one of mystique: maintain secrecy around the product while allowing some information out about the high-end customers, creating interest because of the tantalizing tidbits they provide. Their website is more typical of an advertising firm with nothing meaningful to say than a technology company. Years later (2015) this is still the case. Their website loads very slowly and is full of flash (no HTML) and there is even no phone number or contact form. Our guess: they are finished.