Conner Mackin

Business Intelligence Developer in
Fort Worth, TX

LinkedIn

Data Skills and Tools

  • Ingestion and Transformation (ELT):
    SQL, dbt, Python, Excel Power Query & Power Pivot
  • Visualization:
    Tableau, Power BI
  • Analysis and Communication of Business Insights

Portfolio

Data Visualization

Tableau

Bike Store Online Sales Dashboard

Used T-SQL to join and query retail sales data from 30-table Microsoft SQL Server example database AdventureWorksDW.  Built business intelligence dashboard in Tableau.  See SQL query and data used here.

Python

US House Price Index vs. Consumer Price Index Analysis

Analyzed US House Price Index (HPI) and Consumer Price Index (CPI) data from 2017 to 2022 from Econdb using Python packages NumPy, Pandas, Matplotlib, and Seaborn in Jupyter Notebook.  See analysis here.

Power BI

Finch Beak Size
Retail Sales Dashboard
US Trail Use