Portfolio - Sarala Khadka | Codebasics

Powered by
Codebasics DA Bootcamp

Hello, I am

Sarala Khadka

Data Aspirant

Resume

1

Excel
Project

2

PowerBI
Projects

About

Me

Hi there! I'm Sarala, an enthusiastic and results-driven aspiring Data Analyst with an aptitude for converting raw data into actionable and consumable insights. I hold a bachelor's degree in Computer Science, furnishing me with technical skills crucial for securing roles in the field.

I have work experience and done several business projects on data analysis using tools like Excel, Power BI, SQL and Python. I am eager to collaborate with innovative organizations where I can apply my skills and contribute to data driven decision-making process.

Key

Skills

SQL

Project Management

My

Projects

Sales Insights of Computer Accessories

Sales Insights of Computer Accessories

It is an excel dashboard analyzing sales, customer performance, market performance of all branches located worldwide. This report includes Pivot analysis, conditional analysis, formula ma many more

Business Insights 360

Business Insights 360

The project gives quick, valuable and consumable insights of a business using Power BI. It includes several technical skills and business related concepts.

Hospitality

This interactive dashboard provides comprehensive insights into various aspects of our hotel's performance. From occupancy rates to revenue analysis, all the key metrics presented in easy-to-understand visualizations.

Contact Me

Email

[email protected]

Linkedin

https://www.linkedin.com/in/saralakhadka/

Call

+1 4695248498

Sarala Khadka

Data Aspirant

Download Resume

Resume

Excel Project

Sales Insights of Computer Accessories

It is an excel dashboard analyzing sales, customer performance, market performance of all branches located worldwide. This report includes Pivot analysis, conditional analysis, formula ma many more

Sales Insights of Computer Accessories

Customer Net Sales Data

Sales Insights of Computer Accessories

Customer Net Sales Data

Project Details

Tools Used: Excel

Description: Sales and Marketing analysis of Aroma Hardware
Process followed: ETL, Pivot analysis, VLOOKUP, conditional analysis, and more.
Outcome: Generate Customer Performance Report, Market Performance vs Target, P & L statement by Year and Month which helps enable actionable insights and drive results through its data analysis capabilities, facilitating informed decision-making and enhancing organizational efficiency.

PowerBI Project

Business Insights 360

The project gives quick, valuable and consumable insights of a business using Power BI. It includes several technical skills and business related concepts.

Business Insights 360

It is a Finance View, providing Profit and Loss Statement over the years.

Business Insights 360

It is a Marketing View where it contains key metrics like NS$, GM$, GM%, Net Profit, provides marketing insights under different regions, categories.

Project Details

I now possess a wide range of technical abilities, including proficiency in SQL, Power BI Desktop, Excel, DAX language, DAX studio, and Project charter files.
The course taught a range of skills including creating calculated columns, measures, data modeling, navigating pages, implementing dynamic titles, KPI indicators, conditional formatting, data validation, created dynamic date table using M language and sharing reports on Power BI services.

This project also covered business concepts like gross price, pre-invoice deductions, post-invoice deductions, net invoice sale, gross margin, net sales, net profit, COGS (cost of goods sold), Fiscal Year.

Project video

PowerBI Project

Hospitality

This interactive dashboard provides comprehensive insights into various aspects of our hotel's performance. From occupancy rates to revenue analysis, all the key metrics presented in easy-to-understand visualizations.

Hospitality industry's insights with our dynamic dashboard

Hospitality industry's insights with our dynamic dashboard

Project Details

In this project, we conducted a thorough analysis of the hospitality industry leveraging tools like Power BI, Excel, DAX (Data Analysis Expressions), measures, and formulas. Our goal was to gain actionable insights into various facets of the hospitality domain, revenue optimization, and operational efficiency.

Created different metrics like occupancy%, capacity, bookings, revenue, RevPAR, DBRN many more.

Project video