Powered by
Codebasics DA Bootcamp

Goshikonda Sathish

MIS Analyst

+91 7995434258 [email protected]

Resume

Hello, I am

Goshikonda Sathish.

2

Excel Projects

2

PowerBI Projects

1

Python Project

About Me

MIS 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

Python

Advanced Excel

Power BI

My Projects

My Experience

● Prepared and delivered daily, weekly, and monthly reports in Excel/Power BI with 100% accuracy, supporting management decision-making.

● Developed and automated MIS reports in Excel using Pivot Tables, Power Query, and advanced formulas, improving reporting efficiency.

● Designed interactive Power BI dashboards to track KPIs such as sales performance, order fulfillment, and production efficiency.

● Consolidated and analyzed data from sales, production, and finance teams to provide actionable insights for management.

● Streamlined repetitive reporting tasks, reducing manual effort by 30% and increasing data accuracy.

● Supported management with data-driven decision-making through variance and trend analysis.

Awards & Certificate

Excel: Mother of Business Intelligence

Get Job Ready: Power BI Data Analytics for All Levels 3.0

SQL Beginner to Advanced For Data Professionals

Python: Beginner to Advanced For Data Professionals

Excel: Mother Of Business Intelligence

Excel: Mother Of Business Intelligence

Get Job Ready: Power BI Data Analytics for All Levels

Get Job Ready: Power BI Data Analytics for All Levels

SQL Beginner to Advanced For Data Professionals

SQL Beginner to Advanced For Data Professionals

Python For Beginner and Intermediate Learners

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.

[email protected]

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

+ 91 7995434258

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

AtliQ Hardwares Sales Analysis

p&l for markets

AtliQ Hardwares Sales Analysis

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

Vrindha Store sales analysis 2022

front page of dashboard

Vrindha Store sales analysis 2022

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

T20 World Cup Summary Scorecard

Batting Stats

T20 World Cup Summary Scorecard

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

Business Insights 360

Home Page

Business Insights 360

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

Diwali Sales Analysis using Python

Sales according to age

Diwali Sales Analysis using Python

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.