logo
  • Home
  • Courses
  • Expert Series
  • News
  • Events
logo
  • Home
  • Courses
  • Expert Series
  • News
  • Events
  • About Us

Loading...

Data Analytics Essentials

instructor-img

Instructor

GP Academy

‎

Category

Cisco Series

This data analytics essentials course teaches you the fundamental tools of a data analyst. You will learn to transform, organize, and visualize data with spreadsheet tools such as Excel. You will also learn how to query data from a relational database using SQL and how to improve your data presentations using powerful business intelligence tools like Tableau. By the end of the course, you will have an analytics portfolio complete with an analysis of the popular movies dataset, showcasing your skills in Excel, SQL and Tableau

Course Info

  • |
    Data Analytics Essentials
  • |
    0 sec
  • |
    52 Lessons
  • |
    456 Students

Latest Courses

Recent Courses

Recent Events

Recent News

  • For any inquiry, feedback, or assistance, feel free to reach out

Copyright ©2025 Grameenphone Academy. All Rights Reserved

  • About Us
  • Privacy Policy
  • Courses
  • FAQ

Curriculum

Course Final Exam

Analytics in Real Time

Data Analytics in Action

The Project Portfolio

Data Analytic Projects Summary

Introduction

Introduction

Tools for Data Understanding

Basic Excel Concepts and Features

Use Simple Functions for Data Analysis

Starting The Process Summary

Unstructured Data

Introduction

Sources of Data

Data in Structured Files

Data Preparation

Preparing and Cleaning Data for Analysis Summary

Introduction

Sorting and Filtering Data with Excel

Formatting and Adjusting Data

Data Calculations

Transforming Data with Excel Summary

Analyze the Data Using Statistics Summary

Using Excel to Address Issues with Data

Introduction

Using Statistics to Interpret Data

Choosing the Right Visualization for the Job

Creating Visualizations with Excel

Addressing Anomalies in Data

Introduction

Basic Data Management

SQL

Introductional to Relational Databases and SQL

Introduction

Relational Database Structures

Using SQL with Multiple Tables

Combining SQL Functions to Extract Data

Mangement Features of SQL and Alternatives

Introduction to Structured Queries Summary

Introducing Tableau

Introduction

Create Visualizations in Tableau

Tableau Dashboards

Introduction to Tableau Summary

Introduction

Bias in Data Analysis

Ethical Use of Data

Ethics and Bias in Data Summary

Introduction

Requirements for a Portfolio

Expanding your Analytics Skills

Take the Next Steps Summary

  • news-img
    Session on UI/UX Portfolio Mistakes

    07 Aug 2025

  • news-img
    GP Academy Digital Skills Quiz is here!

    14 Aug 2025

  • news-img
    Freelancing Factory Receives Honorabl...

    29 Jul 2025

  • news-img
    GP Academy Quiz Winners

    28 Jul 2025

  • latest-course-img

    Business Analytics with Power BI

    17 Aug 2025

  • latest-course-img

    Career with AI

    28 Jul 2025

  • latest-course-img

    Sharpen Your Interview Skills

    30 Jun 2025

  • course-img
    Business Analytics with Power BI

    17 Aug 2025

  • course-img
    Career with AI

    28 Jul 2025