Data Analytics & Data Science
Data Analytics & Data Science Course
Course Outcomes
- Understand business requirements and convert them into analytical problem statements.
- Analyze large datasets using Excel functions and formulas.
- Create Pivot Tables, Pivot Charts, and KPI reports.
- Process and manipulate datasets efficiently using Python.
- Work with data structures, file handling, and object-oriented programming.
- Use NumPy and Pandas for data manipulation and analysis.
- Present analytical findings through charts, graphs, and reports.
- Extract, filter, and analyze business data using SQL.
- Write advanced SQL queries for data extraction, transformation, reporting, and analysis.
- Evaluate and optimize machine learning models for business applications.
- Develop interactive dashboards and reports using Power BI.
- Perform advanced analytics using joins, aggregations, and window functions.
- Create data models and relationships.
Curriculum
- Data Fundamentals & Analytics Foundations
- Excel for Data Analysis
- Python Programming Essentials
- Python Data Structures
- Python for Data Analysis
- Machine Learning for Business Analytics
- SQL for Data Analysis
- Power BI for Business Intelligence
- Capstone Projects
tools & technologies
- Microsoft Excel
- Python
- NumPy
- Pandas
- Power BI
- MySQL
- Matplotlib
- Jupyter Notebook