Automate & Streamline Processes for More Accurate Forecasting

/by

ANALYTICS | CASE STUDY

Automate & Streamline Processes for More Accurate Forecasting

COMPANY OVERVIEW


Employing nearly 5,600 people worldwide, the client is a U.S. based workforce management software and services company headquartered in Massachusetts. The client is a leading provider of workforce management and human capital management cloud solutions, offering the industry’s most powerful suite of tools and services to manage and engage an entire workforce from pre-hire to retire.

BUSINESS NEED


With a planned move to a SaaS model, the client had a need to measure the bottom line impact of migrating current customers to the cloud and providing prospective customers with the appropriate products and services to meet their unique needs. The calculations used in this process were variable by platform, product, and several other factors, and when done in Excel were time consuming and error prone due to a need to apply business rules to many scenarios.

SOLUTION


With the help of Alteryx to automate and bring flexibility to the revenue forecasting process, Ironside was able to optimize the calculations and produce a series of datasets to power visual insight, with a self-documented, visually represented workflow that eases supportability.


Discovery & Analysis


  • Worked collaboratively with the team responsible for maintaining the existing solution in Excel as well as the stakeholders who would leverage the output of the forecasts to make decisions to understand the business logic and business impact of the new workflow

  • Assessed the most effective data integration and transformation processes to use in the workflow design and created a high level design that was broken into 2 main modules


Develop First Iteration


  • Broke the development tasks into 2 iterations based on the 2 main modules in the workflow

  • Delivered value faster and incorporated feedback from the development and initial testing of the first module into the 2nd iteration


Develop Second Iteration


  • Focused on applying efficiency gains from lessons learned in the 1st iteration and on organizing and documenting the workflow for ease of future maintenance


Collaborative Testing


  • Facilitateed collaborative testing by holding several testing workshops focused on comparing the outputs of the original Excel solution and the new automated workflow

  • Incorporated the output of the Alteryx model into a data visualization platform

  • Quickly aggregated and drilled into any area of discrepancy to investigate differences and determine if there were any issues with the workflow’s business logic


KEYS TO SUCCESS


By automating their business forecasting process, the client now has the ability to:

  • Automate and streamline Excel-based processes to more quickly and accurately forecast revenue associated with a migration of customers to cloud-based applications

  • Create scalability and flexibility in the model workflow with automated data transformations that simplify calculations and allow for what-if analysis

  • Facilitate ease-of-use and business enablement through the use of self-documenting features to make the workflow easy to understand, interpret, and maintain

  • Support for troubleshooting and maintenance through the automatic generation of error and trace files

About Alteryx

Alteryx is an end-to-end platform that unifies the analytic experience, enabling organizations to break data barriers and solve business problems faster. It provides the analytic flexibility that business analysts, data scientists, and IT need to discover, prep, analyze, and operationalize analytic models through a collaborative and governed platform.

Alteryx logo
[av_section min_height='custom' min_height_px='0' padding='default' shadow='no-border-styling' bottom_border='no-border-styling' bottom_border_diagonal_color='#333333' bottom_border_diagonal_direction='' bottom_border_style='' custom_arrow_bg='' id='' color='main_color' custom_bg='' src='' attachment='' attachment_size='' attach='scroll' position='top left' repeat='no-repeat' video='' video_ratio='16:9' overlay_opacity='0.5' overlay_color='' overlay_pattern='' overlay_custom_pattern='' av_element_hidden_in_editor='0' custom_class='' av_uid='av-93vd1yh'] [av_one_full first min_height='' vertical_alignment='av-align-top' space='no_margin' margin='0px' margin_sync='true' padding='0px' padding_sync='true' border='' border_color='' radius='0px' radius_sync='true' background_color='' src='' attachment='' attachment_size='' background_position='top left' background_repeat='no-repeat' animation='pop-up' mobile_breaking='' mobile_display='' custom_class='' av_uid='av-8blbyo9'] [av_heading tag='h3' padding='0' heading='READ ADDITIONAL CASE STUDIES' color='' style='blockquote modern-quote modern-centered' custom_font='' size='' subheading_active='' subheading_size='15' custom_class='' admin_preview_bg='' av-desktop-hide='' av-medium-hide='' av-small-hide='' av-mini-hide='' av-medium-font-size-title='' av-small-font-size-title='' av-mini-font-size-title='' av-medium-font-size='' av-small-font-size='' av-mini-font-size='' av_uid='av-tl2oyx'][/av_heading] [/av_one_full] [/av_section] [av_tab_section transition='av-tab-slide-transition' padding='default' tab_pos='av-tab-above-content' content_height='' tab_padding='default' initial='3' id='' av_element_hidden_in_editor='0' av_admin_tab_active='4' bg_color='#f4f3f3' color='' av_uid='av-4iskq8s' custom_class=''] [av_tab_sub_section tab_title='Strategy' vertical_align='middle' icon_select='no' icon='ue800' font='entypo-fontello' tab_image='' tab_image_style='' color='' background_color='' src='' attachment='' attachment_size='' background_attachment='scroll' background_position='top left' background_repeat='no-repeat' custom_class='' av_uid='av-3ua41ek'] [av_masonry_entries link='portfolio_entries,1122' wc_prod_visible='' prod_order_by='' prod_order='' sort='no' items='3' columns='3' paginate='none' query_orderby='date' query_order='DESC' size='fixed' orientation='av-orientation-square' gap='large' overlay_fx='active' id='' caption_elements='title' caption_styling='overlay' caption_display='always' color='' custom_bg='' av-medium-columns='' av-small-columns='' av-mini-columns='' av_uid='av-3inv0xo' custom_class=''] [/av_tab_sub_section][av_tab_sub_section tab_title='Data' vertical_align='middle' icon_select='no' icon='ue800' font='entypo-fontello' tab_image='' tab_image_style='' color='' background_color='' src='' attachment='' attachment_size='' background_attachment='scroll' background_position='top left' background_repeat='no-repeat' custom_class='' av_uid='av-2x2nruk'] [av_masonry_entries link='portfolio_entries,1123' wc_prod_visible='' prod_order_by='' prod_order='' sort='no' items='3' columns='3' paginate='none' query_orderby='date' query_order='DESC' size='fixed' orientation='av-orientation-square' gap='large' overlay_fx='active' id='' caption_elements='title' caption_styling='overlay' caption_display='always' color='' custom_bg='' av-medium-columns='' av-small-columns='' av-mini-columns='' av_uid='av-2ibtovw' custom_class=''] [/av_tab_sub_section][av_tab_sub_section tab_title='Analytics' vertical_align='middle' icon_select='no' icon='ue800' font='entypo-fontello' tab_image='' tab_image_style='' color='' background_color='' src='' attachment='' attachment_size='' background_attachment='scroll' background_position='top left' background_repeat='no-repeat' custom_class='' av_uid='av-1ztjhss'] [av_masonry_entries link='portfolio_entries,1124' wc_prod_visible='' prod_order_by='' prod_order='' sort='no' items='3' columns='3' paginate='none' query_orderby='date' query_order='DESC' size='fixed' orientation='av-orientation-square' gap='large' overlay_fx='active' id='' caption_elements='title' caption_styling='overlay' caption_display='always' color='' custom_bg='' av-medium-columns='' av-small-columns='' av-mini-columns='' av_uid='av-1satp18' custom_class=''] [/av_tab_sub_section][av_tab_sub_section tab_title='Platform' vertical_align='middle' icon_select='no' icon='ue800' font='entypo-fontello' tab_image='' tab_image_style='' color='' background_color='' src='' attachment='' attachment_size='' background_attachment='scroll' background_position='top left' background_repeat='no-repeat' custom_class='' av_uid='av-14gy7h8'] [av_masonry_entries link='portfolio_entries,1125' wc_prod_visible='' prod_order_by='' prod_order='' sort='no' items='3' columns='3' paginate='none' query_orderby='date' query_order='DESC' size='fixed' orientation='av-orientation-square' gap='large' overlay_fx='active' id='' caption_elements='title' caption_styling='overlay' caption_display='always' color='' custom_bg='' av-medium-columns='' av-small-columns='' av-mini-columns='' av_uid='av-r6kews' custom_class=''] [/av_tab_sub_section][/av_tab_section]

[av_section min_height='' min_height_px='500px' padding='default' shadow='no-border-styling' bottom_border='no-border-styling' bottom_border_diagonal_color='#333333' bottom_border_diagonal_direction='' bottom_border_style='' custom_arrow_bg='' id='' color='main_color' custom_bg='' src='https://www.ironsidegroup.com/wp-content/uploads/2018/03/yellow-rudder-1500x630.png' attachment='16316' attachment_size='featured_large' attach='parallax' position='center center' repeat='no-repeat' video='' video_ratio='16:9' overlay_opacity='0.5' overlay_color='' overlay_pattern='' overlay_custom_pattern='' av_element_hidden_in_editor='0' custom_class='' av_uid='av-3e8pueh'] [av_one_full first min_height='' vertical_alignment='av-align-top' space='' margin='0px' margin_sync='true' padding='50px,0px,0px,0px' border='' border_color='' radius='10px,10px,0,' background_color='#ffffff' src='' attachment='' attachment_size='' background_position='top left' background_repeat='no-repeat' animation='' mobile_breaking='' mobile_display='' custom_class='' av_uid='av-320m815'] [av_heading tag='h2' padding='10' heading='Become one of our successful clients.' color='' style='blockquote modern-quote modern-centered' custom_font='' size='' subheading_active='' subheading_size='15' custom_class='' admin_preview_bg='' av-desktop-hide='' av-medium-hide='' av-small-hide='' av-mini-hide='' av-medium-font-size-title='' av-small-font-size-title='' av-mini-font-size-title='' av-medium-font-size='' av-small-font-size='' av-mini-font-size='' av_uid='av-2os9ax5'][/av_heading] [/av_one_full][av_one_fourth first min_height='av-equal-height-column' vertical_alignment='av-align-top' space='no_margin' margin='0px' margin_sync='true' padding='0px,0px,50px,0px' border='' border_color='' radius='0px,0px,0px,10px' background_color='#ffffff' src='' attachment='' attachment_size='' background_position='top left' background_repeat='no-repeat' animation='' mobile_breaking='' mobile_display='' custom_class='' av_uid='av-28fflmx'] [/av_one_fourth][av_one_half min_height='' vertical_alignment='av-align-top' space='' margin='0px' margin_sync='true' padding='30px,40px,50px,40px' border='' border_color='' radius='0px' radius_sync='true' background_color='#ffffff' src='' attachment='' attachment_size='' background_position='top left' background_repeat='no-repeat' animation='' mobile_breaking='' mobile_display='' custom_class='' av_uid='av-1rz7q7d'] [av_button_big label='Take our Data & Analytics Self-Assessment' description_pos='below' link='page,15594' link_target='' icon_select='no' icon='ue800' font='entypo-fontello' custom_font='#ffffff' color='custom' custom_bg='#00aec7' color_hover='theme-color' custom_bg_hover='#444444' custom_class='' admin_preview_bg='' av_uid='av-4pr12h'][/av_button_big] [/av_one_half][av_one_fourth min_height='' vertical_alignment='av-align-top' space='' margin='0px' margin_sync='true' padding='0px' padding_sync='true' border='' border_color='' radius='0px,0px,10px,0px' background_color='#ffffff' src='' attachment='' attachment_size='' background_position='top left' background_repeat='no-repeat' animation='' mobile_breaking='' mobile_display='' custom_class='' av_uid='av-2cum7d'] [/av_one_fourth] [/av_section]

Enable Current and Future Growth with Adaptive Insights

/by

ANALYTICS | CASE STUDY

Enable Current and Future Growth with Adaptive Insights

COMPANY OVERVIEW


A world leader in the development and manufacturing of state-of-the-art, whole blood, point-of-care and critical care analyzers, as well as providing the biotechnology industry with the most advanced instruments for cell culture monitoring. It is one of the fastest growing in vitro companies in the world.

BUSINESS NEED


The company’s FP&A team, along with the Controllers, needed an efficient tool and streamlined process to support the financial management of their continued growth. The company had several concerns they needed to address. The initial focus was on reporting financials after loading data from various general ledger systems in different countries. That process included eliminating intercompany balances – a crucial requirement and painful process before implementation of Adaptive.

These needs meant the company needed to reconsider the structural design instead of simply recreating their current structure. They were also looking for a more flexible and robust reporting platform – by products, territory, entity and more. The reporting application needed to have clear visuals and ease of drilling into activities. The implementation of a more user friendly and flexible budgeting and planning solution was much needed as well.

SOLUTION


Ironside’s FPM team thought outside of the box to propose the use of one system to accomplish their reporting, budgeting and consolidations needs and led the client’s implementation of the Adaptive Insights Planning and Consolidation CPM solution through the following phases:


Define the Design


  • Mapped out FP&A discovery project/plan

  • Conducted comprehensive discussions of key business requirements and translation of the client’s intercompany process from Excel to Adaptive


Build the Structure


  • Created Financial Reporting Structure (COA, dimensions, levels, attributes)

  • Integrated data with flat file imports

  • Established financial reporting that includes performance metrics, income statement, balance sheet and statement of cash flows

  • Implemented reporting and analytics capabilities (discovery dashboards)


Build the Financial Eliminations


  • Eliminated intercompany product sales models

  • Integrated with consolidation process


Implement Key Requirements


  • Allowed the ability to load actuals into uniform structure, eliminations and alternate reporting options

  • Supports an efficient, more transparent and more detailed reporting and consolidation process

  • Improved the ability to prepare monthly reporting and analyze results


KEYS TO SUCCESS


Through the implementation of Adaptive Insights for consolidations, budgeting and reporting, the client was able to:

  • Unify the view of actuals across entities, allowing immediate access to decision support

  • Reduce Controllership time through less manual processes to prepare and report intercompany eliminations

  • Improve collaboration with entity controllers in preparing budgets and forecasts

  • Increase time for analysis through faster and more detailed reporting


