Share
Hi friends & readers of Chandoo.org
I hope you had a fantastic start to 2013. Mine was awesome so far.
This year, I am even more committed to making you awesome in what you do. As a first step, I have created a small survey to know how we can help you better this year.
Please take our 2013 readership survey [takes less than 5 mins to answer]
That is all for now. Wishing you an awesome, Excellent new year 2013.
Share this tip with your colleagues
Thank you so much for visiting. My aim is to make you awesome in Excel & Power BI. I do this by sharing videos, tips, examples and downloads on this website. There are more than 1,000 pages with all things Excel, Power BI, Dashboards & VBA here. Go ahead and spend few minutes to be AWESOME. Read my story • FREE Excel tips book
– Jason
From simple to complex, there is a formula for every occasion. Check out the list now.
Calendars, invoices, trackers and much more. All free, fun and fantastic.
Still on fence about Power BI? In this getting started guide, learn what is Power BI, how to get it and how to create your first report from scratch.
Here is a fabulous New Year gift to you. A free 2025 Calendar Excel Template with built-in Activity planner. This is a fully dynamic and 100% customizable Excel calendar for 2025.
19 Responses to “15 Quick & powerful ways to analyze business data”
This is just great Chandoo! Aspiring operation managers should be knowing these powerful analysis approach. Thank you for sharing.
It's very helpful stuff and I am expecting much more awsome in coming training program.
Thanks for sharing.
This awesome! I always enjoy their excel quick tricks!
I meant 'your' texcel tricks
This is Fantastic.
I use quite a few of them on a fairly regular basis. Now I will have a one stop location for a lot of the fire power I need for my analysis
Great help and thanks for sharing Chandoo.
Thanks Chandoo!!!! You work "Hard" to put our lives at "Ease".......
Thank-you Chandoo. 🙂
Thank you Chandoo! This came at a right time!
Thank you chandoo!
Superb!
good.
good
simply awesome stuff. you got my attention can't wait for more.
[…] http://chandoo.org/wp/2015/07/01/how-to-analyze-business-data/ […]
it`s nice man! Thanks. I like it: brief explanations, powerful functions.
hi, awesome.
I want to join
What's stopping me using powerpivot:
#link powerpivot tables on more than one criteria, e.g. Customer Name and postal code as they might have multiple delivery addresses.
#update names across multiple pivots (especially when grouping)
#grouping dates/number into non linear chunks, e.g 1-10, 10- 15, 15-28,28-31
#Quickly changing number format (i.e. rather than right click -> number format, click any cell and change the format for all numbers in that field, in that report.
other things:
#fiscal calendar calcs -> 4/4/5 week vs calendar, P1= april? jan? September?
#mileage() -> variables are(Start point, end point, postal code/geocords, route option, route planner) output = mileage as per route planner (google/bing maps) and economic, fastest... etc
#Coffee() -> variables are (Number of drinks, mug size, type, milk, sugar, flavour, takeaway) -> obviously a joke, but well done for making it to the end...
[…] http://chandoo.org/wp/2015/07/01/how-to-analyze-business-data/ […]
Hi Chandon,
I would like ask a question. I’m now warp ling with a project to analyse the Bottom 10 performance products with 6 parameters (like rating, no. Of clients etc). May I know if I can use proportion of each parameters and get score & 5 star rating for each of them?
Appreciate if you can help with this. Thanks!