top of page
abstract-technology-banner-blue-background-vector.jpg

Blake's Portfolio

Data Analyst
WELCOME,

I'm a data analyst based in Manchester, Iowa, with a strong passion for uncovering insights and solving real-world problems through data. Over the past four years, I've honed my analytical skills through a combination of rigorous academic coursework, hands-on class projects, and self-driven personal projects that reflect both curiosity and commitment to continuous learning.

 

My core skill set includes SQL, Python, Excel, Tableau, and Power BI, which I use to clean, analyze, and visualize data in ways that drive informed decisions. Whether it's designing dashboards to track key metrics, writing efficient queries to extract insights, or using Python for advanced analysis and automation, I thrive on transforming complex datasets into clear, actionable stories.

 

In addition to my main toolkit, I’ve explored and gained working knowledge of other modern tools and platforms such as Looker, Azure, and AWS. This broader exposure helps me stay adaptable and ready to contribute in a variety of environments—from traditional business intelligence setups to more cloud-based data ecosystems.

 

I'm particularly interested in roles and projects where I can blend my technical skills with critical thinking to support data-informed strategies, drive performance, and make a meaningful impact.

 

Feel free to explore my projects to see how I approach data analysis from end to end—from cleaning and exploration to insights and visualization.

​

P.S. I do enjoy other activities outside of analytics. I love to work out and I have been interested in sports my whole life, so I try to watch my favorite teams play when possible. In addition, I try to stay connected with friends by hanging out in person or playing video games for those farther away. Otherwise, my dogs keep me company and definitely keep me on my toes. 

Untitled design.png
WANT TO CONNECT?

Email me at: blakeallansmith@gmail.com

Call me at: (563)-608-0090

​

Resume

Skills:

  • SQL (SQL Server, MySQL, PostgreSQL

  • Python (Pandas, NumPy, SciPy, MatPlotLib)

  • Excel (XLookup, Conditional Formatting, Pivot Tables)

  • Microsoft Azure (DataBricks, Azure Data Lake, Azure Data Warehouse)

  • Microsoft Power BI

bottom of page