Presented by Stacia Misner and Tyler Chessman
Business intelligence experts Stacia Misner and Tyler Chessman walk you through how to get started with SQL Server’s data visualization tools, including Power Query (formerly known as Data Explorer), Power View, PowerPivot, and Report Builder to find, compile, and graphically display data for analysis by business users.
Who should attend? Database administrators, business analysts, IT pros, database developers, business intelligence professionals.
Session 1: Introducing Power Query (formerly known as Data Explorer) — Tyler Chessman
Microsoft Power Query is a new self-service business intelligence (BI) tool that helps users find and prepare data for analysis. Available as an add-in for both Excel 2013 and Excel 2010, Power Query makes it easier to discover, combine, and refine both public and private data sources. In this session, we will look at how Power Query connects to traditional data sources – and how it brings Internet search capabilities into the realm of BI. We’ll then review the data refinement capabilities of Power Query, including its query formula language.
Session 2: Using Power View for analysis and visualization — Tyler Chessman
Power View is an interactive data exploration, visualization, and presentation technology. First introduced in SharePoint 2010, Power View is now also part of Excel 2013. In this session, you’ll learn how to quickly get up to speed with Power View to analyze and visualize data. We’ll review several tips and tricks to get the most out of Power View – including spatial analysis, drillable charts, and URL parameters for customizing the display of reports. We’ll also discuss the key differences for using Power View in Excel 2013 versus SharePoint.
Session 3: Using PowerPivot — Stacia Misner
Traditional BI solutions often require a team to gather, massage, and load data into structures suitable for analysis, and this process takes time. What if the data you need to analyze today isn't going to be ready until months from now? Or perhaps you have access to a new data source, but no one is certain yet how useful it would be for ongoing decision making. Where is that data going to fit into the BI processes? PowerPivot isn't meant to replace your corporate data warehouse, but rather to complement it with data that you can obtain from all sorts of sources. That way, you can answer a question that's applicable only today or test out theories before committing a team to more development of your corporate solution. In this session, you learn how to get started with PowerPivot by creating a model from multiple data sources and enhancing the model with simple calculations and other techniques to reveal patterns in your data by using data visualization techniques.
Session 4: Self-Service Data Visualization with Report Builder — Stacia Misner
Let's face it. A team of professional report developers is hard-pressed to keep up with the information needs of business users. With some up-front planning, and some features built into SQL Server Reporting Services (SSRS), you can create a self-service BI environment that lets business users help themselves to a variety of data visualizations. With Report Builder, you can give more advanced users the freedom to build sophisticated reports, but provide training wheels for more intrepid users who want attractive reports without learning all the ins and outs of the tool. In this session, you'll learn how to create a self-service environment that lets users who have different skills connect to many different data sources (including Hadoop) without the need to write a query and to construct visualization reports by piecing together multiple pre-constructed report parts.
Stacia Misner is a SQL Server Pro contributing editor, a SQL Server MVP, and a principal consultant at Data Inspirations. She has authored and coauthored several books about business intelligence.
Tyler Chessman is a technology specialist for Microsoft, helping customers evaluate and adopt Microsoft's business intelligence (BI) platform. He's the author of the book Understanding the United States Debt (CreateSpace).
If you have any questions regarding this event, the registration process or would like to register more than one attendee, please contact us directly.
Phone: 800-793-5697 or 913-967-1719