This event has ended

Self-Service BI Enhancements in Excel and Power BI

SQL Saturday Silicon Valley 2014

Friday, March 14, 2014 from 8:30 AM to 4:00 PM (PDT)

Mountain View, CA

Self-Service BI Enhancements in Excel and Power BI

Ticket Information

Ticket Type Sales End Price Fee Quantity
Ticket + Lunch Ended $149.00 $0.00

Who's Going

Loading your connections...

Share Self-Service BI Enhancements in Excel and Power BI

Event Details

Speaker: Stacia Misner, author and SQL Server MVP

This workshop will show you how to use Excel 2013 BI features toStacia Misner 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.

Have questions about Self-Service BI Enhancements in Excel and Power BI? Contact SQL Saturday Silicon Valley 2014

When & Where



Microsoft Technology Center
1065 La Avenida
Building One
Mountain View, CA 94043

Friday, March 14, 2014 from 8:30 AM to 4:00 PM (PDT)


  Add to my calendar

Organizer

SQL Saturday Silicon Valley 2014

A free one-day training event on March 15, 2014

Location: Microsoft in Mountain View

Learn more and register for SQL Saturday

  Contact the Organizer

Please log in or sign up

In order to purchase these tickets in installments, you'll need an Eventbrite account. Log in or sign up for a free account to continue.