The Introduction into Power BI Course will equip you with all the skills and knowledge necessary to successfully analyse and represent data from different sources. Our introductory programme will help you create visualisations that perfectly relay messages specific to your objectives. Through activities and hands-on exercises, you will gain practical knowledge that will make you a competent Power BI user quickly with minimal time out of the office. The course uses a hands-on example-based approach, making learning more effective.
At a glance
Power BI has consistently been gaining extreme popularity across a range of different sectors, varying from retail to housing and healthcare. It enables you to perform data analysis and visualisations that can then be used in a range of different scenarios, both internally and externally.
The programme will be delivered by our Microsoft-awarded trainer, an expert in the field who will remain at your disposal to answer questions specific to your role or challenges.
Day 1 - Power BI Desktop
- Introduction to Power BI; Getting Started exercises.
- Build popular charts such as line and bar charts, scatter plots (and decide when it is appropriate to use which).
- Improve these charts and make them appealing and attractive; titles, axes, fonts and good use of colour.
- Configure several charts to interact well on a single report page to help guide analysis e.g. drill from summary to detail, filtering and cross-highlighting.
- Import data into Power BI from Excel and text files, from the web and other sources.
- Shape and transform data in the Query Editor so easier to analyse and visualise.
- Group and bin columns.
Day 2 - Visualisation Techniques and Shaping Data
- Visualisation techniques:
- Custom tooltips.
- Drill-through pages.
- Conditional formatting.
- Dynamic formatting.
- Power BI’s AI-assisted visualisations e.g. decomposition tree.
- Building geospatial data maps with the Azure Map and Mapbox visuals.
- Shaping data in the Query Editor:
- Clean and tidy data: pivot and unpivot, filter datasets, handle missing values, group and sort data.
- Filter, sort, calculate new results to enrich the value of the data.
- Merge and append datasets.
- Understanding and differentiating between different chart types and the data they can be used to represent.
- Filtering and highlighting specific bits of information to enhance the message.
- Importing data into Power BI from various file formats and databases.
- Exploring different visualisation techniques.
- Exploring and understanding data modelling techniques.
This data analytics course appeals to a wide array of professionals that want to understand the role of big data in achieving their business objectives. From operations, marketing, IT, to finance or logistics, if your role includes decision making then big data should be on your agenda.
Mark organises the London Business Analytics Group (LBAG), a popular data and analytics community group. LBAG has over 10,000 members and has run over 60 events over the last six years with a typical audience of about 100 people at each event. Microsoft has recognised Mark as a Most Valuable Professional (MVP) for the last five years. He has an MA from Cambridge and an MBA from Imperial College, London.