Darrell Mortalla Photo

Darrell Mortalla

Data Analyst | Python · SQL · Excel · Power BI · Tableau · Cloud

I specialize in using AI to build end-to-end analytics workflows — from cleaning and modeling data to multi-cloud deployment of dashboards and automated BI pipelines.

1. Data Cleaning & Preparation

Retail Sales dashboard with AWS deployment.

End-to-end data wrangling workflow with validation scripts.

View on GitHub

2. Exploratory Data Analysis (EDA)

Customer Churn tracker deployed on Azure.

Statistical profiling and churn behavior analysis.

View on GitHub

3. Excel Automation Dashboard

COVID-19 trend analysis with GCP integration.

Automated Excel reports and charts powered by Python scripting.

View on GitHub

4. Power BI Retail Insights

Marketing Campaign ROI analytics.

Cross-channel marketing performance with Power BI dashboards.

View on GitHub

5. Tableau Global Sales Overview

E-commerce order automation using Python + Excel.

Visual storytelling with Tableau and automated ETL using Python.

View on GitHub

6. SQL Sales Optimization

Financial KPI tracking via SQL + Power BI.

Optimized queries for pricing and profitability insights.

View on GitHub

7. Predictive Modeling

Customer segmentation & RFM analysis with Tableau.

Machine-learning-based forecasting and customer insights.

View on GitHub

8. Customer Segmentation

Supply Chain efficiency modeling with Power BI.

Advanced segmentation and dashboard-driven optimization.

View on GitHub

9. A/B Testing & Statistical Analysis

Marketing campaign inference modeling.

Statistical testing to identify significant marketing strategies.

View on GitHub

10. Sales Forecasting

Time-series prediction using Python + Power BI.

Forecasting future trends using ARIMA and Prophet models.

View on GitHub

11. BI Data Modeling

Dimensional warehouse schema (SQL + Power BI).

Data modeling and ETL processes for BI systems.

View on GitHub

12. Executive Insights Dashboard

Storytelling dashboard for business leaders.

Executive-level reporting with key insights visualized in Power BI.

View on GitHub

13. Cloud Data Pipeline Capstone

End-to-end analytics pipeline on AWS + Power BI.

Integrated ETL, storage, and BI pipeline demonstrating full-stack analytics workflow.

View on GitHub