Business Intelligence, How To, Statistical Analysis, Web Intelligence

Correlation Analysis and SAP Web Intelligence

Correlation Analysis is a well-known analytical technique used to test if there is a relation between two quantities, for example did a marketing campaign lead to an increase in sales or as the price of one stock rises and falls does the price of another stock also rise or fall in synch. Determining if there… Continue reading Correlation Analysis and SAP Web Intelligence

How To, Statistical Analysis, Web Intelligence

Calculating Moving Averages in Web Intelligence

Introduction The previous article looked at what moving averages are and how to calculate them. This article now looks at how to implement these in Web Intelligence. The formula used here are compatible with the XIr3 version of SAP BOE however some formula may work in previous versions if available. We'll begin by looking at… Continue reading Calculating Moving Averages in Web Intelligence

How To, Statistical Analysis, Web Intelligence

Creating Histograms in Web Intelligence with Adjustable Bucket Sizes

Introduction This article looks at how to create a histogram in Web Intelligence and makes use of input controls to allow the user to automatically adjust the histogram's bucket size. Histograms is a charting technique used to analyse the distribution of a set of data for example a business analyst may use a histogram to… Continue reading Creating Histograms in Web Intelligence with Adjustable Bucket Sizes

How To, SQL Server, Statistical Analysis, Web Intelligence

Analysis of Joiners and Leavers

Introduction This article looks at different techniques to analyse joiners and leavers using Web Intelligence. Analysing joiners and leavers is where you need to understand the change in membership of a set, for example, products moving in and out of your top 10 sales. If you are able to identify which key products that are… Continue reading Analysis of Joiners and Leavers

How To, Statistical Analysis, Web Intelligence

Linear Regression Analysis and Web Intelligence

This article looks at how to do linear regression analysis in Web Intelligence. Linear regression is a statistical technique for analysing data in order to obtain a measure of correlation between two variables where the relationship between the variables is expected to be linear. Web Intelligence does not contain a full set of formula for… Continue reading Linear Regression Analysis and Web Intelligence

How To, Web Intelligence

Using Local Data Sources in Web Intelligence

This article looks at how to use a local data source in a Web Intelligence report and then combine that data with data retrieved from a data warehouse. Business Scenario The worked example described here is to create a simple dashboard style report of sales data. We then highlight the sales figures using a typical… Continue reading Using Local Data Sources in Web Intelligence

How To, Statistical Analysis, Web Intelligence

When analysis is better using Web Intelligence than Excel

This article compares data analysis using Web Intelligence to the same workflow using Microsoft Excel and for the given scenario demonstrates why using Web Intelligence is quicker, easier and less error prone. The objective here is not to show that in all cases Web Intelligence is better than Excel rather to highlight that there are… Continue reading When analysis is better using Web Intelligence than Excel