Gå til hovedinnhold

DAX and Data Modeling Power Hour: 1-Hr Workshop

Decisive Data

A one-hour discussion centered around working with you to determine the best solution or alternative for your DAX and/or data modeling challenge, utilizing Microsoft Power BI.

Are you a technical SME within your organization who has worked with DAX in the past, but want to up your game and improve how you can use Microsoft Power BI to come up with creative solutions?

Bring us your toughest DAX or Microsoft Power BI data modeling problem, and our experts will meet with you to discuss the complexities of your specific situation.

Decisive Data will provide best practices, specific recommendations, and example DAX that can solve your problems, utilizing Power BI.

Agenda

We will work with you to determine:

  • The best solution or alternatives for your DAX/data modeling challenge
  • How your data model design will make your query easier or more difficult to write
  • This includes a review of the relationships and granularity within your data model
  • How your report’s functionality and layout will affect the behavior of the DAX and therefore the results
  • This includes a review of query context
  • How the desire for dynamic results may change your approach
  • Determine whether a calculated measure or a calculated column is the best approach

Example DAX includes the following

Using functions such as:

  • CALCULATE
  • FILTER
  • KEEPFILTERS
  • Time intelligence
  • X-functions
  • ALL
  • And more…

Prerequisites

Please come prepared with your existing Power BI Dashboard or Report and Data Model to review.

Please bring a description of the measure you want to implement, including:

  • Business description of the metric
  • Technical description of the logic
https://gallery.azure.com/artifact/20151001/decisivedata.decisive_data_pbi_dax_and_data_modeling_power_hour.1.0.3/Artifacts/SampleImage/95d0d709-e9de-4230-967d-dd38eeabee7b.png
https://gallery.azure.com/artifact/20151001/decisivedata.decisive_data_pbi_dax_and_data_modeling_power_hour.1.0.3/Artifacts/SampleImage/95d0d709-e9de-4230-967d-dd38eeabee7b.png
https://gallery.azure.com/artifact/20151001/decisivedata.decisive_data_pbi_dax_and_data_modeling_power_hour.1.0.3/Artifacts/SampleImage/b8655e8c-bd80-4513-8b5f-45f40baf44dc.png
https://gallery.azure.com/artifact/20151001/decisivedata.decisive_data_pbi_dax_and_data_modeling_power_hour.1.0.3/Artifacts/SampleImage/e7945072-70c8-433d-8d01-7a92433ca136.png
https://gallery.azure.com/artifact/20151001/decisivedata.decisive_data_pbi_dax_and_data_modeling_power_hour.1.0.3/Artifacts/SampleImage/00c596e1-1cc9-42fc-b31f-596ad65dd200.png
https://gallery.azure.com/artifact/20151001/decisivedata.decisive_data_pbi_dax_and_data_modeling_power_hour.1.0.3/Artifacts/SampleImage/5de8714d-f223-4756-b6c2-e08a9647ab8a.PNG