The Excel BI Virtual Group offers training and support to individuals who use Excel.

News and Updates

The Conference for SQL Server & BI Professionals

Connect, Share & Learn at the largest conference for SQL Server & BI Professionals. Stay ahead of the curve with the most technical sessions, delivered by the world’s experts, and connect with 5,000 attendees from around the world. Join us in Seattle, WA, Oct. 30 – Nov 3, 2017.

Interested in presenting?    
Please contact us at


Just Enough Database Theory for Power BI

Thu, Jul 20 2017 12:00 Central Daylight Time

RSVP: None

Just Enough Database Theory for PowerPivot (Power BI) If you come from the Excel world, chances are you learned how to deal with data via trial and error. Not knowing basics concepts like cardinality and normal form can cause a whole suite of problems, such as duplicate rows or poor data compression. Even if you were trained on the fundamentals, it still never hurts to get a refresher now and again. This session will cover many of the fundamentals you might have learned in college: primary keys, cardinality, normal form, facts versus dimensions, etc. In each case, we will talk about how these concepts apply directly to working better with Power BI. We will show common mistakes and how to get around them, such as dealing with many-to-many relationships in Power BI. By the end of this session, you'll have just enough theory to put it into practice!

Eugene Meidinger

Eugene Meidinger has been working as a BI consultant at All Lines Technology for the past 6 years. He speaks SQL Saturdays and PASS Summit. He also leads the Pittsburgh Power BI User Group. He is certified in querying and administering SQL Server 2012.


Back to Top