facebook
from25.00GBP/ 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.

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?"

Availability of a typical week

(GMT -05:00) New York
MonTueWedThuFriSatSun
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 £25Online via webcam
from £35At student's home

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 -05:00) New York
MonTueWedThuFriSatSun
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 £25Online via webcam
from £35At student's home

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


Matías
Microsoft Office Suite (Word, Excel, Access, Powerpoint) and VBA
Are you looking for efficiency, creativity and productivity in your daily tasks? Do not look any further. Microsoft Office is there to meet all your expectations. Why choose Microsoft Office? Create with Power: Word, Excel, PowerPoint and many other applications give you powerful tools to bring your ideas to life, whether it's for a professional document, a financial dashboard or a stunning presentation. Collaborate with ease: OneDrive and Teams allow you to collaborate with your colleagues or friends, no matter where you are. Work together in real time, share files and communicate easily. Save Time with Automation: Excel simplifies complex tasks with smart formulas, while Outlook organizes your emails and calendar so you can focus on what matters. Advanced Security: Protect your data and privacy with advanced security features, such as two-step verification and access management. Advanced Programming: As a specialist, I master programming in VBA (Visual Basic for Applications) to automate your tasks and personalize your Office applications. Additionally, in the latest version of Microsoft Office you also have the option to program in Python, a language that I also master. Available Everywhere: Whether you're in the office, on the road, or at home, Microsoft Office is accessible on all your devices, allowing you to work wherever and whenever you want. Join the Microsoft Office Revolution! Don't let everyday challenges slow you down. Invest in the power of Microsoft Office and unlock your potential. Transform the way you work, create with ease, and reach new heights with Microsoft Office.

Salah Eddine
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.

Camille
Master Excel for Finance with a Data Engineer and Finance Graduate! I give Excel/GoogleSheets/Spreadsheets and Finance courses
For all levels, I give you the essential basics on Excel or other spreadsheets and on finance in order to develop your skills. We will see the essentials, namely, Income Statement, Cash Flow Statement, Balance Sheet, LBO Model, DCF model. We can then explore advanced tools according to your needs. You can also submit case studies to me and I will respond with an adapted methodology.

Mohamed
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! 🚀

Professeur
- Cours d'Excel à distance Pour tous les niveaux : EN LIGNE-
- Cours d'Excel à distance Pour tous les niveaux : EN LIGNE- Je donne des Cours d'Excel à distance pour tous les niveaux. J'offre des séances en Excel à distance pour tous les niveaux. J'assure un soutien approfondi et bien supporté par des outils d'apprentissage les plus efficaces. Pour plus d'informations, contactez moi

Miguel Pérez
Python for all levels. From scratch onwards or for a specific project.
This course is designed to teach you everything from the basics of the language to more advanced concepts, allowing you to develop skills in programming, automation, data analysis, web development, and more. Python is one of the most popular and versatile programming languages in the world, used by companies like Google, Facebook, and NASA. Its clear and simple syntax makes it a great choice for beginners and experienced programmers alike. Throughout the course, you will learn: ✅ Python basics (variables, data structures, flow control) ✅ Object-oriented programming (OOP) ✅ File and database manipulation ✅ Use of popular libraries such as NumPy and Pandas It doesn't matter if you've never programmed before or if you already have experience with other languages. This course will guide you step by step to master Python and be able to apply it in the real world! Ready to get started? 🚀

Amine
Microsoft Excel (Formules et création des tableaux et calculs)
Une formation selon votre besoin et le niveau sur les fonctionnalités et formules Excel. Je divise la session sur 2 phases: Phase 1: Formules Avancées (formules de calculs, formules de logiques, formules mathématiques etc) Phase 2 : Cas pratique et création des tableaux Vous serez capable de manipuler les formules avancées Vous serez capable de les pratiquer dans la création de vos tableaux.

Benito
Python and/or Machine/Deep Learning Classes at your place or Online!
I am currently working as an independent consultant, technical writer, online teacher 🧑‍🏫 and course content developer in Python, and a wide range of Machine/Deep Learning topics 🧑‍💻. My experience enables me to offer lessons ranging from beginner to advanced levels. I can tailor the classes to your specific needs and schedule, providing a well-structured learning path 🚀. What do you get from me? 👉 Learn at your own pace without any pressure 👉 Well-documented tutorials What topics do I usually cover at the beginning for people without Python experience? ✔️ Understanding the basic concepts (variables & types) ✔️ Math & Statistics (explained easily) ✔️ Data Manipulation (data cleaning, preprocessing...) What topics do I cover for people with Python experience? ✅ Classic libraries: Pandas, NumPy, Scikit-learn, TensorFlow ✅ Data Analytics/Visualization: Plotly, Seaborn, Matplotlib ✅ Domains: Regression, Classification, NLP, LLM, RAG, Computer Vision, Neural Networks, Ensemble Methods, Clustering, Dimensionality Reduction ✅ MLOps: MLflow, Prefect, GCP, AWS Whether you are new to the field, seeking to enhance your skills, or require assistance with a work/school project, feel free to reach out to me! 😉

