TURANK DEBORAH ZICHAT
DATA ANALYST
DATA ANALYST | BUSINESS INTELLIGENCE ANALYST
About Me
In today’s world, data is the foundation of informed decision-making, but raw numbers alone don’t create impact understanding and interpreting them does. As a skilled Data Analyst, I bridge the gap between raw data and meaningful business outcomes. I have a deep understanding of how to interpret, analyze, and visualize data to uncover hidden trends and provide actionable insights that help businesses grow and achieve their goals. My approach is rooted in clear communication, and I aim to empower business leaders by making data approachable, visual, and easy to understand. Whether you need your data cleaned, presented in an interactive dashboard, or analyzed for strategic decision-making, I can help you derive insights and solutions that drive measurable results.
Here’s what I offer:
Data Cleaning:
I transform messy, unstructured data into clean, organized datasets that are ready for analysis. By removing inconsistencies, correcting inaccuracies, and formatting your data properly, I ensure it’s easy to work with and analyze. This process allows you to focus on insights rather than data issues, speeding up decision-making and preventing costly mistakes.
Custom and Interactive Dashboards:
I design visually compelling, interactive dashboards tailored specifically to your business needs. My dashboards are built with your key metrics in mind, offering real-time insights into performance and trends. Whether you need to track KPIs, monitor business processes, or predict future outcomes, my dashboards provide a dynamic view of your data, making it easy for you and your team to act quickly and efficiently.
Data Analysis and Strategy:
I go beyond surface-level insights to provide in-depth, comprehensive analysis that supports strategic planning. Using advanced analytical techniques, I help you identify patterns, forecast future trends, and gain a clear understanding of your data. Based on these insights, I formulate strategies that are aligned with your business objectives, helping you make well-informed decisions that drive long-term success.
Beyond data analysis, I am a passionate advocate for environmental sustainability, specifically focusing on waste reduction, reuse, and recycling. I’ve had the privilege of speaking to audiences across various organizations, sharing insights on the value of waste management and its critical role in public health and environmental conservation. Leveraging my data analysis skills, I’ve conducted research on the impact of plastic waste on human health, particularly when improperly disposed of and contaminating marine environments.
Key Highlights of My Experience:
-
Data-Driven Insights for YouTube Content Creators: I worked closely with an agency for YouTube gamers, where I extracted datasets from top YouTubers and performed competitive analysis. Through in-depth analysis, I identified critical content trends such as the optimal posting times, content types that resonate with audiences, and strategies for driving engagement. These insights directly contributed to measurable improvements in client performance.
-
TikTok Platform Growth: I applied my expertise in data analytics to grow my own TikTok platform from the ground up, reaching nearly 10,000 followers in just 3 months. This success was driven by deep analysis of user engagement patterns and the development of a data-informed content strategy that resonated with my audience.
-
Recognition: In 2025, I was honored to be nominated as one of the top Data Analysts by Martech Africa and Yournotify, a recognition that underscores my dedication to excellence in the data space.
As I continue to grow in my career, I am constantly seeking opportunities that allow me to further expand my skill set, take on exciting challenges, and collaborate with organizations that value innovation, sustainability, and growth. If you’re looking for a data-driven professional who can deliver insights that make a difference, let’s connect!
Work Experience
Job Title: Data Analyst
UPWork (Freelance)
Date: January 2025- Febuary 2025
Location: United Kingdom (Remote)
Job Description:
- Cleaned and processed a dataset containing 87% null values, applying advanced statistical techniques to impute missing numerical data, ensuring data integrity, and enhancing the accuracy of the analysis. Detected and addressed patterns in categorical data to uncover significant relationships, further refining data quality for decision-making.
- Conducted a comprehensive real-time analysis on flight times, identifying key flights contributing to delays and implementing strategic recommendations that resulted in a 65% reduction in passenger delays across multiple routes.
- Analyzed aircraft clustering patterns and areas of high traffic congestion, using data-driven insights to optimize air traffic flow, leading to a 42% reduction in airspace congestion and improved operational efficiency.
- performed a analysis of flight altitude, speed, and path variation by aircraft type, providing actionable insights that improved speed times by 52%, leading to more efficient flight routes and reduced overall travel time.
Job Title: Content Insight Analyst
Company: Flikercrew Agency
Date: August 2024 - January 2025 (Freelance)
Location: United Kingdom (Remote)
Job Description:
- Scraped, gathered, and collected data from YouTube live streams using APIs, extracting detailed performance metrics and trends to provide data-driven insights for optimizing client strategies and decision-making.
- Performed in-depth analysis of content performance, identifying critical factors such as optimal posting times, high-engagement content types, and top-performing video games that drove the highest viewership and audience retention.
- Collected and analyzed performance data from top YouTube gamers, conducting a comprehensive comparative analysis with client-specific metrics to evaluate positioning and identify opportunities for improvement.
- Conducted a thorough competitive analysis of top YouTube gamers, generating insights that helped the client grow their channel from 15,000 to 28,000 subscribers within two months, resulting in a $4,000 increase in revenue.
- Delivered actionable recommendations based on the analysis, which led to a 45% growth in the client’s live streams, significantly boosting audience engagement and expanding their online presence.
- Implemented data-driven strategies to optimize content performance, enhance audience retention, and ensure continuous improvement in viewership and revenue growth.
Job Title: Data Analyst Intern
Company: Cognorise Infotech
Date: November 2023 - August 2024
Location: India (Remote)
Job Description:
- Analyzed and visualized real-world datasets across diverse industries, providing actionable insights to drive business growth and improve operational efficiency.
- Led a churn analysis project for a tour and travel company, leveraging predictive analytics to identify customers at risk of attrition. Successfully retained 76.5% of at-risk customers, reducing overall churn rates by 67% through strategic interventions and targeted retention efforts.
- Provided data-driven insights to optimize marketing campaigns, resulting in a 15% improvement in outcomes and significantly enhancing customer engagement and interaction.
- Recommended business intelligence strategies to enhance customer retention, utilizing predictive analytics and tailored marketing campaigns to address customer needs and preferences.
- Proposed enhancements to the complaint resolution workflow, aimed at addressing customer grievances more effectively, leading to an expected 20% increase in both customer satisfaction and retention rates.
Skills
Python, SQL (MySQL, SQL Server), Microsoft Excel, Data Visualization (Power BI, Tableau), Data Scraping (API, BeautifulSoup, Selenium), Microsoft Azure (Azure Data Lake, Azure Data Warehouse, Data Bricks), Google Cloud, AWS, IBM SPSS (Statistics, Mathematics).
EXPERTISE TECHNOLOGIES
Python:
- Pandas: Data manipulation and analysis.
- NumPy: Numerical computations.
- Matplotlib & Seaborn: Data visualization.
- Jupyter Notebooks: Interactive development and data analysis environment.
Power Bi:
- Power Query: Data transformation and loading.
- DAX (Data Analysis Expressions): Data modeling and calculations.
- Azure: Power BI integrates with Azure for enhanced data processing, especially when dealing with big data.
Microsoft Excel:
- Power Query: Data connection and transformation.
- Power Pivot: Data modeling for large datasets.
- VBA (Visual Basic for Applications): Automating repetitive tasks and creating macros.
- PivotTables and PivotCharts: Data summarization and analysis.
- Solver and Data Analysis ToolPak: Advanced statistical and optimization analysis.
- Excel Add-ins: Tools like “Analysis Toolpak” and third-party integrations for specialized functions.
SQL:
Relational Database Management Systems (RDBMS):
- MySQL: Open-source RDBMS for structured data. MySQL IDES:
- MySQL Workbench: SQL development and administration tool for MySQL.
Tableau:
- Tableau Desktop: Primary tool for building visualizations and dashboards.
- Tableau Server: On-premise platform for sharing and collaboration.
- Tableau Prep: Data preparation and cleaning tool.
Data Scraping:
- Google Cloud Console: YouTube Data API
- Python: googleapiclient
- ETL Processes
📚 Education
- School: Kaduna Polytechnic
- Course Studied: Food Technology
- Grade: Upper Credit(Second Class Upper)
🗞️ Certification
- Certificate of completion with credit in Data Anlysis from APPCLICK ACADEMY
- Certification of Achievement from CONGNORISE INFOTECH (CR1T11CTF044)
- Top Data Analyst Nominee 2025