VTC Legacy
Home / Databases

Implementing Data Models with SQL Server

by Mark Long
93 lessons10 chapters8.4 hReleased 20159 free
Start the free chapter

Data is the fuel that powers modern business and the ability to aggregate and quickly slice and dice data to make accurate, timely decisions is vital in today's environment.rnrnBusiness intelligence is the set of techniques and tools that transform raw, day-to-day, operational data into categorized, aggregated, useful information for fast business analysis purposes.rnrnMicrosoft's business intelligence tools including SQL Server 2014, SQL Server Analysis Services, Visual Studio/SSDT and Excel provide end users with the power to perform self-service BI and it provides developers the tools they need to create enterprise level BI systems.rnrnIn this course, Mark Long, teaches you how to work with these tools to create multidimensional data cubes and Microsoft's new tabular data model to provide BI services and help you prepare for Microsoft's certification exam 70-466 Implementing Data Models and Reports with SQL Server.

Course content

Welcome and Intro9 lessons
SQL Server 20149 lessons
Getting Set Up15 lessons
Understanding Business Intelligence6 lessons
Data Warehouse Basics3 lessons
Multidimensional Cube Development29 lessons
Multidimensional Queries6 lessons
Tabular Model Development14 lessons
Course Wrap Up1 lessons
About the Author1 lessons