Viswanathan R. Profile

OBJEVUJTE

5,0

(44 recenze)

Nyní sledujete

Chyba při sledování uživatele.

Tento uživatel neumožňuje ostatním uživatelům, aby jej sledovali.

Tohoto uživatele již sledujete.

Váš členský plán povoluje pouze 0 sledovaných. Aktualizujte zde.

Úspěšně odebráno sledování

Při rušení sledování uživatele došlo k chybě.

Úspěšně jste doporučili uživatele

Chyba při doporučování uživatele.

Došlo k chybě. Obnovte stránku a zkuste to znovu.

E-mail byl úspěšně ověřen.

$20 USD / hodinu

bangalore,

india

$20 USD / hodinu

Aktuálně je zde 11:51 odp.

Připojil se března 29, 2008

0 Doporučení

Viswanathan R.

@edatawiz

5,0

(44 recenze)

5,4

100%

$20 USD / hodinu

bangalore,

india

$20 USD / hodinu

98 %

Úspěšně realizované projekty

100 %

V rámci rozpočtu

100 %

Včas

15 %

Poměr opětovného zaměstnání

Data Enthusiast: Excel | Python | Data Automation

Welcome to my portfolio! I'm Vishy, also known as Viswa, a seasoned Excel and Data Automation Specialist. My expertise includes: • Automating Excel tasks and designing sophisticated Dashboards. • Tailoring Google Sheets and dashboards to meet your specific needs. • Harnessing the power of Python alongside BS4, Requests, and Selenium for Web Scraping. • Integrating Python for General Scripting to optimize your data workflows seamlessly. Through my engagement with communities and utilization of AI technology, I've honed my professional capabilities significantly. I remain committed to ongoing improvement, consistently exploring new avenues for advancement and innovation. I'm ready to enhance your data workflow and help you unlock the full potential of your data. Let's collaborate to turn your data challenges into opportunities for success. Have a wonderful day !

Zobrazit všechny Excel Experts v India

Kontaktujte Viswanathan R. ohledně vaší práce

Přihlaste se a proberte všechny podrobnosti prostřednictvím chatu.

Portfolio

Quick Dashboard using Google Sheets new formulas, Charts and Pivots

Note: This is only a sample data to show how it would look. The number and count may vary with actual figures.

Sales Processing ! Google Sheets

Features:

One for daily claim uploads:

A macro will run and examine about 19 columns to see if they require any updating. If so, it will log the updates and update them to a different page with the claims number so that it can be verified at all times.
Will add to the consolidated sheet if the claim is not present.
Claims that do not match will be deleted from the combined sheet.

Extra options: Data validation and drop-down menus are included to prevent errors during human entry. Every item will be tagged according to specific criteria, and the comment section will be updated by formulae and macros with the appropriate steps to finish the process.

Dashboard:

There will be a summary of the claims that are pending and ongoing. Here is an example screenshot (the number will display dummy values because this is only an example).

Claim Management System

A performance dashboard for project management was the goal of the project. To create a real-time update to the summary, Excel macros, pivot tables, and pivot charts are all employed.

To visualize the development, key metrics like Actual Vs. Expected completion and Yet to Recover Vs. Revenue are displayed on a trend line chart.

Project Performance Dashboard

This VBA takes as input a folder containing all of the csv files that record the delivery of data for each day, then computes a ratio for the month Max to Min, and then plots the results on a graphs. You can compare two symbols also. The drop-down, charts are automatically populated.

Attached is a sample screenshot.

Portfolio Comparison and Analysis

10822896

The project was to automate the creation of serial number based on inputs. The Excel sheet had to be automated using Forms to avoid manual errors and to speed up the process.

Excel Form - Serial Number Automation

A sample sales dashboard covering key parameters to be measured.

Sample Quick Sales Dashboard

Sales Processing ! Google Sheets

Claim Management System

Project Performance Dashboard

Portfolio Comparison and Analysis

10822896

Excel Form - Serial Number Automation

Sample Quick Sales Dashboard

Recenze

Změny byly uloženy

Zobrazeno 1 - 5 z 44 recenzí

Filtrovat recenze podle:

5,0

₹1 500,00 INR

Excel Dashboard -- 2

It was a pleasure to work with Vishwanathan and a smooth experience. He was proactive in both execution and thought process and worked well basis high level scope shared. He also was open to incorporating feedback and change requests at a short notice.

Excel

Microsoft PowerBI

Praveen K.

@pkumar0080

•

před rokem

5,0

$70,00 USD

Google sheet expert with formulas for basic project

The guy went beyond the scope Definitely hire him again

Edgar S.

@Lvtn2099

•

před rokem

5,0

₹600,00 INR

CORRECTION_SHEET_GENERATOR

He delivered the my task before time and his coordination is outstanding. He is one of the best freelancer i have worked with till now.

PHP

Visual Basic

Excel

Software Architecture

Visual Basic for Apps

Shuvam D.

@Shuvam9

•

před rokem

5,0

$10,00 NZD

Power BI Pro

Really good what he do.

Amit S.

@ammyshro1495

•

před rokem

5,0

£12,40 GBP

Help with a formula.

Viswanathan solved my problem really quickly. His responses were fast and professional. Will definitely go back to him directly next time I need help with a formula. Recommended.