I am a Canadian/Peruvian data analyst and business consultant with 14 years of experience based in Mont-Tremblant, Quebec, Canada. I love digging deep into data, using tools like SQL, Python, Apache Spark, Snowflake, Power BI, Tableau and Looker Studio to find answers that others might miss. My work with big names like Coca Cola, PepsiCo, Alicorp, Danper, and projects in Costa Rica, Colombia, Mexico, Peru, Argentina (to mention just some) have shown me the power of data in making a real difference.
Outside of work, you might find me on the tennis court 🎾, playing soccer ⚽, or snowboarding 🏂🏻 down a slope.
DATA VISUALIZATION TOOLS
DATA PROCESSING & ANALYSIS TOOLS
LANGUAGES
Portfolio
Training Oversight Dashboards
Developed a suite of 13 dashboards to monitor the progress of online training for thousands of small and medium-sized enterprises. Leveraged AWS, Power BI, Sharepoint, and SQL to ensure seamless data integration and visualization. Implemented row-level security to maintain data confidentiality and integrity.
Used Tools: SQL, Power BI Desktop and Service, Python (Pandas), Sharepoint, Excel, Google Sheet, Google Drive, Power Automate
Performance Analysis Dashboard
Designed a Power BI dashboard integrated with Excel and SQL to track and evaluate the performance of consultants against set goals. The dashboard provided insights into individual achievements, helping in performance assessment and strategic decision-making.
Multi-Country Project Overview Dashboard
Created a Power BI dashboard to present a consolidated view of Fundes' projects across various countries. The dashboard offered a clear snapshot of project statuses, aiding in efficient management and coordination.
Agroexport Potential Insights Dashboard
Developed an interactive Power BI dashboard to visualize survey insights from small and medium-sized Costa Rican companies with agroexport potential. The dashboard featured an interactive map, providing a geographical breakdown of the data and highlighting key areas of interest.
US Market Trends (2015-2021)
Conducted a comprehensive analysis of avocado sales in the US from 2015 to 2021 using SQL. The project delved into sales trends, seasonal variations, and market growth, providing valuable insights into the avocado market dynamics.
Les Laurentides Housing Market Analysis
Performed an in-depth analysis of the housing market in the Les Laurentides region of Quebec, Canada. Utilized SQL and Python for data extraction and manipulation, and presented the findings through visually compelling Tableau dashboards. The analysis provided insights into pricing trends, property types, and market demand.
Contact
Get in touch with Daniel Hernandez