Portfolio - Nishikant Kumar Sah

Nishikant Kumar Sah

Power BI Analytics at Freelance

Resume

1

Excel Project

4

PowerBI Projects

1

SQL Project

About Me

Hello! Im Nishikant Sah, a dedicated Data Analyst with over two years of experience in transforming raw data into meaningful insights. My passion for data analysis drives me to uncover the stories hidden within datasets and present them in a way that facilitates strategic decision making.

Key Skills:
*Data Analysis & Visualization
*Data Cleaning & Management
*Excel Reporting
*Dashboard Reporting
*Power BI
*Data Cleaning
*Business Intelligence BI
*Ad Hoc Analysis
*Statistical Analysis
*Problem Solving
*ETL Processes Extract, Transform, Load

I can Provide You Work using Software:
* Advance Excel / Microsoft Excel
* Power Bi
*Power Query
* Python
* Looker
* SQL Ad hoc Analysis
*BI Software
*Google Data Studio
*Python/R

Lets connect and explore how my expertise can contribute to your success. Reach out to discuss your project needs and let’s turn your data into a powerful asset!

Key Skills

SQl

Power Query

Power Pivot

Python

Data Modeling

ETL

My Projects

AtliQ Hardware Sales Report

Domain/Function: Hardware Company Sales Analysis

AtliQ Business 360

Telangana Growth Analysis

AtliQ Hospitality Insight

Domain/Function: Hospitality Analysis

Insight of Codex Marketing Performance - [Power BI | MySQL | Python]

AtliQ-Hardware-Market-Performance-Analyst

My Experience

Junior Engineer Trainee Hitachi Astemo

Compiled and maintained daily production reports using advanced Excel functions, including VLOOKUP, XLOOKUP, Pivot table and Power Query.
Orchestrated the creation and maintenance of highly-detailed shift-wise reports, ensuring 100% data accuracy and alignment with company standards; instrumental in mitigating compliance risks and enabling informed decision-making processes.

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

APPERICIATION Certificate of Participation on Telangana Growth Analysis

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/nishikantsah/

Call Me

+91 9060476020

GitHub

https://www.novypro.com/project/nishikant-sah

Excel Project

AtliQ Hardware Sales Report

Domain/Function: Hardware Company Sales Analysis

AtliQ Hardware Sales Report of Costumer net Sales, Performance of Market ,All properties Performance.fY_year Performance. Performance by Month and Year

View Project
Engagement

View Project
on GitHUB

Market Performance vs Target

Market Performance Target

Project Details

create a Comprehensive Costumer Net Sales Performance and Compare market sales performance vs targets.
Empower business to monitor and evaluate sales activities, identify patterns.
Developed profit & Loss Statement repots categized by Fiscal year, months and market.

PowerBI Project

AtliQ Business 360

Atiq Hardware 360 project based on Brick & mortar and e-commerce . This project has marketing view insight, Finance vie w insight, Sales view Insight, Executive View insight.

View Project
on GitHUB

In this Excutive View discovered by KPI of Net sales,GM% , Net Profit% , Forecast Accuracy and Key Insight by subzone.

In this Marketing view discovered by Coustumer performance , product performance and trend of sales by region.

Project Details

Established a Power BI dashboard gathering sales data from 2 different sources (Excel/CSV files and a SQL database). Optimized
with DAX Studio, resulting in a 5% performance boost and projected 10% revenue growth and 20% data-related expense reduction
the revenue at least by 7% in the next quarter

Live Interactive Dashboard

PowerBI Project

Telangana Growth Analysis

This project basically based on Telangana Growth Analysis . Through this project Insights Telangana state government can take decision of Investment and Implement New Idea according to district of Telangana.

View Project
Engagement

View Project
on GitHUB

Insight data on the revenue generated from document registrations and E-stamp challan payments aggregated at the district and monthly level.

Data Insight about the individual vehicle sales data from the RTA(Regional Transport Authority) of the state of Telangana categorized by fuel type,

Project Details

Telangana is one of the fastest-growing states in India and one of the states so Ensure that which District Performance Better
which Area has more opportunity to Growth and which District is Good for Investment.
Utilized Power BI functions, Including DAX and Power Query, to gather, clean, and transform data from multiple ensuring.
accurate and reliable insight.

Project video

Live Interactive Dashboard

PowerBI Project

AtliQ Hospitality Insight

Domain/Function: Hospitality Analysis

This project is based on OY O Hotel room Business's Insights of monthly trends and weekly trenda . In this project considered by revenue, RevPAR, dsrn and weekly trends and also consider about weekday and weekend.

View Project
on GitHUB

in this page discovered by Revenue,Revpar,dsrn and weekly trends.

This is the tooltip page, and this is the visual of Revenue by week no. and category..

Project Details

Atiq Grands noticed a loss in their market share and revenue over a few months. To diagnose the cause of this loss, they needed a
way to analyze this. I streamlined a dashboard in Power BI using 3 months of data.
With this dashboard, the Revenue team of Atiq Grands was able to gain insights into their revenue trend. This could help in

Live Interactive Dashboard

PowerBI Project

Insight of Codex Marketing Performance - [Power BI | MySQL | Python]

Codex is a German beverage company that is aiming to make its mark in the Indian market. A few months ago, they launched their energy drink in 10 cities in India. In this Project covered by Insights of Codex marketing view.

View Project
on GitHUB

Who prefers energy drink more? (male/female/non-binary?) Which age group prefers energy drinks more .

What do people think about our brand? (overall rating) b. Which cities do we need to focus more on

Project Details

Analyzed the energy drink market in India for Company - Codex, focusing on the F&B industry and marketing function.
Discovered that 70% of energy drink consumers prioritize convenience and portability, making cans the preferred packaging style.
Used data-driven decisions and recommendations based on the insights derived from the dashboard, resulting in a 20% increase
in data-directed decision-making.

Live Interactive Dashboard

SQL Project

AtliQ-Hardware-Market-Performance-Analyst

: The project had a significant impact on AtliQ Hardware. By using the insights I generated, the company was able to make informed decisions regarding product development, marketing strategies, and market expansion. This led to increased market share and improved profitability.

View Project
Engagement

View Project
on GitHUB

Report of Gross Sales report

Generate Yearly report for croma India

Project Details

Conducted comprehensive market analysis using SQL functions to identify key performance metrics, market trends, and
competitive insights, enabling data-driven decision-making for the company.
Created visually compelling reports and dashboards using SQL to present findings in a user-friendly manner, facilitating easier
communication of results to stakeholders and enhancing overall business understanding.