Office Business Intelligence – The way people experience data

re: Office Business Intelligence – The way people experience data

Diego M. Oppenheimer — Mon, 08 Oct 2012 17:18:29 GMT

The capability to cross multiple olap cubes does not work directly. What you would have to do is use the Powerpivot add-in to create "Flattened" queries against those cubes bring them into independent tables in your data model and then combine. Hope this helps.

re: Office Business Intelligence – The way people experience data

AdamVero — Fri, 05 Oct 2012 11:06:20 GMT

Aaargh!! My eyes!!

After finally accepting that 3D charts are not a good way to represent data accurately or usefully and making sure they never get recommended to users, you blow away all my goodwill by having an article ostensibly about BI and plonk a great big screenshot in the middle with an abomination of a 3D pie chart!

(with this many slices even a flat pie would be almost useless here - what's wrong with a simple, single colour bar chart?)

You will never win the hearts and minds of professional people to use Excel as a "serious" BI tool if you keep eroding their confidence that you (as a team) have any real knowledge of what good data visualisation should look like.

re: Office Business Intelligence – The way people experience data

Jim King — Mon, 20 Aug 2012 07:03:17 GMT

Will you post on how to make interactive sales dashboard in Excel?

re: Office Business Intelligence – The way people experience data

Diego M. Oppenheimer — Thu, 09 Aug 2012 07:50:24 GMT

www.microsoft.com/.../try-office-preview

re: Office Business Intelligence – The way people experience data

follow_me_2000 — Mon, 06 Aug 2012 09:33:03 GMT

When I read "PivotTables across multiple Excel tables" ... does that mean that we can expect also the possibility to make pivottables across multiple SSAS Olap cubes ?

re: Office Business Intelligence – The way people experience data

Dan B [MS] — Tue, 31 Jul 2012 06:24:39 GMT

@Peter - Our hope is that many of the visualizations that folks like yourself are looking for will be provided via Apps for Office - components that developers can write and then make available through the Marketplace. These Apps run in both Excel and Excel Services/Web App and internally we've already seen some pretty cool visualizations get created. You can learn more about Apps at blogs.msdn.com/.../introducing-apps-for-the-new-office-and-sharepoint.aspx

re: Office Business Intelligence – The way people experience data

Peter Schmidt — Tue, 31 Jul 2012 04:57:54 GMT

I love the new BI related features. My only request would be to incorporate some additional visualizations, such as bullet charts and GANTT charts. I currently use the excellent Sparkline add-in witten by Fabrice Rimlinger (sparklines-excel.blogspot.com.au) which works great, but as it is done using macros is not supported by Excel Services which is such a shame!

re: Office Business Intelligence – The way people experience data

Dan B [MS] — Mon, 30 Jul 2012 18:38:47 GMT

@Szyl LLC - you can head over to www.microsoft.com/.../preview to join the preview (beta).

re: Office Business Intelligence – The way people experience data

dhExcel — Sun, 29 Jul 2012 04:23:13 GMT

"But, ultimately, have we changed the end user BI game?"

Ultimately, IT in large companies determime how BI is handled. Excel is NOT one of their favorite tools. So, if Microsoft will go to those companies and evangelize Excel as the core for BI solutions, then maybe the long-held belief by IT that Excel is only for the lowly workers can be changed. That belief WILL NOT change by itself.

re: Office Business Intelligence – The way people experience data

syswizard — Fri, 27 Jul 2012 18:51:53 GMT

How can I get onto the beta test list for Excel 2013 ?