Do you love the dynamic reporting capabilities of Power BI? Have you created a few Power BI reports, but unsure of how to take your reporting to the next level? This course will highlight some of the intermediate to advanced features of Power BI, as well as provide you with some pro tips that will save you time and frustration when building Power BI reports.
In this hands-on course students will create a Power BI report from data to dashboard. Upon completion of this course you will:
This was one of the most productive training sessions that I have done in the last 5 years
Good content, delivered very well.
Sun Engineering Ltd
I felt the trainer as very informative and knowledgeable and delivered the session well, I enjoyed the session and gained some well needed knowledge.
Sun Engineering Ltd
Appreciated Robbie's ability to involve all participants thru program whilst playing catch-up with those that did not immediately relate to issue.
Liquor Legends
FANTASTIC! I have already recommended you guys to 3 friends who are looking at doing some courses soon!!
Presence of IT
Robby was Brilliant! I learnt heaps of new tricks and will definitely be back for another advanced excel course. Thanks again Robby for all your hard work yesterday. I found Pete an excellent trainer with plenty of patience and willingness to share his knowledge. Thank you Pete!
Mater
I enjoyed the course and found my attendance to be beneficial.
ERM Power
Murray was very helpful and was able to work with our specific requirements which made the course even more beneficial. I have already recommended PD Training to CASA for future training.
Civil Aviation Safety Authority
I had a chat to two of the participants from yesterday's Excel training. We didn't discuss the specific questions listed in your survey, but they both said the training was excellent and they definitely gained valuable knowledge from it. They said their trainer (Peter) was an excellent trainer.
Mater
Denise was a fantastic trainer and I thoroughly enjoyed my training
Westfield Ltd
Thanks for making the organising so easy. You have all been very helpful.
Mater
If you’re not happy with the outcomes from
the course we offer a money back guarantee
For every participant
valued at $199 each
No one left behind
with our 1/2 price re-run promise
12-months access to the unique REACH Future Proofing Personal Development Dashboard with personally curated learning to develop agility to adapt to different people tasks and situations.
Designed for the end user / power user looking to get more out of Power BI without needing to be a developer.
After completing this course, participants will have learned to:
Topic 1
Power BI Essential Skills Review
Get data from Excel, create relationships and publish a simple dashboard.
Topic 2
Power Query Timesaving Tips
Get data from an entire folder, learn how to edit M query code in the formula bar, edit Applied Steps to troubleshoot data import errors and discuss best practice tips for data transformation in Power Query.
Topic 3
Introduction to DAX
Work with simple DAX functions and discuss the difference between calculated measures and calculated columns.
Topic 4
Analysing Data with Visualizations
Explore various Power BI visualizations such as gauges, KPIs and more. Filter visualizations, sync slicers and edit interactions between visuals to show exactly what you need. Implement row-level security to enable your report to automatically filter for each user.
Topic 5
Format reports
Create interactive reports that drill-through to detailed pages, drill down through hierarchies and use buttons and bookmarks to make the report easier to use and understand. Use conditional formatting to highlight important data. Learn timesaving tricks to align, format and edit existing visualizations so your report looks professional.
If you’re not happy with the outcomes from
the course we offer a money back guarantee
For every participant
valued at $199 each
No one left behind
with our 1/2 price re-run promise
12-months access to the unique REACH Future Proofing Personal Development Dashboard with personally curated learning to develop agility to adapt to different people tasks and situations.
We take care of all of the details, so you don’t have to:
At the completion of training participants are encouraged to create an action plan, and invite an accountability buddy via their Orgmenta App.
In your Training Management Centre you have transparency to the action plans so you can see what people are going to do differently.
Our systems and people make it easy to identify how you’ll be able to measure impacts and then report on the success in the weeks or months after training.
It’s surprisingly easy to make it so that your system can automatically be up to date with all the training record details you need.
After completing this course, participants will have learned to:
Topic 1
Power BI Essential Skills Review
Get data from Excel, create relationships and publish a simple dashboard.
Topic 2
Power Query Timesaving Tips
Get data from an entire folder, learn how to edit M query code in the formula bar, edit Applied Steps to troubleshoot data import errors and discuss best practice tips for data transformation in Power Query.
Topic 3
Introduction to DAX
Work with simple DAX functions and discuss the difference between calculated measures and calculated columns.
Topic 4
Analysing Data with Visualizations
Explore various Power BI visualizations such as gauges, KPIs and more. Filter visualizations, sync slicers and edit interactions between visuals to show exactly what you need. Implement row-level security to enable your report to automatically filter for each user.
Topic 5
Format reports
Create interactive reports that drill-through to detailed pages, drill down through hierarchies and use buttons and bookmarks to make the report easier to use and understand. Use conditional formatting to highlight important data. Learn timesaving tricks to align, format and edit existing visualizations so your report looks professional.
Activities and discussion for engaged learning all day.
On average PDT trainers have 15 years industry experience and 7 years training experience.
We always tailor activities and scenarios to be relevant to you.
In-House and Public Class participants are welcome to join a public class in the same topic for 12 months.
The confidence of booking with an acclaimed multi-national training company.
Support, reinforcement & extension eLearning and videos in the App.
The most important foundation for communication and building meaningful relationships is listening, develop your skills with this micro eLearning course.
Not exactly what you needed? Try other courses in the MS Office Apps Courses Category
Supporting leaders and teams around the globe, we're proud to mark 15 years of growth, innovation, and success. Thank you for being part of the PD Training journey. The future is looking bright!