Tag: Data Modeling

Connecting Data Tables – Tips on Power BI Relationships

Now that I’ve discussed what data modeling is, it’s time to understand what Power BI relationships among different tables can do for your reports. Different data sources within your models need to have the right relationships to yield the right results. When you fail to understand the concept of these relationships, you will never get

Continue reading

Understanding What Data Modeling Is And Creating The Right Relationships

After having an extensive discussion about the query editor, it’s time to move all that data into a Power BI report through data modeling. Data modeling allows you to connect different data tables in your Power BI report by creating relationships between them. Fixing Relationships In The Core Data Model My core data model consists

Continue reading

Best Practices In Using The Q&A Feature In Power BI

The Q&A feature or the natural language feature is seriously one of the most incredible features within the Power BI suite.  In this tutorial, I showcase the potential of this feature and some of the most important things that you need to implement to get Q&A working. In fact, my personal view is that the

Continue reading

New vs Existing Customers – Advanced Analytics In Power BI

If you’re an online retailer or a high frequency sales operation, then understanding your customer base, like if they are new customers or existing customers, is a really high quality insight that you can achieve using advanced analytics in Power BI. You’ll want to dive into this type of analysis because you need to evaluate

Continue reading

Counting Customers Over Time Using DISTINCTCOUNT In Power BI

In this blog post, I’m going to run through how you can calculate how many customers you sell to through time using a few functions such as DISTINCTCOUNT inside of Power BI. There are actually a few ways you can calculate it, which is why I wanted to create a short tutorial on it to

Continue reading