Financial Planning & Analysis
Using Big Data Analytics in Executive Reporting
Big Data analytics tools are becoming more popular in organizations. This discussion examines the role these tools play in reporting to executives and the Board and whether it is a good idea to give executives access to these tools as a substitute for regular reports. Additional conversation includes a look into which visuals should be used when creating these reports, the options for exporting visuals and data, and how to clean up the exports in common office software.
Dave Paradi, Owner, ThinkOutsideTheSlide.com
Evolving the FP&A Function Through Cloud Based Planning Software
Follow the journey of the evaluation, selection and implementation of a cloud-based budgeting and planning tool at Editas: A 4-year-old gene editing company focused on cutting-edge science that is looking to develop transformative medicines for patients. Focus on the evolving needs of finance professionals as we take on broader roles within project management, including the changing dynamics within cloud-based planning and budgeting tools, the process redesign needed to help to support the implementation, and obstacles faced along the way.
Jeff Caravella, FP&A, Sr. Finance Director, Editas Medicine
Build Impactful Financial Dashboards Using Microsoft Power BI
As an FP&A analyst, rather than wrestling with data and queries, wouldn't you rather focus on serving your customer—the business—by providing smart analysis, insights and financial guidance? Meet Microsoft Power BI: the latest and greatest BI tool by Microsoft that's making waves. Power BI makes it super easy to clean up messy data; combine data from multiple sources (e.g., general ledger, personnel); define magical measures that you can use everywhere—say goodbye to filling your sheets with endless formulas; and create beautiful and impactful visualization that you can interact with and ask questions (no more walking out of the meetings with 20 action items). Discover all of this and more as we walk through building an actual financial dashboard using Power BI.
Avi Singh, Founder & CEO, LearnPowerBI.com
Micheal Reynolds, MBA, Manager of FP&A, UnitedLex Corporation
Driving Technology Innovation in FP&A through Staff Development
The pace at which blockchain, machine learning, and artificial intelligence are impacting finance can be overwhelming. Rather than react to solutions pitched by vendors or hoping that internal IT staff will present creative and efficient technological solutions, one FP&A team took steps to become its own technology innovator. Hear how the organization proactively identified tech savvy staff on the existing team and in the hiring process, and then supported them with time and education. As a result, the team was able to develop and implement low-maintenance and low-cost solutions that link operational, financial, and forecast data so that FP&A can stop pulling reports and coloring charts and better analyze and predict the future.
John Bryan, FP&A Supervisor, Chesapeake Corporation
David Adams, Manager - Financial Planning & Analysis, Chesapeake Energy Corporation
It's Not Just Finance: Product Investment Decisions in Corporate Transition
In 2017 CSC and Hewlett Packard Enterprise merged service businesses to form DXC Technology. After the merger an executive investment review committee was established to decide product funding priorities and oversee the new company’s product management organization integration. To effectively identify and fund high value investment opportunities the committee needed to understand product performance, integration progress, and new investments’ potential value creation. However, providing the committee with detailed financial information was a challenge. Attendees learn how financial, operational, management and other information and performance measures can be integrated to enhance new product funding decisions.
Craig Savarese, FP&A, Sr Principal, Decision Support, DXC Technology
Integrating Treasury & FP&A
Sunovion Pharmaceuticals was in the midst of significant organizational changes including acquisitions, new internal financing processes, and major investments to launch products. In this rapidly changing environment, they needed more advanced balance sheet modeling, planning, and cash forecasting capabilities in addition to tight collaboration and integration between treasury and FP&A. Learn how Sunovion met this challenge head on while significantly improving cash forecasting accuracy, deploying a best practice based treasury and FP&A operating model, and leveraging a foundation for continuous improvement.
Alexander Galitsky, Director - Finance Transformation / Strategy & Operations, Peloton Group