Designing Business Intelligence Solutions with Microsoft SQL Server 2012 Video Course

70-467: Designing Business Intelligence Solutions with Microsoft SQL Server 2012

Your Microsoft 70-467 exam is just around the corner, right? So, it's high time to find an effective preparation tool! Our training course is what you really need! This is a series of videos led by the experienced IT instructors who will provide you with a detailed overview of the 70-467 certification test. Ace your Microsoft 70-467 at the first attempt and obtain the Designing Business Intelligence Solutions with Microsoft SQL Server 2012 credential with ease.

# of Students
130
# of Lectures
153
Course Length
4 h
Course Rating
4.5
Price $32.99
Today $29.99

Curriculum for 70-467 Video Course

Designing Business Intelligence Solutions with Microsoft SQL Server 2012

  Video Name Time
  1. Course Introduction 00:30
  2. Course Modules 01:21
  Video Name Time
  1. Introduction to Data Warehousing 00:13
  2. On-Line Transaction Processing (OLTP) vs. OLAP 03:02
  3. Data Warehousing 01:51
  4. Data Warehouse Architecture 01:54
  5. Creating a Data Warehouse Part1 02:51
  6. Creating a Data Warehouse Part2 01:15
  7. Presenting On-Line Analytical Processing (OLAP) Data 04:27
  8. OLTP vs. OLAP Demonstration 04:11
  9. Exam Scenarios 02:43
  10. Module Review 00:46
  Video Name Time
  1. Designing a Data Warehouse 00:04
  2. Data Modeling 01:05
  3. Data Warehouse Schemas 01:38
  4. Time Dimensions 02:05
  5. Data Modeling Considerations 05:14
  6. Implementing a Data Model 01:24
  7. Logical Model 00:38
  8. Physical Model 03:52
  9. Working with Dimensions and Fact Tables 05:18
  10. Exam Scenarios 02:05
  11. Module Review 01:08
  Video Name Time
  1. Extraction, Transformation, and Load (ETL) with SSIS 00:09
  2. Introduction to SQL Server Integration Services (SSIS) 00:54
  3. Upgrading SSIS Packages 01:00
  4. SSIS Tools 00:42
  5. Introduction to Data Flow Tasks 02:05
  6. Data Sources 00:34
  7. Transformations 02:38
  8. Destinations 02:59
  9. Control Flow 01:24
  10. Variables 02:37
  11. Expressions 00:38
  12. Precedence 00:56
  13. Containers 00:22
  14. Control Flow Containers Part1 01:56
  15. Control Flow Containers Part2 02:19
  16. Transactions 01:06
  17. Package Execution with Checkpoints 02:59
  18. Working with SSIS Packages Part1 05:22
  19. Working with SSIS Packages Part2 04:47
  20. Working with SSIS Packages Part3 04:07
  21. Exam Scenarios 02:56
  22. Module Review 01:29
  Video Name Time
  1. Deploying and Securing Packages 00:08
  2. Deploying Options 01:42
  3. Deploying Packages 00:26
  4. Deploying Projects 00:47
  5. Securing Packages 00:59
  6. Deploying and Securing Packages 03:40
  7. Exam Scenarios 02:19
  8. Module Review 01:00
  Video Name Time
  1. SQL Server Reporting Services (SSRS) 00:10
  2. Introduction to Reporting Services Part1 00:10
  3. Introduction to Reporting Services Part2 01:17
  4. SSRS Reports Creation and Delivery 00:33
  5. SSRS Reports 01:24
  6. Grouping 00:51
  7. Expressions 00:31
  8. Drilldown 01:55
  9. Parameters 02:09
  10. Drillthrough 00:58
  11. Visual Components 01:03
  12. Creating Reports Within Reporting Services Part1 04:20
  13. Creating Reports Within Reporting Services Part2 04:34
  14. Creating Reports Within Reporting Services Part3 04:18
  15. Creating Reports Within Reporting Services Part4 03:42
  16. Exam Scenarios 02:48
  17. Module Review 01:11
  Video Name Time
  1. SSRS Reports 00:10
  2. Deploying Reports 00:55
  3. Report Security 04:05
  4. Report Execution 00:53
  5. Report Caching 03:02
  6. Report Snapshot 02:22
  7. Subscriptions 02:12
  8. Data Alerts 01:49
  9. Deploying Reports and Report Security Part1 04:50
  10. Deploying Reports and Report Security Part2 02:48
  11. Exam Scenarios 02:05
  12. Module Review 01:00
  Video Name Time
  1. Multidimensional Cubes 00:07
  2. Introduction to Cubes Part1 00:11
  3. Introduction to Cubes Part2 00:47
  4. Components of a Multidimensional Cubes 01:18
  5. Measures 01:06
  6. Measure Format and Aggregation Functions 01:45
  7. Measure Groups Part1 01:37
  8. Measure Groups Part2 02:04
  9. Aggregations 00:56
  10. Dimensions 00:53
  11. Dimension Storage 00:49
  12. Dimensions Hierarchies 01:47
  13. Grouping and Sorting 01:37
  14. Actions 00:54
  15. Perspectives 01:20
  16. Key Performance Indicators 01:18
  17. Translations 00:57
  18. SSAS Security 01:32
  19. Cell Permissions 01:09
  20. Dimension Permissions 00:41
  21. Creating and Configuring a Cube Part1 04:39
  22. Creating and Configuring a Cube Part2 05:23
  23. Creating and Configuring a Cube Part3 03:01
  24. Creating and Configuring a Cube Part4 05:40
  25. Exam Scenarios 02:44
  26. Module Review 01:13
  Video Name Time
  1. Tabular Data Models 00:10
  2. Introduction to Tabular Data Models 01:23
  3. PowerPivot 00:47
  4. Working with PowerPivot 01:28
  5. Linked and Non-Linked Tables 00:40
  6. PowerPivot Features 00:41
  7. Server Based Tabular Data Models Part1 00:17
  8. Server Based Tabular Data Models Part2 00:36
  9. Creating a Tabular Data Model 00:37
  10. Tabular Models with SSDT 00:42
  11. Workspace Database 01:06
  12. Tabular Data Model 01:50
  13. Tabular Data Model Security 00:35
  14. Creating a Tabular Data Model Using PowerPivot Part1 03:34
  15. Creating a Tabular Data Model Using PowerPivot Part2 05:18
  16. Creating a Tabular Data Model Using PowerPivot Part3 04:58
  17. Creating a Tabular Data Model Using PowerPivot Part4 02:41
  18. Exam Scenarios 01:46
  19. Module Review 00:54
  Video Name Time
  1. MDX/DAX 00:18
  2. Introduction to Multidimensional Expressions (MDX) 00:56
  3. Why Use MDX? 01:07
  4. MDX Syntax 02:36
  5. Sets 01:21
  6. Where is MDX Used? 01:14
  7. Introduction to Data Analysis eXpressions (DAX) Part1 00:13
  8. Introduction to Data Analysis eXpressions (DAX) Part2 00:38
  9. Working with DAX 02:11
  10. DAX Functions 01:30
  11. DAX Queries 00:41
  12. Calculated Columns 00:44
  13. DAX Measures 00:30
  14. Multiple Relationships 00:29
  15. Exam Scenarios 02:22
  16. Module Review 01:03
  Video Name Time
  1. Introduction 00:14
  2. Introduction to Data Mining 01:03
  3. Data Mining Algorithms 01:48
  4. Data Mining Components 01:42
  5. Validating Mining Models 02:46
  6. Creating a Data Mining Model Part 1 04:31
  7. Creating a Data Mining Model Part 1 02:54
  8. Exam Scenarios 01:26
  9. Module Overview 00:45
  10. Course Overview 01:38

