Charlie

When Keys Matter: Why Integer Relationships Outperform Text in Complex Power BI Models

After some research, it appears to be a general consensus in the community that the data type of relationship keys does not significantly impact visual performance in Power BI reports. And in many models, that is true. However, in real-world scenarios where multiple data sources are combined, relationships become increasingly complex. In some cases, this […]

When Keys Matter: Why Integer Relationships Outperform Text in Complex Power BI Models Read More »

PGA Tour Data Collection & Dashboard

First, scraped data from PGATour.com using the website’s GraphQL API and python libraries such as pandas. The data contains various stats for golfer’s from 2017-2022. Conducted Exploratory Data Analysis such as calculating summary statistics, visualizing distributions and relationships, detecting outliers, and checking for missing data. Additionally, performed correlation analysis to assess the relationships between different

PGA Tour Data Collection & Dashboard Read More »

Data Engineering: Microsoft Azure Data Model and Power BI Dashboard

I successfully designed and implemented a data integration solution using Azure Data Factory (ADF) to streamline data processing and analysis. The primary objective was to populate custom Azure SQL Database tables with data from multiple views, ensuring efficient data organization and retrieval. To achieve this, I created a robust data pipeline in ADF that extracted

Data Engineering: Microsoft Azure Data Model and Power BI Dashboard Read More »