Qlikview Version 13 Release Date

Qlikview Version 13

Qlikview Version 13 – Business across the globe are evolving at a breathtaking pace and the need to make decisions instantly has also grown multi-fold.

Decision making at levels needs to be a data driven approach backed up with visualations, diagrams, graphics and more traditional management information sources and reports.

To quickly assimilate a huge amount of data, there is growing demand for Business Intelligence tools that can help the Top Executives gain relevant and conscise  snapshot of the complete picture of their organisations based on key performance indicators and critical success factors.

These tools are now an essential part of management to ensure they are in control of and have the pulse of the business.

There is a range BI tools that are available in the market today which help Business in one or other way.

Gartner’s Magic Quadrant has ranked Qlikview in the Leader’s segment in the BI products category.

Qlikview has consistently maintained its ranking for many years which is a good reflection of Qlikview’s popularity among CIO’s and decision makers from most key sectors and domains including Finance, Banking, Insurance/Actuaries, Automobiles, Pharma, FMCG, Retails, CPG, Manufacturing and Utilities.

The current version of Qlikview is version 12 but Qlickview version 13 is likely to be released in late 2020 but this may have been delayed by the Covid19 pandemic.

Qlickview version 13 will likely be a major transformational release of Qlikview.

 

Ease of Learning Qlikview

Qlikview’s popularity can be attributed to the large number of features that it offers.

The Qlik Business Intellgence software suite generally has a low deployment time and its TCO (Total Cost of Ownership) is also lower compared to several other BI tools.

It is easy to get started with Qlikview and it has a low learning curve and is easily understood by the end user.

These key factors account for the success of the Qlikview product as a BI Tool compared to Power BI.

Since most of the companies/organizations are deploying Qlikview to serve their Data Visualization and Business Analysis needs there is huge Demand Supply gap in terms of required manpower with the desired skillset. Qlikview Developers are having a very absorption rate in the Analytics industry which is no more a strong hold of the big IT firms as it was the case earlier.

Every kind of Business be it small, medium or a large enterprise is looking for manpower which can take care of Qlikview setup, prepare dashboards, and prepare business reports for them.

In short, the demand for Qlikview developers is at its peak at the moment and is a promising field for people who want to enter the Data Visualization arena today.

 

Power BI Azure Synapse Analytics

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  using either serverless on-demand or provisioned resources and the ability scale up or down as demand, performance and sizing dictates.

Azure Synapse Analytics combines Azure Data Factory with Azure SQL Data Warehouse.

You can still “buy” Azure Data Factory standalone but Azure SQL Data Warehouse is now Azure Synapse Analytics.

Micrsoft does not include Power BI or Azure Machine Learning into the Azure Synapse Analytics service directly, integrations are built-in at the metadata and user interface levels, so toolsets and functionality of PBI and machibne learning are available to users.

However whilst Power BI and Azure Machine Learning are treated as integration services in the longer run it seems logical that Microsoft will bundle them into Azure Synapse.

Power BI DAX

Power BI DAX – DAX is a grouping of functions, operators, and constants that can be used in a formula and expression or simply to calculate and return one or more values. To summarise PBI DAX helps you create new insights from data already in your model.

The DAX toolset is also embedded in other Microsoft products such as Power Pivot and SSAS Tabular.

 

power bi dax

DAX can be classed as a functional language, which in practice means the executed code set can be contained inside a function.

What is Power BI DAX?

In simple words, DAX is used for data manipulation – to create new data and insights

There are two main calculations you can create using PBI DAX:

  • calculated columns
  • calculated measures

Important DAX Functions in Power BI

  • LOOKUP( )
  • FILTER( ) & CALCULATE( )
  • Nested IF Condition
  • Splitting a String Based on Delimiters
  • Fetching a Particular Letter from a Word
  • Conditional Formatting
  • The ALL Function
  • RELATED(<column>) – This DAX function is designed to help you return a related value from another table in addition to the one you are working on

