# Questions tagged [business-intelligence]

business intelligence is statistics and data analysis of business information.

78 questions
Filter by
Sorted by
Tagged with
24 views

### Applying ML to Diagnostic Analytics on Financial Report

Background: We (a team in the IT department) are currently helping the financial team solve their problem, by automating their tasks. The task is this: they review the financial report monthly and ...
30 views

### Predict the probability a customer will return

I have a table of historical customer data from a store. Not being allowed to ask any further details on the data provided, I have been told to (1) Predict which customers will return to the store ...
19 views

### How to account for different time periods when trying to calculate the effectiveness of loyalty program

I have the following situation: I would be interested to statistically determine whether or not there are differences between customers who are part of a loyalty program vs. those who are not part of ...
19 views

### Given sales data from multiple shops, what is the best way to determine profitability of a shop with inconsistent sales times

I have a dataset of sales data (individual sales from multiple shops in an area, date sale was made on given) from multiple shops (denoted by the field shop_number). I calculated a field for profit (...
11 views

### Regression with Dummy Variables method with a linear trend-cycle component

We have a homework problem dealing with regression and dummy variables using SPSS. Our question is to use dummy variables with linear trend-cycle, and than later try an non-linear trend cycle (we are ...
7 views

### Test difference in proportions between values of same polytomous variable

What is the right test to compare sample proportions between two values of the same polytomous variable? Basically I'm searching for the right search term. E.g. consider a survey question, Q1. What ...
11 views

### correct cycle duration to minimize sampling bias due to agents

Problem Statement: We are testing two different routing strategies in a call center environment (strategy A and B). The purpose is to figure out which strategy results in more revenue (revenue per ...
21 views

### Forecasting new product sales - pre launch

Product X is due to launch in 6 months time and I am looking for a method to estimate what the sales of this product could likely be in 3 years time. Product X belongs to a category of products for ...
18 views

### Model behind Google's “Popular Times and Busyness Indicator”

Google has recently published an article explaining how their popular "Busyness Indicator" works. For instance, Google maps location information as well as search queries are mentioned as ...
14 views

### How to compare and evaluate different business concepts?

Don't ask me how exactly I came up with this question but I wonder about the following: Assume you want to compare different offers in how requested (and/or how profitable) they are. In addition, due ...
32 views

### How to properly calculate weighted average when the data is in form of ratio

I had a question related to calculating weighted average, on data example below given definition : Column C = Product Supply Column D = Product Demand Column E = Supply / Demand Column F = Demand ...
236 views

### Regression with same values for dependent variables?

I am performing a regression task on a relatively small dataset (4000 observations). These 4000 observations are grouped in such a way, that if I look at the dependent variable, there are only about ...
40 views

### Can I model website conversion as a binomial distribution?

Suppose I have a website where people buy something and I've measured the conversion (calculated as buyers / visitors), and it's 0.05. I want to know what the probabilities are for the different ...
37 views

### Statistical Significance: Can we apply the concept of Statistical Significance when reading the results of AI driven marketing?

Really need to know this from someone who really understands statistical significance. Can we apply Statistical Significance when reading the results of AI driven marketing? Challenge: Large ...
33 views

### Advice on how to answer the “how large of a sample size do we need to show results” question to non-quant people in a business setting

Not sure if this question is too vague, but I'll give it a shot. I've received many questions from non-quantitative colleagues along the lines of "what sample size do we need to trust these ...
13 views

### Customer Retention Rate for a subscription business selling products with multiple contract durations

I have a question related to the standard metric used to evaluate subscription model businesses, aka user retention. We define user retention as the percentage of customers that keep their ...
34 views

### How I generate more data to do analyses?

I have a datasets for 3 months, its about a vehicle movement and the gas consumption. The vehicle should refill gas after 750 km driving. But the data I have is not enough. The first month I have only ...
12 views

### Using a regression beta coefficient as a KPI?

I have a complicated mixed effects regression that predicts the log_price. One of the regression parameters estimates the Beta_1, difference in log price between group A and group B. Group A is ...
41 views

### Practical use of median?

Someone recently asked me the business use of various measures of central tendencies. Although the usage of mean and mode is intuitive and easily seen, I could not think of one intuitive use of median....
1k views

### When is NHST appropriate in business?

Null hypothesis significance testing seems to be widely used in business. The most obvious example is A/B Testing, where a business will perform a test comparing two variants of some aspect of their ...
109 views

### Calculate CLV / TLV for contractual Business

I am desperately trying to apply a CLV/TLV (Customer Lifetime Value) algorithm to my dataset in R. Unfortunately, the more I read about it, the less confident I get if all makes sense. =) Do you have ...
230 views

### Calculating growth rate from a baseline of exactly zero

Say we have a series of month-on-month figures like the following, and we want to get the growth rate between the two periods: ...
21 views

### Drawing a causal conclusion about a change in production code

We had a change in our production code which we did not perform A/B test for. A few days after the product is changed, we have been seeing a significant drop in our quality metrics. Is there any way ...
162 views

### Survival Analysis on conversion rates

I'm trying to implement survival analysis on conversion rates for a free trial product we provide. In general, I understand the applications on survival analysis along with dealing with right censored ...
29 views

### What methods could/should I use for identifying sub-groups in a customer segmentation?

I am working on a segmentation model that has been fed into the company by an external agency which created the segmentation based on surveys. I have a number of 6 attitudinal segments and after ...
146 views

### How to forecast individual customer's spend (for millions of customers)?

Which forecasting model fits better to forecast the customers spend in the next upcoming visit? We have millions of customers, so ARIMA or any other time series modeling for each of the customers is ...
59 views

### Difference between forecasting model, forecasting method and forecasting function

I am new to the field of Business Analytics. Can anyone distinguish between forecasting model, forecasting method and forecasting function? According to the book forecasting function is is an equation ...
15 views

### Architecture to build model off of partners data while protecting each partners intellectual property

Are there any architectures that allow two partners to build a model while protecting each of their respective intellectual property (IP)? For example: Company A builds machine learning models ...
67 views

### Regression with negative values, inverse regression, cost stickiness

I'm doing an analysis of cost stickiness with change in cost and change in revenue. Cost stickiness means that the percentage cost will decrease when revenue decreases is lower than the percentage ...
66 views

### Feature Identification for customer profiling

Problem: I want to identify the characteristic(s) of people who would shop on Monday vs Sunday (or any such dichotomous response variable). I have over a million observations and >50 variables/...
32 views

### Which statistical figures should be used to describe my data set [closed]

I apologize if this question has been asked before. I am looking for the best way to describe my data set. A little background - I am a algorithmic programmer with a physics/mathematics background. ...
822 views

### customer segmentation with categorical variables

I have a customer dataset, which is a survey result. I have 1595 obs. and about 200 columns (200 because most of the cases the questions were multiple choice and we had to split it into columns). ...
66 views

I have been tasked with finding the return on investment of a vaccine. The vaccine is used by farmers for their cows and the number of cows kept varies drastically between farmers (from $1$ to $1,000'... 1answer 58 views ### How can we model the visit pattern of a customer in a retail store? I am trying to segment customers based on how recently they visited the store. However, I am also trying to incorporate the frequency with which they visit the store. For example, in a data collected ... 1answer 67 views ### What is the resulting increase in Sales ($ and %) from a treatment?

I have 43 weeks of data (here) that show the resulting weekly sales of a group of test stores which received a treatment and sales of other "control" stores that did not. There were 36 test stores and ...
682 views

### Calculate mean from cumulative percentage table

Is it possible to calculate mean from cumulative percentage table below? Scenario: Bob is a manager. He is trying to estimate the sales for the next year, and from his experience, he knows the sales ...
60 views

### Correct statistics technique for prob below

I am kind-of stuck with a small problem here. I can't find a proper statistics based technique which will solve my problem! Problem: I have a dependent variable (Categorical 4 Levels), and 6 ...
47 views

### Choosing a significance test for employee performance

I'm analyzing employee performance at a call-center. I'd like indicate whether a particular employee's conversion (success) rate is significantly different from the average/expected conversion rate. ...
63 views

### Is there any “Intro to Statistics” for business and mangement use?

I am looking for an "Introduction to Statistics" to apply to business and management. Can someone recommend a source they have used (maybe in their MBA or similar studies) that is available online (...
83 views

### How do I run a cluster analysis on customer store visit data to identify clusters that consist of both location and time?

I have data from customer visits to a number of different stores over the course of a few months. In one column I have the time/date of the visit, in another the location of the visit, and in other ...
915 views

### Customer behavior analysis and clustering using data from loyalty program?

I'm trying to do some analysis on customers behavior. Basically, I have information on customer's loyalty points activities data (e.g. how many points they have earned, how many points they have used, ...
909 views

### Practical Examples of What Econometrics Can Do for a Business? [closed]

Hello, all. So, as a beginning MA student in Economics, I had to take a basic Econometrics course (which was absolutely fascinating and I really loved it), and it seemed like a genuinely practical ...
27 views

### Suitable and efficient comparison metric/index for price data

I have price data for similar products in different stores like below ...
24 views

### Is there a standard set of reports that can be applied to any dataset?

I work for a small recycling firm and we have built and maintain a stock management system. I've been asked to implement some reports over our dataset but I have no background in BI or statistics. I'm ...
52 views

### Can CAPM be applied in this non-financial context?

I want to get a "score" which measures the efficiency of truck planners at a site which despatches boxes of identical size to multiple destinations. This is measured by how full each truck is, on ...
199 views

### Aggregation system for percentage Key Performance Indicators (KPIs)

I need some suggestions for an issue regarding our business intelligence (BI) system, percentage Key Performance Indicators (KPIs) and average values. I am using a BI system for our organization, ...
130 views

### What is the statistical method that I should use for the following problem?

I have been given a problem and need to find the best statistical method that would help. The problem is as follows: A business has approx. 100,000 active customers who spend between £500 per annum ...
1k views

### Accuracy of a probability estimate

How can you classify the accuracy of a probability? Say I do a study of people that like bananas in 2 different regions. Region 1: 8 out of 10 people tested like bananas. Region 2: 500 out of 1000 ...