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?

image

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.

power-bi-chal-1

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

Relationship
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

Dependency
Tool: DAX Studio
DMV View: DISCOVER_CALC_DEPENDENCY
select * from $SYSTEM.DISCOVER_CALC_DEPENDENCY

Save the result from Dax Studio

  • Change the output to an Excel File.

Design
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

3 Likes

@jose,

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