Data Analytics Course
Overview
A Data Analytics course at Cloud Institution equips learners with the essential skills needed to gather, clean, analyze, and visualize data to drive data-driven decisions. The course covers key areas such as data wrangling with tools like Excel, Python, and SQL, as well as creating impactful visualizations using Tableau and Power BI. Students will also dive into statistical analysis techniques, including hypothesis testing, probability theory, and regression. The curriculum includes exploratory data analysis, clustering, and classification techniques, alongside an introduction to machine learning and predictive analytics. With a strong focus on SQL for managing and querying databases, this course provides a well-rounded foundation, preparing participants to become proficient data analysts who can transform raw data into actionable insights.
What You will Learn?
- Fundamentals of Data Analytics
- Data Collection and Cleaning
- Statistical Analysis
- Data Visualization
Data Analytics Course Syllabus
Introduction Referencing, Named ranges, Uses, Arithmetic Functions Logical functions Referring data from different tables: Various types of Lookup, Nested IF Advanced functions Date and Text Functions Date and Text Functions Data Handling: Data cleaning, Data type identification,Remove Duplicates, Formatting and Filtering Data Visualization: Conditional formatting, Charts Data Summarization: Pivot Report and Charts Data Summarization: Dashboard Creation, Tips and Tricks Data Summarization: Dashboard Creation, Tips and Tricks Connecting to Data: Power query, pivot, power pivot within Excel VBA and Macros
Introduction to SQLIntroduction to Databases and RDBMSInstallation of Database
SQL Syntax
SQL Datatypes
SQL Operators
SQL DDL
SQL DCL
SQL Functions
SQL Clause
SQL Joins
SQL Queries and Subqueries, SQL Views
Introduction to Tableau
Basic Charts & Formatting
Filters
Calculations
Data Combining Techniques
Custom Charts
Groups, Bins, Hierarchies, Sets, Parameters
Analytics & Dashboard
Dashboard Actions & Tableau Public
Power BI Introduction and Installation
The Power BI user interface, including types of data sources
and visualizations
Sample dashboard with Animation Visual
Power BI Artificial Intelligence Visual
Power BI Visualization
Power Query Editor
Modelling with Power BI
Power Query Editor Filter Data
Customize the data in Power BI
Customize the data in Power BI
Dax Expressions
Custom Visual
Power BI Service
Introduction to R, Installation of R Studio, Data types in R
Decision Making Statements, Loops, Functions
Built in Functions in R, Joins, dplyr and ggplot2
- Python Features
- Python History
- Python example
- Python Variables
- Python Data Types
- Python Keywords
- Python Literals
- Python operators
- Python comments
- Python if else
- Python For Loop
- Python While Loop
- Python Break and Continue
- Python pass
- Python Strings
- Python Lists
- Python Tuples
- Python Sets
- Python Dictionary
- Python Functions
- Python lambda Functions
- Python file handling
- Python modules
- Python Exception
- Python date
- Python Regex
- Python Array
- Python oops
- Python Class and object
- Python Constructor
- Python Inheritance
- Python MySQL
- Database Connection
- Creating New database
- Creating tables
- Insert operation
- Read operation