Useful DAX Functions

The most useful PBI DAX function is probably the CALCULATE function given this is one of the most important and multipurpose functions in DAX Power BI.

The DAX calculate function can simplify complex, multiple calculations easily.

The DAX CALCULATE function assesses an expression in a context that is changed by specific filters. Below is a basic example of the relevant DAX expressions:

CALCULATE(<expression>, <filter1>,<filter2>…)

The benefit of using CALCULATE to filter is that using the newly created calculated measures it will add a layer of context and complexity to your visualizations.

 

DAX Functions Cheat Sheet

A  useful DAX Functions cheat sheet can be found here:

DAX Functions Reference Cheat Sheet

 

 

Power BI File Size Limit

Power BI File Size Limit – the limit on PBI file sizes is just 1GB and with the growth in data volumes this can be quite restrictive for some users.

However, there are ways around the PBI file limit.

Power BI file Size limit

Even using Direct query will not get round the PBI 1GB file size limit since in Direct query there is a limitation of 1M records.

PBI Premium

If you have the budget you can purchase Power BI Premium as an option.

Power BI Premium offers advanced, self-service data preparation that allows every user, from Data Scientist to Business analyst to accelerate the delivery of insights and collaborate with ease – it also removes the restrictions of file sizes limit since you can build models as large as the Power BI Premium dedicated capacity memory can hold.

PBI Premium offers the following functionality:

  • Greater scale and performance
  • Flexibility to license by capacity
  • Unify self-service and enterprise BI
  • Extend on-premises BI with Power BI Report Server
  • Support for data residency by region (Multi-Geo)
  • Share data with anyone without purchasing a per-user license

Power BI Premium is a tenant-level Office 365 subscription available as

  • P SKUs (P1-P5) requiring a monthly or yearly commitment, billed monthly, and includes a license to install Power BI Report Server on-premises.
  • EM SKUs (EM1-EM3) for organizational embedding, requiring a yearly commitment, billed monthly. EM1 and EM2 SKUs are available only through volume licensing plans. You can’t purchase them directly.

Power BI File Size

To get round the Power BI file size limit we recommend you consider Power BI Premium.

 

SAP BusinessObjects BI 4.4

SAP BusinessObjects BI 4.4 is due to be released in Q4 2020 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.

SAP BusinessObjects BI 4.3 beta was relased in Q4 2019 and has met a cautious reception was key users and Business Intelligence Sofware industry watchers.

SAP BusinessObjects BI 4.4

Previous SAP Business Objects Versions can be found here.

 

Which version of SAS do I have?

To find out the SAS version that you are currently using go to:

Help -> About SAS Enterprise Guide, if you select ‘Configuration Details’ you can see your SAS system version.

Another option is to

Select the server in the Servers tree (in the window on the bottom left), and right click->Properties, you will see the SAS version information.

Or run this code to find out which version of SAS do I have

proc setinit;
run;

Latest Version of R Language

R version 3.6.3 (Holding the Windsock) prerelease versions will appear starting Wednesday 2020-02-19. Final release is scheduled for Saturday 2020-02-29.

 

Data Science Masters Programs

Data Science Masters Programs offer the chance to become a qualified Data Scientist.

Data Science is a fast growing discipline that offers highly rewarding careers both from a financial and intellectual standpoint

With the recent huge growth in Data, it is easy to see why there is an increased incidence of people who are interested in gaining a Masters in Data Analytics and to follow a potentially rewarding career path?

There is a great deal of potential when it comes to the Data Science and Data Analytics the people who find themselves in the careers that are related to such often find them to be very fulfilling in terms of intellectual reward and often social merit.

Data Science is a fast growing areas of Business Intelligence software and is an in demand skillset.

Having a Data Science Masters degree will certainly help in job hunting in this growing area.

Demand for skilled data scientists continues to be sky-high, with IBM recently predicting that there will be a 28% increase in the number of employed data scientists in the next two years.

