Janani K
Online
Skills
Power Bi Dashboard
Data Analysis
Data Visualization
Data Cleaning
Power BI
SQL
Advanced Excel
Mysql
Database Mysql
Database Management Systems (dbms)
Relational Databases (rdbms)
Database Design
Full Python
R & Python
R Programming/python
Python for Ml and Data Analysis
Object Oriented Programming with Python
Python Basics
Advanced Python Programming
Python Programming
core python
Seaborn
Sqlite
Matplotlib
Numpy, Pandas and Matplotlib
Statistical Analysis
About
Janani K is a dedicated tutor specializing in providing guidance to students in various subjects. With a strong educational background, Janani is committed to helping learners of a...
Janani K is a dedicated tutor specializing in providing guidance to students in various subjects. With a strong educational background, Janani is committed to helping learners of all ages, including students and professionals preparing for exams.QualificationsJanani holds a B.Tech / B.E. and an MBA, showcasing a solid foundation in technical and managerial fields.ExperienceWith a focus on student support, Janani has gained valuable teaching experience. Her approach emphasizes clarity and understanding, ensuring that each student feels guided throughout their learning journey.Teaching LanguagesJanani conducts lessons in English, making her accessible to a wide range of learners.Teaching ApproachJanani's lessons are structured to promote clarity and comprehension. She aims to foster a supportive learning environment where students can ask questions and engage deeply with the material. Her focus on understanding ensures that students grasp concepts effectively, preparing them for their exams or skill development.Why Students Should Learn From This TutorStudents will benefit from Janani's clear teaching style and structured lessons. Her commitment to supporting learners builds trust and encourages students to explore their subjects confidently. With a focus on clarity and understanding, Janani is well-equipped to guide students through their educational challenges.
Janani K
Online
Skills :
Power Bi Dashboard
Data Analysis
Data Visualization
Data Cleaning
Power BI
SQL
Advanced Excel
Mysql
Database Mysql
Database Management Systems (dbms)
Relational Databases (rdbms)
Database Design
Full Python
R & Python
R Programming/python
Python for Ml and Data Analysis
Object Oriented Programming with Python
Python Basics
Advanced Python Programming
Python Programming
core python
Seaborn
Sqlite
Matplotlib
Numpy, Pandas and Matplotlib
Statistical Analysis
Janani K is a dedicated tutor specializing in providing guidance to students in various subjects. With a strong educational background, Janani is committed to helping learners of a...
Janani K is a dedicated tutor specializing in providing guidance to students in various subjects. With a strong educational background, Janani is committed to helping learners of all ages, including students and professionals preparing for exams.QualificationsJanani holds a B.Tech / B.E. and an MBA, showcasing a solid foundation in technical and managerial fields.ExperienceWith a focus on student support, Janani has gained valuable teaching experience. Her approach emphasizes clarity and understanding, ensuring that each student feels guided throughout their learning journey.Teaching LanguagesJanani conducts lessons in English, making her accessible to a wide range of learners.Teaching ApproachJanani's lessons are structured to promote clarity and comprehension. She aims to foster a supportive learning environment where students can ask questions and engage deeply with the material. Her focus on understanding ensures that students grasp concepts effectively, preparing them for their exams or skill development.Why Students Should Learn From This TutorStudents will benefit from Janani's clear teaching style and structured lessons. Her commitment to supporting learners builds trust and encourages students to explore their subjects confidently. With a focus on clarity and understanding, Janani is well-equipped to guide students through their educational challenges.
FindMyGuru is a tutor discovery platform that helps students find and connect with experienced tutors and institutes across a wide range of subjects and skills. Students can explore tutor profiles, compare expertise, and contact tutors directly for online or in-person learning.FindMyGuru facilitates discovery and connections between students and tutors or institutes. All classes and learning arrangements are handled directly between students and the respective tutors or institutes
Courses by: Janani K
Python for Data Analytics by Janani K
Module 1: Python Fundamentals for Analytics
Topics
Introduction to Python & Data Analytics
Python Installation (Anaconda, Jupyter, VS Code)
Python Syntax & Program Structure
Variables, Data Types & Type Casting
Input / Output Operations
Operators in Python
Conditional Statements
Loops & Loop Control
Functions & Modules
Practical
✔ Basic scripts
✔ Data input programs
✔ Calculator & report generator
Module 2: Core Python for Data Handling
Topics
Strings & String Operations
Lists, Tuples, Sets & Dictionaries
Comprehensions
Built-in Functions (map, filter, reduce)
Exception Handling
File Handling (CSV, TXT, Excel basics)
Practical
✔ Data cleaning scripts
✔ File processing automation
Module 3: NumPy for Numerical Analysis
Topics
NumPy Arrays
Array Creation & Reshaping
Indexing & Slicing
Vectorized Operations
Mathematical & Statistical Functions
Broadcasting
Practical
✔ Matrix operations
✔ Performance comparison with Python lists
Module 4: Pandas for Data Analysis
Topics
Series & DataFrame
Importing Data (CSV, Excel, SQL, JSON)
Data Inspection & Cleaning
Handling Missing Values
Filtering, Sorting & Aggregation
GroupBy Operations
Merging & Joining DataFrames
Time Series Basics
Practical
✔ Sales dataset analysis
✔ Customer behavior analysis
✔ Data transformation workflows
Module 5: Data Visualization
Topics
Matplotlib Basics
Seaborn Visualizations
Line, Bar, Pie, Histogram, Boxplot
Heatmaps & Pairplots
Customizing charts
Dashboards (intro)
Practical
✔ Business performance dashboard
✔ Trend & comparison analysis
Module 6: Exploratory Data Analysis (EDA)
Topics
Descriptive Statistics
Correlation Analysis
Outlier Detection
Data Distribution & Patterns
Feature Understanding
Practical
✔ Complete EDA on real business dataset
✔ Generate EDA report
Module 7: SQL with Python
Topics
Python-MySQL / SQLite connectivity
Executing SQL queries using Python
Data extraction & loading
Data pipelines
Practical
✔ Sales database analysis project
Module 8: Business Analytics Case Studies
Case Studies
Sales Forecasting
Customer Segmentation
HR Attrition Analysis
Marketing Campaign Effectiveness
Inventory Demand Analysis
python Programming by Janani K
Module 1: Introduction to Programming & Python
Topics
What is Programming?
Why Python?
Features of Python
Applications of Python (Data Analytics, AI, Web, Automation, etc.)
Installing Python & IDE setup (Anaconda, VS Code, Jupyter)
Python Program Structure
Writing your first Python program
Outcomes
✔ Understand basic programming concepts
✔ Set up Python environment
✔ Run simple programs
Module 2: Python Basics & Syntax
Topics
Python Keywords & Identifiers
Variables and Data Types
int, float, string, boolean, complex
Type Conversion & Type Casting
Input & Output
Comments & Indentation Rules
Outcomes
✔ Use variables correctly
✔ Understand Python syntax rules
✔ Perform basic input/output
Module 3: Operators in Python
Topics
Arithmetic Operators
Relational / Comparison Operators
Logical Operators
Assignment Operators
Bitwise Operators
Membership & Identity Operators
Operator Precedence
Outcomes
✔ Perform calculations
✔ Write logical expressions
✔ Understand decision-making logic
Module 4: Control Flow Statements
Topics
Conditional Statements
if, if-else, if-elif-else
Looping Statements
for loop
while loop
Loop Control
break, continue, pass
Nested loops
Outcomes
✔ Build decision-based programs
✔ Automate repetitive tasks
Module 5: Data Structures in Python
Topics
Strings & String Operations
Lists & List Methods
Tuples
Sets
Dictionaries
Type casting between structures
Outcomes
✔ Store & manipulate collections of data
✔ Choose appropriate data structures
Module 6: Functions & Modular Programming
Topics
Built-in Functions
User-defined Functions
Function Arguments
Positional, Keyword, Default, Variable-length
Return statement
Lambda Functions
Scope of variables
Recursion
Outcomes
✔ Write reusable programs
✔ Improve code organization
Module 7: Exception Handling & File Handling
Topics
Types of Errors
try, except, else, finally
Custom Exceptions
File Handling
Reading & Writing files
Working with CSV & text files
Outcomes
✔ Build error-resistant programs
✔ Store & retrieve data from files
Module 8: Object-Oriented Programming (OOP)
Topics
Classes & Objects
Constructors
Inheritance
Polymorphism
Encapsulation
Abstraction
Outcomes
✔ Design real-world programs
✔ Apply OOP concepts
Module 9: Python Libraries Introduction
Topics
Introduction to NumPy
Introduction to Pandas
Introduction to Matplotlib
Basic Data Analysis using Python
Power BI Course Content – From Beginner to Advance by Janani K
Module 1: Introduction to Business Intelligence & Power BI
Topics
What is Business Intelligence?
Role of Power BI in Analytics
Power BI Ecosystem
Power BI Desktop
Power BI Service
Power BI Mobile
Installing Power BI
Interface & Navigation
Power BI Workflow
Practical
✔ Build your first Power BI report
Module 2: Data Sources & Data Loading
Topics
Connecting to Data Sources
Excel
CSV
SQL Database
Web
Folder
Import vs DirectQuery
Data Refresh & Gateway Concepts
Practical
✔ Import multi-source dataset
Module 3: Power Query – Data Transformation & Cleaning
Topics
Power Query Interface
Data Cleaning Techniques
Remove duplicates
Handle missing values
Split & merge columns
Change data types
Data Profiling
Merge & Append Queries
Applied Steps & M Code basics
Practical
✔ Clean raw sales dataset
Module 4: Data Modeling & Relationships
Topics
Fact & Dimension tables
Star & Snowflake schema
Creating relationships
Cardinality & filter direction
Normalization vs Denormalization
Practical
✔ Build a proper data model
Module 5: DAX (Data Analysis Expressions)
Topics
Measures vs Calculated Columns
Basic DAX Functions
CALCULATE, FILTER, ALL, VALUES
Time Intelligence Functions
Logical & Text Functions
Aggregation Functions
Practical
✔ Create business KPIs using DAX
Module 6: Data Visualization & Report Design
Topics
Visualization types & use-cases
Custom visuals
Formatting & themes
Tooltips & drillthrough
Slicers & filters
Bookmarks & buttons
Practical
✔ Interactive sales dashboard
Module 7: Advanced Analytics in Power BI
Topics
What-if Parameters
Forecasting
Decomposition Tree
Key Influencers
AI Visuals
Practical
✔ Advanced insights dashboard
Module 8: Power BI Service & Collaboration
Topics
Publishing reports
Workspaces
Dashboards
Sharing & permissions
Scheduled refresh
Row Level Security (RLS)
Practical
✔ Publish & share business report
Module 9: Performance Optimization & Best Practices
Topics
Data model optimization
DAX performance tuning
Report performance analyzer
Best practices for scalability
Module 10: Real-World Projects & Capstone
Projects
Sales Performance Analysis
HR Analytics Dashboard
Customer Segmentation Dashboard
Financial Performance Dashboard
SQL for Data Analytics by Janani K
Module 1: Introduction to Databases & SQL
Topics
What is Data?
Database vs File System
What is DBMS & RDBMS?
Database Architecture
Tables, Rows & Columns
Primary Key & Foreign Key concepts
What is SQL?
Types of SQL Commands (DDL, DML, DQL, DCL, TCL)
Practical
✔ Create your first database
✔ Explore sample datasets
Module 2: Database Design & Data Types
Topics
Database Normalization
ER Model Basics
Data Types in SQL
INT, FLOAT, DECIMAL, CHAR, VARCHAR, DATE, etc.
Creating Tables
Inserting Data
Practical
✔ Design Sales database schema
Module 3: DDL – Data Definition Language
Topics
CREATE TABLE
ALTER TABLE
DROP TABLE
TRUNCATE TABLE
RENAME TABLE
Adding & removing columns
Practical
✔ Modify database structures
Module 4: DML – Data Manipulation Language
Topics
INSERT records
UPDATE records
DELETE records
Handling NULL values
Practical
✔ Maintain employee records
Module 5: DQL – Data Query Language
Topics
SELECT statement
WHERE clause
ORDER BY
DISTINCT
LIMIT / TOP
BETWEEN, IN, LIKE
GROUP BY
HAVING
Practical
✔ Retrieve business reports
Module 6: SQL Joins
Topics
INNER JOIN
LEFT JOIN
RIGHT JOIN
FULL JOIN
CROSS JOIN
SELF JOIN
Practical
✔ Combine customer & sales data
Module 7: SQL Functions
Topics
Aggregate Functions
SUM, AVG, COUNT, MIN, MAX
Scalar Functions
UPPER, LOWER, LENGTH, ROUND, CONCAT
Date & Time Functions
Practical
✔ Generate financial summaries
Module 8: Subqueries & CTE
Topics
Single-row Subqueries
Multi-row Subqueries
Correlated Subqueries
Common Table Expressions (WITH)
Practical
✔ Solve complex analytical queries
Module 9: Constraints & Keys
Topics
PRIMARY KEY
FOREIGN KEY
UNIQUE
NOT NULL
CHECK
DEFAULT
Practical
✔ Enforce data integrity
Module 10: Views, Indexes & Stored Procedures
Topics
Creating & using Views
Indexes for performance
Stored Procedures
Basic Triggers
Practical
✔ Create optimized reporting systems
Module 11: Advanced SQL for Analytics
Topics
CASE Statements
Window Functions
ROW_NUMBER, RANK, DENSE_RANK
LEAD, LAG
Analytical Queries
Pivot & Unpivot concepts
Practical
✔ Advanced business analytics queries
Module 12: Performance Optimization & Best Practices
Topics
Query optimization techniques
Execution plans
Index tuning
Best practices for large datasets
Module 13: Real-World Case Studies & Projects
Projects
Retail Sales Analysis
HR Analytics Database
Banking Customer Analysis
E-commerce Business Intelligence System
