Challenge 13 - Acing Documentation from Jose

Challenge Updates
1

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

2

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

image
image1759×286 48.3 KB

Relationship
Tool: Tabular Editor
Advanced Scripting

image
image1722×215 34.2 KB

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

image
image1666×765 103 KB

Save the result from Tabular Editor: Advanced Scripting

image
image940×682 278 KB

  • 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

image
image1088×569 137 KB

  • 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
3

@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