HARSHIT LALORIYA // PORTFOLIO
DATA ANALYTICS • BI • UI/UX DESIGN
Loading Studio Assets & Analytical Modules...
00%
PYTHON • SQL • POWER BI • TABLEAU • FIGMA • EXCEL AGRA, IN
OPEN TO ROLES — DATA ANALYST • BI DEVELOPER • UI/UX DESIGNER

A problem-oriented professional focused on structuring information, understanding business needs, & working with data to support better decisions.

Most businesses have plenty of data, but it stays trapped in messy spreadsheets or confusing screens. I use Python, SQL, and Excel to clean and organize raw data, and Power BI, Tableau, and Figma to turn it into visual dashboards and interfaces that anyone on the team can understand in seconds.

0+ Yrs
Commercial Design & Data Experience
0+
Analytics, BI & UI/UX Projects Shipped
0+
Positive Client & Student Reviews
ARCHITECT // WORKBENCH
Data & Product Portfolio MCA • CU
Harshit Laloriya Studio Portrait
✦ PYTHON (PANDAS • NUMPY • SEABORN) ✦ SQL (POSTGRESQL & MYSQL) ✦ POWER BI & DAX ✦ TABLEAU DASHBOARDS ✦ FIGMA UI/UX DESIGN ✦ EXCEL FINANCIAL & SALES MODELING ✦ AI AUTOMATIONS & WORKFLOWS ✦ HTML • CSS • JAVASCRIPT • CMS ✦ PYTHON (PANDAS • NUMPY • SEABORN) ✦ SQL (POSTGRESQL & MYSQL) ✦ POWER BI & DAX ✦ TABLEAU DASHBOARDS ✦ FIGMA UI/UX DESIGN ✦ EXCEL FINANCIAL & SALES MODELING ✦ AI AUTOMATIONS & WORKFLOWS ✦ HTML • CSS • JAVASCRIPT • CMS
01 // CAPABILITIES & TECHNICAL STACK

Technical Skills & Tools

Core tools are grouped around the work shown below: data preparation and analysis, SQL problem-solving, BI reporting, Python workflows, and responsive web/CMS experiences.

Python SQL Power BI Tableau Excel Figma UI/UX AI Automations Git & Docker
01 // DATA & ANALYSIS Core Stack

Data Analysis & SQL

Before any business decision is made, the numbers have to be trustworthy. I take raw, scattered company tables—missing values, duplicate rows, and broken formats—and structure them using Python, SQL, and Excel.

  • → Data Hygiene & Pattern Discovery (EDA)
  • → SQL Window Functions, CTEs & Joins
  • → Automated Excel & Sales Ledgers
Python Pandas / NumPy PostgreSQL MySQL Excel
02 // VISUALIZATION & BI Decision Layer

Visualization & Insights

When your data crosses lakhs of rows, plain spreadsheets hide the real story. I transform heavy Excel and SQL tables into clean Power BI and Tableau visual systems so teams can spot revenue leaks, trends, and growth at a glance.

  • → Interactive Power BI & Tableau Dashboards
  • → Custom DAX Measures & KPI Architecture
  • → Executive PDF & Visual Storyboards
Power BI Tableau DAX Matplotlib / Seaborn
03 // UI/UX & AUTOMATION 4+ Yrs Figma

Product UI & Smart Workflows

Great analysis fails if the interface is confusing. With 4+ years in Figma UI/UX design, CMS architecture, and Google Business Profile optimization, I build interfaces and AI workflows that convert users and save team hours.

  • → Figma UI/UX Systems & Web Design
  • → AI Automations & CMS Architecture
  • → Git, GitHub & Docker Workflows
Figma AI Automations GBP 2026 Git & Docker
02 // FLAGSHIP CASE-STUDY & BI ARCHITECTURE

Featured Case-Study & Analytical Work

An executive deep-dive into how raw, unindexed global music data was structured in Excel and modeled into an interactive Power BI decision system.

Dataset: 8,778 Tracks Stack: Excel + Power BI
✦ Exploratory Data Analysis & BI
8,778 Tracks Indexed

Spotify — Release & Popularity Trends

