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 USQL T-SQL lifelong learning edX Azure AI PowerBI Python

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 dashboard NoSQL USQL T-SQL lifelong learning SQLAzure PowerBI Azure Data Factory Azure Data Lake Microsoft R Server Python

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 BigData actuarial tech with tags OneNote USQL T-SQL Python PowerBI Azure lifelong learning edX AI

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 Microsoft R Server Python AzureMLStudio PowerBI 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 WPF React PowerBI Blazor ButterCMS SQLAzure ASP.NET Core Telerik AzureQueues AzureFunctions Azure

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 tech BigData with tags SQLAzure ExcelPowerPivot PowerBI Azure Data Factory Azure Data Lake Microsoft R Server Azure

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 tech BigData pensions with tags cashflow projection valuation SQLAzure ExcelPowerPivot PowerBI AzureQueues AzureFunctions Azure

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.