p
premranjan618

Prem Ranjan

@premranjan618

Data Analyst, Power BI, Excel, SQL, Python

India
Engels
Sommige informatie wordt in het Engels weergegeven.
Over mij
Hi, I’m Prem Ranjan, a professional Data Analyst. I specialize in turning complex data into clear, actionable insights using Excel, Power BI, SQL, and Python. What I offer: Interactive Dashboards: Professional Excel & Power BI visuals. Data Technicality: Skilled in SQL for database queries & Python for automation. Data Cleaning: Transforming messy data into structured, accurate reports. Business Insights: Identifying trends to help you make smarter decisions. I focus on accuracy, clean design, and fast delivery. Let’s bring your data to life!... Lees meer

Skills

p
premranjan618
Prem Ranjan
offline • 
Gemiddelde reactietijd: 1 uur

Bekijk mijn diensten

Data dashboards
I will create an interactive power bi dashboard and reports
VanafUS$ 5 / projectMeer informatie
Data dashboards
I will design professional excel dashboard and data visualization
VanafUS$ 5 / projectMeer informatie

Portfolio

Werkervaring

Freelancing_Career

Data Analyst

Freelancing Career • Freelance

Apr 2026 - Present • 3 mos

Freelance Data Analyst (Self Projects) I am a detail-oriented data analyst with hands-on experience in Excel, Power BI, SQL, and Python. I have successfully completed multiple self-driven projects, transforming raw business data into interactive and actionable insights. Excel Expertise: Developed professional Excel Dashboards using Pivot Tables, Slicers, and Advanced Formulas. Performed extensive data cleaning, lookup functions (VLOOKUP/XLOOKUP), and data validation to ensure error-free reporting. Power BI Visualization: Created dynamic dashboards to track sales performance, customer behavior, and product trends. Built complex DAX measures and utilized Power Query for efficient data transformation. SQL Analysis: Experienced in querying databases using JOINs, CTEs, Aggregations, and Window Functions to extract and analyze data for business decision-making. Statistical Foundation: Applied basic statistics (data distribution, probability) to interpret data accurately and provide meaningful business recommendations. I focus on delivering clean, accurate, and visually appealing data solutions that help businesses optimize their performance through data-driven strategies.