Posts

Financial Mathematics CT-1 Finally Paid Off

Image
 How you may ask,  I sat for my financial mathematics paper in 2017. For those who do not know what this is, here is a summary. In the pursuit to be an actuary, there are exams that you are supposed to take and pass. Financial Mathematics (CT-1) was the name of one of it in the Institute and Faculty of Actuaries (IFoA) exam system before they changed the syllabus and consequently the exam paper names. I passed this paper on the first trial with what I would consider an excellent grade. The surprising bit is, as a unit/course, Financial Mathematics 1, was one of my three lowest scores in my entire undergraduate. So, this felt like part vindication that given different circumstances and motivation, I can do pretty well. I studied for the exam for probably more than 3 months, did almost all the past papers leading to that year and checked them against examiners' reports - thanks to the IFoA  repository . I did have a study buddy during this period. I did 2 more actuarial exa...

Self Joins in R

Image
Sometime back at work, I was faced with a dilemma.  I am one of those people who might get stuck on something because I have a "feeling" there is a shorter way to do it. Neither am I the biggest fan of writing several lines of code when there is an option to have less lines. I know that my tendency towards less lines of code sometimes is not the best bacause it might hinder readability.  To explain my dilemma, I have created a sample data frame as follows Code: data <-data.frame(   ID = c(12,12,34,36,47,47,58,68,77,77),   Call_Duration  = c(20,20,25,27,40,40,50,55,20,20),   Call_Reason = c("Reason 1", "Reason 2", "Reason 3", "Reason 1","Reason 3",                   "Reason 6", "Reason 4", "Reason 1", "Reason 2", "Reason 3")   ) Running the code above results to the below dataframe The Dilemma How can I easily find and count duplicate IDs so that I can ration call duration to...

Using R scripts in Power BI - Visualization

Image
If you code in R, you have in some cases worked with applications that enable you to use R. One of those that I constantly work with is Power BI.  There are many visual options available in Power BI including links to custom ones. On the visuals landing tab, you can pick R or Python Scripts as a method to create your desired visual. In this blog, I will demonstrate how to create the visual below (Some have called it a progress bar). Access you visuals page on Power BI, choose the R script, choose the table columns you need for the visual. Power BI will combine the columns into a data frame called dataset that is available for use. You can rename it data or whatever you decide. For this case, I have to create the dataset instead of using one from power BI  Create the data frame and set seed to replicate results set.seed(5) data <- data.frame(Facility = c(rep("A",3), rep("B", 3), rep("C",3), rep("D", 3)),                   Year = r...

Data Scientist Courses (edX vs DatCamp)

Image
I have had the opportunity to try several online learning platforms. Some of these have been LinkedIn Learning, Pluralsight, edX, DataCamp, Microsoft Learn among many more. You may find particular courses in all the platforms. On this post, I am going to outline chapters from the data science courses on edX and DataCamp. I Audited a data science course on edx around the year 2021. This was my first time going through a complete data science course. A lot of the material was new to me especially the coding. The theories on the other hand were more relatable. It was also the first time before my masters that I got to understand hypothesis testing and got to know why it is never "accept the null hypothesis" but always "Reject or fail to reject the null hypothesis". Some of the chapters on it were hosted outside edX and that is how I discovered DataCamp. The link to the full course is  HarvardX's Data Science Professional Certificate Around the second quarter of 202...

PREPARING FOR AND PASSING DP-600 EXAM: IMPLEMENTING ANALYTICS SOLUTIONS IN MICROSOFT FABRIC

I  successfully sat and passed the above exam in the last week of June and earned my Fabric Analytics Engineer Associate certificate. The exam costs $160 but I was lucky to get a voucher that covered the full amount. The voucher was earned by participating to completion in a Microsoft learn challenge that ran between March and April 2024. Exam Sections Plan, implement and manage a solution for data analytics Prepare and serve data Implement and manage semantic models Explore and analyze data If you are planning on taking the exam, this would be my advice to you after you have completely read through the study guide on your own. check out  Learn Microsoft Fabric with Will   a YouTube playlist going through the study guide. The material they went through and the sample questions after each video/section on the playlist are a good introduction to the sections and question style of   the exam. I am inclined to say that this takes the most credit on how I managed to ...

Customer retention vs a one time sale

Image
Companies are always in a bid to grow their market share. To achieve this goal, they resort into some of the following methods. Acquiring their competitors' market share, retaining their existing clients/customers, creating a new target group (expand the market share) which was not served by their product before etc. As a result, extensive research is done into promotion and pricing strategies as a means of meeting the goal.  For illustration, I will use the telecommunications industry. You walk into a store to buy a phone - say Samsung A14. The store has both locked and unlocked phones. The store attendant informs you that; Option A: Get the phone at full retail price $219 and pick a service provider of your choice.  Let say you get a free simcard from service provider A and their monthly plan fee is $20. Option B: Get the phone for $54 of the total retail price of $219 saving $165 in the process. But this is only if get a locked phone under Service provider B whose monthly p...

My Date and Time of Birth Dilemma

 Time There are 24 time zones in the world. These time zones are each 1 hour apart. I will in summary explain how the time difference comes across and what is used to determine the time in a region/country as a build up to the dilemma. From my Geography and Math classes, I remember there being questions like "what will be the time in country 'xyz' if the time in your country is  'this' and given that the country is on 'this' longitude while your country is on 'this'". The question required you to remember that the time difference between two consecutive longitudes is 4 minutes. (There are 360 longitudes and the globe does one full rotation in 24 hrs. The breakdown into minutes and longitude to longitude distance in time is 4 minutes). So, longitudes determine time. They are defined as imaginary lines that run from North to South, from pole to pole but measure distance from East to West (separates East from West). The most famous one is the prim...