Skip to main content

Marketing analysis enables digital marketers to drive meaningful business growth.

Marketing analysis enables digital marketers to drive meaningful business growth. In today’s competitive digital marketing landscape, leveraging data analytics is crucial for driving business growth. As a digital marketer cum analyst, mastering Excel analytics can transform raw marketing data into strategic insights that drive revenue, optimise campaigns, and enhance customer experiences. This article delves into a real-world Excel analysis of a 10,000-entry marketing dataset (marketing_data_xlsx), focusing on the 'Electronics' product category. We'll examine year-over-year (YoY) purchase amount growth segmented by marketing channels, alongside customer satisfaction trends and their correlations, all based on actual filtered data from 2023 and 2024. By incorporating tools like pivot tables , the FILTER function , and correlation formulas , marketers can identify high-performing channels and make data-backed decisions to fuel growth. Why Excel Analytics Is Crucial for ...
Post a Comment

about saikat

Saikat Bhattacharjee

Digital Marketer | Digital Marketing Analyst | Business Analyst | Storyteller through Numbers
Kolkata, South 24-Parganas, India
Feed: News Feed | Social Link: Saikat Bhattacharjee


saikat_image

In today's fast-moving digital world, businesses are constantly looking for ways to grow online. The internet is full of opportunities, but making the right decisions can be tough without the right guidance. That’s where people like Saikat Bhattacharjee come in.

Born on 19th July 2000, Saikat is a Digital Marketing Analyst and Digital Marketer from Kolkata, South 24-Parganas. What makes him special is his ability to turn complex numbers into useful insights. These insights help businesses grow, improve their online presence, and connect better with their audience. Through his skills and passion, he is helping brands use data to make smarter, faster, and more effective marketing decisions.

Strong Educational Background

Saikat’s journey began with a deep interest in how businesses work. He completed his graduation in Accounting and Finance (Hons.) from Seth Anandram Jaipuria College, where he learned the basics of financial systems, budgeting, and business strategies.

Not stopping there, he decided to take a step further and is currently pursuing an MBA in Business Analytics & Data Science from the Bengal Institute of Business Studies (BIBS). This academic path is helping him combine business understanding with technical and analytical skills – a powerful mix for today’s digital world.

Internship at Keylines Digitech

Currently, Saikat is working as a Data Analyst Intern at Keylines Digitech (July 2025 – December 2025). Keylines is a digital agency that helps businesses grow through digital marketing services like SEO, PPC, website development, and more.

At Keylines, Saikat is responsible for:

  • Analysing digital marketing campaign data

  • Tracking how audiences behave online

  • Creating meaningful dashboards and visual reports

  • Helping in strategic decision-making

He works directly with performance metrics to see what’s working and what needs improvement. Through his detailed analysis, campaigns become more focused and cost-effective. For Saikat, every click, impression, or user action tells a story – and he knows how to read it.

Certified and Skilled

Saikat believes in constant learning. He has earned several industry-recognised certifications to stay updated and improve his expertise.

Here are a few of his achievements:

  • Machine Learning & Tableau and Advanced Excel – from IIT Kanpur

  • Business Analytics and Data Science – from IBM

These certifications help him blend traditional marketing with modern data science techniques. He uses machine learning to understand trends, Excel to clean and manage data, and Tableau to visualise it all in easy-to-understand dashboards.

His Technical Toolkit

What makes Saikat stand out is his technical toolkit – a mix of digital marketing knowledge and analytical skills. Here’s a closer look at what he offers:

Digital Marketing Expertise:

  • Search Engine Optimization (SEO): Improving a website’s visibility on Google

  • Pay-Per-Click (PPC): Creating ads that attract the right audience with the best budget

  • Social Media Marketing (SMM): Engaging users on platforms like Facebook, Instagram, and LinkedIn

  • Content Strategy: Planning content that connects with audiences and drives traffic

Data Analysis Skills:

  • Python: For data cleaning, analysis, and automation

  • Excel (Advanced): For data formatting, formula creation, and dashboard reporting

  • SQL: For handling and querying large databases

Dashboard and Reporting:

  • Power BI, Tableau, and Looker Studio: Tools he uses to build stunning and informative dashboards

  • Google Analytics: For tracking website performance and user behaviour in-depth

With this combination, he doesn’t just create reports – he creates clarity. Whether it’s a startup or a large brand, his dashboards help businesses make quick, informed decisions based on real-time data.

Why Saikat Loves Data

Saikat is not just a numbers person. He is deeply curious about how businesses work – and why they sometimes don’t. He often says that every business problem has a hidden answer in its data.

saikat_bhattacharjee_image


