Power BI Course - Intermediate
The Power BI course is an intermediate programme that will take you through the more advanced data modelling techniques and visualisations, enabling you to perform even more powerful analyses. Through activities and hands-on exercises, you will gain practical knowledge that will make you an advanced Power BI user, with minimal time out of the office. The course uses a hands-on example-based approach, building Power BI visualisations, reports and data models of increasing power and sophistication as the programme progresses.
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 internally, in the boardroom, or externally for the purposes of communication and better story-telling.
The programme will be delivered by our Microsoft-awarded trainer Mark Wilcock, an expert in the field who will remain at your disposal to answer questions specific to your role or challenges. Mark organises the London Business Analytics Group (LBAG), a popular data & analytics community group. LBAG has over 10,000 members and has run about 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.
There has not been a better time to expand your knowledge of data analysis techniques. Our unique offering enables you to choose between two competence levels, so your learning experience is tailored to your business needs. This course will be useful to you if data analysis forms a major part of your day to day activities.
Day 1 - Introduction to data modelling with Power BI
The data model underpins our visualisations and our calculations and is of fundamental importance.
- Reshape and tidy data in the Query Editor into the shape of dimensional and fact tables.
- Understand the dimensional model – tables and relationships.
- Date (calendar) tables and how to build and use them.
- Build a data model pattern based on a star schema pattern.
- Improve the data model; hide fields, add hierarchies, formats and display folders, explicit measures.
- Basic DAX calculations (DAX is the calculation language of Power BI).
Day 2 - Common data modelling challenges
- Advanced data modelling techniques.
- Dealing with many dates on our tables.
- Role-playing dimensions.
- Snowflake schemas.
- Several fact tables with different granularity.
- Powerful calculations in DAX.
- Introduction to DAX.
- Measures, calculated columns and calculated tables.
- Time intelligence e.g. year to date.
- Ratio calculations e.g. percentage of parents.
Day 3 - Advanced features of Power BI. The final set of topics will be chosen by the class but may include:
- Advanced data modelling and DAX calculations challenges.
- Virtual relationships.
- Periods between events.
- AI-assisted visualisations and techniques.
- The key influencers visuals.
- Q&A (natural language questions).
- Explain the increase.
- Managing large datasets.
- Incremental modelling.
- Designing for good performance.
- Enterprise features of Power BI.
- Q&A (natural languages questions).
- 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.