Anjali Mishra
Online
Skills
About
Anjali Mishra holds a Bachelor of Commerce degree and has one year of teaching experience. She is dedicated to helping students understand complex concepts in a simple manner. Anja...
Anjali Mishra holds a Bachelor of Commerce degree and has one year of teaching experience. She is dedicated to helping students understand complex concepts in a simple manner. Anjali is fluent in both English and Hindi, making her accessible to a wider range of students.Her teaching approach is focused on building a solid foundation in the subjects she teaches. She emphasizes clarity and understanding, ensuring that her students feel confident in their abilities. Anjali is committed to creating a supportive learning environment, whether online or offline, tailored to meet the unique needs of each student.
Anjali Mishra
Online
Skills :
Anjali Mishra holds a Bachelor of Commerce degree and has one year of teaching experience. She is dedicated to helping students understand complex concepts in a simple manner. Anja...
Anjali Mishra holds a Bachelor of Commerce degree and has one year of teaching experience. She is dedicated to helping students understand complex concepts in a simple manner. Anjali is fluent in both English and Hindi, making her accessible to a wider range of students.Her teaching approach is focused on building a solid foundation in the subjects she teaches. She emphasizes clarity and understanding, ensuring that her students feel confident in their abilities. Anjali is committed to creating a supportive learning environment, whether online or offline, tailored to meet the unique needs of each student.
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: Anjali Mishra
Data Analytics with Excel (Basic to Advanced), SQL & Power BI by Anjali Mishra
Data Analytics Tools: Excel (Basic to Advanced), SQL & Power BI
This program is structured for graduates, early-career professionals, and working executives seeking hands-on proficiency in Excel, SQL, and Power BI for data analysis, reporting, and decision support. The course emphasizes practical application, structured problem-solving, and real-world datasets.
🔹Microsoft Excel (Basic to Advanced)
Excel environment, data types, and structured referencing Formula logic and cell referencing (relative, absolute, mixed).
Core functions: SUM, AVERAGE, COUNT, IF, IFERROR
Conditional functions: COUNTIF, SUMIF, AVERAGEIF
Lookup & reference functions: VLOOKUP, HLOOKUP, XLOOKUP, INDEX–MATCH
Text, date, and logical functions for data transformation
Conditional formatting & data validation
Data cleaning techniques (duplicates, inconsistencies, formatting)
Pivot Tables, Pivot Charts & dynamic reporting
Building Excel-based dashboards for analysis
🔹 SQL for Data Analysis
Relational database concepts & schema understanding
Data retrieval using SELECT, WHERE, ORDER BY, LIMIT
Aggregations and grouping (COUNT, SUM, AVG, GROUP BY, HAVING)
Joins (INNER, LEFT, RIGHT) and relationship handling
Subqueries and query optimization basics
Practical querying on real datasets
SQL interview-oriented problem solving
🔹 Power BI
Power BI architecture & data connectivity
Data preparation using Power Query
Data modeling & relationship management
DAX fundamentals (CALCULATE, FILTER, SUMX, IF)
Designing interactive dashboards & reports
KPIs, slicers, filters, and advanced visuals
End-to-end project-based dashboard development
🎯 Learning Outcomes
Ability to analyze, clean, and structure business data
Proficiency in querying databases and deriving insights
Design of interactive dashboards for stakeholders
Strong foundation for data analyst roles and interviews
👩🏫 Instruction Methodology
Structured, concept-driven teaching Hands-on practice with real-world datasets Use-case-based explanations Focus on analytical thinking and clarity.