EXECUTIVE SUMMARY


The client is a rapidly growing mid-sized biomedical manufacturing company. A classic good news and bad news Office of Finance situation has transpired over the last few years. That is, with rapid growth comes more requirements to report, eliminate and consolidate. The Controllers and FP&A team are highly experienced. As with many Finance teams, they had been rolling up their sleeves to successfully meet this challenge but their existing tools – Excel and Budget Maestro – have made this task difficult. The Finance team recognized this was a risky situation. They needed a modern tool and streamlined process for supporting strong growth and healthy margins.

Ironside was selected by the company to support the implementation of Adaptive Insights for their financial reporting and consolidation function. Ironside had worked with this organization on other projects in the past, from automation of incentive compensation to training and optimization. It was a close partnership that fueled the confidence to crawl, walk, and run with a modern CPM solution to address key financial needs.  

[av_section min_height='custom' min_height_px='0' padding='default' shadow='no-border-styling' bottom_border='no-border-styling' bottom_border_diagonal_color='#333333' bottom_border_diagonal_direction='' bottom_border_style='' custom_arrow_bg='' id='' color='main_color' custom_bg='' src='' attachment='' attachment_size='' attach='scroll' position='top left' repeat='no-repeat' video='' video_ratio='16:9' overlay_opacity='0.5' overlay_color='' overlay_pattern='' overlay_custom_pattern='' av_element_hidden_in_editor='0' custom_class='' av_uid='av-93vd1yh'] [av_one_full first min_height='' vertical_alignment='av-align-top' space='no_margin' margin='0px' margin_sync='true' padding='0px' padding_sync='true' border='' border_color='' radius='0px' radius_sync='true' background_color='' src='' attachment='' attachment_size='' background_position='top left' background_repeat='no-repeat' animation='pop-up' mobile_breaking='' mobile_display='' custom_class='' av_uid='av-8blbyo9'] [av_heading tag='h3' padding='0' heading='READ ADDITIONAL CASE STUDIES' color='' style='blockquote modern-quote modern-centered' custom_font='' size='' subheading_active='' subheading_size='15' custom_class='' admin_preview_bg='' av-desktop-hide='' av-medium-hide='' av-small-hide='' av-mini-hide='' av-medium-font-size-title='' av-small-font-size-title='' av-mini-font-size-title='' av-medium-font-size='' av-small-font-size='' av-mini-font-size='' av_uid='av-tl2oyx'][/av_heading] [/av_one_full] [/av_section] [av_tab_section transition='av-tab-slide-transition' padding='default' tab_pos='av-tab-above-content' content_height='' tab_padding='default' initial='3' id='' av_element_hidden_in_editor='0' av_admin_tab_active='4' bg_color='#f4f3f3' color='' av_uid='av-4iskq8s' custom_class=''] [av_tab_sub_section tab_title='Strategy' vertical_align='middle' icon_select='no' icon='ue800' font='entypo-fontello' tab_image='' tab_image_style='' color='' background_color='' src='' attachment='' attachment_size='' background_attachment='scroll' background_position='top left' background_repeat='no-repeat' custom_class='' av_uid='av-3ua41ek'] [av_masonry_entries link='portfolio_entries,1122' wc_prod_visible='' prod_order_by='' prod_order='' sort='no' items='3' columns='3' paginate='none' query_orderby='date' query_order='DESC' size='fixed' orientation='av-orientation-square' gap='large' overlay_fx='active' id='' caption_elements='title' caption_styling='overlay' caption_display='always' color='' custom_bg='' av-medium-columns='' av-small-columns='' av-mini-columns='' av_uid='av-3inv0xo' custom_class=''] [/av_tab_sub_section][av_tab_sub_section tab_title='Data' vertical_align='middle' icon_select='no' icon='ue800' font='entypo-fontello' tab_image='' tab_image_style='' color='' background_color='' src='' attachment='' attachment_size='' background_attachment='scroll' background_position='top left' background_repeat='no-repeat' custom_class='' av_uid='av-2x2nruk'] [av_masonry_entries link='portfolio_entries,1123' wc_prod_visible='' prod_order_by='' prod_order='' sort='no' items='3' columns='3' paginate='none' query_orderby='date' query_order='DESC' size='fixed' orientation='av-orientation-square' gap='large' overlay_fx='active' id='' caption_elements='title' caption_styling='overlay' caption_display='always' color='' custom_bg='' av-medium-columns='' av-small-columns='' av-mini-columns='' av_uid='av-2ibtovw' custom_class=''] [/av_tab_sub_section][av_tab_sub_section tab_title='Analytics' vertical_align='middle' icon_select='no' icon='ue800' font='entypo-fontello' tab_image='' tab_image_style='' color='' background_color='' src='' attachment='' attachment_size='' background_attachment='scroll' background_position='top left' background_repeat='no-repeat' custom_class='' av_uid='av-1ztjhss'] [av_masonry_entries link='portfolio_entries,1124' wc_prod_visible='' prod_order_by='' prod_order='' sort='no' items='3' columns='3' paginate='none' query_orderby='date' query_order='DESC' size='fixed' orientation='av-orientation-square' gap='large' overlay_fx='active' id='' caption_elements='title' caption_styling='overlay' caption_display='always' color='' custom_bg='' av-medium-columns='' av-small-columns='' av-mini-columns='' av_uid='av-1satp18' custom_class=''] [/av_tab_sub_section][av_tab_sub_section tab_title='Platform' vertical_align='middle' icon_select='no' icon='ue800' font='entypo-fontello' tab_image='' tab_image_style='' color='' background_color='' src='' attachment='' attachment_size='' background_attachment='scroll' background_position='top left' background_repeat='no-repeat' custom_class='' av_uid='av-14gy7h8'] [av_masonry_entries link='portfolio_entries,1125' wc_prod_visible='' prod_order_by='' prod_order='' sort='no' items='3' columns='3' paginate='none' query_orderby='date' query_order='DESC' size='fixed' orientation='av-orientation-square' gap='large' overlay_fx='active' id='' caption_elements='title' caption_styling='overlay' caption_display='always' color='' custom_bg='' av-medium-columns='' av-small-columns='' av-mini-columns='' av_uid='av-r6kews' custom_class=''] [/av_tab_sub_section][/av_tab_section]

[av_section min_height='' min_height_px='500px' padding='default' shadow='no-border-styling' bottom_border='no-border-styling' bottom_border_diagonal_color='#333333' bottom_border_diagonal_direction='' bottom_border_style='' custom_arrow_bg='' id='' color='main_color' custom_bg='' src='https://www.ironsidegroup.com/wp-content/uploads/2018/03/yellow-rudder-1500x630.png' attachment='16316' attachment_size='featured_large' attach='parallax' position='center center' repeat='no-repeat' video='' video_ratio='16:9' overlay_opacity='0.5' overlay_color='' overlay_pattern='' overlay_custom_pattern='' av_element_hidden_in_editor='0' custom_class='' av_uid='av-3e8pueh'] [av_one_full first min_height='' vertical_alignment='av-align-top' space='' margin='0px' margin_sync='true' padding='50px,0px,0px,0px' border='' border_color='' radius='10px,10px,0,' background_color='#ffffff' src='' attachment='' attachment_size='' background_position='top left' background_repeat='no-repeat' animation='' mobile_breaking='' mobile_display='' custom_class='' av_uid='av-320m815'] [av_heading tag='h2' padding='10' heading='Become one of our successful clients.' color='' style='blockquote modern-quote modern-centered' custom_font='' size='' subheading_active='' subheading_size='15' custom_class='' admin_preview_bg='' av-desktop-hide='' av-medium-hide='' av-small-hide='' av-mini-hide='' av-medium-font-size-title='' av-small-font-size-title='' av-mini-font-size-title='' av-medium-font-size='' av-small-font-size='' av-mini-font-size='' av_uid='av-2os9ax5'][/av_heading] [/av_one_full][av_one_fourth first min_height='av-equal-height-column' vertical_alignment='av-align-top' space='no_margin' margin='0px' margin_sync='true' padding='0px,0px,50px,0px' border='' border_color='' radius='0px,0px,0px,10px' background_color='#ffffff' src='' attachment='' attachment_size='' background_position='top left' background_repeat='no-repeat' animation='' mobile_breaking='' mobile_display='' custom_class='' av_uid='av-28fflmx'] [/av_one_fourth][av_one_half min_height='' vertical_alignment='av-align-top' space='' margin='0px' margin_sync='true' padding='30px,40px,50px,40px' border='' border_color='' radius='0px' radius_sync='true' background_color='#ffffff' src='' attachment='' attachment_size='' background_position='top left' background_repeat='no-repeat' animation='' mobile_breaking='' mobile_display='' custom_class='' av_uid='av-1rz7q7d'] [av_button_big label='Take our Data & Analytics Self-Assessment' description_pos='below' link='page,15594' link_target='' icon_select='no' icon='ue800' font='entypo-fontello' custom_font='#ffffff' color='custom' custom_bg='#00aec7' color_hover='theme-color' custom_bg_hover='#444444' custom_class='' admin_preview_bg='' av_uid='av-4pr12h'][/av_button_big] [/av_one_half][av_one_fourth min_height='' vertical_alignment='av-align-top' space='' margin='0px' margin_sync='true' padding='0px' padding_sync='true' border='' border_color='' radius='0px,0px,10px,0px' background_color='#ffffff' src='' attachment='' attachment_size='' background_position='top left' background_repeat='no-repeat' animation='' mobile_breaking='' mobile_display='' custom_class='' av_uid='av-2cum7d'] [/av_one_fourth] [/av_section]

Enable Interaction Reporting with Tableau

/by

ANALYTICS | CASE STUDY

Enable Interaction Reporting with Tableau

COMPANY OVERVIEW


A multinational pharmaceutical company focused on preventative health care and the research, development and production of prescription drugs of chemical and biotechnology origin.

BUSINESS NEED


The client’s Medical team had a need for a more comprehensive set of reporting around their interactions with health care providers, currently tracked using Salesforce Veeva. They wanted to replace current processes and workflows to manually combine monthly reports and metrics from Veeva and provide reporting stakeholders across Medical with a consolidated view of KPIs and the ability to identify and analyze drivers of those KPIs using Tableau.

SOLUTION


The client engaged Ironside’s BI team to carry out the following phases:


Discovery & Analysis


  • Hold discovery sessions with stakeholders to understand their business objectives and current processes related to interactions and the use of Veeva data to track interactions

  • Identify and review reports pulled from Salesforce Veeva used as inputs to current processes

  • Define metrics used by each team as well as leadership to relay the quality of interactions


Design


  • Create an initial dashboard mockup displaying the defined metrics visually and iteratively review and update based on stakeholder feedback


Data Prep & Prototyping


  • Create a mock data set and Tableau prototype to replicate the approved design and serve as a reference for data sourcing activities


Data Sourcing & Automation


  • Source Veeva data into the Enterprise Data Warehouse and model data in accordance with metric definitions and mock data set used in Tableau Prototype

  • Update Tableau prototype to use the enterprise data environment in conjunction with a Tableau Extract, and publish to Tableau server for distribution


KEYS TO SUCCESS


By replacing their current processes, the client will see the following benefits:

  • Creation of a scalable data model to be used for both the dashboard and future self-service analytic capabilities

  • Elimination of manual tabular report compilation and replace with an automated, visual analytic dashboard to drive insight into interactions between the Medical team and Healthcare providers

  • Deployment of a dashboard solution intended for use by 4 different teams, with the ability to retain the unique requirements of each team with a consolidated view for the Medical leadership team

About Tableau

Tableau Software helps people see and understand data. Used by more than 19,000 companies and organizations worldwide, Tableau delivers fast analytics, visualization, and rapid-fire business intelligence and helps you drive data discovery with stunning, intuitive visualizations. Tableau has a diverse range of platform types and deployment approaches. Whether you just need a simple, compact desktop app or an enterprise-grade on-prem or cloud environment, Tableau can size itself to fit your organizational goals and needs.

