Skip to content
  • Twitter
  • Linkedin
  • Pinterest

Devin Knight

  • Home
  • Training
  • Services
  • About Me

Tag: Excel

Power BI Desktop: A Guide for Excel Users

July 24, 2015 devinknight

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

Continue reading

Power Map Enhancements and Presentation

September 20, 2013 devinknight

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

Continue reading

Introduction to Power Query Q&A

August 28, 2013 devinknight

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

Continue reading

Whitepaper: Building Self-Service BI Solutions with Power Query

August 14, 2013 devinknight

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.

Continue reading

Extracting Data From Multiple Files with Power Query

August 13, 2013 devinknight

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

Continue reading

Using Parameters in Power Query Extracts

August 7, 2013 devinknight

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

Continue reading

OLAP PivotTable Extensions Update

July 31, 2012 devinknight

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

Continue reading

Using Excel Macro (.xlsm) Enabled Files in SSIS

June 29, 2012 devinknight

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

Continue reading

Choosing the Right Microsoft Reporting Technology Part 2: Excel

March 6, 2012 devinknight

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

Continue reading

Using Excel 2007 in SSIS 2005

March 2, 2010 devinknight

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

Continue reading

Search

Devin Knight

SQL Server MVP

Follow me on Twitter

My Tweets

Categories

  • Azure (5)
  • Books (2)
  • Data Mining (1)
  • Excel (7)
  • MDX (7)
  • PerformancePoint (5)
  • Power Automate (17)
  • Power BI (12)
  • Power BI – Problem, Design, Solution (3)
  • Power BI Custom Visuals (118)
  • Power BI Interview Questions (3)
  • Power BI Monthly Digest (31)
  • Power BI Q&A (7)
  • Power Map (3)
  • Power Platform Quick Tips (4)
  • Power Query (13)
  • Power View (10)
  • Power Virtual Agents (4)
  • PowerApps (1)
  • PowerPivot (18)
  • Scripts (1)
  • Social (2)
  • Speaking (42)
  • SSAS (24)
  • SSIS (33)
  • SSRS (26)
  • T-SQL (5)
  • This Week in Data (16)
  • Training (2)
  • Uncategorized (1)
  • Visio (1)
  • Visual Studio (2)
  • Windows (1)

RSS Feed

RSS Feed RSS - Posts

Create a website or blog at WordPress.com
  • Follow Following
    • Devin Knight
    • Join 167 other followers
    • Already have a WordPress.com account? Log in now.
    • Devin Knight
    • Customize
    • Follow Following
    • Sign up
    • Log in
    • Report this content
    • View site in Reader
    • Manage subscriptions
    • Collapse this bar