Blog posts tagged with: PowerBI

My Journey to Data Science, Big Data and AI

by Patrick Lee on 11 Mar 2020 in categories actuarial with tags AI Azure edX lifelong learning PowerBI Python T-SQL USQL

I gave a presentation to the Channel Islands Actuarial Association earlier today, and a similar one earlier this year to the Staple Inn Actuarial Society. I provided copies of the materials I used to those two Societies, but I have had a few requests for a copy from other people: ...

Microsoft Professional Program for Big Data: my journey (Oct 2017 - Apr 2019)

by Patrick Lee on 22 May 2019 in categories actuarial BigData with tags Azure Data Factory Azure Data Lake dashboard lifelong learning Microsoft R Server NoSQL PowerBI Python SQLAzure T-SQL USQL

I was very pleased to complete this program (a series of 10 courses) in April 2019, working in my spare time. Overview The 10 courses were: Microsoft Professional Orientation: Big Data (completed Oct 2017) Analyse and Visualize Data (completed on the Data Science program in July 2017) Work with NoSQL ...

A few tips to help maximise your marks on online courses (e.g. edX)

by Patrick Lee on 13 May 2019 in categories actuarial BigData tech with tags AI Azure edX lifelong learning OneNote PowerBI Python T-SQL USQL

I have now taken 24 online edX courses, mainly on #DataScience, #BigData and #AI. The pass mark on these has been 70%, but being a bit of a perfectionist, I have always tried for 100%. (After all, would you really want an airline pilot who got things right 70% of ...

Microsoft Professional Program for Data Science: my journey (May 2017 – April 2018)

by Patrick Lee on 30 Apr 2019 in categories actuarial BigData with tags AzureMLStudio Microsoft R Server PowerBI Python SQLAzure

I wrote this exactly a year ago - since then I have completed the Microsoft Professional Program for Big Data, again working in my spare time. I am delighted to have now completed the Microsoft Professional Program for Data Science. It has been 10 online courses (taking a total of ...

My software portfolio

by Patrick Lee on 30 Apr 2019 in categories tech with tags ASP.NET Core Azure AzureFunctions AzureQueues Blazor ButterCMS PowerBI React SQLAzure Telerik WPF

Below is a slideshow of some of my software work. To see each individual picture in more detail, go to https://patrickjlee.smugmug.com/Software-engineering-portfolio/ .

My technology certifications

by Patrick Lee on 30 Apr 2019 in categories BigData tech with tags Azure Azure Data Factory Azure Data Lake ExcelPowerPivot Microsoft R Server PowerBI SQLAzure

Below is a slideshow of my software certifications. To see each individual certification in more detail, go to https://patrickjlee.smugmug.com/Technology/Certifications/ .

Valuing large pension plans more quickly and cost effectively using Azure Functions (Part 1)

by Patrick Lee on 29 Apr 2019 in categories actuarial BigData pensions tech with tags Azure AzureFunctions AzureQueues cashflow projection ExcelPowerPivot PowerBI SQLAzure valuation

Using different Microsoft cloud techniques to perform a financial valuation of large numbers (100,000 or even several million) of UK defined benefit pension plan members via cashflow projections as quickly as possible, but without incurring unnecessary cost.