Data Management

0/0 Ratings

CIS branches across Lebanon and online

$ Price $650.00

Delivery type On-Campus or Online

Capacity Unlimited

Level All levels

Duration 30 Hours

Lessons 7

Enroll WhatsApp Us

Overview

This course walks you through the complete life of data: how it is collected, cleaned, stored, and turned into insight. You will study the fundamentals of data science, learn how to build a solid data collection plan, and practice cleaning and validating real datasets. From there, you will move into analysis, working with SQL, pivot tables, and Excel to summarize data and build presentation-ready dashboards, before finishing with an introduction to big data concepts.

The course runs 30 hours and is built around real case studies and hands-on practice, so you leave able to work with data confidently in a professional setting.

What You Will Learn

Explain core data science concepts, including data types and variables such as nominal, ordinal, and ratio
Build a data collection plan and choose appropriate collection methods and sample sizes
Clean and validate datasets, including handling missing values and outliers
Describe common data storage methods, including data lakes and cloud storage
Apply descriptive, diagnostic, and predictive analysis techniques using SQL
Build and use pivot tables to filter, group, and summarize data
Create presentation-ready dashboards and reports in Excel
Describe the basics of big data, including storage, clustering, and processing challenges

Course Curriculum

Module	What you cover
Introduction to Data Science	Data science fundamentals, structured versus unstructured data, and studying variables
Data Collection Techniques and Preparation	Building a data collection plan, choosing methods and sample sizes, and using ETL tools
Data Cleaning and Validation	Handling missing values, outliers, normalization, and building mineable datasets
Data Storage and Protection	Storage essentials, data lakes, storage virtualization, and cloud storage
Data Analysis with SQL	Descriptive, diagnostic, and predictive analytics, the data analysis process, and an introduction to SQL and probability
Data Analysis with Pivot Tables and Excel	Building and formatting pivot tables, applying formulas, and creating presentation-ready dashboards and charts
Big Data and Professional Skills	Big data storage and processing challenges, plus communication, marketing, and financial planning skills for freelancers