Category Archives: Excel

I’ll take “Products that start with Power”, Alex

FYI: Geoflow (see Geoflow Preview for Excel 2013) is now called Power Map, and Data Explorer (see Microsoft Data Explorer) is now called Power Query. Microsoft Power Query for Excel has reached General Availability and is now available for download. More info: “Data … Continue reading

Posted in Excel, Power Map, Power Query, SQLServerPedia Syndication | Leave a comment

Geoflow Preview for Excel 2013

Last week at the PASS Business Analytics Conference in Chicago, Microsoft disclosed a public preview of GeoFlow for Excel (download).  GeoFlow is a 3D visualization tool for mapping, exploring and interacting with both geographic and chronological data, providing users with a new … Continue reading

Posted in Excel, SQLServerPedia Syndication | 3 Comments

Microsoft BI tools: How they use data sources

A quick list of how each of these Microsoft BI tools handles the two data sources “SQL Server” (relational-based) and “Analysis Services” (cubed-based, which can be the multidimensional model or the tabular model).  Note that any reporting tool that supports the … Continue reading

Posted in Excel, PerformancePoint, Power Pivot, Power View/Project Crescent, Report Builder, SQLServerPedia Syndication, SSRS | 1 Comment

Microsoft Data Explorer/Power Query

UPDATE 10/21/13: Data Explorer is now called Power Query (download). Data Explorer (download), which I first mentioned in my blog about PASS Summit 2011 (SQL Server 2012 and other PASS announcements), has finally taken the next step and is now … Continue reading

Posted in Excel, Power Query, SQLServerPedia Syndication | 5 Comments

Excel 2013 and BI

On July 16, 2012, Office 2013 Preview was released to the public (download).  Excel 2013 now includes a lot of the SQL Server BI components directly in the initial install, as well as enhancements made to the business intelligence (BI) capabilities … Continue reading

Posted in Business Intelligence, Excel, SQLServerPedia Syndication | Leave a comment

End-User Microsoft BI Tools – Clearing up the confusion

Given two types of underlying data sources (a data warehouse and a OLAP cube built from the data warehouse) there are many different possible presentation layers (client tools) that serve different user communities with varying usage profiles.  There is a … Continue reading

Posted in Excel, PerformancePoint, Power Pivot, Power View/Project Crescent, ProClarity, Report Builder, SQLServerPedia Syndication, SSRS, White Paper | 2 Comments