
Douglas Woollam
Data Analyst | Data Scientist
Technical Skills
+ SQL
+ Power BI
+ Python
+ Excel
+ R
+ Data Analysis
+ Project Management
+ GMP & GDP
Featured Projects
Power BI - Data Modelling: Insights into the U.S. Manufacturing Sector
Power BI| Data Modelling◾ Manufacturing Trends Uncovered: analysed employment trends in the U.S. manufacturing sector.
◾ Key Insight: The 1980s saw a peak of 291K+ manufacturing firms, highlighting historical industry shifts.
◾ Optimised Data Modeling: Explored time intelligence, composite key relationships, and role-playing dimensions for deeper insights.
Power BI - Data Modelling: Insights into the U.S. Manufacturing Sector
Power BI| Data Modelling◾ Schema Showdown: Compared star and snowflake schemas in Power BI using U.S. Census manufacturing data.
◾ Key Insight: Food manufacturing leads with the highest average employee counts over time.
◾ BI Performance Analyser – Minimal speed difference between schemas for this dataset.
Python - Uncovering How Obesity Affects Metabolic Health
Python| MSc Thesis
◾Clinical dataset | Gene expression dataset◾ Featuring: statistical analysis, PCA, metabolic modeling, k-means clustering, significance & multiple testing and reaction pathway analysis.◾ Generated: statistical summary tables, Box plots, heat maps, scatter plots, bar charts
About Me
