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:

I. 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

II. 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

IV. 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

V. 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