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

🪓 Data Visualization with Power-BI - Start-Tech Academy

Additionally, Andrew is actively exploring cloud-based data warehousing to enhance his expertise in scalable and distributed data architectures.

Project Experience

Andrew has completed over 70 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

Database & ETL Projects

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 over 20 end-to-end ETL and data warehousing projects using PDI, Apache Hop, PGadmin & PowerBI, where he designed and automated data pipelines to extract, transform, and load data into warehouses for analysis and visualization.

Core Expertise

🧲 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

Mark is a seasoned sales and marketing specialist with deep expertise in driving business growth and strategic expansion. His career is distinguished by a proven ability to build and scale startups, where he has consistently focused on strategic planning and business development.

His diverse experience spans multiple sectors, including commodity trading, where he successfully led operations and implemented growth strategies for Umilele Coffee by fostering key business relationships. Mark also possesses substantial expertise in commercial real estate, encompassing mortgage lending, real estate appraisal, and commercial lending.

He is highly skilled in building and managing robust client pipelines, expertly transforming initial engagements into successful project deliveries that ensure value for all stakeholders. Mark's academic credentials include a Master of International Business Administration (MBA) from Ecole Superieure Libre des Sciences Commerciales Appliquees (ESLSCA University, Paris) and a Bachelor's degree in Business Administration from Uganda Martyrs University, Nkozi.