Some well known acacdmic instutions that offer Data Science courses are:

There are some free Data Science courses, for example EdX offer a Data Science Essentials course:

This course is provided by Microsoft and forms part of their Professional Program Certificate in Data Science, although it can also be taken as a stand-alone course through EdX. Students are expected to have an “introductory” knowledge of R or Python – the two most popular languages for data science programming at the moment. Subjects covered include probability and statistics, data exploration, visualization, and an introduction to machine learning, using the Microsoft Azure framework. Although all of the course material is free, students can pay ($90 in this case) for an official certificate on completion.

SQL2021

SQL2021 Microsoft Release Date – the planned date for SQL2021 is likely due summer 2021 but there is no formal confirmatiom from Microsoft.

BI Software SQL 2021 Server consulting has been serving the greater Detroit, Michigan area for more than a decade. We provide SQL Server consulting and SQL Server contracting for Detroit, Michigan and all surrounding areas. We specialize in SQL Server performance tuning, remote SQL Server support and SQL Server database troubleshooting and SQL Server monitoring.

SQL2021

Following the planned release of SQL2020.

SQL Server Consulting for Detroit, Michigan

BI Software SQL Server consulting has been serving the greater Detroit, Michigan area for more than a decade. We provide SQL Server consulting and SQL Server contracting for all surrounding areas. We specialize in SQL Server performance tuning, remote SQL Server support and SQL Server database troubleshooting and SQL Server monitoring.

SQL2021

Click here for a list of Microsoft SQL 2021 Server Consulting Services

SQL 2021 Server  provides world-class SQL Server support consulting that is customized according to your needs. Our SQL Server consulting is done by industry experts and we offer complete SQL Server support and SQL Server consulting as well as SQL Server contractor services at affordable prices for London and all surrounding areas.

SQL2021 Costs & Pricing

 

SQL 2020 Release Date

SQL 2020 will be released in late 2020 probably November / December 2020.

Also named SQL2020 and SQL Server 16.0  (not to be confused with SQL Server 2016!)

The latest verison SQL 2019 was officially released in November 2019 and contained a range of new features covering:

  • Big Data Clusters and PolyBase – this was a major enhacements and is a major enhancement to PolyBase that allows you to connect SQL Server to Oracle, MongoDB and Teradata natively
  • Intelligent Query Processing- like a “black box” recorder that enables a database administrator to very quickly isolate the root cause of a performance issue.
  • Smarter Monitoring – resolves issues many users had with query store
  • Optimized Insert Performance – resolves bottleneck and performance constraints when trying to insert sequential records into a table at very high volume
  • Better, faster database recovery – resolves one of those key NFR’s RTO
  • On premise – Microsoft appears to still be very committed to building on premise SQL Server so this is not going away any time soon

Looking forward it is worth looking at some of the key features that Microsoft are likely to include in the SQL 2020 Release date.

The latest incarnation of Microsoft hugely popular BI, database and analytics toolset is likely to further build on the foundations laid in SQL 2019 and offer improved integration with widely used open source Data Science toolsets like R and Python.

We also widely expect the further embedding of more Azure Managed instance functionality and a widening of the Data Science, Artificial Intelligence, Machine Learning, Robotics and Predictive analytics capabilities into SQL2020.

It’s also anticipated that Power BI will get a major revamp with probably the introduction of improved data governance and stewardship capabilities to ensure it keeps pace with the competition now that Power BI

SQL 2020

An area that is ripe for exploitation by the main Business Intelligence vendors is Data Quality. This is an area that vendors increasingly provide expensive add on products for but there is a keen desire amongst many organisations for more embedded mainstream offerings in this area.

Wider use of Master Data Management tools and better Dev Ops integration with Azure

Data Quality is one key area that Microsoft have very few offerings to users in comparison with widely used Data Quality tools.

Overall Microsoft will likely continue to build on the success of SQL2019, widen and deepen the plaform.