Course Details
Data Analyst
Course Overview
A data analyst course typically provides an overview ot the tools and techniques needed to collect,clean, analyze, and visualize data to extract meaningful sights,focusing on key skills like SQL for database querying, statistical analysis using R or Python, data visualization with tools like Tableau, and Excel proficiency, ultimately preparing students to interpret data and communicate findings to inform business decisions.
Course lessons
- Overview of Data Analyst
- Introduction to Python
- Basic of Python
- Numpy
- Pandas
- Matplotlib
- Seaborn
- Plotly
- Introduction
- Database
- Tables
- Select Query
- Insert Data
- Alter Table
- Delete Table
- Update table
- Constraints
- Aggregrate Functions
- Joins
- Subquery
- Introduction
- What is Spreadsheets
- All Basic Formula
- Error handling
- Lookup Function
- Vlookup Function
- Hlookup Function
- Xlookup Function
- Pivot Table
- Pivot Charts
- All Charts
- Create Dashboard
- Introduction
- Downloads & Installing
- Import Data
- Creating a Graph
- Table
- Matrix
- Slicers
- Cards
- Create a PowerBi Account
- Scroller
- More Visual Charts
- Publish Report
Our Newsletter
© 2022 H&B Computer Education