SQL Clone
SQLServerCentral is supported by Redgate
 
Log in  ::  Register  ::  Not logged in
 
 
 


Attractive dashboards/cube browser/reports solution


Attractive dashboards/cube browser/reports solution

Author
Message
baal32
baal32
SSC-Enthusiastic
SSC-Enthusiastic (131 reputation)SSC-Enthusiastic (131 reputation)SSC-Enthusiastic (131 reputation)SSC-Enthusiastic (131 reputation)SSC-Enthusiastic (131 reputation)SSC-Enthusiastic (131 reputation)SSC-Enthusiastic (131 reputation)SSC-Enthusiastic (131 reputation)

Group: General Forum Members
Points: 131 Visits: 412
Kind of open-ended question, but I'm trying to woo my employer away from a disastrous engagement with Oracle to implement OBIEE (and OBIA) towards a Microsoft solution. The only thing that concerns me is that MS BI seems to focus heavily on using Excel to display business intelligence, and that the SharePoint dashboard solution is kind of dated looking.

Wanted to ask whether anyone with experience in this realm could offer some guidance - hoping for a solution where we can use SSIS/SSRS (maybe)/SSAS but still deliver very attractive (even flashy) dashboards and visualization to end users and C level management. Dundas looks pretty decent, and SharePoint while not beautiful will do in a pinch, but any other suggestions?

Thanks
Koen Verbeeck
Koen Verbeeck
One Orange Chip
One Orange Chip (27K reputation)One Orange Chip (27K reputation)One Orange Chip (27K reputation)One Orange Chip (27K reputation)One Orange Chip (27K reputation)One Orange Chip (27K reputation)One Orange Chip (27K reputation)One Orange Chip (27K reputation)

Group: General Forum Members
Points: 27163 Visits: 13268
Check out Power View, the flashy looking self-service BI dashboarding tool. Power View is available in SharePoint, but also in Excel 2013 (but the data needs to be in Excel). Power View works on top of SSAS.

With SSRS, you can also build decent reports and dashboards, but it takes some skill.

