Author Image

Hi, I am Zach

Zach Renwick

Analytics Engineer

I am a passionate data professional with extensive SQL, data modeling and data visualization skills. I make videos on YouTube exploring data tools and blog about data and analytics topics

Skills

Experiences

1
Analytics Engineering with dbt (course/bootcamp)
co:rise

Nov 2021 - Dec 2021, Remote

co:rise accelerates your professional growth through live, small group courses created and taught by top experts.

Responsibilities:
  • Designed and developed a mock data warehouse using dbt and PostgreSQL
  • Utilized jinja SQL templating
  • Created automated lineage graphs and docs for our data model project
Power BI Developer (contract role)
West Fraser

Jul 2021 - Present, Vancouver, BC / Remote

West Fraser is one of the largest lumber companies in the world.

Responsibilities:
  • led reporting migration from existing internal reporting tool to Power BI Premium
  • led training sessions for end users on Power BI development and end use
  • created high-level architecture planning documents to plan out Power BI central dataset use in organization
2
3
Power BI Developer (contract role)
lululemon

Aug 2020 - Jun 2021, Vancouver, BC / Remote

lululemon is one of the world’s leading athleisure brands.

Responsibilities:
  • Utilized Power BI and Snowflake data warehouse to transform data into enterprise-grade business intelligence and analytics solutions.
  • Development work at lululemon was focused on creating data models and dashboards for the e-commerce team (sales, web and inventory analytics)
  • Developed a global e-commerce sales and visits semantic model to replace an existing on-premises Qlikview reporting solution
  • Developed a near real-time e-commerce sales dashboard, which enabled up-to-the-hour sales insights
  • Delivered an Omni order fulfillment report, which highlighted orders not meeting delivery and pickup SLAs
BI Developer
Best Buy Canada

Sep 2019 - Aug 2020, Vancouver, BC / Remote

Best Buy Canada’s mission is to enrich the lives of customers through technology.

Responsibilities:
  • Supported the digital intelligence and eCommerce teams with reports, dashboards and analysis of web and business data.
  • Developed data pipelines with Python
  • Supported ongoing delivery of automated reports via SSRS, Power BI and Adobe Analytics
  • Conveyed insights to users quickly and effectively using data visualizations and tables
  • Supported analysts on digital intelligence team with data they need to conduct ad-hoc analysis
  • Raised the eCommerce department overall analytic IQ through formal training, workshops, insights meetings and presentations to senior leadership
4

Recent Posts

Card image cap
Incremental Refresh in Power BI

What is incremental refresh in Power BI? Behind every Power BI dataset is a SQL Server Analysis Services (SSAS) tabular data model. This underlying technology has built-in partition support for larger datasets. Partitions divide tables into logical parts, which can then be refreshed independently. Incremental refresh brings that same partition support to the forefront in Power BI, enabling business users and IT professionals to refresh sections of a dataset. Why would you use incremental refresh in Power BI?

March 16, 2021 Read
Card image cap
Creating a Python Forecasting App with Streamlit and Prophet

I recently cobbled together a data web app using the Streamlit open-source framework. Users can upload their own data, visualize trends and features, and finally download the newly created forecast back to their computer. If you want to try it out yourself, you can see it in action here, assuming I have not gone over 25 hours of free app time on Heroku 😂 Streamlit is an awesome tool for quickly creating front ends to consume you data and analytics products.

May 16, 2020 Read
Card image cap
Why You Should Choose Power BI Pro or Premium over Power BI Report Server

Introduction In this article I’ll share the top issues and missing features of Power BI Report Server (PBIRS), and explain why I think organizations should choose cloud versions of Power BI over the on-premises PBIRS. as of May 2020 – these features may change over time. To begin with, what is PowerBI.com vs. Power BI Report Server? Microsoft offers free, Pro, and Premium licensing options for Power BI in the cloud.

May 10, 2020 Read