|
|
|
|||||
|
|||||
|
|
|
|
This web session is designed to empower actuaries to enhance their existing toolkits with practical skills in three of Microsoft’s most powerful data tools.
Focussing on real-world actuarial applications, this web session will demonstrate practical ways to prepare, analyse and visualise data using these tools thin the familiar environment of MS Excel and beyond.
Starting from Microsoft Excel, this web session will demonstrate how Power Query, Power Pivot, and Power BI can be integrated to create a seamless and efficient actuarial data workflow. Power Query, via the M language, enables automated data extraction and transformation. Power Pivot allows for the construction of robust Data Models and the use of the DAX language for advanced calculations.
These Data Models can be copied directly from Power Query into Power BI, where interactive visualisations and reporting further enhance actuarial analysis. The session focuses on practical actuarial examples, illustrating how the combined use of M, DAX, and the Data Model across all three tools enables actuaries to manage complex data tasks more efficiently and deliver clearer, more impactful results.
Early-bird discount is available for bookings made by 4 May 2026. |
|
|
|
Coming soon... |
|
Comparing IFRS 17 and Solvency II | 26 March 2026
Build LLM Inference in Excel: Advanced Excel to Demystify GPTs | 24&27 April 2026
How to Read the IFRS Balance Sheet for Insurers | 24 June 2026
Explore our website for more information and discover all our upcoming events. For more insights, updates, and a bit of actuarial fun, feel free to follow us on LinkedIn! |