Speaker: Stacia Misner, author and SQL Server MVP
This workshop will show you how to use Excel 2013 BI features to transform raw data into powerful insights. Excel 2013 includes built-in self-service business intelligence functionality that allows you to delve deeper into your data. You can use Excel to start analyzing data as a simple data model, and then progressively add more data from a variety of data sources to enrich your analysis. Using the PowerPivot add-in, you can fine-tune the structure of the model to explre and enrich the model with calculations and key performance indicators. You can then add Power View sheets into your workbook to develop interactive data visualizations.
But wait! There’s more! What about Power Query, Power Map, and Power Q&A? Now you can gather and curate data from internal and external sources, transform and visualize that data, and ask natural language questions of your data.
You will learn:
How to Create Models for Data Analysis
Before you can begin exploring the data, you must build a suitable data model. In this session, you’ll learn how to import data into a data model and how to combine data from multiple sources. You’ll also learn how best to structure your data model to support analysis by adding relationships, hierarchies, perspectives, and simple calculations.
How to Work with DAX Formulas to Enhance Your Data Model
By using DAX formulas, you can enrich your PowerPivot model in multiple ways. You’ll learn the principles of working with the DAX language through the development of many different types of calculations. You’ll learn how to create calculated columns to compute new values for each row of imported data, such as the concatenation of multiple columns or the replacement of one string for another. You’ll also learn how to create calculated fields to aggregate data for analysis and key performance indicators to measure progress towards goals. In addition, you’ll learn how evaluation context affects query results.
How to Use Power View to Explore Data for Insight
Although you can explore your data model by using pivot tables and pivot charts in Excel, you can use the new Power View features in Excel 2013 to interactively explore and analyze your data by using a variety of data visualization techniques. You’ll learn how to combine multiple data visualizations into a report that you can filter and highlight to understand the relationships in your data. You’ll also learn the necessary optimizations you should make to your data model to ensure a better data visualization experience with Power View.
Exploring Power BI – Taking Self-Service to the Cloud
Microsoft has added even more functionality to Excel 2013 with Power Query, Power Map, and Power Q & A, while at the same time bringing business intelligence to the cloud. We’ll review the BI components available in the cloud BI stack. We’ll also compare and contrast functionality of the cloud BI tools with on-premises tools. You’ll understand what’s possible and whether it’s time to launch your BI-in-the-cloud solution.
Stacia Misner is a consultant, educator, mentor, and author specializing in Business Intelligence solutions. She is the author and co-author of Microsoft SQL Server 2012 Reporting Services and Business Intelligence in Microsoft SharePoint 2013. Stacia provides consulting and custom education services through Data Inspirations (www.datainspirations.com). She is also a SQL Server MVP and SSAS Maestro.