Landon Pillar

Motivated Data Analytics student with hands-on experience applying analytical techniques through both internship work and portfolio projects. Skilled in transforming raw data into clear, actionable insights using tools such as SQL, Excel, Python, Power BI, and Tableau. Adept at cleaning, modeling, and visualizing data to support decision-making and improve business outcomes. Known for strong problem-solving skills, attention to detail, and a commitment to continuous learning in analytics and AI-driven solutions.

• AWS Academy Graduate - AWS Academy Cloud Architecting
• AWS Academy Graduate - AWS Academy Cloud Foundations
• Google Data Analytics Professional Certificate

DrivePro Autohouse Vehicle Sales Analysis

Tools: PowerBI, Excel

Developed a sales intelligence report for a fictional used car dealership using historical transaction data. Tracked key metrics such as sales volume, average price by odometer range, and top-performing makes. Created visuals comparing pricing deltas, color popularity, and geographic performance by state. Designed with dealership stakeholders in mind. 

Coffee & Cream Sales Dashboard

Tools: PowerBI, Excel

Built a comprehensive sales performance dashboard for a fictional cafe and bakery using 2023 transaction data. Key visualizations include monthly profit trends, item-level sales rankings, and payment method breakdowns. Implemented slicers for product, month, and location to support dynamic business insights. Optimized for small business decision-making. 

E-commerce Sales & Customer Insights

Tools: Tableau, SQL

Analyzed synthetic retail sales and customer demographic data to identify trends across products, categories, and regions. Created interactive dashboards to visualize sales KPIs, customer segments, and category performance. Used SQL to extract insights from structured datasets and support strategic planning for marketing and inventory.