Legal Aid Qld Case Study
[/et_pb_text][/et_pb_column][/et_pb_row][/et_pb_section][et_pb_section admin_label=”section” fullwidth=”off” specialty=”off” background_color=”#ffffff” inner_shadow=”off” parallax=”off”][et_pb_row admin_label=”row”][et_pb_column type=”1_2″][et_pb_text admin_label=”Text” background_layout=”light” text_orientation=”left” use_border_color=”off” border_color=”#ffffff” border_style=”solid”]The Challenge
Legal Aid Queensland provides legal help to financially disadvantaged Queenslanders. They provide litigation and dispute resolution services via an in-house legal practice and network of preferred supplier law firms from around the state, to maximise legal services available to disadvantaged Queenslanders. LAQ needed to improve the efficiency and reliability of its reporting infrastructure and improve its ability to deliver insights into their In-house legal practice, Grants, Income and Expenditure and Government mandated reporting. [/et_pb_text][/et_pb_column][et_pb_column type=”1_2″][et_pb_text admin_label=”Text” background_layout=”light” text_orientation=”left” use_border_color=”off” border_color=”#ffffff” border_style=”solid”]
The Solution
Legal Aid Queensland built a business intelligence solution supporting 7 business areas including legal case work, legal advice, duty lawyer, conferencing, time recording, lawyer income, financial provisioning and payroll. Legal Aid built a data warehouse using Dimodelo Data Warehouse Studio. The data warehouse was built with 28 Dimension and 20 Facts in just 79 days. The effort included gathering requirements, installing and configuring an SQL Server 2012/SharePoint environment, developing the Data Warehouse and ETL using Dimodelo Data Warehouse Studio, creating a cube with many complex measures, data security, several reports, implementing the ETL workflow and deploying to a UAT and Production environments. Dimodelo Solutions were used to build the business intelligence solution and mentored 2 data analysts throughout the development process providing hands on training and helping them become self-sufficient. [/et_pb_text][/et_pb_column][/et_pb_row][/et_pb_section][et_pb_section admin_label=”section” fullwidth=”off” specialty=”off” background_color=”#353535″ inner_shadow=”off” parallax=”off”][et_pb_row admin_label=”row”][et_pb_column type=”1_4″][et_pb_number_counter admin_label=”Number Counter” title=”Staging Tables” number=”113″ percent_sign=”off” background_layout=”dark” counter_color=”#2ea3f2″ use_border_color=”off” border_color=”#ffffff” border_style=”solid” title_font_size=”16″ number_font_size=”72″] [/et_pb_number_counter][/et_pb_column][et_pb_column type=”1_4″][et_pb_number_counter admin_label=”Number Counter” title=”Dimensions” number=”28″ percent_sign=”off” background_layout=”dark” counter_color=”#2EA3F2″ use_border_color=”off” border_color=”#ffffff” border_style=”solid” title_font_size=”16″ number_font_size=”72″] [/et_pb_number_counter][/et_pb_column][et_pb_column type=”1_4″][et_pb_number_counter admin_label=”Number Counter” title=”Facts” number=”20″ percent_sign=”off” background_layout=”dark” counter_color=”#2EA3F2″ use_border_color=”off” border_color=”#ffffff” border_style=”solid” title_font_size=”16″ number_font_size=”72″] [/et_pb_number_counter][/et_pb_column][et_pb_column type=”1_4″][et_pb_number_counter admin_label=”Number Counter” title=”Days” number=”79″ percent_sign=”off” background_layout=”dark” counter_color=”#f2622e” use_border_color=”off” border_color=”#ffffff” border_style=”solid” title_font_size=”16″ number_font_size=”72″] [/et_pb_number_counter][/et_pb_column][/et_pb_row][/et_pb_section][et_pb_section admin_label=”section” fullwidth=”off” specialty=”off” background_color=”#2ea3f2″ inner_shadow=”off” parallax=”off”][et_pb_row admin_label=”row”][et_pb_column type=”1_2″][et_pb_text admin_label=”Text” background_layout=”dark” text_orientation=”left” use_border_color=”off” border_color=”#ffffff” border_style=”solid”]