[av_section min_height='custom' min_height_px='0' padding='default' shadow='no-border-styling' bottom_border='no-border-styling' bottom_border_diagonal_color='#333333' bottom_border_diagonal_direction='' bottom_border_style='' custom_arrow_bg='' id='' color='main_color' custom_bg='' src='' attachment='' attachment_size='' attach='scroll' position='top left' repeat='no-repeat' video='' video_ratio='16:9' overlay_opacity='0.5' overlay_color='' overlay_pattern='' overlay_custom_pattern='' av_element_hidden_in_editor='0' custom_class='' av_uid='av-93vd1yh'] [av_one_full first min_height='' vertical_alignment='av-align-top' space='no_margin' margin='0px' margin_sync='true' padding='0px' padding_sync='true' border='' border_color='' radius='0px' radius_sync='true' background_color='' src='' attachment='' attachment_size='' background_position='top left' background_repeat='no-repeat' animation='pop-up' mobile_breaking='' mobile_display='' custom_class='' av_uid='av-8blbyo9'] [av_heading tag='h3' padding='0' heading='READ ADDITIONAL CASE STUDIES' color='' style='blockquote modern-quote modern-centered' custom_font='' size='' subheading_active='' subheading_size='15' custom_class='' admin_preview_bg='' av-desktop-hide='' av-medium-hide='' av-small-hide='' av-mini-hide='' av-medium-font-size-title='' av-small-font-size-title='' av-mini-font-size-title='' av-medium-font-size='' av-small-font-size='' av-mini-font-size='' av_uid='av-tl2oyx'][/av_heading] [/av_one_full] [/av_section] [av_tab_section transition='av-tab-slide-transition' padding='default' tab_pos='av-tab-above-content' content_height='' tab_padding='default' initial='3' id='' av_element_hidden_in_editor='0' av_admin_tab_active='4' bg_color='#f4f3f3' color='' av_uid='av-4iskq8s' custom_class=''] [av_tab_sub_section tab_title='Strategy' vertical_align='middle' icon_select='no' icon='ue800' font='entypo-fontello' tab_image='' tab_image_style='' color='' background_color='' src='' attachment='' attachment_size='' background_attachment='scroll' background_position='top left' background_repeat='no-repeat' custom_class='' av_uid='av-3ua41ek'] [av_masonry_entries link='portfolio_entries,1122' wc_prod_visible='' prod_order_by='' prod_order='' sort='no' items='3' columns='3' paginate='none' query_orderby='date' query_order='DESC' size='fixed' orientation='av-orientation-square' gap='large' overlay_fx='active' id='' caption_elements='title' caption_styling='overlay' caption_display='always' color='' custom_bg='' av-medium-columns='' av-small-columns='' av-mini-columns='' av_uid='av-3inv0xo' custom_class=''] [/av_tab_sub_section][av_tab_sub_section tab_title='Data' vertical_align='middle' icon_select='no' icon='ue800' font='entypo-fontello' tab_image='' tab_image_style='' color='' background_color='' src='' attachment='' attachment_size='' background_attachment='scroll' background_position='top left' background_repeat='no-repeat' custom_class='' av_uid='av-2x2nruk'] [av_masonry_entries link='portfolio_entries,1123' wc_prod_visible='' prod_order_by='' prod_order='' sort='no' items='3' columns='3' paginate='none' query_orderby='date' query_order='DESC' size='fixed' orientation='av-orientation-square' gap='large' overlay_fx='active' id='' caption_elements='title' caption_styling='overlay' caption_display='always' color='' custom_bg='' av-medium-columns='' av-small-columns='' av-mini-columns='' av_uid='av-2ibtovw' custom_class=''] [/av_tab_sub_section][av_tab_sub_section tab_title='Analytics' vertical_align='middle' icon_select='no' icon='ue800' font='entypo-fontello' tab_image='' tab_image_style='' color='' background_color='' src='' attachment='' attachment_size='' background_attachment='scroll' background_position='top left' background_repeat='no-repeat' custom_class='' av_uid='av-1ztjhss'] [av_masonry_entries link='portfolio_entries,1124' wc_prod_visible='' prod_order_by='' prod_order='' sort='no' items='3' columns='3' paginate='none' query_orderby='date' query_order='DESC' size='fixed' orientation='av-orientation-square' gap='large' overlay_fx='active' id='' caption_elements='title' caption_styling='overlay' caption_display='always' color='' custom_bg='' av-medium-columns='' av-small-columns='' av-mini-columns='' av_uid='av-1satp18' custom_class=''] [/av_tab_sub_section][av_tab_sub_section tab_title='Platform' vertical_align='middle' icon_select='no' icon='ue800' font='entypo-fontello' tab_image='' tab_image_style='' color='' background_color='' src='' attachment='' attachment_size='' background_attachment='scroll' background_position='top left' background_repeat='no-repeat' custom_class='' av_uid='av-14gy7h8'] [av_masonry_entries link='portfolio_entries,1125' wc_prod_visible='' prod_order_by='' prod_order='' sort='no' items='3' columns='3' paginate='none' query_orderby='date' query_order='DESC' size='fixed' orientation='av-orientation-square' gap='large' overlay_fx='active' id='' caption_elements='title' caption_styling='overlay' caption_display='always' color='' custom_bg='' av-medium-columns='' av-small-columns='' av-mini-columns='' av_uid='av-r6kews' custom_class=''] [/av_tab_sub_section][/av_tab_section]

[av_section min_height='' min_height_px='500px' padding='default' shadow='no-border-styling' bottom_border='no-border-styling' bottom_border_diagonal_color='#333333' bottom_border_diagonal_direction='' bottom_border_style='' custom_arrow_bg='' id='' color='main_color' custom_bg='' src='https://www.ironsidegroup.com/wp-content/uploads/2018/03/yellow-rudder-1500x630.png' attachment='16316' attachment_size='featured_large' attach='parallax' position='center center' repeat='no-repeat' video='' video_ratio='16:9' overlay_opacity='0.5' overlay_color='' overlay_pattern='' overlay_custom_pattern='' av_element_hidden_in_editor='0' custom_class='' av_uid='av-3e8pueh'] [av_one_full first min_height='' vertical_alignment='av-align-top' space='' margin='0px' margin_sync='true' padding='50px,0px,0px,0px' border='' border_color='' radius='10px,10px,0,' background_color='#ffffff' src='' attachment='' attachment_size='' background_position='top left' background_repeat='no-repeat' animation='' mobile_breaking='' mobile_display='' custom_class='' av_uid='av-320m815'] [av_heading tag='h2' padding='10' heading='Become one of our successful clients.' color='' style='blockquote modern-quote modern-centered' custom_font='' size='' subheading_active='' subheading_size='15' custom_class='' admin_preview_bg='' av-desktop-hide='' av-medium-hide='' av-small-hide='' av-mini-hide='' av-medium-font-size-title='' av-small-font-size-title='' av-mini-font-size-title='' av-medium-font-size='' av-small-font-size='' av-mini-font-size='' av_uid='av-2os9ax5'][/av_heading] [/av_one_full][av_one_fourth first min_height='av-equal-height-column' vertical_alignment='av-align-top' space='no_margin' margin='0px' margin_sync='true' padding='0px,0px,50px,0px' border='' border_color='' radius='0px,0px,0px,10px' background_color='#ffffff' src='' attachment='' attachment_size='' background_position='top left' background_repeat='no-repeat' animation='' mobile_breaking='' mobile_display='' custom_class='' av_uid='av-28fflmx'] [/av_one_fourth][av_one_half min_height='' vertical_alignment='av-align-top' space='' margin='0px' margin_sync='true' padding='30px,40px,50px,40px' border='' border_color='' radius='0px' radius_sync='true' background_color='#ffffff' src='' attachment='' attachment_size='' background_position='top left' background_repeat='no-repeat' animation='' mobile_breaking='' mobile_display='' custom_class='' av_uid='av-1rz7q7d'] [av_button_big label='Take our Data & Analytics Self-Assessment' description_pos='below' link='page,15594' link_target='' icon_select='no' icon='ue800' font='entypo-fontello' custom_font='#ffffff' color='custom' custom_bg='#00aec7' color_hover='theme-color' custom_bg_hover='#444444' custom_class='' admin_preview_bg='' av_uid='av-4pr12h'][/av_button_big] [/av_one_half][av_one_fourth min_height='' vertical_alignment='av-align-top' space='' margin='0px' margin_sync='true' padding='0px' padding_sync='true' border='' border_color='' radius='0px,0px,10px,0px' background_color='#ffffff' src='' attachment='' attachment_size='' background_position='top left' background_repeat='no-repeat' animation='' mobile_breaking='' mobile_display='' custom_class='' av_uid='av-2cum7d'] [/av_one_fourth] [/av_section]
,

Use Data to Drive Personalized Marketing

/by

ANALYTICS | CASE STUDY

Use Data to Drive Personalized Marketing

COMPANY OVERVIEW


A large provider of travel and vacation services was looking to personalize their marketing efforts with the overall goal of increasing revenue and creating returning customers.

BUSINESS NEED


The company needed to stimulate growth and gain more returned value from marketing campaigns. Their goals were to increase sales of vacation packages, re-engage previous customers, and apply a smarter marketing campaign.

SOLUTION


Ironside’s BI team used the client’s data to deliver a solution by doing the following:


Refine the Focus


  • Collect data at a granularity that permits propensity score creation for each prior customer

  • Use predictive analytics to identify customers most likely to be interested in purchasing specific vacation packages

  • Target the flagged customers with promotional material tailored to their vacation interests and propensities

  • Understand the model drivers and characteristics of the customers associated with specific types of vacation packages and use this information in other marketing endeavors


Define the Roadmap


  • Collect necessary historical customer data and cleanse it

  • Build a propensity to buy model which identifies patterns in customer data associated with purchasing specific vacation packages

  • Use the model to assign a likelihood to purchase score which will align prospective customers with prior customers similar to them on key features

  • Group prospective customers according to likelihood to purchase each package and design distinct marketing campaigns

  • Follow campaign success and continue to enhance model performance with continuous learning


Develop the Model


  • Compile and cleanse data from multiple sources

  • Ask relevant questions to ensure the resulting model is accurate

  • Test predictive modeling methods and use the best to predict likelihood to buy each package type


Inform Action


  • Enable the client to zero in on key segments of their prospective customer base and market to them in a more customized fashion

  • Afford the ability to apply less costly and more generalized marketing efforts to individuals unlikely to make a purchase; therefore diverting more of their marketing funds and efforts to those more likely to purchase

  • Provide insight into customer characteristics and other drivers associated with specific vacation packages


KEYS TO SUCCESS


The propensity model engagement resulted in the following benefits:

  • Insight into what drives customer preferences

  • Specialized the sales/marketing efforts on customers

  • Monetized data that otherwise was under-utilized

  • Empowered the client to use advanced techniques to maximize sales

[av_section min_height='custom' min_height_px='0' padding='default' shadow='no-border-styling' bottom_border='no-border-styling' bottom_border_diagonal_color='#333333' bottom_border_diagonal_direction='' bottom_border_style='' custom_arrow_bg='' id='' color='main_color' custom_bg='' src='' attachment='' attachment_size='' attach='scroll' position='top left' repeat='no-repeat' video='' video_ratio='16:9' overlay_opacity='0.5' overlay_color='' overlay_pattern='' overlay_custom_pattern='' av_element_hidden_in_editor='0' custom_class='' av_uid='av-93vd1yh'] [av_one_full first min_height='' vertical_alignment='av-align-top' space='no_margin' margin='0px' margin_sync='true' padding='0px' padding_sync='true' border='' border_color='' radius='0px' radius_sync='true' background_color='' src='' attachment='' attachment_size='' background_position='top left' background_repeat='no-repeat' animation='pop-up' mobile_breaking='' mobile_display='' custom_class='' av_uid='av-8blbyo9'] [av_heading tag='h3' padding='0' heading='READ ADDITIONAL CASE STUDIES' color='' style='blockquote modern-quote modern-centered' custom_font='' size='' subheading_active='' subheading_size='15' custom_class='' admin_preview_bg='' av-desktop-hide='' av-medium-hide='' av-small-hide='' av-mini-hide='' av-medium-font-size-title='' av-small-font-size-title='' av-mini-font-size-title='' av-medium-font-size='' av-small-font-size='' av-mini-font-size='' av_uid='av-tl2oyx'][/av_heading] [/av_one_full] [/av_section] [av_tab_section transition='av-tab-slide-transition' padding='default' tab_pos='av-tab-above-content' content_height='' tab_padding='default' initial='3' id='' av_element_hidden_in_editor='0' av_admin_tab_active='4' bg_color='#f4f3f3' color='' av_uid='av-4iskq8s' custom_class=''] [av_tab_sub_section tab_title='Strategy' vertical_align='middle' icon_select='no' icon='ue800' font='entypo-fontello' tab_image='' tab_image_style='' color='' background_color='' src='' attachment='' attachment_size='' background_attachment='scroll' background_position='top left' background_repeat='no-repeat' custom_class='' av_uid='av-3ua41ek'] [av_masonry_entries link='portfolio_entries,1122' wc_prod_visible='' prod_order_by='' prod_order='' sort='no' items='3' columns='3' paginate='none' query_orderby='date' query_order='DESC' size='fixed' orientation='av-orientation-square' gap='large' overlay_fx='active' id='' caption_elements='title' caption_styling='overlay' caption_display='always' color='' custom_bg='' av-medium-columns='' av-small-columns='' av-mini-columns='' av_uid='av-3inv0xo' custom_class=''] [/av_tab_sub_section][av_tab_sub_section tab_title='Data' vertical_align='middle' icon_select='no' icon='ue800' font='entypo-fontello' tab_image='' tab_image_style='' color='' background_color='' src='' attachment='' attachment_size='' background_attachment='scroll' background_position='top left' background_repeat='no-repeat' custom_class='' av_uid='av-2x2nruk'] [av_masonry_entries link='portfolio_entries,1123' wc_prod_visible='' prod_order_by='' prod_order='' sort='no' items='3' columns='3' paginate='none' query_orderby='date' query_order='DESC' size='fixed' orientation='av-orientation-square' gap='large' overlay_fx='active' id='' caption_elements='title' caption_styling='overlay' caption_display='always' color='' custom_bg='' av-medium-columns='' av-small-columns='' av-mini-columns='' av_uid='av-2ibtovw' custom_class=''] [/av_tab_sub_section][av_tab_sub_section tab_title='Analytics' vertical_align='middle' icon_select='no' icon='ue800' font='entypo-fontello' tab_image='' tab_image_style='' color='' background_color='' src='' attachment='' attachment_size='' background_attachment='scroll' background_position='top left' background_repeat='no-repeat' custom_class='' av_uid='av-1ztjhss'] [av_masonry_entries link='portfolio_entries,1124' wc_prod_visible='' prod_order_by='' prod_order='' sort='no' items='3' columns='3' paginate='none' query_orderby='date' query_order='DESC' size='fixed' orientation='av-orientation-square' gap='large' overlay_fx='active' id='' caption_elements='title' caption_styling='overlay' caption_display='always' color='' custom_bg='' av-medium-columns='' av-small-columns='' av-mini-columns='' av_uid='av-1satp18' custom_class=''] [/av_tab_sub_section][av_tab_sub_section tab_title='Platform' vertical_align='middle' icon_select='no' icon='ue800' font='entypo-fontello' tab_image='' tab_image_style='' color='' background_color='' src='' attachment='' attachment_size='' background_attachment='scroll' background_position='top left' background_repeat='no-repeat' custom_class='' av_uid='av-14gy7h8'] [av_masonry_entries link='portfolio_entries,1125' wc_prod_visible='' prod_order_by='' prod_order='' sort='no' items='3' columns='3' paginate='none' query_orderby='date' query_order='DESC' size='fixed' orientation='av-orientation-square' gap='large' overlay_fx='active' id='' caption_elements='title' caption_styling='overlay' caption_display='always' color='' custom_bg='' av-medium-columns='' av-small-columns='' av-mini-columns='' av_uid='av-r6kews' custom_class=''] [/av_tab_sub_section][/av_tab_section] [av_section min_height='' min_height_px='500px' padding='default' shadow='no-border-styling' bottom_border='no-border-styling' bottom_border_diagonal_color='#333333' bottom_border_diagonal_direction='' bottom_border_style='' custom_arrow_bg='' id='' color='main_color' custom_bg='' src='https://www.ironsidegroup.com/wp-content/uploads/2018/03/yellow-rudder-1500x630.png' attachment='16316' attachment_size='featured_large' attach='parallax' position='center center' repeat='no-repeat' video='' video_ratio='16:9' overlay_opacity='0.5' overlay_color='' overlay_pattern='' overlay_custom_pattern='' av_element_hidden_in_editor='0' custom_class='' av_uid='av-3e8pueh'] [av_one_full first min_height='' vertical_alignment='av-align-top' space='' margin='0px' margin_sync='true' padding='50px,0px,0px,0px' border='' border_color='' radius='10px,10px,0,' background_color='#ffffff' src='' attachment='' attachment_size='' background_position='top left' background_repeat='no-repeat' animation='' mobile_breaking='' mobile_display='' custom_class='' av_uid='av-320m815'] [av_heading tag='h2' padding='10' heading='Become one of our successful clients.' color='' style='blockquote modern-quote modern-centered' custom_font='' size='' subheading_active='' subheading_size='15' custom_class='' admin_preview_bg='' av-desktop-hide='' av-medium-hide='' av-small-hide='' av-mini-hide='' av-medium-font-size-title='' av-small-font-size-title='' av-mini-font-size-title='' av-medium-font-size='' av-small-font-size='' av-mini-font-size='' av_uid='av-2os9ax5'][/av_heading] [/av_one_full][av_one_fourth first min_height='av-equal-height-column' vertical_alignment='av-align-top' space='no_margin' margin='0px' margin_sync='true' padding='0px,0px,50px,0px' border='' border_color='' radius='0px,0px,0px,10px' background_color='#ffffff' src='' attachment='' attachment_size='' background_position='top left' background_repeat='no-repeat' animation='' mobile_breaking='' mobile_display='' custom_class='' av_uid='av-28fflmx'] [/av_one_fourth][av_one_half min_height='' vertical_alignment='av-align-top' space='' margin='0px' margin_sync='true' padding='30px,40px,50px,40px' border='' border_color='' radius='0px' radius_sync='true' background_color='#ffffff' src='' attachment='' attachment_size='' background_position='top left' background_repeat='no-repeat' animation='' mobile_breaking='' mobile_display='' custom_class='' av_uid='av-1rz7q7d'] [av_button_big label='Take our Data & Analytics Self-Assessment' description_pos='below' link='page,15594' link_target='' icon_select='no' icon='ue800' font='entypo-fontello' custom_font='#ffffff' color='custom' custom_bg='#00aec7' color_hover='theme-color' custom_bg_hover='#444444' custom_class='' admin_preview_bg='' av_uid='av-4pr12h'][/av_button_big] [/av_one_half][av_one_fourth min_height='' vertical_alignment='av-align-top' space='' margin='0px' margin_sync='true' padding='0px' padding_sync='true' border='' border_color='' radius='0px,0px,10px,0px' background_color='#ffffff' src='' attachment='' attachment_size='' background_position='top left' background_repeat='no-repeat' animation='' mobile_breaking='' mobile_display='' custom_class='' av_uid='av-2cum7d'] [/av_one_fourth] [/av_section]
,

