Data Science
Launch your career in Data Analytics with Infidata Technologies! Our 12-week professional training covers essential tools including Excel, SQL, Power BI, and Python. Learn through hands-on projects, real-world scenarios, and build your portfolio to stand out.
Pre Requisites: Basic Computer Skills
Course Objective
- Understand Data Analytics and its applications
- Learn to connect to various data sources (e.g., Excel, SQL databases) and use Power Query Editor to clean, transform, and prepare data for analysis.
- Be able to analyze large data sets to support data-driven decision making
- Analyzing datasets, identifying patterns, and using those insights to make predictions, understand past behavior, and optimize processes.
- Able to import, transform, and model data; create interactive reports and dashboards; and publish them for sharing and collaboration
Syllbus
- Data Science Overview
- Basic & Advanced Formulas
- Pivot Tables & Charts
- Data Cleaning Techniques
- Dashboards & Reporting
- Introduction to Python and its usage in the industry
- Introduction to Anaconda
- Installation of Anaconda Python Distribution
- Jupyter Notebook Installation
- Jupyter Notebook Introduction
- Variable Assignment
- Basic Data Types: Integer, Float, String, None, and Boolean; Typecasting
- Creating, accessing, and slicing tuples
- Creating, accessing, and slicing lists
- Creating, viewing, accessing, and modifying dicts
- Creating and using operations on sets
- Basic Operators: 'in', '+', '*'
- Functions
- Lambda functions
- Numpy,Pandas
- Relational Databases Basics
- SELECT, JOIN, GROUP BY, HAVING
- Subqueries, Views & Indexing
- Real-World SQL Projects
- Dashboards & Reporting
- Data Import & Transformation
- Data Modeling & DAX
- Interactive Dashboards
- Reporting Publishing
- Introduction to Data Visualization
- Processes in Data Science
- Data Wrangling, Data Exploration, and Model Selection
- Exploratory Data Analysis or EDA
- Data Visualization
- Plotting
- Hypothesis Building and Testing
Finally: time to do the project and take online assesment test
Assesment Details
- -Online Test (MCQ) : 50 marks
- - Weekly Assesment:20 Marks
- - Project Work : 30 marks
Certificate Sample
