OBIEE Latest Version

OBIEE Latest version – Oracle BI Latest Version is Oracle Business Intelligence Enterprise Edition 12c Release 12.2.1.4.0

OBIEE

Oracle Business Intelligence Enterprise Edition 12c documentation is part of Oracle® Fusion Middleware Online Documentation Library 12c Release 1 (12.2.1.2.0) Oracle BI is often known as OBIEE

OBIEE Latest Version

Oracle BI

Oracle BI consists of the following Business Intelligence software components:

  • BI Server: common enterprise business model and abstraction layer
  • BI Answers: ad-hoc query and reporting
  • BI Interactive Dashboards: highly interactive dashboards
  • BI Delivers: proactive business activity monitoring and alerting
  • BI Publisher: enterprise reporting and distribution of pixel-perfect reports
  • Oracle Real-Time Decision Server: predictive analytics for adaptive decision management
  • Oracle Scorecard and Strategy Management: strategic goal setting and tracking
  • Oracle Data Visualization: self-service visual analytics

Performance Tiles.

A performance tile displays a single aggregate measure in a visually prominent manner. It is an ideal way of displaying and calling out attention to a metric or set of metrics of interest on a dashboard. A user can select from a list of options to customize the performance tile, including applying a style, size, and conditional formats.

Waterfall.

A waterfall graph lets a user view how each value in a series incrementally affects the whole by showing how an initial price is affected by various discounts and options. This is the preferred visualization in a number of applications including pricing analysis, where it aids in identifying pricing leakages.

Map Views.

Map Views support the ability to format a line to vary its color based on one measure, but to also vary its thickness by a second measure. For example, an airline route could be color coded based on the number of flights flown, and its thickness based on the average revenue per seat.

100 Percent Stacked Chart.

A subtype, 100% Stacked, has been added to both the bar and area graphs. This graph shows values as percentages, and because it normalizes the data between values of 0 and 100 percent, makes it comparison of values easier across series and groups.

Analyses often have sparse data that includes null rows and/or columns. A new option, available at the analysis level, allows users to display this data. It can be overridden at the view level, providing flexibility and convenience to designers to control how data is displayed for different views in the same analysis.

Breadcrumbs.

As the name suggests, breadcrumbs are an aid to navigation, and help users understand not only their present location within an application but also the path they took within the application to arrive at their current location. This navigational aid is displayed at the bottom of the page, and a user can click on any section of the breadcrumb.

Trellis View Actions.

Action links are a powerful way to provide contextual functionality to users within visualizations as well as dashboards. The high-density Trellis Views that are available in OBIEE now support action links for both Simple and Advanced Trellis views. In addition, action links are available in legend and axis labels in Trellis views. •

Freeze Headers.

A new option – “Freeze Column” – for tables, pivots, and Advanced Trellis views, keeps the headers positioned at the top of the view, even as a user scrolls down the dataset. This feature can be switched on or off for a particular view from the properties panel of the view. In the Oracle BI Mobile HD app, this is available via a twofinger swipe gesture.

Oracle Financial Close and Reporting

Maximize Views. When working with data-dense views, or where users may want to view the data in a full-screen mode on their tablet, they can do so by double-tapping the view.

Support for new visualizations.

New visualizations added in this release, like the Performance Tile, 100 percent stacked graphs, Waterfall, etc… are all available in the mobile app. Furthermore, users can also use touch interactions like tap, swipe, double-tap, tap-and-hold. For example, to scroll through the rows of a table, pivot, or trellis view where the headers have been fixed, users can use the single-finger drag gesture.

Oracle BI Publisher mobile enhancements.

Users can open BI Publisher reports and view them in dashboards. BI Publisher content is fully interactive, with support for prompts. Additionally, users can save BI Publisher content for local (offline) consumption.

OBIEE Security Toolkit.

The Oracle BI Mobile Security Toolkit provides a solution for Oracle BI Mobile customers who require higher levels of mobile device security than is provided by the mobile operating systems or through the Oracle BI mobile application itself. It is a repackaged, unsigned and uncertified version of the Oracle BI Mobile HD application that will allow a customer to combine the application with their chosen third party Mobile Device Management (MDM) security solution, sign it with their corporate signature and deliver it as part of their chosen mobile application delivery mechanism.

