Projects using Google Sheets in NairobiProjects using Google Sheets in NairobiManual Financial Data Transfer: PDF to Google Sheets (375 Pages)
The Challenge:
A client needed a full year of 2025 financial records spanning 375 pages of PDF documents, accurately transferred into a structured Google Sheet for easier analysis, reporting, and record-keeping. Given the sensitivity and precision required for financial data, the client specifically requested a fully manual, copy-and-paste transfer rather than an automated PDF-to-sheet conversion, to avoid formatting errors, misaligned figures, or data corruption common with auto-extraction tools.
My Approach:
I worked directly through each of the 375 pages, manually reviewing and entering every figure into a clean, organized Google Sheet structure. To maintain accuracy and consistency throughout the project, I:
-Cross-checked each entry against the source PDF before finalizing it.
- Organized the sheet with clear categories and consistent formatting for easy navigation and future reporting.
- Maintained a steady, disciplined workflow to meet a tight three-day turnaround without sacrificing accuracy.
- Flagged any unclear or inconsistent entries in the source material for client review.
Tools Used:
- Google Sheets (data entry, formatting, organization).
- Adobe Acrobat / PDF viewer (source document review).
- Manual data verification techniques (double-entry cross-checking).
The Impact:
The client received a fully accurate, well-organized digital record of their entire 2025 financial data, free from the errors that automated extraction often introduces. This gave them a reliable foundation for financial reporting, auditing, and decision-making, with data they could trust down to the last figure. Completing the transfer within three days also meant the client could proceed with their financial review without delay. 📊 Toyota Global Performance Dashboard — Quick Analysis by Intersect Analytics
We recently came across Toyota’s global automotive data and carried out a quick Power BI-driven business intelligence analysis to uncover the trends driving performance, revenue, and market dominance.
Key Findings:
🚗 RAV4 emerged as a major revenue driver, reinforcing the growing dominance of SUVs in the global automotive market.
🌍 Asia-Pacific remains Toyota’s strongest-performing region, contributing the largest share of global vehicle sales and market influence.
⚡ Hybrid & electrified vehicles continue gaining momentum, signaling a strong transition toward sustainable and future-focused mobility.
📈 Toyota maintained impressive global sales performance, with a small number of flagship models driving a significant share of total revenue.
💡 What does this tell us?
The businesses leading today are not necessarily those with the most data — but those that understand how to use it strategically.
At Intersect Analytics, we specialize in transforming raw business data into strategic insights, executive dashboards, automation systems, and business intelligence solutions that improve decision-making and unlock growth opportunities.
Our services include:
✅ Power BI Dashboard Development
✅ Business Intelligence & Data Analytics
✅ Workflow Automation Across Multiple Platforms
✅ Financial, Sales & Operational Analytics
✅ Executive Reporting & KPI Tracking
✅ SQL, Python, Excel & Cloud Analytics Solutions
✅ AI-Powered Reporting & Predictive Insights
Whether you operate in finance, logistics, healthcare, retail, manufacturing, or e-commerce, we help organizations transform complexity into clarity through data visualization, automation, and advanced analytics.
Because data alone does not create growth.
Insights do.
DECISIONS BACKED BY DATA.
GROWTH DRIVEN BY INSIGHT.
📱 WhatsApp: +254 723 632 207
#DataAnalytics #BusinessIntelligence #PowerBI #DashboardDesign #Automation #FinancialAnalytics #SQL #DataVisualization #AI #DigitalTransformation #Toyota #BusinessGrowth Global Cosmetics Manufacturer Sourcing Research - Conducted global supplier research for a beauty brand seeking suitable cosmetics manufacturers in the USA, China, and India. I evaluated 8 manufacturers based on private-label capabilities, MOQs, lead times, costs, certifications, quality standards, and reputation. I organized the findings into a structured comparison report and ranked the top 5 suppliers based on the client’s requirements, providing clear, actionable recommendations to support supplier selection and product development. 
