Passionate data enthusiast showcasing dashboards, analyses and insights from self-driven projects with Excel, SQL, Tableau, PowerBI and Python @Ecometrikx
In this project, I developed an automated file sorter for my data analysis training materials using Jupyter Notebooks and Python, streamlining the organization of files within my file explorer. For the execution of this project, I drew on the knowledge and guidance from the Data Analyst Bootcamp of AlexTheAnalyst hosted on YouTube.
I built a test notebook to explore and interact with a cryptocurrency API using Jupyter Notebooks and Python. Drawing on the Data Analyst Bootcamp by AlexTheAnalyst, I customized the concepts to fit my project needs, allowing me to analyze real-time data and gain practical experience with API integrations.
I worked on a project focused on data cleaning using SQL to process a raw Excel file from Kaggle containing housing data for Nashville, Tennessee. Drawing on techniques and guidance from the Data Analyst Bootcamp by AlexTheAnalyst, I customized my approach to transform the dataset for improved accuracy and usability in analysis.
I built a simple dynamic Excel dashboard using a publicly available dataset on international bike sales. Drawing on techniques and guidance from the Data Analyst Bootcamp by AlexTheAnalyst, I customized my approach to create an interactive visualization tailored to my analysis needs.
I built a simple dynamic dashboard using Microsoft Power BI and Power Query, summarizing data from a publicly available professional survey sourced from Kaggle. Drawing on techniques and guidance from the Data Analyst Bootcamp by AlexTheAnalyst, I customized my approach to create an interactive visualization tailored to highlight key insights from the survey data.
I web scraped a Wikipedia page containing a list of the top 10 private U.S. companies by revenue using Jupyter Notebooks, Python, and the Pandas library. Drawing on techniques and guidance from the Data Analyst Bootcamp by AlexTheAnalyst, I customized my approach to extract and analyze the data efficiently. I ensured compliance with ethical standards and legal guidelines related to web scraping, respecting the terms of service of the source website to maintain integrity in my data collection practices.
Work-in-Progress!
Hamburg, Germany