OBIEE Latest Version

The latest version of OBIEE is Release 12.2.1.4.0 made available in March 2020.

Power BI Review Disadvantages Advantages Pros Cons

Power BI Review – Power BI is a business intelligence and analytics tool provided by Microsoft. It provides interactive visualisations with self-service business intelligence capabilities.

Microsoft Power BI is a solid and proven BI solution that has a large and growing user base and solid support ecosystem both online and from reputable Microsoft partners and vendors.

Most organisations find they have a lot of data but very little insights and to that end Power BI is a rich and fully featured powerful cloud-based service that helps business users, Management Information owners and data scientists visualise and share insights from their organisations’ data.

Power BI offers the capability to access data from more than 40 different data sources and databases covering everything from SQL2019 to Hadoop and Mongo, Azure and even Spark based architectures.

power bi review

There are two ways of accessing Power BI:

1. Via windows desktop (mainly targeted at developers)
2. Via a cut-down browser version (mainly targeted at Execs and report consumers)

To undertake real data manipulation, analysis and development you will need the Windows version of Power BI.

Microsoft is developing Power BI at a rapid rate and new versions and functionality are being released to keep the product ahead of the game.

There is a wealth of online reporting and visualisation templates that can be used to quickly generate eye catching graphics, maps and data visualisations. These are very easy to use and help non technical users get valuable reports and MI to market quickly. This is one of the key strengths of Power BI over and above other market leaders in this space such as Tableau and Spotfire.

Power BI is easy to use and given it’s vast corporate user base from it’s Microsoft SQL heritage is a real Enterprise Business Intelligence tool.

Power BI also serves well as a Mobile BI tool – ideal for presenting information to one the move senior execs via a range of dashboards and easy to drill down visualisations.

Power BI Pricing

Power BI pricing falls into two brackets; free and paid for.

For the Pro version you can use this for as little as £10 a month with a 10GB data allowance – this is plenty considering that most users will never fall into the Big Data brackets.

Power BI Review

Usability ★ ★ ★ ★ ✰
Cost        ★ ★ ★ ★ ★
Support  ★ ★ ★ ★ ✰
Overall   ★ ★ ★ ★ ★

Power BI Pros and Cons

Power BI Advantages

One major advantage of Power BI is the pricing (free) and the fact that it is a cloud-based service that is easy to implement and requires minimal IT engineering or involvement. The only requirement is to sign up and download the technology to start gaining insight and evaluating organisational business data.

Power BI Disadvantages

One of the major limitation of Power BI is that it doesn’t have the ability to publish reports with all associated data. This means some information can be left out of visualisations.

Other Disadvantages of Power BI are:

  • Very few data sources
  • 1GB file limit for non Premium versions

Qlikview Version – Latest versions updates

Qlikview Latest Version

The latest version Qlikview is Qlikview version Version 12.40 (April 2019) – released April 2019.

The final service release of Qlikview version 11 is QlikView 11.20 SR17 and is the end of the line for Qlikview 11. Users will need to upgrade to Version 12 to maintain security and functionality release

Read our Qlikview Review here.

Qlikview Version History

QlikView BI Software