Predict Higher Education Student Retention Risk

/by

ANALYTICS | CASE STUDY

Predict Higher Education Student Retention Risk

COMPANY OVERVIEW


A community college providing open access to quality higher education was looking for a way of predicting student retention risk so they could intervene and help at-risk students succeed.

BUSINESS NEED


The college’s student retention rate over 6 years was below 50 percent. They knew they needed to find proactive ways of identifying at-risk students, but weren’t sure how to best leverage their data to do it. The college’s Institutional Research team brought in Ironside to test predictive modeling techniques, evaluate and select a set of predictor variables on which to base student risk scores, segment students into groups based on GPA attainment and retention likelihood, integrate with the college’s student services model, data warehouse, and BI platform, and output individualized student risk scores and intervention/retention strategies for at-risk students.

SOLUTION


The Ironside Data Science & Advanced Analytics team is dedicated to helping organizations realize the full potential of their data resources. The client brought in the team to do the following:


Define the Vision


  • Collect data at a granularity that permits risk score creation for each enrolled student

  • Trigger actions and alerts based on student behaviors or academic events

  • Fit recommendations to each student’s needs, allowing long-term intervention plans

  • Feed into the data warehouse to compare with actuals/the student services model


Prepare the Data


  • Client needed to prepare and transform their data for use in predictive models

  • Analysts spent 70-80% of their total project time working with Ironside experts to extract and refine the information needed for their predictive model


Develop & Refine Scoring Methods


  • Isolate productive variables and designate variable categories for each model

  • Train models against 10 years’ worth of student data (approx. 68,000 unique records) using multiple predictive algorithms

  • Implement linear regression models based on findings from modeling tests

  • Weight chosen variables based on relative importance in overall risk score outputs

  • Identify four student service quadrants: GPA & retention safe, GPA safe but retention at risk, GPA at risk but retention safe, and GPA & retention at risk

  • Feed results into data warehouse and begin defining next best actions based on reports


Ensure Future Progress


  • Client’s internal resources gained hands-on experience with their student retention risk models and with variable and algorithm selection

  • Ensured they could use their student retention risk models as a springboard into other modeling projects

  • Opened the door for future insights into student behavior and other operational projections like donor optimization


KEYS TO SUCCESS


Through predictive analysis, the client was able to:

  • Enable mass deployment of individualized student services and target first year experiences

  • Refine the views on established business practices with hard facts and accurate predictions, fueling change

  • Affirm the importance of specific variables for student success and tie them to actual effects on the student population

  • Empower analysts with a predictive analytics knowledge base so they can better improve policies and assist students

[av_section min_height='custom' min_height_px='0' padding='default' shadow='no-border-styling' bottom_border='no-border-styling' bottom_border_diagonal_color='#333333' bottom_border_diagonal_direction='' bottom_border_style='' custom_arrow_bg='' id='' color='main_color' custom_bg='' src='' attachment='' attachment_size='' attach='scroll' position='top left' repeat='no-repeat' video='' video_ratio='16:9' overlay_opacity='0.5' overlay_color='' overlay_pattern='' overlay_custom_pattern='' av_element_hidden_in_editor='0' custom_class='' av_uid='av-93vd1yh'] [av_one_full first min_height='' vertical_alignment='av-align-top' space='no_margin' margin='0px' margin_sync='true' padding='0px' padding_sync='true' border='' border_color='' radius='0px' radius_sync='true' background_color='' src='' attachment='' attachment_size='' background_position='top left' background_repeat='no-repeat' animation='pop-up' mobile_breaking='' mobile_display='' custom_class='' av_uid='av-8blbyo9'] [av_heading tag='h3' padding='0' heading='READ ADDITIONAL CASE STUDIES' color='' style='blockquote modern-quote modern-centered' custom_font='' size='' subheading_active='' subheading_size='15' custom_class='' admin_preview_bg='' av-desktop-hide='' av-medium-hide='' av-small-hide='' av-mini-hide='' av-medium-font-size-title='' av-small-font-size-title='' av-mini-font-size-title='' av-medium-font-size='' av-small-font-size='' av-mini-font-size='' av_uid='av-tl2oyx'][/av_heading] [/av_one_full] [/av_section] [av_tab_section transition='av-tab-slide-transition' padding='default' tab_pos='av-tab-above-content' content_height='' tab_padding='default' initial='3' id='' av_element_hidden_in_editor='0' av_admin_tab_active='4' bg_color='#f4f3f3' color='' av_uid='av-4iskq8s' custom_class=''] [av_tab_sub_section tab_title='Strategy' vertical_align='middle' icon_select='no' icon='ue800' font='entypo-fontello' tab_image='' tab_image_style='' color='' background_color='' src='' attachment='' attachment_size='' background_attachment='scroll' background_position='top left' background_repeat='no-repeat' custom_class='' av_uid='av-3ua41ek'] [av_masonry_entries link='portfolio_entries,1122' wc_prod_visible='' prod_order_by='' prod_order='' sort='no' items='3' columns='3' paginate='none' query_orderby='date' query_order='DESC' size='fixed' orientation='av-orientation-square' gap='large' overlay_fx='active' id='' caption_elements='title' caption_styling='overlay' caption_display='always' color='' custom_bg='' av-medium-columns='' av-small-columns='' av-mini-columns='' av_uid='av-3inv0xo' custom_class=''] [/av_tab_sub_section][av_tab_sub_section tab_title='Data' vertical_align='middle' icon_select='no' icon='ue800' font='entypo-fontello' tab_image='' tab_image_style='' color='' background_color='' src='' attachment='' attachment_size='' background_attachment='scroll' background_position='top left' background_repeat='no-repeat' custom_class='' av_uid='av-2x2nruk'] [av_masonry_entries link='portfolio_entries,1123' wc_prod_visible='' prod_order_by='' prod_order='' sort='no' items='3' columns='3' paginate='none' query_orderby='date' query_order='DESC' size='fixed' orientation='av-orientation-square' gap='large' overlay_fx='active' id='' caption_elements='title' caption_styling='overlay' caption_display='always' color='' custom_bg='' av-medium-columns='' av-small-columns='' av-mini-columns='' av_uid='av-2ibtovw' custom_class=''] [/av_tab_sub_section][av_tab_sub_section tab_title='Analytics' vertical_align='middle' icon_select='no' icon='ue800' font='entypo-fontello' tab_image='' tab_image_style='' color='' background_color='' src='' attachment='' attachment_size='' background_attachment='scroll' background_position='top left' background_repeat='no-repeat' custom_class='' av_uid='av-1ztjhss'] [av_masonry_entries link='portfolio_entries,1124' wc_prod_visible='' prod_order_by='' prod_order='' sort='no' items='3' columns='3' paginate='none' query_orderby='date' query_order='DESC' size='fixed' orientation='av-orientation-square' gap='large' overlay_fx='active' id='' caption_elements='title' caption_styling='overlay' caption_display='always' color='' custom_bg='' av-medium-columns='' av-small-columns='' av-mini-columns='' av_uid='av-1satp18' custom_class=''] [/av_tab_sub_section][av_tab_sub_section tab_title='Platform' vertical_align='middle' icon_select='no' icon='ue800' font='entypo-fontello' tab_image='' tab_image_style='' color='' background_color='' src='' attachment='' attachment_size='' background_attachment='scroll' background_position='top left' background_repeat='no-repeat' custom_class='' av_uid='av-14gy7h8'] [av_masonry_entries link='portfolio_entries,1125' wc_prod_visible='' prod_order_by='' prod_order='' sort='no' items='3' columns='3' paginate='none' query_orderby='date' query_order='DESC' size='fixed' orientation='av-orientation-square' gap='large' overlay_fx='active' id='' caption_elements='title' caption_styling='overlay' caption_display='always' color='' custom_bg='' av-medium-columns='' av-small-columns='' av-mini-columns='' av_uid='av-r6kews' custom_class=''] [/av_tab_sub_section][/av_tab_section] [av_section min_height='' min_height_px='500px' padding='default' shadow='no-border-styling' bottom_border='no-border-styling' bottom_border_diagonal_color='#333333' bottom_border_diagonal_direction='' bottom_border_style='' custom_arrow_bg='' id='' color='main_color' custom_bg='' src='https://www.ironsidegroup.com/wp-content/uploads/2018/03/yellow-rudder-1500x630.png' attachment='16316' attachment_size='featured_large' attach='parallax' position='center center' repeat='no-repeat' video='' video_ratio='16:9' overlay_opacity='0.5' overlay_color='' overlay_pattern='' overlay_custom_pattern='' av_element_hidden_in_editor='0' custom_class='' av_uid='av-3e8pueh'] [av_one_full first min_height='' vertical_alignment='av-align-top' space='' margin='0px' margin_sync='true' padding='50px,0px,0px,0px' border='' border_color='' radius='10px,10px,0,' background_color='#ffffff' src='' attachment='' attachment_size='' background_position='top left' background_repeat='no-repeat' animation='' mobile_breaking='' mobile_display='' custom_class='' av_uid='av-320m815'] [av_heading tag='h2' padding='10' heading='Become one of our successful clients.' color='' style='blockquote modern-quote modern-centered' custom_font='' size='' subheading_active='' subheading_size='15' custom_class='' admin_preview_bg='' av-desktop-hide='' av-medium-hide='' av-small-hide='' av-mini-hide='' av-medium-font-size-title='' av-small-font-size-title='' av-mini-font-size-title='' av-medium-font-size='' av-small-font-size='' av-mini-font-size='' av_uid='av-2os9ax5'][/av_heading] [/av_one_full][av_one_fourth first min_height='av-equal-height-column' vertical_alignment='av-align-top' space='no_margin' margin='0px' margin_sync='true' padding='0px,0px,50px,0px' border='' border_color='' radius='0px,0px,0px,10px' background_color='#ffffff' src='' attachment='' attachment_size='' background_position='top left' background_repeat='no-repeat' animation='' mobile_breaking='' mobile_display='' custom_class='' av_uid='av-28fflmx'] [/av_one_fourth][av_one_half min_height='' vertical_alignment='av-align-top' space='' margin='0px' margin_sync='true' padding='30px,40px,50px,40px' border='' border_color='' radius='0px' radius_sync='true' background_color='#ffffff' src='' attachment='' attachment_size='' background_position='top left' background_repeat='no-repeat' animation='' mobile_breaking='' mobile_display='' custom_class='' av_uid='av-1rz7q7d'] [av_button_big label='Take our Data & Analytics Self-Assessment' description_pos='below' link='page,15594' link_target='' icon_select='no' icon='ue800' font='entypo-fontello' custom_font='#ffffff' color='custom' custom_bg='#00aec7' color_hover='theme-color' custom_bg_hover='#444444' custom_class='' admin_preview_bg='' av_uid='av-4pr12h'][/av_button_big] [/av_one_half][av_one_fourth min_height='' vertical_alignment='av-align-top' space='' margin='0px' margin_sync='true' padding='0px' padding_sync='true' border='' border_color='' radius='0px,0px,10px,0px' background_color='#ffffff' src='' attachment='' attachment_size='' background_position='top left' background_repeat='no-repeat' animation='' mobile_breaking='' mobile_display='' custom_class='' av_uid='av-2cum7d'] [/av_one_fourth] [/av_section]
,

