Power BI Desktop Advanced
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.
- Time Intelligence DAX
- TOTALYTD
- SAMEPERIODLASTYEAR
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.
- DAX Formulas
- SUM, SUMX, MAXX, DIVIDE
- IF
- HASONEVALUE
- SELECTEDVALUE
- CALCULATE
- SWITCH
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.
Anyone with a basic understanding of Creating a basic Power BI report but would like to expand their knowledge into Power BI Service.
We can deliver our training sessions in several ways, these being:
- Open public course (Contact us if you can’t see a suitable date listed)
- Closed group
- In person face to face
- Virtual
- One to one coaching
Have two or more people to train? You may consider a closed group course.
Benefits include:
- Cost effective
- Choose a date to suit you
- Customise content and timings
- No minimum delegate
Contact us on [email protected] to discuss specific date and delivery requirements.
How Our Tutor led Courses Are Delivered:
Delegates are given Pre-work
Group courses use your real-world scenarios so learning is immediately relevant and actionable.
Our sessions are participative and highly Interactive by including a variety of activities throughout the delivery including
Real-world case work
Practical exercises
Real Play
Peer learning
Case studies
Simulation
Facilitated discussion and Structured reflection
Leave with Actionable outcomes
Post-session measurements
Participants leave with:
Practical tools
Clear action plans
Greater confidence
Skills they can apply immediately
Course Benefits
- Fully tutor led instruction
- Comprehensive courseware for all delegates
- Certificates of attendance
- Course Guarantee
- Emergency trainer
- Contextualisation and customisation for Closed group courses
- Evaluation Feedback
- Pre & Post Course Activities
- Access to Customer Portal (course bookers) for oversight of past and future training events and attendance details
Key Features
Engaging tutor led event
Comprehensive course materials
£695.00 Plus VAT
Can’t see a suitable date? Please request a date here
Payment available via all major credit cards or Invoice. All options available during the online booking process.