Ir al contenido principal

Budget Analysis

Budget Analysis

Having tables with the income, expected income, expenses and expected expenses, more measures were modeled: Utility and expected utility, this is, income – expenses and expected income – expected expenses; balance and expected balance, this is, a cumulative monthly sum of utility and expected utility, respectively. Finally, the performance of each factual measure compared with its expectations, this is: income quota (income/expected income), expenses quota (expenses/expected expenses), utility quota (utility/expected utility) and balance quota (balance/ expected balance).

The Dashboard:

The page ‘Principal’ has the quotas for income, expenses, utility and balance, and links to the correspondent pages, for more detailed information on each element.

The second page, income quota, shows the performance of this measure per month (area chart), a multi row card with its performance by category (online, other) and a line chart with a time line showing each category result. This page has a link just below the area chart visualization, that takes to the third report page, for more detailed information about income and expected income per category.

The fourth page has information about the expenses quota with the same structure as the one for the income quota: area chart, multi row card, line chart and the link below the area chart for detailed information on expenses and expected expenses per category, in the fifth page.

The next two pages have the information about the utility quota, keeping the same structure: area chart, multi row card and line chart, tracking the behavior of this variable per month and category. Also, it has the link to the next page, for detailed information about utility and expected utility per month and category, besides a table that includes the income and expenses quota for comparison with utility quota.

Finally, it’s the balance quota page, that follows this variable over time using a line chart and a table.

All pages have filters for year and month on the headline.

You can acces the dashboard HERE.  


Comentarios

Entradas populares de este blog

HR Analysis

HR Analysis This dashboard showcases human resources information for a company based on the number of employees, their salaries, and the results from a performance evaluation test. The information is presented across three pages, which can be navigated using bookmarks: Total Employees, Salary Analysis, and Performance Evaluation. In the Total Employees section, data on all company employees is displayed according to the department they belong to (vertical bar chart), their location (bubble map), and their distribution by age group, salary range, and evaluation outcome, shown in horizontal bar charts. At the top of the dashboard, five cards interact with all visualizations, displaying average age, average evaluation, total employees, average salary, and gender division for each selection made. Finally, a table with specific information about each employee is presented, maintained across the three report pages. In the Salary Analysis section, information on the average salary and total

Historical Sales of Video Games

Historical Sales of Video Games This dashboard compiles a historical record of video game sales worldwide, allowing information to be segmented by year, region, genre, platform, and publisher. The dashboard features filters at the top, next to the title; a card to present the totals of the selected criteria; a ring chart showing total sales by region, a vertical bar chart with yearly results from 1980 to 2017 for each region; two horizontal bar charts for viewing results by region, platform, and genre; and a table detailing each sold game. Key Findings: Video game sales experienced a boost starting in 1996, when sales records (199 million) more than doubled from the previous year (88 million). From this point, video game sales saw a steady increase until 2008, after which they began to decline, reaching 1989 levels in 2016 (approximately 70 million) and nearly vanishing in 2017 (only 5 million copies sold). Regarding regions, the United States has seen the highest sales, followed by

Black Friday

Black Friday Dashboard analyzing the purchasing behavior of a company's clients, according to three outcomes: i) Total purchases, ii) Average purchases, and iii) Number of clients. The dashboard displays these results by categories of gender, city category, marital status (married/single), age group, client occupation, and product category. Access dashboard here.