Welcome to the Sample Chapter

Next Meeting

Wednesday,

April

12

Wellington Power BI Meetup

  • In-Person @ Trade Me Offices Wellington, , New Zealand (map)
  • 17:30 - 19:00 (UTC+12:00) Auckland, Wellington
  • Language: English

Power Query is a relatively new addition to Microsoft Excel that brings ETL to the self-service BI user's desktop.  In this level 200 session I cover the basics of Power Query and how it can be used for desktop BI before quickly moving on to demonstrate how you can use Power Query for more advanced scenarios that you may not have thought of before, including:

• Use Power Query as a data provider for traditional Excel Pivot Tables without using Power Pivot.

• Building a Power Pivot calendar table from scratch using pure Power Query steps.

• Add commentary to bank statements and make those comments "stick" using self-referencing tables.

• Using Power Query as an auditing and exception management tool

• Using Power Query as a pure ETL tool and exporting more than 1 m rows of transformed data to a file.

Featured Presentation:

Power Query is more than just a desktop BI ETL tool

Matt Allington, BI Professional, Microsoft MVP Excelerator BI

Power Query is a relatively new addition to Microsoft Excel that brings ETL to the self-service BI user's desktop. In this level 200 session I cover the basics of Power Query and how it can be used for desktop BI before quickly moving on to demonstrate how you can use Power Query for more advanced scenarios that you may not have thought of before, including: • Use Power Query as a data provider for traditional Excel Pivot Tables without using Power Pivot. • Building a Power Pivot calendar table from scratch using pure Power Query steps. • Add commentary to bank statements and make those comments "stick" using self-referencing tables. • Using Power Query as an auditing and exception management tool • Using Power Query as a pure ETL tool and exporting more than 1 m rows of transformed data to a file.

About Matt:
Matt is a BI Professional with over 30 years’ experience in the Consumer Packaged Goods industry. He has held senior job commercial and IT roles, always leveraging data to drive success. Matt was the BI Director for Asia Pacific at The Coca-Cola Company before leaving to set up his own consulting business in 2014. Matt is now the Principal Consultant at Excelerator BI and specialises in helping small, medium and large companies leverage Microsoft Excel, Power Pivot, Power BI and SharePoint to deliver rapid business value through Self Service Business Intelligence.

cage-aids
cage-aids
cage-aids
cage-aids