Project Information

September 2023

I utilized Excel and Power BI to tackle an academic challenge, collecting and cleaning relevant data before applying fundamental predictive modeling techniques. Through exploratory data analysis, I gained insights into patterns and trends, and subsequently interpreted and communicated the results. The project not only demonstrated foundational skills in data analysis but also provided actionable recommendations, showcasing a practical application of Excel and Power BI in addressing academic scenarios

​

Business Opportunities:

​

• Partner with local cafes and restaurants to feature your lemonade on their menus.

​

• Create special promotions and marketing campaigns during peak seasons or weather conditions when demand for refreshing beverages is high.

​

Key Skills: 

​

• Advanced Excel Functions and Formulas

• Data Accuracy and Integrity Assurance

• Power BI Dashboard Creation

• Inferential Statistical 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

​