Previous versions and releases of Qlikview can also be found in the list below

  • version 12.10 Service Release 6 – released 15th May 2017.
  • version 12.10 Service Release 5 – released 2nd May 2017.
  • version 12.10 Service Release 4 – released 27th March  2017
  •  version 12.10 Service Release 3 – released 20th February  2017
  •  version 12.10 Service Release 2 – released 26th January  2017
  •  version 12.10 Service Release 1 – released 7th December 2016
      • Improved QlikView Server clustering and scaling. This leads to significantly improved response times under high load and improved ramp-up capacity. It also allows for more nodes and concurrent users.
      • Unbalanced QlikView Server clusters: a QlikView Server cluster can now manage nodes of different sizes regarding CPU, RAM, and number of cores.
      • Improved caching in QlikView AccessPoint, which significantly decreases response times when scaling to a large number of documents and/or users.
      • Introduction of publisher groups and regular and dedicated tasks for load balancing purposes.
      • New task status added: Queued. A task will be queued if it is not able to start due to overload.
      • Publisher high-load support: QlikView 12.10 optimizes the inter-service communication to improve stability and performance in cases with many concurrent tasks and high frequency changes.
      • QlikView Distribution Service (QDS) now allows running tasks to finish before shutting down the service.
      • QlikView can now be configured for single sign-on (SSO) access to SAP HANA.
      • Expanded QMS API functionality, with additional methods and new API calls.

      In QlikView 12.10, support has been added for:

      • Software and applications: MS Office 2016, MS SharePoint 2016, MS SQL Server 2016. MS Windows Server 2016.
      • Browser/web: Internet Explorer 11 and ActiveX Plugin for MS Windows 10.
      • Operating system: iOS10.
  •  version 11.2 SR17 Dec 2013
  •  version 11.2 SR5 Dec 2013
  •  version 9 SR 3 released Feb 2010
  •  version 9 SR 1 released 23rd September 2009
  • version 9 released SR4 October 31st 2013

Qlikview Versions

Tableau Version 11 Release Date

Tableau Version 11 Release Date – coming soon in 2017 with a range of key new features and functionality from the Gartner Magic Quadrant BI 2017 leader.

We look ahead to see the likely new features and range of functionality planned for Tableau Version 11.

Tableau’s mission statement is “to help people see and understand their data, because we know data can empower people to achieve great things. In short, we work toward our mission so you can achieve yours.”

tableau version 11

Tableau Version 11

Improved Data Governance

Tableau see data governance and being a key functionality item in an Enterprise Business Intelligence tool and they aim to achieve this via “certified data source” functionality. This is quite a radical idea and I’m sure will be hugely popular within IT departments who are still often the gateway users and data stewards of most Enterprise level data sets.

Hyper Data Engine

Hyper enables fast analysis on billions of records and near real-time data updates.

Hyper is designed to simultaneously process transactional and analytical queries without impacting performance resulting in the ability to scale up and perform sophisticated analysis on large data sets with.

Machine Learning Algorithm Libraries

One of the strengths of Data Science toolsets such as python is the diverse and hugely useful asset library of functions.

Many Tableau users would like to see Tableau adopting this type of approach with prebuilt templates and recommended machine learning algorithms

Improved Data Driven Alerting & Metrics

Users miss critical insights every second even with the best data and Business Intelligence tools.  There are so many dashboards and reports that they don’t know where to focus their attention. For example

The ability of software to notify you when something breaks/breaches a predefined threshold etc. (aka automated alerts/exception reports). Data Driven alerts, where someone gets a report/message sent to them if some event or threshold in the database is triggered/breached. eg. “Send me a Risk report per product/branch/Loan Officer if the PAR30 for a branch exceeds 10% for  2 consecutive days” etc.

 

SQL 2017 Server – Microsoft Release Linux & AI Server with R Python Data Science Tools

SQL 2017 – Microsoft announced in April 2017 that the next version of SQL Server RDBMS and Business Intelligence software is officially named SQL Server 2017 and made a new Community Technology Preview (CTP) available for download.

SQL 2017 BI Business Intelligence Artificial

SQL 2017 – referred to as “SQL Server vNext”  has been released in a series of CTPs since late last year.

The latest SQL Server 2017 Community Technology Preview 2.0 is the first production-quality preview of the upcoming offering, available for both Windows and Linux.

“In this preview, we added a number of new capabilities, including the ability to run advanced analytics using Python in a parallelized and highly scalable way, the ability to store and analyse graph data, and other capabilities that help you manage SQL Server for high performance and up-time, including the Adaptive Query Processing family of intelligent database features and resumable online indexing,” the SQL Server team said in a blog post on April 17th 2017.

Microsoft have developed a range of new functionality for SQL 2017 mainly focused around the following key areas:

