Duration 3 days – 21 hrs
Overview
This beginner-level training course introduces participants to the foundational concepts of data analytics. Designed for professionals with little to no background in data analysis, the course covers essential tools, techniques, and processes used in analyzing data to support decision-making. Participants will gain hands-on experience using Excel and introductory business intelligence tools to clean, visualize, and interpret data. By the end of the course, learners will be equipped with the skills needed to understand and apply basic data analytics in their respective roles or industries.
Objectives
- Understand the role and importance of data analytics in business decision-making.
- Identify different types of data and analytics (descriptive, diagnostic, predictive).
- Apply Excel tools for data sorting, filtering, and basic analysis.
- Perform basic data cleaning and transformation.
- Create and interpret charts, graphs, and dashboards.
- Use basic functions of a BI tool to generate visual reports.
- Develop confidence in making data-driven insights and presentations.
Audience
- Entry-level professionals interested in data analysis
- Administrative and operations staff
- Business professionals seeking to make data-informed decisions
- Entrepreneurs and startup founders
- Students and fresh graduates in business, IT, or related fields
Pre-requisites
- Basic computer literacy
- Familiarity with Microsoft Excel (basic navigation) is an advantage but not required
- No prior experience in data analytics needed
Course Content
Day 1: Introduction to Data Analytics and Excel Fundamentals
- What is Data Analytics?
- Importance of Data-Driven Decision Making
- Types of Analytics: Descriptive, Diagnostic, Predictive, Prescriptive
- Overview of Data Analytics Lifecycle
- Excel Fundamentals for Analysis
- Sorting, Filtering, and Conditional Formatting
- Basic Formulas and Functions (SUM, AVERAGE, IF, VLOOKUP, COUNTIF)
Day 2: Data Cleaning and Visualization Techniques
- Understanding Data Quality and Data Types
- Data Cleaning Techniques in Excel
- Removing Duplicates, Handling Missing Values
- Text-to-Columns, Flash Fill, Find and Replace
- Introduction to Data Visualization
- Chart Types: Bar, Line, Pie, Column
- Creating and Formatting Charts
- Introduction to Pivot Tables
- Creating Pivot Tables and Pivot Charts
- Analyzing Data Using Pivot Features
Day 3: Introduction to Business Intelligence Tools (Optional Tools: Power BI or Google Data Studio)
- What is Business Intelligence (BI)?
- Connecting Data to BI Tools
- Building Simple Dashboards
- Visualizing Data with Charts and Filters
- Publishing and Sharing Reports
- Capstone Mini-Project: Create a Basic Dashboard
