Mohit Lokhande

                                                                       Data Analyst

 

 

 

    PROFESSIONAL SUMMARY   

 

• Experienced Business Analyst with 2.9 years of dedicated expertise in driving data-driven insights and strategic solutions.
• Expertise developing reports and dashboards using Microsoft Power BI and Tableau.
• Good in writing DAX queries/expressions in power bi desktop.
• Imported data from multiple data sources into BI Tools, created relationships between data, created calculated columns and measures using DAX Query.
• Good experience in Merge and Append Queries, Duplicate table and Reference table in Power Bi.
• Having good knowledge on Data Warehouse concepts like Star Schema, Snow Flake, Dimension and Fact table
• Worked on Dax expressions like Time Intelligence and Date Functions to create business calculations based on requirements.
• Experience with implementing security in Power BI Desktop and Power BI Service.
• Proficient in designing/building complex reports/dashboards using Filters, Slicers, Drill-down Reports, Sub reports and Bookmarks in Power BI Desktop.
• Knowledge in scheduling power bi reports by using the Data Gateway and viewing dashboards in Power BI Mobile version.
• Experience in creating customized visualization.
• Created, Scheduled, and maintained various reports in Power Bi

 

 

 

 

 

    TECHNICAL SKILLS   

• Data Visualization
• Python Programming
• Data Visualization
• MYSQL
• Advance Microsoft Excel
• Data Analysis
• Problem Solving
• ETL
• Machine Learning

 

    EDUCATION   

 

• BCCA (Bachelor of Commerce & Computer Application)

 

    PROJECTS   

 

TIBIL Solutions PVT. LTD.

Designation: Data Analyst                                                                                                                                         

(Feb,2022 – present)

• Expertise developing reports and dashboards using Microsoft Power BI and Tableau.
• Good in writing DAX queries/expressions in power bi desktop. Imported data from multiple data sources into BI Tools, created relationships between data, created Calculated columns and measures using DAX Query.
• Good experience in Merge and Append Queries, Duplicate table and Reference table in Power Bi. Having good knowledge of Data Warehouse concepts like Star Schema, Snowflake, Dimension and Fact table Worked on Dax expressions like Time Intelligence and Date Functions to create business calculations based on requirements.
• Experience with implementing security in Power BI Desktop and Power BI Service. Proficient in designing/building complex reports/dashboards using Filters, Slicers, Drill-down Reports, Sub reports and Bookmarks in Power BI Desktop.
• Knowledge in scheduling power bi reports by using the Data Gateway, Schedule Refresh and viewing dashboards in Power Bl Mobile version.
• Experience in creating customized visualization. Created, Scheduled and maintained various reports in Power Bi

 

Project 1 - Caterpillar

• Worked on Tableau supply chain dashboard with World largest construction equipment manufacturer client US.
• Design dashboard for CI (Construction Industry) products for visualizing end to en