- 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
Are you looking to improve your efficiency, your modeling skills, and your general DAX usage skills for Power BI or Power Pivot? IF so then this course is for you.
This course is a general tips course for those working with DAX in Power BI or Power Pivot. You will learn tips and tricks that will both save you time and make you more efficient. DAX is becoming a more sought after skill and this course has been designed to help you become on top of the game.
You will be given tips on the following topic and more
- Data Modelling
- Working with Date tables
- Keyboard shortcuts
- Model optimization
- Data transformation steps
- Using Power Query
- Much much more
This is a hands-on course, so you will find workbooks to download so that you can practice along
So if you are a DAX user and are looking to improve your general skills and efficiency then when don't you hope into the course and find out more.
Digital Photoshop Compositing - Anyone can do it, all secrets and tricks are revealed.
How to easaly create more than hundrets effective ads with Automation
Strategies on how to prepare your family and yourself for starting a business.
About the instructors
- 4.26 Calificación
- 94666 Estudiantes
- 25 Cursos
Paula Guilfoyle CPA & MVP
Microsoft MVP, CPA Accountant, & Life Long Learner
Paula is a qualified CPA with over 15 years' experience in the fields of Accountancy, Business Management, Process improvement, Internal Audit, Group accountant, Operations Management and Training. All across a broad range of industries and sectors. Paula has been Key Speaker at many Accounting Events where her talks on Excel are received very positively. Taken from her experiences in Accounting and business fields, Paula also has Udemy courses for those wishing to upskill, especially in the area of Spreadsheets, Bookkeeping and Accounting.
In 2020 Paula was awarded with a Microsoft MVP award for her dedication to Excel and the Excel community.
Excelentes consejos para optimizar los modelos y para mejorar las habilidades en el uso de PowerBI y PowerQuery
This summary helps you to avoid "basic" mistakes which you would learn through your own failures
Paula always teaches great, practical lessons. This course is no different.
Wow, the teacher' language is unambiguous and easy to understand. The 1st lesson shows extensive knowledge. After 20 min, I know that this learning will be beneficial for me. It is a good piece of knowledge for each level of skills.
Excellent. Well delivered, full of clear reasoning and explanation. Worthy of a 5***** rate. Good stuff Paula.
As a starter, It was helpful to learn these tips.