

from29.70EUR/ h
Data Analytics Tutorials -- Join the Data Dive: Your Guide to Excel, SQL, Power BI and Python
Excel, SQL, and Python: Essential Tools for Data Analysts
As a data analyst, mastering Excel, SQL, and Python is crucial for effectively extracting, manipulating, and analyzing data. This comprehensive course is designed to equip you with the practical skills needed to excel in these essential tools.
Key areas of focus include:
Excel: Learn advanced Excel techniques, including data manipulation, pivot tables, and data visualization.
SQL: Gain proficiency in SQL for querying databases, extracting relevant data, and performing data analysis.
Python: Discover the power of Python for data analysis, including data cleaning, manipulation, and visualization using popular libraries like Pandas, NumPy, and Matplotlib.
Through hands-on exercises and real-world examples, you'll develop the confidence and expertise to tackle complex data analysis challenges and drive informed decision-making.
As a data analyst, mastering Excel, SQL, and Python is crucial for effectively extracting, manipulating, and analyzing data. This comprehensive course is designed to equip you with the practical skills needed to excel in these essential tools.
Key areas of focus include:
Excel: Learn advanced Excel techniques, including data manipulation, pivot tables, and data visualization.
SQL: Gain proficiency in SQL for querying databases, extracting relevant data, and performing data analysis.
Python: Discover the power of Python for data analysis, including data cleaning, manipulation, and visualization using popular libraries like Pandas, NumPy, and Matplotlib.
Through hands-on exercises and real-world examples, you'll develop the confidence and expertise to tackle complex data analysis challenges and drive informed decision-making.
Location
Online via webcam
At student's location: Around Coventry, United Kingdom






