Manoj Bharath

Projects ENHANCING BUSINESS WITH EFFECTIVE INSIGHTS – Virtual Client’s Project May 2023

● Created a dashboard using Microsoft Power BI to help client compare the business between different branches and regions

● Transformed and processed client’s data by using DAX and Excel to ensure data completeness and validity

● Provided technical insights on how the client can fully utilize their data by introducing various strategies

● Consulted with the client to determine the best metrics to be displayed on the final decision WEB SCRAPING USING PYTHON – Personal Project April 2023

● Utilized BeautifulSoup and Requests packages in Python to extract Top 250 Rated movies from IMDB website

● Used OpenPyXL library to export the extracted 250 records from IMDB to an Excel file, so as to perform statistical operations CUSTOMER SUPPLY CHAIN MANAGEMENT – Personal Project March 2023

● Performed data cleaning and text analysis using Power Query as the data preprocessing, transformed and filtered data by using various features in Power BI visualizations

● Created dashboard and visualized data with DAX measures in Microsoft PowerBI over the period to identify key business metrics TELECOM CUSTOMER CHURN ANALYSIS – Personal Project February 2023

● Utilized MySQL to analyze 7043 customers over different regions and gain insights on how to grow the business and revenue

● Used Window Functions to summarize the data with respect to revenue and churn proportions Summarized and aggregated the data that implies results to develop the business MARKETING CAMPAIGN ANALYSIS – Personal Project January 2023

● Utilized Microsoft’s SQL Server Management Studio (SSMS) to analyze the customers over different regions and gain insights on how to make them potential purchasers based on the campaigns provided by the company

● Used LAG() functions to extract the year-over-year growth and identify the new and repeated customers