Data Analytics
Beginner-friendly course that teaches how to collect, clean, analyze, visualize, and use data to make practical decisions using Excel, Google Sheets, and Power BI.
See what you will learn
About this course
Course overview
This introductory Data Analytics course gives adult learners and early-career professionals practical, hands-on skills to work with real data and make informed decisions. Starting from core concepts and data types, the course progresses through spreadsheet techniques for cleaning and summarizing data, and finishes with visualization and a real-world case study using Power BI. No coding or advanced math required — lessons focus on step-by-step tools and observable skills you can apply immediately.
Who this course is for
Adult learners and early-career professionals with little or no prior experience in data who want practical skills to analyze business or personal data, create visual reports, and make evidence-based decisions.
What you will learn
- Define core data analytics terms and distinguish common data types
- Clean and organize raw data in spreadsheets to prepare it for analysis
- Use essential formulas and summary tools (SUM, AVERAGE, COUNT, IF, pivot tables) to aggregate data
- Create clear charts and visualizations to reveal patterns and trends
- Build a simple interactive dashboard in Power BI from a spreadsheet
- Interpret analysis results and make concise, actionable recommendations while applying basic ethical and privacy considerations
Prerequisites
- Basic computer literacy (file management, web browsing, downloading/uploading files)
- Access to Microsoft Excel (desktop or web) and a Google account for Google Sheets
- Willingness to practice with sample datasets; no prior data or programming experience required
Level: Beginner