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

Our next meeting

Next Meeting

Thursday,

July

20

Just Enough Database Theory for Power BI

  • Online @ http://excelbivc.sqlpass.org/ (map)
  • 12:00 - 13:00 Central Daylight Time
  • Language: English

Featured Presentation:

Just Enough Database Theory for PowerPivot (Power BI)

Eugene Meidinger, BI Consultant Lantek

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!

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

Back to Top