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