Business Intelligence Analyst

Joe
Carignan

I turn messy data into clear decisions —
through BI infrastructure, reporting systems,
and analytical storytelling.

See my work

Analytical by nature,
strategic by practice.

Tools & Technologies

  • Power BI & DAX
  • Power Automate
  • SQL
  • R / RStudio
  • Tabular Editor
  • VertiPAQ Analyzer
  • Microsoft Fabric
  • Dataflows Gen1

Selected Work

01

Partner Reporting Automation

Built an end-to-end automated reporting system delivering paginated Power BI reports to global partners across AU/NZ, EMEA, and NAM regions via Power Automate flows, including SFTP delivery and dynamic date parameterization.

Power BI Power Automate DAX SFTP
02

BI Infrastructure Migration

Redesigned the Power BI data architecture by migrating ODBC-sourced tables into a Dataflow Gen1 framework, resolving persistent memory crash issues in Power BI Desktop and establishing dev/prod workspace separation with deployment pipelines.

Power BI Dataflows Architecture
03

Spotify Track Analysis

Academic group project analyzing a Spotify tracks dataset using R — covering exploratory data analysis, hypothesis testing (t-tests, proportion z-tests), and regression modeling to surface patterns in audio features and popularity.

R Statistics EDA Regression
04

Semantic Model Optimization

Audited and optimized a Power BI semantic model using VertiPAQ Analyzer and Tabular Editor, identifying high-cardinality columns with poor compression and implementing structural changes to improve query performance and model size.

VertiPAQ Tabular Editor Power BI

Let's connect.

I'm always open to interesting conversations about data, analytics infrastructure, or new opportunities.