This comprehensive course equips students with essential skills in three powerful data analysis and visualization tools: SQL,Power BI, Python, Advanced Excel and SAS. The program is offered by the department in collaboration with Techolas Technologies, a leading IT enhancement institution in Kerala, with extensive experience in providing advanced expertise that aligns with current career paths. 

Aim of the course:

To equip students with hands-on experience in data analysis, visualization, and management using industry-leading tools and technologies. By covering Python, SQL, Advanced Excel, Power BI, and SAS, students will gain a broad range of skills in data manipulation, analysis, and visualization, enabling them to make informed decisions.

Objectives of the course

1. Develop Proficiency in Data Analysis Tools: Equip students with hands-on experience in using popular data analysis tools like Python, SQL, Advanced Excel, Power BI, and SAS.
2. Enhance Data Visualization and Interpretation Skills: Enable students to effectively visualize and interpret complex data using various tools and techniques.
3. Build Strong Foundation in Programming and Data Management: Provide students with a solid understanding of programming concepts, data types, and data management techniques using Python, SQL, and SAS.
4. Foster Data-Driven Decision Making: Empower students to make informed decisions by analyzing and interpreting data, identifying trends, and creating predictive models using various data analysis tools.
5. Prepare Students for Real-World Data Analysis Challenges: Equip students with practical skills and knowledge to tackle real-world data analysis challenges, making them industry-ready professionals in data analysis and science.

Beneficiaries: Intended for PG & UG final year students

Course Curriculum:

1. PYTHON
   o Python and installation
   o Introduction to pycharm
   o Variable in python
   o List, Tuple, Set, Dictionary
   o Data types in Python, operators
   o If, If else, If elif
   o Loop in python For, While
   o Loop control statement Break, Continue, Pass
   o Functions in python
   o anonymous functions
   o Object oriented programming
   o Class and objects, Init method
   o Inheritance
2. SQL
   o Introduction to relation databases
   o Installation of mysql workbench
   o Database creation- Create, Show, Use
   o Table creation- Create, Alter, Update, Select
   o Clauses- Where, Group by, Having, like
   o Primary key, Foreign key
   o Not null
   o Joins- Inner join, Left join, Right join, Outer join

III. ADVANCED EXCEL
o Advanced Excel-Basic
o Spreadsheet concepts
o Worksheets
o Conditional Formatting
o Advanced Excel-Sorting and Filtering Data Sorting Tables
o Specifying a valid range of values for a cell
o Advanced Excel- Text Function-Upper, Lower, Proper
o Left, Mid, Right, Trim, Len, Exact, Concatenate
o Basic Function – Sum, Average, Max, Min, Count,
o Logical Functions (AND, OR, NOT)
o Mathematical Functions
o Advanced Excel -Pivot Tables
o Excel – Charts &Slicers
o Using Charts, Formatting Charts, Dashboard

1. POWER Bi
   o Introduction to DAX Measures
   o DAX Measures Practical Activity Relationships
   o Creating and managing Relationships in Power Bl
   o Relationship Calculations
   o Power BI Query Editor
   o Aggregating Data, Dashboard
2. SAS
   o Introduction to SAS Programs
   o SAS Data types and Libraries
   o Data and Proc Steps
   o Output Delivery System (0DS)
   o Reading Raw Data – Column Input
   o Understanding data step processing
   o Reading date and time format
   o Creation of raw data file from a Dataset
   o Managing variables in dataset
   o If else, If else with do statement, Select When, Do loop statement
   o Managing SAS dataset using set statement
   o SAS functions Overview
   o String Functions
   o Date Functions
   o Mathematical Functions
   o Combining data set – one to one reading, concatenation and merge
   o Array – single and multidimensional array