Excel Level 6 BI Desktop Visualisations
A practical guide to using Desktop Power BI app to manipulate large data sets using DAX formulas, measures and calculated columns in Power Query.
Once data is in the correct format we will create Relationships to join tables from different sources and use this data to create interactive visualisations which may be published to the web and shared with colleagues.
- Prepare Reports for import
- Import files
- Importing text files
- Creating DAX formulas
- Calculated columns
- Fields for slicers
- Creating Measures
- Using Slicers to view data
- 20 & 21 July 2022 AM (2 half days 9:30-12:30) - Virtual Classroom
- 10 & 11 October 2022 AM (2 half days 9:30-12:30) - Virtual Classroom
To request new dates, arrange a meeting to identify your goals, or find out more details about the training Send Karen a Message
In House Training
This course can be delivered privately to your team.
Request a Quote (please specify preferred dates and expected number of delegates).
Delegates MUST have completed our Excel Levels 1 - 4 courses or provide evidence that they are already competent to this level to book onto this course. The earlier courses provide foundations for the techniques we teach on this training event.
Delegates should be confident about their Excel skills before joining this class.