October 24, 2012 at 12:13 pm
Hi geniuses.
What are the methods and tools available for end-users to modify or create new and standard reports, that you know of?
I 'm familiar with Report Builder, but thats pretty much it.
Thanks
Regrads!
October 24, 2012 at 2:16 pm
Excel and PowerPivot directly connected to the database. There is also a tool in 2012 (I forget the name) that is very much like Tableau and supposedly available to end users for report development.
October 25, 2012 at 2:03 am
Daniel Bowlin (10/24/2012)
Excel and PowerPivot directly connected to the database. There is also a tool in 2012 (I forget the name) that is very much like Tableau and supposedly available to end users for report development.
That tool is PowerView.
Just to summarize everything, these are report building applications:
* BIDS (or SSDT in SQL Server 2012): developing SSRS reports. Meant for developers.
* Report Builder 3.0: developing SSRS reports. Meant for developers/analysts/power users.
* Excel: PivotTables on top of database or SSAS. You can create normal reports on top of SSAS using CUBE functions, but this is pretty advanced and tiresome.
* PowerPivot: plug-in for Excel. Combines different datasources and creates a tabular model in its engine. Reports are like PivotTables.
* PowerView: reports on top of Tabular data sources (SQL Server 2012 SSAS Tabular). Before Office 2013 SharePoint Enterprise is needed to deploy the reports. Nice interactivity with PowerPoint. With Office 2013 PowerView is also available in Excel, making Excel one of the most obvious choices for end users to create reports.
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
October 25, 2012 at 2:20 am
Thanks!
So basically for end-users, the more adequate tools are Report Builder and PowerViewer?
What about these tools technology methods?
Do you have any good site or doc where I can learn more about these tools?
Thanks
Regards!
October 25, 2012 at 2:25 am
You can start by reading this article series by Devin Knight:
It compares all the reporting tools and lists their strength and weaknesses.
It also includes PerformancePoint, which I forgot in my list.
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
October 25, 2012 at 2:52 am
What about VISIO Reporting Services?
Adequate for end-users?
Thanks!
Regrads!
October 25, 2012 at 3:12 am
What exactly do you mean with Visio Reporting Services?
Do you mean Visio Services in SharePoint?
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
October 25, 2012 at 3:26 am
Yes! Visio Services in SharePoint.
It is appropriate for end-users?
Regards!
October 25, 2012 at 4:01 am
That is really limited.
You can connect shapes to a datasource and change the color of the shape (for example) according to the data.
Example:
you have a visio diagram of your server infrastructure consisting out of 4 servers.
You have a query that gets the current status from a table: offline or online.
If it's online, you color the shape green. If it's offline, you color the shape red.
So it's good for quick overview of statuses, but that's about it.
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
October 25, 2012 at 7:32 am
Does PerformancePoint Services allows to create reports and integrate them to SQL Server Reporting Services and Excel Services?
Thanks!
October 25, 2012 at 8:46 am
What r the features available in Visio Services (Sharepoint 2010) for end users?
Thanks
Regards
October 25, 2012 at 1:07 pm
davdam8 (10/25/2012)
Does PerformancePoint Services allows to create reports and integrate them to SQL Server Reporting Services and Excel Services?Thanks!
No. PerformancePoint integrates only with SharePoint.
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
October 25, 2012 at 1:07 pm
davdam8 (10/25/2012)
What r the features available in Visio Services (Sharepoint 2010) for end users?Thanks
Regards
They can open up the Visio diagram and admire the pretty colors.
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
Viewing 13 posts - 1 through 12 (of 12 total)
You must be logged in to reply to this topic. Login to reply