Andrew Tumwesigye, Data and Business Intelligence Analyst, MBA
Founder, Dimension Metrics
Predictive Analytics| Descriptive Analytics |Hypothesis testing| Business Analysis |Staff KPI Analysis |Process Analysis & Improvement |Trainer
Andrew is a data and business intelligence analyst with extensive experience in Data Analytics and Business Intelligence. With expertise in SQL, R, Tableau, Power BI, Power Query and Power Pivot, he specializes in Transforming, Analyzing, and Visualizing data to deliver actionable insights that drive business strategy and decision-making.
He has completed the certifications below:
πͺGoogle Data Analytics Certificate
πͺGoogle Business Intelligence Certificate
πͺ Excel Power Tools β Macquarie University, Australia
πͺ Managing Big Data with MySQL β Duke University
πͺ Database Management Essentials β University of Colorado System
πͺ Pentaho for ETL and Data Integration - Start-Tech Academy
πͺ Predictive Analytics β Start-Tech Academy
Additionally, Andrew is actively exploring cloud-based data warehousing to enhance his expertise in scalable and distributed data architectures.
Andrew has completed over 60 data analysis and business intelligence projects across diverse industries, including:
πͺ Housing, transportation, health, and microfinance
πͺ Banking, insurance, and digital finance
πͺ Renewable energy, manufacturing, and security
πͺ Crime, domestic violence, and gun violence analysis
πͺ Culinary, hospitality, and entertainment analytics
πͺ Education and workforce development analytics
Beyond analytics, Andrew has designed six database projects with a strong focus on design, indexing, partitioning, and optimization. He has also built three websites using drag-and-drop technology, demonstrating his versatility.
He has executed four end-to-end ETL and data warehousing projects using PDI and PGadmin, where he designed and automated data pipelines to extract, transform, and load data into warehouses for analysis and visualization.
𧲠Database Design & Management β Structuring ERDs, cardinal constraints, relational schemas, indexing, and optimizing queries.
𧲠ETL & Data Warehousing β Building automated pipelines for scalable data processing.
𧲠Descriptive Analytics β Conducting trend, demographic, and location-based analyses among others.
𧲠Predictive Analytics β Leveraging R and SQL for correlation, forecasting, and linear/logistical modeling.
𧲠Statistical Analysis - hypothesis testing using Chi-Square and t-tests to analyze relationships between variables and assess significant differences between groups.Β
𧲠Data Visualization & Reporting β Developing BI dashboards in Tableau, Power BI, and R.
𧲠Business Intelligence Strategy β Designing data models and analytical frameworks for performance optimization.
Andrewβs passion for data-driven decision-making is matched by his commitment to building efficient, scalable, and insightful business intelligence models