Alex Carran's
Portfolio

Power BI Developer & Data Analyst

I'm a Power BI developer with a strong foundation in SQL querying and data modeling. I specialize in turning complex, raw datasets into dashboards and reports that hold up in real business use, from writing and optimizing SQL queries to building data models and DAX measures. I've worked with healthcare, sales, and public health data, and I currently support enterprise Power BI development as part of a data migration initiative at work.

SQL Power BI DAX Data Modeling Tableau Python Excel

Power BI Projects

Medical Records with Power BI

Analyzed hospital patient records using Power BI to evaluate admissions, readmissions, patient demographics, healthcare costs, and treatment trends. Built an interactive dashboard to transform patient data into clear KPIs and actionable insights for hospital decision-making.

Pizza Sales Analysis with Power BI

Leveraged Power BI's dashboard capabilities to effectively communicate insights derived from diverse projects, including a focus on pizza sales. Analyzed data to identify the top 5 pizza flavors and pinpoint peak sales days of the week, showcasing a proficiency in extracting actionable information from datasets.

SQL Projects

Cleaning Data in SQL

In this project centered on Nashville's housing data, my primary focus was on data cleaning using SQL. I meticulously processed raw datasets, addressing inconsistencies and handling missing values to enhance usability. By ensuring data quality and organization, I set the groundwork for future in-depth analysis and insights extraction.

Covid-19 Data Exploration

Using SQL Server, I explored global COVID-19 data spanning [X countries / X rows] to calculate infection rates and death rates relative to population. The queries formed the analytical backbone later used to build the COVID-19 Tableau dashboard, connecting raw case data to a visual, explorable format.

Tableau Projects

Tableau Dashboards

A collection of dashboards built to practice turning varied, real-world datasets into visuals stakeholders can explore on their own. Topics include a COVID-19 case tracker, Airbnb pricing trends, London bike-share usage, top-paid athlete earnings, and library circulation data, each designed to surface patterns without requiring the viewer to touch the raw data.

Python Projects

Movie Correlation with Python

Curious what actually predicts a movie's box office success, I used Python (Pandas, NumPy, Seaborn) to analyze [X movies], testing correlations between budget, release timing, director, and runtime against gross earnings. Budget emerged as the strongest predictor, a finding that shaped how I approached feature selection in later analysis work.