Announcing P3 Seattle / Northwest!

Published on: PowerPivotPro

Article by: Rob Collie

    If you were paying close attention to my article on the role of consulting firms in the self-service BI revolution, you may remember that we operate on a geographically-independent basis.  Since our services deliver rapid results at a much higher benefit-to-cost ratio than traditional BI, our clients don’t feel “stalked,” or like they are signing away their soul when they hire us.  As a result, we don’t need to be “wining and dining” them through a long sales cycle, nor do we need to “park” a team of consultants onsite at the client forever...

    Posted on May 31, 2017 .

    Dashboard in an Hour Webinar with Reid Havens

    Published on: Power BI Community

    Dashboard In An Hour is a high-level introduction to Power BI in only an hour.  You'll get experience in building a Power BI dashboard including.

    • How Power BI can turn your unrelated sources of data into coherent, visually immersive, and interactive insights.
    • To easily connect to your data sources, visualize (or discover) what’s important, and share that with anyone or everyone you want.
    Posted on May 24, 2017 .

    Power Query (M)agic Part 1: Always Have Good References

    Published on: PowerPivotPro

    Article By: Reid Havens

    P3 friends…for those of you in the know (and for those who aren’t), Power Query (or PQ for short) is one of the cornerstones of the Microsoft BI Suite. It’s a tool built into Excel 2016 and Power BI Desktop that allows us to extract our data (78 data connectors and GROWING), transform our data (it’s more than meets the eye), and finally load our data into a Data Model. Wait…so PQ extracts, transforms, and loads data? Those words spell out ETL as an initialism!

    Posted on May 23, 2017 .

    Using Power Update as a Time Machine for Excel (AND NOW Power BI Desktop) files!

    Published on: PowerPivotPro

    Article By: Reid Havens

      Many of you may know of our wonderful business partners over at PowerON. Among the services and software they offer is a powerful tool called Power Update that essentially automates the refresh (AND publishing!) of Excel AND Power BI Desktop files.

      Posted on May 11, 2017 .