At JM Healthcare, I leveraged my expertise in Power BI and analytical skills to enhance decision-making through comprehensive data analysis, including Google Analytics and SEO optimizations.Developed a Looker Studio dashboard for JM Health Care to analyze Google Ads performance, offering insights on campaign effectiveness, which improved ad budget allocation and decision-making.
● Implemented Google Analytics for various analysis including user behavior analysis, Funnel analysis, Path Analysis.
● Configured custom events with the help of Google Tag Manager.
● Analyzed data, generated insights, and created reports and dashboards that help organizations make datadriven decisions.
● Utilized SEO and SEM techniques to optimize website visibility on search engine results pages.
● Power BI
● Excel
● Python
● SQL (Structured Query Language)
● MySQL
● Microsoft SQL Server
● Get Job Ready: Power Bl Data Analytics for All Levels 2.0 | Codebasics.
● Excel: Mother of Business Intelligence | Codebasics
● Get Job Ready: Power BI Data Analytics for All Levels 2.0 | Codebasics
● SQL Beginner to Advanced for Data Professionals | Codebasics ● E SUMMIT’20(IIT-BHU)
Brick & mortar and ecommerce [Power BI | SQL | Excel | Dax Studio]
● Customized a multi-functional Power BI dashboard to analyze AtliQ hardware's sales trends over the global market by gathering data from 2 different sources (Excel/CSV files and a SQL database).
● Built data model and visualizations in Power BI, and optimized the report with DAX studio which improved the performance of the report by 5%.
● Developed a dashboard that enabled Atliq Hardware to analyze department sales trends, driving a projected 10% revenue acceleration and a 20% reduction in data-related expenses.