Mahesh Singh Mehra

I have been working as a database analyst on contractual basis in PSU Sector. I am passionate about learning new skills . Adept at receiving and monitoring data from multiple data streams including MS-Excel data source, SQL. Ability to synthesize quantitative information and interact effectively with colleagues and clients.

PROJECTS SUMMARY

Project #1:

Project Title : My Store

Role : Dashboard formed in MS- Excel.

Environment : MS-Excel Project

Description:

My Store is one of the Garments Shop. The Shop has different types of garments like kurta, Saree, Western Dress, Ethnic Dress etc. . This shop take online orders from different modes like, AJIO, Amazon, Flipkart, Myntra etc.

Different types of Charts were used to show:

 Order Status.

 Order Vs Sales.

 Sales Men Vs Women

 Sales through different Channels

 Top 5 States by sale.

Responsibilities:

 Created tables, Views and Procedures by using MS-Excel data.

 Created visualized Reports from MS- Excel File.

 Created Rich visualized Pie Charts, slicers, Bar Chart etc.

 Created rich visualized Dashboards in MS-Excel.

Project #2:

Project Title : Hotel Revenue

Role : Power BI, CSV data

Environment : .CSV File & Latest Power BI Desktop Project

Description:

Microsoft is a technology leader focused on helping people and businesses throughout the world realize their full potential. We create technology that transforms the way people work, play, and communicate across a wide range of computing devices. We generate revenue On the basis of rating given to the hotel and reviews by the customers visit the Hotel, this project basically based on the revenue earned by the hotel weekly. In this project different types of charts and slicers and KPI used to show weekly change on revenue.

Responsibilities:

 Created tables, Views and Procedures by using .CSV files.

 Created Rich visualized Power BI Reports by creating KPI & different measures.

 Created Rich visualized Donut Charts, Line Chart, Line & stack chart, Slicers, cards & Matrix Reports from CSV by using Power BI Desktop.

 Used Custom Visuals based on business requirement.  Worked on writing the complex measures using DAX.  Created Custom columns using DAX.  Extensively worked on Power BI Personal Gateways and Enterprise Gateways.  Created rich visualized Dashboards in Power BI.