Analysis of Spotify’s global music dataset highlighting multi-decade release velocity, artist activity, popularity distribution, explicit content ratio, and genre metadata coverage. Data was structured in Excel and modeled in Power BI to turn noisy catalog exports into an executive decision view.

Role & Type : Exploratory Data Analysis & BI Visualization
Tech Stack : Excel, Power BI, DAX, Data Modeling
HR Takeaway : Bridges raw data hygiene and executive storytelling
Key Analytical Findings: Standardized 8,778 track records across 2,549 artists, exposing a 51% genre metadata gap in legacy catalogs and establishing a 52/100 normalized popularity benchmark.
POWER BI TELEMETRY CANVAS
Global Catalog View — All Release Eras
TOTAL TRACKS 01
8,778
100% Cleaned in Excel
ACTIVE ARTISTS 02
2,549
Unique Artist Profiles
AVG. POPULARITY 03
52 /100
Normalized Benchmark
RELEASE VELOCITY & POPULARITY CURVE Power BI DAX
LEGACY 2000s 2010s 2020s STREAMING ERA
25%
Explicit Content
Share of tracks marked explicit
49%
Genre Coverage
Tracks with verified genre tags
Why Teams Struggle Here: Raw catalog exports leave 51% of genre metadata blank and mix explicit flags across decades—requiring structured Excel hygiene before DAX modeling.
All repositories
01Data analytics/PostgreSQL
Relational data analysis

Music Store Analysis

A SQL analysis project that turns a relational digital-music-store database into answers about customer value, sales geography, artist demand, and genre preferences.

Challenge

Translate business questions into precise, repeatable queries across connected store tables.

Approach

Progress from sorting and aggregation to multi-table joins, CTEs, and country-level rankings with window functions.

Questions

Revenue by city, highest-value customers, top rock artists, and the most purchased genre by country.

PostgreSQLJOINsCTEsAggregationsROW_NUMBER()
View SQL Repository
03 // SELECTED PRODUCT & CLIENT WORK

Selected Product & Client Work

Selected product and client work spanning intercity mobility and industrial B2B catalog workflows. For additional projects, use the enquiry form to discuss the work most relevant to your needs.

More work · Project walkthroughs

Want to explore more of my work?

I’m preparing detailed write-ups for additional projects. Tell me what you’re looking for, and I’ll help you find the most relevant work to discuss.

APPLICATION 01 // CANADIAN MOBILITY VENTURE • Web + iOS/Android Ecosystem

Structuring Intercity Commutes into a Unified Web & Mobile Booking Flow

Built for a Canadian city-to-city mobility startup ("Made By A Canadian For Canadians"), RideShare bridges empty-seat highway drivers with verified intercity passengers. Instead of cluttered transit forms, the system structures route discovery (Toronto → Peterborough → Ottawa), per-seat pricing, and trip verification into a high-trust web landing experience and a 3-screen mobile application.

PRIMARY BUSINESS OUTCOME End-to-End Rider & Driver Conversion System
KEY ARCHITECTURAL DELIVERABLES // 01—03
01.

3-Screen Mobile Booking Architecture: Dedicated native flows for Ride Request approval, route Post Request scheduling, and live Your Trips GPS tracking.

02.

Dual-Sided Value Proposition: Balanced conversion paths addressing Driver fuel-cost recovery alongside Rider identity verification and 8-hour refund rules.

03.

Interactive Web Storytelling: Custom vector highway pathing, pickup/dropoff schedule selectors, and responsive FAQ governance.

SYSTEM STACK & MODULES
Mobile App UI/UX Web Booking Flow Route Telemetry Design System
VERIFIED SCOPE
iOS/Android + Full Web Platform
● Shipped International Client Deliverable
RideShare iOS & Android 3-Screen UI Mockup
Showing 01 / 03 — RideShare (Safe RS)
PROJECTS & CODE // SQL, PYTHON & BI

More ways I solve data problems.

Explore work across SQL analysis, Python data workflows, ETL concepts and BI reporting. Browse repositories opens my current GitHub repository list while these case-study write-ups are being prepared.

REPO 01 SQL ANALYTICS KPI ANALYSIS

SQL Business Insights & KPI Analysis

A business-focused SQL case study designed to analyze revenue, customer value and category performance through multi-table joins, CTEs and window functions.

