Learn the essential tools of a data analyst — transform, query, and visualize data using Excel, SQL, and Tableau, and build a real analytics portfolio.
Data Analytics Essentials teaches you the fundamental tools of a data analyst. You will learn to transform, organize, and visualize data using spreadsheet tools such as Microsoft Excel, query data from relational databases using SQL, and improve your data presentations using powerful business intelligence tools like Tableau. The course uses a hands-on approach throughout — including lab activities, interactive exercises, and real-world datasets. By the end, you will have built an analytics portfolio featuring a complete analysis of the popular movies dataset, showcasing your practical skills in Excel, SQL, and Tableau. No prior experience is required.
Curriculum Chapters
- 1. Data Analytics Projects
- 2. Getting Started with Data Gathering and Investigation
- 3. Preparing and Cleaning Data for Analysis
- 4. Transforming Data with Excel
- 5. Analyze the Data Using Statistics
- 6. Introduction to Relational Databases and SQL
- 7. Introduction to Structured Queries
- 8. Introduction to Tableau
- 9. Ethics and Bias in Data
- 10. Take the Next Steps
Skills You Will Learn
Explain how data analytics projects are organized and managed. Perform initial data gathering and investigation using a spreadsheet. Use Excel functions and formulas to prepare, clean, and transform data for analysis. Perform statistical analysis on data including basic descriptive statistics. Write structured SQL queries to extract and combine data from multiple relational database tables. Build visual data presentations using Tableau. Understand ethical considerations and bias in data including data privacy and cybersecurity principles. Create and present a data analytics portfolio using real-world datasets. Set up a GitHub repository to share your work and build an online presence.
Technologies Used
Microsoft Excel
SQL (Relational Databases)
Tableau
GitHub
Course Details
Course Type: Free self-paced
Time: 30 Hours
Modules: 10
Labs: 29 hands-on lab activities & interactive exercises
Prerequisites
None. Completing Introduction to Data Science first is recommended for beginners.
Certification & Career
Career and Certification alignment: This course is part of Cisco Networking Academy’s Data Science learning portfolio and supports entry-level roles such as Data Analyst and Business Intelligence Analyst. There are no target certifications for this course. Learners are encouraged to continue with more advanced data science or programming courses upon completion.
Achievements & Badges
Upon completion, earn a Cisco Networking Academy digital badge. Share your verified achievement on LinkedIn, your CV, or professional profile.
What Cisco verifies: Cisco verifies the earner of this badge successfully completed the Data Analytics Essentials course. The holder of this student-level credential has a broad understanding of how the data analytics process creates value from data, can explain characteristics of data including formats, availability, and methods to acquire it, can transform and analyze data using basic statistical and data preparation techniques, and has completed hands-on activities using Excel, SQL, Tableau, and other tools.
Ready to Start This Course?
This course is delivered through Cisco Networking Academy — the official global learning platform. To enroll, click the button and you will be taken to the official course page on netacad.com. If you already have a Cisco Networking Academy account, simply log in and click Get Started. If you are new to the platform, creating a free account takes less than a minute. Enrollment is completely free.
You will be redirected to netacad.com.
A free account is required to enroll.