Sales Executive Dashboard
Jogleen Calipon
This sample project explored sales trends from the fiscal years 2018 to 2020 to identify patterns and find business opportunities in today’s market.
The dataset can be found and downloaded for your reference on Kaggle
Tools Used for this Project: Power Query, Data Modeling, DAX, and Power BI
Screenshot of the Table View
Screenshot of the data modeling in Model Pane
And lastly, the final output after data modeling
Subscribe to my newsletter
Read articles from Jogleen Calipon directly inside your inbox. Subscribe to the newsletter, and don't miss out.
Written by
Jogleen Calipon
Jogleen Calipon
My name is Jogleen, and I am a Data Analyst with over four years of experience in transforming data into actionable insights. I have strong skills in the following areas: Data Analysis & Visualization Power BI: Creating dashboards, using DAX, data modeling, and Power Query. Excel: Performing ETL (Extract, Transform, Load) processes, utilizing advanced functions such as VLOOKUP, INDEX-MATCH, and SUMIFS, along with Power Pivot and Power Query. Python: Leveraging data analysis libraries, including Pandas, NumPy, and Matplotlib. R: Conducting analysis and visualization using dplyr, ggplot2, tidyr, and Shiny. Database Management SQL: Executing queries, performing data extraction and manipulation, and designing databases. Project Management & Collaboration GitHub: Utilizing version control and repository management. Jupyter/Google Colab: Working in collaborative notebook environments for both Python and R analyses. Environment Management Anaconda: Managing environments and packages for R and Python projects. I am dedicated to helping businesses make informed decisions. Feel free to explore my projects, and I welcome any connections for potential collaborations!