PostgreSQLCTEs & JOINsWindow FunctionsAggregationsKPI AnalysisData Validation
Browse repositories
REPO 02 PYTHON EDA & ML DATA QUALITY WORKFLOW

Python Automated Data Hygiene & Cosine-Similarity Recommendation Engine

Python workflows using Pandas, NumPy and Scikit-learn for data-quality checks, cleaning examples and vectorized cosine-similarity rankings. Row counts and validation results should be added when measured.

PythonPandasNumPyScikit-learnCosine SimilarityAutomated EDA
Browse repositories
REPO 03 DATA ENGINEERING ETL PIPELINE DESIGN

API-to-Database ETL Pipeline

A reproducible pipeline concept to extract API or CSV data, validate and normalize records, then load them into PostgreSQL with logging, retry handling and repeatable runs.

PythonREST APICSV / JSONPostgreSQLData ValidationLogging & Retries
Browse repositories
REPO 04 BI REPORTING DAX & STAR SCHEMA

Power BI Sales & Performance Dashboard

A reporting project focused on a star-schema model, documented DAX measures, sales trends, average order value and category performance, with practical slicers and drill-through.

Power BIDAXPower QueryStar SchemaKPI ReportingDrill-through
Browse repositories
04 // PERSONAL NARRATIVE & BACKGROUND

About Me and My Ongoing Journey...

I work across data analytics, UI/UX design, and practical problem-solving, with four years of experience handling real client requirements, digital product workflows, and business data reporting. My focus is simple: understand the core business problem, organize messy information, and turn raw data into clear, usable outputs.

Over the last four years of building interfaces in Figma and working with Python, SQL, Excel, Power BI, and Tableau, I have developed a habit of explaining complex trends in plain, human language that teams and clients can act on immediately.

I'm most comfortable stepping into projects where requirements are unclear at the start and building clarity step by step.

Portrait of Harshit Laloriya
Harshit Laloriya
Data Analyst & Experience Designer
Agra, IN

MY EXPERIENCE

4 YEARS TENURE • FULL-TIME & CLIENT WORKFLOWS 2022 – 2026

Experience Designer · Wovo Marketing

Led digital product design, requirement structuring, and performance reporting across 25+ commercial client projects over four years.

  • Designed responsive Figma UI/UX systems, bento layouts, and CMS websites.
  • Built Power BI, Excel & GBP analytics reports to track client lead growth.
  • Translated unclear client briefs into developer-ready specs with zero friction.
Figma UI/UX Power BI & Excel CMS & Web Ops Client Strategy

MY EDUCATION

POST-GRADUATE DEGREE 2023 – 2025

Master of Computer Applications (MCA)

Chandigarh University

Relational DBMS & SQL Python & ML Data Analytics
UNDERGRADUATE DEGREE 2019 – 2022

Bachelor of Science (Computer Science)

N.D. College of Science & Technology, Agra

Computer Science Core Probability & Statistics Data Structures
05 // UPCOMING FLAGSHIP COURSES • RELEASING SOON

Hands-On Video Courses — Built for Real-World Execution

Zero textbook theory. 3 practical, project-driven video courses currently in studio production—teaching how to analyze business data, design in Figma, and automate workflows.

3 Flagship Curriculums Releasing Soon
SWIPE LEFT TO EXPLORE
01 / 03
07 // CLIENT & LEARNER FEEDBACK

The Work, In Their Words.

Perspectives from clients and learners on the digital experiences, workflows, and learning journeys we've shaped together.

AK

Arisha Khan

UI/UX Developer, HCL · Student

“Harshit bhaiya has a way of explaining things that makes UI/UX feel much less confusing. Whenever I got stuck, he would break the problem down and help me understand the reason behind a design decision, not just the answer. That guidance has helped me become more confident in my work.”

PP

Peter Pedro

International Client · Gutter Repair & Home Services

“The website came together really well. Harshit understood the kind of service business we run and kept the design clear, professional, and easy for customers to navigate. I also appreciated that the CMS side was considered, so managing the content would be straightforward after handover.”

UA

Utkarsh Agrawal

Founder, Chandra Manufacturing

