Power BI / PowerPivot users, preferably those that haven’t studied databases
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 all into practice!
Why I Want to Present This Session:
A lot of data problems are from a lack of good fundamentals. The age of self-service BI means ushering in thousands, perhaps millions, of data workers who have never heard of a primary key before. This session is aimed at resolving that issue.
Latest posts by Eugene Meidinger (see all)
- SQL Server Health Checks - July 30, 2017
- Just Enough Database Theory for Power BI - June 15, 2017
- Keeping up with Technology: Drinking from the Firehose - June 2, 2017