Why book this course?
Microsoft Power BI (Business Intelligence), is a suite of business analytics tools to analyse data and share insights. Power BI dashboards provide a 360-degree view for business users with their most important metrics in one place, updated in real time, and available on all their devices.
With one click, users can explore the data behind their dashboard using intuitive tools that make finding answers easy. You can also access your data and reports from anywhere with the Power BI Mobile apps, which update automatically with any changes to your data.
If you are responsible for delivering reporting and analytics to your organisation, Power BI lets you be productive and creative with what you build. Power BI Desktop is a feature-rich data and report authoring tool.
Who is the course for?
Our Introduction to Microsoft Power BI course is ideal for anyone who needs to use Microsoft Power BI in their workplace, or is interested in introducing it to their workflow.
Attendees will learn how to take advantage of the software to create reports, manage data and present information. Familiarity with other Microsoft applications, especially Microsoft Excel, is recommended.
What content will the course cover?
During the course, you will cover the following content:
- Introduction
- The Building Blocks of Power BI
- Starting Microsoft Power BI
- First Visualisation
- Adding A Matrix of Data
- Simple Charts
- Maps
- Adding A Card
- Adding Slicers
- Interactivity in Dashboards
- Formatting Reports
- Entering Your Own Data
- Databases and Power BI
- Filtering Data Using Queries
- Power Charts
- Drilling into and Expanding Chart Data Hierarchies
- Drill Down & Drill Up
- Including and Excluding Data Points
- Formatting Charts
- ToolTips
- Chart Analytics
- Creating ArcGis Maps
- Filtering Data
- Introduction to Power Bi Query Editor
- Power BI Query Editor Query Toolbar
- Transforming Data with Power BI Query Editor
- Applied Steps Menu
- Common Transformation Tasks
- Moving Columns
- Splitting Columns
- Split A Column by Position
- Split A Column Using Far Left or Far Right
- Concatenating Columns
- Merging Multiple Columns
- Filtering Data
- Exporting Power Query Data to A Power BI
- Removing Duplicates
- Filtering Rows with Errors
- Sorting A Table in Power Query
- Text Transformations
- Extracting left, Right and middle values
- Unpivoting Columns
- Creating A Custom Column
What will I get out of the training?
Attendees will gain a clear understanding of the fundamentals of Microsoft Power BI, and become more confident with using the software. You’ll be able to use Power BI's key features efficiently and learn how to create and maintain reports.
At Kent Trainers, we’re proud to tailor all of our courses to the needs of businesses across the region. Our Introduction to Microsoft Power BI course gives attendees the opportunity to ask questions and receive advice that applies to their situation. By the end, you’ll have an appreciation of the software that allows you to harness it to improve your own performance.
What is the duration of this course?
This is a 1-day course.
The timings and format for our courses are as follows:
- In-house & bespoke courses, held virtually or at a venue of your choice
For all in-house training courses, we will adapt the timings and format for each day around the needs of your organisation and team. Please get in touch with us to discuss your requirements.
- Scheduled training courses held at one of our venues
Courses commence at 9:30am and finish at approximately 4:30pm. A hot and cold buffet lunch is included on all our scheduled courses, and refreshments are provided throughout the day.
- Scheduled training courses held virtually
Unless specified, courses commence at 9:30am and finish at approximately 4:00pm. The day is broken up into modules, both online and offline to ensure engagement and interaction. We also ensure that there are plenty of comfort breaks throughout the day.
