Business Intelligence Featuring Microsoft's Power BI Tools
Full Day Course
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 are 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 7 hours
- Instructional delivery method: This course will be taught in Excel for Office 365 and Power BI Desktop with reference to the differences to Excel 2013 and subsequent. The program focuses on Excel for Windows and Power BI desktop and we encourage you to bring your windows laptop equipped with Excel 2010 or newer, Power BI Desktop and Power Query to follow along with the instructor.
- Prerequisites: Basic understanding of computer operations and terminology, including Microsoft Office Excel
- Program level: Advanced
- Advance preparation: Download and install the free Power BI desktop application from https://powerbi.microsoft.com/en-us/desktop/ . For users of Excel 2010 and subsequent download and install the free Power Query for Excel add-in from http://bit.ly/K2E_PowerQuery
- Who should participate: Business professionals seeking to develop and implement BI solutions