Understanding data is central to smarter decision-making. This course introduces participants to core data analytics concepts, exploring how data transforms into insight using Excel. They will learn the full cycle from importing and cleaning data, to visualising results and interpreting dashboards.
Learning Outcomes:
Understand key concepts in data and analytics
Apply descriptive and predictive techniques in Excel
Clean and transform raw datasets
Create reports and dashboards for decision-making
Key Topics:
Basics of data and big data
Types of data analytics
Data transformation workflows
Excel pivot tables
Module 1. Basic concepts of Data
- Data vs. Information
- Big Data Buzz
- V’s of Data
- How to make Big Data actionable?
Module 2. Concepts of Data Analytics
- Basics of Data Analytics
- Types of Data Analytics
- Why Data Analytics
- Data Analytics and Business Users (Self-Service BI)
- Descriptive and Predictive Data Analytics with Excel
Module 3. Start the Data Analytics Process
- Choosing Data Analytics Platform
- Accessing Data
- Importing Data
- Cleaning and Transforming Data
- Presenting Results of Data Analytics – Reports and Dashboards
Module 4: Use Pivot Table and Power BI Desktop
- Table and Pivot Tables
- Filter Data with Slicers
- Introduction to Power BI Desktop
Module 5: Create the Data Visualizations
- Let the visualisation Do the Talking
- Explore Data visualisation with Cards, Tiles, Maps
- Export Report
