Power BI Desktop Advanced

Course Duration is 1 Day

£695.00 Plus VAT (per person)

Have more than 2 delegates? Talk to us about our closed group courses.

Delivery Method

Open Public Courses РVirtual Delivery Only  Closed Group Courses РFace To Face and Virtual Delivery

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.

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

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.

How to Book

Dates below represent open public courses only. To book this course, please select an available date and click the book now button below to complete the booking. Have two or more people to train – you may consider a closed group course. Contact us on [email protected] to discuss specific date and delivery requirements.

 

Measuring The Success

 

The purpose of your training is learning new skills and/or changing behaviour. We can help you measure this!

To evaluate how successfully the attendees are doing this, delegates can attend a Workplace Implementation session during the skills transfer period. The cost of the session is £595+VAT delivered virtually and lasts for 2.5 hours.

During the Workplace Implementation session the individuals will either on a 1-2-1 basis or as a group discuss the challenges and successes they have experienced during their skills transfer period.
This will include what they are doing differently as a direct result of the training and how this has positively impacted the organisation.
This is an excellent way to encourage the learning, support the skills transfer into the workplace and act as a measure to evaluate the training.

We compile this information into a report so that you have evidence of your return on investment.