This 2 day course is intended to train you on Power Pivot and Power BI. Power Pivot for Excel and its close cousin Power BI Desktop are Microsoft's tightly-related pair of revolutionary analytical tools - tools that are fundamentally changing the way organizations work with data. Their shared state of the art calculation engines (DAZ and M) turn any PC into an analytical supercomputer, but the real secret is people - these tools are 100% learnable by today's users of Excel.
This course will discuss the various methods and best practices that are in line with business and technical requirements for modeling, visualizing, and analyzing data with Power BI. The course will also show how to access and process data from a range of data sources including both relational and non-relational data.his course will also explore how to implement proper security standards and policies across the Power BI spectrum including datasets and groups.
The audience for this course are data professionals and business intelligence professionals who want to learn how to accurately perform data analysis using Power BI. This course is also targeted toward those individuals who develop reports that visualize data from the data platform technologies that exist on both in the cloud and on-premises.
Prerequisites
Before attending this course, students must have:
Basic knowledge of the Microsoft Windows operating system and its core functionality.
Advanced working knowledge of Excel spreadsheets including formulas..
*Course Cost listed does not include the cost of courseware or exam. Course is subject to a minimum enrollment to run. Course may run virtually as a Virtual Instructor-Led (VILT) class if the minimum enrollment is not met. If the course is under the minimum enrollment the course may run as 1 day class (Bootcamp Style). For more information, please contact learn@vtec.org or call 207-775-0244.