Questions tagged [business-intelligence]

business intelligence is statistics and data analysis of business information.

Filter by
Sorted by
Tagged with
3
votes
3answers
314 views

How to classify customers by those who use quite a lot of shops vs. mostly one specific shop

I would be interested in how to approach the following problem: A supermarket chain has 1 million customers in a region and 10 shops. For each of the customers we know the distribution for all the ...
2
votes
0answers
37 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 ...
1
vote
1answer
619 views

How is survey respondent segmentation based on market opportunity score done in practice?

As per instructions, I have administered a survey to a sample population that for several different "jobs-to-be-done" asks the survey participants to rate the importance of the "job-...
4
votes
1answer
204 views

What challenges can data science help with in small businesses

Data science can solve/help with many challenges. But it usually looked upon as something for multi-million dollar corporations. I'm looking for examples of challenges data science helped with in ...
0
votes
2answers
1k views

Odds vs probability in logistic regression

I am going through Trevor Hastie's Classification Techniques. Its says Odds are traditionally used instead of probabilities in horse-racing. I still don't understand how they relate more ...
1
vote
1answer
166 views

Measuring impact of advertising on retail sales

I have a dataset of retail products which contains weekly sales for 12 different items in a single category. For each item, I have three dummy variables representing different types of advertising (...
2
votes
1answer
172 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- ...
1
vote
0answers
30 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 ...
14
votes
4answers
765 views

Good practice for statistical analysis in a business environment

(While I realise this isn't strictly about statistics, it is about the dissemination of statistics in a business environment so I have assumed it is still within the topic range of CV) A brief bit of ...
2
votes
1answer
261 views

ROI Social Media

I'm trying to estimate the ROI of a social media campaign but the main issue I'm falling into is linking social media spend to actual company sales. More followers/tweets/likes/fans etc may just mean ...
2
votes
0answers
302 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 ...
4
votes
2answers
3k views

How to write log-likelihood for beta-geometric with optim() in R?

I am trying to estimate the parameters for a shifted beta-geometric distribution to model user churn, as shown in this paper. The log-likelihood function is described there and solved via Excel, and I ...
2
votes
2answers
3k views

What is the difference between Visualization and BI Visualization?

I am currently doing visualization on my project and I need to know whether the visualization I have done is BI visualization or not. So is there any difference between Visualization and BI ...
5
votes
1answer
186 views

Should I use Bayes' formula to generate simple data about business competition and the market place?

I run a small business, and I'm keen on understanding my market a little more. Market surveying and similar tools are not available to me, mainly due to time and budget. I don't require rock-solid ...
0
votes
0answers
141 views

MS business intelligence development studio CART analysis

I'm doing some clinical database research and in an effort to lessen the burden on our statistical staff, I started to look for different software solutions to get the analyses I need, and that's ...
4
votes
1answer
3k views

Standard deviation of revenue where numbers are only positive

Is there a way for standard deviation to ignore negative numbers? In other words, how can you make it so that 2 or 3 deviations do not extend into negative territory? When looking at a set of only ...
4
votes
1answer
123 views

Layperson's guide to valid polling via Internet?

Sites such as Survey Monkey allow a layperson to easily create and administer a questionnaire. However, the only thing I know about polling is that you can't just create a questionnaire, let anyone ...
4
votes
1answer
186 views

What's the probability a rabbit will return to a (certain) forest?

Let's assume we have a forest. And there is a breed of rabbits that is visiting that forest all the time. It is possible to distinguish every individual rabbit. There are devices in that forest ...
1
vote
1answer
251 views

How can you summarize growth in the “production” rate per person?

I have been reading the book, Good to Great by Jim Collins. It says that you should focus on information that "cannot be ignored," and that you should focus on the right "denominator." I thought it ...
2
votes
2answers
532 views

Doing data analysis for property managers…any tips? [closed]

So I have data elements such as rent price, late payments, unit type and location. I haven't done statistical analysis since my university time where I majored in industrial engineering 2 years ago ...
14
votes
3answers
11k views

RFM & customer lifetime value modeling in R

Can anybody tell me how to do recency, frequency & monetary value (RFM) modeling & customer value modeling in R? Also, can somebody refer me some literature on it?
2
votes
1answer
180 views

Algorithm to evaluate whether you should buy now or wait [closed]

I'm currently in search of an algorithm that can determine whether or not it's time to buy something (an item, a stock, a service, etc.) given an history of prices (30, 50, 100, ...). My idea is ...
1
vote
1answer
1k views

Combining metrics for score card

We are building a score card system to measure the performance of various groups in the organization. The scores are generated by true / false metrics on individual transactions that each group ...
6
votes
7answers
4k views

What is the best tool for customer segmentation?

I have a customer data set with the following data: The number of purchases that each customer made The Date that they made each purchase The Date that they signed up The amount they spent on ...
1
vote
0answers
128 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 ...
4
votes
2answers
170 views

Checking what attributes of a population made objects more likely to do certain action

I'm pretty lost at how to approach this, and particularly with regards to the terminology; so please feel free to point to resources, fix my question name, etc. Thanks. I used R back in college, I've ...
1
vote
1answer
1k views

How should I compare average store sales change across time?

I have what seems like a fairly common business statistics scenario: I need to compare one group of stores to another group of stores and be able to say if their difference in sales is statistically ...
3
votes
4answers
3k views

Useful statistical functions for business — for use by a newbie

I am a database developer working for a sales and manufacturing business. I am mostly ignorant about statistics. We need useful metrics. Our managers are tuned to accounting, and the vagaries of ...

1
2