Forums for the Business Analyst

  Modern Analyst Forums  Careers  Getting Started  Time Crunch Meets Information Overload
Previous Previous
Next Next
New Post 4/18/2015 8:41 AM
User is offline Ack
1 posts
No Ranking

Time Crunch Meets Information Overload 

Hey everyone!

I'm in something of an odd situation and am in serious need of direction! 


I'm moving from my current position in operations with my company, to business analyst in roughly one month's time.  My undergrad degree is in business, but realistically taught me nothing I've used thus far or will be using as BA, I don't have a masters degree.  I graduated a little less than a year and a half ago, so I have that much experience with this company (consumer finance).  My current job has no aspect that could be related to BA.  However, I've formulated and executed a significant number of my own projects of my own volition to the point where I've gained a lot of attention from our VPs.

This is basically my dream job and I'm unbelievably excited to start.  I love learning and spend a majority of my free time studying content related to work or general interests.   However, given my limited time frame and how complicated the BA role is I'm a little overwhelmed.  I've found I'm spending more time trying to figure out what to study, than actual learning.  There are so many options even with what I know I need to learn it is hard to figure out where to start.  I would love some advice on where to go for tutorials and study material!

I asked my new boss as well as another member from the department and they suggested I learn Powerpivot for Excel, and how to run queries/macros in Access.  I have a limited understanding of access, but I have been through the microsoft guide.  I have no experience with Powerpivot but know how to use pivot tables.  Any free guides/course suggestions would be appreciated!  I could afford to spend a little money, but anything over $100 probably isn't feasible.

In terms of BA specifically, I've read most of the free material at and have a good understanding of what a BA generally does.  My company seems to use BAs more as a Data Analysis source that generate reports for Senior VPs with about 40% of their time.  The rest of the time they come up with their own projects.  I nearly purchased the BABOK last night, but after reading a few amazon reviews I realized it may not be the best source of material for me at this point in time.  Any advice for what to look at in this regard?  Any certifications that can be worked on without experience would also be amazing.

Any advice would be incredibly appreciated!  I apologize for the wall of text!  After reading other similar posts and the subsequent responses requesting more information I tried to be as thorough as possible while remaining concise and to the point hah.


TLDR: Limited time, need help picking the better guides for Microsoft Access, and PowerPivot for Excel.  Also, study material for general BA work/certifications that require no time in the field.

New Post 4/25/2015 10:11 PM
User is offline Kimbo
450 posts
5th Level Poster

Re: Time Crunch Meets Information Overload 

HI Ack,

Good to hear you're advancing your career. So learning technical stuff like Access and pivot tables won't be much use to you as a BA (been a BA for 15 years and never  used either) but all new skills are generally worth acquiring.

I basically have a set of techniques that I apply to all projects, using the ones that are most appropriate for the project I'm working on. Most of them are covered in the BABoK. I recommend you join the IIBA  think its You get the BABoK as part of the subscription plus you get access to their online library of books which I've found useful. If you live in the states, go to their convention and get involved in a local chapter. Work out the techniques you need and practice them - get advice from peers where you work. Have fun. Let us know how you get on.


Previous Previous
Next Next
  Modern Analyst Forums  Careers  Getting Started  Time Crunch Meets Information Overload

Community Blog - Latest Posts

Different procedures are utilized for legitimate administration of IT administrations, yet ITIL is viewed as the best arrangement of practices for even administration of IT administrations. ITIL is the contraction for Information Technology Infrastructure Library.  In easier words, ITIL is many rules and arrangements for the effective admin...
2 Responses
What Everyone Must Know about AI in Testing Artificial Intelligence is the buzzword that we frequently keep hearing. Its widespread popularity and influence can be understood from the way industries adopting AI in their organization. Whether it’s Healthcare, Automobile, Banking & Financial Services, or Airlines, many industries have st...
0 Responses
Ashish Adike
Ashish Adike
As a Business Analyst, very often we get into a situation where the Project requires multiple IT Products to be evaluated before implementation and might seek Business Analyst’s recommendation for the same. With the ever-growing range of Products in the market and the marketing promotions associated with some of the products, it’s very ...
0 Responses

Latest Articles

How to Thrive as a Business Analyst in the New Normal
Jan 24, 2021
The Pandemic hit us suddenly and yes it came without any notice to our lives as a transient thing but became the new normal way of life. Some of ...
Copyright 2006-2021 by Modern Analyst Media LLC