SQL 2017 – Industry-leading performance

Perform queries up to 100x faster than disk with in-memory columnstore, and transactions up to 30x faster with in-memory OLTP.

SQL 2017 – Improved Security

Use layers of protection, including innovative features such as encryption at rest and in motion, all from the least vulnerable database over the last seven years.

Data Science Microsoft SQL 2017 BI – Real-time intelligence

Gain trans-formative insights with up to 1 million predictions per second using built-in Python and R integration, and get end-to-end mobile BI on any platform. This is a key area of extension into the fast growing Data Science, Predictive Analytics and Big Data arenas.

The inclusion of R and Python is a bonus for those organisation that have invested heavily in a Microsoft estate but also need to cater for growing demand for R Language and Python Data Science tool-sets.

Application Extensibility, anywhere

Build modern applications using any data, any language, any platform—on-premises and in the cloud.

Download SQL 2017

SQL 2017 is available for download here

SAS Latest Version History Release Dates BI

SAS Version – SAS  BI (Statistical Analysis System) is a software suite developed by SAS Institute for advanced analytics, multivariate analyses, business intelligence, data management, and predictive analytics.

SAS Latest Version

SAS Versions

The SAS Latest version is 9.4 platform and key features are high-performance analytics, further ability to deploy in cloud environments, and standardised data management, governance and control.

The key features of SAS 9.4 (the latest SAS Version) are:

  • SAS 9.4 provides a simplified architecture, increased security, and more deployment options.
  • For SAS administrators, SAS 9.4 provides new management capabilities and administration tools. n For data administrators, the integration of the DataFlux products creates a more complete data management solution. Also, new programming languages enable you to manipulate your data and access relational data from various data sources. New programming languages enable you to update data on the database and access relational data from various sources.
  • SAS programmers can benefit from high-performance analytics enable you to quickly analyse large amounts of data. Multi-threading capabilities have also been added so that you can perform analyses on single-machine deployments. SAS Studio provides a web browser-based interface for SAS programmers to write, edit, and submit SAS code. n
  • For the user community, SAS 9.4 extends the options for mobile access and self-service options for data access, reporting, and exploration.

SAS Windows 10

Unfortunately SAS 9.4 requires an operating system upgrade to 64-bit Windows for example Windows 10.

Version History

The version history is detailed below and this highlights the major releases and versions.

VersionSAS VersionSAS Version ReleaseSAS Analytical Products Version
Recent9.4m416-Nov-1614.2
Recent9.4m314-Jul-1514.1
Recent9.4m205-Aug-1413.2
Recent9.4m115-Dec-1313.1
Recent9.410-Jul-1312.3
Old9.3m229-Aug-1212.1
Old9.312-Jul-119.3
Old9.2m201-Apr-109.22
Ancient9.201-Mar-089.2
Ancient9.1.301-Aug-04
Ancient9.101-Dec-03
Ancient901-Oct-02
Ancient8.201-Mar-01
Ancient8.101-Jul-00
Ancient801-Nov-99

 

Business Intelligence Benefits – what is your BI Business Case?

 

Business Intelligence Benefits

Business Intelligence Benefits – the use of BI can lead to a number of beneficial outcomes for organisations, some of these could be sumarised as:

  • Providing insights and knowledge into large and complex data sets
  • Ability for improved Management Information and decision intelligence making
  • Allows the organisation to interrogate data that was previously too granular or large
  • Enables the organisation to make improvements to data quality as a result of the improved visibility of the data sets
  • Business Intelligence Benefits can be tangible and financial such as improved sales revenue, reduced operating costs all deriving from better information#