“Harshit worked on our IndiaMART listings and helped present our products more clearly. He paid attention to the details that can easily get missed when uploading and organising listings. The work was practical and focused on making it easier for potential buyers to understand what we offer.”

LH

Larib Hashmi

Student · Freelancing Mentorship

“Harshit bhaiya guided me on things I honestly didn’t know where to start with—finding my first client, approaching people, and how to talk to a client professionally. He explained it in a simple way and helped me understand that freelancing is not just about having a skill; you also need to know how to communicate and build trust.”

MT

Meraki Travels

Local Travel Business · Website & Online Listings

“We got our website made for Meraki Travels, and Harshit also helped us get our business listed on relevant online platforms. He was mindful of how customers would find our services online, not just how the website looked. Overall, the work helped us build a more organised online presence.”

SE

Sun Enterprises

Website design · Draft for client approval

“The new website brings our residential, commercial and industrial solar services together in a way that is easier to understand. The assessment form gives visitors a clear next step, and information about subsidies and net metering is easier to find. Overall, the site feels more organised and professional.”

ER

Ensured Roofing

Website design · Draft for client approval

“We wanted homeowners to find the right roofing service and request an inspection without having to search around. The service sections, estimate form and insurance-claim information make that journey easier to follow. The layout feels professional without getting in the way of the information people need.”

RT

Roman Training

Website design · Draft for client approval

“The site presents our training options and coaching approach in a much clearer order. Visitors can learn about the process and find the consultation link without hunting for it. The overall structure feels more focused and consistent with the message we want to share.”

DR

Driven Roofing

Website design · Draft for client approval

“The new layout brings our residential and commercial roofing services, storm-repair information, past projects and quote form together in one place. It is easier to browse, and visitors have clearer ways to learn about the work and get in touch.”

UA

Utkarsh Agrawal

Founder, Chandra Manufacturing

“Harshit worked on our IndiaMART listings and helped present our products more clearly. He paid attention to the details that can easily get missed when uploading and organising listings. The work was practical and focused on making it easier for potential buyers to understand what we offer.”

LH

Larib Hashmi

Student · Freelancing Mentorship

“Harshit bhaiya guided me on things I honestly didn’t know where to start with—finding my first client, approaching people, and how to talk to a client professionally. He explained it in a simple way and helped me understand that freelancing is not just about having a skill; you also need to know how to communicate and build trust.”

MT

Meraki Travels

Local Travel Business · Website & Online Listings

“We got our website made for Meraki Travels, and Harshit also helped us get our business listed on relevant online platforms. He was mindful of how customers would find our services online, not just how the website looked. Overall, the work helped us build a more organised online presence.”

AK

Arisha Khan

UI/UX Developer, HCL · Student

“Harshit bhaiya has a way of explaining things that makes UI/UX feel much less confusing. Whenever I got stuck, he would break the problem down and help me understand the reason behind a design decision, not just the answer. That guidance has helped me become more confident in my work.”

PP

Peter Pedro

International Client · Gutter Repair & Home Services

“The website came together really well. Harshit understood the kind of service business we run and kept the design clear, professional, and easy for customers to navigate. I also appreciated that the CMS side was considered, so managing the content would be straightforward after handover.”

DR

Driven Roofing

Website design · Draft for client approval

“The new layout brings our residential and commercial roofing services, storm-repair information, past projects and quote form together in one place. It is easier to browse, and visitors have clearer ways to learn about the work and get in touch.”

RT

Roman Training

Website design · Draft for client approval

“The site presents our training options and coaching approach in a much clearer order. Visitors can learn about the process and find the consultation link without hunting for it. The overall structure feels more focused and consistent with the message we want to share.”

ER

Ensured Roofing

Website design · Draft for client approval

“We wanted homeowners to find the right roofing service and request an inspection without having to search around. The service sections, estimate form and insurance-claim information make that journey easier to follow. The layout feels professional without getting in the way of the information people need.”

SE

Sun Enterprises

Website design · Draft for client approval

“The new website brings our residential, commercial and industrial solar services together in a way that is easier to understand. The assessment form gives visitors a clear next step, and information about subsidies and net metering is easier to find. Overall, the site feels more organised and professional.”