p
premranjan618

Prem Ranjan

@premranjan618

Data Analyst, Power BI, Excel, SQL, Python

Inde
Anglais
Certaines informations sont présentées en anglais.
À propos de moi
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!... Plus d’infos

Compétences

p
premranjan618
Prem Ranjan
hors ligne • 
Temps de réponse moyen de 1 heure

Voir mes services

Tableaux de bord des données
I will create an interactive power bi dashboard and reports
De5 $US / projetPlus de détails
Tableaux de bord des données
I will design professional excel dashboard and data visualization
De5 $US / projetPlus de détails

Portfolio

Expérience professionnelle

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.