facebook
from30.04EUR/ 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 -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.04€Online via webcam
from 42.05€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.04€Online via webcam
from 42.05€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


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.

Ephraim
Python 101: Master the Language of Programming, From Basics to Advanced Concepts
In this course, you'll learn Python from the ground up, starting with the basics and progressing to more advanced concepts. You'll gain hands-on experience writing Python code, working with data structures, and using libraries to solve real-world problems. By the end of the course, you'll be confident in your ability to write Python programs, automate tasks, and tackle challenges in various domains.

Baia
Python & Django Development – From Beginner to Web App Developer
🚀 Learn Python and Django to Build Powerful Applications 🚀 Want to master Python and develop real-world web applications with Django? Whether you're a beginner or looking to enhance your coding skills, this course will guide you step by step! What You’ll Learn: ✅ Python Basics & Advanced Concepts – Learn syntax, data structures, OOP, and algorithms ✅ Django Framework – Build dynamic and scalable web applications ✅ Databases & APIs – Work with PostgreSQL, SQLite, and REST APIs ✅ Project-Based Learning – Apply concepts through hands-on coding and real projects ✅ Debugging & Best Practices – Learn clean coding principles and error handling 🔹 Who is this course for? Complete beginners who want to start coding with Python Developers looking to transition into backend or full-stack development Students and professionals who want to build their own web applications 💻 Class Format: - Live online sessions via Google Meet - Interactive coding exercises & projects - Personalized guidance based on your level 📩 Contact me to start your Python & Django journey today!

Oussama
Python Programming for All Levels: From Fundamentals to Advanced Libraries and Frameworks
What You Will Learn: Core Principles: Introduction to programming, algorithms, and data structures to build a strong foundation. Advanced Libraries and Frameworks: NumPy, Pandas, and Django to create web applications and perform efficient data analysis. Practical Projects: Real-world applications to strengthen your skills and build an impressive portfolio. How You Will Benefit: Students: Gain the necessary skills to excel in academic projects and lay the groundwork for your career. Self-Taught Learners: Avoid common mistakes and fast-track your progress with clear, hands-on guidance. Professionals: Enhance your skill set to meet industry demands and open up new career opportunities. Why Choose My Courses?: Personalized Approach: Each course is customized to your level and learning pace, ensuring tailored guidance and support. Theory and Practice: You’ll combine theoretical concepts with hands-on exercises for a comprehensive and lasting understanding. Solving Real-World Problems: Learn how to tackle the common challenges faced in programming, from debugging to performance optimization.

Mohamed
Data Engineering & Science: Packaging Python Projects & deployment tools either on premise or on Cloud (Amazon AWS)
In this course, you will learn how to efficiently package, containerize, and deploy Python applications and microservices using Docker. The course covers fundamental Docker concepts, best practices for structuring Python projects, and strategies for building scalable and portable applications. Through hands-on projects, you will gain practical experience in creating Docker images, managing containers, and orchestrating microservices, enabling seamless deployment across different environments. Contact me if you want to have more information about the course!

Rony
Master Microsoft Word, Excel and Powerpoint: Transform From a Beginner to a Pro!
Microsoft Office is the most essential toolset for students, professionals, and anyone looking to improve their productivity. This beginner-friendly course will teach you the key skills needed to confidently use Microsoft Word, Excel, and PowerPoint for personal, academic, and professional tasks. In this course, you will learn how to: ✅ Microsoft Word – Create, format, and edit professional documents with ease ✅ Microsoft Excel – Organize data, use formulas, and create charts for better analysis ✅ Microsoft PowerPoint – Design stunning presentations with animations and transitions ✅ Use shortcuts and best practices to work more efficiently ✅ Collaborate with others using sharing and review features By the end of this course, you’ll have the skills to create polished documents, manage data effectively, and deliver engaging presentations. No prior experience is needed—just a desire to learn!

Marwin
Skilled Mathematics Coaching: Year 6 - GCSE/A-Levels Students
Mathematics: I am a skilled mathematics teacher with strong academic qualifications. Additionally, I can help your ward to learn Python Programming Language which could help to bridge the gap between industry and academics from a very young age. Grade: Year 6 to GCSE/A-Levels UG Degree & Grade: 93.07% in B.Sc. (Hons) Mathematics from the University of Delhi PG Degree & Grade: Distinction in MSc in Data Science from The London School of Economics and Political Science

