1. Home
  2. Business Intelligence (BI) Tools
  3. MS SharePoint / SQL Reviews
  4. User Review of MS SharePoint / SQL
Straightforward Microsoft
April 27, 2018

Straightforward Microsoft

John Dopson | TrustRadius Reviewer
Score 7 out of 10
Vetted Review
Verified User

Overall Satisfaction with MS SharePoint / SQL

It is being used by multiple application groups and on infrastructure level. We use SQL as our main windows database engine, and Share Point for collaboration moving to o365 and Sharepoint cloud.
  • SharePoint collaboration and dashboards, visual reporting and easy repository
  • SQL database and maintenance and easy Reporting services.
  • SQL backup wizard for backup and restore could be improved to be more like more modern backup tools, better file management.
  • Easier maintenance planning and job management.
  • Easier UI for being able to create new Sharepoint sites for sharing.
Selected because of easy setup and easy maintenance. Better pricing model on a Microsoft platform.
Very good for vanila environment with out a lot of customization where where reporting services can be used for ad hock reporting.

MS SharePoint / SQL Feature Ratings

BI Platform ()
Not Rated
Supported Data Sources ()
Not Rated
6.0
Pixel Perfect reports
Not Rated
Customizable dashboards
6
Report Formatting Templates
Not Rated
7.7
Drill-down analysis
8
Formatting capabilities
7
Integration with R or other statistical packages
Not Rated
Report sharing and collaboration
8
7.0
Publish to Web
7
Publish to PDF
7
Report Versioning
Not Rated
Report Delivery Scheduling
Not Rated
Delivery to Remote Servers
Not Rated
7.0
Pre-built visualization formats (heatmaps, scatter plots etc.)
7
Location Analytics / Geographic Visualization
7
Predictive Analytics
Not Rated
8.0
Multi-User Support (named login)
Not Rated
Role-Based Security Model
8
Multiple Access Permission Levels (Create, Read, Delete)
8
Single Sign-On (SSO)
8
Not Rated
Responsive Design for Web Access
Not Rated
Mobile Application
Not Rated
Dashboard / Report / Visualization Interactivity on Mobile
Not Rated
Not Rated
REST API
Not Rated
Javascript API
Not Rated
iFrames
Not Rated
Java API
Not Rated
Themeable User Interface (UI)
Not Rated
Customizable Platform (Open Source)
Not Rated

Using MS SharePoint / SQL

200 - They represent sometimes analytics and sometimes the sale reporting teams. We also use SQL to support a lot of our application database back end.
3 - Skills like DBA or systems admins, we have also the network team that helps support SQL and developer that helps support share point.
  • We might start using for some data consolidation
  • We might start using some of SharePoint cloud features for improved collaboration.
  • Collaboration
  • Data aggregation.
  • I would not call it innovative but was able to use SQL to consolidate multiple small database platforms.

Evaluating MS SharePoint / SQL and Competitors

  • Product Features
  • Product Reputation
  • Vendor Reputation
It is a pretty standard process but may have changed the testing of different features. More proof of concept, proof of value.

MS SharePoint / SQL Implementation

Mo major insight regarding the implementation if very well documented for standard products.
  • Implemented in-house
Yes - dev , qa, prod phases
Change management was a small part of the implementation and was well-handled
  • nothing major

MS SharePoint / SQL Support

professional support
ProsCons
Quick Resolution
Good followup
Knowledgeable team
Problems get solved
Kept well informed
Immediate help available
Support cares about my success
None
They were able to help recover a crucial database

Using MS SharePoint / SQL

Over all very similar to other microsoft products
ProsCons
Like to use
Relatively simple
Easy to use
Quick to learn
Feel confident using
None
  • database creation
  • maintenance planing