Tru Walor

Data Analysis and Visualization

  • 21 Views

$50.00

(per hour)

Featured Services

Description

I have over ten years of cumulative professional work experience in Business Development, Sales, Finance, Operations, and Project Management. I enjoy problem solving and helping businesses make more efficient data driven decisions. I specialize in Power BI dashboard creation, editing, and “fixing” errors within existing dashboards; as well as Financial Data Analysis within Excel Dashboards. I am proficient in DAX, creating automated refreshes, bookmarks, M code, ETL, etc. I have worked with extremely large (and confidential) datasets so I can handle any data that is thrown at me. I enjoy having some direction but putting my own spin on dashboard and visualizations when possible. I have created many Power BI and Excel dashboards for clients within the Medical, Construction, Finance, and Marketing industries.

 

 

My most recent project consisted of a Power BI dashboard (and a corresponding Excel Dashboard linked to it) that contained sales data from an ERP system as & cost data from the client. I created many different visualizations to help them decide which specific zip code areas had the best conversion rates, marketing cost, leads, GSA, etc. so they could invest in better ad spend. 

 

I work full time as a Financial Data Analyst and pick up projects in the slower months and my free time. I have a lot of experience with KPI calculations, QA testing, creating and maintaining complex financial dashboards, budgeting, and visualizations. While in college I studied business analytics focused on Machine Learning, Linear programing, and other business intelligence focusing on R studio and excel.  

 

I do have some background in taxation and government spending as well. My contracts are confidential so I am not able to share too many specific details but I am happy to answer questions and share more about the skills I have/use.

I have had some exposure to VBA, SQL, R, Python, and Tableau, and I am currently working on expanding and improving these skills. If there is a project requiring these skills I would be happy to work at a reduced rate while I gain more experience in these areas. 

Experience

Power BI and Data Analytics Consultant

  • Self Employed
  • January 1, 2023 - continue

• Utilizes M code, DAX, Bookmarks, etc. in order to develop, maintain, and automate Power BI reports & dashboards. • Interacts with clients to understand business needs/goals and translates these into digestible visualizations and dashboards. • Extracts, transforms, and loads (ETL) data from various sources into Power BI. • Optimizes Microsoft Power BI dashboards with a focus on usability, performance, and accuracy. • Performs data analysis, data validation, data mapping/design, and produces ad-hoc reports. • Examines and evaluates current systems, troubleshoots data-related issues, and provides input on process and dashboard improvements.

Financial Data Analyst

  • April 10, 2023 - continue

• Builds and runs complex, detailed and accurate financial models for projects in multiple jurisdictions with a focus on K-12 school districts • Research, organize, analyze, and visualize data to provide insights with metric driven data into new and creative opportunities to both target and fund projects • Expert in Power BI, Excel, and maintaining large databases • Understands and models detailed tax (federal, state and local) legislation/implications and incentives for projects as well as preparing Government Body submissions and Contracts between clients and SitelogiQ • Maintains large databases and documents with the latest information including but not limited to construction indices, finance rates, municipal data and internal targeting databases/tools • Provides training and support to business users in the effective use of Power BI and Excel dashboards

Educational Details

Bachelors of Science in Business Administration (BSBA)

  • Drexel University
  • September 1, 2016 - September 1, 2020

Triple Major in Finance, Business Analytics, and Operations & Supply Chain Management

Report Freelancer

Ready To Get Started

QWIRK is a brand owned by Gigart Solutions Incorporation, Delaware, USA. The company is a freelance marketplace to help firms find quality professionals when needed, to be a part of your workforce.