Overview 8.0 Credits ONLINE In today’s business climate, Business Intelligence (BI) is perhaps the hottest topic in most professional circles. Learn how to implement “do-it-yourself business intelligence” using various techniques and tools and how to work with some of the advanced data query and summarization features in Excel to create Excel-based dashboards. Discuss leveraging that knowledge to build even more powerful BI objects using Microsoft’s Power BI tools.Increasingly, organizations of all sizes are seeking to take advantage of the available data to identify previously undiscovered insights and gain competitive advantages thought to be out of reach just a few short years ago. A growing array of tools – from Excel add-ins to dedicated solutions such as Power BI – now allow you to leverage your existing knowledge and skills to create powerful, interactive dashboards and analyses unthinkable until recently.
Objectives Create Excel-based BI dashboards List the potential shortcomings of BI solutions based wholly on Excel Identify and implement various Excel add-ins that might useful in BI applications Differentiate between the BI opportunities in Excel and Power BI Create and distribute dashboards using Power BI
Prerequisite Basic understanding of computer operations and terminology, including Microsoft Office Excel