Business Intelligence, Statistical Analysis

Are You A Data Scientist?

FICO, company that provides analytics and decision making services—including credit scoring, have published a new infographic summarising the key skills and attributes required by a Data Scientist. Of course there are skills in statistics, data analysis and application to real world business problems but what other skills should a Data Scientist have? Check out the… Continue reading Are You A Data Scientist?

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

Business Intelligence, Statistical Analysis

Getting Started with Statistics – a key part of Business Intelligence

A key part of our work in Business Intelligence is the analysis of data and the branch of mathematics that we employ for this is statistics. We analyse data to understand our business better and when analysing the data our main objective is to pick out the reality from the background noise. For example when… Continue reading Getting Started with Statistics – a key part of Business Intelligence

Statistical Analysis

Overview of Moving Averages

Introduction A moving average is a simple technique for smoothing random data. Most often we find moving averages to analyse movement of stock prices but we also see them in other areas of business and data analysis. This is the first part of a series of two articles. This article discusses what are moving averages… Continue reading Overview of Moving Averages

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