His goal is to:

  • Find those answers

  • Turn them into actions

  • Make businesses grow smarter, not just bigger


He believes that data is not just for analysts – it should be useful for marketers, managers, and even business owners. That’s why he always presents complex data in a simple and practical way.

Sharing Knowledge with the World

Another great thing about Saikat is his willingness to share knowledge. He often writes blogs, case studies, and campaign insights to help others understand how digital marketing and data go hand-in-hand.

In his content, you’ll find:

  • Real-world marketing campaign breakdowns

  • Lessons from past projects

  • Tips to use analytics tools better

  • Strategies to grow online with limited budgets

His writing style is simple, friendly, and practical – perfect for beginners and experienced marketers alike.

A Voice for Data-Driven Marketing

Digital marketing today is not just about creativity – it’s also about understanding numbers. Businesses need people who can see what’s really happening behind the scenes.

That’s where Saikat plays an important role. He:

  • Translates data into strategy

  • Helps businesses focus on what truly matters

  • Ensures marketing efforts are backed by real evidence

In short, he brings clarity to the world of digital chaos.

The Road Ahead

As Saikat continues his MBA journey and internship, his future looks bright. He dreams of building more impactful dashboards, working with large datasets, and helping brands scale using smart data decisions.

His long-term goals include:

  • Leading a data analytics team

  • Contributing to digital growth for small businesses in India

  • Making digital marketing more data-focused and accessible

Saikat also wants to make Kolkata a hub for digital analytics talent by training others and spreading awareness about the power of marketing analytics.

Conclusion

In the world of digital marketing, every click, view, and share matters. But what matters even more is how you understand and use that data.

Saikat Bhattacharjee is one of those rare professionals who knows how to connect the dots between raw numbers and real-world marketing success. With strong technical skills, a business mindset, and a passion for learning, he is not just building a career – he’s building the future of data-driven marketing.

Whether you're a business owner, a marketing professional, or someone new to the world of analytics, there’s something to learn from Saikat’s journey. His story is a reminder that with the right mix of curiosity, tools, and learning, anyone can turn data into decisions – and decisions into success.

Comments

Post a Comment

Popular posts from this blog

The Timeline That Defined the Rise of Artificial Intelligence.

The Timeline That Defined the Rise of Artificial Intelligence. Introduction The beginning of artificial intelligence (AI) started with a legend. There were tales of machines as human as can be, such as Talos, a giant made of bronze, and the Golem, a clay creature to be awakened. Inventors created simple machines imitating human and animal movement over the years, keeping the vision of AI alive. In the 1940s, the concept of a thinking machine was becoming serious.  The development of digital computers led people to feel that human thought could be replicated by machines. In 1956, a team of researchers formally began AI research at the Dartmouth Workshop.  Governments provided them with plenty of m...
Post a Comment
Read more

The History of Marketing: From 1.0 Basics to 6.0 Smart Tech

The History of Marketing: From 1.0 Basics to 6.0 Smart Tech Introduction Marketing is always in motion. It's an ever-changing narrative. Just treat it like a living entity, constantly evolving with new technologies, how people live, and the evolution of society. That's something any business has to understand. It keeps you part of the game and on your toes in a busy world. We will talk about the early steps, Marketing 1.0 to 3.0. Those early steps are what the present is based on. But then what? What will marketing in the future consist of? We will talk about that as well. Marketing 1.0: The Product-Centric Era Marketing was easy. There were factories that produced a lot of products, and all the businesses wanted to do was just sell them. They just wanted to sell their goods to as many people as possible. The History of Mass Advertising Early advertising was mass-targeted. Imagine a Ford Model T commercial in the newspaper. This period employed print, radio, and e...
Post a Comment
Read more

Why Your Marketing Strategy Needs Machine Learning Now

Why Your Marketing Strategy Needs Machine Learning Now Introduction Marketing for decades depended on guesswork and general assumptions. Things are however changing with the advent of machine learning (ML), focusing attention away from guesswork to data-driven decision-making. Machine learning algorithms are no longer tomorrow's novelties; they're already transforming the manner in which marketers interact with audiences, optimize campaigns, and ultimately drive business outcomes. It's a model proving to be priceless with the ability to personalize, predict customer needs, and optimize ROI. Let's examine how some algorithms are disrupting the game in different marketing fields. Customer Segmentation: Getting to Know Your People on a Deeper Level At the heart of effective marketing is understanding your audience, and it starts with segmentation. Segmentation used to depend on coarse demographics. Now, machine learning algorithms, and K-Means Clustering in particu...
Post a Comment
Read more

Back to Home

© 2025 Saikat's Blog. All Rights Reserved.