01
Description: Explore insights from different aspects of an insurance organization, namely member activity, member credits, program, and provider.
Query: Sample SQL
Technology: Power BI, MySQL, Power Query, DAX, Microsoft Fabric
02
Description: E-Commerce, a multinational company, relies on a SQL Server database to manage their transactional data, encompassing customer orders, returns, and customer profiles. However, the lack of a user-friendly interface for data analysis has impeded the company's ability to extract meaningful insights from their data. This project aims to provide an analytics solution using Power BI Desktop to overcome these challenges and optimize sales strategies while addressing customer satisfaction concerns.
Technology: Power BI, MySQL, Power Query, DAX, Microsoft Fabric
03
Description: Designed an advanced business dashboard to track sales department performance, providing insights into revenue vs budget, revenue by product, and revenue by salesperson.
Technology: Power BI, MySQL, Power Query, DAX, Microsoft Fabric
04
Description: Analyze patient volumes visiting the emergency room by developing a dashboard, which investigates patient types, trends, seasonality, waiting times, and patient satisfaction.
Technology: Power BI, Power Query, DAX, MySQL, Microsoft Fabric
05
Description: Evaluate the performance of the Email Marketing Campaign by transforming data from 2017 to 2019. The Dashboard provides depth into the campaigns, including a variety of critical metrics, namely delivery rate, open rate, click-to-open rate…
Technology: Tableau, MySQL