Built with datascienceportfol.io

Aditya Kumar Pandey

Data Analyst

Based in West Bengal, India

About

A Information Technology graduate in Data Visualization and Data Analytics . I hold certifications from TABLEAU ,POWERBI , SQL . I love to build Dashboards/ Reports using Tableau & PowerBI and present it in appealing way to give more power to your raw data. In addition to this i am very good in SQL , databases , ETL , Data warehouse Work Experience : 4 years 1) Tableau Software and Platform : *****(Certified Expert) 2) Tableau Server/ Online : **** (Expert) 3) Power BI Software and Platform : **** (Expert) 4)Excel Dashboard : **** (Advanced) 5)SQL SERVER , Data Modelling : *** (Advanced) My Clients : 1. 10+ Fortune 500 Companies(Retail , HealthCare , Travel) 2. 40+ Small Business Owners and Startup from US, UK , AUS , Singapore , Middle East, Ireland 3. Educational Institutes and NGOs

Skills

Projects

Experience

2024- Present

Data Analyst at PONKA Ltd.

In my current role at PONKA, I work on 1) BI Dashboarding & Analytics: Design and maintain interactive quality-control dashboards in Power BI and Tableau to monitor tagging accuracy and track data anomalies in real time. 2) Advanced Calculations (DAX & LOD): Optimize data models by writing complex DAX measures in Power BI for automated data validation, and utilize Tableau LOD expressions (FIXED, INCLUDE) to perform granular, multi-level brand analysis. 3) Data Standardization & Modeling: Cleanse and standardize massive datasets of brand domains. Map complex brand hierarchies to ensure absolute data integrity for downstream analytics. 4) Spreadsheet Automation: Deploy advanced Excel/Google Sheets

2021-2024

Trainee Engineer / Freelancer

Education

2024- Present

BTech in Information Technology

2023

MASTER DATA SCIENCE PROGRAM

2023

Certificate of Completion Python

2023

Certified professional in Advance Programing

2023

Chatgpt for Everyone

2023

Chatgpt Prompt Engineering for Developer's