Welcome Power BI User Group PUG Chicago Data

Welcome! Power BI User Group (PUG) Chicago

Data Modeling 101 Power Query, Relationships and Star Schemas Gil Raviv Microsoft MVP, Avanade, Data. Chant. com

Welcome to Data Modeling - 101 Gil Raviv is a Microsoft MVP, Analytics Group Manager at Avanade, and a Power BI blogger Data. Chant. com. As a former Senior Program Manager on the Microsoft Excel Product team, Gil led the design and integration of Power Query as the next-generation Get-Data technology in Excel 2016. About Avanade We transform Businesses for the Digital Era. Founded in 2000 as a joint venture between Accenture and Microsoft $2. 4 B Sales 29, 000 Professionals 1, 200+ Clients worldwide 46% Of Global 500 companies as clients

Data Modeling 101 • In this session we will learn how to prepare the most common data patterns for analysis • Will build relationships and star schemas which are the a cornerstone for good modeling • You’ll learn how apply the Query Editor (in Power BI and Excel) without any code, to speed up your time to insight • The Query Editor (AKA Power Query) – Your New Friend

Session Agenda • The endgame • Demo - Append from a folder • Fact Tables, Lookup Tables and Relationships • Append multiple worksheets • Unpivot • Pitfalls • Multiple Fact Tables • Query Functions & Iterations

The Endgame = Better, Faster, More Insights Untapped Data

Appending CSVs from a folder + Lookup tables Species Planets

Multiple Fact Tables Actual Sales Date Category ID Forecast Product Sale Category Each category: Actual / Forecast Month

Category Multiple Fact Tables Date Month Category ID Forecast Actual Sales Product Category Product Date Category ID Sale Category ID Month Date

Functions & Page Iterations

What’s Next? Recommended Books

Thank you for Attending! Don’t forget to join your local PUG to enjoy year-round networking and learning. www. pbiusergroup. com/chicagoland www. pbiusergroup. com/milwaukee