Mastering Data Analytics: In Python, SQL & Power BI

Why this Course:

Data Analyst roles are high in demand across industries owing to the fact that companies increasingly rely on the Data-Driven insights in their decision-making processes. Similar is the case with R & D organizations also, where researchers have to analyse huge amount of Data for drawing meaningful conclusions. Python, SQL and Power BI are the three very widely used tools across industries in Data Analytics applications. Therefore, this course is designed to make the participants efficient in using these three Data Analytics tools and thus helping them to enhance their skillsets & employability.

What you will learn?

Data Analytics with Python Programming
Starting from the fundamentals of Python Programming, we shall dive into the applications of Python libraries in the processes like Data Wrangling & Data Exploration taking real-world Datasets. Also, We will discuss Data Visualization & Data Interpretation using Matplotlib & Seaborn libraries. There will be a Capstone Project with real-world datasets.
Database Management with SQL
We shall start from understanding the basics of Databases & DBMS, and their role in Data Organization. Then, from installation & setup of MySQL and discussing its applications in working with Databases, we will dive into the important processes like Data Manipulation & Data Optimization using SQL, taking Databases from real-world applications.
Working with Power BI
Starting from Power BI basics like its components and architecture, we will discuss its applications in Data visualization. We shall learn the use of Power BI in creating coherent, visually impressive and interactive insights from disparate Data sets.

Course Objectives:
• Introducing the participants to the world of Data Analytics and its enormous career prospects.
• Enabling participants to learn the Fundamentals of Python Programming and its applications in Data Analytics.
• To make the participants understand the fundamentals of SQL and concepts related to its application in the world of Databases.
• To enable the participants to work with real-world databases and efficiently perform operations like Data manipulation & Data Optimization using SQL.
• To enable the participants to use Power BI for creating meaningful and visually attractive insights to make effective Data-driven decisions.

Batch Details:

Class Timings: 7:00 pm – 9:00 pm (Mon-Wed-Friday)
Start Date: 20th Jan 2025
Duration: 64 Hours
End Date: 31st March 2025
Mode: Online
Certification: iHUB Divyasampark IIT Roorkee
Last Date to Register: 19th Jan 2025

Course Fee:
Students/PhD Scholars/RA/JRF/SRF/Postdoc fellows: Rs. 6500/-
Faculty/Working Professional: Rs. 8500/- (Amounts inclusive of GST)


Link to Register :-           https://rzp.io/rzp/MasteringDataAnalytics


Course Overview

Module 1
Python Fundamentals - Basics of Python Language -Python objects with details of numbers/lists/dictionaries/variables etc. -Comparison operators, Range, List Comprehension, -Attributes and Functions, Lambda expressions etc. -Object Oriented Programming - Introduction to NumPy - Random Functions, Reshape, Arithmetic operations, Data Manipulation

Module 2
Data Wrangling & Exploration
-Introduction to Pandas
-Series, DataFrames, working with various data types, Group-By operation
-Indexing & sorting, Handling Null Values
-loc & iloc with series, Built-in and Universal methods
-Inspecting DataFrames, filtering with conditional operators, Lambda, Map and Filter operations.
-Manipulating columns; updating values; working with date & time

Module 3
Data Visualization & Projects
-Introduction to Matplotlib Library
-Working with different plots with Matplotlib Library
-Functional and Object-Oriented plotting method
-Introduction to Seaborn Library
-Working with Seaborn library for data interpretation
- Capstone Projects with real world datasets.

Module 4
Introduction to Databases & SQL
-Introduction to DBMS and their role in data organization.
-Exploring various types of DBMS architectures.
-Understanding the ACID properties and their importance in database transactions.
-Installation and setup of MySQL.
-Introduction to SQL and its subsets: DDL, DML, DQL, DCL, TCL.
-Creating, dropping, and managing databases.

Module 5
Data Manipulation with SQL
Understanding basic data types and table structures.
-Implementing primary keys, auto-increment, and constraints.
-Comprehensive coverage of CRUD operations: Create, Read, Update, Delete.
-Mastering SELECT statements with various clauses: WHERE, GROUP BY, HAVING, ORDER BY, LIMIT.
-Utilizing string functions for data manipulation and transformation.

Module 6
Data Optimization with SQL
-Data Analysis using Aggregation functions
-Utilizing Ranking Functions
-Exploring advanced SQL features like UNIQUE constraints, adding/dropping columns, and column modifications.
-Understanding complex query operations using comparison & logical operators, and CASE statements. Optimization techniques for improving query performance and database efficiency.
-Capstone Project

Module 7
Power BI Basics
-Introduction, Components and Architecture of Power BI
-Visualizations, Reports, Dashboards, Tiles, Power BI vs Tableau.
-Basic Transformations, Text tools, Unwanted Columns, Null Values, Numerical Tools, Date and Time.
-Conditional Columns, Merge and Append Queries.

Module 8
Working with Power BI
-Pivoting and Unpivoting of Data, Data Modeling and Relationships, Cardinality and Cross-Filter.
- DAX: Syntax, Operators, Functions: Date and Time, Text, Logical
- Power BI charts: Bar, Column, Line, Area, Combination, Pie, Doughnuts, Maps, Funnels etc.
- Power BI KPIs, Tree maps, tool tips, Dashboard and Reports
- Hands-on projects using Power BI



Contact Person: Dr. Subrat Kotoky
CTO, Ritvij Bharat Pvt. Ltd. (RBPL)
Ph.D. in Mechanical Engineering (IIT Guwahati)
rbpl.edu@gmail.com/subrat.kotoky@ritvij.co.in
9085317465/8473874389

Expert Profile: Mr. Shreyas Shukla
Professional Corporate Trainer & Microsoft Azure Certified Data Engineer M.Tech-IIT Kharagpur & BE- The Aeronautical Society of India, New Delhi
Has successfully conducted 15+ courses and trained 800+ learners in the fields of Python Programming, Data Analytics, Machine Learning, Deep Learning, Computer Vision etc. till now.

Certifications:
1. DP-203: Microsoft Certified: Azure Data Engineer Associate
2. DP-900: Microsoft Certified: Azure Data Fundamentals
3. AZ-900: Microsoft Certified: Azure Fundamentals