Applied Microsoft Visualization Tools
Reporting is an essential feature of every business intelligence solution. One way to extract and disseminate the wealth of information is to author Reporting Services standard “paginated” reports that end users can review and print. Starting with SQL Server 2016, BI developers can also create reports that are optimized for mobile devices. And when interactive data exploration is preferred, end user can use Excel, Power View, or Power BI to create their own reports.
This two-day class is designed to help you learn the visualization tools that are included in the Microsoft Data Analytics Platform. We’ll start by exploring the Excel reporting capabilities that include pivot (PivotTable and PivotChart) and Power View reports. Then, you’ll learn how to explore data interactively with Power BI Desktop. During the second day of the class, we’ll focus on learning how to create paginated reports with Reporting Services. The class can be customized to discuss other tools, such as SSRS mobile reports or Power Map reports.
Audience
- Business users
- Data analysts
- BI developers
Prerequisites
- Experience with MS Excel
- Basic report authoring experience with Reporting Services
Hardware and software requirements
- Windows 7 or above
- Excel 2013 or above
- Power BI Desktop
- AdventureWorks and AdventureWorksDW databases
- Detailed software setup instructions will be sent before the event