May 2023

I applied advanced functions and formulas in Excel to meticulously ensure the accuracy and integrity of the data. The focal point of the project was the creation of a Power BI dashboard, wherein I demonstrated proficiency in analyzing baseball league statistics.

​

My expertise extended to crafting complex Data Analysis Expressions (DAX) functions within Power BI, enabling the display of intricate trends identified within the dataset. To enhance the user experience and facilitate in-depth exploration, I designed visualizations with Drill-Through capabilities, strategic filters, and parameter controls, providing a comprehensive and interactive perspective on the analyzed data

​

Business Opportunities:

​

• Conduct longitudinal analysis of player and team performance over multiple seasons to identify trends and potential shifts in gameplay strategies.

• Explore the career trajectories of individual players, including performance peaks, declines, and any correlations with external factors.

• Compare player and team statistics across different eras of baseball to assess the impact of rule changes, equipment advancements, and other external factors.

​

Key Skills:

​

• Advanced Excel Functions and Formulas

• Data Accuracy and Integrity Assurance

• Power BI Dashboard Creation

• Baseball League Statistics Analysis

• Proficient in Writing Complex DAX Functions

• Trend Identification within Datasets

• Designing Visualizations with Drill-Through Capabilities

• Strategic Filters and Parameters Implementation

• Data Science for Exploratory Data Analysis