facebook
from30.91EUR/ 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 -04: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 30.91€Online via webcam
from 43.27€At 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 -04: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 30.91€Online via webcam
from 43.27€At 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
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.

Salah Eddine
Excel with Microsoft Office: Unlock Your Potential in the Gulf Region
Do you aspire to maximum efficiency, limitless creativity and unparalleled productivity in the Gulf region? Let us guide you to excellence with Microsoft Office. Why Choose Microsoft Office? Harness Your Creativity: With Word, Excel, PowerPoint and more, you'll have powerful tools to bring your projects to life, whether creating corporate documents, developing cutting-edge financial tables or delivering presentations breathtaking. Save Time with Automation: Excel simplifies complex tasks with its smart formulas, pivot tables and many other innovative features. Accessible Anywhere: Whether you're in the office, on the road, or at home, Microsoft Office is available on all your devices, allowing you to work wherever and whenever you want. Join the Microsoft Office Revolution! Do not accept compromises in your daily professional life. Invest in the power of Microsoft Office and unlock your full potential. Transform the way you work, create with ease, and reach new heights with Microsoft Office. Register now to master Microsoft Excel, Microsoft Word and Microsoft PowerPoint at all levels and drive your business to excellence in the Gulf region.

Myat Hein
Maths and Further Pure Maths for Secondary Students
This class is designed to help students tackle key GCSE and secondary-level Maths concepts with confidence. From algebra to trigonometry, I'll guide you through each topic with clear explanations and problem-solving techniques. Whether you're preparing for exams or just looking to improve your Maths skills, this course is tailored to your individual needs. Having transformed my own understanding of Maths from a beginner to achieving top grades, I know how to break down complex topics and make them easier to understand. You can trust me to help you succeed!

Aymen
Programming: Introduction to Python (Beginner level)
In this class, you’ll embark on an exciting journey into the world of programming with Python. You’ll start by writing your very first Python program, gaining hands-on experience from the get-go. As you progress, you’ll delve into the core fundamentals of Python, including variables, data types, control structures, functions, and modules.

George
Python for beginners: Learn an amazing coding language!
Python is a very useful and dynamic coding language which is very useful to learn. I'm here to help you along your journey to learn the basic coding techniques and put them into practice. Even if my younger age of 17 I still hold an impressive knowledge of Python, using it for over 3 years! We will go over Python basics such as syntax reading and variable, and move up to some slightly more advanced techniques like loops and functions.

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 !

Aniket
Oracle Certified Tutor/Trainer For Java, Python and Web with 300+ Reviews
- B.tech and M.tech in Computer Science - Worked as a Software engineer in Virtusa Corp & DIGIDEZ - More than 6 years of teaching experience - Oracle Certified Developer - Helped students placed in FAANG Featured Review : Been trying to learn Java on my own for about 1 year and I couldn't get a grasp on it. Aniket make learning Java a fun experience and challenges you to think for yourself to reinforce the concepts you've learned. I am truly excited for our meetings and he makes time go by so fast that I'm upset when they end. Great teacher and he is genuinely passionate about your success. If I could give him more stars I would!!! Thanks Aniket

Yasmine
I have a Master 2 in Audit and management control, I offer Excel courses
Excel lessons based on exercises. Learn to use formulas, pivots, useful shortcuts. Demonstration and practice via exercises. The lessons depend on the level of the student and depending on their needs, this can be adapted gradually. I have a Master 2 in Audit and Management Control and 10 years of experience in finance with multinationals (in different countries). As well as experiences in coaching and mentoring in international competitions for students.

Benito
Python, SQL and/or Machine/Deep Learning Classes at your place or Online!
I am currently working as an online teacher 🧑‍🏫 and course content developer in Python, SQL 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 👉 Free support between lessons What topics do I usually cover at the beginning for people without Python/SQL experience? ✔️ Understanding the basic concepts (variables & types) --> Python/SQL ✔️ Math & Statistics (explained easily) --> Python ✔️ Data Manipulation (tables, dataframes, joins,...) --> Python/SQL What topics do I cover for people with Python/SQL experience? ✅ Classic libraries: Pandas, Numpy, Scikit-learn, Tensorflow, Pytorch ✅ Data Analytics/Visualization: Plotly, Seaborn, Matplotlib ✅ Domains: Regression, Classification, NLP, LLM, Computer Vision, Generative AI, Time Series, Neural Networks, Ensemble Methods ✅ MLOps: MLflow, Prefect, Mage, 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!😉

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.

Amine
Computer course for all levels , EXCEL, WORD, POWER-POINT, Coaching in Computer Science, Office Automation
I offer courses in computer science for different languages and frameworks also intended for students in classes preparatory and license in computer science. Tailor-made training adapted to the profile of each student whatever his difficulties, with a pleasure of teaching; academic orientation sessions, and then the addition of other subjects that I master is surely possible.

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.

Nancy
Python Programming for beginners and intermediates
As a tutor, my goal is to create a supportive and engaging learning environment where students feel confident to explore and grow. I tailor my teaching style to suit each student's unique needs. My focus is on building a solid foundation in algorithm and computational concepts and fostering critical thinking, helping students not only understand the material but also develop independent problem-solving skills. For parents, I value open communication and progress updates, ensuring they are informed and involved in their child’s learning journey. My background in mathematics and data science allows me to approach problems from both analytical and practical perspectives, giving students valuable insights into real-world applications of what they learn.

Azzedine
Use Excel, Word and PowerPoint for optimal performances and unlimited creativity!
Boost your product and edit your creativity with Microsoft Office: Liberate all your capabilities to create this file! Do I find a solution to improve your effectiveness, stimulate your creativity and increase your productivity at home? Don't share anything else with Microsoft Office. Why choose Microsoft Office? Explore your creativity: with Word, Excel, PowerPoint and other applications, you can find out which files you want to donate to your IDs, which is suitable for creating professional documents, creating calculus complexes or performing percutantes. Turn on the high-temperature automation: Excel simplifies complex touches with intelligent formats, dynamic table rotations and intelligent functions. Available part: If you travel to your office, place it or your home, access Microsoft Office to all your devices, you will be able to use it anywhere else. Benefit from the Microsoft Office revolution! Do not allow any obstacles to enter your progression. Invest in the Microsoft Office box to edit all your photos. Transform your travel façon and lancez-vous facilement in new records with Microsoft Office. Inscribe your main content to master Microsoft Excel, Microsoft Word and Microsoft PowerPoint to all of your children, which you can do now, in the future or later.

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.