This event has ended

Self-Service BI with Excel and Power BI

Puerto Rico Professional Association for SQL Server

Friday, April 11, 2014 from 9:00 AM to 5:00 PM (AST)

Guaynabo, Puerto Rico

Self-Service BI with Excel and Power BI

Registration Information

No registrations are available

Who's Going

Loading your connections...

Share Self-Service BI with Excel and Power BI

Event Details

WHERE:
Microsoft Puerto Rico (Click here for a map)
City View Plaza II Suite 107
State Road 165 Km 1.2
Guaynabo, PR  00968

 

Self-Service BI with Excel and Power BI

 

Presenters: Rafael Salas & Javier Guillen

 

This is a full day of intensive training designed to provide you with the required knowledge to design and create Business Intelligence solutions leveraging the latest version of Microsoft self-service BI tools: Power BI. You will learn how to use Power Query for Excel to explore, collect a combine data from heterogeneous sources and then how to create data models and calculations using in-memory analytics with Power Pivot for Excel. You will see how to create interactive data visualizations within Excel using Power View and Power Maps. Finally, we will look at Power BI deployment options into Office 365 and provide you with guidelines to make architectural and design decisions when building self-service BI solutions. 

 

Rafael Salas is a recognized speaker and published author with more than 15 years of experience in Business Intelligence and Information Architecture. He is the recipient of multiple industry recognitions, including the Microsoft MVP Award and The Data Warehouse Institute Best Practices Award. Rafael is also an active member of the SQL Server technical community and blogs regularly at www.rafael-salas.com.


Javier GuillenJavier Guillen is a Solutions Architect for BlueGranite, a Microsoft Gold Partner in Business Intelligence. An active blogger, speaker, and Microsoft community contributor, Javier is particularly interested in SQL Server Analysis Services technology, including Multidimensional and Tabular models, as well as the practical application of MDX and DAX patterns.

 

 

Goals:

 

  • Make a business case for Self-Service BI and understand how it can fit into the overall BI landscape in your organization.
  • Learn how to use Power BI tools in Excel to extract, transform and combine data; 
  • Create models and calculations to support BI analytics and create interactive and rich data visualizations.
  • Understand Power BI deployment options to share and collaborate content.


Pre-requisites:

 

  • There are no pre-requisites for this course
  • Attendees are not required to have Power BI but they are encouraged to bring their laptops with the required software installed if they want to follow examples and demos. Excel 2013 with Power Query, Power Pivot, Power View and Power maps. Excel 2010 can be used for Power Query and Power Pivot exercises.

 

 

OTHER COURSE INFORMATION:

Food:  Lunch will be provided at the event location.

 

Cancellation policy: no cancellations/refunds/exchanges allowed except if event is cancelled for any reason. Full payment is due at the time of registration.

Have questions about Self-Service BI with Excel and Power BI? Contact Puerto Rico Professional Association for SQL Server

When & Where


Microsoft Puerto Rico

Guaynabo, Guaynabo 00968
Puerto Rico

Friday, April 11, 2014 from 9:00 AM to 5:00 PM (AST)


  Add to my calendar

Organizer

Puerto Rico Professional Association for SQL Server

The Puerto Rico Professional Association for SQL Server (PRPASS) is a volunteer organization founded in 2005 with the main objective of providing a learning, networking and collaboration Information Technology (IT) users community for SQL Server professionals. PRPASS is the local Chapter affiliated to PASS, the largest community of SQL Server users in the world.

  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.