ashishaggarwal03 Goto Github PK

analyzing_apple_app_store_data

Contains details and descriptions for 7000+ mobile apps available on the Apple App Store: Analyze data to see trends and patterns about which app may have improved their rating the most by updating to their current version. How free apps perform vs paid apps

analyzing_imdb_movie_database-excel-pivot-tables-and-pivot-charts-

Used Microsoft Excel Pivot tables, Pivot Charts, Macros and VBA to analyze and clean IMDb movie dataset that contains 3000+ movies and generating insights with filters like slicers and timeline. I have used macros in case the database updates so I don't have to perform data cleaning steps again.

analyzing_weatherconditions_us

Weather App Data: Used Pivot charts, calculated fields, Date grouping, sorting and filtering to analyze the temperature over months and days and to answer which day and which month saw the max difference between max temp and min temp.

analyzingandcleaning_us_voters_data

US Voter: Used pivot table and created calculated fields to show data that answers the some of the following questions: How does voter turnout compare across states? Are certain age ranges more or less likely to vote in general? Do these trends hold nationwide or are there state specific insights that we can uncover?

cleaning_stock_market_data

Stock Market: 3 month of stock market data for 500 publicly-traded companies. Used sorting and filtering, conditional formatting and value settings to analyze the performance of companies over these 3 months.

collaborative-frontend-application

Collaborative frontend application where users can conveniently view the output directly within the same coding window and allows them to code in HTML, Css, JavaScript simultaneously. This streamlined process enhances efficiency and expedites the development and testing phases for users, allowing them to focus more on their core tasks.

ff-proxy

A UDP to TCP proxy server for sending HTTP requests with zero roundtrips

healthcare-dataset---power-bi-power-query-dax-

Explored healthcare dataset to uncover hospital efficiency insights. Analyzed attributes impacting the patient length of stay (LOS) and cost and work to identify factors contributing to hospital differences using Power query. Employed DAX skills to create measures and insightful visualizations in Power BI.

mayhem-cmake-example

mortgage-trading-analysis---power-bi---power-query---dax---m-

I analyzed 5,000+ mortgages with DAX functions and M language, generating insights by creating multiple visualizations along with filters to enhance data presentation. I Merged datasets that enabled precise bids and created multiple reports and storytelling that highlighted vital factors. My analysis suggested to create pricing tiers based on score