This is a group dedicated to the Modern Excel and Power BI users. For people that are using or aspiring to use Power BI or advanced features of Excel (PowerPivot/Power Query) in their day to day lives. We wanted to have a place where like minded individuals can share knowledge and stories about how they leverage these modern tools to provide reporting and analytics.
Topic: Q&A on Power BI
Speaker: Ed Hansberry
Ed will cover the following areas in his presentation:
• Beginning Power Query - Extract, Transform and Load
• Intermediate Power Query - including getting the most out of Query Folding with SQL Server and other relational databases
• Power BI Data Modeling 101 - this is an intro to the importance of the Star Schema, and has a little bit of Power Query and DAX showing how a good data model makes it easier get your Power BI Report up and running.