Latest articles
Every week I write on the topic of data analysis, revenue management, business strategy, and various other topics which interest me. Below is my latest work.
The Big 3 Strategic Pricing Frameworks by BCG, McKinsey, and Simon-Kucher →
Most global consulting firms do not publicly disclose their strategic pricing frameworks on their websites. However, a few do. I found three that can serve as powerful tools in your professional toolkit.
The Comprehensive Guide to Pricing Strategies and Models →
Pricing has no textbook solution or magic formula. Different companies require different strategies and tactics. This guide offers an extensive collection of pricing strategies and models used across various industries, from B2B to B2C.
From Data to Profit: What Is Revenue Management and Why It Matters? →
Revenue management is not accounting or just pricing management. Discover how revenue management transforms data into profit, its evolution across industries, and why more organisations are adopting this critical commercial capability. Explore key frameworks by BCG and Coca-Cola within the CPG/FMCG industries.
Economic Theories Behind Pricing Strategies →
Economic theories shape pricing strategies, helping to predict market reactions to product prices. This refresher highlights the core aspects of the theory of price, focusing on the Law of Supply and Demand and price elasticity.
Your Ultimate Guide to 55 Web Analytics Tools →
Navigate the sea of web analytics tools to track, analyse, and enhance your digital presence effectively with this ultimate guide.
How to Choose the Right Python Library for Your Data Project? →
Discover practical tips and tools to pinpoint the right Python library for your data project, ensuring optimal results and efficiency.
Your Ultimate Guide to 60 Python Libraries for Data Analysis and Science →
Python reigns supreme in data science and analysis, thanks to its robust libraries. This guide outlines 60 widespread ones, categorised to enhance your data projects.
Data Wrangling and Manipulation in Python: Pandas vs. Polars →
Explore the strengths of Pandas and Polars in Python for data wrangling and manipulation. Learn which library best suits your data processing needs for efficient and effective analysis.
The Power of Common Table Expressions (CTEs) in SQL →
Discover the power of CTEs in SQL: streamline complex queries, enhance performance, and choose wisely between CTEs, temp tables, and subqueries for cleaner code.
Interesting Stats Behind Brand Biopics →
Films and TV series about brands and products have gained immense popularity in recent times. Which of them are most successful? Let’s take a look at the numbers.
32 Fascinating Stories Behind Famous Brands Told in Movies and TV Series →
Keen on blending entertainment with insight, and interested in entrepreneurship, business growth, or specific companies and industries? Find a comprehensive list of movies and series about famous brands in this article.
The World of Chocolate: Analysing the Global Chocolate Market →
Chocolate is one of the most beloved sweets around. Curious about what is going on in the chocolate industry? Dive into this article to explore its origins, the global market's trends, challenges, and what the future holds.
Optimising SQL: Subqueries vs. Joins →
TL;DR: joins are the winner in this battle. Why? Explore the nuances of SQL optimisation through a detailed comparison of subqueries and joins.
How to Improve SQL Query Performance with Indexing? →
Discover how smart indexing transforms SQL query performance, avoiding common mistakes and mastering best practices.
All About SQL Joins →
Explore the magical world of bridging data with SQL joins with a simple and comprehensive guide.
How to Select Features for Your Machine Learning Model? →
Feature selection distinguishes the best data scientists from the others. Get techniques and tips for choosing the best features effectively.
Interesting Facts & Insights from Business Intelligence History →
Ever wondered about the origins of business intelligence? Who coined the BI term? Who sold the initial BI software? Discover how historical insights shape BI’s future.
Clash of the BI Titans: Breaking Down Power BI, Tableau, and Looker →
Which business intelligence tool is the best: Power BI, Tableau, or Looker? Let's explore their strengths, weaknesses, and roles in the market.
Good Strategy / Bad Strategy: Learnings from a Strategy Guru →
How to craft an effective strategy? The best answer is provided in Richard Rumelt's book 'Good Strategy / Bad Strategy'. This article explores Rumelt's core concepts and offers a few thoughts on his ideas and the book as a whole.