Student Feedback

5 Stars
4 Stars
3 Stars
2 Stars
1 Star
4.5
Rating: 4.5
Overall Rating: Good.

Similar Courses

Only Registered Members can View Training Courses

Please fill out your email address below in order to view Training Courses. Registration is Free and Easy, You Simply need to provide an email address.

  • Trusted by 1.2M IT Certification Candidates Every Month
  • Hundreds Hours of Videos
  • Instant download After Registration

Already Member? Click here to Login

A confirmation link will be sent to this email address to verify your login

1200+ IT Certification Exams available: Get a free sample of any exam right now!
Try Free Demo

Try Free Demo

  • ABA
  • ACAMS
  • ACFE
  • ACI
  • ACSM
  • Adobe
  • AHIMA
  • AHIP
  • AHLEI
  • AICPA
  • AIWMI
  • Alfresco
  • AMA
  • Amazon
  • AndroidATC
  • APBM
  • API
  • APICS
  • Apple
  • Arista
  • Aruba
  • ASIS
  • ASQ
  • Atlassian
  • Autodesk
  • Avaya
  • Axis Communications
  • BACB
  • BCS
  • BICSI
  • Blockchain
  • Blue Coat
  • Blue Prism
  • Brocade
  • C++ Institute
  • CA Technologies
  • Checkpoint
  • CIMA
  • Cisco
  • Citrix
  • CIW
  • Cloudera
  • CompTIA
  • CSA
  • CWNP
  • CyberArc
  • Dell
  • DMI
  • DSCI
  • ECCouncil
  • EMC
  • Esri
  • Exin
  • Extreme Networks
  • F5
  • FileMaker
  • FINRA
  • Fortinet
  • GAQM
  • GARP
  • Genesys
  • GIAC
  • Google
  • Guidance Software
  • H3C
  • HFMA
  • HIPAA
  • Hitachi
  • HP
  • HRCI
  • Huawei
  • IAPP
  • IBM
  • IFPUG
  • IIA
  • IIBA
  • Informatica
  • Isaca
  • iSAQB
  • ISC
  • iSQI
  • ISTQB
  • ITIL
  • Juniper
  • Linux Foundation
  • Logical Operations
  • LPI
  • Magento
  • Marketo
  • McAfee
  • Microsoft
  • Mulesoft
  • NACVA
  • NCMA
  • Network Appliance
  • NI
  • Nokia
  • Novell
  • Nuage Networks
  • OMG
  • Palo Alto Networks
  • Pegasystems
  • PEOPLECERT
  • PMI
  • PRINCE2
  • Python Institute
  • QlikView
  • RedHat
  • Riverbed
  • RSA
  • Salesforce
  • SANS
  • SAP
  • SAS Institute
  • Scrum
  • SDI
  • ServiceNow
  • Six Sigma
  • SNIA
  • SOA
  • Software Certifications
  • SolarWinds
  • Splunk
  • SpringSource
  • Symantec
  • The Open Group
  • Tibco
  • VCE
  • Veeam
  • Veritas
  • Vmedu
  • VMware
  • WatchGuard
  • WorldatWork
  • Zend
Next Step
Next Step

Try Free Demo

  • Microsoft
Next Step
Next Step

Summer Sale! Get 25% Discount on All Your Purchases!

Passguide Products

Enter Your Email Address to Receive Your 25%
OFF
Discount Code Plus... Our Exclusive Weekly Deals

* We value your privacy. We will not rent or sell your email address