Latest Enterprise DNA Initiatives

Challenge 13 - Acing Documentation from Jose

Here’s Jose’s entry for Power BI Challenge 13. @jbressan, would you like to share how you built this dashboard and what your inspiration is in building it?


Here’s the link to the report:

To learn about the real-life scenario presented for the challenge, be sure to click on the image below.


For this challenge my approach was to find how I can collect the information fast and easy. I did it with 3 advanced scripts that can be run with Tabular Editor Advanced Scripting and 1 DMV that can be run with DAX Studio

Data Dictionary
Tool: Tabular Editor
Advanced Scripting

Tool: Tabular Editor
Advanced Scripting

Best Practices Analyzer (BPA)
Tool: Tabular Editor
Advanced Scripting

Save the result from Tabular Editor: Advanced Scripting

  • Click bottom Copy to clipboard and paste on an Excel File

Tool: DAX Studio

Save the result from Dax Studio

  • Change the output to an Excel File.

For the design aspect I wanted to keep basic. I used a vertical navbar with 4 options to handle the navigation between pages.

  • Tools: Power Point from Microsoft.
  • Icons: Syncfusion Metro Studio

Thanks @haroonali1000 for this challenge

Jose Bressan



Awesome job! Thanks very much for the detailed report. I’ve been trying to figure out how to automate the dependency mapping for my own documentation, and this is a really simple, elegant solution. :clap: :clap:

  • Brian
1 Like