Optimize Donations at Michigan State University

/by

ANALYTICS | CASE STUDY

Optimize Donations at Michigan State University

COMPANY OVERVIEW


Michigan State University (MSU) is a public research university in East Lansing, Michigan and is the eighth-largest university in the United States in terms of enrollment. As recently as the early 1990s, MSU was last among the Big Ten schools in endowments, with barely over $100 million in funds. This changed in the 2000s, when the University started a campaign to increase the size of the endowment.

BUSINESS NEED


MSU’s University Advancement team needed to strategically engage nearly one million alumni and friends of the university in the most strategic way possible. They needed help providing a team of 200 professionals and support staff with actionable insights, managing an Oracle transactional database with more than 1 million records (alumni, donors, friends, organizations). The staff was working with limited resources to analyze the volume of data and maximize the return on the smallest number of targets.

SOLUTION


From strategy through execution, business analytics is a process. Ironside helped MSU with the predictive modeling process by doing the following:


Define A Roadmap


  • Gather and understand information about consumer needs, behaviors, and preferences

  • Analyze a multitude of formats including postal mail, telemarketing, email marketing, texting, crowd sourcing, and social media

  • Focus on high net-worth individuals segmented by region, high-paying degrees, industries, and salaries

  • Profile potential and/or likely candidates for major gift giving


Organize Data & Information


  • Identify internal and external sources that can give you the information you need to make data-driver decisions

  • Identify which best-of-breed technologies will give you the insights you need


Implement, Measure, Refine


  • Layer the predictive models over the existing BI implementation to calculate affinity scores for potential donors

  • Calculate affinity scores for potential donors based on the vast array of variables

  • Implement a predictive model, taking in both structured and unstructured data. Update the model daily so users can keep pace with any changes

  • Create one reporting environment that manages dynamically enriched data. Support with data integrity, data governance, maintenance, and real-time intelligence through analytics

  • Improve organizational performance through new BI tool introductions and training


Hands-on Coaching & Mentoring


  • Provide MSU analytics team with hands-on experience of being actively involved in the predictive analytics and data mining activities during the development of each of the scoring models


KEYS TO SUCCESS


With Ironside’s Advanced Analytics team, MSU was able to:

  • Increase data visibility across the institution, allowing for quicker action on findings

  • Boost business analyst and director productivity turning multi-week studies into real-time report insights

  • Reduce internal resource cost of identifying strong donation prospects

  • Achieve a 55% ROI payback after 2.1 years

[av_section min_height='custom' min_height_px='0' padding='default' shadow='no-border-styling' bottom_border='no-border-styling' bottom_border_diagonal_color='#333333' bottom_border_diagonal_direction='' bottom_border_style='' custom_arrow_bg='' id='' color='main_color' custom_bg='' src='' attachment='' attachment_size='' attach='scroll' position='top left' repeat='no-repeat' video='' video_ratio='16:9' overlay_opacity='0.5' overlay_color='' overlay_pattern='' overlay_custom_pattern='' av_element_hidden_in_editor='0' custom_class='' av_uid='av-93vd1yh'] [av_one_full first min_height='' vertical_alignment='av-align-top' space='no_margin' margin='0px' margin_sync='true' padding='0px' padding_sync='true' border='' border_color='' radius='0px' radius_sync='true' background_color='' src='' attachment='' attachment_size='' background_position='top left' background_repeat='no-repeat' animation='pop-up' mobile_breaking='' mobile_display='' custom_class='' av_uid='av-8blbyo9'] [av_heading tag='h3' padding='0' heading='READ ADDITIONAL CASE STUDIES' color='' style='blockquote modern-quote modern-centered' custom_font='' size='' subheading_active='' subheading_size='15' custom_class='' admin_preview_bg='' av-desktop-hide='' av-medium-hide='' av-small-hide='' av-mini-hide='' av-medium-font-size-title='' av-small-font-size-title='' av-mini-font-size-title='' av-medium-font-size='' av-small-font-size='' av-mini-font-size='' av_uid='av-tl2oyx'][/av_heading] [/av_one_full] [/av_section] [av_tab_section transition='av-tab-slide-transition' padding='default' tab_pos='av-tab-above-content' content_height='' tab_padding='default' initial='3' id='' av_element_hidden_in_editor='0' av_admin_tab_active='4' bg_color='#f4f3f3' color='' av_uid='av-4iskq8s' custom_class=''] [av_tab_sub_section tab_title='Strategy' vertical_align='middle' icon_select='no' icon='ue800' font='entypo-fontello' tab_image='' tab_image_style='' color='' background_color='' src='' attachment='' attachment_size='' background_attachment='scroll' background_position='top left' background_repeat='no-repeat' custom_class='' av_uid='av-3ua41ek'] [av_masonry_entries link='portfolio_entries,1122' wc_prod_visible='' prod_order_by='' prod_order='' sort='no' items='3' columns='3' paginate='none' query_orderby='date' query_order='DESC' size='fixed' orientation='av-orientation-square' gap='large' overlay_fx='active' id='' caption_elements='title' caption_styling='overlay' caption_display='always' color='' custom_bg='' av-medium-columns='' av-small-columns='' av-mini-columns='' av_uid='av-3inv0xo' custom_class=''] [/av_tab_sub_section][av_tab_sub_section tab_title='Data' vertical_align='middle' icon_select='no' icon='ue800' font='entypo-fontello' tab_image='' tab_image_style='' color='' background_color='' src='' attachment='' attachment_size='' background_attachment='scroll' background_position='top left' background_repeat='no-repeat' custom_class='' av_uid='av-2x2nruk'] [av_masonry_entries link='portfolio_entries,1123' wc_prod_visible='' prod_order_by='' prod_order='' sort='no' items='3' columns='3' paginate='none' query_orderby='date' query_order='DESC' size='fixed' orientation='av-orientation-square' gap='large' overlay_fx='active' id='' caption_elements='title' caption_styling='overlay' caption_display='always' color='' custom_bg='' av-medium-columns='' av-small-columns='' av-mini-columns='' av_uid='av-2ibtovw' custom_class=''] [/av_tab_sub_section][av_tab_sub_section tab_title='Analytics' vertical_align='middle' icon_select='no' icon='ue800' font='entypo-fontello' tab_image='' tab_image_style='' color='' background_color='' src='' attachment='' attachment_size='' background_attachment='scroll' background_position='top left' background_repeat='no-repeat' custom_class='' av_uid='av-1ztjhss'] [av_masonry_entries link='portfolio_entries,1124' wc_prod_visible='' prod_order_by='' prod_order='' sort='no' items='3' columns='3' paginate='none' query_orderby='date' query_order='DESC' size='fixed' orientation='av-orientation-square' gap='large' overlay_fx='active' id='' caption_elements='title' caption_styling='overlay' caption_display='always' color='' custom_bg='' av-medium-columns='' av-small-columns='' av-mini-columns='' av_uid='av-1satp18' custom_class=''] [/av_tab_sub_section][av_tab_sub_section tab_title='Platform' vertical_align='middle' icon_select='no' icon='ue800' font='entypo-fontello' tab_image='' tab_image_style='' color='' background_color='' src='' attachment='' attachment_size='' background_attachment='scroll' background_position='top left' background_repeat='no-repeat' custom_class='' av_uid='av-14gy7h8'] [av_masonry_entries link='portfolio_entries,1125' wc_prod_visible='' prod_order_by='' prod_order='' sort='no' items='3' columns='3' paginate='none' query_orderby='date' query_order='DESC' size='fixed' orientation='av-orientation-square' gap='large' overlay_fx='active' id='' caption_elements='title' caption_styling='overlay' caption_display='always' color='' custom_bg='' av-medium-columns='' av-small-columns='' av-mini-columns='' av_uid='av-r6kews' custom_class=''] [/av_tab_sub_section][/av_tab_section] [av_section min_height='' min_height_px='500px' padding='default' shadow='no-border-styling' bottom_border='no-border-styling' bottom_border_diagonal_color='#333333' bottom_border_diagonal_direction='' bottom_border_style='' custom_arrow_bg='' id='' color='main_color' custom_bg='' src='https://www.ironsidegroup.com/wp-content/uploads/2018/03/yellow-rudder-1500x630.png' attachment='16316' attachment_size='featured_large' attach='parallax' position='center center' repeat='no-repeat' video='' video_ratio='16:9' overlay_opacity='0.5' overlay_color='' overlay_pattern='' overlay_custom_pattern='' av_element_hidden_in_editor='0' custom_class='' av_uid='av-3e8pueh'] [av_one_full first min_height='' vertical_alignment='av-align-top' space='' margin='0px' margin_sync='true' padding='50px,0px,0px,0px' border='' border_color='' radius='10px,10px,0,' background_color='#ffffff' src='' attachment='' attachment_size='' background_position='top left' background_repeat='no-repeat' animation='' mobile_breaking='' mobile_display='' custom_class='' av_uid='av-320m815'] [av_heading tag='h2' padding='10' heading='Become one of our successful clients.' color='' style='blockquote modern-quote modern-centered' custom_font='' size='' subheading_active='' subheading_size='15' custom_class='' admin_preview_bg='' av-desktop-hide='' av-medium-hide='' av-small-hide='' av-mini-hide='' av-medium-font-size-title='' av-small-font-size-title='' av-mini-font-size-title='' av-medium-font-size='' av-small-font-size='' av-mini-font-size='' av_uid='av-2os9ax5'][/av_heading] [/av_one_full][av_one_fourth first min_height='av-equal-height-column' vertical_alignment='av-align-top' space='no_margin' margin='0px' margin_sync='true' padding='0px,0px,50px,0px' border='' border_color='' radius='0px,0px,0px,10px' background_color='#ffffff' src='' attachment='' attachment_size='' background_position='top left' background_repeat='no-repeat' animation='' mobile_breaking='' mobile_display='' custom_class='' av_uid='av-28fflmx'] [/av_one_fourth][av_one_half min_height='' vertical_alignment='av-align-top' space='' margin='0px' margin_sync='true' padding='30px,40px,50px,40px' border='' border_color='' radius='0px' radius_sync='true' background_color='#ffffff' src='' attachment='' attachment_size='' background_position='top left' background_repeat='no-repeat' animation='' mobile_breaking='' mobile_display='' custom_class='' av_uid='av-1rz7q7d'] [av_button_big label='Take our Data & Analytics Self-Assessment' description_pos='below' link='page,15594' link_target='' icon_select='no' icon='ue800' font='entypo-fontello' custom_font='#ffffff' color='custom' custom_bg='#00aec7' color_hover='theme-color' custom_bg_hover='#444444' custom_class='' admin_preview_bg='' av_uid='av-4pr12h'][/av_button_big] [/av_one_half][av_one_fourth min_height='' vertical_alignment='av-align-top' space='' margin='0px' margin_sync='true' padding='0px' padding_sync='true' border='' border_color='' radius='0px,0px,10px,0px' background_color='#ffffff' src='' attachment='' attachment_size='' background_position='top left' background_repeat='no-repeat' animation='' mobile_breaking='' mobile_display='' custom_class='' av_uid='av-2cum7d'] [/av_one_fourth] [/av_section]
,

Formulate a Predictive Admissions Strategy

/by

ANALYTICS | CASE STUDY

Formulate a Predictive Admissions Strategy

COMPANY OVERVIEW


A leading New England technical institute that looking for a way to refine its admissions process.

BUSINESS NEED


The college was struggling to admit the right students to their academic programs – specifically, students who would continue at the school beyond their freshman year. The school needed a way of evaluating prospective students’ likelihood of success that was integrated into the admissions process and provided actionable recommendations admissions officers could use.

SOLUTION


The client’s leadership team brought in Ironside data scientists to help realize the full potential of their data by doing the following:


Plan an Approach


  • Collect necessary historical and current data from relevant departments and cleanse it

  • Evaluate predictive approaches and choose the most effective model

  • Feed predictive results into BI ecosystem to allow visually rich report displays and comparison with actuals

  • Score prospective students dynamically as information comes in to direct admissions decisions


Prepare the Data


  • Get individualized scores for each prospective student by preparing and transforming their historical admissions data to work in a predictive model

  • Select meaningful categories of information and merge data source formats from different departments into a standard presentation


Test and Integrate Models


  • Isolate useful data sources and build a clear project roadmap

  • Prepare data sets for predictive modeling, ensuring quality and standardizing format

  • Test modeling approaches and integrate best results into the BI workflow

  • Work prospective student scores into BI reports for easy comparison and consumption

  • Automate score updates to provide admissions with the most current model results in real time

  • Create easy to interpret recommendations individualized to each candidate to allow quick action


Inform Action


  • Output a score alongside current reporting numbers

  • Translate projections into usable recommendations for admissions counselors

  • Allow for full collaboration and rapid response across all functions related to admissions, such as financial aid and business offices, optimizing planning

  • Boost flexibility, allowing instant adjustments to the database to reflect predictions


