SECOND HIGHEST SALARY – LEETCODE
Here ‘s the problem statement https://leetcode.com/problems/second-highest-salary/ My Solution: WITH SALARY_RANKING AS ( SELECT Salary, DENSE_RANK() OVER (ORDER BY salary DESC) [ranking] FROM Employee ), RESULT_SET AS ( SELECT DISTINCT Salary FROM SALARY_RANKING WHERE ranking = 2 ) …
HR ANALYTICS DASHBOARD
Tool Used : Power BIDatasource : ExcelSteps : Import from Excel -> Clean Data->Data Modelling using DAX Key Insights: 1)Total Head Count Increased from 157 in 2018 to 239 in 2019 and 346 in 2020.2)Total Employee Expense increase from 15M in 2018 to 24M in 2019 and 36M in 2020.3)Company have more number of FTE …
Interactive SALES DASHBOARD
Tool Used : Power BIDatasource : ExcelSteps : Import from Excel -> Clean Data->Data Modelling using DAX Key Insights: 1)Total sales decreased by 31.13 % compared to LY 2)Total cost decreased by 33.75 % compared to LY 3)Profit Percentage increased by 24.01 % compared to LY(2019)4) 1015 new customers in 2020 compared to 20195)Netherlands has Total …
Technoedge dashboard
Key Insights: 1)Total Sales-57438.86 2)Office suplies tops in category wise order 3)Top 5 selling products are BoomBox,FlexiSeat,DeskMate,Canvas prints and FlexiTable 4)Net Profit followed an increasing trend till 2022 and faced a slight decreasein 2023