My name is Aiden Lane and I am an aspiring Data/Business Analyst!
- Leveraged SQL in local PostgreSQL database to thoroughly clean data from Amazon India and performed exploratory data analysis to uncover key sales trends
- Developed simple yet informative data visualization in PowerBI, aimed to make the most important information available at a glance
- Identified significant factors behind sales and revenue including geographic location, product category, etc.
- Built an interactive Excel dashboard using pivot tables to analyze large supply chain dataset, uncovering trends in relevant key performance indicators (KPIs)
- Analyzed patterns in order fulfillment metrics, including late and perfect order rates, to optimize supply chain
- Utilized Python (Pandas) and PostgreSQL to analyze clinical data from a case study on indwelling arterial catheters (IAC) for patients in the ICU as part of the MIMIC-II database
- Performed binary logistic regression using scikit-learn to create a model with high accuracy for classifying mortality in patients
- Programming: SQL, Python (Pandas, Scikit-learn), R, SAS, Java
- Data Visualization: Power BI, Excel, ArcGIS
- Database Management: MS SQL Server, PostgreSQL
- Email: aidenjlane@outlook.com
- Linkedin: https://www.linkedin.com/in/aidenlane