Brahim
Introduction to Relational Database and SQL Language by practise
Module 1: SQL Overview Outlining SQL as the cornerstone of database activity Applying the ANSI/ISO standards Describing the fundamental building blocks: tables, columns, primary keys, and foreign keys Module 2: Building the Database Schema - Creating tables and columns Building tables with CREATE TABLE Modifying table structure with ALTER TABLE Adding columns to an existing table Removing tables with DROP TABLE - Protecting data integrity with constraints Guaranteeing uniqueness with primary key constraints Enforcing integrity with foreign key constraints Imposing business rules with check constraints - Improving performance with indexes Expediting data retrieval with indexes Recommending guidelines for index creation Module 3: Manipulating Data - Modifying table contents Adding table rows with INSERT Changing row content with UPDATE Removing rows with DELETE - Applying transactions Controlling transactions with COMMIT and ROLLBACK Deploying BEGIN TRANSACTION in SQL Server Module 4: Working with the SELECT Statement - Writing Single Table queries Retrieving data with SELECT Specifying column expressions Sorting the result with ORDER BY Handling NULL values in expressions - Restricting rows with the WHERE filter Testing for equality or inequality Applying wildcard characters Avoiding NULL value pitfalls Module 5: Querying Multiple Tables - Applying the ANSI/ISO standard join syntax Matching related rows with INNER JOIN Including nonmatched rows with OUTER JOIN Creating a Cartesian product with CROSS JOIN - Combining results with set operators Stacking results with UNION Identifying matching rows with INTERSECT Utilizing EXCEPT to find nonmatching rows Module 6: Employing Functions in Data Retrieval - Processing data with row functions Conditional formatting with the CASE expression Utilizing the CASE expression to simulate IF tests Dealing with NULL values - Performing analysis with aggregate functions Summarizing data using SUM, AVG and COUNT Finding the highest/lowest values with MAX and MIN Defining the summary level with GROUP BY Applying filter conditions with HAVING Module 7: Constructing Nested Queries - Applying subqueries in filter conditions Creating correlated vs. noncorrelated subqueries Testing the existence of rows - Including subqueries in expressions Placing subqueries in the column list Creating complex expressions containing subqueries Handling subqueries that return no rows Module 8: Developing In-Line and Stored Views - Breaking down complex problems Selecting data from a query result set Using subqueries in the FROM clause - Creating views in a database Building reusable code Creating updateable vs. non-updateable views

Anass
Computer and office training Word Excel and PowerPoint
Hello, You want to learn the basics of computers or how to use software such as Word, Excel or Powerpoint. I will give you the skills you need to better understand the features of this software to write, for example, a document. I will also give you advice on how to make the most of the internet, protect and back up your data, or on the day-to-day use of your computer. Contact me.

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

Juan Manuel Carrillo
Python, Physics and Maths tutor - MSc. Physics student at DTU
I am a recent master's graduate in Engineering Physics at DTU. I hold a GPA of 10 and have graduated from my bachelor's in Paris with honours. I am experienced in applied physics, theoretical maths and use python on a daily basis, especially in the field of advanced image analysis. I have experience tutoring students in mathematics and physics and currently I am a Teacher Assistant in a master's course at DTU, about deep learning applications to data analysis. If you're struggling with homework, preparation for an exam or want to learn how to code to add that skill on your CV then I can help you! My strategy to teach is always to give simple examples that relate to our common intuition and build upon these to understand complex concepts. Reach me out to inform me of your needs and discuss the best strategy for you!

Dishant
Python, C, C++, Java Programming Classes 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.

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.

Elmehdi
I'm a developer coach with over 10 years of experience in website and database development. Titolay
I'm a developer coach with over 10 years of experience in website and database development. Holding a professional license and several industry-recognized certifications, he is a MySQL expert and able to walk you through the most complex requests. As a coordinated and passionate website builder, I am able to share my knowledge and experience with over 100's of people to help achieve their development goals. Many renewable projects are experienced and able to deliver high quality results. If you are looking for a talented developer coach to help you with your MySQL demands, please feel free to contact me.”

Mazuba
Introduction to Programming with Python Programming Language.
Learn programming fundamentals with Python, a beginner-friendly and versatile language. This class will guide you through the essentials of coding, building problem-solving skills, and understanding how programs work behind the scenes. Note: Students are encouraged to suggest specific topics or areas of interest they would like to focus on during the course. What You’ll Learn: Python basics: Syntax, variables, and control flow (if-else, loops). Understanding IDEs: Setting up and working with Python IDEs. Execution process: Interpreters, compilers, and how Python executes code. Introduction to modular programming with functions.