Our Work

Employee Scorecard

This report provides job performance details of employees within a company. Employee performance is broken down by category and metrics within a category. Comparisons can be made between job titles and departments. This report is useful when there is a ranking system in place to measure performance by different metrics and categories.

Features and Benefits:

  • Disconnected data tables used as slicers
    Enables flexible filtering and visual simplicity

  • Dynamically changing metrics and categories
    Adjusts visuals dynamically, ensuring relevance and reducing clutter

  • Conditionally formatted symbols
    Identifies increases/decreases in employee ranking over time

  • Custom tooltips when hovering over visuals
    Adds contextual details without crowding the dashboard

  • Employee rollup table
    Enables hierarchy-level analysis with precise calculations via DAX measures

  • Dynamic titles with DAX measures
    Updates titles for content-aware, relevant visuals

 

COVID-19 Report

A custom dashboard using data scraped from the Johns Hopkins CSSE COVID-19 repository on Github. The first page shows data for cases around the world, which can be filtered by country. The second page shows data for the US and can be sliced by state and county.

Features and Benefits:

  • Connected to John Hopkins GitHub repository
    Provides up-to-date, accurate data for real-time decision-making

  • Custom information buttons
    Offers direct access to external resources, improving clarity without clutter

  • Column chart colors based on DAX calculation
    Highlights growth from previous period, making data visually intuitive

  • Multi-row card displaying top-level metrics
    Offers clear performance snapshot

  • Gradient colored bars in bar chart
    Visually emphasizes growth intensity

 

Distributor Dashboard

This dashboard allows users to view product sales through their distributors. Contrasting colors, rounded edges and shadows are used to make important top level metrics pop out at first glance. Their positioning also does not detract from informational charts behind them. Year-to-date sales for each product category dynamically turn green or red depending on positive or negative year-over-year growth.

Features and Benefits:

  • KPI cards with rounded edges and shadows
    Modern, clean design, focuses on key metrics with minimal clutter

  • Custom cards with conditional formatting
    Highlights positive/negative growth from previous period, making trends immediately recognizable

  • Sparklines with markers
    Emphasizes critical data points for quick analysis