Just Enough Database Theory for Power BI

Target Audience:

Power BI / PowerPivot users, preferably those that haven’t studied databases

Abstract:

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.

Additional Resources:

The following two tabs change content below.
Eugene is a Business Intelligence developer in the Pittsburgh area. He helps run the local Power BI user group.
Previous Post
Solving Power BI pain points with R
Next Post
Polybase In Action

1 Comment. Leave new

M A Srinivas
March 7, 2019 9:50 am

Awaiting this . Good Topic

Reply

Leave a Reply

Your email address will not be published. Required fields are marked *

Fill out this field
Fill out this field
Please enter a valid email address.

Menu