Musings of a software engineer
Data practitioners use SQL for data mining: From simply displaying data to telling stories with data.
As a software engineer, most of my interactions with SQL are for simple transactional queries, rather than analytical queries.
[Read more…] about Data mining: SQL for data practitionersBuilding a great product is important, but tracking its impact on end-users is even more important in order to determine its effectiveness.
Being a software developer means that I spend most of my time writing code to build and maintain features, and fix bugs that are uncovered along the way.
As much as I position myself to be a product engineer that delivers product features to solve user needs, there is little visibility of the impact on end-users, which is reasonable because the analytics part of the work will be typically handled by a product manager or analytics manager.
[Read more…] about Tracking user behaviour with Google Analytics and Google Tag ManagerLike many other young adults, I was clueless about the world of investment. All I have heard was that investment is one of the few ways to grow our wealth significantly over the next few decades.
The rule of 72 states that the amount of time to double your money is derived by dividing 72 by your rate of return. For example, if your investment generates 12% a year, it will take you 6 years to double it.
[Read more…] about How I got started in investmentIn the beginning of 2019, I was experimenting with niche pages on Instagram, and wanted an on-demand tool to find viral instagram posts of users in my niche. So, I created a small project to scrape viral posts from any instagram user.
[Read more…] about Instagram scraper: Find viral posts on instagramReverse geocode is used to convert latitude longitude coordinates to a list of locations, which can then be used in search results.
In many consumer applications, the search experience is one of the most important aspects of consumer satisfaction. Search usually comes in these forms:
[Read more…] about Reverse geocode cities from geographic coordinatesDesigning a great onboarding, sign in experience is not easy because everyone is different and behaves differently. However, doing it well can put a smile on users’ face. For most B2C applications, onboarding should be quick, intuitive, easy to navigate. The key point is to offer a high value, frictionless experience with minimal effort.
I came across an article that describes common problems with login and its solutions, and another that talks about the rules for sign in experience. Both contain useful information to consider when designing the entire onboarding and sign in flow.
[Read more…] about Challenges in designing a great user onboarding experience