Course overview

Duration: 1 day (6.5 hours)

This course is aimed at existing users who want to expand their skills to use advanced reporting techniques and use DAX to create calculated columns and measures.

Participants should have either attended our Power BI – Introduction course or have equivalent knowledge. You should be able to import and transform data and create simple reports.

Objectives 

By the end of the course you will be able to:

• Import and connect data tables
• Create and use date calendars
• Create calculated columns
• Create and use measures
• Use drill down and drill through
• Create Tooltip pages
• Add and customise slicers
• Add action buttons
• Streamline your report for use in the Power BI Service

Content

Review of importing and loading data

• Importing data
• Transforming data
• Adding custom columns
• Creating data models
• Building visuals

Creating date calendars

• Building date tables
• Creating Financial Year information
• Including Month and Day information

Creating calculated columns 

• Power Query custom columns vs DAX columns
• Creating DAX calculated columns

Creating measures

• Implicit vs Explicit Measures
• Building measures
• Using DAX
• Common DAX functions

Drill Down vs Drill Through

• Review of drill down
• Creating drill through pages
• Using drill through

Creating ToolTips Pages

• Adding pages to use for Tooltips
• Linking ToolTip pages to visuals

Using action buttons

• Adding images
• Adding buttons
• Setting actions

Working with slicers

• Adding slicers
• Changing slicer settings
• Syncing slicers between pages
• Showing what has been sliced
• Setting slicer interactions

Techniques in the Power BI Service

• Hiding the navigation bar
• Stopping users manually filtering

Public Training Programme

Explore our current selection of public courses, available as convenient and cost-effective virtual sessions.

Engage with expert instructors and a diverse peer group in an interactive, online learning environment.

Ideal for those valuing flexibility and affordability, our public courses are ideal where you only have small numbers requiring training and offer training from the comfort of your home or office.

View our full catalogue of Leadership, Personal Development, Systems, Office Applications and Project Management courses

Contact us

Do you have questions, suggestions, or feedback? We value your input and are here to assist you. Please don't hesitate to get in touch with us via email or phone:

• Email: [email protected]
• Phone: +44 (0)20 8152 6551

Our dedicated team is ready to respond to your enquiries and provide the support you need. Feel free to reach out, and we'll do our best to assist you.

Thank you for visiting our website, and we look forward to hearing from you!