Power BI Advanced

Course Duration is 1 Day

£1,495.00 Plus VAT

Delivery Method

Face To Face Delivery  Virtual Delivery One To One Coaching Closed Group Course Public Course

Business Benefit

This course includes creating visualisations using Power BI Desktop and then publishing them to the Power BI Service and learning how to share their reports and dashboards with colleagues.

How to Book

If you are interested in booking this course, then please select an available date and then click book now to complete the booking. Can’t see a suitable date contact us on [email protected] and we can discuss specific date requirements.

Who Should Attend

Anyone with a basic understanding of Creating a basic Power BI report but would like to expand their knowledge into Power BI Service.

Learning Outcomes – by the end of this course you will be able to…

Learn how the Power BI engine performs its various calculations using Evaluation Context, Filter Context & Row Context.
Learn how to use more advanced DAX functions to solve common finance reporting needs, such as: calculating YTD, year-end (calendar), year-end (fiscal) and learn more about how to use CALCULATE.
Learn about the relationship between the Desktop & Service.
Learn how to share reports & dashboards with colleagues & partners.

Course Content

Learn how the Power BI engine performs its various calculations using Evaluation Context, Filter Context & Row Context.
By learning the above, delegates will be able to understand the principles of many DAX functions and how to use them.
Learn how Power BI differs from Excel.
By learning the above delegates will be able to create more complex calculations & diagnose problems.
Learn about DAX Time Intelligence functions and how to use them in financial reports.
Learn how to report using a range of categorical calendar periods such as: Year, Quarter, Month & Week.
Learn how to use more advanced DAX functions to solve common finance reporting needs, such as: calculating YTD, year-end (calendar), year-end (fiscal) and learn more about how to use CALCULATE.
Learn about the relationship between the Desktop & Service.
Learn how to navigate the Service environment. Learn how to manipulate reports and create new ones from new & existing data sets.
Learn how to build a dashboard using reports published to the Service.
Learn how to share reports & dashboards with colleagues & partners.
Learn how to analyse a data model in the Service and show the results in an Excel pivot table.

Embedding

These follow up coaching sessions help support your colleagues to embed their learning during their skills transfer period.  Applying new skills and changing behaviour takes effort and practice.  After attending a training course many colleagues will find they need support through this transition.  EQV can provide that support with follow up coaching sessions to help embed the learning.

Embedding coaching sessions can be delivered in 90 minute and half day durations.  The facilitator will work with the group to capture feedback about challenges and how to overcome them ensuring success going forward.

Having a formal embedding coaching session will not only increase the success of the skills transfer period but helps create a platform of motivation, inclusivity and commitment within the group.