Bhawana Agrawal
(+91) 9301913905 # ï LinkedIn § GitHub
Technical Skills
Languages: SQL,Python,DAX,C
Databases: MySQL
Tools: Microsoft Excel,PowerBI,Power Point
Course Work: DataBase Management System, OOPS
Soft Skills: Communication, Problem Solving, Teamwork
Projects
Mobile Sales Dashboard | POWERBI, POWER QUERY, DAX, POWER PIVOT Link
• Developed an interactive PowerBI dashboard for real time data analysis using Mobile Sales dataset.
• Applied data extraction, transformation, and modeling to ensure accuracy and insightful visualizations.
• Designed an intuitive dashboard with dynamic charts and KPIs for enhanced decision-making.
Online Book Store | SQL, JOINS SUBQUEREIS, COMMON TABLE EXPRESSIONS(CTEs) Link
• Designed and implemented a relational database for an online book store using SQL.
• Optimized query performance and ensured data consistency across related tables.
• Cleaned and organized raw data using subqueries, joins and CTEs (Common Table Expressions).
• Generated reports that identified top-selling products, customer segments, and regional performance.
Hospital Emergency Room | MS EXCEL, POWER QUERY, DAX, POWER PIVOT Link
• Analyzed hospital emergency room data to identify peak hours, patient inflow patterns, and bottlenecks in service
delivery.
• Used Power Query to clean and transform raw datasets efficiently.
• Created dynamic dashboards and KPIs using Power Pivot and DAX for better decision-making.
Workforce Analytics Dashboard | PYTHON, SQL, WORKBENCH, MYSQL, POWERBI, EXCEL, DAX Link
• Developed a Workforce Analytics Dashboard using Power BI to analyze employee attendance patterns,work
preferences,and absenteeism trends.
• Applied data transformation techniques to clean and normalize attendance data, creating key performance metrics such
as present percentage, work from home percentage, and sick leave trends.
• Delivered actionable insights to optimize work force management and improve overall productivity.
Education
National Institute Of Technology Raipur 2022 – 2025
Master of Computer Application Raipur, Chhattisgarh
Pt.Shayam Shankar Mishra Mhavidyalaya College 2019 – 2022
Bachelor of Science Deobhog, Chattisgarh
Govt Girls H. School 2017 – 2018
Class XII Deobhog, Chattishgarh
Saraswati Shishu Mandir School 2015 – 2016
Class X Deobhog, Chattishgarh
Achievements
• Earned a 5-star rating on HackerRank, demonstrating strong problem solving and algorithmic skills.
• Secured an All India Rank of 442 in NIMCET 2022, highlighting strong analytical and
computational abilities.
• Got Certificate of Python Completion by Hakkerrank. View
(+91) 9301913905 # ï LinkedIn § GitHub
Technical Skills
Languages: SQL,Python,DAX,C
Databases: MySQL
Tools: Microsoft Excel,PowerBI,Power Point
Course Work: DataBase Management System, OOPS
Soft Skills: Communication, Problem Solving, Teamwork
Projects
Mobile Sales Dashboard | POWERBI, POWER QUERY, DAX, POWER PIVOT Link
• Developed an interactive PowerBI dashboard for real time data analysis using Mobile Sales dataset.
• Applied data extraction, transformation, and modeling to ensure accuracy and insightful visualizations.
• Designed an intuitive dashboard with dynamic charts and KPIs for enhanced decision-making.
Online Book Store | SQL, JOINS SUBQUEREIS, COMMON TABLE EXPRESSIONS(CTEs) Link
• Designed and implemented a relational database for an online book store using SQL.
• Optimized query performance and ensured data consistency across related tables.
• Cleaned and organized raw data using subqueries, joins and CTEs (Common Table Expressions).
• Generated reports that identified top-selling products, customer segments, and regional performance.
Hospital Emergency Room | MS EXCEL, POWER QUERY, DAX, POWER PIVOT Link
• Analyzed hospital emergency room data to identify peak hours, patient inflow patterns, and bottlenecks in service
delivery.
• Used Power Query to clean and transform raw datasets efficiently.
• Created dynamic dashboards and KPIs using Power Pivot and DAX for better decision-making.
Workforce Analytics Dashboard | PYTHON, SQL, WORKBENCH, MYSQL, POWERBI, EXCEL, DAX Link
• Developed a Workforce Analytics Dashboard using Power BI to analyze employee attendance patterns,work
preferences,and absenteeism trends.
• Applied data transformation techniques to clean and normalize attendance data, creating key performance metrics such
as present percentage, work from home percentage, and sick leave trends.
• Delivered actionable insights to optimize work force management and improve overall productivity.
Education
National Institute Of Technology Raipur 2022 – 2025
Master of Computer Application Raipur, Chhattisgarh
Pt.Shayam Shankar Mishra Mhavidyalaya College 2019 – 2022
Bachelor of Science Deobhog, Chattisgarh
Govt Girls H. School 2017 – 2018
Class XII Deobhog, Chattishgarh
Saraswati Shishu Mandir School 2015 – 2016
Class X Deobhog, Chattishgarh
Achievements
• Earned a 5-star rating on HackerRank, demonstrating strong problem solving and algorithmic skills.
• Secured an All India Rank of 442 in NIMCET 2022, highlighting strong analytical and
computational abilities.
• Got Certificate of Python Completion by Hakkerrank. View