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
-
If you were to build a freelance marketplace for data scientists and data analysts, what kind of companies and projects would you target?
It's unlikely that companies would look to outsource such a critical component and also it would be near impossible to create trust around 3rd parties accessing their data especially via an intermediary service.TW
-
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
-
How can I better market my services?
Hi: Sounds like you have a potential solution to offer to the marketplace. Or is it a service that clients can plug into existing processes? It's great that you've developed the requisitie experience and skills, but whether you're offering a solution or service, you now need to spin your thinking around: * Who is using this technology currently? * What are the headaches those users experience while using this technology? * How does your solution or service resolve those headaches? * Are users willing to pay to resolve those headaches? * What will it take to get users to switch from their current solution or service to your solution or service? If you don't do this legwork in the marketplace to identify existing issues, challenges and headaches, there's a high likelihood your solution or service will fall flat. If you wish to discuss, send me a PM through Clarity for 15 free minutes. Cheers, KerbyKM
-
Decision Makers: Are Rows+ Columns really > than charts?
It depends on what you mean by "Visualized Data." Do decision makers use graphs, charts, dashboards, etc? Yes of course. Are there some visualizations that wouldn't be of any value to a decision maker whatsoever? Also yes of course. You can't show me a word cloud if I work as a portfolio manager for a bank and expect me to make any decisions from it. That being said, the social media team might be able to. It all depends on the audience, and whether or not you're making patterns they care about easier to detect. If you are talking about graphs/charts/dashboards, what I would do if I was in your shoes is I would try to make one dashboard with (say) 3-4 graphs inside of it, and then I'd show them that dashboard and say something like, "You know, I've been thinking about that conversation we had. And I definitely appreciate the point you made about fluff visualizations. But I also really think there's at least a few charts that would be really valuable to you. I whipped a few together (on my time, not yours!). Do you have a few minutes that you could spare to come have a look at them with me?"EV
the startups.com platform
Copyright © 2025 Startups.com. All rights reserved.