Data Management & Analytics

This assignment focuses on decluttering a bar chart by:

​

• Removing unnecessary elements (gridlines, borders, redundant labels).

• Simplifying the visual design while maintaining clarity.

• Enhancing focus on the key message of the data.

​​

According to Storytelling with Data by Cole Nussbaumer Knaflic (2020), 

Gestalt Principles,  including proximity, similarity, enclosure, continuity, and connection, can also significantly improve data visualizations.

Entity Relationship Diagrams (ERDs) are useful for visualizing database structure, relationships, and how data flows between tables. They help with:

• Mapping out tables, primary keys (PKs), and foreign keys (FKs).

• Understanding Relationships (one-to-one, one-to-many, and many-to-many relationships).

This spreadsheet showcases data-cleaning techniques using a large dataset generated via Python. Techniques include:

​

• Text to Columns

• SUBSTITUTE Function

• TRIM Function

This spreadsheet covers fundamental Excel concepts:

​

• Data Validation (Menu): Restricting field inputs to a predefined list.

• Named Ranges: Defining a specific block of cells for easier referencing.

• Error Handling: Providing feedback to users when invalid data is entered.

This spreadsheet explores how contextual menus dynamically update based on cell values. Concepts include:

 

• INDIRECT Function: Populating menu options based on another cell’s content.

• Conditional Formatting: Changing cell appearances based on logical rules (red for debits, green for credits).

This file focuses on data lookups in cost estimation:

​

• VLOOKUP for searching within variable rows and columns.

• Nested MATCH Statements for refining searches.

• SUMIF Function to calculate sums based on conditions.

This spreadsheet explores complex lookup functions and logical formatting. Features include:

​

• VLOOKUP & HLOOKUP to retrieve data dynamically.

• MATCH statements for custom searches.

• Conditional Formatting with AND/OR/NOT Logic.

This spreadsheet calculates key digital marketing performance indicators, such as:

• CPM, CPC, CTR, CPA

• Conversion Rate & Profit per Order

This Tableau Prep file processes data received from Graphic Communication students for Tableau Desktop use. The flowchart above mainly features data cleaning. Other useful techniques include:​

​

• Joins and Unions to combine data from two tables

• ​Aggregation to summarize data by grouping values and performing calculations.

This Tableau Prep file processes data received from Graphic Communication students for Tableau Desktop use. The flowchart above mainly features data cleaning. Other useful techniques include:​

​

• Joins and Unions to combine data from two tables

• ​Aggregation to summarize data by grouping values and performing calculations.

This Tableau project includes sophisticated visualizations analyzing video game data Features include:

​

• KPI Cards to quickly communicate key statistics without needing detailed analysis (e.g. "Total Video Games Released")

• Treemaps to show proportions and compare categories.

• Line Graphs & Bar Charts

This Tableau story about Airbnbs in San Mateo in 2023-2024 consists of multiple worksheets and dashboards, each featuring insightful data visualizations. A Tableau story allows for:

​

• Step-by-step analysis showing how data changes over time or how different metrics interact.

• Data-driven narratives that walk users through key insights.

• User-guided interactions where users can click through different pages to explore data.