Power BI Advanced

Course Duration is 1 Day

£1,495.00 Plus VAT

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.

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.