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

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

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 BigData actuarial with tags PowerBI SQLAzure Microsoft R Server AzureMLStudio Python

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 Blazor Telerik ASP.NET Core Azure ButterCMS AzureFunctions AzureQueues PowerBI SQLAzure React 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 tech BigData with tags Azure PowerBI ExcelPowerPivot SQLAzure Microsoft R Server Azure Data Lake Azure Data Factory

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

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.