Bidhan Pant | MSc. Data Science & Artificial Intelligence | dbt Certified (Analytics Engineer Loading……) | Excel, Power BI | SQL & Database Enthusiast | Python (NumPy, Pandas & Matplotlib) | NLP |

Bidhan Pant

Based in United Kingdom

About

As a passionate and results-driven Data Analyst, I thrive on transforming raw data into actionable insights that drive strategic decision-making. With a strong foundation in statistical analysis, data visualization, and predictive modeling, I bring a blend of analytical rigor and creative problem-solving to every project I undertake. Over the years, I have honed my expertise in leveraging tools like Python, SQL, and Microsoft Power BI to analyze complex datasets, identify trends, and uncover opportunities for business growth. My experience spans multiple industries, allowing me to adapt quickly and apply data-driven solutions to diverse challenges.

Skills

Projects

EDA of us-accident

In this analysis, I delved into the comprehensive dataset of US traffic accidents spanning from 2016 to 2023 to gain insights into the patterns, trends, and factors influencing road safety. Through exploratory data analysis and visualization.

Web Scraping of Forbes Global 2000: World's Largest Companies Dataset (2003-2023)

This dataset comprises data extracted through web scraping from the Forbes Global 2000 ranking, showcasing key financial metrics of the world's largest companies. Utilizing Python libraries like BeautifulSoup and requests, company-specific information such as sales, profit, assets, and market value.

Sales Insights using SQL and PowerBI

I've been diving deep into sales data and created an interactive dashboard that unlocks valuable insights into customer behavior across different markets. This empowers us to make informed decisions about resource allocation, market expansion opportunities, and product diversification strategies.

Comprehensive Consumer & Product Analytics on Global Super Store Data

I am excited to share my latest analysis on Global Super Store data, where I've uncovered some fascinating insights into consumer behavior and product performance from. Using Python, I delved into various aspects of sales, shipping, and profitability.

ATM Transaction Dashboard

This project represents the pinnacle of data analysis and visualization, designed to empower stakeholders with deep, actionable insights using: Visionary Wireframing with Mockup AI Stunning Design with Figma Dynamic Data Analysis in PowerBI

Customer Payments Insights with dbt: Jaffle Shop

This project leverages dbt (data build tool) to transform and analyze customer orders and payment data from the Jaffle Shop dataset. By implementing dbt models, tests, and documentation, I created a robust data pipeline that provides actionable insights into customer purchasing behaviors and payment

Customer Churn Analysis using SQL and Power BI

As we dive deep into customer behavior and churn analysis, it's fascinating to uncover patterns and insights that drive strategic decisions. Here's what I've found through my latest analysis, and some recommendations to boost retention.

Choco Boom Pvt. Ltd. Sales Analysis

This dashboard provides a comprehensive look at our: Total Sales: $34M Total Profit: $20.52M Shipments & Costs Boxes Used & Efficiency With interactive visualizations, we've been able to quickly identify trends, monitor profit margins, and optimize operations.

Experience

2024 - Present

MI Data Administrator at Bournemouth and Poole College - Bournemouth, England

Collaborating with MI & Funding teams to ensure high data quality, consistently aligning data capture with ESFA funding rules using tools like SQL and Excel. Administering and managing student data with precision, regularly meeting deadlines and generating actionable insights through Power BI and MIS systems. Enhancing enrolment processes, ensuring accurate data capture and financial accountability using financial software and advanced data management techniques.

2020-2023

Data and Insight Analyst at Caim Technologies - Kathmandu, Nepal

Conducted thorough data analysis to identify trends and patterns, leading to a 25% improvement in the effectiveness of cybersecurity measures Developed and maintained data models and dashboards using Microsoft Power BI and Excel, resulting in a 30% increase in the security team's ability to detect threats. Collaborated with cross-functional teams to improve data-driven decision-making processes, ensuring data integrity and accuracy in all reports, which contributed to a 20% reduction in data-related errors.

Education

2023 - 2024

MSc. Data Science and Artificial Intelligence at Bournemouth University

The Master of Science in Data Science and Artificial Intelligence program at Bournemouth University has empowered me with advanced expertise in cutting-edge technologies and techniques crucial for thriving in today's data-driven world. Through a comprehensive curriculum covering machine learning, deep learning, big data analytics, and more, I've gained practical experience and theoretical knowledge to tackle complex challenges across diverse industries. With a strong emphasis on critical thinking, problem-solving, and ethical considerations, I now emerge as a skilled professional ready to lead innovation and make meaningful contributions in data science, AI, and related fields.

2017-2020

BSc. Computer Networking and IT Security at London Metropolitan University

In my BSc in Computer Networking and IT Security, I have gained a deep understanding of network design, implementation, and management. I've also learned how to secure systems and data through comprehensive knowledge of cybersecurity principles, threat analysis, and defense mechanisms. This program has equipped me with practical skills in configuring and maintaining network infrastructure and developing robust security strategies.