get_pbi_dashboard_london: Create files necessary for FFP London's Power BI dashboard

In caldwellst/fightr: Tools for Fight for Peace Data

Description

get_pbi_dashboard_london() takes in the parsed databases coming from parse_session_database() or parse_multiple_session_databases() and produces the data frames necessary for use in FFP London's Power BI dashboards. The function exports a list of data frames that will go into the dashboards in R, and also exports them in Excel to a specified file path.

Usage

get_pbi_dashboard_london(pd, file = NULL, ...)

Arguments

pd	Parsed database list coming out of parse_session_database() or parse_multiple_session_databases() with sessions, attendance, and attendees data frames.
file	If not NULL, file name and path for writing, must end in ".xlsx". If NULL, no Excel file is generated.
...	Additional arguments passed to openxlsx::write.xlsx().

Details

The data frames filter data based on a specific set of attributes. Specifically:

• Open Access filters data for sessions where project == "Open Access"

• Employability filters data for sessions where project == "Employment"

• Pathways filters data for sessions where activity_group == "Pathways"

• Special Project filters data for sessions where project == "Special Project"

• Youth leadership filters data for sessions where project == "Youth Leadership"

Relevant columns are then selected for each of these activity groups, written to Excel, and exported as a list.

Value

A list of data frames, and Excel file printed to file.

caldwellst/fightr documentation built on July 4, 2021, 8:50 a.m.