▄▄▄ ▄▄▄
█████▄ ▄▄▄ ▄█████
▄▄▄▄ ▀█████ ▄▄█▓█████▄▄ █████ ▄▄▄ ▄▄▄▄
▄██████████▄████▓ █████████████ ████ ▄█████ ██████
███▓▀▀▀▀█████▓████ █████▀ ▀████▓ ▓███ ▄██▄ █████▓ ▓██████
░▓███▄ ▄████ ████ █████▓ ▓█████▓███ ████ ██████▄ ▄██████▓
████████████▀ ████ █████ █████████ ████▄██▄███████▄███▀████▓
▀███▄ ▄▄▄ ▄████▀ ▓████ █████████ ████████▓███ ▀██▓▀ ████
▀███▄████▄█████ ██████ ████▓█████▄▓████ ▀▀ ████ ▀ ████
▄████▄ ▀▀████████▓ ███████ ▓▓██▀███▀ ▀██████▄██▄ ███ ████
█████████ ▀█▓▀ █████▄▄ ░▓███████▄▄▄████▄██▓ ▀████████████ ████
██████████▄ ▄▄ ▀▀█████▄▄▓████▀███████▀▄███ ▄▄ ████████████ ▓▄▄▄▄ ████▓░
▓█████████████▓▓█▄▄ ▀▀▓▓█████▓░ ▀▀▀ ▄ ▀████▄ ▀██ ████████████ ████▀ ▄███▓
▀███▓▓▓█████████████▄▄▄ ▀▀███▀ ▄███████▄ ▀▀███▄ ▓ ███▓███▓████ ▓█▀ ▄███▀▀
▀▀▀ ▀▀▀▓▓███▄▄▄▄▄███████▀▀▀▀▓ ▀▀ ███▓ ▀▀ ████ ▀ ▀▓▓█▄▄
▀▀▀▀▀▀ ▀▀ ▀██▀ ▀▀▀▀▀
RELEASE NAME....: Lynda.com.Microsoft.Business.Intelligence.Stack.in.Depth-ELOHiM
RELEASE DATE....: 2014-08-21
RELEASE SIZE....: 18x15Mb
FORMAT..........: Bookware
LANGUAGE........: English
URL.............: http://www.lynda.com
You've gone over the fundamentals. It's time to get into the Microsoft
business intelligence (BI) stack in depth, in this course with Ron Davis.
Ron starts in SQL Server Analysis Services, explaining both the
traditional multidimensional mode and the new tabular mode for viewing
your business's data. Then he moves on to enriching and analyzing your
data with Excel's PowerPivot tool, and sharing your Excel workbooks in
SharePoint. Finally, Ron covers PerformancePoint Services, which allows
you to build dashboards for your data warehouses and other data sources,
and explores designing diagrams and data visualizations with Visio
Services and data mining with Microsoft BI.
Topics include:
* Working with data sources and data views in SQL
* Understanding the star and snowflake database schemas
* Working with the SQL 2012 semantic model (aka tabular mode)
* Using Data Analysis Expressions (DAX)
* Using Excel Web Parts to connect to spreadsheets
* Building dashboards with key performance indicators (KPIs) and reports
* Understanding the Microsoft data-mining process
Author: Ron Davis
Subject: Developer
Software: Excel 2010, SharePoint 2010, SQL Server 2012
Level: Intermediate
Duration: 2h 22m
Released: Aug 20, 2014