Power BI Sample Dashboards

Sales Analysis Power BI Dashboard

One of the most common dashboards we develop for our clients is for Sales Analysis. Most business organizations have a lot of sales data available in the form of customer invoices or customer sales orders. This data can be presented very effectively on a Power BI Dashboard. This dashboard typically offers real-time insights into sales trends, sales increases and decreases, sales by product, sales by sales rep, sales by customer, and sales by region. These insights can help you identify issues such as lost customers or competitive challenges.

SALES BY PRODUCT

315-RUI-650 10.7% 315-RUI-650 10.7% 10.53% 710-ROM-432 10.53% 10.4… 200-ACE-540 10.41% 10.02% 290-RSH-077 10.02% 820-TOH-210 10.01% 820-TOH-210 10.01% 9.95% 500-WEN-354 9.95% 9.94% 410-GIA-608 9.94% 9.81% 100-AXC-101 9.81% 9.77% 103-GFD-900 9.77% 118-NOM-305 8.88% 118-NOM-305 8.88% 710-ROM-432 10.53% 200-ACE-540 10.41% 290-RSH-077 10.02% 500-WEN-354 9.95% 410-GIA-608 9.94% 100-AXC-101 9.81% 103-GFD-900 9.77%

SALES

100% 100% 103.8% 103.8% 2020202020212021 $6.77M $7.03M

SALES BY MONTH VS. LAST YEAR

$0.0M $0.0M $0.2M $0.2M $0.4M $0.4M $0.6M $0.6M Month Month Sales_2021 Sales_202101-JAN 01-JAN 02-FEB 02-FEB 03-MAR 03-MAR 04-APR 04-APR 05-MAY 05-MAY 06-JUN 06-JUN 07-JUL 07-JUL 08-AUG 08-AUG 09-SEP 09-SEP 10-OCT 10-OCT 11-NOV 11-NOV 12-DEC 12-DEC $0.61M $0.53M $0.68M $0.54M $0.58M $0.61M $0.55M $0.59M $0.59M

SLICERS

  • Region (Not yet applied): Midwest, North East, North West, South East, South West
  • SalesRep (Not yet applied): Elliot Moses, Erin Walls, Janessa Wright, Jerome Green, Stephan Lam
  • Product (Not yet applied): 100-AXC-101, 103-GFD-900, 118-NOM-305, 200-ACE-540, 290-RSH-077, 315-RUI-650, 410-GIA-608
  • Customer (Not yet applied): Admire Arts, Bloom Marketing, Bonefete Fun, Bravura Inc., Brean Sports, Candor Corp, Cipher Publishing, Cogent Data, Eco Focus, Epic Adventure Inc., Erudite Learning
  • Year (Not yet applied): 2020, 2021

$/INVOICE

100% 100% 99.3% 99.3% 2020202020212021 $2,771 $2,751

SALES BY REP

20.34% Jerome Green 20.34% 20.24% Stephan Lam 20.24% 19.96% Elliot Moses 19.96% 19.77% Erin Walls 19.77% 19.68% Janessa Wright 19.68%

SALES BY REGION

SALES INCREASES BY CUSTOMER

Sales_Change Sales_Change Customer Customer Bravura Inc. Bravura Inc. Candor Corp Candor Corp Flux Water … Flux Water Gear Office Title Office Title Quad Goals Quad Goals Lambent Ill… Lambent Illumination $0.11M $0.08M $0.06M $0.06M $0.05M $0.05M

SALES DECREASES BY CUSTOMER

Sales_Change Sales_Change Customer Customer Cipher Publ… Cipher Publishing Eco Focus Eco Focus Vortex Solar Vortex Solar Admire Arts Admire Arts Inspire Fitn… Inspire Fitness Cogent Data Cogent Data ($49K) ($38K) ($35K) ($31K) ($30K) ($28K)

Project Management Power BI Dashboard

Project Managers deal with complex data including projects, project dates, tasks, task dependencies, task dates, task effort, resources, resource loading, and more. A well-designed Power BI Dashboard can help bring clarity to a Project Manager’s job by organizing this data effectively. Power BI includes helpful project-oriented visualizations such as a Gantt chart timeline and a resource loading matrix. The manager will have instant insights into past due tasks, resource overload situations, at-risk timelines, and more.

ACTIVE PROJECTS

12

ACTIVE PROJECTS TIMELINE

Custom Visual Host v2+ Door Rout... Door Route Ship Shape Lib... Shape Library Hammer Cloud Bell... Cloud Bell Bridge Door Cloc... Door Clock Paint Force Tra... Force Trade Picture Trade Wre... Trade Wrench Design Memory F... Memory Floor Branch Window S... Window Slope Bell Wrench Tr... Wrench Train Branch Island Ed... Island Education Water Frame Bul... Frame Bulb Ship Silver Pict... Silver Picture Desk Sep 19 Sep 26 Oct 03 Oct 10 Oct 17 Oct 24 Oct 31 Nov 07 Nov 14 Nov 21 Nov 28

Active Projects By PM

JG 5 JG 5 EM 3 EM 3 2 JW 2 EW 1 EW 1 SL 1 SL 1 JW JW 2

Open Tasks

Row Selection ProjectName TaskName Resource StartDate EndDate % Complete PlanHours ActualHours Rating Select Row

  • Floor Bridge Floor Develop Go To Market Plan Allen Leblanc 10/10/2021 10/16/2021 120% data bar 96% 20 24
  • Silver Picture Desk Develop Go To Market Plan Allen Leblanc 11/21/2021 11/27/2021 35% data bar 28% 20 7
  • Circle Wrench Shape Develop Go To Market Plan Cassius Durham 10/10/2021 10/16/2021 10% data bar 8% 20 2
  • Door Route Ship Develop Go To Market Plan Cassius Durham 10/17/2021 10/23/2021 35% data bar 28% 20 7
  • Frame Bulb Ship Develop Go To Market Plan Cassius Durham 11/21/2021 11/27/2021 100% data bar 80% 20 20
  • Memory Floor Branch Develop Go To Market Plan Cassius Durham 10/31/2021 11/6/2021 80% data bar 64% 20 16
  • Shape Library Hammer Develop Go To Market Plan Cassius Durham 10/17/2021 10/23/2021 75% data bar 60% 20 15

PAST DUE TASKS

18

Active Employees By Type

1204 (49.83%) Full-Time 1204 (49.83%) 618 (25.58%) Temporary 618 (25.58%) 594 (24.59%) Part-Time 594 (24.59%)

TOTAL WAGES

100% 100% 103% 103% LYR LYR CYR CYR $147.0M $151.4M

NEW HIRES

149 116

ACTIVE EMPLOYEES

2416

ACTIVE EMPLOYEES BY RACE

1747 (72.31%) White 186 (7.7%) African American 166 (6.87%) Hispanic/Latino 164 (6.79%) Other

ACTIVE EMPLOYEES BY TENURE

1299 (53.77%) 10+ Years 557 (23.05%) 5-10 Years 343 (14.2%) 2-5 Years 217 (8.98%) 0-2 Years