Skip to main content

Questions tagged [business-intelligence]

business intelligence is statistics and data analysis of business information.

Filter by
Sorted by
Tagged with
0 votes
2 answers
49 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 ...
badc0ffee's user avatar
  • 123
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 ...
LarryW's user avatar
  • 19
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 ...
Suzanne's user avatar
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 ...
facility_manager's user avatar
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 ...
G. Vece's user avatar
  • 548
0 votes
0 answers
19 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 ...
jrubins's user avatar
  • 13
1 vote
1 answer
41 views

How to tell whether segments from K Means clustering result are "successful" and will impact business metrics?

Background I'm a data analyst. The Business unit I'm assigned for needs to segment users based on power vs non-power users so they can target each segment with proper treatments. Goal Segment users (...
Blaze Tama's user avatar
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+...
user392306's user avatar
0 votes
1 answer
25 views

How to build an acquisition models?

I have historical transaction data for a B2B business. I want to prepare acquisition models where the model will predict the potential buyers who haven't purchased from the business yet. In addition ...
NAS_2339's user avatar
  • 223
2 votes
1 answer
40 views

How to determine if a change in (traffic or user behavior) has had a negative impact on the overall system

How to determine if a change in (traffic or user behavior) has had a negative impact on the overall system? For ex: if we introduce a new line of shoes, the older ones will might see a decline in ...
Aman Mathur's user avatar
0 votes
1 answer
53 views

A good textbook about value at risk in R? [closed]

I am so new to business applications and interested in learning about value at risk. My question is, could you please recommend for me a nice/easy book about value at risk with applications using the ...
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 ...
GT1992's user avatar
  • 1
1 vote
1 answer
51 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 ...
jstaxlin's user avatar
  • 221
0 votes
0 answers
24 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 ...
Arthur's user avatar
  • 536
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 ...
deemel's user avatar
  • 2,734
0 votes
1 answer
72 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 ...
Hemant Gupta's user avatar
3 votes
2 answers
126 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. ...
Deepak Agarwal's user avatar
2 votes
0 answers
36 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 ...
Ben's user avatar
  • 451
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 ...
Jasmine Lawrence's user avatar
1 vote
1 answer
27 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 (...
Fardin Ahsan's user avatar
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 ...
prototype's user avatar
  • 559
0 votes
0 answers
20 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 ...
Ben's user avatar
  • 3,473
0 votes
0 answers
317 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 ...
Decile's user avatar
  • 1
3 votes
1 answer
2k 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 ...
jitmanchan's user avatar
1 vote
0 answers
176 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 ...
user7817's user avatar
  • 111
2 votes
1 answer
214 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 ...
Alex's user avatar
  • 497
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 ...
Tamim Abo Saleh's user avatar
0 votes
0 answers
31 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 ...
J Doe's user avatar
  • 372
2 votes
2 answers
59 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....
Srishti Jain's user avatar
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 ...
Vincent B. Lortie's user avatar
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 ...
Lebowski's user avatar
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: ...
Jivan's user avatar
  • 571
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 ...
aghd's user avatar
  • 314
4 votes
1 answer
486 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 ...
James Taylor's user avatar
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 ...
Nolatar's user avatar
0 votes
0 answers
218 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 ...
ML101's user avatar
  • 1
0 votes
1 answer
124 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 ...
user8657231's user avatar
1 vote
1 answer
495 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 ...
hawkaterrier's user avatar
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 ...
Ryan Lowe's user avatar
1 vote
1 answer
212 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 ...
user209439's user avatar
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/...
Robin's user avatar
  • 11
2 votes
0 answers
43 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. ...
user206929's user avatar
1 vote
3 answers
2k 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). ...
Sara's user avatar
  • 11
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'...
Leonhard Euler's user avatar
0 votes
1 answer
115 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 ...
kusur's user avatar
  • 305
2 votes
1 answer
81 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 ...
Russ Harris's user avatar
4 votes
2 answers
1k 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 ...
cht's user avatar
  • 41
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 ...
user avatar
1 vote
1 answer
67 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. ...
Hiram Foster's user avatar
0 votes
1 answer
70 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 (...