Generic filters

Building Business Intelligence (BI) in Excel


This course is best suited to anyone in Business Intelligence, data managers, data analysts, or Project Managers. This course would also suit anyone looking to extend their knowledge of Excel to understand some of the more advanced features and how they can be used to work together. At the end of this course you will understand what makes a dashboard. You will learn how to build some of the most useful components when constructing your own dashboard reports.

course details
2 DaysEnglishDISS Certificate
 *Please notify us if an interpretation is required 
course benefits/progression opportunities
Course objectives

All Excel users; some basic Excel experience is preferable but all Excel users, even those  with significant experience, will benefit from learning about the “power-tools” in Excel.  Prior experience with Data Analysis or Business Intelligence is NOT required

course outline

Day 1

In Day 1, you’ll learn how Power Query can clean up, reshape and combine your data with ease – no matter where it comes from. You can convert ASCII files into tables, combine multiple text files in one shot, and even un-pivot data. These techniques are not only simple, but an investment in the future! With Power Query’s robust feature set at your fingertips, and your prepared data, you can begin building BI in Excel using Power Pivot. The best part is that these dynamic business intelligence models are refreshable with a single click.

Day 2

Day 2 focuses on Power Pivot, a technology that is revolutionizing the way that we look at data inside Microsoft Excel. Power Pivot allows you to link multiple tables together without a single VLOOKUP statement. It also enables you to pull data together from different tables, databases, the web, and other sources like never before. But this just scratches the surface! We’ll also focus on proper dimensional modeling techniques and working with DAX formulas to report on your data the way you need to see it.Also you will lear how to create dashboars wirh Power View

course Methodology

The format of the Two-day workshop is a series of brief lectures followed by discussion and hands-on exercises. Case studies and real-life examples are used to illustrate success and failure

Not Sure? Request a call!