Top Tips for DAX users - Power BI and Excels Power Pivot

Description

In this course, you will learn :

• Tips and tricks for improving your DAX skills in Power BI or Power Pivot.
• This is not a DAX course, but rather a collection of tips and tricks to help you improve your DAX and Power BI or Power Pivot skills.
• Modeling Tips
• Date table tricks
• Power BI tricks
• Shortcuts

Syllabus :

• Raw data and course activities
• Keep Fact and Dimension tables separate
• Before you forget
• Keep the structure simple - From Snowflake to star
• Always Format measures
• Always use a date table 1. Turn off Auto date tables
• Always use a date table 2. Create a date table on the fly with Power query
• Always use a date table 3. Mark a date table as a date table
• Hide Fields
• Document measures using Tool-tips
• Do not Transform data using DAX