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

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
Getting ready for my New York trip to present â€œPersonalized Business Intelligenceâ€

Iâ€™m pretty excited to be traveling to New York this week to present at the Microsoft offices to several media and entertainment companies. We are going to be co-presenting with Microsoft on â€œPersonalized Business Intelligenceâ€ and showing...

Published Thu, Oct 8 2009 6:00 AM by Patrick Husting

Filed under: Microsoft, Office 12, Excel, Dasbboards, Marketing, Performance Management, Analytics, Screenshots, Conference, Extended Analytics, PushBI, Scenario, Visualization, Mobile, Office 14
Dashboards in Excel 2010

Again, I canâ€™t write any specific information on the features of the forth coming Excel 2010, but I can point you to the Office Excel blogâ€¦ Slicers are going to be pretty cool feature in Excel 2010 and just think of the dashboards we can...

Published Fri, Oct 2 2009 6:00 AM by Patrick Husting

Filed under: Excel, Article, Office 14
Collaborative Business Intelligence 2009 Road show with Microsoft

Iâ€™m going to be traveling to 5 cities (New York, Kansas City, Dallas, Denver and Chicago) with the Microsoft Communications Sector group that focuses on Telecommunications and Media and Entertainment companies. I will be doing sessions on Personalized...

Published Thu, Oct 1 2009 5:00 AM by Patrick Husting

Filed under: PerformancePoint Server, Microsoft, SharePoint, Excel, Marketing, Conference, PushBI

1 2 Next >

Browse by Tags

Blogs

Syndication

Recent Posts

Tags

Microsoft Business Intelligence

SharePoint Links

SQL Server

Microsoft Office Blogs

Archives