TrustRadius: an HG Insights company

Save this comparison

Save this comparison

Add Product

Recommended Comparisons

    Overview
    ProductRatingMost Used ByProduct SummaryStarting Price

    Microsoft Access

    Score7.5 out of 10
    N/AMicrosoft Access is a database management system from Microsoft that combines the relational Microsoft Jet Database Engine with a graphical user interface and software-development tools.

    $139.99

    per PC

    Strategy Analytics

    Score8.4 out of 10
    N/AMicroStrategy Analytics is an enterprise business analytics and mobility platform. Key features include automatic big data analysis and reporting, data discovery and visualization, digital security credentials, and support for mobile devices.N/A
    Pricing
    Microsoft AccessStrategy Analytics
    Editions & Modules
    Microsoft Access
    $139.99
    per PC
    No answers on this topic
    Offerings
    Pricing Offerings
    Microsoft AccessStrategy Analytics
    Free Trial
    NoNo
    Free/Freemium Version
    NoNo
    Premium Consulting/Integration Services
    NoNo
    Entry-level Setup FeeNo setup feeNo setup fee
    Additional DetailsMust contact sales team for pricing information.
    More Pricing Information
    Community Pulse
    Microsoft AccessStrategy Analytics
    Considered Both Products
    Microsoft
    No answer on this topic
    Strategy
    Chose Strategy Analytics
    Tableau is a user friendly environment that creates visualizations, reports, and dashboards. The performance of Tableau is bad when querying large data sets. Users are not able to customize their reports as easily in Tableau as they can in MicroStrategy. Analysis and modeling …
    Incentivized
    Key User Insights
    Would buy again
    97%
    Would buy again
    29 Answers
    No answers on this topic
    Delivers good value for the price
    97%
    Delivers good value for the price
    29 Answers
    No answers on this topic
    Happy with the feature set
    93%
    Happy with the feature set
    28 Answers
    No answers on this topic
    Lived up to sales and marketing promises
    86%
    Lived up to sales and marketing promises
    19 Answers
    No answers on this topic
    Implementation went as expected
    91%
    Implementation went as expected
    21 Answers
    No answers on this topic
    Features
    Microsoft AccessStrategy Analytics
    Relational Databases
    Comparison of Relational Databases features of Microsoft Access and Strategy Analytics
    Feature
    Microsoft Access
    7.7
    3 Ratings
    5% below category average
    Strategy Analytics
    -
    Ratings
    ACID compliance7.02 Ratings00 Ratings
    Database monitoring8.02 Ratings00 Ratings
    Database locking8.03 Ratings00 Ratings
    Encryption7.02 Ratings00 Ratings
    Disaster recovery7.73 Ratings00 Ratings
    Flexible deployment8.02 Ratings00 Ratings
    Multiple datatypes8.03 Ratings00 Ratings
    BI Standard Reporting
    Comparison of BI Standard Reporting features of Microsoft Access and Strategy Analytics
    Feature
    Microsoft Access
    -
    Ratings
    Strategy Analytics
    10.0
    26 Ratings
    20% above category average
    Pixel Perfect reports00 Ratings10.023 Ratings
    Customizable dashboards00 Ratings10.023 Ratings
    Report Formatting Templates00 Ratings10.024 Ratings
    Ad-hoc Reporting
    Comparison of Ad-hoc Reporting features of Microsoft Access and Strategy Analytics
    Feature
    Microsoft Access
    -
    Ratings
    Strategy Analytics
    10.0
    24 Ratings
    22% above category average
    Drill-down analysis00 Ratings10.022 Ratings
    Formatting capabilities00 Ratings10.024 Ratings
    Integration with R or other statistical packages00 Ratings10.016 Ratings
    Report sharing and collaboration00 Ratings10.023 Ratings
    Report Output and Scheduling
    Comparison of Report Output and Scheduling features of Microsoft Access and Strategy Analytics
    Feature
    Microsoft Access
    -
    Ratings
    Strategy Analytics
    10.0
    23 Ratings
    20% above category average
    Publish to Web00 Ratings10.022 Ratings
    Publish to PDF00 Ratings10.023 Ratings
    Report Versioning00 Ratings10.020 Ratings
    Report Delivery Scheduling00 Ratings10.022 Ratings
    Delivery to Remote Servers00 Ratings10.05 Ratings
    Data Discovery and Visualization
    Comparison of Data Discovery and Visualization features of Microsoft Access and Strategy Analytics
    Feature
    Microsoft Access
    -
    Ratings
    Strategy Analytics
    10.0
    22 Ratings
    22% above category average
    Pre-built visualization formats (heatmaps, scatter plots etc.)00 Ratings10.020 Ratings
    Location Analytics / Geographic Visualization00 Ratings10.019 Ratings
    Predictive Analytics00 Ratings10.018 Ratings
    Pattern Recognition and Data Mining00 Ratings10.01 Ratings
    Access Control and Security
    Comparison of Access Control and Security features of Microsoft Access and Strategy Analytics
    Feature
    Microsoft Access
    -
    Ratings
    Strategy Analytics
    10.0
    21 Ratings
    16% above category average
    Multi-User Support (named login)00 Ratings10.019 Ratings
    Role-Based Security Model00 Ratings10.020 Ratings
    Multiple Access Permission Levels (Create, Read, Delete)00 Ratings10.020 Ratings
    Report-Level Access Control00 Ratings10.01 Ratings
    Single Sign-On (SSO)00 Ratings10.09 Ratings
    Mobile Capabilities
    Comparison of Mobile Capabilities features of Microsoft Access and Strategy Analytics
    Feature
    Microsoft Access
    -
    Ratings
    Strategy Analytics
    9.7
    19 Ratings
    23% above category average
    Responsive Design for Web Access00 Ratings10.019 Ratings
    Mobile Application00 Ratings10.015 Ratings
    Dashboard / Report / Visualization Interactivity on Mobile00 Ratings10.019 Ratings
    Application Program Interfaces (APIs) / Embedding
    Comparison of Application Program Interfaces (APIs) / Embedding features of Microsoft Access and Strategy Analytics
    Feature
    Microsoft Access
    -
    Ratings
    Strategy Analytics
    10.0
    8 Ratings
    25% above category average
    REST API00 Ratings10.06 Ratings
    Javascript API00 Ratings10.07 Ratings
    iFrames00 Ratings10.05 Ratings
    Java API00 Ratings10.04 Ratings
    Themeable User Interface (UI)00 Ratings10.05 Ratings
    Customizable Platform (Open Source)00 Ratings10.06 Ratings
    Best Alternatives
    Microsoft AccessStrategy Analytics
    Small Businesses
    Amazon RDS
    Score8.1 out of 10
    Cyfe
    Score4 out of 10
    Medium-sized Companies
    SingleStore
    Score8.2 out of 10
    Qlik Cloud Analytics (Qlik Sense)
    Score8.2 out of 10
    Enterprises
    SAP IQ
    Score5.5 out of 10
    Jaspersoft Community Edition
    Score7 out of 10
    All AlternativesView all alternativesView all alternatives
    User Ratings
    Microsoft AccessStrategy Analytics
    Likelihood to Recommend
    7.4
    (102 ratings)
    10.0
    (50 ratings)
    Likelihood to Renew
    10.0
    (15 ratings)
    9.9
    (27 ratings)
    Usability
    7.6
    (8 ratings)
    3.2
    (5 ratings)
    Availability
    8.0
    (1 ratings)
    9.0
    (2 ratings)
    Performance
    -
    (0 ratings)
    9.0
    (2 ratings)
    Support Rating
    6.4
    (5 ratings)
    2.2
    (5 ratings)
    Online Training
    -
    (0 ratings)
    9.0
    (5 ratings)
    Implementation Rating
    10.0
    (1 ratings)
    9.0
    (4 ratings)
    Configurability
    -
    (0 ratings)
    9.0
    (1 ratings)
    Data Sharing and Collaboration
    -
    (0 ratings)
    8.0
    (21 ratings)
    Data Sources
    -
    (0 ratings)
    8.8
    (21 ratings)
    Ease of integration
    8.0
    (1 ratings)
    -
    (0 ratings)
    Product Scalability
    5.0
    (1 ratings)
    9.0
    (2 ratings)
    Vendor post-sale
    -
    (0 ratings)
    10.0
    (1 ratings)
    Vendor pre-sale
    -
    (0 ratings)
    10.0
    (1 ratings)
    User Testimonials
    Microsoft AccessStrategy Analytics
    Likelihood to Recommend
    Microsoft
    As a Material Purchasing/Planning/inventory tracking application, Microsoft Access serves its purpose well. It's presentation is clean, data entry is simple and the ability to customize search fields is welcome. It does, however, come with some caveats; namely, when setting search filters and the need arises to back up a step or two, with Microsoft Access you have to reset, or "clear all", adding extra steps/time to a query.
    Incentivized
    Read full review
    Strategy
    MSTR is great for any organization that is looking for a way to deliver complicated data in an uncomplicated way. From business teams to marketing and finance, several departments benefit from using MSTR to keep track of KPIs enabling teams to make optimizations along the way. MSTR provides great visual representations of data enabling team members to distill thousands of data points into easily digestible charts and graphs
    Incentivized
    Read full review
    Pros
    Microsoft
    • Very easy to create entity-relationship diagrams for various tables and designing mock layouts.
    • Really easy to navigate as it hold[s] the classic Microsoft UI. Another good thing is that it comes with the complete MS Office Suite.
    • It is really fast when joining multiple tables no matter what type of join.
    • Works on pretty much same SQL scripts so no need to learn a new language!
    Incentivized
    Read full review
    Strategy
    • They sell the product well, and make promises you will actually believe
    • "checks the box" for most features a company would need. Doesn't actually deliver them though
    • They answer the phone in a timely manner. Can't answer your questions or provide support, but the queue time isn't bad
    • They have online documentation. It's not up to date, and likely doesn't reflect the version of software you are using, but hey... they can point to it.
    Read full review
    Cons
    Microsoft
    • Microsoft Access has not really changed at all for several years. It might be nice to see some upgrades and changes.
    • The help info is often not helpful. Need more tutorials for Microsoft Access to show how to do specific things.
    • Be careful naming objects such as tables, forms, etc. Names that are too long can get cut off in dialog boxes to choose a table, form, report, etc. So, I wish they would have resizable dialog boxes to allow you to see objects with long names.
    • I wish it could show me objects that are not in use in the database for current queries, tables, reports, forms, and macros. That way unused objects can be deleted without worrying about losing a report or query because you deleted the underlying object.
    Incentivized
    Read full review
    Strategy
    • The graph options are not as robust as an Excel user might want.
    • The metadata layer can sometimes be slower, and it takes a long time for reports to run.
    • Viewing the data feed entered can be cumbersome at times, in terms of validation with reports.
    Incentivized
    Read full review
    Likelihood to Renew
    Microsoft
    I and the rest of my team will renew our Microsoft Access in the future because we use and maintain many different applications and databases created using Microsoft Access so we will need to maintain them in the future. Additionally, it is a standard at our place of work so it is at $0 cost to us to use. Another reason for renewing Microsoft Access is that we just don' t have the resources needed to extend into a network of users so we need to remain a single-desktop application at this time.
    Read full review
    Strategy
    I would always choose to renew MicroStrategy as long as they lead the market in features, functionality and price. The support of MicroStrategy is timely and professional, I frequently get answers to my questions within 24 hours and normally have solutions within 48 hours. Training available for MicroStrategy completely covers everything required to be able to expertly use MicroStrategy and understand data warehousing.
    Incentivized
    Read full review
    Usability
    Microsoft
    Microsoft Access is easy to use. It is compatible with spreadsheets. It is a very good data management tool. There is scope to save a large amount of data in one place. For using this database, one does not need much training, can be shared among multiple users. This database has to sort and filtering features which seem to be very useful.
    Incentivized
    Read full review
    Strategy
    The standard grid reporting could look more like the styling and object used for the Import and Visual Insight products. In addition, object properties almost seem to be hidden when first using the product. It's as if they are asking the engineers to only use the presets we make available...and, these presets are 10+ years old. On the positive side, Microstrategy seems to be the only product, not named Cognos, which can scale to Big Data. The product is "hackable" via the SDK or tricking the Intelligence Server to do uncommon things. The Microstrategy development team also seems to be very involved with their OEM partners; especially when it comes to features and enhancements. A large majority of the improvements we suggested have made it into the product or on the roadmap for future enhancements. Only suckas fall for the shiny objects from most other vendors; Microstrategy is really the only choice for Enterprise BI.
    Read full review
    Reliability and Availability
    Microsoft
    I don't think the program has ever failed me. It is one of those programs where there is always a solution if you know where to look.
    Incentivized
    Read full review
    Strategy
    I've never had an issue with MicroStrategy not being available due to MicroStrategy application malfunction. It is very robust and only failures I've seen were due to user error or the platform the machine running the service failed some how.
    Incentivized
    Read full review
    Performance
    Microsoft
    No answers on this topic
    Strategy
    Being able to customize the performance based on the business need is extremely powerful. Proper configuration and understanding of the usage pattern is key, if the technical ability of the architect is not at top level, then the product will not be configured correctly which will lead to poor performance.
    Incentivized
    Read full review
    Support Rating
    Microsoft
    While I have never contacted Microsoft directly for product support, for some reason there's a real prejudice against MS Access among most IT support professionals. They are usually discouraging when it comes to using MS Access. Most of this is due to their lack of understanding of MS Access and how it can improve one's productivity. If Microsoft invested more resources towards enhancing and promoting the use of MS Access then maybe things would be different.
    Incentivized
    Read full review
    Strategy
    Good user community. Support team is available if you are under AMC. You get decent support after raising the support ticket. If it is product bug they will inform you and let you know which patch will resolve the same.
    Incentivized
    Read full review
    Online Training
    Microsoft
    No answers on this topic
    Strategy
    I have attended many trainings offered by MicroStrategy; both distance and in-person training. I earned my CRD (Certified Report Developer) certification via the online training. I found the training to be well organized and concise. Overall I will definitely continue to increase my knowledge with MicroStrategy via the online training offering.
    Read full review
    Implementation Rating
    Microsoft
    there is no key idea, since it is easy to implement Microsoft Access
    Read full review
    Strategy
    We measured following KPI for the success
    • Increase in Business Feeds Loads
    • Reduction in Controllers Manual Work.
    • Conversion of Manual Work into Systematic Workflows.
    • Increase in Customer Spend
    • Reduction in Service costs
    • Reduction in time-to-market for new campaigns
    • Increase in cross sell and Up sell
    • Error reduction in customer Identification
    • Existing client retained
    Incentivized
    Read full review
    Alternatives Considered
    Microsoft
    Excel is a fantastic - robust application that can do so much so easily. Its easy to train and understand. However - excel does not provide a reporting function and that is typically where we will suggest a move to [Microsoft] Access. [Microsoft] Access requires a little more knowledge of data manipulation.
    Incentivized
    Read full review
    Strategy
    Tableau is probably MicroStrategy Analytic's biggest competitor I've noticed over time, and I'm not sure why. Tableau only covers visualizations independently for each business user, which then creates the issues of every employee creating their own version of the data, and then you have 20 versions of the truth. A enterprise data warehouse and MicroStrategy's Visual Insight is a better method.
    Incentivized
    Read full review
    Scalability
    Microsoft
    No answers on this topic
    Strategy
    This software is extremely scaleable, one can add more core servers which performs as a load balancing. The configurations available to manage usage patterns and daily activity are as high a caliber as any other enterprise level software. This product can be installed on both a windows and unix platform allow for integration on a budget.
    Incentivized
    Read full review
    Return on Investment
    Microsoft
    • Not having to recreate queries or reports every time you want to use them.
    • Once an item is created and saved as part of the database, you save manpower by not having to recreate them.
    • ROI from a usability standpoint is great. Solid product with great functionality that requires low maintenance usually.
    Incentivized
    Read full review
    Strategy
    • MicroStrategy was helpful for reducing the amount of time we needed to spend number crunching large data sets, and in doing so, allowed me as the primary users to spend more time gleaning insights from the data that in turn informed our leadership team to make strategic decisions.
    • By creating numerous canned reports available to all members of the team through email distribution or basic access to the platform, we were able to reduce the time I spent showing people how to pull the data in Microsoft Excel by nearly 40% .
    • We ended up needing to make many changes to the way our DMP was feeding data into MicroStrategy due to incorrect reporting that caused complications in accounting and finance.
    Read full review
    ScreenShots