Join us today at noon central for Asgeir presenting for the Excel BI VC.
Thu, Jun 18 2015 12:00 Central Daylight Time
PASS Excel BI VC presents Ásgeir Gunnarsson: End to End Risk Assessment – Using PowerView
END TO END RISK ASSESSMENT – AFFORDABLE SOLUTION USING POWER BI AND EXCEL
Risk assessment is becoming an integral part of many organizations. In order to do it successfully you need to do it regularly and consistently. You need to register the risk factors, the risks them self, evaluate them and then plan the actions required to mitigate them. Besides the registration you need to have compelling and easy reading reports that help managers quickly find how the assessment is going. The familiar Excel interface helps assessors register the risk factors and risks and then plan the actions. The solutions then uses Power Query to load data into PowerPivot without overwriting and the Power View to report the results. The results can then be monitored in Power BI. This method can easily transfer to any other data collection solution such as budgeting or incident registration Decent knowledge of Excel and a familiarity with Power Query, PowerPivot, Power View and Power BI sites
Ásgeir is a Senior Consultant with Capacent Iceland working with Business Intelligence and planning solutions using different software vendors. Ásgeir has been working in BI since 2007 both as a consultant and internal employee. Before turning to BI Ásgeir worked as a technical trainer and currently teaches BI courses at the Continuing Education Department of the University of Iceland. Ásgeir is passionate about data and loves solving problem