Power BI

DAX Expression > DAX query > Vertipaq query. Test 1: Testing the Impact of USERELATIONSHIP() in a DAX Measure Does using USERELATIONSHIP() with inactive relationships slow down a DAX measure? I’m not sure so I thought I would test it out. To test this I will create a measure using the existing between my date… Read more: Testing Power BI DAX Measures Speed with DAX Studio

I’ll start with some references: Definitive Guide to DAX Book by Marco Russo and Alberto Ferrari (the definitive experts).The Guy in the Cube video on model refresh slow: Chat GPT (I don’t know who that is!)My own testing and experience and demo using Power BI model using data from the Contoso Retail data warehouse First… Read more: Analysing the Power BI Data Model to Improve Refresh Rates with DAX Studio

Power BI can be useful for displaying and storing survey results for your organization. In this example we build some data for the results of a fictitious Airline survey, using questions taken from a real online airport survey. The data was built in Excel with a sheet for questions and a sheet for answers. You… Read more: How to Build a Survey Results Report with Power BI

The Power BI KPI demo report is a demonstration of how a typical KPI report will look. The report uses data from the fictitious Microsoft Contoso Retail Datawarehouse which is stored in a SQL Server Database. I’ve simply renamed it to rn retail for demo purposes. View the Demo Report on Youtube: The report is… Read more: How to Build a KPI Report with Power BI

Most businesses will have sales and marketing departments as well as top-level C-Suite/director levels. They are all going to be interested in a bunch of similar reports from organization to organization. One of the most important reports, that sales and marketing teams are going to be interested in is:Who are our best customers? Top customers… Read more: How to Create a Power BI Top Customers Report