Questions tagged [business-intelligence]
business intelligence is statistics and data analysis of business information.
90
questions
0
votes
0
answers
7
views
Data Set With Variable Start Dates for Churn Modeling (New customers from business acquisition)
I have dataset representing to specific region of the country. Its purchase data which is how much costumer is placing with associated dates of order, amount etc.
I want to do churn modeling for this ...
0
votes
0
answers
16
views
What would be best the best way for multiple companies to consolidate their demand forecasting together?
I am currently reading up on my demand forecasting knowledge and had this question where I can't seem to find a quick answer for.
Let's say you have a couple of stores/restaurants/etc that sell more ...
0
votes
0
answers
17
views
How would we set the initial parameters of beta distribution of Thompson sampling if we want to start the model with the existing data?
This was one of the business-related questions from my technical interview last week for a data science position in a recommender system team at a search engine company focusing on advertisement ...
1
vote
1
answer
27
views
What is the general right call to make from a marginal difference in A/B test results in recommender system?
This was one of the business-related questions from my technical interview last week for a data science position in a recommender system team at a search engine company focusing on advertisement ...
0
votes
0
answers
11
views
Assess whether distance from competitor affects sales in stores
Suppose I'd like to investigate whether proximity of a competitor store affects sales in my stores.
I'm struggling on how to frame the question from a regression perspective. Furthermore, there may be ...
0
votes
0
answers
5
views
Accounting for time effects with time covariates vs. instrumental variables or other alternatives
I have sales data where I expect some structure in time due to inflation, market changes, etc.
I am not a statistician by training, but I am aware of the issues that this presents and the technique of ...
1
vote
0
answers
17
views
Estimating demand from partially right-censored sales data
Imagine a company is having limited-time sales events of certain limited editions of their products. Let's consider 3 such events, each featuring a different product, with limited inventory of 600 ...
0
votes
0
answers
46
views
Linear regression for longitudinal data
In my work, we collect sales data of our products. We have a set of 1st level customers (lets call that group as jacks) with whom we do we business. These jacks then sell our products to end customers ...
0
votes
0
answers
50
views
Supply chain planning - multiple warehouses
I work in retail company, we have multiple warehouses across the Europe, we sell a lot of different articles. In supply chain planning we take article, forecast sales of it (ARIMA) and in next step we ...
0
votes
1
answer
64
views
Company selling consumer goods on e-commerce channel want to reduce customer returns
I have a use case as below
One company selling products online would like to understand how to reduce returns from customers. They on an average have 25% returns. They have data for orders which have ...
3
votes
2
answers
59
views
How to avoid selection bias while updating lead scoring (predictive) model with new data
We developed a standard lead scoring model using logistic regression on couple of months worth data. The model has been working and we have been pushing only top 1/3 leads to sales team basis that. ...
0
votes
0
answers
19
views
Wilcoxon Sign-Rank Test with before/after treatment and control groups
Here is the setup of my experiment. I have 500 storefronts that are all part of the same chain brand. I've selected 250 of them to test an advertising intervention, and want to know whether the ...
0
votes
0
answers
10
views
Agricultural product decision making under price volatility
I am recently doing agricultural price forecasting to make decision in which month the company should buy them (normally when the price is low). But, the company decided to not buy all of stock they ...
2
votes
0
answers
29
views
Method for determining the root cause behind a drop in business performance
What methods are there for determining the root cause behind a drop in business performance? My question is best explained with a very simple example...
There are two Widget Factories (A and B).
Each ...
1
vote
0
answers
31
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 ...
0
votes
0
answers
162
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 ...
0
votes
0
answers
23
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 ...
1
vote
1
answer
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 (...
1
vote
0
answers
15
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 ...
0
votes
0
answers
17
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 ...
0
votes
0
answers
40
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 ...
3
votes
1
answer
531
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 ...
1
vote
0
answers
87
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 ...
2
votes
1
answer
45
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 ...
1
vote
1
answer
46
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 ...
0
votes
0
answers
15
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 ...
2
votes
2
answers
46
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....
14
votes
3
answers
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 ...
3
votes
0
answers
187
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 ...
1
vote
0
answers
515
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:
...
0
votes
0
answers
25
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 ...
3
votes
1
answer
257
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 ...
0
votes
1
answer
32
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 ...
0
votes
0
answers
167
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 ...
0
votes
1
answer
77
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 ...
1
vote
1
answer
344
views
Pareto/NBD and New/Existing Customers
I am looking at implementing a Pareto/NBD model to forecast customer lifetime value in a non-contractual business setting. One thing I haven't got my head around yet is whether such a model is equally ...
0
votes
1
answer
16
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
...
1
vote
1
answer
102
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 ...
1
vote
1
answer
69
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/...
2
votes
0
answers
39
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. ...
1
vote
2
answers
1k
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). ...
2
votes
1
answer
72
views
Return on investment for a vaccine
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'...
0
votes
1
answer
84
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 ...
2
votes
1
answer
70
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 ...
4
votes
2
answers
895
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 ...
0
votes
3
answers
62
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 ...
1
vote
1
answer
54
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. ...
0
votes
1
answer
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 (...
0
votes
0
answers
90
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 ...
1
vote
1
answer
952
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, ...