AuthorGini von Courter
- Understanding data analysis and business intelligence
- Installing Office BI add-ins
- Searching for online data with Power Query
- Shaping data in the Query Editor
- Connecting to data sources
- Modeling data with Power Pivot
- Enhancing PivotTables and PivotCharts with PowerPoint
- Visualizing geospatial data with Power Map
- Creating and formatting Power View reports
- Sharing your data using Power BI for Office 365
Skill Level Intermediate
(musical tones) - [Voiceover] Welcome to Power BI Features in Depth. In this course, we'll use two different Excel 2013 tool sets, the four self-service BI tools that only require Excel, and the power BI tools that work with Office 365. First I'll show you how to use Excel 2013 and the free add-ins PowerPivot, Power Query, Power View, and Power Map, to connect to data sources online and on your computer, build data models that are powerful, and summarize, analyze, and present your data in tables, charts, maps, and reports.
Then, we'll switch to Power BI, and see how you can share those queries and reports that you've already created using the new Office 365 Power BI tools. If you're comfortable with Excel features, like tables, charts, and pivot tables, and are ready to do more with your data, then I designed this course for you. Let's get started.
1. Getting Started: Self-Service, Power BI, and BI Tools
2. Using Power Query to Get Data
3. Modeling Your Data with Power Pivot
4. Enhancing PivotTables and PivotCharts with Power Pivot
5. Expanding the Data Model in Power Pivot
6. Visualizing Geospatial Data with Power Map
7. Creating and Formatting Power View Reports
8. Creating Other Power View Visualizations
9. Sharing Your Data Using Power BI for Office 365
Next steps2m 59s
- Mark as unwatched
- Mark all as unwatched
Are you sure you want to mark all the videos in this course as unwatched?
This will not affect your course history, your reports, or your certificates of completion for this course.Cancel
Take notes with your new membership!
Type in the entry box, then click Enter to save your note.
1:30Press on any video thumbnail to jump immediately to the timecode shown.
Notes are saved with you account but can also be exported as plain text, MS Word, PDF, Google Doc, or Evernote.