|
Use ctrl + wheel to zoom!
General info
Age: | Adults (18-64 years old) Seniors (65+ years old) |
---|---|
Student level: | Beginner Intermediate Advanced |
Duration: | 60 minutes |
The class is taught in: | English |
About Me
I'm Samuel, a data analyst with a passion for empowering others through the power of data.Here's what sets me apart as your Data Analysis Tutor:
Proven Track Record: I bring over 5 years of experience working as a Data Analyst, having demonstrably improved data accessibility, reduced customer churn, and increased sales prediction accuracy.
Master of Many Tools: I'm well-versed in industry-standard tools like Excel, SQL, Python, Power BI, and Tableau, ensuring you get a comprehensive learning experience.
Data Storytelling Enthusiast: I believe in clear and impactful communication. I'll help you not only analyze data but also translate it into actionable insights stakeholders can understand.
Passionate and Patient Instructor: My goal is to make data analysis accessible and engaging for everyone. I tailor my approach to your learning style and ensure you grasp the concepts at your own pace.
Results-Oriented: I go beyond theory and focus on practical skills that will help you excel in the real world.
Whether you're a beginner seeking a strong foundation or an aspiring data analyst looking to refine your skills, I'm here to guide you on your data journey.
Ready to unlock your data superpowers? Let's connect!
Education
Master of Science: Data Science | Coventry University, England (Ongoing)Master of Computer Application: Computer Science and IT | Jain university
Bachelor of Science: Agricultural Economics | University of Port Harcourt
Experience / Qualifications
Data Analyst | 09/2019 – 09/2024• Developed and maintained dashboards with Power BI and Tableau to monitor key performance indicators (KPIs), resulting in a 15% improvement in data accessibility and decision-making.
• Conducted extensive data mining and predictive modelling using Python and Scikit-learn to identify customer churn patterns, leading to a 10% reduction in customer attrition.
• Collaborated with cross-functional teams to analyze and interpret data, providing actionable insights that drove product development and marketing strategies.
• Created automated reports using Power BI, facilitating real-time monitoring of sales trends, and enabling prompt adjustments to marketing campaigns.
• Utilized SQL for data extraction, transformation, and loading (ETL) processes, streamlining data workflows and improving data accuracy.
• Assisted in collecting and analyzing data from various sources, contributing to the creation of comprehensive customer profiles.
• Conducted exploratory data analysis to identify trends and outliers in the data, providing valuable insights for strategic decision-making.
• Developed Python scripts for data cleaning and preprocessing, improving data quality and reducing errors.
• Assisted in building predictive models to forecast sales trends, which increased the accuracy of sales predictions by 12%.
Achievements and Impact:
• Reduced customer attrition by 10% through predictive modelling.
• Improved data accessibility and decision-making with a 15% enhancement in KPI monitoring.
• Enhanced sales prediction accuracy by 12% through predictive models.
• Contributed to the development of automated reports, enabling real-time sales trend monitoring.
• Streamlined data workflows and improved data accuracy, leading to more efficient ETL processes.
Ask a question
Send a message explaining your needs and Samuel Oyakhilome Kwasi will reply soon:
The more detail, the better.
Ex. "Hi, when are you available to meet for a lesson?"
Ex. "Hi, when are you available to meet for a lesson?"
Availability of a typical week
(GMT -04:00) New York
Mon | Tue | Wed | Thu | Fri | Sat | Sun | |
---|---|---|---|---|---|---|---|
0 | |||||||
1 | |||||||
2 | |||||||
3 | |||||||
4 | Monday at 4:00 | Tuesday at 4:00 | Wednesday at 4:00 | Thursday at 4:00 | Friday at 4:00 | Saturday at 4:00 | Sunday at 4:00 |
5 | Monday at 5:00 | Tuesday at 5:00 | Wednesday at 5:00 | Thursday at 5:00 | Friday at 5:00 | Saturday at 5:00 | Sunday at 5:00 |
6 | Monday at 6:00 | Tuesday at 6:00 | Wednesday at 6:00 | Thursday at 6:00 | Friday at 6:00 | Saturday at 6:00 | Sunday at 6:00 |
7 | Monday at 7:00 | Tuesday at 7:00 | Wednesday at 7:00 | Thursday at 7:00 | Friday at 7:00 | Saturday at 7:00 | Sunday at 7:00 |
8 | Tuesday at 8:00 | Thursday at 8:00 | Friday at 8:00 | Saturday at 8:00 | Sunday at 8:00 | ||
9 | Tuesday at 9:00 | Thursday at 9:00 | Friday at 9:00 | Saturday at 9:00 | Sunday at 9:00 | ||
10 | Tuesday at 10:00 | Friday at 10:00 | Saturday at 10:00 | Sunday at 10:00 | |||
11 | Tuesday at 11:00 | Friday at 11:00 | Saturday at 11:00 | Sunday at 11:00 | |||
12 | Tuesday at 12:00 | Friday at 12:00 | Saturday at 12:00 | Sunday at 12:00 | |||
13 | Tuesday at 13:00 | Friday at 13:00 | Saturday at 13:00 | Sunday at 13:00 | |||
14 | Tuesday at 14:00 | Friday at 14:00 | Saturday at 14:00 | Sunday at 14:00 | |||
15 | Tuesday at 15:00 | Friday at 15:00 | Saturday at 15:00 | Sunday at 15:00 | |||
16 | |||||||
17 | |||||||
18 | |||||||
19 | |||||||
20 | |||||||
21 | |||||||
22 | |||||||
23 |
from 29.70€Online via webcam
100% Satisfaction Guarantee
Good-fit Instructor Guarantee
If you are not satisfied after your first lesson, Apprentus will find you another instructor or will refund your first lesson.
Online reputation
- Instructor since October 2024
Availability of a typical week
(GMT -04:00) New York
Mon | Tue | Wed | Thu | Fri | Sat | Sun | |
---|---|---|---|---|---|---|---|
0 | |||||||
1 | |||||||
2 | |||||||
3 | |||||||
4 | Monday at 4:00 | Tuesday at 4:00 | Wednesday at 4:00 | Thursday at 4:00 | Friday at 4:00 | Saturday at 4:00 | Sunday at 4:00 |
5 | Monday at 5:00 | Tuesday at 5:00 | Wednesday at 5:00 | Thursday at 5:00 | Friday at 5:00 | Saturday at 5:00 | Sunday at 5:00 |
6 | Monday at 6:00 | Tuesday at 6:00 | Wednesday at 6:00 | Thursday at 6:00 | Friday at 6:00 | Saturday at 6:00 | Sunday at 6:00 |
7 | Monday at 7:00 | Tuesday at 7:00 | Wednesday at 7:00 | Thursday at 7:00 | Friday at 7:00 | Saturday at 7:00 | Sunday at 7:00 |
8 | Tuesday at 8:00 | Thursday at 8:00 | Friday at 8:00 | Saturday at 8:00 | Sunday at 8:00 | ||
9 | Tuesday at 9:00 | Thursday at 9:00 | Friday at 9:00 | Saturday at 9:00 | Sunday at 9:00 | ||
10 | Tuesday at 10:00 | Friday at 10:00 | Saturday at 10:00 | Sunday at 10:00 | |||
11 | Tuesday at 11:00 | Friday at 11:00 | Saturday at 11:00 | Sunday at 11:00 | |||
12 | Tuesday at 12:00 | Friday at 12:00 | Saturday at 12:00 | Sunday at 12:00 | |||
13 | Tuesday at 13:00 | Friday at 13:00 | Saturday at 13:00 | Sunday at 13:00 | |||
14 | Tuesday at 14:00 | Friday at 14:00 | Saturday at 14:00 | Sunday at 14:00 | |||
15 | Tuesday at 15:00 | Friday at 15:00 | Saturday at 15:00 | Sunday at 15:00 | |||
16 | |||||||
17 | |||||||
18 | |||||||
19 | |||||||
20 | |||||||
21 | |||||||
22 | |||||||
23 |
from 29.70€Online via webcam
Good-fit Instructor Guarantee
If you are not satisfied after your first lesson, Apprentus will find you another instructor or will refund your first lesson.
Share
You are here
Similar classes
Private coding / programming lessons with python
Python is one of the best, if not the best, language to start learning programming. It is also one of the most widely used languages today, especially in cutting-edge areas such as machine learning.
This popularity means that Python is constantly evolving. It offers a wide range of tools and libraries, which are free and very varied.
As an aeronautical engineer, I like to share my knowledge and derive satisfaction from it by teaching and motivating others.
I'm used to working with people of different ages. I believe in the importance of segmenting learning, visualizing progress, setting concrete goals and practicing regularly.
Beyond these general principles, there is no magic rule or method. Some approaches work with some students but not with others. Adaptation to individual needs is therefore the main objective of private lessons. So I will do my best to find what motivates and helps my student.
Master Python with Courses Suitable for All Ages and Levels! Beginners, Intermediates, Professionals, Everyone is Welcome
Master Python with Personalized Courses
Discover the art of programming with Python courses tailor-made to meet your specific needs. Whether you are a beginner, intermediate or professional, my lessons are suitable for all levels.
Why Choose My Courses?
Personalized Teaching Approach: Each course is tailored to your skill level and individual goals.
Practical Experience: Learn by doing with real-world projects that build your understanding and skills.
Ongoing Support: Get unlimited email support for any questions you have between sessions.
As a Python expert, I have a passion for teaching and sharing my knowledge. My goal is to guide you effectively in your learning journey.
Book Your First Lesson:
Start your journey to Python mastery now by booking your first lesson. Whether you aspire to enter the development field or hone your existing skills, these courses are designed for you.
From Zero to Web Hero - Learn Python & Django Step by Step
Code Your Ideas Into Reality 💻🚀
Want to build your own website or start a tech career? This class is perfect for absolute beginners who want to learn Python and use it to build real, working web apps with Django. You'll go from writing your first line of code to deploying complete projects - step by step, clearly explained, and handsOn.
✨ No experience needed.
🧠 Learn by doing - real apps, real logic.
🌍 Build skills for school, work, or freelance life.
Let’s turn your curiosity into code. First session gets you started!
Python Programming: Learn to code from scratch, develop your own projects, and progress.
This course is for anyone who wants to learn to program in Python, whether you are a student, a professional, or simply curious.
Python is one of the most widely used languages today, thanks to its simplicity and power. You'll learn how to write your first programs, manipulate data, automate tasks, and understand the essential foundations of modern programming.
The objective is to make you independent in developing your own projects (scripts, small software, data analysis, etc.) and acquire a skill sought after in the academic and professional world.
Data Engineering: Extract Transform Load (ETL) Programming with Apache Airflow - Industry Applications
This course provides a hands-on approach to mastering Apache Airflow, a powerful open-source workflow automation tool widely used in ETL (Extract, Transform, Load) processes. You will learn how to build, schedule, monitor, and optimize data pipelines, ensuring data reliability and efficiency in production environments. Through real-world examples and projects, you will gain the skills required to become a proficient Data Engineer capable of handling complex workflows in modern data ecosystems.
This course will allow you to build multiple real-world ETL workflows using Apache Airflow. Let me know if you would like additional information! 🚀
Master Microsoft Office with Expert Online Private Classes! 🔹📝 Microsoft Word 📊 Microsoft Excel 🎨 Microsoft PowerPoint
Master Microsoft Office with Expert Online Private Classes! 🔹
Boost your skills with one-on-one training in:
📝 Microsoft Word – Professional document formatting, tables, mail merge, reports, and more.
📊 Microsoft Excel – Formulas, functions, pivot tables, charts, data analysis, and macros.
🎨 Microsoft PowerPoint – Stunning presentations, animations, slide design, and storytelling.
Why Choose Our Classes?
✔ Personalized Lessons – Tailored to your skill level & goals.
✔ Flexible Scheduling – Learn at your own pace, anytime.
✔ Practical Training – Real-world exercises & tips.
✔ Certified Instructors – Experienced & patient teachers.
Online Private Classes in Microsoft Word, Excel, and PowerPoint
Online Private Classes in Microsoft Word, Excel, and PowerPoint
Boost your productivity and master essential office skills with personalized one-on-one online training in:
Microsoft Word – Document formatting, tables, mail merge, and more.
Microsoft Excel – Formulas, pivot tables, data analysis, and automation.
Microsoft PowerPoint – Professional presentations, animations, and design tips.
✅ Flexible schedules
✅ Customized lessons
✅ Beginner to Advanced levels
✅ Certification guidance
📩 Contact us today to book your session!
Elevate Your Skills: Online French Classes Tailored for You! \/ Speak French with Confidence
Are you ready to embark on a journey to fluency? Our online French classes are designed for learners of all levels, from beginners to advanced speakers. With engaging lessons, experienced instructors, and interactive resources, you’ll build the skills you need to communicate effectively in French.
Join a supportive community where you can practice speaking, listening, reading, and writing in a fun and dynamic environment. Whether you’re preparing for travel, work, or personal enrichment, our classes will empower you to express yourself with ease and confidence.
Don’t let language barriers hold you back. Sign up today and take the first step toward speaking French fluently!
Course of marocain distance to all of our neighbors
I don't want to eat anywhere near the distance to all our neighbors.
I'll offer my children's memories at a distance from all around the world.
I'm sure you will receive a solution and be supported by outils of the application for more efficaces.
Pour plus information, contactez moy.
Your Computer Science Instructor: From Basics to AI & Beyond
Computer Science is more than just code—it's the foundation of innovation in today's world. In this comprehensive live class, I’ll guide you through everything from the basics of Computer Science to Object Oriented Programming (OOP), Data Structures & Algorithms (DSA), and advanced computing concepts.
We’ll cover:
Core Programming Languages: Python, C, C++, Java, JavaScript, and more
AP Computer Science Preparation
Hands-on Project Development
Artificial Intelligence, Data Science & Machine Learning
I can teach in my own structured style or fully adapt to your preferred curriculum, pace, and goals—whatever helps you learn best. Whether it’s exam prep or real-world projects, we’ll build your Computer Science skills your way.
Develop your expertise in Power BI and Business Intelligence: Create impactful dashboards and professional data visualizations
Whether you're involved in finance, management, planning, project management, human resources, or perhaps an ambitious student looking to hone your professional dashboarding skills, you've come to the right place. If you're looking for a solution that goes beyond the limitations of Excel and PowerPoint, then you've come to the right place: allow me to introduce you to Power BI.
With Power BI, I offer you much more than just a tool. It's a gateway to interactive reporting, efficient data management, and advanced analytics. Here's what I can offer you:
- Expert creation and management of interactive reports.
- Careful transformation and cleaning of data for maximum accuracy.
- Use of powerful DAX formulas for advanced data analysis.
- Creation of custom visualizations and impactful dashboards.
- Secure sharing and publishing of your reports for seamless collaboration.
-Automation of repetitive tasks with Power BI & Power Query.
Whatever your specific needs—whether they relate to professional projects, studies, or personal aspirations—I'm here to offer you a tailor-made solution. Together, we'll create a program tailored to your goals, guiding you through every step of your learning journey.
Whether you're a beginner looking to master the basics or an expert looking to deepen your knowledge of data analysis, I'm here to provide the expertise and support you need to succeed.
Support course in Python (For all levels, CPGE)
We are a team of engineers passionate about programming. We offer Python tutoring courses suitable for all levels (beginners, advanced students, CPGE students, or anyone looking to develop their skills).
Our courses combine essential foundations, practical examples and clear teaching to ensure solid and useful progress for both studies and careers.
Learn Python, machine learning with me until you become an expert.
Start your journey into the world of Python programming with this hands-on, beginner-friendly course and also for expert level. Whether you're completely new to coding or looking to expand your skills, this course will guide you through the core concepts of Python — from variables and data types to control structures, functions, and lists.
As you build a strong foundation in programming, you'll also dive into the powerful data analysis capabilities of Python using popular libraries like Pandas and NumPy . Learn how to clean, process, and analyze real-world data sets to extract meaningful insights.
Next, bring your data to life with stunning visualizations using Matplotlib and Seaborn , two of the most widely used data visualization libraries in Python.
Finally, take your skills to the next level by building your own web applications using either Flask or Django — two of Python’s most popular web frameworks.
By the end of this course, you’ll have a well-rounded understanding of Python programming, data manipulation, visualization, and web development — empowering you to create real-world projects and pursue further specializations.
Statistical Analysis with Python and R (Rstudio) - Intro to Data Science
By delving deep into the practical applications of statistics and data science, this course is designed to set you up for success.
Learn from real-world examples: Instead of spending hours on theoretical material and trying to relate it to practical issues, we will focus solely on applied statistics. Programming will allow you to apply theory to real-world problems, equipping you with the knowledge and skills you need to succeed.
We won’t be spending hours solving math problems by hand for reinforcement, as this isn’t school. Instead, we’ll use cutting-edge methods and code libraries that leverage the latest software releases to maximize productivity and efficiency.
If you have any further questions, please do not hesitate to contact us.
Introduction to Python: Programming Basics and Simple Applications
This course is designed for beginners who want to get started with programming in Python, one of the most popular and accessible languages today. No previous experience is necessary. In one session, students will learn the basics of programming and will be able to create their first Python applications. With clear explanations, practical exercises, and real-world examples, this course is an ideal gateway to exploring computer science and coding.
Online Course: Introduction to Python - Programming Basics and Simple Applications
Duration :
- 60 minutes: intensive format to learn fundamental concepts.
- 90 minutes: In-depth format with more time for practical examples and interactive questions.
---
Educational objectives
At the end of the course, participants will be able to:
1. Understand the basics of programming, including the concepts of variables, data types, conditional structures, and loops.
2. Write and run simple Python scripts.
3. Manipulate inputs and outputs to interact with the user.
4. Solve practical problems with short, functional programs.
---
Course syllabus
1. Introduction (10-15 min)
- Presentation of Python: Why this language?
- Installation and configuration of a programming environment (IDLE, Visual Studio Code, or Jupyter Notebook).
- First program: *"Hello, World!"*.
2. Python Basics (20-30 min)
- Variables and data types (integers, strings, lists).
- Mathematical operations and data manipulation.
- Conditional structures (if/else) and loops (for/while).
3. Practical exercises (20-35 min)
- Write a program to calculate the sum of two numbers provided by the user.
- Create a simple application, like a currency converter or password generator.
- Bonus for 90 min format: Fixed a more complex issue involving lists or loops.
4. Q&A and conclusion (5-10 min)
- Summary of the concepts covered.
- Suggestions for resources to continue learning.
- Feedback on the course.
---
Teaching methodology
- Interactive and engaging: the course combines theoretical explanations with practical exercises.
- Personalized approach: Sessions are tailored to the needs of participants. Students are encouraged to ask questions at any time.
- Learning by doing: examples and exercises are designed to help you assimilate concepts quickly.
---
Target audience
This course is ideal for:
- Complete beginners in programming.
- Students or professionals wishing to acquire skills in Python for their personal or professional projects.
- Anyone curious to discover a powerful and versatile tool for solving problems.
---
Benefits of this online course
- Teaching by an experienced and passionate trainer.
- Interactive sessions adapted to your learning pace.
- Access to educational materials and exercises to continue practicing after the course.
Join us now to discover programming and its applications using Python!
---