Blogs

Data Analyst or Business Intelligence Analyst: Different Roles or just Interchangeable Terms

To answer the question, do data analysts differ from business intelligence analysts, or are they just interchangeable terms? let me take you back to my journey as a digital financial services consultant, a path I started in 2016. Read more...

Do Organizations really need Analysts

Before becoming an analyst, my only knowledge of analytics was a few basic aggregation functions in Excel. These proved useful when analyzing research data, typically from about 100 respondents. That was the extent of my data analytics exposure. Read more...

Mastering R: A Data Analysts Journey of Fear and Fascination

Two years ago, while taking the Google Analytics Professional Certificate course, I encountered R programming for the first time. Alongside modules like Excel, SQL, and Tableau, R seemed like a foreign language that I would have trouble understanding. My initial reaction was to. Read more...

Must know SQL Queries Every Analyst must Know

Structured Query Language (SQL) was invented by IBM in the early 1970s and has since become one of the most powerful tools for querying and analyzing relational databases. These databases store data in structured tables linked via primary and foreign keys, allowing analysts to extract insights efficiently. Read more...

Pentaho: An ETL Tool for Data Intensive Organizations - My Top 7 Transformations

In 2024, after completing various data analytics and visualization certifications, I noticed that job postings increasingly sought business intelligence analysts proficient in ETL (Extract, Transform, Load) tools. Tools like. Read more...

Unleashing the Potential of Power Query in Business Intelligence

The mobile phone industry in the 1990s and early 2000s provides a compelling case study. Initially dominated by players like Motorola, Nokia, Samsung, and Ericsson, Nokia became the market leader in 1999, capturing up to 30% market share thanks to its innovative products, strong brand appeal. Read more...

Will AI replace Analysts? A reality Check

When I became an analyst, the AI revolution was already in motion. A common narrative, especially on social media, suggested that certain professions—such as data analysis, data science, coding, and app development—were at risk of being replaced by AI. Read more...