Embedded Files
Hello, I'm Eric.
I'm a creative and detail-oriented Graphic Designer turned Data Analyst with a strong foundation in data visualization, storytelling, and user-centric design. Passionate about turning complex problems and datasets into actionable insights through clear, compelling visuals and analysis.
Technical Abilities
Languages & Tools – SQL, Excel, Power BI, Tableau, Python (In Progress), HTML, CSS, Atlassian Jira, Microsoft Office, Google Workspace
Concepts – Data Cleaning, Exploratory Data Analysis, Data Visualization, A/B Testing, Competitive Analysis
Design Tools – Adobe Creative Suite: Photoshop, Illustrator, InDesign, XD, Acrobat, Figma
Projects
Classic Models Sales Performance
Project completed as part of Udemy Data Analysis program. Used real company data and were posed with questions from a simulated stakeholder in the company looking to display different metrics.
Utilized SQL to create a database, import the raw data, and used string and date functions to standardize and clean the data in preparation for analysis. Within the SQL database, performed some more complex queries to explore the dataset and find answers to stakeholder questions. This exploration informed what visualizations to include in the dashboard.
Power BI was connected to the SQL database to create an interactive dashboard which visualized Net Profit and Sales by Product Line, Cost of Sales, and Country. All cards were filterable by date in addition to having a running monthly sale breakdown.
View the source code on Github and the dashboard on Power BI.
Netflix Shows and Movie Data
Project completed as part of Udemy Data Analysis program. Data on Netflix Shows and Movies was provided to process in Excel and display in Power BI.
In Excel, the raw data was standardized and complex fields that contained multiple entries were separated into their own tables to make the data easier to parse. From Excel, the cleaned data was then imported to create a relational SQL database.
Power BI was connected to the SQL database to create an interactive dashboard that visualized Shows by Date, Rating, Genre, and Countries Available. Additionally, individual Shows could be selected from a dropdown to view their specific data breakdown.
View the source code on Github and the dashboard on Power BI.
Washington Electric Vehicle Data
Project completed as part of Udemy Data Analysis program. Data was sourced from Data.gov in order to create a Tableau dashboard.
Dashboard displays a selector for Car Make and breaks down Vehicle Type, Quantity by County, Postal Code Map, and Vehicle Year for each Make. Totals for each Make and Model highlight when the Make is selected.
View the dashboard on Tableau Public.
Bike Sales Data
Project completed as part of Udemy Data Analysis program. Data was sourced from kaggle.com in order to create a Tableau dashboard.
Dashboard displays Sales data based on the Year and Countries selected. For each Year, Sales are displayed by Top 10 Products, Customer Gender, Customer Age, plus overall Revenue, Profit, and Year-over-year Change.
View the dashboard on Tableau Public.
Report abuse