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
Tag: 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
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
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
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
Al Gulland 
You must be logged in to post a comment.