KEYS TO SUCCESS


The client achieved successes through predictive admissions that enabled them to:

  • Connect data resources from multiple departments to allow a full view of admissions variables

  • Provide easy access to incentivization recommendations for desirable prospects

  • Unify BI actuals with predictive admissions strategy for comparisons and constant refinement

  • Deliver real-time recommendations empowering admissions counselors in a timely fashion

[av_section min_height='custom' min_height_px='0' padding='default' shadow='no-border-styling' bottom_border='no-border-styling' bottom_border_diagonal_color='#333333' bottom_border_diagonal_direction='' bottom_border_style='' custom_arrow_bg='' id='' color='main_color' custom_bg='' src='' attachment='' attachment_size='' attach='scroll' position='top left' repeat='no-repeat' video='' video_ratio='16:9' overlay_opacity='0.5' overlay_color='' overlay_pattern='' overlay_custom_pattern='' av_element_hidden_in_editor='0' custom_class='' av_uid='av-93vd1yh'] [av_one_full first min_height='' vertical_alignment='av-align-top' space='no_margin' margin='0px' margin_sync='true' padding='0px' padding_sync='true' border='' border_color='' radius='0px' radius_sync='true' background_color='' src='' attachment='' attachment_size='' background_position='top left' background_repeat='no-repeat' animation='pop-up' mobile_breaking='' mobile_display='' custom_class='' av_uid='av-8blbyo9'] [av_heading tag='h3' padding='0' heading='READ ADDITIONAL CASE STUDIES' color='' style='blockquote modern-quote modern-centered' custom_font='' size='' subheading_active='' subheading_size='15' custom_class='' admin_preview_bg='' av-desktop-hide='' av-medium-hide='' av-small-hide='' av-mini-hide='' av-medium-font-size-title='' av-small-font-size-title='' av-mini-font-size-title='' av-medium-font-size='' av-small-font-size='' av-mini-font-size='' av_uid='av-tl2oyx'][/av_heading] [/av_one_full] [/av_section] [av_tab_section transition='av-tab-slide-transition' padding='default' tab_pos='av-tab-above-content' content_height='' tab_padding='default' initial='3' id='' av_element_hidden_in_editor='0' av_admin_tab_active='4' bg_color='#f4f3f3' color='' av_uid='av-4iskq8s' custom_class=''] [av_tab_sub_section tab_title='Strategy' vertical_align='middle' icon_select='no' icon='ue800' font='entypo-fontello' tab_image='' tab_image_style='' color='' background_color='' src='' attachment='' attachment_size='' background_attachment='scroll' background_position='top left' background_repeat='no-repeat' custom_class='' av_uid='av-3ua41ek'] [av_masonry_entries link='portfolio_entries,1122' wc_prod_visible='' prod_order_by='' prod_order='' sort='no' items='3' columns='3' paginate='none' query_orderby='date' query_order='DESC' size='fixed' orientation='av-orientation-square' gap='large' overlay_fx='active' id='' caption_elements='title' caption_styling='overlay' caption_display='always' color='' custom_bg='' av-medium-columns='' av-small-columns='' av-mini-columns='' av_uid='av-3inv0xo' custom_class=''] [/av_tab_sub_section][av_tab_sub_section tab_title='Data' vertical_align='middle' icon_select='no' icon='ue800' font='entypo-fontello' tab_image='' tab_image_style='' color='' background_color='' src='' attachment='' attachment_size='' background_attachment='scroll' background_position='top left' background_repeat='no-repeat' custom_class='' av_uid='av-2x2nruk'] [av_masonry_entries link='portfolio_entries,1123' wc_prod_visible='' prod_order_by='' prod_order='' sort='no' items='3' columns='3' paginate='none' query_orderby='date' query_order='DESC' size='fixed' orientation='av-orientation-square' gap='large' overlay_fx='active' id='' caption_elements='title' caption_styling='overlay' caption_display='always' color='' custom_bg='' av-medium-columns='' av-small-columns='' av-mini-columns='' av_uid='av-2ibtovw' custom_class=''] [/av_tab_sub_section][av_tab_sub_section tab_title='Analytics' vertical_align='middle' icon_select='no' icon='ue800' font='entypo-fontello' tab_image='' tab_image_style='' color='' background_color='' src='' attachment='' attachment_size='' background_attachment='scroll' background_position='top left' background_repeat='no-repeat' custom_class='' av_uid='av-1ztjhss'] [av_masonry_entries link='portfolio_entries,1124' wc_prod_visible='' prod_order_by='' prod_order='' sort='no' items='3' columns='3' paginate='none' query_orderby='date' query_order='DESC' size='fixed' orientation='av-orientation-square' gap='large' overlay_fx='active' id='' caption_elements='title' caption_styling='overlay' caption_display='always' color='' custom_bg='' av-medium-columns='' av-small-columns='' av-mini-columns='' av_uid='av-1satp18' custom_class=''] [/av_tab_sub_section][av_tab_sub_section tab_title='Platform' vertical_align='middle' icon_select='no' icon='ue800' font='entypo-fontello' tab_image='' tab_image_style='' color='' background_color='' src='' attachment='' attachment_size='' background_attachment='scroll' background_position='top left' background_repeat='no-repeat' custom_class='' av_uid='av-14gy7h8'] [av_masonry_entries link='portfolio_entries,1125' wc_prod_visible='' prod_order_by='' prod_order='' sort='no' items='3' columns='3' paginate='none' query_orderby='date' query_order='DESC' size='fixed' orientation='av-orientation-square' gap='large' overlay_fx='active' id='' caption_elements='title' caption_styling='overlay' caption_display='always' color='' custom_bg='' av-medium-columns='' av-small-columns='' av-mini-columns='' av_uid='av-r6kews' custom_class=''] [/av_tab_sub_section][/av_tab_section] [av_section min_height='' min_height_px='500px' padding='default' shadow='no-border-styling' bottom_border='no-border-styling' bottom_border_diagonal_color='#333333' bottom_border_diagonal_direction='' bottom_border_style='' custom_arrow_bg='' id='' color='main_color' custom_bg='' src='https://www.ironsidegroup.com/wp-content/uploads/2018/03/yellow-rudder-1500x630.png' attachment='16316' attachment_size='featured_large' attach='parallax' position='center center' repeat='no-repeat' video='' video_ratio='16:9' overlay_opacity='0.5' overlay_color='' overlay_pattern='' overlay_custom_pattern='' av_element_hidden_in_editor='0' custom_class='' av_uid='av-3e8pueh'] [av_one_full first min_height='' vertical_alignment='av-align-top' space='' margin='0px' margin_sync='true' padding='50px,0px,0px,0px' border='' border_color='' radius='10px,10px,0,' background_color='#ffffff' src='' attachment='' attachment_size='' background_position='top left' background_repeat='no-repeat' animation='' mobile_breaking='' mobile_display='' custom_class='' av_uid='av-320m815'] [av_heading tag='h2' padding='10' heading='Become one of our successful clients.' color='' style='blockquote modern-quote modern-centered' custom_font='' size='' subheading_active='' subheading_size='15' custom_class='' admin_preview_bg='' av-desktop-hide='' av-medium-hide='' av-small-hide='' av-mini-hide='' av-medium-font-size-title='' av-small-font-size-title='' av-mini-font-size-title='' av-medium-font-size='' av-small-font-size='' av-mini-font-size='' av_uid='av-2os9ax5'][/av_heading] [/av_one_full][av_one_fourth first min_height='av-equal-height-column' vertical_alignment='av-align-top' space='no_margin' margin='0px' margin_sync='true' padding='0px,0px,50px,0px' border='' border_color='' radius='0px,0px,0px,10px' background_color='#ffffff' src='' attachment='' attachment_size='' background_position='top left' background_repeat='no-repeat' animation='' mobile_breaking='' mobile_display='' custom_class='' av_uid='av-28fflmx'] [/av_one_fourth][av_one_half min_height='' vertical_alignment='av-align-top' space='' margin='0px' margin_sync='true' padding='30px,40px,50px,40px' border='' border_color='' radius='0px' radius_sync='true' background_color='#ffffff' src='' attachment='' attachment_size='' background_position='top left' background_repeat='no-repeat' animation='' mobile_breaking='' mobile_display='' custom_class='' av_uid='av-1rz7q7d'] [av_button_big label='Take our Data & Analytics Self-Assessment' description_pos='below' link='page,15594' link_target='' icon_select='no' icon='ue800' font='entypo-fontello' custom_font='#ffffff' color='custom' custom_bg='#00aec7' color_hover='theme-color' custom_bg_hover='#444444' custom_class='' admin_preview_bg='' av_uid='av-4pr12h'][/av_button_big] [/av_one_half][av_one_fourth min_height='' vertical_alignment='av-align-top' space='' margin='0px' margin_sync='true' padding='0px' padding_sync='true' border='' border_color='' radius='0px,0px,10px,0px' background_color='#ffffff' src='' attachment='' attachment_size='' background_position='top left' background_repeat='no-repeat' animation='' mobile_breaking='' mobile_display='' custom_class='' av_uid='av-2cum7d'] [/av_one_fourth] [/av_section]
,

Maximize Efficiency for Utilities Demand Forecasting

/by

ANALYTICS | CASE STUDY

Maximize Efficiency for Utilities Demand Forecasting

COMPANY OVERVIEW


A natural gas and electricity utilities provider that serves nearly 4 million customers and invests over $1 billion in capital each year to improve service.

BUSINESS NEED


The company was struggling to accurately anticipate how much demand different areas of their network would have. This led to supply problems and scrambles to fill service gaps. They needed a predictive modeling platform that could automate processes and maximize efficiency by allowing accurate, proactive supply adjustment.

SOLUTION


The client’s leadership team brought Ironside on as an expert resource to help with the following:


Discover Data Resources


  • Assess existing data quality and refine it for use in new predictive models

  • Run prepared data against regression and time series analysis algorithms

  • Implement a single platform for predictive analytics using SPSS Modeler and C&DS

  • Connect demand forecasts to the company’s energy management system


Prepare the Data


  • Leverage skills of analysts and Ironside experts to clean, transform and impute demand data from over 40 different geographic points of delivery

  • Enrich the core facts with geographic and weather data to account for the factors affecting utilities usage in each area


Develop & Test the Model


  • Refine and consolidate data from all points of delivery

  • Migrate to a more extensible and flexible predictive analytics solution

  • Test multiple predictive modeling approaches to find the most relevant

  • Reduce the need for manual rework of results through standard workflows

  • Automate connections between predictive analytics tools and other analytics assets/operational systems

  • Mentor internal resources to show future possibilities for predictive analytics and build comfort with the platform


Deploy to the Organization


  • Integrate the projections with their BI platform to compare against actuals

  • Use each point of delivery’s forecasts to trigger automated alerts in the energy management system upon generation

  • Allow proactive energy supply adjustments in different geographies based on predictive trends


KEYS TO SUCCESS


The demand forecasting project enabled the client to:

  • Increase data richness to generate more accurate and flexible predictive modeling results

  • Boost visibility and actionability of demand forecasts through energy management system integration

  • Empower internal analyst resources through a formal platform and hands-on mentorship

  • Implement a flexible SPSS predictive analytics platform able to extend to additional use cases

About IBM

IBM is a leading cloud platform and cognitive solutions company. Leverage IBM’s Analytics portfolio of high-value products and solutions to turn the company you’re running today into the company you’re building for tomorrow.

