About Me

Joshua Lamothe
Joshua Lamothe
Business Intelligence Analyst
PL-300 Certified · Business Intelligence Analyst

Turning complex data
into strategic insight.

A decade of analytical experience, from aerospace engineering to business intelligence, turning complex data into faster, better-informed decisions with SQL, Power BI, and R.

Power BISQLDAXRTableauLooker Studio
10+
Years in data
4
Case studies
PL-300
Certified analyst
Sales Performance
Q3 overview · live dashboard
Revenue
$482K
▲ 12.4%
Orders
3,204
▲ 6.1%
Margin
34.8%
▲ 1.9%
Monthly RevenueJan–Sep
Channel Mix
Online 62% Retail 23% Partner 15%
Top Region
Northeast
$186K · 38.6% of total
Toolkit

BI Tools & Skills

The core stack behind every dashboard, model, and analysis I ship.

BI
Power BI
PL-300 Certified
SQL
SQL
T-SQL, Azure
Dx
DAX
Data Modeling
R
R
Statistics
Tb
Tableau
Visualization
LS
Looker Studio
Reporting
Portfolio

Featured Projects

A selection of case studies covering sales analytics, operations, and consumer behavior.

Revenue Trend
SQLPower BI

Sales Management Dashboard

Dynamic, daily-updating Power BI dashboards built on SQL data integrated from multiple sources, giving sales managers real-time insight into customer, product, and budget performance.

View case study →
Peak-Hour Analysis
SQLPower BI

Pizza Sales Analytics

SQL-driven data cleansing and transformation feeding a Power BI dashboard that surfaces peak ordering hours, top-selling items, and revenue trends for a pizza company’s full-year performance.

View case study →
Ridership Patterns
RData Viz

Bike-Sharing Demand Analysis

Statistical analysis in R comparing member and casual riders across ride duration, timing, and frequency, informing targeted marketing and membership strategy recommendations.

View case study →
Order Funnel
Looker Studio

Sales Orders Dashboard

An interactive Looker Studio dashboard visualizing customer, product, region, and time-period metrics with dynamic filtering, surfacing sales trends, profitability, and performance for stakeholders.

View case study →
PL-300

Microsoft Certified: Power BI Data Analyst Associate

PL-300 certified, validated expertise in preparing, modeling, visualizing, and analyzing data with Power BI.

Interactive Dashboard Development

Data Modeling & Transformation

KPI Design & Metric Alignment

Stakeholder Communication

Business Requirements Gathering

ETL Process Design

Advanced DAX Calculations

Ad Hoc & Executive Reporting

Joshua Lamothe

About Joshua

PL-300 certified analytics professional with over a decade of experience turning complex data into strategic insights that drive measurable business impact. Skilled in Power BI, SQL, and DAX, I build scalable, intuitive solutions that improve efficiency, optimize decision-making, and align analytics with organizational goals. I’m passionate about guiding analytics efforts that not only solve today’s problems but also lay the groundwork for stronger teams, smarter strategies, and sustainable growth.

Let’s turn your data into decisions.

Open to new opportunities and collaborations in business intelligence and analytics.