Kavita D. Profile

5.0

(9 reviews)

You're now following

Error following user.

This user does not allow users to follow them.

You are already following this user.

Your membership plan only allows 0 follows. Upgrade here.

Successfully unfollowed

Error unfollowing user.

You have successfully recommended

Error recommending user.

Something went wrong. Please refresh the page and try again.

Email successfully verified.

$15 USD / hour

gurgaon,

india

$15 USD / hour

It's currently 12:33 AM here

Joined August 9, 2013

1 Recommendation

Kavita D.

@kavitadhingra

5.0

(9 reviews)

3.2

91%

$15 USD / hour

gurgaon,

india

$15 USD / hour

100%

Jobs Completed

100%

On Budget

100%

On Time

14%

Repeat Hire Rate

Excel | VBA | Macro| PowerBI | Googlesheets | VA

Hi, I am a professional with 15 years of Industry experience in various technologies like Power BI, SQL Server, excel ,VBA, SQL server, MS office, SSIS. I worked on multiple Power BI projects with different data sources like SQL server, Oracle, Azure databricks, Excel sharepoint. I have around 10 years of experience in Excel VBA and macros. I worked on multiple automation projects as well. With my extensive experience, I can help you with your projects in Power BI and Excel automation.

See all Excel Experts in India

Contact Kavita D. about your job

Portfolio

This project was to analyze the data for Gas Station. There are different types of fuels being sold at the Gas Station. Client wanted to analyze which fuel type is majorly sold, the weekly trend of all fuel type sold. There are multiple Convenience stores as well at every Gas Station. The second thing, client was to analyze was the most sold product/ product category on convenience store.

I imported the data into Power BI, transformed the data to create different useful insights from that. Then I designed a professional power BI report to analyze the facts.

Gas Station Analysis

Client provided me a financial sheet, including profit & loss statement, balance sheet and a cash flow statement.
I need to create a data model and visualize the data in form of a dashboard for her so that she can use and analyze the data.

Financial Dashboard

Created a Power BI dashboard with HR sample data to show different KPIs of HR
1st page shows the new hired employees KPI like ratio of new hires by Gender and by region
2nd page shows the employees leaving the organization.

Power BI HR Dashboard

Gas Station Analysis

Financial Dashboard

Power BI HR Dashboard

Reviews

Changes saved

Showing 1 - 5 out of 9 reviews

Filter reviews by:

5.0

₹1,200.00 INR

Excel Task Automation via Programming and Macros

Good Work on time. Shall highly recommend for Automation works in excel.

Visual Basic for Apps

Slabs E.

@slokhandw

•

4 months ago

5.0

₹4,000.00 INR

Log to maintain service record and customer database

Very professional approach towards assinged task.

Deven D.

@Devenpd

•

6 months ago

5.0

₹2,200.00 INR

Basic Excel sum calculation

It is good working with Kavita. She is very patience during solving the issues. She has very expertise on the VBA and looking forward to work with her in future.

Pravallika J.

@pravallika14398

•

8 months ago

5.0

₹1,500.00 INR

Basic Excel project to copy paste rows

I was satisfied with the work done and she has expertise in VBA which helped me achieve my requirement. Apart from that she was very responsive and handled the work on time.

Visual Basic

Excel

Pravallika J.

@pravallika14398

•

9 months ago

5.0

₹1,200.00 INR

VBA Macro development -- 2

Please follow above ratings

Visual Basic

Excel

Software Architecture

Visual Basic for Apps

VB.NET

Smit S.

@smitsanghavi23

•

9 months ago

Experience

WNS Global Services

May 2012 - Jul 2022 (10 years, 2 months)

I have total 15 years of Industry experience in various technologies like Power bi, SQL server, oracle, ssis, vba, excel. I have 6+ years of experience in Power BI. I have completed multiple assignments in Power BI.

Colt Technologies

Nov 2009 - May 2012 (2 years, 6 months)

I have 15 years of experience in different technologies like Power bi, SQL server, oracle, ssis, vba, excel.

WNS Global Services

Oct 2007 - Nov 2009 (2 years, 1 month)

• Automation of reports and dashboards using macros on Excel, VBA, MS-Access and SQL server • Identify and prioritize current and future information needs • Developing templates/tools in MS Excel, VBA Access and SQL server. • Testing and debugging the projects at our end • Modification and enhancement in the working of existing MIS project