Gaurav M.

With 9 plus years of experience, I am looking forward to achieve professional satisfaction, progress and personal development while working in an environment that encourages learning and growth. I am a quick learner & can start working on anything within short span of time. Roles & Responsibilities: 1. Created various Power BI Dashboard’s as per the business requirements of different business units like Energy, Infra, M&M, Bantrel etc using various DAX functions and Power Query techniques. Combine multiple tables into one table using create table DAX in Power Bi. Build Page Navigation, Slicer Panel, Clear Filter option and lot more using bookmark technique and at last use different visualisation provided by Microsoft and insert from App store. All the reports were published on Power BI Services and provide access to user’s using direct method and Create Link Method. 2. Created multiple reports in Power BI as per the business requirements on different cuts of multiple KPI’s using DAX to create calculated columns. All the reports were published on Power BI Report Server and user can access through VPN only. Provided Row Level Security (RLS) on multiple conditions, i.e. Users in multiple states, are able to see only their respective state report data. No user can see all states report data on Report Server. Developed Brand File using Branding functionality on Power BI Report Server, so that it should look like own organization report server. Created ETL Package to Extract, Merge and Load data into OBRM tables and using SCD – Slow Changing Dimension technique maintain & manage the current and historic data for many reports on daily basis.