[av_section min_height='custom' min_height_px='0' padding='default' shadow='no-border-styling' bottom_border='no-border-styling' bottom_border_diagonal_color='#333333' bottom_border_diagonal_direction='' bottom_border_style='' custom_arrow_bg='' id='' color='main_color' custom_bg='' src='' attachment='' attachment_size='' attach='scroll' position='top left' repeat='no-repeat' video='' video_ratio='16:9' overlay_opacity='0.5' overlay_color='' overlay_pattern='' overlay_custom_pattern='' av_element_hidden_in_editor='0' custom_class='' av_uid='av-93vd1yh'] [av_one_full first min_height='' vertical_alignment='av-align-top' space='no_margin' margin='0px' margin_sync='true' padding='0px' padding_sync='true' border='' border_color='' radius='0px' radius_sync='true' background_color='' src='' attachment='' attachment_size='' background_position='top left' background_repeat='no-repeat' animation='pop-up' mobile_breaking='' mobile_display='' custom_class='' av_uid='av-8blbyo9'] [av_heading tag='h3' padding='0' heading='READ ADDITIONAL CASE STUDIES' color='' style='blockquote modern-quote modern-centered' custom_font='' size='' subheading_active='' subheading_size='15' custom_class='' admin_preview_bg='' av-desktop-hide='' av-medium-hide='' av-small-hide='' av-mini-hide='' av-medium-font-size-title='' av-small-font-size-title='' av-mini-font-size-title='' av-medium-font-size='' av-small-font-size='' av-mini-font-size='' av_uid='av-tl2oyx'][/av_heading] [/av_one_full] [/av_section] [av_tab_section transition='av-tab-slide-transition' padding='default' tab_pos='av-tab-above-content' content_height='' tab_padding='default' initial='3' id='' av_element_hidden_in_editor='0' av_admin_tab_active='4' bg_color='#f4f3f3' color='' av_uid='av-4iskq8s' custom_class=''] [av_tab_sub_section tab_title='Strategy' vertical_align='middle' icon_select='no' icon='ue800' font='entypo-fontello' tab_image='' tab_image_style='' color='' background_color='' src='' attachment='' attachment_size='' background_attachment='scroll' background_position='top left' background_repeat='no-repeat' custom_class='' av_uid='av-3ua41ek'] [av_masonry_entries link='portfolio_entries,1122' wc_prod_visible='' prod_order_by='' prod_order='' sort='no' items='3' columns='3' paginate='none' query_orderby='date' query_order='DESC' size='fixed' orientation='av-orientation-square' gap='large' overlay_fx='active' id='' caption_elements='title' caption_styling='overlay' caption_display='always' color='' custom_bg='' av-medium-columns='' av-small-columns='' av-mini-columns='' av_uid='av-3inv0xo' custom_class=''] [/av_tab_sub_section][av_tab_sub_section tab_title='Data' vertical_align='middle' icon_select='no' icon='ue800' font='entypo-fontello' tab_image='' tab_image_style='' color='' background_color='' src='' attachment='' attachment_size='' background_attachment='scroll' background_position='top left' background_repeat='no-repeat' custom_class='' av_uid='av-2x2nruk'] [av_masonry_entries link='portfolio_entries,1123' wc_prod_visible='' prod_order_by='' prod_order='' sort='no' items='3' columns='3' paginate='none' query_orderby='date' query_order='DESC' size='fixed' orientation='av-orientation-square' gap='large' overlay_fx='active' id='' caption_elements='title' caption_styling='overlay' caption_display='always' color='' custom_bg='' av-medium-columns='' av-small-columns='' av-mini-columns='' av_uid='av-2ibtovw' custom_class=''] [/av_tab_sub_section][av_tab_sub_section tab_title='Analytics' vertical_align='middle' icon_select='no' icon='ue800' font='entypo-fontello' tab_image='' tab_image_style='' color='' background_color='' src='' attachment='' attachment_size='' background_attachment='scroll' background_position='top left' background_repeat='no-repeat' custom_class='' av_uid='av-1ztjhss'] [av_masonry_entries link='portfolio_entries,1124' wc_prod_visible='' prod_order_by='' prod_order='' sort='no' items='3' columns='3' paginate='none' query_orderby='date' query_order='DESC' size='fixed' orientation='av-orientation-square' gap='large' overlay_fx='active' id='' caption_elements='title' caption_styling='overlay' caption_display='always' color='' custom_bg='' av-medium-columns='' av-small-columns='' av-mini-columns='' av_uid='av-1satp18' custom_class=''] [/av_tab_sub_section][av_tab_sub_section tab_title='Platform' vertical_align='middle' icon_select='no' icon='ue800' font='entypo-fontello' tab_image='' tab_image_style='' color='' background_color='' src='' attachment='' attachment_size='' background_attachment='scroll' background_position='top left' background_repeat='no-repeat' custom_class='' av_uid='av-14gy7h8'] [av_masonry_entries link='portfolio_entries,1125' wc_prod_visible='' prod_order_by='' prod_order='' sort='no' items='3' columns='3' paginate='none' query_orderby='date' query_order='DESC' size='fixed' orientation='av-orientation-square' gap='large' overlay_fx='active' id='' caption_elements='title' caption_styling='overlay' caption_display='always' color='' custom_bg='' av-medium-columns='' av-small-columns='' av-mini-columns='' av_uid='av-r6kews' custom_class=''] [/av_tab_sub_section][/av_tab_section] [av_section min_height='' min_height_px='500px' padding='default' shadow='no-border-styling' bottom_border='no-border-styling' bottom_border_diagonal_color='#333333' bottom_border_diagonal_direction='' bottom_border_style='' custom_arrow_bg='' id='' color='main_color' custom_bg='' src='https://www.ironsidegroup.com/wp-content/uploads/2018/03/yellow-rudder-1500x630.png' attachment='16316' attachment_size='featured_large' attach='parallax' position='center center' repeat='no-repeat' video='' video_ratio='16:9' overlay_opacity='0.5' overlay_color='' overlay_pattern='' overlay_custom_pattern='' av_element_hidden_in_editor='0' custom_class='' av_uid='av-3e8pueh'] [av_one_full first min_height='' vertical_alignment='av-align-top' space='' margin='0px' margin_sync='true' padding='50px,0px,0px,0px' border='' border_color='' radius='10px,10px,0,' background_color='#ffffff' src='' attachment='' attachment_size='' background_position='top left' background_repeat='no-repeat' animation='' mobile_breaking='' mobile_display='' custom_class='' av_uid='av-320m815'] [av_heading tag='h2' padding='10' heading='Become one of our successful clients.' color='' style='blockquote modern-quote modern-centered' custom_font='' size='' subheading_active='' subheading_size='15' custom_class='' admin_preview_bg='' av-desktop-hide='' av-medium-hide='' av-small-hide='' av-mini-hide='' av-medium-font-size-title='' av-small-font-size-title='' av-mini-font-size-title='' av-medium-font-size='' av-small-font-size='' av-mini-font-size='' av_uid='av-2os9ax5'][/av_heading] [/av_one_full][av_one_fourth first min_height='av-equal-height-column' vertical_alignment='av-align-top' space='no_margin' margin='0px' margin_sync='true' padding='0px,0px,50px,0px' border='' border_color='' radius='0px,0px,0px,10px' background_color='#ffffff' src='' attachment='' attachment_size='' background_position='top left' background_repeat='no-repeat' animation='' mobile_breaking='' mobile_display='' custom_class='' av_uid='av-28fflmx'] [/av_one_fourth][av_one_half min_height='' vertical_alignment='av-align-top' space='' margin='0px' margin_sync='true' padding='30px,40px,50px,40px' border='' border_color='' radius='0px' radius_sync='true' background_color='#ffffff' src='' attachment='' attachment_size='' background_position='top left' background_repeat='no-repeat' animation='' mobile_breaking='' mobile_display='' custom_class='' av_uid='av-1rz7q7d'] [av_button_big label='Take our Data & Analytics Self-Assessment' description_pos='below' link='page,15594' link_target='' icon_select='no' icon='ue800' font='entypo-fontello' custom_font='#ffffff' color='custom' custom_bg='#00aec7' color_hover='theme-color' custom_bg_hover='#444444' custom_class='' admin_preview_bg='' av_uid='av-4pr12h'][/av_button_big] [/av_one_half][av_one_fourth min_height='' vertical_alignment='av-align-top' space='' margin='0px' margin_sync='true' padding='0px' padding_sync='true' border='' border_color='' radius='0px,0px,10px,0px' background_color='#ffffff' src='' attachment='' attachment_size='' background_position='top left' background_repeat='no-repeat' animation='' mobile_breaking='' mobile_display='' custom_class='' av_uid='av-2cum7d'] [/av_one_fourth] [/av_section]
,

Enable Self-Service Analytics

/by

ANALYTICS | CASE STUDY

Enable Self-Service Analytics

COMPANY OVERVIEW


Major regional bank and financial services provider that’s been in business for almost 200 years, with over $140 billion in total assets and more than 1,000 branches.

BUSINESS NEED


The company was experiencing consistency issues with reporting. IT believed the answer was to enable users to be more self-sufficient, but disparate results from multiple sources were causing confusion. The bank needed a centralized self-service solution to help users get reliable business information independent of IT, and in the process, build on the bank’s solid enterprise analytics foundation.

SOLUTION


The Ironside Business Intelligence team’s approach is based on balance. It is equal parts governance and flexibility, with an emphasis on delivering BI solutions that enable both scheduled reporting results and spontaneous investigations into new business questions. The solution consists of:


Focus on Data


  • Focus on risk-related information, using a performance and balance metrics delivered in multiple business contexts through a multidimensional cube for easy viewing

  • Determine how to present data from the cube to increase user adoption, consistency of experience and ability of users to test scenarios and get meaningful results on their own


Experience Design


  • Create a UX in which user needs, technology and business goals smoothly intersect

  • Set up a self-service extracts capability for non-technical users who need access to risk data contained in their cube, so they can pull information in real time simply by selecting a business dimension


Portal Creation


  • Create an easy-to-use, unified portal through which users can access multiple, useful analytics functions

  • Set up a simplified interface containing preconfigured reporting options designed to answer common questions about risk data occurring across different departments


Benchmarking


  • Establish a set of limits and benchmarks to determine risks of different portfolios

  • Build a limits management solution into the portal, letting users add different limits and benchmarks to their reports, while making quick performance comparisons between different areas


KEYS TO SUCCESS


This Self-Service Analytics project allowed the company to:

  • Increase user adoption of analytics resources, and establish user trust in data

  • Enable consistent reporting based on verified data across different business groups

  • Implement a simple yet flexible self-service model that’s repeatable across departments

  • Provide measurable corporate benchmarks to focus user efforts on company goals

[av_section min_height='custom' min_height_px='0' padding='default' shadow='no-border-styling' bottom_border='no-border-styling' bottom_border_diagonal_color='#333333' bottom_border_diagonal_direction='' bottom_border_style='' custom_arrow_bg='' id='' color='main_color' custom_bg='' src='' attachment='' attachment_size='' attach='scroll' position='top left' repeat='no-repeat' video='' video_ratio='16:9' overlay_opacity='0.5' overlay_color='' overlay_pattern='' overlay_custom_pattern='' av_element_hidden_in_editor='0' custom_class='' av_uid='av-93vd1yh'] [av_one_full first min_height='' vertical_alignment='av-align-top' space='no_margin' margin='0px' margin_sync='true' padding='0px' padding_sync='true' border='' border_color='' radius='0px' radius_sync='true' background_color='' src='' attachment='' attachment_size='' background_position='top left' background_repeat='no-repeat' animation='pop-up' mobile_breaking='' mobile_display='' custom_class='' av_uid='av-8blbyo9'] [av_heading tag='h3' padding='0' heading='READ ADDITIONAL CASE STUDIES' color='' style='blockquote modern-quote modern-centered' custom_font='' size='' subheading_active='' subheading_size='15' custom_class='' admin_preview_bg='' av-desktop-hide='' av-medium-hide='' av-small-hide='' av-mini-hide='' av-medium-font-size-title='' av-small-font-size-title='' av-mini-font-size-title='' av-medium-font-size='' av-small-font-size='' av-mini-font-size='' av_uid='av-tl2oyx'][/av_heading] [/av_one_full] [/av_section] [av_tab_section transition='av-tab-slide-transition' padding='default' tab_pos='av-tab-above-content' content_height='' tab_padding='default' initial='3' id='' av_element_hidden_in_editor='0' av_admin_tab_active='4' bg_color='#f4f3f3' color='' av_uid='av-4iskq8s' custom_class=''] [av_tab_sub_section tab_title='Strategy' vertical_align='middle' icon_select='no' icon='ue800' font='entypo-fontello' tab_image='' tab_image_style='' color='' background_color='' src='' attachment='' attachment_size='' background_attachment='scroll' background_position='top left' background_repeat='no-repeat' custom_class='' av_uid='av-3ua41ek'] [av_masonry_entries link='portfolio_entries,1122' wc_prod_visible='' prod_order_by='' prod_order='' sort='no' items='3' columns='3' paginate='none' query_orderby='date' query_order='DESC' size='fixed' orientation='av-orientation-square' gap='large' overlay_fx='active' id='' caption_elements='title' caption_styling='overlay' caption_display='always' color='' custom_bg='' av-medium-columns='' av-small-columns='' av-mini-columns='' av_uid='av-3inv0xo' custom_class=''] [/av_tab_sub_section][av_tab_sub_section tab_title='Data' vertical_align='middle' icon_select='no' icon='ue800' font='entypo-fontello' tab_image='' tab_image_style='' color='' background_color='' src='' attachment='' attachment_size='' background_attachment='scroll' background_position='top left' background_repeat='no-repeat' custom_class='' av_uid='av-2x2nruk'] [av_masonry_entries link='portfolio_entries,1123' wc_prod_visible='' prod_order_by='' prod_order='' sort='no' items='3' columns='3' paginate='none' query_orderby='date' query_order='DESC' size='fixed' orientation='av-orientation-square' gap='large' overlay_fx='active' id='' caption_elements='title' caption_styling='overlay' caption_display='always' color='' custom_bg='' av-medium-columns='' av-small-columns='' av-mini-columns='' av_uid='av-2ibtovw' custom_class=''] [/av_tab_sub_section][av_tab_sub_section tab_title='Analytics' vertical_align='middle' icon_select='no' icon='ue800' font='entypo-fontello' tab_image='' tab_image_style='' color='' background_color='' src='' attachment='' attachment_size='' background_attachment='scroll' background_position='top left' background_repeat='no-repeat' custom_class='' av_uid='av-1ztjhss'] [av_masonry_entries link='portfolio_entries,1124' wc_prod_visible='' prod_order_by='' prod_order='' sort='no' items='3' columns='3' paginate='none' query_orderby='date' query_order='DESC' size='fixed' orientation='av-orientation-square' gap='large' overlay_fx='active' id='' caption_elements='title' caption_styling='overlay' caption_display='always' color='' custom_bg='' av-medium-columns='' av-small-columns='' av-mini-columns='' av_uid='av-1satp18' custom_class=''] [/av_tab_sub_section][av_tab_sub_section tab_title='Platform' vertical_align='middle' icon_select='no' icon='ue800' font='entypo-fontello' tab_image='' tab_image_style='' color='' background_color='' src='' attachment='' attachment_size='' background_attachment='scroll' background_position='top left' background_repeat='no-repeat' custom_class='' av_uid='av-14gy7h8'] [av_masonry_entries link='portfolio_entries,1125' wc_prod_visible='' prod_order_by='' prod_order='' sort='no' items='3' columns='3' paginate='none' query_orderby='date' query_order='DESC' size='fixed' orientation='av-orientation-square' gap='large' overlay_fx='active' id='' caption_elements='title' caption_styling='overlay' caption_display='always' color='' custom_bg='' av-medium-columns='' av-small-columns='' av-mini-columns='' av_uid='av-r6kews' custom_class=''] [/av_tab_sub_section][/av_tab_section] [av_section min_height='' min_height_px='500px' padding='default' shadow='no-border-styling' bottom_border='no-border-styling' bottom_border_diagonal_color='#333333' bottom_border_diagonal_direction='' bottom_border_style='' custom_arrow_bg='' id='' color='main_color' custom_bg='' src='https://www.ironsidegroup.com/wp-content/uploads/2018/03/yellow-rudder-1500x630.png' attachment='16316' attachment_size='featured_large' attach='parallax' position='center center' repeat='no-repeat' video='' video_ratio='16:9' overlay_opacity='0.5' overlay_color='' overlay_pattern='' overlay_custom_pattern='' av_element_hidden_in_editor='0' custom_class='' av_uid='av-3e8pueh'] [av_one_full first min_height='' vertical_alignment='av-align-top' space='' margin='0px' margin_sync='true' padding='50px,0px,0px,0px' border='' border_color='' radius='10px,10px,0,' background_color='#ffffff' src='' attachment='' attachment_size='' background_position='top left' background_repeat='no-repeat' animation='' mobile_breaking='' mobile_display='' custom_class='' av_uid='av-320m815'] [av_heading tag='h2' padding='10' heading='Become one of our successful clients.' color='' style='blockquote modern-quote modern-centered' custom_font='' size='' subheading_active='' subheading_size='15' custom_class='' admin_preview_bg='' av-desktop-hide='' av-medium-hide='' av-small-hide='' av-mini-hide='' av-medium-font-size-title='' av-small-font-size-title='' av-mini-font-size-title='' av-medium-font-size='' av-small-font-size='' av-mini-font-size='' av_uid='av-2os9ax5'][/av_heading] [/av_one_full][av_one_fourth first min_height='av-equal-height-column' vertical_alignment='av-align-top' space='no_margin' margin='0px' margin_sync='true' padding='0px,0px,50px,0px' border='' border_color='' radius='0px,0px,0px,10px' background_color='#ffffff' src='' attachment='' attachment_size='' background_position='top left' background_repeat='no-repeat' animation='' mobile_breaking='' mobile_display='' custom_class='' av_uid='av-28fflmx'] [/av_one_fourth][av_one_half min_height='' vertical_alignment='av-align-top' space='' margin='0px' margin_sync='true' padding='30px,40px,50px,40px' border='' border_color='' radius='0px' radius_sync='true' background_color='#ffffff' src='' attachment='' attachment_size='' background_position='top left' background_repeat='no-repeat' animation='' mobile_breaking='' mobile_display='' custom_class='' av_uid='av-1rz7q7d'] [av_button_big label='Take our Data & Analytics Self-Assessment' description_pos='below' link='page,15594' link_target='' icon_select='no' icon='ue800' font='entypo-fontello' custom_font='#ffffff' color='custom' custom_bg='#00aec7' color_hover='theme-color' custom_bg_hover='#444444' custom_class='' admin_preview_bg='' av_uid='av-4pr12h'][/av_button_big] [/av_one_half][av_one_fourth min_height='' vertical_alignment='av-align-top' space='' margin='0px' margin_sync='true' padding='0px' padding_sync='true' border='' border_color='' radius='0px,0px,10px,0px' background_color='#ffffff' src='' attachment='' attachment_size='' background_position='top left' background_repeat='no-repeat' animation='' mobile_breaking='' mobile_display='' custom_class='' av_uid='av-2cum7d'] [/av_one_fourth] [/av_section]
,

