Excel 2013 Power BI
Fundamentals
Brandon Neeb | Business Intelligence Professional
Meet Brandon Neeb
Microsoft Sr. Content Publisher
Focused on Office 365, Lync and SharePoint
Industry experience in education, advertising and project
management
Passion for using Microsofts tools to enable better
business insights
Course Topics
Excel 2013 Power BI Fundamentals
Module 1: Exploring Power Query
Module 2: Preparing a Power Pivot Data Model for Power View
Reporting
Module 3: Exploring Power View
Module 4: Exploring Power Map
Setting Expectations
Progressive connected demonstration
Target Audience
Excel users who prepare and present reports
New to Power BI in Excel
Suggested Prerequisites/Supporting Material
Basic Microsoft Excel skills
Conceptual understanding of business data relationships
Join the MVA Community!
Microsoft Virtual Academy
Free online learning tailored for IT Pros and Developers
Over 1M registered users
Up-to-date, relevant training on variety of Microsoft
products
Related MVA courses
Faster Insights to Data with Power BI Jump Start
Comprehensive explanation and demos of Microsofts BI
products
From Data to Insight and Impact: The BI Revolution
More background about BI
Power BI Personas
Stewart
Anna
Joe
Data
Steward
Business
SME
Provisions
and
distributes
High Quality
Analyst
Business
User
Provides
reports and
information
to
managemen
IT Pro
Technical
SME
Provides and
supports IT
Platform
IT
Management
Why use Excel Power BI tools?
Insights in Excel
Discover
Analyze
Visualiz
e
Search, access, and
transform public and
internal data sources with
Power Query
Easy data modeling and
lightning fast in-memory
analytics with Power Pivot
Bold new interactive data
visualizations with Power
View and Power Map
Click to edit
Master subtitle
style
01 | Exploring Power Query
Brandon Neeb| Business Intelligence Professional
Data used in the demo
Sales Analysis.xlsx
DEMO
Enable PowerPivot and Explore Web data
Click to edit
Master subtitle
style
Create a Power Query Query
DEMO
Creating a Power Query Query
Click to edit
Master subtitle
style
Modifying the Power Query Query
DEMO
Modifying the Power Query Query
2013 Microsoft Corporation. All rights reserved. Microsoft, Windows, Office, Azure, System Center, Dynamics and other product names are or may be registered
trademarks and/or trademarks in the U.S. and/or other countries. The information herein is for informational purposes only and represents the current view of
Microsoft Corporation as of the date of this presentation. Because Microsoft must respond to changing market conditions, it should not be interpreted to be a
commitment on the part of Microsoft, and Microsoft cannot guarantee the accuracy of any information provided after the date of this presentation. MICROSOFT
MAKES NO WARRANTIES, EXPRESS, IMPLIED OR STATUTORY, AS TO THE INFORMATION IN THIS PRESENTATION.
