avising
Power Query and Fixed-width M(agic)!
Intro by Avi: We know that Power Pivot and Power Query are extremely useful tools in the Finance and...
Date: 02/29/2016
Job Opportunities in Seattle Area!
Join the PowerPivotPro Team! As part of our growth process, we at PowerPivotPro are pleased to say...
Date: 02/29/2016
List.Generate(): Create Tables from Thin Air in Power BI with M!
Announcement: Friends, short notice, but in about 2 hours, I (Avi) will be presenting in...
Date: 02/25/2016
Data Modeling for Power Pivot and Power BI
What if I told you, there was one key skill, that has set me head and shoulders above the Excel...
Date: 02/15/2016
Sort Your Data on Load for Improved Compression
My last 2 blog posts have been about data compression – that theme continues today. In December I...
Date: 02/09/2016
For Real This Time: Show Barnes & Noble that Power Pivot and Power BI are Important!
Sunday, Feb 7th in a Local B&N: That Silver/Grey Spined Book is Ours! OK, for real, B&N has...
Date: 02/08/2016
Oh Em Gee: Embedded Power BI Dashboard, Google Analytics, Real-Time?
I Bet You Think This is a Picture, Don’t You? Yeah, this is the place in most posts where you will...
Date: 02/04/2016
Upcoming In-Person Class Schedule, March-May
Upcoming Two-Day Classes in DC, Seattle (Consecutive with MDIS), Philly, and Indy – Plus a 1-Day...
Date: 02/01/2016
MS Roadmap: The Good, the Bad, and the Ugly
Yeah I’m a Bit Slow… Back in October, Microsoft released a roadmap blogpost detailing plans and...
Date: 01/25/2016
B&N Does NOT Have the Books Yet + A CIA Story
First of all, please disregard (for now) the earlier post about buying our 2nd edition at Barnes and...
Date: 01/22/2016
Show Barnes & Noble that Power Pivot is a Monster!
Earlier this month we had a conversation with the “Product Mix” department at Barnes and Noble (the...
Date: 01/21/2016
Year to Date in Previous/Prior Year
YTD is easy with “standard” calendars, but the previous year’s equivalent is a non-obvious formula....
Date: 01/19/2016
Start 2016 By Meeting Us at Upcoming Conferences!
Hi folks! I hope everyone got some rest over the holidays, because 2016 is on like Donkey Kong....
Date: 01/12/2016
Restructure Your Data Table for Improved Compression
I was relaxing during my vacation thinking some more about column compression in Power Pivot. One...
Date: 01/05/2016
Holiday Gift! Print Edition Available & Signup for Free Book Discussion Webinar
Our first edition book has been the number one selling Power Pivot book for a long time. Too long...
Date: 12/21/2015
Quickbooks Analysis via QQube!
Power BI Desktop View of Our Clients by State (Map) and Breakdown by How We Help Them (TreeMap)...
Date: 12/15/2015
Compression with Power Pivot
I have read a lot about how good Power Pivot compression is over the last couple of years, and I...
Date: 12/08/2015
BI for Everyone: Tear Down the Wall Between IT and Business
President Reagan in his famous “Tear down this wall” address, asked for the Berlin wall to be...
Date: 12/01/2015
Happy Thanksgiving! Enroll in our Online Course
There are two kinds of people in this world (okay, the two that we’re rooting for ) Those who have...
Date: 11/26/2015
Break your DAX Problem into Manageable Parts
One of the concepts I discuss in my new book Learn to Write DAX, is that you should break your DAX...
Date: 11/26/2015
Gear Up for Black Friday Sale at PowerPivotPro
This Thanksgiving there are many things we are thankful for. This has been our busiest year ever....
Date: 11/19/2015
GFITW Strikes Again! Another Power Pivot Training Exercise
Me and Rob were discussing a chapter from our new book: Chapter 25 – Time Intelligence with...
Date: 11/18/2015
2nd Edition is Here: Get the eBook Today!
Buy and Download from MrExcel.com right now If you’re ready to get started, go here and buy your...
Date: 11/16/2015
Free Power BI Webinar on Tue Nov 17
Our monthly Power BI webinar is on Tue Nov 17. Go ahead and register now. We’ve been cranking on our...
Date: 11/12/2015
Foreword and Forward: Excerpt from Second Edition
Hey, yeah. I’ve been bad about posting lately. Lots of travel, AND working on the final edits to...
Date: 11/10/2015
(SOLUTION) Real World Exercise using Power Pivot, Power Query
The Problem We had presented you with the real world exercise, which you could solve using Power...
Date: 11/05/2015
The High Cost of Poor Equipment
by Matt Allington Over the last 12 months I have engaged with may people from lots of different...
Date: 10/29/2015
What Versions of Office 2016 Contain Power Pivot?
Long Overdue Post! You Want This, But What Versions Have It? Versions of Office 365 that DO Contain...
Date: 10/27/2015
Power BI at Beauty Pageant: An Exercise for Beginners
I have worked with NASA, NBC Universal and many other top companies since joining PowerPivotPro. But...
Date: 10/22/2015
Giving Back: “Steal” this Reference Card!
A long time coming… The Finalized 8-Page “Reference Card V2” – Download it for Free Below Yes, this...
Date: 10/13/2015
Power Pivot, Power BI and Last Chances
In my webinars you would often hear me say that Power Pivot is the ♥heart♥ of Power BI. Below is the...
Date: 10/07/2015
Power BI Sep 22 Webinar Recording and Signups
Our next Excel to Power BI free webinar would be on Oct 20th. Click to register. Along with Power BI...
Date: 10/06/2015
Interview with Kamal Hathi of Microsoft, plus “AMA!”
Director of Product Management, Microsoft BI (At left: the many faces of Kamal Hathi: 1 –...
Date: 10/05/2015
Bring Rob Home! Last Few Days to Preorder Power Pivot Book
Friends, we are in the final days of our crowd funding campaign. Help us make a final surge and...
Date: 10/04/2015
Facelift!
Well folks it’s been nearly six years since we launched PowerPivotPro.com, and we were long overdue...
Date: 10/02/2015
Share and Refresh Power Query with Local Links
By Matt Allington The concept of parameter tables in Power Query will be familiar to some and new to...
Date: 10/01/2015
Power BI / Power Pivot Class Date Change for Indy
Post by Rob Collie Hi folks, just a quick note: we are moving the dates for our Indy class to...
Date: 09/30/2015
Mini Post #3: Cases of Books at 50% Off
Post by Rob Collie Everyone Wins in this Deal! Last week, one of our clients (The Wolf, actually)...
Date: 09/29/2015
Mini-Post 2 of 3: Power BI Desktop Loads 2016 Files
Post by Rob Collie All I Did Was Import my Excel 2016 Power Pivot Workbook(Then Create the Chart)...
Date: 09/29/2015
Mini-Post 1 of 3: We finally “sold out” to Microsoft
Post by Rob Collie But in a Good Way… The Microsoft Power BI team just purchased the ad slot on the...
Date: 09/29/2015
Power BI and the Trajectory of Your Life
By Avi Singh [Twitter] At a recent client visit, I found myself thinking of trajectories. A small...
Date: 09/25/2015
Complex Customer Cohort Retention Using PRODUCTX
Post by Rob Collie First, a Few Quick Updates… 1) Just a reminder that enrollments are open for the...
Date: 09/22/2015
Free Webinar: Excel to Power BI, Tue Sep 22 with a Special Guest
By Avi Singh [Twitter] Boy, time flies when you’re having so much Power BI fun. Our monthly webinar...
Date: 09/21/2015
Quick 1-question poll: heard of Alchemy?
Post by Rob Collie View Poll The post Quick 1-question poll: heard of Alchemy? appeared first on...
Date: 09/17/2015
Power Query as an SSIS Alternative
By Matt Allington One of the many things I love about Power Pivot and Power Query is that these...
Date: 09/16/2015
Some “Biz,” Then Reflection on Connection
Post by Rob Collie Some Obligatory “Biz” Stuff Today, Then Something “Deeper” I find myself “stuck”...
Date: 09/15/2015
Power Pivot/Power BI Job Opportunity in Seattle Area
Is this you? We have been working through the applicants who filled out our Mini-Application Form...
Date: 09/13/2015
Preorder 2nd Edition of our DAX Book, Help us Print in Color, Get Cool Perks :)
-Post by Rob Collie Bill’s New Book in Color, DAX 1st Edition in B&W – Which is Easier to Read?...
Date: 09/10/2015
Two Tricks to Make Your Cube Formula Scorecards Drama-Free!
Guest Post by Andrew Todd Cube Formulas: Ultimate flexibility for your reports but lots of drama to...
Date: 09/02/2015
California Power Pivot / Power BI Pro for Hire
Post by Rob Collie Solid Analyst / Data Modeler / Dashboard Dev Available Immediately A few months...
Date: 08/31/2015