And yes, you can also build reports and dashboards in Excel. Admit it, it's the tool end users love :-D
If you are a bit skilled in it (and you don't need to be a developer for that), you can produce some awesome dashboards/graphs in Excel.
A nice book will be released soon: Dashboarding and Reporting with Power Pivot and Excel: How to Design and Create a Financial Dashboard with PowerPivot ?


How to post forum questions.
Need an answer? No, you need a question.
What’s the deal with Excel & SSIS?
My blog at SQLKover.

MCSE Business Intelligence - Microsoft Data Platform MVP
baal32
baal32
SSC-Enthusiastic
SSC-Enthusiastic (131 reputation)SSC-Enthusiastic (131 reputation)SSC-Enthusiastic (131 reputation)SSC-Enthusiastic (131 reputation)SSC-Enthusiastic (131 reputation)SSC-Enthusiastic (131 reputation)SSC-Enthusiastic (131 reputation)SSC-Enthusiastic (131 reputation)

Group: General Forum Members
Points: 131 Visits: 412
When we say Excel are we talking about end users actually opening up Excel to view the dashboards or do you mean as an authoring tool? Our end users (executives and managers) absolutely will not open a client application (other than a browser) to view dashboards and reports...

I'll check out powerview - thanks
xsevensinzx
xsevensinzx
SSCrazy
SSCrazy (2K reputation)SSCrazy (2K reputation)SSCrazy (2K reputation)SSCrazy (2K reputation)SSCrazy (2K reputation)SSCrazy (2K reputation)SSCrazy (2K reputation)SSCrazy (2K reputation)

Group: General Forum Members
Points: 2012 Visits: 2696
I'm pretty new to the BI game, so bear with me.

We are currently transitioning to SSAS/SSRS from a reporting module built on top of MS Access that exports data to predefined Excel templates.

As we are using 2008 R2, SSRS looks pretty dated, but the team cares more about the data than looking pretty. This is a very good thing for me because I couldn't handle a situation like yours where someone cares more about vanity than functionality! :-P

Regardless, we also need reporting for our website and clients. That changes thing. Vanity is pretty important when it comes to clients, but functionality is also as equally important too. Therefore, I've been testing Tableau for our external reporting that can out the box, integrate right into our website with minimal effort. It's very attractive, sexy and easy to use with any setup or data source. The only issue is that it can be pretty pricey the first year, but significantly drops therefore after. Costs are broken down by seat (login) and report builder.

Check it out. Free trials are available. They also just introduced a cloud version as well. I believe the data space for the cloud is like 100GB per seat.

http://www.tableausoftware.com/

Fully Interactable Dashboard Examples

http://www.tableausoftware.com/solutions/business-dashboards


Tableau Server

Delivers web-based analytics from any workbook created by Tableau Professional
Delivered as a complete solution, no other prerequisite software required
Connects to all Tableau supported data sources, including relational databases, cubes, Hadoop, cloud data, and desktop files
Publish content to the server from Tableau Professional
Microsoft® Windows® Server 2012, 2012 R2, 2008, 2008 R2, 2003 R2 sp2 or higher; Windows® 8 or 7 (see Note 2)
32-bit or 64-bit versions of Windows (see Note 1)
Minimum of a Pentium 4 or AMD Opteron processor (see Note 3)
32-bit color depth recommended
Internet Protocol version 4 (IPv4) and 6 (IPv6)


Data Sources

Actian Vectorwise 1.5 or later
Amazon Redshift
Cloudera Hadoop Distribution via Hive (CDH3u1, which includes Hive .71, or later, with options for Beeswax server and Kerberos)
Cloudera Impala 1.0 or later
DataStax Enterprise Edition 2.2 or later
EMC Greenplum 4.x or later
EXASOL 4.2 or later
Firebird 2.0 or later
Google Analytics
Google BigQuery
Hortonworks Data Platform (HDP) 1.1 or later
HP Vertica 4.x or later
IBM DB2 9.1 or later for Linux, UNIX, or Windows
IBM Netezza release 4.6 or later
MapR Distribution for Apache Hadoop
Microsoft Access 2003 or later
Microsoft Excel 2003 or later
Microsoft PowerPivot 2008 (whether or not published in SharePoint) or later
Microsoft SQL Server 2005, 2008, 2008R2, or 2012
Microsoft SQL Server Analysis Services 2005, 2008, 2008R2, or 2012 (Multi-dimensional mode only)
Microsoft Windows Azure Marketplace DataMarket
MySQL 4.0 or later
OData
Oracle Database 10.x or later
Oracle Hyperion Essbase 11.1.1 or later
ParAccel Analytic Database (PADB) version 3 or later
PostgreSQL 8.3 or later
Progress OpenEdge 10.2B patch 4 or later
Salesforce.com, Force.com, and Database.com
SAP HANA 1.0035 or later
SAP NetWeaver Business Warehouse 7.00 with SP20+ recommended; also requires SAP GUI for Windows 7.20 Client or later
SAP Sybase ASE 15.5 or later
SAP Sybase IQ 15 or later
Splunk Enterprise 6 or later
Teradata V2 R6.2 or later
Teradata Aster Data nCluster 4.5 or later
Teradata OLAP Connector 14.10 or later
Text files -- comma separated value (.csv) files
Also, many databases and applications that are ODBC Version 3.0 compliant

Koen Verbeeck
Koen Verbeeck
One Orange Chip
One Orange Chip (27K reputation)One Orange Chip (27K reputation)One Orange Chip (27K reputation)One Orange Chip (27K reputation)One Orange Chip (27K reputation)One Orange Chip (27K reputation)One Orange Chip (27K reputation)One Orange Chip (27K reputation)

Group: General Forum Members
Points: 27163 Visits: 13268
baal32 (4/4/2014)
When we say Excel are we talking about end users actually opening up Excel to view the dashboards or do you mean as an authoring tool? Our end users (executives and managers) absolutely will not open a client application (other than a browser) to view dashboards and reports...

I'll check out powerview - thanks


When used on the desktop, Excel is usually about pivot tables and graphs. The typical users are analysts and power users. The advantage of Excel is that everyone is familiar with it. You can also use it on SharePoint as Excel services (which is in the browser), there you can use it for solely displaying purposes.

Viewing SSRS reports and dashboards is also through the browser.


How to post forum questions.
Need an answer? No, you need a question.
What’s the deal with Excel & SSIS?
My blog at SQLKover.

MCSE Business Intelligence - Microsoft Data Platform MVP
Go


Permissions

You can't post new topics.
You can't post topic replies.
You can't post new polls.
You can't post replies to polls.
You can't edit your own topics.
You can't delete your own topics.
You can't edit other topics.
You can't delete other topics.
You can't edit your own posts.
You can't edit other posts.
You can't delete your own posts.
You can't delete other posts.
You can't post events.
You can't edit your own events.
You can't edit other events.
You can't delete your own events.
You can't delete other events.
You can't send private messages.
You can't send emails.
You can read topics.
You can't vote in polls.
You can't upload attachments.
You can download attachments.
You can't post HTML code.
You can't edit HTML code.
You can't post IFCode.
You can't post JavaScript.
You can post emoticons.
You can't post or upload images.

Select a forum

































































































































































SQLServerCentral


Search