we360(mahak mishra).pptx data analysis..

dATA ANALYSIS OF COMPANY of the company superstoe and performance trackerData analysis is a systematic process of inspecting, cleansing, transforming, and modeling data to discover useful information, inform conclusions, and support decision-making. It encompasses various techniques that can be broadly categorized into qualitative and quantitative analysis.

1. Data Analysis By – Mahak Mishra We360.ai

2. ABOUT WE360.AI We360.ai is an employee monitoring software that helps companies gain insights into employee performance and productivity. It offers real-time monitoring of both remote and in-office teams, providing detailed reports on productivity, app usage, time tracking, and more. We360.ai prioritizes privacy with customizable settings and data protection, enabling easy monitoring and management of teams from anywhere. We360.ai include tracking employees' computer activity, calculating actual work hours logged, and providing smart analytics for each team member. It also offers project management tools for keeping projects on track with real-time progress updates. The software is designed to boost revenue by improving engagement, efficiency, and informed decision making, while preventing data breaches and protecting intellectual property through employee monitoring. 2 "Employee Monitoring Like Never Seen Before." we360

3. The Founders 3 Arnav Gupta , Swapnil Tripathi , Siddharth Gupta we360 The founder of We360.ai is Arnav Gupta, who is a young entrepreneur currently building the workforce analytics software. He is joined by his co-founders, Swapnil Tripathi and Siddharth Gupta. Arnav, at the age of 23, is leading the company to empower 1 million companies globally and expand into international markets.

4. MISSION Enhancing Global Productivity We aim to revolutionize how businesses monitor and manage their teams, ensuring maximum productivity and transparency. . 4 we360

5. Core Features Real-Time Monitoring . 5 Productivity Insights Application and Website Usage Tracking Automated Attendance Tracking Screenshot Capture Employee Wellness This feature allows managers to track employee activities in real-time, including active applications, websites visited, and overall system usage. The platform offers detailed analytics on employee productivity by measuring key metrics such as keystrokes, mouse movements, and active versus idle time. We360.ai monitors the usage of various applications and websites to ensure that employees are focusing on work-related tasks. The software simplifies attendance management by automating the process. This feature captures screenshots of employees’ screens at regular intervals, providing visual evidence of work activities. We360.ai also focuses on employee wellness by tracking working hours and categorizing employees into underutilized, overworked, or balanced groups.

6. Commitment Presentation Title 6 Integrity & Intent: We prioritize responsible actions and trust-building by aligning our behavior with our words. Pushing Boundaries: Constantly innovating and striving to set new standards . Customer-Centric: Always working in the best interest of our customers, ensuring they receive the best possible service and support. we360

7. SuperStore Data Analysis . 7 we360 By Using Excel & PowerBI

8. Project Objective We have a superstore dataset where we have to perform different Data Analysis techniques, Specifically focusing on time series analysis , to provide valuable insights and accurate forecasting. . 8 . we360

9. Superstore dataset 9

10. Data Cleaning & Data Preprocessing Data Cleaning: Duplicate Entries : Check for and remove any duplicate rows based on ‘Order ID’. Date Validation : Ensure ‘Order Date’ is before ‘Ship Date’ for all entries. Consistency : Standardize text formatting in ‘Customer Name’, ‘City’, and ‘State’. Missing Values : Identify and address any missing or null values in the dataset. Typographical Errors : Correct any misspellings in categorical fields like ‘Ship Mode’. Data Preprocessing: Date Conversion : Transform ‘Order Date’ and ‘Ship Date’ from strings to datetime objects for easier manipulation. Categorization : Group cities into regions or other relevant categories. Encoding : Convert categorical variables like ‘Segment’ into numerical values for modeling purposes. Normalization : Scale numerical fields if necessary for analytical methods. Each table should be treated individually, following the steps above to ensure the data is clean and preprocessed for analysis. Remember to document each step taken for reproducibility and review. http://go.microsoft.com/fwlink/p/?LinkId=255141

11. Super Store Sales Dashboard Presentation Title 11 .

