Tag: Data Modeling

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

Power BI Query Parameters: Optimizing Tables

Query parameters are a really strong feature in Power BI. There are many places that you can implement filters in Power BI, but on some occasions, it’s better to do this at the query layer versus the report level. You might want to create filters at the query level if you have massive tables from

Continue reading