Wednesday, 14 January 2015

Video tutorials to learn SSRS - SQL Server Reporting Service


  1. Reporting Services (SSRS) Part 1 - Getting Started with a New Project
  2. Reporting Services (SSRS) Part 2 - Data Sources and Datasets
  3. Reporting Services (SSRS) Part 3 - Working with Tables
  4. Reporting Services (SSRS) Part 4 - Keeping Header Rows Visible
  5. Reporting Services (SSRS) Part 5 - Controlling the number of rows per page
  6. Reporting Services (SSRS) Part 6 - Grouping in Tables
  7. Reporting Services (SSRS) Part 7 - Calculated Fields
  8. Reporting Services (SSRS) Part 8 - Conditional Formatting in Tables
  9. Reporting Services (SSRS) Part 9 - Indicators
  10. Reporting Services (SSRS) Part 10 - Gauges
  11. Reporting Services (SSRS) Part 11 - Basic Parameters
  12. Reporting Services (SSRS) Part 12 - Drop Down List Parameters
  13. Reporting Services (SSRS) Part 13 - Null Values in Parameters
  14. Reporting Services (SSRS) Part 14 - Cascading Parameters
  15. Reporting Services (SSRS) Part 15 - Matrix
  16. Reporting Services (SSRS) Part 16 - Lists
  17. Reporting Services (SSRS) Part 17 - Linked Reports
  18. Reporting Services (SSRS) Part 18 - Charts
  19. Reporting Services (SSRS) Part 19 - Subreports
  20. Reporting Services (SSRS) Part 20 - Basic Maps
  21. Reporting Services (SSRS) Part 21 - Pivot Table (Dynamic Matrix)
  22. Reporting Services (SSRS) Part 22 - Document Maps
  23. Reporting Services (SSRS) Part 23 - Report Variables and Group Variables
  24. Reporting Services (SSRS) Part 24 - Report Templates
  25. Reporting Services (SSRS) Part 25 - Adding Code to Reports
  26. Reporting Services (SSRS) Part 26 - Creating a Custom Assembly

Video tutorials to learn MDX - Multidimensional Expressions

  1. Basics 1 MDX for SQL Developers
  2. Basics 2 MDX Terminology Part 1
  3. Basics 2 MDX Terminology Part 2
  4. Basics 3 MDX Filters Part 1
  5. Basics 3 MDX Filters Part 2
  6. Basics 4 MDX JOINS Part 2
  7. Basics 5 MDX Rules Part 1
  8. Basics 5 MDX Rules Part 2
  9. Basics 6 MDX Misc Functions
  10. Basics 7 MDX Time Functions
  11. MDX Query Tutorial Displaying the Top Count
  12. MDX tutorial, introduction to Multidimensional Expressions
  13. MDX Sorting and Filtering
  14. MDX Query Tutorial how to Calculate % of Parent
  15. MDX Filters Essential Tutorial

Video tutorials to learn Power BI with Excel - Self service business intelligence in Excel


PowerPivot
  1. Excel PowerPivot Basics #01: Introduction To PowerPivot for Excel 2013
  2. Excel PowerPivot Basics #02: Import Large Non-Normalized Data Set To Reduce File Size
  3. Excel PowerPivot Basics #03: Replace VLOOKUP with Excel 2013 Data Model & Relationships
  4. Excel PowerPivot Basics #04: DAX Formulas Can Be Easier & Faster Than Array Formulas
  5. Excel PowerPivot Basics #05: Import External Excel Tables, Build Data Model with SUMX function
  6. Excel PowerPivot Basics #06: Import, Filter, Edit From Multiple Data Sources: Access, Excel, Text
  7. Excel PowerPivot Basics #07: Calendar Table Calculated Columns: Month Year Quarter Fiscal Quarter
  8. Excel PowerPivot Basics #08: Edit Existing Connections, Import New Data, Existing Reports Update
  9. Excel PowerPivot Basics #09: Calculated Fields & DAX Functions 9 Examples
  10. Excel PowerPivot Basics #10: CALCULATE function to Change Filter Context (14 Examples)
  11. Excel PowerPivot Basics #11: Group By Date: Excel PivotTable vs. PowerPivot PivotTable
  12. Excel PowerPivot Basics #12: Show Report Filter Pages Not Available In PowerPivot Pivot Table
  13. Excel PowerPivot Basics #13: Replace 3 Way Lookup Array Formulas for 1.2 Million Rows of Data

