Questions tagged [business-intelligence]
business intelligence is statistics and data analysis of business information.
51
questions
1
vote
1answer
30 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
0answers
11 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
2answers
32 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
3answers
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 ...
0
votes
0answers
25 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 ...
0
votes
0answers
5 views
Markov Switching CHP test
In Hamilton's paper "What is real about business cycles?" (2005) I have three questions: 1) How do we calculate C(p; theta) on page 451 if we do not know "nuisance" parameter values of p? 2) What was ...
1
vote
0answers
43 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
0answers
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 ...
0
votes
0answers
30 views
Propensity modeling
I am trying to model for understanding the probability of a customer buying a product based on his/her recent interactions with the system. For a customer who has made a purchase it is very easy to ...
1
vote
0answers
57 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
0answers
9 views
Benchmarking Analysis (statistical approach)
Im looking for sources in order to perform some kind of statistical analysis applied to Benchmarking, i.e., "market analysis" where I'm measuring the performance of a company's products, services, or ...
0
votes
0answers
111 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
1answer
47 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
1answer
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
...
1
vote
1answer
54 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 ...
2
votes
0answers
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. ...
2
votes
1answer
62 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
1answer
59 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
2answers
491 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
3answers
59 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
1answer
43 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
1answer
61 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 (...
1
vote
1answer
682 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 ...
0
votes
0answers
25 views
Suitable and efficient comparison metric/index for price data
I have price data for similar products in different stores like below
...
0
votes
0answers
23 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 ...
0
votes
1answer
47 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 ...
1
vote
0answers
171 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, ...
2
votes
3answers
648 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 ...
0
votes
1answer
63 views
Calculating Revenue per customer for a series of emails over time, which have a normal decay rate
I am analyzing data for an email marketing company.
We have x amount of subscribers that come in at some point in time.
We promote zero or more emails to these individuals daily, for several ...
1
vote
1answer
31 views
How to average days until completion when some items haven't completed the cycle?
I am attempting to calculate the average number of days it takes for an order to go through our process - from receipt of order to delivery. When calculating the average days, how should I handle ...
3
votes
1answer
195 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
836 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
152 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 (...
14
votes
4answers
751 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 ...
1
vote
1answer
252 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
248 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
2k 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
183 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
139 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 ...
3
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
176 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
250 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
531 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
...
2
votes
1answer
172 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 ...
1
vote
0answers
126 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 ...
