Portfolio - Goshikonda Sathish

Goshikonda Sathish

Assistant Engineer

Resume

2

Excel Projects

2

PowerBI Projects

1

Python Project

About Me

Iam an aspiring Data Analyst.I know how to analyse data and get insights using Excel,Power BI,SQL & Python

I have my bachelor's degree in Civil Engineering but i found my natural abilities in data analysis

Though i haven't worked in an organization before I have done several business projects which i have showed in my portfolio below

Key Skills

MYSQL

Python

My Projects

AtliQ Hardwares Sales Analysis

Vrindha Store sales analysis 2022

T20 World Cup Summary Scorecard

Business Insights 360

Diwali Sales Analysis using Python

Awards & Certificate

Excel: Mother Of Business Intelligence

Get Job Ready: Power BI Data Analytics for All Levels

SQL Beginner to Advanced For Data Professionals

Python For Beginner and Intermediate Learners

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.

Download Resume

Resume

Mail Me

[email protected]

https://www.linkedin.com/in/sathish-goshikonda-2741b6193/

Call Me

+91 7995434258

GitHub

https://github.com/rgsathish45/

Excel Project

AtliQ Hardwares Sales Analysis

AtliQ Hardwares Sales Analysis using Excel,here we have done data cleaning with power query,data processing ,data transformation,data visualization in the end p&l reports are done

View Project
Engagement

View Project
on GitHUB

p&l for markets

by fiscal year

Project Details

Project objective:

1. Create Profit and Loss (P&L) reports by Fiscal Year & Months

2. Create Profit and Loss (P&L) reports by Markets

Purpose of sales analytics: Evaluation of financial performance, support decision-making, and facilitate communication with stakeholders.

Importance of analyzing Finance data: Aid in benchmarking against industry peers and previous periods Foundation for budgeting and forecasting.

Role of reports: Align financial planning with strategic goals Instill confidence in the organization's financial outlook.

Excel Project

Vrindha Store sales analysis 2022

Purpose of sales analytics: Empower businesses to monitor and evaluate their sales activities and performance. Importance of analyzing sales data: Identify sales patterns and track key performance indicators

View Project
Engagement

View Project
on GitHUB

front page of dashboard

Sales in month of april by amazon

Project Details

Project objective:

Project objective: (https://github.com/rgsathish45/Vrindha-Store-Annual-report-2022/blob/main/Vrinda%20Store%20Data%20Report.xlsx)

Purpose of sales analytics: Empower businesses to monitor and evaluate their sales activities and performance.

Importance of analyzing sales data: Identify sales patterns and track key performance indicators
Role of reports: Determine effective customer discounts, facilitate negotiations with consumers, and identify potential business expansion opportunities in promising countries.

Project video

PowerBI Project

T20 World Cup Summary Scorecard

This is cricket T20 world cup Dashboard in this we have 4 screens 1)Home 2)Overview 3)Batting Stats 4)Bowling Stats insights are produced based on their perfomances

View Project
Engagement

Other Tools

Power Query

Batting Stats

Overview of T20 World Cup

Project Details

To create cricket T20 World Cup Dashboard
Cleaning Data like rain matches are removed and null values
Transformations are done in power Query

Project video

Live Interactive Dashboard

PowerBI Project

Business Insights 360

AtliQ Hardware, a rapidly expanding global consumer electronics company, has been grappling with unwieldy Excel files for data analytics. This outdated approach has been hindering effective decision-making and causing significant losses.

View Project
Engagement

Other Tools

MySQL

Excel

Dax Studio

Home Page

Sales View in the Dashboard

Project Details

AtliQ Hardware produces products in their manufacturing units and sells this product to various cutomers like Croma,Best Buy,Staples,Flipkart,etc.
AtliQ Hardware's business is growing rapidly but they still rely on excel files for data analytics.This has led to significant losses in Latin America.
To address this challenge, our data analytics project aims to revolutionize AtliQ's business model by replacing excel-based analytics with powerful and data-driven solutions

Project video

Live Interactive Dashboard

Python Project

Diwali Sales Analysis using Python

Married women age group 26-35 yrs from UP, Maharastra and Karnataka working in IT, Healthcare and Aviation are more likely to buy products from Food, Clothing and Electronics category

View Project
Engagement

View Project
on GitHUB

Other Tools

Excel

Matlpotlib

Seaborn

Pandas

Numpy

Sales according to age

Project Details

Conduct exploratory analysis to understand the characteristics of the data. This may involve creating visualizations like bar charts, line plots, and histograms to observe sales trends, peak sales days, popular products, and customer behaviors during Diwali.