Business Intelligence Benefits

  • Business Intelligence can also in a wider sense reduce Total Cost of Ownership of IT systems by aggregating data in a data warehouse that might otherwise have been stored in a non aggregated (and larger data size)
  • Business Intelligence Benefits can derive from the techniques required to manage and control Business Intelligence such as improved data governance, data stewardship and control.
  • Benefits can be the ability to ensure relevant data compliance with regulatory areas such as GDPR compliance
  • BI lower can lower costs by dramatically reducing time employees spend on collecting data, creating reports, distribution, collaboration, and financial planning.
  • Business Intelligence software can improve productivity by enabling employees to focus on decision making rather than report production
  • BI can help elimiate manual tools such as Excel that are often prone to error and unreliable
  • Improved Organisational Effectiveness
  • Single version of the truth: single, centralised available version of the truth
  • Future Capability: BI can reduce costs and improve efficiency in other systems
  • Reduce resources and labour costs used for the collation, analysis and distribution of vital business data
  • Be aware of emerging crises: quality data = improved decision making
  • Improved Data Quality & Security Data Quality – BI can provide visibility across immense databases enabling proactive identification and correction of data issues.
  • Eliminate guesswork: Business intelligence can provide more accurate historical data, real-time updates, synthesis between departmental data stores, forecasting and trending; eliminating the need to guesstimate
  • Storage cost avoidance – by leveraging BI solutions as an “Operational Data Store” this can enable space savings to be gained from copies of non-production databases
  • reporting self sufficiency by eliminating the dependency on IT and other areas allowing the business more timely access to vital reports
    improved understanding of the underlying trends hidden in large data sets enabling the organisation to seize upon un-recognized business opportunities, sooner and with greater return
  • potential opportunities to syndicate and license data due to the easier availabity in understanble formats
  • provision of a single, consolidated reporting platform across an onrganisation that can be controlled and managed centrally and above all which is trusted.

BI Benefits

As shown in the diagram below, data stored in disparate systems can be drawn out to populate a BI system, where using specialised architecture and an intuitive presentation layer, the user would be able to design and draw out underlying trends, hot-spots, KPIs and other valuable aspects that lie hidden in the data itself. This is a key benefit of Business Intelligence solutions.

Business Intelligence Example

BI Tools Market Share 2017

BI Tools Market Share 2017 – the BI market continues to grow as companies invest in data related technoligies to gain competitive advantage.

The BI tools market is forecast to be worth USD 13 billion by end of 2022 driven as usual by the explosion in data and need for data related insights.

Microsoft seems to be the main mover up 1% in terms of market share with SAS down 1%.

BI Tools Market Share 2017

BI VendorBI Tools Market Share
SAP  Business Objects10%
SAS8%
IBM8%
Oracle7%
Microsoft6%
Qlik5%
Tableau5%
Teradata4%
MicrosStrategy4%
Informatica1%
Others42%

 

What is R Language in Data Science?

R language in Data Science is a programming language and software environment for statistical computing and graphics.

The R language is widely used among statisticians and data miners for developing statistical software and data analysis.

R is a GNU package  which is similar to the S language and environment which was developed at Bell Laboratories (formerly AT&T, now Lucent Technologies) by John Chambers and colleagues.

R in Data Science

R’s a great choice for basic data analysis and visualization work and is widely used by Data Scientists – the other competing data science language is Python.

R is considered the more “authentic” data science and statistical programming language compared to Python – it has a greater depth of statistical functionality.

Why use R?

R provides a powerful, extensible environment, and as noted above, it has a wide range of statistics and data visualization capabilities.

R is easy to install and use, and it’s free – downloadable from the CRAN R project website.

R in Microsoft

R is now embedded in Microsoft SQL 2016 and Azure and hence is growing in popularity in a more corporate environment where MS SQL is widely used.

R’s power, flexibility and price (it is free) likely contribute to its popularity among researchers across scientific disciplines. Users around the world are consistently writing new programs, called packages, to carry out data analytic tasks that range from very simple to exceedingly complex. If there is a statistical method, somebody has written an R program to carry it out.

With R Server being able to run both on-premises and in the cloud on Azure Virtual Machines, you can model on-premises and score in the cloud without the need for rewrites.

Microsoft R Server is built to handle massive data sizes and computation on hundreds of nodes. Its big-data capable architecture includes ScaleR algorithms optimised for fast parallel execution, DistributedR parallel computing framework for managing compute resources, and ConnectR for versatile connections to data sources.