by Scot J. Reagin | Released October 2017 | ISBN: 0134840909

6+ Hours of Video Instruction Prepare for Microsoft Exam 70-768: Developing SQL Data Models and develop practical Business Intelligence (BI) skills with more than 6 hours of video instruction and hands-on demonstrations. Description SQL Server Analysis Services (SSAS) provides a robust semantic environment for modeling data in support of analytic and ad hoc reporting needs. With each release of SQL Server, SSAS functionality is enhanced, with tabular models in particular becoming more capable and fully featured. In this video, Scot Reagin couples discussion with demonstration to give you not just an understanding of the functional differences between multidimensional and tabular models, but also the context to understand where and why each should be implemented. In addition to a comprehensive discussion of design and implementation topics, Scot covers techniques for developing queries using multidimensional and data analysis expressions, optimizing processing and query performance, and configuring and maintaining SSAS.About the InstructorScot Reagin has a technology career that spans the entire history of what we now think of as Business Intelligence. Starting with software he developed for mini-computers in the early 1980s to the first Cube technologies of the 1990s and Self-Service BI and contemporary Predictive Analytics, Scot has consistently designed, developed, and delivered solutions for organizations across the evolving BI marketplace. Scot is a TDWI Certified Business Intelligence Professional and Board Member of the Colorado Data Warehouse Institute. He is also a Certified Data Vault Data Modeler and active member of the Genesee Academy. Skill Level IntermediateLearn How ToDesign a multidimensional semantic modelDesign a tabular semantic modelDevelop queries using MDX and DAXConfigure and maintain SSASWho Should Take This CourseIT professionals responsible for designing, developing, maintaining, or administering SQL Server Analysis Services (SSAS)BI developers pursuing Microsoft CertificationCourse RequirementsBasic understanding of relational databases and SQL queriesFamiliarity with Microsoft SQL Server client toolsLesson DescriptionsLesson 1, Designing a Multidimensional Semantic Model, covers building a multidimensional semantic model—a Cube. Create the fundamental components for the model, dimensions, and measures as a project and deploy this to Analysis Service. Lesson 2, Designing a Tabular Semantic Model, demonstrates how to build and deploy tabular models while exploring security and refresh options. Lesson 3, Developing Queries Using MDX and DAX, covers developing queries and expressions using MDX and DAX. Understanding these query languages is essential to optimizing Analysis Services models—whether multidimensional or tabular. Lesson 4, Configuring and Maintaining SSAS, looks at ways to monitor and configure Analysis Services for best performance. About Pearson Video Training Pearson publishes expert-led video tutorials covering a wide selection of technology topics designed to teach you the skills you need to succeed. These professional and personal technology videos feature world-leading author instructors published by your trusted technology brands: Addison-Wesley, Cisco Press, Pearson IT Certification, Prentice Hall, Sams, and Que Topics include: IT Certification, Network Security, Cisco Technology, Programming, Web Development, Mobile Development, and more. Learn more about Pearson Video training at http://www.informit.com/video. Show and hide more

1. Introduction
   • SQL Server 70-768: Introduction 00:03:23
2. Lesson 1: Designing a Multidimensional Semantic Model
   • Learning objectives 00:01:07
   • 1.1 Create a multidimensional database 00:19:29
   • 1.2 Choose a dimensional model 00:17:41
   • 1.3 Define attribute relationships 00:16:47
   • 1.4 Create measures and measure groups 00:18:27
   • 1.5 Define aggregation functions 00:15:01
3. Lesson 2: Designing a Tabular Semantic Model
   • Learning objectives 00:00:56
   • 2.1 Create a tabular model 00:16:26
   • 2.2 Deploy and process a tabular model 00:19:12
   • 2.3 Configure tabular model storage and refresh settings 00:15:14
   • 2.4 Configure user and data security 00:10:52
4. Lesson 3: Developing Queries Using MDX and DAX
   • Learning objectives 00:01:17
   • 3.1 Understand MDX fundamentals 00:19:48
   • 3.2 Use MDX calculated members and sets 00:25:30
   • 3.3 Use MDX functions 00:16:56
   • 3.4 Use the SCOPE statement 00:11:16
   • 3.5 Create MDX solutions 00:06:06
   • 3.6 Use the EVALUATE and CALCULATE functions 00:10:00
   • 3.7 Create calculated measures 00:10:36
   • 3.8 Perform data analysis with DAX 00:08:10
5. Lesson 4: Configuring and Maintaining SSAS
   • Learning objectives 00:01:08
   • 4.1 Plan and deploy SSAS 00:19:57
   • 4.2 Monitor performance 00:12:18
   • 4.3 Identify bottlenecks and improve performance 00:08:11
   • 4.4 Configure limits and model design 00:10:48
   • 4.5 Configure partition processing 00:23:20
   • 4.6 Configure dimension processing 00:11:33
   • 4.7 Create KPIs in cubes 00:18:58
   • 4.8 Create KPIs in tabular models 00:08:25
   • 4.9 Create actions 00:13:23
   • 4.10 Create translations 00:10:18
6. Summary
   • SQL Server 70-768: Summary 00:01:39
Show and hide more



9780134840901.sql.server.70.768.OR.part1.rar

9780134840901.sql.server.70.768.OR.part2.rar

9780134840901.sql.server.70.768.OR.part3.rar