Prakhar Singh Bisht

Data Analyst with a strong interest in financial services. Proven ability to provide daily support to the data and finance department, perform routine assignments, and solve routine/standard problems. Skilled at managing expectations and comfortable working with a substantial amount of information. Analyst who maximizes productivity, profitability, and competitiveness by transforming technology plans into powerful business solutions. Distinguished for both technical and business acumen, and for an ability to bridge communication gaps between technical, business, and executive audiences. Earned degrees in both business and technology

• Data Import and Preprocessing: Imported libraries and dataset, conducted a thorough check for missing values, and addressed them using mean, median, and mode.
• Data Splitting and Scaling: Split data into training/testing sets, applied standard scaling, and converted the price column into a categorical format for linear regression.
• Correlation and Feature Selection: Analyzed correlations, removed irrelevant columns, and applied Linear Regression, Decision Tree, and Random Forest, achieving a 75% accuracy rate.

• Data Preprocessing: Handled null values, extracted month names, split columns, and created a KPI board with key metrics. Added filters and slicers for efficient visualization.
• Tableau Dashboard: Developed interactive charts and dashboards, enhancing data understanding.
• Key Insights: Identified Naypyitaw as the most profitable city, 19th hour as peak purchase time, and Food & Beverages as the top product category.