avising
Protecting time intelligence expressions against non-consecutive range of days
By Dany Hoter (Download file here to follow along). Time intelligence functions are some of the most...
Author: Anonymous Date: 04/02/2015
The Diabolical Genius of “SWITCH TRUE”
Post by Rob Collie Did Someone Say Deliberately “Misuse” a DAX Function for Our Benefit? We’re...
Author: Anonymous Date: 03/31/2015
Best way to learn Power Pivot: get over analysis paralysis
I have loved reading ever since I was a young kid. In my adult life though, reading fell on the...
Author: Anonymous Date: 03/29/2015
Power Pivot and Basketball Superstars: Many-to-Many and USERELATIONSHIP
By Avi Singh [Twitter] Friends at a company play pick-up basketball during their lunch hour. Since...
Author: Anonymous Date: 03/26/2015
Power Update Adds Email Notifications, Macro Support, and 100% Free Version
Post by Rob Collie Autorefreshes Your Power Pivot Workbook as Frequently as Desired, Auto-Publishes...
Author: Anonymous Date: 03/23/2015
Course Prep: Excel 2010 and Excel 2013 Differences
By Avi Singh Matt Allington, our friend from down under, had suggested the idea that we make some...
Author: Anonymous Date: 03/19/2015
Create a 445 Calender using Power Query
by Matt Allington In my last blog on PowerPivotPro.com I showed how easy it is to create a standard...
Author: Anonymous Date: 03/19/2015
Thanks for attending the beeping webinar: Q&A From Webinar
By Avi Singh Folks, thanks for attending our webinar. We did have a full house with 200 attendees....
Author: Anonymous Date: 03/18/2015
Schrodinger’s Pivot, or Why CALCULATE() Should Be Your Favorite Function EVER.
Post by Rob Collie In the Classic Physics Thought Experiment, Schrodinger Hypothesized a Cat That...
Author: Anonymous Date: 03/17/2015
Excel Users Everywhere: Free PowerPivot Webinar Tomorrow Tue Mar 17th
By Avi Singh Excel users are everywhere! Even at Toastmasters – a nonprofit educational...
Author: Anonymous Date: 03/15/2015
Creating a Histogram with a User Defined Number of Buckets
By Dany Hoter Intro by Avi: I have often been asked, about ways to provide an “input” to the Power...
Author: Anonymous Date: 03/12/2015
Listen to Me Interview MrExcel (Bill Jelen), and See Us Both at the PASS Biz Analytics Conference
Post by Rob Collie I Interviewed Bill Via Phone – Me in the Arctic of Ohio, Bill in his Winter HQ...
Author: Anonymous Date: 03/10/2015
Excel to Power Pivot Webinar Countdown – in 10 days
By Avi Singh Happy Friday! Our next webinar is coming up in about 10 days from now, on Tue Mar 17th....
Author: Anonymous Date: 03/05/2015
How to Compare the Current Row to the Previous Row in Power Pivot
By Dany Hoter Business Case I was approached with a business question from the car fleet manager in...
Author: Anonymous Date: 03/04/2015
PowerPivotPro Expands to Europe/Africa/Asia, Welcomes Dany Hoter!
Post by Rob Collie My Business Intelligence “Yoda” Figure Joins the Team! Master and Student, on a...
Author: Anonymous Date: 03/04/2015
Interview with Chris Finlan of Microsoft
Post by Rob Collie A Kindred Spirit Revealed! Me and Chris Last Week at the Microsoft Offices in...
Author: Anonymous Date: 03/02/2015
Power Pivot Blitzkrieg: Webinar, Seattle Class, Online Class
By Avi Singh [Twitter] My New Year’s resolution to help 1000 people start using Power Pivot,...
Author: Anonymous Date: 02/26/2015
Power Pivot to SSAS Tabular: Automatically Publish Excel Workbooks
By Avi Singh [Twitter] This article is Part II of a series.<<Read Part I: Power Pivot to...
Author: Anonymous Date: 02/26/2015
Create a Custom Calendar in Power Query
by Matt Allington In this post, I am going to show you how simple it is to create a custom calendar...
Author: Anonymous Date: 02/19/2015
Power Pivot to SSAS Tabular in less than 30 minutes
By Avi Singh [Twitter] A key milestone in my Power Pivot journey (read or watch) was when I let my...
Author: Anonymous Date: 02/17/2015
Supporting Files from “Power Pivot Alchemy”
Post by Rob Collie Click to Download the Workbooks and Data Sources Apologies for the Delay No...
Author: Anonymous Date: 02/11/2015
Tales from the Trenches: My personal experience with Power Update (by Tim Rodman)
Guest Post by Tim Rodman, currently blogging about reporting in Acumatica ERP @...
Author: Anonymous Date: 02/10/2015
Introducing Power Update!
Post by Rob Collie A brand-new software utility designed from the ground up asa...
Author: Anonymous Date: 02/03/2015
Upcoming Webinar at PASS BA Marathon Tue Feb 3rd
By Avi Singh [Twitter] Thanks to all those who attended our past Excel to Power Pivot webinar on...
Author: Anonymous Date: 02/01/2015
Dynamic Age Calculation Using Measures
by Matt Allington I was recently helping a forum member at https://powerpivotforum.com.au with a...
Author: Anonymous Date: 01/29/2015
Power BI, YouTube for Workbooks: More Affordable!
Post by Rob Collie $9.99 Per User Per Month Starting Feb 1! Wow, this is awesome. What I have...
Author: Anonymous Date: 01/27/2015
Live Class, Online, Online U… Which is Right For You?
By Avi Singh Few of you have inquired about the learning options now available. This may help you...
Author: Anonymous Date: 01/26/2015
SEA vs GB NFC Championship Game: Visualized in Power BI Dashboard
By Avi Singh [Twitter] For today’s post, I get to combine two of my passions – Seahawks...
Author: Anonymous Date: 01/22/2015
The Only “Requirements Doc” You Will Ever Need
Post by Rob Collie One of Our Clients Sent This to us Before a Consult. It is Perfection. The...
Author: Anonymous Date: 01/20/2015
Reminder: Webinar – Excel to Power Pivot Jan 20th (mini-post)
Folks, our Webinar: Excel to Power Pivot, is coming up tomorrow Tuesday Jan 20th (click to add to...
Author: Anonymous Date: 01/19/2015
Power Query for Excel: Combine multiple files of different file types
Guest Post by Miguel Escobar - Twitter | Youtube | Blog | Website Power Query...
Author: Anonymous Date: 01/14/2015
Power BI as Google Docs Antidote
“Help ME (Power BI)… Help YOU (Office).” Reviving the “Open Letter to MS” Tradition In...
Author: Anonymous Date: 01/13/2015
PowerPivot Live Online Class in January and New Year Resolutions
By Avi Singh [Twitter] We wish all the readers of PowerPivotPro a very happy new year. We wish that...
Author: Anonymous Date: 01/12/2015
Cleveland and D.C. In-Person Classes in February!
Post by Rob Collie One of Our 2014 Classes Washington D.C. Feb 24-25 and Cleveland Feb 17-18 ...
Author: Anonymous Date: 01/08/2015
Would You Like to Join Our Team in 2015?
Post by Rob Collie Do You Have the “Data Gene?” Know Your Way Around Power Pivot?We’re Looking...
Author: Anonymous Date: 01/05/2015
Mini-Post: Excel to Power Pivot, Webinar Jan 2015
by Avi Singh [Twitter] Pop quiz: For 2015, do you a) change nothing this year?b) Embark on a brand...
Author: Anonymous Date: 01/04/2015
See You in 2015!
Post by Rob Collie On Hiatus (from Blog Only) Until 2015 After 120+ published posts in 2014, we’re...
Author: Anonymous Date: 12/16/2014
Last Week’s Survey
Post by Rob Collie It’s 30 Seconds – We Promise! Hi folks, if you haven’t taken last week’s survey...
Author: Anonymous Date: 12/15/2014
SQL Date Tables in Power Pivot
Guest post by Thomas Allan Intro by Avi: As in Excel, in Power Pivot there are often many ways to...
Author: Anonymous Date: 12/11/2014
Help Us Design Our 2015 In-Person Class Schedule!
Post by Rob Collie Seattle? Cleveland? Elsewhere? Hi Folks, we’re already starting to plan our...
Author: Anonymous Date: 12/10/2014
Repeat Customers in DAX: Three Flavors
Post by Rob Collie In 2004, There Were 2,561 Customers Who Bought Something in the Southwest.But How...
Author: Anonymous Date: 12/09/2014
The Catalyst to Corporate Power Pivot Success
by Matt Allington Many businesses (dare I say most) are yet to get started with Power Pivot and Self...
Author: Anonymous Date: 12/04/2014
Black/White Decisions in a Greyscale World
Post by Rob Collie JACK RYAN: “…with them in the same place, the odds...
Author: Anonymous Date: 12/01/2014
Monday Mini-Post: Excel to Power Pivot Cross the Gap Webinar Dec 1st
By Avi Singh [Twitter] Happy Monday! We’ll be going light this week for Thanksgiving, but we have...
Author: Anonymous Date: 11/24/2014
Flat to Star Transformation using DAX Query
By Avi Singh [Twitter] As I have started working with clients around training/consulting, I am...
Author: Anonymous Date: 11/20/2014
Visualization Layers in Perspective: The Last Mile
Post by Rob Collie The Models We Build in Power Pivot are the Prime Movers. Visualization is...
Author: Anonymous Date: 11/18/2014
Power BI and Tableau: Best Friends Forever
By Avichal Singh [Twitter] Yes, you heard me right. I hear a lot of talk about “Power BI versus...
Author: Anonymous Date: 11/12/2014
Displaying Top N, Bottom N, and “All Others”
Post by Rob Collie If We Use Excel’s Built-In Top N Filter to See Our Top 1,000 Customers, It Hides...
Author: Anonymous Date: 11/11/2014
New Twist for Dynamic Segmentation: Variable Grain Control
By Avichal Singh [Twitter] Dynamic segmentation or banding has been covered in PowerPivotPro...
Author: Anonymous Date: 11/05/2014