Today Microsoft officially released the new development tool for Power BI called Power BI Desktop. First of all let me share my excitement in what
Tag: Excel
Power Map Enhancements and Presentation
Power Map for Excel 2013 has had some recent enhancements that are worth noting. You can download the latest Power Map install file here. This
Introduction to Power Query Q&A
Thanks everyone for attending my free webinar on Introduction to Power Query on August, 27, 2013. If you were not able join for the live
Whitepaper: Building Self-Service BI Solutions with Power Query
Through Self-Service BI, business units can personalize Business Intelligence to their needs and solve problems at a much faster rate than any traditional BI solution.
Extracting Data From Multiple Files with Power Query
In this post I’d like to demonstrate another way Power Query can solve simple data extraction problems without much time or effort. If you’re still
Using Parameters in Power Query Extracts
Introduction By now you have likely heard a little about Power Query (formally known as Data Explorer). While you may have heard of the tool
OLAP PivotTable Extensions Update
OLAP PivotTable Extensions is a really cool free add-in for Excel that’s been around for quite a while now. It allows you to have some
Using Excel Macro (.xlsm) Enabled Files in SSIS
Recently while working for a client that was running SQL Server 2008 R2 I was tasked with loading an Excel Macro (.xlsm) enabled workbook. If
Choosing the Right Microsoft Reporting Technology Part 2: Excel
This post is a continuation of a series started to help you understand each of the Microsoft presentation layer tools purpose and when you should
Using Excel 2007 in SSIS 2005
Many companies are not in a rush to upgrade their SQL Servers because of the enormous cost to upgrade. This results in the majority of