- *Position** : Power BI \& Advanced Excel Trainer
- *Department:** Training
- *Location:** CGC University Mohali
- *Employment Type:** Full\-Time
We are seeking a highly skilled and passionate **Power BI \& Advanced Excel Trainer** to deliver engaging, practical, and industry\-focused training programs. The ideal candidate will have strong expertise in data analysis, dashboard development, business intelligence, and advanced Excel functions, with the ability to simplify complex concepts and enhance learners' analytical capabilities.
- *Key Responsibilities :**
- Design and conduct instructor\-led training sessions on **Microsoft Power BI** and **Advanced Microsoft Excel**.
- Deliver training programs for corporate employees, students, and professionals at various skill levels.
- Create interactive learning environments through hands\-on exercises, case studies, assignments, and real\-world projects.
- Assess participants' progress and provide constructive feedback to improve learning outcomes.
* Train participants on
- Power BI Desktop \& Power BI Service
- Data Import, Transformation, and Modeling
- Power Query \& ETL Processes
- DAX Functions and Measures
- Interactive Dashboard Development
- Data Visualization Best Practices
- Report Publishing \& Sharing
- Row\-Level Security (RLS)
- Power BI Administration Basics
- *Advanced Excel Training**
* Deliver training on
- Advanced Formulas \& Functions (VLOOKUP, XLOOKUP, INDEX\-MATCH, IF, SUMIFS, etc.)
- Pivot Tables \& Pivot Charts
- Data Validation \& Conditional Formatting
- Dashboard Creation
- Power Query \& Power Pivot
- Data Analysis Tools
- Macros \& VBA Basics
- MIS Reporting \& Automation
- Develop training materials, presentations, manuals, assessments, and learning resources.
- Update course content in line with industry trends and Microsoft product enhancements.
- Create practical assignments and capstone projects for participants.
- *Required Qualifications**
- Bachelor's Degree in Computer Science, Information Technology, Statistics, Business Analytics, or a related field.
- Relevant certifications in Power BI, Data Analytics, or Microsoft Excel preferred.
- Minimum **3–5 years of experience** in Power BI, Excel, Data Analytics, or Corporate Training.
- Strong expertise in **Power BI, DAX, Power Query, and Data Modeling**
- Advanced knowledge of **Microsoft Excel**
- Understanding of SQL and database concepts
- Dashboard design and data visualization skills
- Business Intelligence and reporting expertise
- Data cleaning, transformation, and automation techniques
- Excellent presentation and communication skills
- Strong facilitation and classroom management abilities
- Ability to explain technical concepts to non\-technical audiences
- Strong analytical and problem\-solving skills
Passion for mentoring and knowledge sharing
- *Job Types:** Full\-time, Permanent
- *Salary**: ₹25,000\.00 \- ₹35,000\.00 per month
- *Ability to commute/relocate:**
Mohali, Punjab: Reliably commute or planning to relocate before starting work (Required)
- Bachelor's Degree in Computer Science, Information Technology, Statistics, Business Analytics, or a related field.
- *Experience :** 2years (Preferred)
**Supplemental Pay**
- Performance bonus
- Yearly bonus
- *Speak with the employe**r : **9875913163**
- *Email ID : reetu.hr@cgcuniversity.in**
- *Work Location** : **In person**
Pay: ₹25,000\.00 \- ₹35,000\.00 per month
Work Location: In person