Data Analyst

Job Summary


Module 1(IT Tools)

• This Module covers basic understanding of Computers,Ms Word , Advance Excel , Ms Powerpoint, Internet and WWW , Email,Digital Financial Tools , Cyber Security , PPT Presentation, data cleaning, lookup and logical formulas, Pivot Tables, and interactive dashboards

Module 2(My SQL)

• This Module covers deep knowlegde of Data Retrieval (DQL), Data Aggregation, Multi-table Joins, and Advanced Analytical Functions.RDBMS Concepts, Installing MySQL, Constraints Exploring PRIMARY KEY, FOREIGN KEY, and data integrity rules. Data Retrieval,Row Filtering,Pattern Matching,Sorting Limiting, Organizing outputs via ORDER BY and restricting volume with LIMIT. Aggregate Functions,Grouped Analysis using GROUP BY.Group Filtering using the HAVING clause.Conditional Logic: Creating custom segments and buckets with CASE WHEN. Subqueries: Nesting queries within SELECT, FROM, or WHERE blocks for multi-layered analysis.Common Table Expressions (CTEs): Writing cleaner, isolated code using WITH statements.Window Functions: Running complex analytical tasks like ROW_NUMBER(), RANK(), DENSE_RANK(), and rolling statistics using OVER(PARTITION BY...).String Date Functions: Formatting timestamps, extracting text intervals, and cleansing text strings

Module 3(Python)

• This Module covers Python Core with its Introduction ,Algorithm flow charts,Python Programs using variables,contants ,literals , conditional statements ,Loops , Functions , String ,Mathematical Date Functions , Lists Tuples Dictionaries File Processing , Scope and Modules ,OOPS, Numpy , Pandas, Matplotlib

Module 4(Power BI)

• This Module Covers data preparation, relational modeling, DAX calculations, interactive visualization, and cloud deployment

Career Opportunities

• Business Analyst (BA)
• Data Visualization Specialist
• Marketing Analyst
• Financial/Healthcare/HR Analyst

Our Courses

• E-Accounting
• Advance Program in Graphics and Web Design
• All modules of our long term courses include project work

Disclaimer: This job posting has been aggregated from external source. Role details, content, and availability are subject to change. Applicants are advised to confirm the latest information directly on the company website before applying.