Business Intelligence Software

Business Intelligence Software, Tools and Supplier Vendors

Business Intelligence Software

SQL2022 Release Date – Are we nearing the end of the road for SQL Server?

By

SQL2022 Release Date is currently scheduled for a release in mid 2022.

Microsoft typically does not announce any actual release dates until very close to the release.

The current version is Microsoft SQL Server 2019, released November 4, 2019. The RTM version is 15.0.

The lack of a clear roadmap for Microsoft SQL Server is a bit disconcerting given the huge user base of this Enterprise solution.

Many key users see Microsoft pushing hard on on all things Azure and it’s clear that the subscription model via the Cloud is the future.

However for some users Azure can be painfully expensive is the design is not correct or optimised.

SQL Server will be supported until the latter end of the decade but having seen what happened to Office and so many other Microsoft products some users are wondering whether Azure is the writing on the wall for SQL Server.

How soon will it be before Microsoft gives us the ultimatum of migrating to Azure or else?

sql2022 release date

Typically before a major release of a critical product like SQL, Microsoft normally deliver a Community Technology Preview (CTP).

The CTP will precede the SQL2022 release date.

The CTP is normally issued to major systems integrators and large users as a “Alpha” style release.

Given the elapsed three years since the last release a number of new features are expected to be available with the SQL2022 release date

  • Accelerated Database Recovery (ADR)
  • Polybase – with SQL Server 2022, Polybase was expanded support Oracle, Teradata, MongoDb and more.
  • Key features available in Azure
  • Features currently working flawlessly in Azure will be migrated down to SQL Server 2022. And some of the slightly buggy features will appear in SQL Server 2021/2022 in a CU or SP once they get ironed out.

As with most Microsoft products, Microsoft provides mainstream support for a product for 5 years after its initial release. This means that for the first 5 years you may see new smaller features or enhancements added to the product along with any bug fixes and security patches. After this mainstream support ends you will usually get another 5 years of extended support at which time you can only expect bug fixes and security patches.

Business Objects BI 4.4

By

Business Objects (from SAP) BI 4.4 is due to be released in Q1 2022 according to inside sources at SAP.

The next major release of SAP BO is expected to contain a number of major functional enhancements and improvements.

Key new features are expected to be increased analytics and visualations and improved user interface.

Business Objects

SAP Business Objects BI 4.3 beta was relased in Q4 2019.

The new version has met a cautious reception was key users and Business Intelligence Sofware industry watchers.

SAP Business Objects BI 4.4 was relased in June 2020 was welcomed by key users and Business Intelligence Sofware industry experts.

Business Objects

Previous SAP Business Objects Versions can be found here.

The Advantanges and Disadvantages of SAP BO can be summarsed as:

Advantages of SAP BO

  • Ingest data from multiple areas of the business and use them to generate easy to understand reports.
  • Report scheduling is simple and efficient allowing the team to run reports at a variety of different times to suit the stakeholder’s needs.
  • The metalayer takes away some of the complexities of other programs, allowing the end user to interact with the program in a clean and efficient way.

Disadvantages of SAP BO

  • Users have indicated challenges inking up with data in  web portals. resulting in additional, unplanned development time,
  • Older versions had functions which have now been removed, or replaced with less effecient functions. For example the HTML output option.

SAP BO is a leading edge Business Intelligence tool for large and mid size organisatiosn that probably already use SAP as their main ERP solution.

Best Business Intelligence Software 2021

By

Best Business Intelligence Software 2021 Vendors and Comparisons – the BI Business Intelligence Software market is a crowded and confusing marketplace.

It can be difficult to navigate the vendor offerings, functionality and pricing and compare these to guide the purchase decision making process.

Best Business Intelligence Software 2021

The Best Business Intelligence Software 2021 based on User and Analyst feedback is :

  1. Power BI
  2. MicroStrategy
  3. Spotfire
  4. SAS Visual Analytics.
  5. Oracle Business Intelligence (OBIEE)
  6. Sisense.
  7. Qlikview
  8. Tableau
  9. Yellowfin BI
  10. Cognos

Microsoft Power BI is the rising challenger to some of the more established vendors.

Power BI accounts for almost 60% of new Business Intelligence Software purchased.

Power BI Azure Synapse Analytics

By

Power BI is a well known and widely used Business Intelligence software tool.

It is widely used often because many users have Power BI because they’re Windows users and Power BI comes with Windows. It’s probably fair to say that users of the Power BI platform often don’t always fully assess the BI tools market since they mostly have what they need in Power BI

Despite Microsoft’s ability to update the Power BI platform on an almost constant basis, its capabilities aren’t always viewed as the most innovative on the market.

This could be about to change with Microsofts introduction of Power BI Azure Synapse Analytics.

Power BI Azure Synapse Analytics aims to integrate data warehousing and data analytics in a single BI cloud service that provides the functionality and tooling from both Microsoft Power BI and Azure Machine Learning.

Azure Synapse Analytics

ASA can be summarised as the next step in the evolution of Azure SQL Data Warehouse as the diagram below illustrates

Power BI Azure Synapse Analytics

What is Azure Synapse Analytics?

Azure Synapse is a limitless analytics service from Microsoft that brings together enterprise data warehousing and Big Data analytics. It gives you the freedom to query data on

Power BI (PBI) WordPress MYSQL Analytics

By

PBI for WordPress – we offer consultancy services to integrate Microsoft Power BI to WordPress / MYSQL databases.

This can be used to provide analytics on all items in your WordPress database, to extract to a report, Microsoft Excel, CSV or Power BI Dashboard.

Examples might be data captured via Gravity Forms, WPForms, Contact Form 7,Jetpack Form, Caldera Forms, Ninja Forms that is contained in your WordPress website database.

Wordpress Power BI

 

Please complete the form below to find out more about our PBI for WordPress Consultancy services:

  • This field is for validation purposes and should be left unchanged.

WordPress Analytics

We offer a range of WordPress Analytics solutions and consultancy, from analysing web visitors and site traffic to more detailed analysis of the contents in the WordPress MYSQL database.