CP020: Top 10 time saving strategies for business analysts
Podcast: Play in new window | Download
Subscribe: Apple Podcasts | Spotify | RSS
In the 20th session of Chandoo.org podcast, lets save some time.
What is in this session?
We all want to save time and stay productive. The obvious answer seems like using keyboard shortcuts. But they can only get you so far. So what about the real productive strategies? That is what we address in this podcast.
In this podcast, you will learn,
- Announcements
- 5 key areas of business analyst work – tracking, analysis, reporting, data management & modeling
- Time saving strategies for tracking
- for analysis
- for reporting
- for data management
- for modeling
- Conclusions
Please help me design our new course – “50 ways to analyze your data”
Hi friends & readers of Chandoo.org,
I have an exciting and awesome new training program for you. 50 ways to analyze your data is aimed to give you critical data analysis & charting skills necessary for your success as an analyst (or manager). I want to make sure that this course offers you best content & value. I need your help in designing it. Please take a few minutes to read this short post & share your feedback.
CP016: 3 Must have books for aspiring analysts
Podcast: Play in new window | Download
Subscribe: Apple Podcasts | Spotify | RSS
In the 16th session of Chandoo.org podcast, lets review 3 very useful books for aspiring analysts.
What is in this session?
Analytics is an increasingly popular area now. Every day, scores of fresh graduates are reporting to their first day of work as analysts. But to succeed as an analyst?
By learning & practicing of course.
And books play a vital role in opening new pathways for us. They can alter the way we think, shape our behavior and make us awesome, all in a few page turns.
So in this episode, let me share 3 must have books for (aspiring) analysts.
Use Analytical Charts to Make your Boss Love You
There are beautiful, powerful & awesome charting examples all around us. Today, I want to show you how we can harness the power of Excel to create Analytical Charts.
Analytical What?!?
To be frank, I do not know what to call these charts, so I choose the term Analytical Charts. But this is what I have in mind when I say Analytical charts:
A chart is analytical chart,
(1) If it is interactive
(2) It it can answer different questions by re-structuring same data differently
Do you use (or make) Excel Dashboards? Tell us about yourself to win a free training kit
(You can win my latest Excel Dashboard Training kit free, read this post to find out how.)
Over at Jorge’s ExcelCharts blog, he started a very good discussion on Excel Dashboards: Who needs them anyway?.
Jorge has very good experience designing, working on and teaching about dashboards. So he uses all that skill to gaze in to a crystal ball, to understand who needs excel dashboards and why. In this post, I build on his argument and ask you the big question – “If you make or use Excel Dashboards, who are you?”
Excel Links – Next Dashboard Contest Edition
Almost an year ago, we had a memorable dashboard contest on Sales Dashboards. We got 32 beautiful, outstanding, well crafted entries and it was a lot of fun learning new tricks & meeting new members of our community. I am planning to have one more dashboard contest and I need your help.
I need you to suggest a topic for the contest (optional: and give some sample data)
Just drop a comment with your suggestions (and point to source data if any). We will have a dashboard contest on one of those topics.
Read the rest of this post to get some useful Excel related links.
Are you a Solver Virgin? Watch this tutorial video …,
Do you ever think about questions like this?
1) What is the maximum profit we can make?
2) What is the best way to schedule employees in shifts?
3) What the best combination of tasks we can finish in a given time?
You might have heard about Excel Solver tool while trying to find solutions to questions above. If you have never used Solver or have little idea about it, then this post and video are for you.