Tableau

ER Insights: Data-Driven Care

Utilizing Tableau, this ER dashboard employs calculated fields and dynamic selectors for an in-depth look at patient care. Features include trend analysis, heatmaps, key performance indicators, and user-driven data filtering.

• Explore

Excel

Pedaling Insights

An interactive Excel dashboard showing sales trends and insights for a global retail bike chain. Achieved with Pivot Tables, slicers, filters, and a myriad of useful formulas. Be sure to download an open in Excel for proper functionality :)

• Check It

SQL, Excel

App Store Analytics

An in-depth SQL analysis of the Apple App Store, revealing key market trends and opportunities. Tools used include SQL, SQLite, and advanced functions like CTEs and Window Functions.

• Analyze

Tableau, Excel

Star Trek: TNG Episode Guide

An interactive, LCARS-themed dashboard, featuring season breakdowns, top and bottom episode rankings, and episode notes.

• Discover

SQL

SQL Murder Mystery!

A demonstration of my SQL skills and problem-solving abilities, using a fun and interactive murder mystery scenario. Can you crack the case in only two queries? Only a true data detective can!

• Solve

MicroSoft PowerPoint

Google Data Analyst Course Capstone Project

Bringing it all together in a PowerPoint deck with various data visuals and a bevy of insights. Uploaded to Google Sheets for convenience, however PowerPoint will provide the best experience.

• Learn

Tableau, R Langauge, Github

Cyclistic Capstone Process Breakdown

A step-by-step breakdown of my entire process during this exciting project including links to my GitHub repository, my R Markdown, and more!

• Dig In

Thank you

for exploring my work. If my passion for data-driven insights resonates with you, please reach out and connect. Together, we can innovate solutions and drive success. Let's turn data into action!hello@ernestdevaney.com

• LinkedIn