Non technical data analysts add power to their toolbelts.
December 22, 2014
Non technical data analysts add power to their toolbelts.
Score 7 out of 10
Vetted Review
Verified User
Software Version
2010 V.14 (32-bit)
Overall Satisfaction with Microsoft Access
As a Data Analyst, my department uses Access for ad hoc analysis, business process automation and recurring reporting. It is used by line of business analysts when a technology budget is not approved and a non IT developed/supported application is an option. Typically this would only be used for single user/departmental solutions to reduce single point of failure analytics.
Pros
- Provides user friendly interface (Microsoft standards).
- Provide wizard/step by step guides.
- Does not require a high technical level skill set.
Cons
- Does not handle large data sets particularly well.
- Does not use standard SQL syntax.
- Requires much customization for complex workflows.
- Increased employee efficiency.
- Availability to provide "Just In Time" analytics for decision support.
- Decreased dependency on technology resources.
No other evaluates - this is used as it is bundled with MS Office Professional and there is no additional licensing cost.
Comments
Please log in to join the conversation