avising
Excel to Power BI Webinar Recording and a Call for Your Votes!
By Avi Singh [Twitter] Friends, it was a joy again to host our free monthly webinar Excel to Power...
Author: Anonymous Date: 08/27/2015
Power BI Desktop Now Converts Power Pivot Workbooks
Post by Rob Collie Another Excellent Step: Power BI Desktop Now Converts Excel Power Pivot...
Author: Anonymous Date: 08/25/2015
Quick Poll on Data Nerd “Art”
Post by Rob Collie No, We’re Not Opening a Store… Not any time soon anyway. if we do any...
Author: Anonymous Date: 08/21/2015
Power BI Desktop New Feature: Bi-Directional Relationships!
Guest Post by Andrew Todd Intro by Avi: We’ve been excited about all the new functionality that...
Author: Anonymous Date: 08/19/2015
Grab Bag: Job Opps, Sold Out in Indy, and a Vibrant Power BI Discussion
Post by Rob Collie Four quick topics today: Mini-application for for PowerPivotPro jobs Specific job...
Author: Anonymous Date: 08/18/2015
Free Webinar: Excel to Power BI, Tue Aug 18
By Avi Singh [Twitter] Friends,We’ll be hosting our monthly “Excel to Power BI” Webinar on Aug 18....
Author: Anonymous Date: 08/13/2015
Building Datazen Dashboards from Existing Power Pivot Models
Guest Post by Andrew Todd Build awesome dashboards for mobile and desktop using Datazen Datazen is a...
Author: Anonymous Date: 08/11/2015
Transitioning from Excel Power Pivot/Query to Power BI Desktop: A Remarkably Smooth Road
Post by Rob Collie Can Excel Pros Make the Jump? For 5+ years, Excel was the ONLY “place” where we...
Author: Anonymous Date: 08/11/2015
Nested SUMX or DAX Query?
by Matt Allington I was helping a friend out recently with an interesting problem. It all started...
Author: Anonymous Date: 08/06/2015
So Your Detailed/Flat Pivot is Slow and Doesn’t Sort Properly? Try Text Measures!
Post by Rob Collie Does Your Pivot Look Like This? Does its Slow make you Sad? Time for...
Author: Anonymous Date: 08/04/2015
Power BI Desktop (Designer) vs. Excel: Rematch
By Avi Singh [Twitter] In our last webinar the #1 question and confusion seemed to be around Excel...
Author: Anonymous Date: 07/29/2015
Are Your Official Data Tools an “Arranged Marriage?”
Post by Rob Collie A Recent Trip to the Hospital Highlighted the Folly of The Way Things Work That...
Author: Anonymous Date: 07/28/2015
Webinar Recording and Online Class Aug 3-4
By Avi Singh [Twitter] Friends, it was a joy again to host our free webinar Excel to Power BI. As...
Author: Anonymous Date: 07/26/2015
Connecting to an Oracle Database from Power Pivot
Guest Post by Andrew Todd Intro by Avi: Andrew has been a part of PowerPivotPro family for a while...
Author: Anonymous Date: 07/22/2015
Excel 2016: Ten Heartwarming Improvements
Post by Rob Collie Seriously, I Want to Hug the Computer and Every Software Engineer in Redmond...
Author: Anonymous Date: 07/21/2015
RANKX with Ascending Order to Show Lowest Quotes by Vendors
By Avi Singh [Twitter] This post is based on a query that I got in our monthly Q&A session held...
Author: Anonymous Date: 07/15/2015
Summer Fun at PowerPivotPro Free Webinar: Jul 22
By Avi Singh [Twitter] It has been a busy summer. My first summer working from home. And with my...
Author: Anonymous Date: 07/13/2015
Consolidated Worksheets with Power Query
by Matt Allington The more I use Power Query, the more I want to use Power Query – and of course the...
Author: Anonymous Date: 07/09/2015
Power BI Designer vs. Excel: What’s Microsoft Up To?
Post by Rob Collie This is Power BI Designer, a New Product from Microsoft, and It’s Relevant to ALL...
Author: Anonymous Date: 07/07/2015
Power Query Training: From Zero to [M]ax
Post by Rob Collie I’ve known Ken Puls and Miguel Escobar for many years now. They’ve been “in” on...
Author: Anonymous Date: 07/06/2015
A Hello Heard Around the World
By Avi Singh [Twitter] “Hello Everybody…” With those words, Rob opened the very first blog post on...
Author: Anonymous Date: 07/01/2015
2-Day Class in Indianapolis, Aug 25-26
Post by Rob Collie Two Days in Indy to Make You a (Happy) Data Rockstar Hey folks, I will be...
Author: Anonymous Date: 06/30/2015
Cycle Plots Show You Data Insights using Power Pivot
By Avi Singh [Twitter] If you want to look for trends based on weekday (Sunday…Saturday) or...
Author: Anonymous Date: 06/24/2015
Counting Overlapping/Shared Twitter, Facebook, Instagram, etc. Followers
Post by Rob Collie From Last Week’s Client Work Last week a client asked us to solve a somewhat...
Author: Anonymous Date: 06/23/2015
No More Apologies: Excel is the World’s Best Data Tool, Period.
Post by Rob Collie NASA JPL is Using Modern Excel to Perform Financial Analysis On TheirSpace...
Author: Anonymous Date: 06/15/2015
Time to revisit the Power Pivot Import Wizard
by Matt Allington I have learnt a lot over the last year working full time as a Power Pivot...
Author: Anonymous Date: 06/11/2015
RANKX-apalooza: Within and Across Groups, With Filters, Etc.
Post by Rob Collie One from the Reference Stacks I sometimes find RANKX() a bit perplexing. So...
Author: Anonymous Date: 06/09/2015
Power BI Jun 2nd Webinar Recording Available
By Avi Singh [Twitter] Thanks to all, who attended our Power BI Webinar on Jun 2nd. We had 400+...
Author: Anonymous Date: 06/05/2015
Data Nirvana: Power Pivot, OData, and Acumatica ERP
Guest Post By: Tim Rodman There is finally an ERP product that gets it, that embraces Power Pivot,...
Author: Anonymous Date: 06/03/2015
A New Take on “Data Quality?”
Post by Rob Collie Bad Data DOES Lead to Bad Results. But Good Data Can STILL Lead to Bad...
Author: Anonymous Date: 06/02/2015
Last Chance to register for Power BI Webinar, Tue Jun 2nd
Are you… Confused by all the terms and acronyms around Power BI? Wondering how all the pieces fit...
Author: Anonymous Date: 05/31/2015
Dear Accountants: PowerPivot is your friend!
Guest Post by: Mike Griffin Intro by Avi: Power Pivot and Power BI tools can be used to transform BI...
Author: Anonymous Date: 05/28/2015
Some Good Power Pivot / Power BI Computers
Post by Rob Collie A Lot More Work Than Expected! Last month I posted a survey of computer...
Author: Anonymous Date: 05/26/2015
Red Nose Day Special: 24 Distinctive Ways to Die
By Avi Singh [Twitter] Folks, May 21st is being celebrated as Red Nose Day across USA. Goal is to...
Author: Anonymous Date: 05/21/2015
Dear Accountants: PowerPivot is your friend!
Introduction: Accountants are NOT typically data GEEKS Accounting related problems open doors to a...
Author: Anonymous Date: 05/20/2015
Grab Bag of Fun
Post by Rob Collie Assortment of Quick and Fun Topics I keep something called Ye Olde OneNote List...
Author: Anonymous Date: 05/19/2015
Power Pivot Online Class Jun 8-9: Join the Party
By Avi Singh [Twitter] Last online class we hit an important milestone where we had our first...
Author: Anonymous Date: 05/14/2015
Power Query Super Charges the Internet
by Matt Allington I guess most of the readers of PowerPivotPro.com will already have a pretty good...
Author: Anonymous Date: 05/14/2015
Datazen = Beautiful Mobile Dashboards to Make Power Pivot Shine
Post by Rob Collie and Chris Finlan Datazen (The Latest Addition to Microsoft’s Suite of BI Tools)...
Author: Anonymous Date: 05/11/2015
Free Webinar: How to Build BI Solution Using Power BI
By Avi Singh [Twitter] Friends, Rob made a joke in one of his classes, that “Microsoft gives you the...
Author: Anonymous Date: 05/10/2015
Harness Power Query to Gain Competitive Analysis Insights from LinkedIn
Guest Post by Gil Raviv Intro by Avi: Many experts had proclaimed LongForm Journalism was headed...
Author: Anonymous Date: 05/06/2015
Our Road Ahead
Post by Rob Collie If you believe in redemptionI’m calling to you from another dimension -The...
Author: Anonymous Date: 05/05/2015
Secret Pot Roast Recipe: Power Query vs. VBA Macros
Guest Post by Willem van Dijk Intro by Avi: I have never met Willem van Dijk in person, but in my...
Author: Anonymous Date: 04/29/2015
Where’s Rob?
Post by Rob Collie Can You Spot the Power Pivot Blogger In this Picture? A Little Scarce… Last week...
Author: Anonymous Date: 04/27/2015
Just around the corner: May 4-5 Online Power Pivot Class
Friends, the goal of our Instructor-Led Online class is to reach the folks, we are unable to reach...
Author: Anonymous Date: 04/26/2015
VLOOKUP better than Relationships? Hell must have frozen over
By Dany Hoter We always think about a data model with multiple tables and relationships between them...
Author: Anonymous Date: 04/22/2015
In-Person 2-Day Class, May 12-13, Cleveland
Post by Rob Collie Hey folks, just a quick reminder that I’m teaching a class next month here in...
Author: Anonymous Date: 04/16/2015
Jump between pivots with context
by Matt Allington Today I am sharing a trick that I have used a number of times for clients – it...
Author: Anonymous Date: 04/16/2015
Is Your DAX/PowerPivot/Power BI Computer FAST?
Post by Rob Collie Looking for the Fastest Desktops, Laptops, Tablets, and Servers! “What’s a good...
Author: Anonymous Date: 04/14/2015
“Beta Test” the New Reference Card?
Post by Rob Collie RefCard Pt 2: Captures/Condenses Important Tips & Fundamentals from Our Years...
Author: Anonymous Date: 04/07/2015