MS SharePoint / SQL refers to Microsoft Sharepoint, a web-based collaborative platform, being used in tandem with Microsoft SQL Server to provide business intelligence analytics and reporting. They can provide BI content such as data connections, reports, scorecards, dashboards, and more.
N/A
Tableau Public
Score 8.9 out of 10
N/A
Tableau Public is a free edition of the Desktop product. With this edition, data can only be published to the Tableau public website and does not allow work to be saved or exported locally.
A simple and important scenario well suited is that you can configure alerts to notify you when the production server fails. another best feature is the report server is the central component of reporting services. For me something less appropriate is that the admin must ensure optimal performance for farm operations, they recommend that you install SQL Server on a dedicated server that does not run other farm roles and does not host databases for other applications.
Tableau public is the best platform to build dashboards for your personal profile and share with recruiters. It's always good to keep ourselves updated on the latest features, create sample dashboards and save them to a personal profile. Tableau public is free and doesn't need any subscription. anyone can create an account and start building reports.
Data visualization: lots of different options, including bar, scatter, pie, waterfall charts to explore relationships between variables, and to present findings/trends to different teams
Integrates readily with limited, though different data sources: TXT, CSV, TDE, Access
Exports reports for review of different dashboards: client-ready/team-ready, with a clean and tidy presentation in PDF format (or hardcopy)
Tableau Public (both Desktop and Server) like their "for a fee" counterparts offer very easy to learn and use tools to transform data into pictures and gain insights into your data. Most organizations report a reduction in development time of 10x vs. other similar tools, due to the intuitive user interface. That said, with Tableau Public, published workbooks are "disconnected" from the underlying data sources and require periodic updates when the data changes. Users are limited to 1 Gb of storage space per user ID and password as well.
I would like to see better options for public sharing of visualizations and data from within the "for a fee" products as more and more organizations are moving in the direction of data sharing with partners and their communities.
This was a long-term buy-in from a corporate perspective, to remain in the SharePoint space. Migration is certainly possible, which is good for planning and having options further out. At this point, the only planned migration is to eventually move the architecture up to SharePoint/SQL 2013. At that point, we will be able to leverage some greater efficiencies, some enhanced content design and management features, and some more current social features. It is well worth a full consideration in any shop looking at a new implementation of or migration to SharePoint (although you will probably be considering 2013 versions or beyond in those discussions), but the platform should be a strong competitor to any alternatives. Realizing the capability of a fully-branded and customized website was not part of the original choice for the architecture at Lincoln, but seeing it implemented and functioning now with this capacity far beyond original expectations has certainly cemented plans to continue using it.
It's free, right? I'll keep using the free version. So the real question to ask is this? Will I pay $999 for the Personal version or $1,999 for the Professional? Yikes! That is a big stretch. I'm not sure about that. The product comparison chart is at: http://www.tableausoftware.com/public/comparison
SharePoint is very complex. This makes usability somewhat difficult from an IT perspective. An IT generalist will be able to pick it up and run with basic tasks. More customized functions would require significant specialized training and therefore limit what a standard user would be able to achieve. From an end user perspective, it's pretty straightforward to use.
Tableau public is a great training tool to understand the basics of Tableau before buying it. A great tool to extend Excel's visualization and to publish data for others. Not useful for anything you need secure. No ability to access databases. Static information only.
It's been fantastic in terms of Premier Support so far. If there is an issue and if you report if the product has an issue, they will act upon it immediately. In some cases, if you design/develop something using the platform, Microsoft appreciates it and... publishes it on their public website. But you have to wait for some time if it is a non-Premier Support issue as you may experience delays.
Start at the end and work backward. Identify the business case / issue and questions the end users have, then identify the data needed, and where to get it.
At the time of the two large projects, SharePoint was the enterprise solution so we were required to use that. We have since lobbied the enterprise teams to review and consider Atlassian Confluence and were successful. Confluence is cheaper than Sharepoint which is why we wanted to bring that in. The enterprise has now made Confluence an enterprise solution as an alternative to SharePoint. After using both I think SharePoint has many more add-ins than Confluence. It has much more customization ability than Confluence. SharePoint is not good for mobile readiness. Confluence is so there is a difference that might lead you to Confluence over SharePoint. I would also say that SharePoint is very document-centric and that Confluence has better KM than SharePoint does. even with the use of SQL Server. We were told that we could not use Google Drive even though it had features we liked.
Google Charts/Drive is sufficient for simpler data sets, but it does not integrate with other web platforms and the visualization does not look as professional. I'm not aware of any other competitors that offer the same package as Microsoft.
I've installed SharePoint in many different industries and each industry has seen greater collaboration among their teams both locally and nationally. The ability to collaborate more efficiently has reduced the need to have employees centrally located.
Companies which have used SharePoint in a end user training portal have had great ROI, since they can create the content once and share with all their users who subscribe to their training service. The web content management aspect of SharePoint is a very helpful feature.
