- View Offline
- 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.