Data Analysis

Description
This course provides comprehensive training in data analysis tools and techniques, covering Python, Excel, SQL, and Power BI for effective data-driven decision-making.
Course Content
• 120h total length
What is Data Analysis?
Steps in the data analysis process
Key competencies and mindset of a data analyst
Python fundamentals
Descriptive statistics basics
Pandas, NumPy, Matplotlib, Seaborn
Data visualization with Python
Excel basics & functions
Pivot tables & charts
Power Query
Power Pivot & data modeling
Database lifecycle & design
SQL concepts & commands
Joins, subqueries, aggregate functions
Permissions & security
Power BI environment
Data import & cleaning
Creating reports & dashboards
DAX formulas
Complex data models
Advanced visualizations
Publishing & sharing dashboards
Linux System Administration Course