Questions tagged [business-intelligence]
business intelligence is statistics and data analysis of business information.
46
questions with no upvoted or accepted answers
4
votes
2
answers
320
views
Customer satisfaction over time in R
As a side project I am currently working on determining customer satisfaction over time for quite a large company. We have over 100,000 records in our dataset which need to be analysed. The dataset ...
- 143
4
votes
1
answer
293
views
Clustering Consumer data with over 100 variables and 50000 rows each
I am tasked with performing a clustering exercise for a consumer survey dataset with the hopes of finding distinct consumer segments.
In the past, I've done it using a variety of techniques- ...
- 141
3
votes
0
answers
298
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 ...
- 31
2
votes
0
answers
35
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 ...
- 451
2
votes
1
answer
74
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'...
2
votes
0
answers
38
views
Clustering stream of new customers based on future potential?
I need to cluster new customer according to their future potential, but I have only information about their first transaction.
I have access to all transactions for the other customers.
So I can do a ...
- 21
2
votes
0
answers
85
views
What Model to Use, are my assumptions correct? Psuedo Time series
I have quite a few questions and would like some help/advice or a general pointing i the correct direction.
I have a dataset that has every home sold over the last 3 years and it's sale price, along ...
- 161
2
votes
0
answers
372
views
Difficulty identifying diminishing returns from additional SKUs
As a work assignment, I've been asked to determine the optimal SKU count for a product group. I've decided to tackle this Q using a simple linear regression with sales as my dependent variable and the ...
- 173
1
vote
0
answers
36
views
Statistics to detect employee/customer collusion
I'm an analyst at an agency that operates landfills. There was a recent discovery that certain trash haulers colluded with 2 or 3 weigh-masters to undercharge in return for kickbacks. I'm tasked ...
- 19
1
vote
0
answers
61
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 ...
- 2,714
1
vote
0
answers
40
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 ...
1
vote
1
answer
26
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 (...
- 21
1
vote
0
answers
45
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 ...
- 559
1
vote
0
answers
175
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 ...
- 111
1
vote
1
answer
54
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 ...
1
vote
1
answer
1k
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:
...
- 571
1
vote
1
answer
492
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 ...
- 153
1
vote
1
answer
71
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/...
- 11
1
vote
1
answer
57
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 ...
- 399
1
vote
0
answers
233
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, ...
- 11
1
vote
2
answers
150
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 ...
- 11
1
vote
0
answers
31
views
Change in distribution of a portfolio of customers
I'm looking for some high-level thoughts on understanding a change in distribution for a portfolio of customers.
I have a file with information on a bunch of customers. These customers are purchasing ...
- 121
1
vote
0
answers
355
views
Logistic Regression Sample Size and Outcome Period
I am to run logistic regression on approximately 900,000 observations (each a unique customer) in order to determine propensity to purchase a given product or propensity to hold a given product. I ...
- 203
1
vote
0
answers
129
views
Building business intelligence tool -- where to start?
I'm currently a web developer with a backgound mainly in server side technologies however I've always had an interest in probability so recently I've been exploring building a dummy betting platform ...
- 111
0
votes
2
answers
45
views
How to find a consistency index for a binary variable?
I am working on a project where there are 2 variables to monitor, say sales (actual) and projected sales (target).
The sales ...
- 123
0
votes
0
answers
15
views
Converting Mean Customer Satisfaction to 2TB Score
In Previous years we have reported on mean satisfaction for customer satisfaction. Previous years have been calculated on a 5 point scale. We have moved to T2B satisfaction ratings with the scale ...
- 1
0
votes
0
answers
30
views
Which algorithm for cost prediction?
I don’t have any experience in creating statistical models.
My goal is to to predict future costs for specific areas in the field of facility management (for example repair/maintenance).
I have data ...
0
votes
0
answers
12
views
Regression of Purchase Count using Offset Term to Carry Information About Package Size/Count
Hello: I am interested in modelling the purchase rate over time (an integer number of purchases, observed daily, for a number of shoppers) for a collection of 3 different products.
The data look a ...
- 548
0
votes
0
answers
18
views
discovering latent values, with extremely high cardinality categorical features
I think i know what I need to do here, but I want a gut check, and i might need some direction on specific packages and processing to use.
My goal is to discover the latent value of products that ...
- 13
0
votes
0
answers
12
views
Correlation analysis on sales data (e.g., Click through rate of different pages x Conversion rate of different pages)
I am looking into e-commerce page sales data, and I am wondering if pearson correlation analysis can be done on data set like below.
Each of the variable (e.g., conversion rate, CTR) is based on 10000+...
0
votes
0
answers
27
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 ...
- 1
0
votes
0
answers
23
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 ...
- 536
0
votes
0
answers
19
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 ...
- 3,443
0
votes
0
answers
308
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 ...
- 1
0
votes
0
answers
30
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 ...
- 372
0
votes
0
answers
28
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 ...
- 314
0
votes
1
answer
40
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 ...
- 1
0
votes
0
answers
217
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 ...
- 1
0
votes
1
answer
123
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 ...
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
...
0
votes
3
answers
63
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 ...
karenP
0
votes
0
answers
101
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 ...
- 9
0
votes
0
answers
29
views
Suitable and efficient comparison metric/index for price data
I have price data for similar products in different stores like below
...
- 111
0
votes
0
answers
28
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 ...
- 101
0
votes
0
answers
46
views
How to create an Index of changes to product data
Firstly - I'm a developer with a very limited knowledge of stats / math - so, be gentle.
I have a dataset of product categories, and data about each of them, for each day:
...
- 101
0
votes
0
answers
68
views
Impact analysis through ANOVA
Consider this scenario : Acme inc. processes tickets every day. The ticket completion time range in the order of few days-weeks. Acme hires a new manager Wile E Coyote.
We collect the data for the ...
- 141