Renu prabha Excel, SQL, Power BI
No reviews yet

🚀 Excel | SQL | Power BI Tutor | Turn Data into Decisions 🚀

Hi, I’m Renu Prabha, a data professional with over 5 years of experience in IT, analytics, and reporting. I specialize in teaching Excel, SQL, and Power BI—empowering students and professionals to work confidently with data, automate workflows, and build impactful dashboards.

Whether you're just starting out or preparing for a job role, my sessions are hands-on, real-world, and tailored to your goals.

💡 What I Offer:
Excel Training (Beginner to Advanced)

SQL for Data Analysis & Reporting

Power BI Dashboards & Data Modeling

Corporate Excel & BI Skills

Interview/Test Preparation

Project Support & One-on-One Coaching

🧠 My Teaching Style:
Clear, practical, and engaging—focusing on real-life business scenarios and tools used in the industry.

🧾 Format:
Online sessions (Zoom/Google Meet)

Flexible timing

Practice exercises & resources provided

Subjects

Microsoft Power BI Beginner-Intermediate
SQL Developer Beginner-Expert
Power BI Desktop Beginner-Intermediate
Excel (Basic) Beginner-Intermediate

Experience

Senior Data Analyst (Jul, 2021–Jan, 2023) at Wipro private limited

Extracted data from different sources, including flat files, Excel, and SQL Server, ensuring 99% accuracy after thorough validation before loading into staging and final destination systems..
Developed 20+ interactive dashboards and reports in Power BI for supply chain management, enabling stakeholders to track key metrics like delivery performance, inventory turnover, and supply chain disruptions, reducing report generation time by 40%.
Created and customized 50+ different chart types (e.g., line, bar, scatter, tree map, and maps) to visually represent supply chain metrics, increasing report engagement by 30%.
Implemented dynamic and drill-through capabilities for deeper insights into areas like order status and inventory performance, improving decision-making efficiency.
Configured Edit Interactions for seamless cross-visual interactions, improving analytical workflows and allowing users to filter data on multiple visuals at once.
Implemented row-level security (RLS) for 5+ supply chain management reports, ensuring sensitive data such as supplier pricing and internal forecasts were only visible to authorized users.
Managed gateways, ensuring automated and accurate data refresh schedules for supply chain reports, reducing manual report updates from weekly to daily for near real-time insights.
Designed and implemented indexes and partitioning strategies in SSMS, enhancing query performance and reducing data load times by 15%.
Developed and deployed SSIS packages to automate the ETL process, improving data loading speed by 50%, ensuring seamless integration of supply chain data for analysis.
Conducted performance reviews of SSIS ETL jobs and adjusted data flow logic to optimize memory usage and processing time, ensuring faster and more efficient data loads.
Data Analyst (Jul, 2019–Jul, 2021) at 2 years of experience in Cognizant Technology Solutions

Utilized SSMS to design and optimize 50+ SQL queries for the extraction, transformation, and loading (ETL) of data from legacy systems, ERP, and external databases into centralized data warehouses.
Developed and deployed SSIS packages to automate the ETL process, improving data loading speed by 50%, ensuring seamless integration of supply chain data for analysis.
Implemented error-handling mechanisms within SSIS workflows, reducing data processing errors by 30%.
Scheduled and maintained SSIS jobs for regular data extraction and transformation tasks related to inventory levels, supplier shipments, and order statuses.
Extracted and integrated data into Power BI Desktop from diverse sources, ensuring accuracy and completeness.
Created dynamic slicers, measures, and calculated columns to facilitate advanced data analysis. Designed and delivered a range of report types, strategically pinning them to dashboards to meet business requirements.
Generated comprehensive reports utilizing DAX time intelligence functions and advanced DAX calculations, enabling 30% faster interpretation of key trends such as sales growth and inventory turnover.
Contributed to the development of 10+ hierarchies and established robust relationships between attributes to optimize processing efficiency.
Built and maintained relationships between 20+ dimensions and measure groups, aligning data models with organizational goals and improving the accuracy of cross-functional reporting.
Software Engineer (Jan, 2017–Jul, 2019) at Larsen & Toubro Infotech Chennai

• Designed and developed Micro Strategy graphical and visualization solutions as per business
requirement documents and plans for creating interactive dashboards and Dossiers.

• Extensively worked in creating and integrating MicroStrategy reports and objects (Attributes, filters,
metrics, facts, prompts, templates, consolidation and custom
groups).
Involved in the creation of intelligent cubes, derived elements, derive attributes and aggregated
tables to improve the performance.

Experience in customize SQL query by setting VLDB properties at different levels Database Instance,
Reports and Metrics.

Involved in migration of Business objects documents to MicroStrategy Documents.

Skilled in troubleshooting and resolving issues related to UNIX and Linux systems, utilizing
command-line tools and scripting languages.

Education

Electronics and Communication (Aug, 2012–Apr, 2016) from S A ENGINEERING COLLEGE, chennai

Fee details

₹600–1,000/hour (US$6.32–10.53/hour)

Beginner Level Excel: ₹600/hour
Intermediate Level (functions, charts, basic dashboards): ₹800/hour
Advanced Level (PivotTables, Power Query, VBA, Power Pivot): ₹1000+/hour