Loading...
Answers
MenuI'm looking for data mapping/analyzing software or excell tips to use my past sales data in order to project future sales by a week at a time.
I have an etsy and amazon shop and I'm grabbing the data from ship station a week at a time and am realizing that it would take a ton of time to create a weekly breakdown and forcast by manually maping the data out on an excell sheet, but it would be really helpful to have these projections in order to plan our buying and manufactoring, and it would also be fun to project how much cash we may make this year by calculating the difference in our growth.
Answers
This isn't what I normally do for clients ... at all.
But I write Excel formulas and custom-code databases every day and have a solid background in statistics.
Sounds like what you're asking could be done in an hour using Excel ... and in such a way that you'd be able to enter future data in the spreadsheet on your own and have it analyzed automatically.
Maybe software exists. Maybe you can hire someone on Fiverr. But if neither of those options works for you and you're willing to overpay someone overqualified for the task, I suppose I could set it up. Might be a nice break from real work!
Go for a specialist who has work in data analytics spectrum, someone who has good business and statistics knowledge. There a number of freelancers and reputed companies, www.marketquotient,com can surely help.
Excel is still a solution for a big deal of your needs .
But for visualization you need to check "Tableau".. It is a really different experience that will take you in a different dimension.
For a deeper statistical analysis , you may go to mini tab , which has an edge on excel when come to statistics.. But still visually , tableau is waaaay better .
I'm a data scientist and look into questions like this frequently. Until recently, I ran the data science organization at a payment processor, where we answered questions like this for merchants on a daily basis, and also built products at scale to help inform merchants' decision making.
The question here really is: can you predict these sales numbers well enough to inform specific buying and manufacturing decisions? Sales numbers are difficult to predict precisely for many reasons (week to week fluctuations can be pretty high, seasonality can be a big factor depending on what you're selling, it's very helpful but often difficult to separate sales from existing and new customers, etc.), but as long as you can predict them well enough and far enough in advance to make better decisions you can create a positive financial impact. The point is that this isn't so much a question about predicting the sales as well as you can, but a question about optimizing your decision making process.
Therefore, I'd encourage you to engage the help of someone who has experience in solving operational business problems using data. One of the first things a good data person should do is help you quantify the size of the problem - how much money you can save by doing this analysis. This will help you determine how much time and money to put into it to make sure that the project has a positive return on investment.
Projections are not only based on data but also on operations, products, people and process. There are couple tactics you can use without mapping a large data.
Other things you should look at are the people who execute behind your products because mostly they are the one causing sales problem, not the product or its data projection.
By implementing couple tactics you can figure out easily the product that sells most, your A players people, and implement a marketing strategy that sells.
Give me a buzz. We can set up together the process for you.
Related Questions
-
How can I use my cohort analysis by revenue to determine if I'm spending too much or too little in advertising?
You'll find that looking at top line revenue alone won't provide much value to you if you are asking the question "Is my advertising spend worth it?" Typically, in advertising I want to know the Lifetime Value of the customer or the Average Revenue Per User (ARPU). Then, it boils down to : If I spend $100 to acquire this new customer and he spends $150 over the lifetime of his paid relationship with me then, yes--- my ad spend is worth it. On the other hand: I could spend 10K this month in ads. I could sign up 20K in users/customers/top line revenue. But my data will tell me I spent MORE per customer/user than they are actually worth over the average lifetime. So that's what usually answers the "Is it worth it" question in any advertising scenario. 1. How much to acquire the user? 2. How much does the user spend over the avg lifetime? If it doesn't make sense, it's not worth it, regardless of what your top line revenue tells you. You might find this blog post on cohort analysts valuable as it goes into more detail. (I have no affiliation.) https://apsalar.com/blog/2012/01/how-to-use-cohort-analysis-to-improve-revenue/LH
-
Looking for a tool to help me tweet replies from a specific Twitter account. Then I'll need help to analyze the data.
Are you talking about tweeting replies based on keywords in a tweet directed towards a specific @user? If so, then you should be able to find a developer to create a simple Twitter bot for you. You can get really fancy with it and even train an AI model to come up with replies on its own. Analyzing data is a much different beast than a Twitter bot. For one, Twitter data is unstructured data. Also, how do you want to analyze this data and how do you plan on using these results? That makes a big difference in the direction that the real answer to this question will take. There are a number of different tools available, but it's probably going to require a hybrid solution of custom programming on top of using the tools available.MG
-
What is the simplest / best way of implementing NPS (net promoter score) and CSAT (customer satisfaction) metrics at a small but old company?
Use Delighted: https://delighted.com/CB
-
What are the best traits to look for in a data scientist/data analyst?
First off, I have several people I could introduce. I'd also like to know the industry you're operating in, what the data looks like, where it comes from, and how much it needs to be cleaned up if putting into a relational database, or if the better solution would be a distributed file system like MongoDB where you don't necessarily need to normalize the data. Also, if you're a startup, or if the company is well established with many existing customers and if this is for a new initiative. Assuming you're working with a relational database, which it sounds like you are, you will want to implement something like Tableau or build out a custom dashboard using Google Charts, HighCharts, D3Js, or any number of other potential dashboarding/visualization solutions, which usually involves some programming/scripting in JavaScript. There are paid solutions like Tableau (which is amazingly powerful), and then there are free/open source options. I'd be happy to talk about possible ways to architect the solution, and discover who you would need once I understand the variables more. If you're building a web application, then you will likely need someone who is also a full stack developer, meaning they can handle building the back end and the front end in addition to the data requirements. Many early startups choose Ruby on Rails (because there is a ton of open source code out there for it) with Twitter Bootstrap (modified) and in order to visualize the data, they will need to work with JavaScript. It makes sense to have this person act as initial product and to derive the insights out of the data. They're pretty much the only person who can do this anyways, because they're the ones on the data. If you're in an early stage startup, I would recommend the strongest business owner (usually the early stage startup's CEO) be directly involved with this person on communicating what value your solution brings to clients, and what they pay you for, and in brainstorming on potential features and reports. Once the solution becomes established, and many customers start using it directly, there should be a different product person interfacing to those customers over time, gathering feature requests from customers and bringing it back to the Data Scientist/Analyst who spends their time working on the data. Depending on whether the solutions are SQL or NoSQL or hybrid, there are different types of Data Science professionals you should consider: 1. Data Scientist 2. Data Engineer 3. Data Modeler/Analyst 1. The Data Scientist handles experimenting with the data, and is able to prove statistically significant events and statistically valid arguments. Normally, this person would have modeling skills with Matlab, R, or perhaps SAS, and they should also have some programming/scripting skills with C++ or Python. It really depends on your whole environment and the flow of data. In my experience, Data Scientists that exclusively use SAS are sometimes extremely skilled PhD level statisticians and focused exclusively on the accuracy of the models (which is okay), but often not sufficiently skilled to fit within an early startup's big data environment in today's world and handle all of the responsibilities you'd like them to handle described in your question. I'm am not bad mouthing SAS people as they are often the MOST talented mathematicians and I have a great deal of respect for their minds, but if they do not have the programming skills, they become isolated within a group without a Data Engineer helping them along. Often a SAS user trying to fit into this environment will force you to use a stack of technologies that a skilled Data Architect would not recommend using. It takes programming in some object oriented language to fit into today's big data environments, and the better Data Scientists are using hybrid functional and OOP programming languages like Scala. Extremely hard to find Data Scientist can also work with graph databases like Neo4j, Titan, or Apache Giraph. 2. The Data Engineer, if you're dealing with a firehose of data like Twitter and capturing it into a NoSQL architecture, this is the person who would prepare the data for the Data Scientist to analyze. They often are capable of using machine learning libraries like WEKA to transform data, or techniques like MapReduce on Hadoop. 3. The Data Modeler/Analyst is someone who can use a tool like SAS, SPSS, Matlab, or even R, probably a very strong advanced Excel user, but likely won't be a strong programmer, although perhaps they will have a computer science degree and have some academic programming experience. The most important thing to watch out for is someone who is too academic, and has not been proven to deliver a solution in the real world. This will really screw you up if you're a startup, and could be the reason you fail. Often, the startup will run out of money due to the time it takes to deliver a complete solution or in the startup's case, a minimally viable product. Ask for examples of their work, and specifically dig into what it is that they did for that solution. I've tried to cover a pretty broad range of possibilities here, but it's best to talk in specifics. I'd be happy to discuss this with you in detail. To answer your question, is it perfectly reasonable for someone to handle all of the responsibilities described in your question, if you find the right type of person with the appropriate skills, and a history of success.SE
-
How big data can evolve if our overall ability to convert data into really valuable info that then can drive effective decision making is so limited?
I would disagree with the premise that "big data" isn't being converted into valuable information. Modern advertising is being driven by exactly this ability. The problem lies not with the information, or lack thereof, but with the decision makers. Lack of vision at both the strategic and tactical levels of decision, fear of change, among other things are at the root of the problem.GD
the startups.com platform
Copyright © 2025 Startups.com. All rights reserved.