Freelancers using Microsoft Excel in Nairobi CountyFreelancers using Microsoft Excel in Nairobi County
ProjectsPeople
Johnson Wairimu's avatar
Johnson Wairimu
Nairobi, Kenya
Delivering Strategic Growth Through Data, Finance & Tech.
10
Followers
Delivering Strategic Growth Through Data, Finance & Tech.
Cover image for Executive Review: Global Aircraft Manufacturing
Executive Review: Global Aircraft Manufacturing Intelligence Dashboard The Global Aircraft Manufacturing Intelligence Dashboard demonstrates how modern Business Intelligence can transform complex aviation datasets into strategic insights that support executive decision-making. By integrating production, delivery, market share, and regional performance data from leading aircraft manufacturers into a unified Power BI environment, the solution provides stakeholders with a comprehensive view of industry performance and emerging market trends. The analysis indicates that Airbus and Boeing continue to dominate the global commercial aviation market, while manufacturers such as Embraer, Bombardier, Dassault Aviation, Gulfstream, and COMAC continue to strengthen their presence across regional, business, and emerging aviation segments. Through interactive visualizations, users can evaluate production performance, delivery trends, market distribution, and competitive positioning to better understand the evolving dynamics of the aerospace industry. Beyond visualization, the dashboard serves as a strategic decision-support platform by enabling organizations to monitor key performance indicators, identify growth opportunities, anticipate market shifts, and improve forecasting accuracy. The ability to consolidate multiple data sources into a single, reliable reporting environment significantly reduces manual reporting effort while improving data consistency and operational visibility. At Intersect Analytics, we specialize in designing enterprise-grade Business Intelligence solutions that convert fragmented business data into actionable intelligence. Our expertise spans Power BI Dashboard Development, Financial Analytics, Executive Reporting, SQL Data Modeling, Python Analytics, Excel Automation, Office Scripts, Power Automate, Predictive Analytics, and Data Engineering. Every solution we develop is tailored to enhance reporting efficiency, strengthen decision-making, and support long-term business growth. Rather than simply building dashboards, we develop intelligent reporting ecosystems that enable organizations to automate reporting, improve operational performance, and make strategic decisions with confidence. Intersect Analytics Decisions Backed by Data. Growth Driven by Insight.
1
37
Cover image for 🚗 Executive Automotive Industry Intelligence
🚗 Executive Automotive Industry Intelligence — Powered by Power BI How do the world's leading automotive manufacturers compare when it comes to revenue, profitability, production, and market performance? At Intersect Analytics, we developed this executive Power BI dashboard to transform complex automotive industry data into a single source of truth for strategic decision-making. 📊 Executive Insights Our analysis revealed several key industry trends: 🏆 Toyota Motor Corporation continues to lead the global automotive market, generating the highest revenue while maintaining exceptional profitability and vehicle production volumes. 📈 Volkswagen Group remains one of the strongest global competitors, demonstrating consistent revenue growth and a diversified international market presence. ⚡ BYD has emerged as one of the fastest-growing manufacturers, driven by rapid expansion in electric vehicle production and increasing global demand. 💰 While several manufacturers generate significant revenue, profit margins vary considerably, highlighting differences in operational efficiency, manufacturing costs, and pricing strategies. 🌍 Asian manufacturers continue to dominate the global automotive industry, contributing the largest share of revenue and vehicle production compared to Europe and North America. 🚘 The transition toward electric and hybrid vehicles is reshaping the competitive landscape, with manufacturers investing heavily in next-generation mobility technologies. 📉 Comparing Revenue against Cost of Sales reveals that companies with stronger cost control consistently deliver higher profitability despite operating in the same competitive environment. 📊 Revenue per vehicle varies significantly across manufacturers, reflecting differences in brand positioning, product mix, and premium versus mass-market strategies. What This Dashboard Delivers ✔ Executive KPI Scorecards ✔ Revenue & Profitability Benchmarking ✔ Global Vehicle Sales Analysis ✔ Regional Performance Comparison ✔ Revenue vs Cost Analysis ✔ Net Profit Margin Analysis ✔ EV, Hybrid & ICE Market Breakdown ✔ Interactive Geographic Performance Mapping ✔ Executive-ready Multi-page Reporting Our Services At Intersect Analytics, we help organizations transform raw business data into executive intelligence through: ✅ Power BI Dashboard Development ✅ Financial Analytics & Executive Reporting ✅ Business Intelligence Solutions ✅ Excel & Google Sheets Automation ✅ SQL Data Modeling & ETL ✅ Power Query & DAX Optimization ✅ KPI Scorecards & Performance Monitoring ✅ Predictive Analytics & Decision Support Every dashboard we build is designed to help leaders move beyond reporting—to uncover trends, optimize performance, and make confident, data-driven decisions. 📊 Decisions Backed by Data. Growth Driven by Insight. If your organization is ready to unlock the full potential of its data, let's build a solution tailored to your business.
0
20
Cover image for 📊 GLOBAL AI STOCK MARKET
📊 GLOBAL AI STOCK MARKET PERFORMANCE DASHBOARD Artificial Intelligence is no longer influencing individual companies alone — it is reshaping entire financial markets. At Intersect Analytics, we developed this interactive Global AI Stock Market Performance Dashboard to analyze how AI investment is driving market performance across the United States, South Korea, Taiwan, Europe, China, and Japan. Our analysis highlights several key findings: ✅ South Korea's KOSPI significantly outperformed many major global markets, driven largely by AI-related semiconductor companies. ✅ Massive AI capital expenditure by major US technology companies continues to fuel global semiconductor demand. ✅ Market concentration risk is increasing, with a small number of companies accounting for a significant share of market performance. ✅ Retail investor participation has reached historic levels in some markets, increasing both opportunity and risk. ✅ AI infrastructure spending is becoming one of the strongest drivers of global equity markets. How We Built This Solution This dashboard was developed using a complete Business Intelligence workflow: • Data collection and market research • Data transformation and modeling • Power Query data preparation • DAX calculations and performance measures • KPI development and financial analysis • Geographic and market visualization • Risk assessment and investment analysis • Executive dashboard design in Power BI Services Delivered by Intersect Analytics 📈 Power BI Dashboard Development 📊 Financial & Market Analytics 🤖 Business Intelligence Solutions ⚙️ Data Modeling & Automation 📉 Executive Reporting & KPI Design 🗄️ Power Query & DAX Optimization 🌍 Economic & Market Intelligence Dashboards ☁️ Data Integration & Analytics Infrastructure At Intersect Analytics, we help businesses, investors, and organizations transform complex data into clear insights that support better decisions. DECISIONS BACKED BY DATA. GROWTH DRIVEN BY INSIGHT. #PowerBI #BusinessIntelligence #DataAnalytics #FinancialAnalytics #ArtificialIntelligence #StockMarket #DashboardDesign #DataVisualization #InvestmentAnalytics #BusinessGrowth
0
24
Cover image for 🚀 NEW PROJECT INTAKE OPEN
🚀 NEW PROJECT INTAKE OPEN | 20% OFF UNTIL JUNE 15 Every business generates data. The difference between industry leaders and everyone else is what they do with it. At Intersect Analytics, we help organizations save time, eliminate manual reporting, automate repetitive processes, and turn data into actionable business intelligence that drives growth. Our services include: 📊 Power BI Dashboards & Business Intelligence 📈 Data Analytics & Visualization ⚙️ Excel & Google Sheets Automation 🐍 Python Data Extraction & Preparation 🗄️ SQL & Database Solutions 🔄 Business Process Automation Whether your business is just beginning its analytics journey or already has reporting systems in place, we help unlock greater value through smarter automation, better insights, and more efficient decision-making. ✅ Reduce reporting time ✅ Improve operational efficiency ✅ Monitor KPIs in real time ✅ Make faster, data-driven decisions ✅ Focus more time on growth and strategy 🎉 Enjoy 20% OFF all Data Analytics, Business Intelligence, and Automation projects until June 15. 📱 WhatsApp: +254 723 632 207 INTERSECT ANALYTICS Decisions Backed by Data. Growth Driven by Insight.
0
33
Microsoft Excel(21)
Nipul Patel's avatar
Nipul Patel
Nairobi, Kenya
Customer Success Expert & Virtual Admin Guru
Customer Success Expert & Virtual Admin Guru
Cover image for Data Entry and Management for Blue Dragon Plumbing, LLC
Data Entry and Management for Blue Dragon Plumbing, LLC
0
1
Cover image for Elevating Efficiency: Virtual Assistant Services for Viva W/sale
Elevating Efficiency: Virtual Assistant Services for Viva W/sale
0
2
Cover image for Detail-Oriented Bookkeeper
Detail-Oriented Bookkeeper
0
1
Placeholder project card media
View more →
Microsoft Excel(3)
Salome Wachira's avatar
Salome Wachira
Nairobi, Kenya
Project Scheduling |Primavera P6 | MS Project, Power BI
New to Contra
Project Scheduling |Primavera P6 | MS Project, Power BI
Cover image for I Turned 4,000 projects
I Turned 4,000 projects ($4.57bn portfolio) into a 3-part risk dashboard Key findings: 1. $2.26bn (49%) of budget is at risk, 762 projects flagged Critical 2. Risk doesn't fade as projects mature, it spikes again at Execution 3.Surprisingly, Senior/Mixed teams showed the highest critical-risk concentration, not Juniors meaning process maturity mattered more than experience 4.Budget utilization is highest at Initiation (~97%) and drops by Execution (~94%), the riskiest financial calls happen earliest, with the least information. Built end-to-end in Power BI. I help teams turn messy project, ops, or sales data into dashboards that actually drive decisions. 📩 Open to freelance and full-time work in data analytics & project management. #DataAnalytics #PowerBI #ProjectManagement #RiskManagement #OpenToWork
1
2
72
Cover image for Boost Sales with Professional Cafe Startup Analysis Report
This was a sales analysis of a small cafe startup. I helped the business owner gain insights into the performance of the business and also provided report and recommendations on how to improve their sales and general performance
1
46
Cover image for Transform Raw Data into Clear Business Insights with Dashboards
Turning Raw Data into Actionable Business Insights A peek into some of my recent data visualization work! I designed these interactive dashboards to help businesses move away from messy spreadsheets and look at their data with absolute clarity.
1
48
Cover image for I just completed a full
I just completed a full Oil & Gas project schedule in Primavera P6 Professional, built from scratch as part of my ongoing learning in project controls. Here's what the schedule includes: - Full WBS structure across 6 phases; Initiation, Engineering, Procurement, Construction, Testing & Commissioning, and Handover - 25+ activities with realistic durations and Finish-to-Start predecessor logic - 6 resources assigned across all phases; Project Manager, Lead Engineer, Procurement Officer, Site Supervisor, HSE Officer, and Construction Crew - Cost loading of $1.6M across all activities with expense categories - S-Curve generated showing cumulative budget distribution - Baseline locked and constraints applied showing critical path analysis - Project duration: 12 months (Feb 2024 - May 2025) - Total budget: $1,628,000 - Critical path identified with -53d float , showing real schedule pressure
0
22
Microsoft Excel(3)
Lucy Kilonzo's avatar
Lucy Kilonzo
Nairobi, Kenya
I transform disorganized data and messy cloud drives
New to Contra
I transform disorganized data and messy cloud drives
Cover image for Bulk Data Cleansing Title: Multi-Source CRM
Bulk Data Cleansing Title: Multi-Source CRM Contact Database Standardization Project Description: Scrubbing and consolidating messy consumer data lists compiled across multiple event sign-up forms and legacy sheets into a single, clean master file ready for database migration. What I Did: Executed deep deduplication across 15,000 rows of raw customer contact text records. Normalized phone numbers into standard international formats and fixed mismatched date structures. Cleaned up text columns by fixing typos, capitalizing names, and separating merged text fields. The Result: Delivered a 100% error-free, tabular dataset ready for smooth CRM integration without any broken entries.
0
20
Cover image for Cleansed the Projects Dashboard for
Cleansed the Projects Dashboard for Machakos County
1
44
Cover image for Knowledge Management Mapping Title: SharePoint Knowledge
Knowledge Management Mapping Title: SharePoint Knowledge Base Setup & Metadata Tagging Project Description: Migrating an organizational document registry into a modern, searchable SharePoint environment to capture institutional memory and secure data sharing. What I Did: Designed a custom metadata mapping profile layout to organize documents cleanly. Assigned explicit property tags (such as Project, Document Type, Fiscal Year, and Access Level) across the digital assets. Configured permissions and access controls to ensure strict data governance. The Result: Built a fully filterable internal wiki and knowledge repository that protected sensitive data while keeping information instantly discoverable.
0
26
Cover image for Title: Google Drive Restructuring &
Title: Google Drive Restructuring & File Taxonomy Design Project Description: Transforming a chaotic, 4-year-old corporate Google Drive into a streamlined, high-efficiency repository. The client was a growing regional operations team struggling with duplicate files, missing folders, and a complete lack of naming standards. What I Did: Audited over 3,000 corporate documents and removed a massive amount of duplicate file clutter. Designed a standard 5-tier organizational taxonomy tailored to the company’s core business tracks. Established and deployed a strict, mandatory naming convention framework (YYYYMMDD_DocumentName_v1.0). The Result: Reduced employee file retrieval times from minutes down to just three clicks. Project 2: Bulk Data Cleansing Title: Multi-Source CRM Contact Database Standardization Project Description: Scrubbing and consolidating messy consumer data lists compiled across multiple event sign-up forms and legacy sheets into a single, clean master file ready for database migration. What I Did: Executed deep deduplication across 15,000 rows of raw customer contact text records. Normalized phone numbers into standard international formats and fixed mismatched date structures. Cleaned up text columns by fixing typos, capitalizing names, and separating merged text fields. The Result: Delivered a 100% error-free, tabular dataset ready for smooth CRM integration without any broken entries.
0
32
Microsoft Excel(2)
Elizabeth Waweru's avatar
Elizabeth Waweru
Nairobi, Kenya
Decoding data patterns to reveal actionable business stories
Decoding data patterns to reveal actionable business stories
Cover image for Adidas Sales Performance Analysis
Adidas Sales Performance Analysis
1
5
Cover image for Customer Churn Analysis for Databel
Customer Churn Analysis for Databel
1
4
Cover image for Turnover Analysis Dashboard
Turnover Analysis Dashboard
1
7
Placeholder project card media
View more →
Microsoft Excel(1)
Jamin Mwaririe's avatar
Jamin Mwaririe
Nairobi, Kenya
Exceeding Expectations in Youtube Growth & Data Analysis
Exceeding Expectations in Youtube Growth & Data Analysis
Cover image for Key Factors Shaping the 2024 U.S. Presidential Election.
Key Factors Shaping the 2024 U.S. Presidential Election.
0
15
Cover image for BEST TIME TO BUY A CAR IN 2024.
BEST TIME TO BUY A CAR IN 2024.
0
21
Cover image for MARKET RESEARCH
MARKET RESEARCH
0
21
Placeholder project card media
View more →
Microsoft Excel(1)