
Implementing Data Models with SQL Server
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
- SQL Server 2014 Editions6:231 credit or ad
- SQL Server Management Tools5:271 credit or ad
- SQL Server Data Tools7:341 credit or ad
- Integration Services5:541 credit or ad
- Analysis Services6:011 credit or ad
- Reporting Services6:091 credit or ad
- BI Clients5:341 credit or ad
- Data Quality Services6:161 credit or ad
- Master Data Services4:441 credit or ad
Getting Set Up15 lessons
- What You Will Need4:371 credit or ad
- Hardware Requirements3:371 credit or ad
- Software Requirements5:221 credit or ad
- Getting SQL Server 20143:141 credit or ad
- Getting Visual Studio Community 20134:581 credit or ad
- Installing SQL Server 2014 pt. 16:491 credit or ad
- Installing SQL Server 2014 pt. 25:071 credit or ad
- SSDT-BI5:401 credit or ad
- Installing SSDT-BI3:011 credit or ad
- Tools Tour4:471 credit or ad
- Sample Databases2:271 credit or ad
- Installing Sample Databases pt. 16:201 credit or ad
- Installing Sample Databases pt. 23:061 credit or ad
- Working with Diagrams6:121 credit or ad
- SQL Server Connection Issue2:571 credit or ad
Understanding Business Intelligence6 lessons
Data Warehouse Basics3 lessons
Multidimensional Cube Development29 lessons
- Multidimensional Basics6:251 credit or ad
- Creating a Cube with SSDT6:311 credit or ad
- Creating a Cube Data Source6:171 credit or ad
- Creating a Data Source View pt. 16:341 credit or ad
- Creating a Data Source View pt. 22:541 credit or ad
- Making the Data User Friendly3:461 credit or ad
- Named Calculations6:201 credit or ad
- Creating the Cube6:521 credit or ad
- Creating Dimensions First4:151 credit or ad
- Formatting Output6:431 credit or ad
- Formatting Utility4:351 credit or ad
- Using the Dimension Designer6:471 credit or ad
- Understanding Attributes6:291 credit or ad
- Understanding Hierarchies pt. 16:241 credit or ad
- Understanding Hierarchies pt. 23:151 credit or ad
- User-Defined Hierarchies pt. 16:351 credit or ad
- User-Defined Hierarchies pt. 22:591 credit or ad
- Attribute Relationships5:021 credit or ad
- Creating Attribute Relationships pt. 16:351 credit or ad
- Creating Attribute Relationships pt. 25:011 credit or ad
- Defining Calculated Members pt. 16:281 credit or ad
- Defining Calculated Members pt. 24:561 credit or ad
- Understanding KPIs4:561 credit or ad
- Creating a KPI pt. 16:551 credit or ad
- Creating a KPI pt. 27:121 credit or ad
- Aggregations6:411 credit or ad
- Creating Aggregations7:151 credit or ad
- Translations6:061 credit or ad
- Partitions2:551 credit or ad
Multidimensional Queries6 lessons
Tabular Model Development14 lessons
- SSAS Tabular Basics6:441 credit or ad
- Creating a Tabular Project5:531 credit or ad
- Importing Data6:471 credit or ad
- Creating Measures6:281 credit or ad
- Analyze in Excel Button3:571 credit or ad
- Deploying a Tabular Model4:521 credit or ad
- Calculated Columns4:141 credit or ad
- Creating Hierarchies pt. 16:341 credit or ad
- Creating Hierarchies pt. 26:451 credit or ad
- Creating Hierarchies pt. 36:481 credit or ad
- DAX Basics5:061 credit or ad
- Calculated Column or Measure5:121 credit or ad
- Perspectives4:141 credit or ad
- Creating KPIs4:441 credit or ad