Lynda - Power BI [Business-Intellegence] Features in Depth

Lynda.com - Power BI Features in Depth
5h 49m Intermediate Jun 30, 2014 Uploaded in Jul 2014, by 2boweb


Learn how you can easily search, access, and analyze data inside and outside of your organization in just a few clicks with Power BI—the business intelligence features that lie inside Microsoft Office. Author Gini Courter walks you through two toolsets: the self-service BI tools that only require Excel, and Power BI, which relies on Office 365. Using the Power Query, Power Pivot, Power Map, and Power View tools in Excel 2013, you'll learn to connect to local and remote data sources, model that data, and present your findings in the form of tables, charts, maps, and reports. Then Gini switches to Power BI to enhance and share the queries and reports you just created. As you'll soon find in the course of these tutorials, Microsoft's BI tools allow you to use the software you already know and love to analyze and share complex business data.
Topics include:

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