☰

WELCOME TO MY PORTFOLIO

Hi, I'm Lorens Mishra
Data Analyst & Business Intelligence Professional

I specialize in transforming raw data into actionable business insights using SQL, Power BI, Excel, and Python.

Passionate about KPI tracking, dashboard development, and data-driven decision making.

View My Projects Contact Me
Find Me On
Best Skills On
Power BI Excel MS Office Jira MySQL
Lorens Mishra

About Me

I am an MCA graduate (8.90 CGPA) with professional experience as a Software Engineer.

I am currently working at Knack Global Pvt. Ltd. as a Junior Software Engineer.

My primary interest lies in Data Analytics and Business Intelligence.

I work with SQL, Power BI (DAX & Power Query), Excel Dashboards, Python, and Jira to clean data, perform analysis, and create performance reports.

I focus on converting raw datasets into structured insights that help organizations track KPI performance, identify trends, and support data-driven decisions.

I have built 6+ data analytics projects including Power BI dashboards, exploratory data analysis (EDA), SQL reporting systems, and machine learning models.

6+ Projects 5+ Tools 1+ Years Experience

Core Strengths

  • ✔ Data Cleaning & ETL
  • ✔ Dashboard Development
  • ✔ SQL Query Writing
  • ✔ Business Performance Analysis
  • ✔ Reporting & Visualization
  • ✔ Data Modeling

Technical Skills

Python

Java

C

Jira

Jira

Dashboard

Dashboard

Power BI

Power BI

Pipelining Icon

Pipelining

SQL

Excel

GitHub

Git

Domo

MS Office

Python

Java

C

Jira

Jira

Dashboard

Dashboard

Power BI

Power BI

Pipelining Icon

Pipelining

SQL

Excel

GitHub

Git

Domo

MS Office

Achievements & Coding Profiles

LinkedIn

LinkedIn

👤 Professional Profile

📊 Data Analytics Journey

View Profile
GitHub

GitHub

📂 Code Repository & Projects

💻 Portfolio Hosting

View Profile
LeetCode

LeetCode

🧠 DSA Problem Solving

🐍 Python Practice

View Profile
HackerRank

HackerRank

🗄 SQL Practice & Certification

📊 Query Writing

View Profile
Kaggle

Kaggle

📊 Data Analytics Projects

🏅 ML & Dataset Practice

View Profile

Featured Projects

Sales Performance Analytics Dashboard
Business Intelligence

Sales Performance Dashboard

Built an interactive Power BI dashboard to analyze regional sales performance, revenue trends, and KPIs. The dashboard helps track sales growth and improves business decision-making through visual insights.

Power BI DAX Data Modeling SQL
GitHub Project Files
Android Playstore Data Analysis
Data Analytics

Playstore Data Analysis

Performed exploratory data analysis on the Google Playstore dataset to identify app category trends, ratings distribution, installs, and pricing patterns using Python.

Python Pandas EDA Data Visualization
GitHub Notebook
Data Center Database Infrastructure
Database & SQL

DBMS Notes & SQL Projects

Repository containing structured DBMS concepts, SQL practice queries, joins, subqueries, and business case projects used for data analysis and reporting.

SQL DBMS Queries Joins Reporting Data Analysis
GitHub
House Price Prediction Machine Learning
Machine Learning

House Price Prediction

Built a machine learning model to predict house prices using historical housing data. Applied data preprocessing, feature engineering, and regression techniques for accurate predictions.

Python Machine Learning Scikit-learn Pandas
GitHub
Excel Data Analysis
Excel Analytics

Excel Learning Hub

Repository containing structured Excel learning notes including formulas, functions, pivot tables, charts, and dashboard concepts used for data analysis and reporting.

Excel Formulas Pivot Tables Dashboards
GitHub
Jira Project Management Notes
Project Management

Jira Learning Lab

Repository containing structured learning notes on Jira including backlog management, sprint planning, issue tracking, workflows, and agile project management concepts.

Jira Agile Scrum Project Management
GitHub

Education

BSc – Mathematics with Computer Science

University of Allahabad

2020 – 2023 | Score: 69.2%

Mathematics C Programming DBMS Data Structures

MCA – Master of Computer Applications

University of Allahabad

2023 – 2025 | CGPA: 8.9

Data Analytics Machine Learning SQL Python Business Intelligence

Certifications

PW Skills

Full Stack Development

PW Skills

Feb 2025
Web Development
Udemy

Python Programming

Udemy

Aug 2025
Python Programming
SQL

SQL For Beginners

Scaler

Jul 2025
SQL Database
Udemy

Advanced MS Excel VBA

Udemy

2025
Excel Automation
Power BI

Power BI for Beginners

Simplilearn

2025
Power BI ETL Data Analytics
HackerRank

SQL (Basic)

HackerRank

Mar 2026
MySQL Joins Aggregation
Python

Python (Basic)

HackerRank

Apr 2026
Python Functions OOP
SQL

SQL (Intermediate)

HackerRank

Apr 2026
Subqueries Window Functions

Contact Me

Get In Touch

I am open to Data Analyst & BI opportunities. Feel free to contact me for:

mishralorens212303@gmail.com

+91 8858417372

Chat on WhatsApp

Hyderabad, India

Contact me for:

Data analysis and business intelligence projects
Dashboard development using Power BI, DOMO, and Excel
Collaborations on data-driven solutions
Job opportunities in analytics