12. Dashboard Insight . 12 . we360 1. Top Metrics Summary : - Profit : Displays the total profit, marked as 27K. - Sales : Shows the total sales, though partially obscured, it appears to be a significant number likely in the hundreds of thousands. - Orders : Indicates the total number of orders, which is 5239. - Ship Days : Reflects the average shipping days, noted as 4. 2. Sum of Sales by Segment (Pie Chart): - Segments : The pie chart divides sales into different segments: Home Office (20%), Consumer (48%), and Corporate (33%). 3. Sum of Sales by Payment Mode (Pie Chart): - Payment Modes : Displays the distribution of sales by payment mode: Cards (20%), COD (41%), and Online (39%).

13. Dashboard Insight . 13 . we360 4. Sum of Sales by Region (Pie Chart): - Region: Shows sales by region, with the Central region accounting for 100% of the sales, suggesting the data might be focused on a particular region only. 5. Monthly Sales By Year over Year (Line Chart): - Monthly Sales Comparison : A line chart comparing monthly sales for the years 2019 and 2020, highlighting trends and seasonal peaks. 6. Monthly Profit By Year over Year (Line Chart): - Monthly Profit Comparison : A line chart showing monthly profit trends for the years 2019 and 2020, indicating profitability changes over time. 7. Profit by Customer Class (Bar Chart): - Customer Classes : A bar chart detailing profit distribution across different customer classes: Standard Class (0.21M), Second Class (0.07M), First Class (0.04M), and Same Day (0.02M).

14. Dashboard Insights . 14 . we360 8. Sum of Sales and Sum of Profit by State (Map): - Geographical Sales and Profit : A map visualization showing sales and profit distribution by state, offering a geographical perspective on performance. 9. Sales by Sub-Category (Bar Chart): - Sub-Categories: Bars representing sales figures for specific sub-categories: Chairs (46K), Binders (43K), and Phones (43K). 10. Sales by Category (Bar Chart): - Categories: A bar chart categorizing sales into Office Supplies (0.15M), Furniture (0.11M), and Technology (0.09M).

15. Presentation Title 15

16. Super Store Forecasting – 15 Days Forecasting . Presentation Title 16 .

17. Forecasting Insights 17 . we360 Sales Trend Analysis The line graph shows sales data from January 2019 to January 2021, with noticeable fluctuations indicating varying sales performance over time. The highlighted orange section suggests a recent upward trend in sales, which could be due to seasonal factors, marketing efforts, or new product launches. Category Performance The bar chart titled “Sales by Category” compares sales across different product categories. Office Supplies, Technology, and Furniture are visible, with varying sales figures represented by the length and color intensity of the bars. Darker greens indicate higher sales, suggesting that these categories may be key revenue drivers for SuperStore .

18. Forecasting Insights . 18 . we360 Category Performance: The bar chart titled “Sales by Category” compares sales across different product categories. Office Supplies, Technology, and Furniture are visible, with varying sales figures represented by the length and color intensity of the bars. Darker greens indicate higher sales, suggesting that these categories may be key revenue drivers for SuperStore . Regional Sales Insights: The report includes sales data by region, with numerical values next to the names of regions like New York, Washington, and Florida. This information is crucial for understanding regional market performance and could influence decisions on resource allocation and targeted marketing.

19. Forecasting Insight . 19 . we360 Forecasting Implications: The 15-day sales forecast is likely based on historical sales data and predictive analytics. Accurate forecasting is essential for inventory management, ensuring that supply meets anticipated demand without overstocking or stockouts. Strategic Decision-Making: Stakeholders can use this report to make informed decisions regarding inventory, marketing strategies, and financial planning. The forecast helps anticipate customer demand, allowing SuperStore to optimize operations and maximize profitability.

20. Presentation Title 20

21. Summary For data analysis, this dashboard offers a comprehensive overview of sales performance, customer segmentation, payment methods, geographical distribution, and time-based trends. Analyzing these dimensions can help in identifying sales patterns, understanding customer preferences, optimizing inventory, and improving marketing strategies. In summary, the sales forecast report provides valuable insights into SuperStore’s past performance and future expectations. It highlights key categories and regions contributing to sales, with an upward trend suggesting positive growth. This data-driven approach aids in strategic decision-making for the company’s continued success. 21

22. Links Super Store Excel file 22 Sum of Order Excel sheet Visualization Images http://go.microsoft.com/fwlink/p/?LinkId=255141 http://go.microsoft.com/fwlink/p/?LinkId=255141 http://go.microsoft.com/fwlink/p/?LinkId=255141 http://go.microsoft.com/fwlink/p/?LinkId=255141

23. THANK YOU!