Manendra
Mentor
Rising Codementor
US$8.00
For every 15 mins
ABOUT ME
5+ Years of Experience in Power BI Development & Training
5+ Years of Experience in Power BI Development & Training
I am a Microsoft Certified Trainer with data analysis, visualization, and modelling expertise. I have experience in Power BI, Snowflake, SQL, and DAX, enhancing decision-making and data security for clients.
Kolkata (+05:30)
Joined July 2024
EXPERTISE
5 years experience
5 years experience
5 years experience
5 years experience
REVIEWS FROM CLIENTS
Manendra's profile has been carefully vetted and approved as a Codementor. Connect with Manendra now, and leave a review for them once you're done!
EMPLOYMENTS
Senior Manager Data Analytics
PCGI Systems India LLP
2021-07-01-Present
- Enhanced decision-making for over 20 clients by gathering requirements, developing wireframes, and creating interactive Power BI ...
- Enhanced decision-making for over 20 clients by gathering requirements, developing wireframes, and creating interactive Power BI reports, resulting in actionable insights that drove business growth.
- Improved data security and accuracy by implementing Role-Level Security (RLS) and performing SQL-based data validation, ensuring reliable and secure reporting across organizational hierarchies.
- Streamlined report usability and user engagement by integrating Power Automate flows, sharing reports via the Power BI app, and developing comprehensive user guides, leading to higher user adoption and satisfaction.
- Demonstrated advanced technical expertise in DAX functions, SQL scripting, and paginated report development, optimizing data visualization and reporting processes to meet and exceed client expectations.
SQL
DAX
Power BI
View more
SQL
DAX
Power BI
Microsoft Power Automate
View more
Asst. Manager Data Analyst/ BI Developer
Larsen & Toubro
2017-09-01-2021-06-01
- Delivered comprehensive module designs by analyzing business requirements and functional workflows, ensuring alignment with clien...
- Delivered comprehensive module designs by analyzing business requirements and functional workflows, ensuring alignment with client needs and project goals.
- Mastered Power BI capabilities, building, customizing, and publishing interactive reports and dashboards, significantly enhancing data visualization and reporting efficiency.
- Streamlined data integration from various sources, including Flat Files, Excel, and Microsoft SQL Server, optimizing data extraction and transformation processes.
- Demonstrated expertise in Data Warehousing and ETL processes, utilising OLTP, OLAP, Star Schema, Snowflake Schema, Fact, and Dimension tables, alongside conducting thorough code walkthroughs, peer reviews, and unit testing of SSIS packages to ensure high-quality deliverables.
Excel
SSIS
ETL
View more
Excel
SSIS
ETL
OLAP
Microsoft SQL Server
Star Schema
Power BI
Data warehouse
Delta Tables
View more
PROJECTS
Sales Summary Report for Client
2024
I developed a comprehensive Sales Summary Report using Power BI, showcasing detailed analytics on sales performance for a client. This re...
I developed a comprehensive Sales Summary Report using Power BI, showcasing detailed analytics on sales performance for a client. This report showcases a clear view of sales trends, returns, discounts, and net sales. Key features include:
Sales Metrics: Weekly and daily sales trends, hourly sales breakdown, and top-selling categories.
Financial Insights: Gross amount, net sales, taxes, and tips.
Payment Analysis: Sales distribution through cash, card, and other payment methods.
Inventory Overview: Total inventory value, retail value, and projected profit with profit margins.
Team Performance: Gross sales contribution by top team members and discount analysis.
The report provides actionable insights, allowing for data-driven decision-making to optimize sales strategies and improve overall business performance. This project highlights my ability to deliver precise, data-centric solutions tailored to client needs, making me an ideal candidate for future projects requiring advanced data analytics and visualization skills.
SQL
Excel
PostgreSQL
View more
SQL
Excel
PostgreSQL
Power Query
DAX
Power BI
View more