Take advantage of our Live Online Instructor Led Training to start benefitting from Power BI. If you're not sure of the potential of Power BI, please have a play around with our Power BI Interactive Dashboard.
This 1-day course is available either at your premises or at the Cambourne training venue. If you would like to book this course, please email us, and we'll let you know the available dates. As soon as a date has been fixed the training day will be booked.
Training Delivery: Live Online Instructor Led & Classroom Face to Face
Course Duration: 1 Day
Power BI Online Training - All you need to know.
Microsoft Excel Power BI Training Course Beginners Cambridge
Introduction to Excel Power BI
- Business Analysis
- Installing Power BI
- Check your version of Office
Getting Data
- Excel
Creating Calculated Columns
- Concatenation
- Date Formulas
Visualisations with Power BI
- Formatting Visualisations
- Adding a Slicer
- Sorting the Month Order Problem
- Multiple Labels on Axis
- Drilling Down
- Creating Hierarchies - Multiple Labels on the same Axis
- When to use a Tree Map
Filters
- Adding Arrows and Comments
Edit Interactions
Calendar Table
Relationships and Keys
- Showing Rows with no Data
- Using Excel Tables
Laying out a Page
DAX
- YTD - Year to Date
- Previous Year
- HASONEVALUE
- The Process of RANKING
Importing Visualisations
- Importing Custom Visual from the Web
- Timeline Slicer Visualisation
Publishing
- Signing in
Navigating Online Power BI
- Pinning Dashboards
- Asking Questions of your Data
- Custom Q&A Questions
- Removing a Visualisation from the Dashboard
Insights
- Importing Custom Visuals
Power Query
- Removing Errors
- Applied Steps
- Removing the Rows Entirely
- Custom Columns and Try
- Adding an Index Column
On completion of the course the delegates will be able to:
- Use Excel to produce interactive Charts and Visualisations that can be easily shared
- Organise and Analyse vast amounts of data with ease
- Create Interactive Dashboards
