*** Proof of Product ***
Exploring the Essential Features of “Devin Knight – Introduction to SSAS Multidimensional – Pragmatic Works”
WHAT YOU’LL LEARN
- To develop a data warehouse for your company
- To develop a repeatable methodology for a successful SSAS project
- To create and configure a cube and dimensions
- To write MDX (the querying language for cubes)
- To define calculations, Key Performance Indicators (KPIs) and perspectives, and implementing dynamic security
- To administer and deploy SSAS, defining actions, implementing data mining
- To build office-based BI applications and dashboards, and administering SSAS
Course Description
In this course, you’ll learn how to use SSAS in your enterprise. This training takes you from the ground up, teaching you the fundamental skills needed to develop and deploy SSAS solutions and present this new data to your end users.
Instructor
DEVIN KNIGHT
Pragmatic Works President
Devin Knight is a Microsoft Data Platform MVP, Microsoft Certified Trainer, and President of Pragmatic Works Training. He focuses on driving adoption of technology through learning. He is an author of nine Power Platform, Business Intelligence, and SQL Server books. He has been selected as a speaker for conferences like Power Platform Summit, PASS Summit, SQLSaturdays, and Code Camps for many years. Making his home in Jacksonville, FL Devin is a contributing member to several local user groups.
System Requirements
- Microsoft Windows XP Professional, Microsoft Windows Server 2003, 2008, 2012, Microsoft Vista, Windows 7 or Windows 8
- 1 GHz or faster CPU
- 1 GB of available RAM (recommended 2 GB)
- 20 GB of free hard drive space
- SQL Server Developer, Standard or Enterprise Edition 2008/2008R2/2012/2014SQL Server Database Engine
- SQL Server Analysis Services Multidimensional
- SQL Server Data Tools (SQL 2012/2014) or Business Intelligence Development Studio (SQL 2008/2008R2)
- SQL Server Management Studio
- Follow this installation guide (https://file.ac/jmoWZzkHvMo/Pragmatic%20SSAS%20Installation%20Guide.docx) to ensure all items are installed correctly
- **Optional** Data Mining Add-ins for Excel (only compatible with 32-bit Excel) http://tinyurl.com/ExcelDataMining
- AdventureWorksDW2008R2 or AdventureWorksDW2012 databases installed on the instance
What To Know Before Class
This class assumes that you have no previous knowledge of OLAP or Analysis Services. Technical knowledge of basic database design concepts is assumed. It is required that you already know how to navigate around SQL Server 2005/2008/2012/2014 and how to query a SQL Server.
Please see the full list of alternative group-buy courses available here: https://lunacourse.com/shop/
