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 ⊞+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


Salah Eddine
Master Microsoft Excel, Word and PowerPoint from zero to expert!
Optimize Your Efficiency with Microsoft Office: Unleash Your Creativity at Every Level! If you're looking for a solution to improve the efficiency, creativity and productivity of your daily tasks, look no further than Microsoft Office. Why Choose Microsoft Office? Unleash Your Creativity: Word, Excel, PowerPoint and many other applications give you powerful tools to bring your ideas to life, whether you're creating professional documents, building impactful financial dashboards or designing impressive presentations. Save Time with Automation: Excel simplifies complex tasks with smart formulas, pivot tables, and other nifty features. Available Anywhere: 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 daily challenges slow down your progress. Invest in the power of Microsoft Office to unlock your full potential. Transform the way you work, create easily, and reach new heights with Microsoft Office. Sign up now to master Microsoft Excel, Microsoft Word, and Microsoft PowerPoint at every level, whether you're beginner, intermediate, or advanced.

Anas
Private lessons in math - physics - chemistry - engineering science
Hello dear students and participants, As a former teacher, I had the privilege of supporting more than 40 students over the past year in their academic progress. I teach the following subjects: mathematics, physics, chemistry, engineering sciences and Excel. Thanks to my personalized and structured approach, I help my students develop their skills, their self-confidence and their autonomy. By working with me you will learn: *Effective resolution methods, *Intensive practice of exercises, *Educational coaching adapted to your needs, *The development of summary revision sheets, *Career guidance to inform your future choices, *Practical practical work in engineering sciences, to anchor concepts in reality. At the same time, as an information technology consulting engineer, I have in-depth expertise in the technical field, with the ability to design and implement innovative solutions in complex environments. Passionate about aeronautics and piloting aircraft, I cultivate essential qualities such as rigor, discipline and rapid decision-making in dynamic environments. This passion fuels my teaching by adding a practical and inspiring perspective.

Mahnoor
AI for Complete Beginners: A Practical Guide to Understanding and Building AI
Artificial Intelligence is a powerful technology that is reshaping industries worldwide. As an AI enthusiast, you'll need to navigate through its many concepts and techniques to build intelligent systems effectively. I've designed this course as a practical guide to AI, specifically created for beginners who want to understand and apply AI from the ground up. You'll learn the fundamentals of machine learning, neural networks, and data processing. Step by step, we’ll explore key concepts like training models, working with datasets, and implementing AI in real-world applications. Through hands-on projects and practical exercises, you'll not only grasp the basics but also gain the confidence to build and experiment with your own AI models. By the end of this course, you’ll have a strong foundation in AI and be able to start exploring more advanced topics, unlocking the full potential of artificial intelligence.

Hamza
Maîtrisez Python avec un Expert en Programmation et Data Science
Découvrez la puissance de Python avec un formateur expérimenté en informatique ! Je suis Hamza, un développeur passionné et mentor chevronné avec une vaste expérience dans l'enseignement de la programmation. Mon approche pédagogique unique vous permettra d'acquérir rapidement des compétences solides en Python, tout en découvrant ses applications concrètes dans le monde professionnel. Ce que vous apprendrez : Fondamentaux de Python (variables, structures de contrôle, fonctions) Programmation orientée objet avancée Analyse et visualisation de données avec pandas et matplotlib Développement d'interfaces graphiques avec PyQt Projets pratiques inspirés de cas réels en entreprise Pourquoi me choisir ? Plus de 5 ans d'expérience en formation et mentorat Méthode pédagogique adaptée à tous les niveaux Approche hands-on basée sur des projets concrets Passion contagieuse pour le code et l'innovation technologique Que vous soyez débutant cherchant à vous lancer dans la programmation ou professionnel souhaitant monter en compétences, ce cours vous ouvrira de nouvelles perspectives passionnantes dans le monde du développement logiciel et de la data science. Rejoignez-moi pour un voyage captivant au cœur du langage de programmation le plus polyvalent et demandé du marché ! Réservez maintenant et faites le premier pas vers la maîtrise de Python. Votre carrière en tant que développeur Python commence ici !

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

Youness
Office Automation Training: Excel, Word, Remote Power Point / Online
- I teach in Excel, Word, Power point, Access, Outlook, internet, computer maintenance at home or remotely. - For more information, contact me. - I teach in Excel, Word, Power point, Access, Outlook, internet, computer maintenance at home or remotely. - For more information, contact me. - I teach in Excel, Word, Power point, Access, Outlook, internet, computer maintenance at home or remotely. - For more information, contact me.

Younes
Master Python at All Levels with Personalized Lessons - SUP SPE Program included
Start with the fundamentals like variables, loops, and conditionals, and progress to more advanced concepts including manipulating files, images, and using Python libraries like Numpy, Scipy, Pandas, and Matplotlib. Also explore the fundamentals of object-oriented programming. Why choose this Course? By opting for these courses, you will have the opportunity to consolidate your knowledge through practical exercises and concrete mini-projects which will strengthen your Python skills. Each session will be interactive, allowing you to ask questions and receive constructive feedback on your code. You will be able to benefit from personalized support. Lessons are tailored to your level, whether you're looking to pursue a career in programming or just want to learn for fun. Sessions are tailored to your goals, and ongoing support is provided to overcome any challenges you may encounter.

Alper
Automating the Internet: Python, Selenium, Intro to Web-Scraping
Are you interested in automating the boring stuff on the internet? Would you like to have your computer handle the boring tasks you spend your time on? Would you like to save websites to your PC for later viewing? You can learn to access, manipulate and save data from the internet to your PC by taking this class! It will teach you how to use Selenium with Python to automate basic tasks in your web browser. You can simply sit back and allow your computer handle the tedium. You can save your favourite recipes, pictures and stories from the web to your PC for later viewing. Anything you can do with your own time, the scripts we will write together can do on their own!

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! 😉

Jean Marc
Excel course Word ACCESS PowerPoint general IT
EXCEL POWER POINT WORD and ACCESS are inevitable software when working with a computer. I will introduce you to this software with exercises to do by yourself, exercises accompanied by courses appropriate to your requests.

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.

Majd
Helping you to solve all your problems in math, physics and python language.
Since I have a masters degree in theoretical physics, I can teach math and physics for all levels, I'll do my best to help you understand any problem you face. As for python language, I can be considered as an expert, since I used it to analyse data during my internships, thus I'll also help you to do your projects and fix the bugs.

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.

Amin
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.