View RSS Feed

The ExcelGuru (Ken Puls) Blog

This is where I share opinions and rants, test material, share site updates and stuff like that. If you like Beta software, this is a good place for you. If you don't, well... you may not want to try much of what I post here.

  1. PowerPivot - It sure would be nice if...

    I've been doing a lot of work with PowerPivot where I connect to databases. My normal development cycle is as follows:

    • Connect to a view or table, pulling in ALL columns
    • Work through my data scenario until I've worked out my logic and solve the issue I'm trying to solve
    • Cut the table/view query down to just the required columns
    • Add WHERE clauses to cut the data down to just the bare minimum I need
    • Deploy to my users

    By doing all this, I really focus on trying ...
    Tags: powerpivot
    PowerPivot , Excel