Business Intelligence
Featuring Microsoft's Power BI Tools
Half Day Course - New Course for 2017!
In today’s business climate, Business Intelligence (BI) is perhaps the hottest topic in most professional circles. Increasingly, organizations of all sizes are seeking to take advantage of the data that is available to them 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 – ranging 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.
In this program, you will learn how to implement “do it yourself business intelligence” using a variety of techniques and tools. You will learn how to work with some of the advanced data query and summarization features in Excel to create Excel-based dashboards and then you will learn how to leverage that knowledge to build even more powerful BI objects using Microsoft’s Power BI tools. If gaining greater insights into your data to make better decisions is of interest to you, then join us for a fast-paced look at how you can take advantage of these fantastic tools.
In this program, you will learn how to implement “do it yourself business intelligence” using a variety of techniques and tools. You will learn how to work with some of the advanced data query and summarization features in Excel to create Excel-based dashboards and then you will learn how to leverage that knowledge to build even more powerful BI objects using Microsoft’s Power BI tools. If gaining greater insights into your data to make better decisions is of interest to you, then join us for a fast-paced look at how you can take advantage of these fantastic tools.
Learning Objectives
Upon completing this course, you should be able to:
- 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 be useful in BI applications
- Differentiate between the BI opportunities in Excel and Power BI
- Create and distribute dashboards using Power BI
Course Information
- CPE credit: Recommended for one day of credit
- Instructional delivery method: Group-live demo and discussion – we encourage you to bring your laptop equipped with Excel 2013 or newer and Power BI Desktop (PowerBI desktop is free and is available for download and installation from https://powerbi.microsoft.com ; this should be done at your office before the course). The program focuses on Excel for Windows and is not intended for Excel for macOS.
- Prerequisites: Basic understanding of computer operations and terminology, including Microsoft Office Excel
- Program level: Advanced
- Advance preparation: None
- Who should attend: Business professionals seeking to develop and implement BI solutions
Note: This course will be taught in Excel 2016. Reference will be made to the differences between Excel 2016 and Excel 2013, 2010 and 2007.