Untapped-Insights

Microsoft Business Intelligence Collaboration and Community

Microsoft Business Intelligence Blog » All Tags » Excel (RSS)

Browse by Tags

Blogs

Microsoft Business Intelligence Blog

Home

Syndication

RSS for Posts
Atom
Email Notifications
Go

Microsoft Business Intelligence

SharePoint Links

SQL Server

Microsoft Office Blogs

Archives

CNN Money Chart Explained

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...

Published Thu, Jul 29 2010 5:15 AM by Kyle Schadt

Filed under: Excel, Reporting, Analytics, Article, UI/UX, Visualization, Business Intelligence, PowerPivot, Infographics, Economics, Education
Let’s Innovate on Business Intelligence Again!

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...

Published Thu, May 6 2010 9:00 AM by Patrick Husting

Filed under: PerformancePoint Server, Database, Microsoft, SharePoint, Excel, UI/UX, Visualization, Office 14, Business Intelligence, Infographics, C#
A Great ROI Story by Enhancing Microsoft Excel with Extended Excel

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...

Published Mon, Apr 26 2010 5:02 AM by Patrick Husting

Filed under: Microsoft, Excel, Tips, Business Intelligence
Excel 2010 Sparklines

Another video on how to add SparkLines to your spreadsheets in Excel 2010. But we need better music in the video guys!

Published Wed, Feb 3 2010 5:04 AM by Patrick Husting

Filed under: Microsoft, Excel, Video, Office 14, Business Intelligence
Excel Services 2010 â€“ Iâ€™m quite impressed!

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...

Published Mon, Jan 18 2010 4:22 AM by Patrick Husting

Filed under: Microsoft, Excel, Visualization, Business Intelligence
BI Radio & Webinar Education Series: Jan. 20th - Building A Culture of Performance | Analytical Paradox & User Centricity

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...

Published Thu, Jan 14 2010 11:04 AM by Patrick Husting

Filed under: Excel, Article, Webinar
Excel: OLAP PivotTable Extensions Add-in

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...

Published Mon, Jan 4 2010 6:00 AM by Patrick Husting

Filed under: Microsoft, Excel, Tips, Add-In
Do collaboration tools really increase employee productivity?

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...

Published Wed, Dec 30 2009 8:04 AM by Patrick Husting

Filed under: Blogging, SharePoint, Excel, Tips, Article, Outlook, BLOG
Better looking charts in Excel 2007/2010

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...

Published Tue, Dec 29 2009 8:50 AM by Patrick Husting

Filed under: Microsoft, Excel, Tips, Analytics, Article, Visualization, Business Intelligence
Search Engine Market Share in Excel 14 and Excel Services

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...

Published Wed, Dec 16 2009 4:31 AM by Patrick Husting

Filed under: Microsoft, Excel, Tips, Office 14
Cost of Employees Searching for Information

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...

Published Fri, Dec 4 2009 4:00 AM by Patrick Husting

Filed under: Microsoft, Excel, Tips, Extended Analytics
Business intelligence for Super Computers

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...

Published Mon, Nov 16 2009 1:05 PM by Patrick Husting

Filed under: Microsoft, Excel, Office 14, Business Intelligence
PowerPivot â€“ DAX Formulas â€“ SOLD!

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â...

Published Wed, Nov 11 2009 4:42 AM by Patrick Husting

Filed under: Microsoft, Excel, Tips, Business Intelligence, PowerPivot
Want to see the MDX Excel is generating?

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...

Published Wed, Nov 4 2009 4:07 PM by Patrick Husting

Filed under: Excel, Tips
Gemini is now Microsoft PowerPivot

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...

Published Sat, Oct 24 2009 4:51 AM by Patrick Husting

Filed under: Excel, PowerPivot, Gemini, BLOG

1 2 Next >

Browse by Tags

Blogs

Syndication

Recent Posts

Tags

Microsoft Business Intelligence

SharePoint Links

SQL Server

Microsoft Office Blogs

Archives