The Inside Story: Self-Service-BI in MS Excel 2013

MP4 | Video: AVC 1280x720 | Audio: AAC 44KHz 2ch | Duration: 2 Hours | Lec: 15 | 655 MB

Genre: eLearning | Language: English

Be a master in self-service business intelligence tools in MS Excel

This course is intended for the data analysts and end users who are willing to explore the self-service business intelligence tools in Microsoft Excel 2013. This training is best suited for all business professionals: data analysts, developers, IT professionals, project leads, and project managers.

At the end of the course, participants would learn/use/acquire the following techniques/knowledge:

Explore and connect to data sources using Power Query

Using ETL techniques to gather data from multiple sources - Wikipedia, Oracle MySQL DB & others

Comprehend the Power Pivot user interface

Extract and transform data using Power Query

Build a cascading relationship and manage data models

Build a relationship between tables from different sources

The course discusses the rationale for self-service BI, and describes how to use Microsoft SQL Server Reporting Services, Microsoft Excel, Microsoft SharePoint Server, and Microsoft Office 365 to create self-service data models and reports. This course is designed for customers who are interested in learning Self-Service BI tools and techniques.