Carlos Alberto
Clases de Excel básico e Intermedio Online para principiantes
Microsoft Excel es una herramienta poderosa que facilita la gestión y análisis de datos, optimizando nuestras tareas diarias de manera más eficiente. Dominar sus funciones no solo mejora la productividad, sino que también abre nuevas oportunidades laborales y profesionales. En este curso, aprenderás desde los conceptos básicos, como abrir la aplicación y familiarizarte con su interfaz, hasta el uso de fórmulas esenciales y herramientas intermedias para la gestión de datos. Al finalizar, serás capaz de manejar Excel con mayor confianza y aplicar sus funciones para optimizar tu trabajo diario.

Dishant
Python and Java Programming Bootcamp for Computer enthusiats
Welcome to my immersive - Programming Bootcamp, a comprehensive journey designed to empower you with one of the most versatile and in-demand programming languages of our time! Python and Java stands at the forefront of the technological revolution, fueling advancements in artificial intelligence, automation, and web development. Whether you’re an aspiring developer or a student of any level preparing for exams, this bootcamp is crafted to give you the knowledge and confidence to excel. Starting from the very basics, I’ll guide you through every essential topic with a detailed, hands-on approach. Each session is structured to build a solid foundation, gradually progressing into more advanced concepts to ensure your learning is smooth, intuitive, and rewarding. My commitment to your satisfaction and understanding is absolute—I take pride in creating an environment where every question is welcomed, each concept is clarified, and no one is left behind. With clear explanations and patient guidance, I’m here to help you achieve mastery step by step. The bootcamp doesn’t stop at theory. To make learning meaningful and memorable, I’ve integrated real-world projects that bring to life. You’ll apply your skills in practical scenarios, tackling hands-on projects that simulate industry challenges. By the end, you’ll have a portfolio of applications showcasing your proficiency, making you well-prepared for real-life tech opportunities. With an emphasis on clarity, relevance, and personalized support, my goal is to ensure that your learning experience is both empowering and enjoyable. Whether you’re seeking to advance in your career or simply unlock new skills, I’m here to make this journey as impactful as possible. Join me in this Bootcamp, where your growth and success are my highest priorities, and take the first step toward unlocking your potential in the world of programming.

Miron
Programming with Python (Chatbots, Web Applications, AI ... )
Welcome to the exciting world of Python, where coding dreams come to life! 🐍💻 In this captivating class, you'll embark on a coding journey like no other. Whether you're a beginner or an aspiring Python pro, I'm here to guide you step-by-step through the language's wonders. Together, we'll dive into Python's syntax, data structures, and functions, mastering the art of problem-solving along the way. Prepare to create mesmerizing projects, from simple games to interactive chatbots, and explore the realm of web development. No matter your age or experience, this class is designed to inspire, challenge, and empower you. So, let's embark on this incredible coding adventure and turn your Python dreams into reality! 🚀🌟

Franck
Introductory computer, office automation and Powershell course
With a Bac+3 degree in IT, I have been working as an IT administrator in a large company for 17 years. I would like to give you a personalized introductory or advanced IT course tailored to your needs. Create a unique and impactful CV with Word? Create a monthly budget in Excel? Sort your emails automatically or hold meetings in Outlook? Make a beautiful presentation in PowerPoint? Navigate and search the internet easily? Tell me your goal and I will help you achieve it quickly. For the more advanced, I master the Powershell language to professionally automate your Windows administration tasks. I practice daily in a large company context the creation of professional Powershell scripts. I can help you program your first scripts or via advanced courses train you on specific features. The secret to progressing quickly is practice! I aim to make computing easy and accessible to everyone. I offer the first hour of class. If you take a 10 hour pack I offer 1h30 and for 5 hours I offer 30 minutes. Christmas is coming and you could also offer this gift to a loved one...

Mouad
Support course in Python (For all levels, CPGE)
Passionate about programming, we offer Python support courses adapted to all levels, from beginner to advanced. These courses are aimed at students in preparatory classes for grandes écoles (CPGE) as well as anyone wishing to acquire solid programming skills. The lessons cover the essential foundations of Python with a clear and accessible teaching approach. Whether you are new to programming or want to deepen your knowledge, you will benefit from structured and progressive teaching. With a focus on concrete concepts and practical examples, these courses aim to strengthen your skills in a tangible way. You will be guided through the nuances of Python, gaining a deep understanding that will benefit you both in your studies and in your future career. Join us to explore the fundamentals of Python programming and progress to more advanced levels. Together, we will build a solid foundation and develop the skills needed to succeed in the dynamic world of computer programming.

Salomé
University graduate gives computer/excel/word/typing lessons
A 32-year-old university graduate, management engineer, with 8 years of professional experience offers her teaching services. Course (1 hour only online) - 1 hour 30 minutes or 2 hours depending on subject/level/location Educational and organized teacher with good revision and organization techniques Microsoft Office - excel/word/powerpoint - mail - typing - ... Educator and patient with a good methodology adapted to each student 97% success rate with regular monitoring Feel free to contact me for more information ! See you soon

Amin
Microsoft Office tools for beginners, intermediates and advanced
Looking to master Microsoft Office tools? This course covers the three most popular Microsoft Office products: Word, PowerPoint, and Excel. Designed primarily for beginners, the course also offers support for those already familiar with the basics, helping you achieve proficiency with these tools. The course can be tailored for individual or group learning. With our assistance, you'll be mastering Microsoft Office in no time. If you have any questions, please do not hesitate to contact us.