NOTE: This class was presented during the 2017 NextGen User Group Meeting on Tuesday, November 7, 2017.
Contains course materials from the UGM 2017 Presentation EPM 200 - Using Microsoft Reporting Tools to build Reports from the NextGen Database.
This class covered concepts related to creating, populating, and structuring data for a Data Warehouse, and using Microsoft's Power BI product to import and analyze that data.
The resulting Report was shared using one of the Power BI publishing mechanisms called "Publishing to Web", which both FREE and PRO User Accounts of Power BI can do. We created a Tiny URL to more easily access the report.
The Report Link:
Course materials include:
• Instructions regarding the project files for download.
• Updated PowerPoint Presentation File.
• Microsoft Power BI Project File (PBIX) containing the sample Report shown in the actual UGM Presentation.
• SQL Server 2012 Database Backup (BAK) of the sample Data Warehouse Database.
• T-SQL Scripts to create the contents of the Data Warehouse (for SQL Server 2008R2 and earlier).
Questions about the course, materials, or the report can be emailed me at: firstname.lastname@example.org
All questions about Microsoft Power BI can be answered by reading about the product. Visit this excellent resource page:
The PowerPoint Presentation Files, Sample Data Warehouse backup files, any T-SQL Scripts, Power BI PBIX files, and Installation Documentation are provided free of charge for instructional purposes only, and are not supported by NextGen.
Microsoft Word, PowerPoint, SQL Server and Power BI are registered trademarks of Microsoft Corporation.