-
I was reading my boss’s blog post yesterday about the CNN Money charts that include a red or green stripe to indicate if the market has gone up or down over each monthly period. I wanted to recreate the graph, but knew Silverlight would be a time-consuming process, and would require quite a bit...
Posted to
Microsoft Business Intelligence Blog
by
Kyle Schadt
on
Thu, Jul 29 2010
Filed under:
Filed under: Excel, Reporting, Analytics, Article, UI/UX, Visualization, Business Intelligence, PowerPivot, Infographics, Economics, Education
-
I don’t know about you, but all the so called “DASHBOARD” solutions I have been seeing the last several years are really not well designed. What happened to the creative minded people? We have been very busy working on a new retail business intelligence portal leveraging a lot of different...
Posted to
Microsoft Business Intelligence Blog
by
Patrick Husting
on
Thu, May 6 2010
Filed under:
Filed under: PerformancePoint Server, Database, Microsoft, SharePoint, Excel, UI/UX, Visualization, Office 14, Business Intelligence, Infographics, C#
-
We have a customer where we went in an analyzed their spreadsheet overload their analyst were experiencing. The analyst were spending 65 minutes a day looking for information in their email, my documents, file share and SharePoint for spreadsheets and data critical to the business. We reviewed...
-
Another video on how to add SparkLines to your spreadsheets in Excel 2010. But we need better music in the video guys!
-
One of my business intelligence development managers came in the office to do a walk through of his project. We are embracing Excel Services quite heavily now and he showed me an example within our Extended Outlook product. The below report is showing country comparisons side...
-
Extended Results Launch Invite - BI Radio & Webinar Education Series: Jan. 20th - Building A Culture of Performance | Analytical Paradox & User Centricity WELCOME TO THE FIRST EPISODE OF THE UNTAPPED INSIGHTS EDUCATIONAL SERIES! Companies of all sizes will benefit from this monthly interactive...
-
This is a pretty neat add-in that allows you to enhance your PivotTables when working against OLAP cubes. OLAP PivotTable Extensions is an Excel 2007 add-in which extends the functionality of PivotTables on Analysis Services cubes. The Excel 2007 API has certain PivotTable functionality which is not...
-
Just read this article about collaboration and time lost. They say a person looses over $3,300 a year looking for information. That is probably about right. Our solution Extended Outlook and Extended Excel retrieves a large portion of that lost ROI and we have proven it several...
-
One thing I really like about using Excel for my business intelligence solution is the ability to create some really good looking charts (author opinion). We are all guilty of just cranking out reports using the default settings as we are just trying to get the job done, but if you spend...
-
We are really buying into the fact that a lot of our business reporting will be going back to Excel in the next version of Office 2010. There are just a ton of new features in Excel 2010, SharePoint 2010 (with PPS) and Excel Services, PowerPivot, etc. coming and I’ll try and expend some blog...
-
Research studies from IDC, Gartner and other firms show that the cost of your employees spending 20% of their time searching for information can be valued at more than $500,000 per 50 employees. And that doesn’t count the cost of your employees using the wrong information, which 42% reported having...
-
Now I just need to find a super computer to use… At a key supercomputing conference on Monday, Microsoft released a test version of its Excel spreadsheet redesigned to run on powerful clusters of servers. By engineering Excel to run better on such clusters Microsoft said that customers are seeing spreadsheets...
-
One of the features in PivotTables we always wanted was the ability to throw in a measure in the middle of it. You really couldn’t do that unless you converted it to cube functions, but then you lost some of the drag and drop features. I’m watching a LiveMeeting on DAX formulas. ...
-
Check out the following very useful utility: http://www.codeplex.com/OlapPivotTableExtend OLAP PivotTable Extensions is an Excel 2007 add-in which extends the functionality of PivotTables on Analysis Services cubes. The Excel 2007 API has certain PivotTable functionality which is not exposed in...
-
If you haven’t seen it already, check out the new Microsoft PowerPivot blog PowerPivot for Excel is a data analysis tool that delivers unmatched computational power directly within the application users already know and love — Microsoft Excel. Leveraging familiar Excel features, users can transform...