[et_pb_section admin_label=”section” background_color=”#056fa0″ inner_shadow=”off” parallax=”on” transparent_background=”off” allow_player_pause=”off” parallax_method=”off” padding_mobile=”off” make_fullwidth=”off” use_custom_width=”off” width_unit=”on” make_equal=”off” use_custom_gutter=”off”][et_pb_row admin_label=”row”][et_pb_column type=”4_4″][et_pb_blurb admin_label=”Blurb” url_new_window=”off” image=”https://www.dimodelo.com/wp-content/uploads/Legal_Aid_logo.png” animation=”bottom” background_layout=”light” text_orientation=”center” use_icon=”off” icon_color=”#45c4ec” use_circle=”off” circle_color=”#45c4ec” use_circle_border=”off” circle_border_color=”#45c4ec” icon_placement=”top” use_icon_font_size=”off” use_border_color=”off” border_color=”#ffffff” border_style=”solid”] [/et_pb_blurb][/et_pb_column][/et_pb_row][et_pb_row admin_label=”row”][et_pb_column type=”4_4″][et_pb_text admin_label=”Text” background_layout=”dark” text_orientation=”center” use_border_color=”off” border_color=”#ffffff” border_style=”solid”]

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”]

Legal Aid Qld can now:

[/et_pb_text][et_pb_blurb admin_label=”Blurb” title=”In-house Legal Team Performance” url_new_window=”off” use_icon=”on” font_icon=”%%92%%” icon_color=”#ffffff” use_circle=”off” circle_color=”#2caaca” use_circle_border=”off” circle_border_color=”#2caaca” icon_placement=”left” animation=”right” background_layout=”dark” text_orientation=”left” use_icon_font_size=”off” use_border_color=”off” border_color=”#ffffff” border_style=”solid”] Understand how the legal team is performing against target on key measures related to Case Work, Conferencing, Duty Lawyer and Legal Advice. [/et_pb_blurb][et_pb_blurb admin_label=”Blurb” title=”Improve Grants Efficiency” url_new_window=”off” use_icon=”on” font_icon=”” icon_color=”#ffffff” use_circle=”off” circle_color=”#2caaca” use_circle_border=”off” circle_border_color=”#2caaca” icon_placement=”left” animation=”right” background_layout=”dark” text_orientation=”left” use_icon_font_size=”off” use_border_color=”off” border_color=”#ffffff” border_style=”solid”] Provide feedback to Grants officers, balancing efficiency measures with quality measures to deliver the right outcome for the community and clients. [/et_pb_blurb][et_pb_blurb admin_label=”Blurb” title=”Income and Expenditure and Provisioning” url_new_window=”off” use_icon=”on” font_icon=”” icon_color=”#ffffff” use_circle=”off” circle_color=”#2caaca” use_circle_border=”off” circle_border_color=”#2caaca” icon_placement=”left” animation=”right” background_layout=”dark” text_orientation=”left” use_icon_font_size=”off” use_border_color=”off” border_color=”#ffffff” border_style=”solid”] Build a detailed provisioning model into daily processing to automate provisioning and understand provisioning requirements on a daily/weekly/monthly/annual basis. [/et_pb_blurb][/et_pb_column][et_pb_column type=”1_2″][et_pb_cta admin_label=”Call To Action” title=”The Results Were Amazing” button_url=”https://www.dimodelo.com/request-a-demo/” button_text=”Request Demo” use_background_color=”off” background_color=”#2ea3f2″ background_layout=”dark” text_orientation=”left” url_new_window=”off” use_border_color=”off” border_color=”#ffffff” border_style=”solid” custom_button=”off” button_letter_spacing=”0″ button_use_icon=”default” button_icon_placement=”right” button_on_hover=”on” button_letter_spacing_hover=”0″] Find out how Dimodelo Data Warehouse Studio can save you time and money on your Business Intelligence project. [/et_pb_cta][/et_pb_column][/et_pb_row][/et_pb_section]