Transition to Bimodal BI Migration in Health Insurance

/by

ANALYTICS | CASE STUDY

Transition to Bimodal BI Migration in Health Insurance

COMPANY OVERVIEW


Fortune 500 health insurance company with over $30 billion in revenue, more than 30,000 employees worldwide, and over 85 million customer relationships.

BUSINESS NEED


The company’s business users were hungry for analytics results, but weren’t getting them in time due to an aging Hyperion reporting system. IT regularly ran several hundred tabular-style reports on request, but users had to export and manually manipulate them to get insights. The need, therefore, was to find a way to get fresh data to business users as questions arose, while also maintaining regular reporting on core metrics.

SOLUTION


Ironside Analytics Advisory is all about developing and implementing a practical strategy, which involved helping the client do the following:


Evaluate the Options


  • Assess current analytics strategy in light of new goal of evolving analytics delivery

  • Run an assessment workshop to determine how to best capture and meet users’ needs

  • Explore two delivery directions—a report redesign or migration of key reports to Tableau or Cognos


Build a Migration Plan


  • Pick the use case that fits the desired bimodal approach and map the transition away from the current solution

  • Build strategy based on assessment findings and user goals, including establishing which reports/SQR extracts to migrate, and setting a timeline for project milestones


Perform the Migration


  • Enlist Ironside Solution Center consultants to move through the many reports isolated for transfer, determine the changes required to migrate them to Tableau or Cognos, and migrate each report

  • Work with client’s internal team to rapidly transition and test the assets


Foster User Adoption


  • Provide Tableau training with Ironside instructors to promote use of self-service platform

  • Transition migrated tabular data into visualizations for new insights

  • Keep admin control with IT through central Tableau server, plus regular Cognos KPI reporting


KEYS TO SUCCESS


The bimodal analytics migration allowed stakeholders to:

  • Answer their own questions through a central, pain-free, data discovery oriented BI platform

  • Make decisions more efficiently, without affecting IT governance or the reports essential for performance checks

  • Create a central repository for storing/sharing analysis results, allowing reuse and IT oversight

  • Have an enhanced user experience through intuitive controls and easy visualization generation

  • Increase speed to action, removing obstacles between business stakeholders and data

[av_section min_height='custom' min_height_px='0' padding='default' shadow='no-border-styling' bottom_border='no-border-styling' bottom_border_diagonal_color='#333333' bottom_border_diagonal_direction='' bottom_border_style='' custom_arrow_bg='' id='' color='main_color' custom_bg='' src='' attachment='' attachment_size='' attach='scroll' position='top left' repeat='no-repeat' video='' video_ratio='16:9' overlay_opacity='0.5' overlay_color='' overlay_pattern='' overlay_custom_pattern='' av_element_hidden_in_editor='0' custom_class='' av_uid='av-93vd1yh'] [av_one_full first min_height='' vertical_alignment='av-align-top' space='no_margin' margin='0px' margin_sync='true' padding='0px' padding_sync='true' border='' border_color='' radius='0px' radius_sync='true' background_color='' src='' attachment='' attachment_size='' background_position='top left' background_repeat='no-repeat' animation='pop-up' mobile_breaking='' mobile_display='' custom_class='' av_uid='av-8blbyo9'] [av_heading tag='h3' padding='0' heading='READ ADDITIONAL CASE STUDIES' color='' style='blockquote modern-quote modern-centered' custom_font='' size='' subheading_active='' subheading_size='15' custom_class='' admin_preview_bg='' av-desktop-hide='' av-medium-hide='' av-small-hide='' av-mini-hide='' av-medium-font-size-title='' av-small-font-size-title='' av-mini-font-size-title='' av-medium-font-size='' av-small-font-size='' av-mini-font-size='' av_uid='av-tl2oyx'][/av_heading] [/av_one_full] [/av_section] [av_tab_section transition='av-tab-slide-transition' padding='default' tab_pos='av-tab-above-content' content_height='' tab_padding='default' initial='3' id='' av_element_hidden_in_editor='0' av_admin_tab_active='4' bg_color='#f4f3f3' color='' av_uid='av-4iskq8s' custom_class=''] [av_tab_sub_section tab_title='Strategy' vertical_align='middle' icon_select='no' icon='ue800' font='entypo-fontello' tab_image='' tab_image_style='' color='' background_color='' src='' attachment='' attachment_size='' background_attachment='scroll' background_position='top left' background_repeat='no-repeat' custom_class='' av_uid='av-3ua41ek'] [av_masonry_entries link='portfolio_entries,1122' wc_prod_visible='' prod_order_by='' prod_order='' sort='no' items='3' columns='3' paginate='none' query_orderby='date' query_order='DESC' size='fixed' orientation='av-orientation-square' gap='large' overlay_fx='active' id='' caption_elements='title' caption_styling='overlay' caption_display='always' color='' custom_bg='' av-medium-columns='' av-small-columns='' av-mini-columns='' av_uid='av-3inv0xo' custom_class=''] [/av_tab_sub_section][av_tab_sub_section tab_title='Data' vertical_align='middle' icon_select='no' icon='ue800' font='entypo-fontello' tab_image='' tab_image_style='' color='' background_color='' src='' attachment='' attachment_size='' background_attachment='scroll' background_position='top left' background_repeat='no-repeat' custom_class='' av_uid='av-2x2nruk'] [av_masonry_entries link='portfolio_entries,1123' wc_prod_visible='' prod_order_by='' prod_order='' sort='no' items='3' columns='3' paginate='none' query_orderby='date' query_order='DESC' size='fixed' orientation='av-orientation-square' gap='large' overlay_fx='active' id='' caption_elements='title' caption_styling='overlay' caption_display='always' color='' custom_bg='' av-medium-columns='' av-small-columns='' av-mini-columns='' av_uid='av-2ibtovw' custom_class=''] [/av_tab_sub_section][av_tab_sub_section tab_title='Analytics' vertical_align='middle' icon_select='no' icon='ue800' font='entypo-fontello' tab_image='' tab_image_style='' color='' background_color='' src='' attachment='' attachment_size='' background_attachment='scroll' background_position='top left' background_repeat='no-repeat' custom_class='' av_uid='av-1ztjhss'] [av_masonry_entries link='portfolio_entries,1124' wc_prod_visible='' prod_order_by='' prod_order='' sort='no' items='3' columns='3' paginate='none' query_orderby='date' query_order='DESC' size='fixed' orientation='av-orientation-square' gap='large' overlay_fx='active' id='' caption_elements='title' caption_styling='overlay' caption_display='always' color='' custom_bg='' av-medium-columns='' av-small-columns='' av-mini-columns='' av_uid='av-1satp18' custom_class=''] [/av_tab_sub_section][av_tab_sub_section tab_title='Platform' vertical_align='middle' icon_select='no' icon='ue800' font='entypo-fontello' tab_image='' tab_image_style='' color='' background_color='' src='' attachment='' attachment_size='' background_attachment='scroll' background_position='top left' background_repeat='no-repeat' custom_class='' av_uid='av-14gy7h8'] [av_masonry_entries link='portfolio_entries,1125' wc_prod_visible='' prod_order_by='' prod_order='' sort='no' items='3' columns='3' paginate='none' query_orderby='date' query_order='DESC' size='fixed' orientation='av-orientation-square' gap='large' overlay_fx='active' id='' caption_elements='title' caption_styling='overlay' caption_display='always' color='' custom_bg='' av-medium-columns='' av-small-columns='' av-mini-columns='' av_uid='av-r6kews' custom_class=''] [/av_tab_sub_section][/av_tab_section] [av_section min_height='' min_height_px='500px' padding='default' shadow='no-border-styling' bottom_border='no-border-styling' bottom_border_diagonal_color='#333333' bottom_border_diagonal_direction='' bottom_border_style='' custom_arrow_bg='' id='' color='main_color' custom_bg='' src='https://www.ironsidegroup.com/wp-content/uploads/2018/03/yellow-rudder-1500x630.png' attachment='16316' attachment_size='featured_large' attach='parallax' position='center center' repeat='no-repeat' video='' video_ratio='16:9' overlay_opacity='0.5' overlay_color='' overlay_pattern='' overlay_custom_pattern='' av_element_hidden_in_editor='0' custom_class='' av_uid='av-3e8pueh'] [av_one_full first min_height='' vertical_alignment='av-align-top' space='' margin='0px' margin_sync='true' padding='50px,0px,0px,0px' border='' border_color='' radius='10px,10px,0,' background_color='#ffffff' src='' attachment='' attachment_size='' background_position='top left' background_repeat='no-repeat' animation='' mobile_breaking='' mobile_display='' custom_class='' av_uid='av-320m815'] [av_heading tag='h2' padding='10' heading='Become one of our successful clients.' color='' style='blockquote modern-quote modern-centered' custom_font='' size='' subheading_active='' subheading_size='15' custom_class='' admin_preview_bg='' av-desktop-hide='' av-medium-hide='' av-small-hide='' av-mini-hide='' av-medium-font-size-title='' av-small-font-size-title='' av-mini-font-size-title='' av-medium-font-size='' av-small-font-size='' av-mini-font-size='' av_uid='av-2os9ax5'][/av_heading] [/av_one_full][av_one_fourth first min_height='av-equal-height-column' vertical_alignment='av-align-top' space='no_margin' margin='0px' margin_sync='true' padding='0px,0px,50px,0px' border='' border_color='' radius='0px,0px,0px,10px' background_color='#ffffff' src='' attachment='' attachment_size='' background_position='top left' background_repeat='no-repeat' animation='' mobile_breaking='' mobile_display='' custom_class='' av_uid='av-28fflmx'] [/av_one_fourth][av_one_half min_height='' vertical_alignment='av-align-top' space='' margin='0px' margin_sync='true' padding='30px,40px,50px,40px' border='' border_color='' radius='0px' radius_sync='true' background_color='#ffffff' src='' attachment='' attachment_size='' background_position='top left' background_repeat='no-repeat' animation='' mobile_breaking='' mobile_display='' custom_class='' av_uid='av-1rz7q7d'] [av_button_big label='Take our Data & Analytics Self-Assessment' description_pos='below' link='page,15594' link_target='' icon_select='no' icon='ue800' font='entypo-fontello' custom_font='#ffffff' color='custom' custom_bg='#00aec7' color_hover='theme-color' custom_bg_hover='#444444' custom_class='' admin_preview_bg='' av_uid='av-4pr12h'][/av_button_big] [/av_one_half][av_one_fourth min_height='' vertical_alignment='av-align-top' space='' margin='0px' margin_sync='true' padding='0px' padding_sync='true' border='' border_color='' radius='0px,0px,10px,0px' background_color='#ffffff' src='' attachment='' attachment_size='' background_position='top left' background_repeat='no-repeat' animation='' mobile_breaking='' mobile_display='' custom_class='' av_uid='av-2cum7d'] [/av_one_fourth] [/av_section]
© 1999-2024 Ironside Group. All Rights Reserved.