Power Query
  1. Excel Power Query #01: Merge 3 Tables Into One in PowerPivot or Excel Table
  2. Excel Power Query #02: Transform Data and Import Into PowerPivot or Excel Table
  3. Excel Power Query #03: Import Multiple Text Files in 1 Step, and Amazing Pivot Chart For Grade Data
  4. Excel Power Query #04: Import Multiple CSV Files In 1 Step & Retrieve New Files Automatically
  5. Excel Power Query #05: Create Dimension Table From Fact Table for PowerPivot During CSV File Import
  6. Excel Power Query #06: Import Multiple Excel Files From Folder Into One Excel Table or Data Model
  7. Excel Power Query #07: Extract Unique List For Data Validation List with Power Query
  8. Excel Power Query #08: Import Multiple Excel Sheets From Multiple Excel Workbooks
  9. Excel Power Query #09: Merge Multiple Worksheets in Workbook To New Table using Append Feature
  10. Excel Power Query #10: UnPivot Feature to Create Proper Data Sets (2 Examples)
  11. Excel Power Query #11: Each Row Has 3 Records, Unwind Table into Proper Data Set
  12. Excel Power Query #12: Find & Replace, Group By 3 Columns, Load With Existing Connections

Power View
  1. Interactive Data Visualization with Power View
  2. Introduction to Power Map

Video Tutorials to learn SSAS - SQL Server Analysis Service

Video Set 1
  1. SSAS Class Day 1 Part 1 - Pragmatic Works
  2. SSAS Class Day 1 Part 2 - Pragmatic Works
  3. SSAS Class Day 2 - Pragmatic Works
  4. SSAS Class Day 3 - Pragmatic Works
  5. SSAS Class Day 4 - Pragmatic Works

Video tutorials to learn SSIS - SQL server Integration Service


  1. SQL Server Integration Services (SSIS) Part 1 - Getting Started
  2. SQL Server Integration Services (SSIS) Part 2 - Performing Basic Tasks
  3. SQL Server Integration Services (SSIS) Part 3 - Basic Transformations
  4. SQL Server Integration Services (SSIS) Part 4 - Variables
  5. SQL Server Integration Services (SSIS) Part 5 - Data Types and Data Conversion
  6. SQL Server Integration Services (SSIS) Part 6 - Expressions
  7. SQL Server Integration Services (SSIS) Part 7 - Conditional split and derived column transforms
  8. SQL Server Integration Services (SSIS) Part 8 - Debugging
  9. SQL Server Integration Services (SSIS) Part 9 - Lookup Transforms
  10. SQL Server Integration Services (SSIS) Part 10 - Sequence Containers and FOR Loops
  11. SQL Server Integration Services (SSIS) Part 11 - Looping Over Files
  12. SQL Server Integration Services (SSIS) Part 12 - Other Foreach Loops
  13. SQL Server Integration Services (SSIS) Part 13 - Script Tasks using C#
  14. SQL Server Integration Services (SSIS) Part 14 - Script Tasks using Visual Basic
  15. SQL Server Integration Services (SSIS) Part 15 - Script Components
  16. SQL Server Integration Services (SSIS) Part 16 - Expression and Other Constraints
  17. SQL Server Integration Services (SSIS) Part 17 - Event-handling and logging
  18. SQL Server Integration Services (SSIS) Part 18 - Error handling
  19. SQL Server Integration Services (SSIS) Part 19 - Parameters and deployment

Video tutorials to learn T-SQL Programming


  1. What is Transact-SQL and How Does It Fit? (2008/R2)
  2. Basics of Transact-SQL: Batches, Scripts, GO, and Statements
  3. How to Declare and Initialize Variables in T-SQL (Part 2)
  4. SQL Server Data Types: An Overview
  5. Overview of SQL Server Data Types: Numbers
  6. Overview of SQL Server Data Types: Date and Time
  7. Overview of SQL Server Data Types: Time Zone Aware Dates
  8. SQL Server Constraints: Server or Client-Side Constraints?
  9. Foreign Keys in SQL Server: What They Are and How to Use Them
  10. Implementing EAV Models in SQL Server (Entity-Attribute-Value)
  11. The Four Steps SQL Server Goes Through to Run Your Query
  12. The Basics of Execution Plans and SHOWPLAN in SQL Server
  13. Creating Scalar UDFs: Syntax and Basics
  14. Multistatement UDFs in SQL Server 2008/R2: The Syntax and Basics
  15. How to Encrypt Your Source Code in SQL Server
  16. Introduction to Indexes in SQL Server
  17. The Basics of INSERT in T-SQL
  18. Three Syntaxes for INSERT in T-SQL
  19. The OUTPUT Clause in T-SQL
  20. Nested Transactions in T-SQL
  21. T-SQL Triggers: Why Are They So Popular?
  22. SQL Server Stored Procedures: Returning Data to the Client
  23. SQL Server Output Parameters: Understanding the Syntax
  24. SQL Server Performance Tuning Tools