Powered by
Codebasics Data Analytics Bootcamp

Dharmana Leelambara Datta

Fresher

Hello, I am

Dharmana Leelambara Datta.

4

PowerBI Projects

1

Excel Project

About Me

As an aspiring data analyst, I am passionate about unraveling complex insights hidden within vast datasets to drive informed decision-making and facilitate positive change. With a solid foundation in statistical analysis, data visualization, and programming languages like Python, I am eager to leverage my skills to tackle real-world challenges. My commitment to continuous learning and my ability to communicate insights effectively make me a valuable asset in the pursuit of data-driven solutions. Together with a collaborative spirit and a drive for excellence, I am poised to contribute meaningfully to the field of data analysis and make a tangible impact in shaping a better future.

Key Skills

My SQL

Python

Data Visualization

Data Mining

Continuous Learning

Communication

Power BI

Advanced Excel

My Projects

My Experience

Data Analyst Intern
AtliQ Technologies | Virtual Internship(4 weeks)

During my 4-week virtual internship at AtliQ Technologies, I had the opportunity to work as a Data Analyst Intern, where I successfully completed various tasks that included:

Data Cleaning
Data Validation
Reporting
Client Handling (Insurance Domain)

I actively participated in all assigned tasks and demonstrated a strong willingness to learn, grow, and contribute to the team. My enthusiasm, professionalism, and analytical skills were key assets during this experience.

Testimonial:

"Dharmana Leelambara Datta displayed exemplary dedication and skill throughout the course of this internship. Their enthusiasm, professionalism, and analytical skills were invaluable to our team. As they move forward in their career, we are confident that they will continue to build upon the strong foundation established during this internship and will continue to make significant contributions to their future employers. We wholeheartedly wish them the very best in their future endeavors."

— Dhaval Patel, Co-Founder, AtliQ Technologies

Let's Connect

Feel free to get in touch with me. I am always open to discussing new projects, creative ideas or opportunities to be part of your visions.

https://www.linkedin.com/in/dharmana-leelambara-datta/

PowerBI Project

Analyse Growth & Present Insights to the Telangana Govt. Resume Project Challenge-7

Domain/Function: Government

Telangana Prosperity Initiative: Data-driven analysis to address socio-economic challenges, leveraging insights from e-challan usage, stamp revenue, sector dominance, and investment trends. Empowering the government for informed decisions.

View Project
Engagement

View Project
on GitHUB

Other Tools

Canva

Microsoft Power Point

Analyse Growth & Present Insights to the Telangana Govt. Resume Project Challenge-7

This describe about the project in detail

Analyse Growth & Present Insights to the Telangana Govt. Resume Project Challenge-7

It describe about Telanagana prosperity and richness.

Project Details

The Telangana Prosperity Initiative is a comprehensive project aimed at identifying and addressing socio-economic challenges hindering the state's progress. Utilizing data-driven strategies and insights from various sectors like e-challan usage, stamp revenue, and sector dominance, we aim to empower the government with actionable recommendations for sustainable development. Together, we're forging a path towards a prosperous and thriving Telangana.

Project video

Live Interactive Dashboard

Excel Project

Sales and Finance Analytics

Domain/Function: Sales and Finance

Sales Report: Analyzed customer performance metrics and compared market performance to sales targets. Finance Report: Created annual P&L reports and generated market-segmented P&L reports.

View Project
Engagement

View Project
on Excel

Sales and Finance Analytics

This Project tells about Sales and Finance Analytics

Sales and Finance Analytics

The table of contents in a nutshell

Project Details

The purpose of the sales analytics report was to monitor sales activities and provide strategic insights to help guide decision-making. The finance analytics report focused on evaluating financial performance through annual and segmented P&L reports to support overall business decisions. The project required expertise in ETL methodology, generating date tables with Power Query, establishing data model relationships using Power Pivot, and creating calculated columns with DAX. In addition to technical skills, the project emphasized designing reports with a user-centric approach, optimizing report efficiency, and developing structured, systematic reporting methods.

Project video

PowerBI Project

Provide Insights to the Executive Team in the Telecom Domain

Domain/Function: Telecom Executive Management

AtliQo is one of the leading telecom providers in India and launched its 5G plans in May 2022 along with other telecom providers. However, the management noticed a decline in their active users and revenue growth post 5G launch in May 2022.

View Project
Engagement

Provide Insights to the Executive Team in the Telecom Domain

KPI View

Provide Insights to the Executive Team in the Telecom Domain

Market Share View

Project Details

This project involved analyzing AtliQo's telecom data to understand the impact of the 5G launch on revenue and KPIs. The report highlights revenue analysis, underperforming KPIs, and the evaluation of 5G plan performance. Based on these findings, strategic recommendations were made to optimize internet plans, boost revenue, and increase user retention. This data-driven analysis is intended to support informed decision-making for AtliQo’s management.

Project video

Live Interactive Dashboard

PowerBI Project

AtliQ Presence Insights - HR Data Analysis Dashboard

Domain/Function: HR Management

In this project, I developed an HR Data Analysis Dashboard for AtliQ using Power BI, leveraging data from Excel files. The dashboard tracks key workforce metrics such as Presence %, Work-from-Home %, and Sick Leave %, providing insights

View Project
Engagement

AtliQ Presence Insights - HR Data Analysis Dashboard

HR Analytics Dashboard

AtliQ Presence Insights - HR Data Analysis Dashboard

It tells abbout all types of modes of work and type of leaves abbrevation

Project Details

This project involved creating an HR Data Analysis Dashboard using Power BI, sourced from Excel files. It tracks key HR metrics such as Presence %, Work-from-Home %, and Sick Leave %. The dashboard features interactive visuals that allow for deep analysis of employee trends across departments and time periods, providing actionable insights for optimizing workforce productivity and engagement. This project showcases my skills in data visualization and HR analytics for improving decision-making in HR management.

Live Interactive Dashboard

PowerBI Project

Shield Insurance Analysis

Domain/Function: Insurance

Developed dynamic Power BI dashboards to analyze customer demographics, revenue trends, and sales performance for Shield Insurance, uncovering actionable insights to drive business strategy.

View Project
Engagement

Shield Insurance Analysis

The Entire analysis parts in a nutshell

Shield Insurance Analysis

Customer Analysis Mockup Similarly it contains mockup of others too.

Project Details

During this virtual internship, I segmented customers by age group and city, tracked revenue growth, and analyzed sales modes. Key insights included identifying top-performing age groups and regions, understanding seasonal trends in customer and revenue growth, and evaluating sales channels for strategic optimization. This project provided valuable business intelligence to enhance decision-making and operational efficiency for Shield Insurance.

Project video

Live Interactive Dashboard