Course Description
Want to make sense of all the data around us? This Data Analysis course is your guide! You’ll learn to work with Python, SQL, and Excel to clean and analyze data. Then, bring it to life with interactive dashboards in Power BI and Tableau. By the end, you’ll be able to spot trends, solve real-world problems, and tell compelling stories with data. Perfect for beginners and anyone looking to upskill.
Syllabus-
- Fundamentals of Data Analytics: Business Intelligence & Dashboards, Data Warehousing & Big Data, Data Science & Machine Learning, Artificial Intelligence, Types of Data, Data Analytics Project Lifecycle, Importance of Statistics.
- Python: Basics, Control Flow, Data Structures, Functions, OOP, File Handling, Modules
- DBMS & SQL: ER Modeling, Normalization, SELECT, Joins, Subqueries, DML/DDL
- Advanced Excel: Functions, Pivot Tables, Charts, Sorting & Filtering, Dashboards
- Power BI: Data Sources, Modelling, DAX, Visualizations, Dashboards, Custom Visuals
- Tableau: Data Connections, Charts, Calculated Fields, Groups, Parameters, Dashboards
Skills you’ll gain:
- Data cleaning & analysis like a pro
- Advanced Excel & spreadsheet wizardry
- SQL queries & Python programming for analytics
- Data visualization & storytelling with dashboards
- Analytical thinking for real-world business problems