OVERVIEW
- 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
|
COURSE DURATION |
LANGUAGE |
CERTIFICATE |
| 2 Days | English | DISS |
| *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 |
|
On 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 your data the way you need to see it. Also, you will learn how to create dashboards with 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
