Advanced POWER BI using DAX and data tools

Advanced POWER BI using DAX and data tools

Do you want to go the the next level of Power BI? Using DAX expressions and automation to create more advanced data sets and reports.

By Lake Mill Training and Consulting

Date and time

Location

The Vicky Business Centre Meeting Room & Office Hire

13B Station Street Cockermouth CA13 9QQ United Kingdom

Refund Policy

Refunds up to 7 days before event

About this event

  • Event lasts 6 hours 30 minutes
  • No venue parking

The purpose of this course is to help you enhance how you Use Power BI as a Business Intelligence tool within your company to produce amazing, interactive and informative reporting using more Data tools and DAX expressions.

£120 for the full day including refreshments and lunch.

Advanced Data Functions

  1. Data transformation examples
  2. Advanced transformation and querying techniques
  3. Designing advanced data models
  4. Optimising your models
  5. Course Assignments - Advanced Data Transformations

DAX Started

  1. DAX - Aggregation Functions
  2. Context & Calculate, Variables, Tricks & Tips
  3. Iterator Functions
  4. Filters Functions
  5. Information Functions
  6. Logical Functions
  7. Min & Max Highlight
  8. Math Functions
  9. Text Functions
  10. Trick and Tips
  11. Table Functions
  12. Relationship Functions
  13. TopN, Rankx
  14. Time Intelligence Functions
  15. Calculation Groups
  16. DAX Statements
  17. Visual Level Calculations

Handouts will be provided for reference during the course.

Frequently asked questions

Is lunch provided?

Yes, lunch is provided in the cost please let us know if you have any specific requirements.

Do I need to bring my own laptop?

Yes, we will work on your own equipment. Please ensure you have Power BI desktop dowloaded.

Where can we park?

If you turn onto Lorton road from Station street there is a small car park (opposite loading entrance to Mitchells auctions) that costs £5.50 for 12 hours.

Organised by

Lake Mill Training and Consulting provide Microsoft Office training services online and bespoke, onsite courses specific to clients needs.

10% off applied
£108