Pro Tips and Minimum Requirements

Minimum Non-negotiable requirements and Pro Tips while working on Power BI in DataRoars:

1. Formatting, spellings, and data verifications, should be perfect. Take time to meet this requirement, no matter the delay.

   
   

   1. Color Formatting - Blog Available

   2. Cover Page Format and Design - Blog Available

   3. Dashboard Page Design - Blog Available

2. Add the letter "Dim - " in front of the Dimensional table. So that it places all the Dim tables below for handy-navigation.

   1. Do likewise for Fact tables - "Fact". This step also helps in clarity.
      

      
      

3. Always think automation and avoid redundancy. Particularly while loading data from similar table or a common location.

   1. Leverage Reference tables over Duplicate tables
      

4. Always think of a way to connect the dates to the Dates Table.

   1. Make it a rule, to always start a new dashboard with a Calendar Table.
      

5. Modelling (Relationship) Section:

   1. Remove Auto-detect in Settings.

   2. All Tables tab. Don't use.

   3. Always use Layouts.

   4. Create multiple layouts for each area of the total dashboard as you see fit.

      1. This helps in great traceback and easy to follow-back the work

   5. Multi-to-multi, not allowed. Special permission needs to be taken from your Manager.

      1. In general, out of 100 projects, you might need it only 1-2 times.

      2. Create bridge tables to tackle this problem.