Posts

Showing posts from June, 2022

Product User Research - Reward badges Feature - Byjus (Whitehat Jr LMS)

Image
  User Research - Reward badges Feature - Byjus (Whitehat Jr LMS) Based on findings from prior study, a new Achievement badge has been created. On the Whitehat Junior App, it was just offered  to 40% course completion of users. We need to know how students are interacting with the new build. A survey was created to  be sent out to the users who would be involved in the project. However, after some past survey experiences, it was decided to  approach these users students by obtaining their phone numbers from the data team. The goal was to link people who were in  their Beginner Session and those who were in their Advanced Session. Some of them would have got at least one achievement  badge on the app the others would have not yet got a badge.

Health Insurance Survey Dashboard : PowerBI Project

Image
 Hey Friends!! I have made the below data analysis dashboard based on the survey carried on the sample set of employee of    "Organisation Confidential" .  based on the mediclaim survey carried. Below the analyis of the Dataset Observations 1 ) 91.73% of employees are aware of Healthbenifits provided by Company         8.27%  Employees are Unware of the Benefits 2) Maximum number of employees stated the reason of their unsatisfaction as " Other reasons" 3) 1.94% Employees wants to upgrade the medicalaim coverage to 5lacks     33.55%  Employees are not intrested in upgrade     56.73% Employees would like to upgrade the coverage to 10 Lacks     7.78% Employees would like to know more details of medical policy. Observations 1 )  83% Employees have already claimed the health benifits 2) 5.02% Employees are not satisfied becoz the service is not quick 3) 518 Employees have not claimed the medical insura...

Employees Salary Prediction Using Linear Regression - KNIME ANALYTICS PLATFORM

Image
Here I will be using the KNIME to forecast the employee's salaries with respect to their year of experience by training and testing data in ML using Linear Regression. Step 1 : Reading the data set with KNINE - File Reader Node 1                                         Step 2: Adding the data filter node to remove the Null Values Setting up the pattern match to N/A Step 3: Adding Node 2.1 Partitioning for Data sorting to Train & Test for Machine learning Algo. Here we set 70% of total data to Train & 30% to Test Step 4:  Training data for linear regression Note: After training the data, we have concluded that our model shows ~95% Accuracy , as we have selected the Random samples from the training data to maintain the efficiency of the model. Step 5: Adding the Linear Regression Node run Trained & Test Data Step 6: Once we have trained and tested data, we have got the ...

Data Visualization Project : Sales Data - PowerBI

Image
In this project we have displayed the comparison of Current Year Sales with Previous Year sales and YoY sales growth%. We have displayed the Budgeted Sales data along with Budget Variance%. We have Power BI Tooltip to display Product Level comparison of Sales and Month wise Budget Variance%. We have created the Sales forecast also. Data link : https://docs.google.com/spreadsheets/d/1Ap1S4IIUJCPN80aT2YSIhVZ2HaK7nDlP/edit?usp=sharing&ouid=109399052699278618880&rtpof=true&sd=true Final output So here we go................... Step 1 : Here we have uploaded Excel file in power BI via Home - Getdata- Excel navigator Step 2 : Sorting data with Year / Month / Quarter  as mentioned below Year Dim =  Year = 'Date Dim'[Date] . [Year] Month Dim =  Month = 'Date Dim'[Date] . [Month] Quarter Dim =  Quarter = 'Date Dim'[Date] . [Quarter] Step 3 - Adding the column to the database to analyse the data for creating charts Step 4 - Interrelate the Database, based ...