- Reporting Services (SSRS) Part 1 - Getting Started with a New Project
- Reporting Services (SSRS) Part 2 - Data Sources and Datasets
- Reporting Services (SSRS) Part 3 - Working with Tables
- Reporting Services (SSRS) Part 4 - Keeping Header Rows Visible
- Reporting Services (SSRS) Part 5 - Controlling the number of rows per page
- Reporting Services (SSRS) Part 6 - Grouping in Tables
- Reporting Services (SSRS) Part 7 - Calculated Fields
- Reporting Services (SSRS) Part 8 - Conditional Formatting in Tables
- Reporting Services (SSRS) Part 9 - Indicators
- Reporting Services (SSRS) Part 10 - Gauges
- Reporting Services (SSRS) Part 11 - Basic Parameters
- Reporting Services (SSRS) Part 12 - Drop Down List Parameters
- Reporting Services (SSRS) Part 13 - Null Values in Parameters
- Reporting Services (SSRS) Part 14 - Cascading Parameters
- Reporting Services (SSRS) Part 15 - Matrix
- Reporting Services (SSRS) Part 16 - Lists
- Reporting Services (SSRS) Part 17 - Linked Reports
- Reporting Services (SSRS) Part 18 - Charts
- Reporting Services (SSRS) Part 19 - Subreports
- Reporting Services (SSRS) Part 20 - Basic Maps
- Reporting Services (SSRS) Part 21 - Pivot Table (Dynamic Matrix)
- Reporting Services (SSRS) Part 22 - Document Maps
- Reporting Services (SSRS) Part 23 - Report Variables and Group Variables
- Reporting Services (SSRS) Part 24 - Report Templates
- Reporting Services (SSRS) Part 25 - Adding Code to Reports
- Reporting Services (SSRS) Part 26 - Creating a Custom Assembly
Microsoft Business Intelligence
Learn Microsoft Business Intelligence by video tutorials.
Wednesday, 14 January 2015
Video tutorials to learn SSRS - SQL Server Reporting Service
Video tutorials to learn MDX - Multidimensional Expressions
- Basics 1 MDX for SQL Developers
- Basics 2 MDX Terminology Part 1
- Basics 2 MDX Terminology Part 2
- Basics 3 MDX Filters Part 1
- Basics 3 MDX Filters Part 2
- Basics 4 MDX JOINS Part 2
- Basics 5 MDX Rules Part 1
- Basics 5 MDX Rules Part 2
- Basics 6 MDX Misc Functions
- Basics 7 MDX Time Functions
- MDX Query Tutorial Displaying the Top Count
- MDX tutorial, introduction to Multidimensional Expressions
- MDX Sorting and Filtering
- MDX Query Tutorial how to Calculate % of Parent
- MDX Filters Essential Tutorial
Video tutorials to learn Power BI with Excel - Self service business intelligence in Excel
PowerPivot
- Excel PowerPivot Basics #01: Introduction To PowerPivot for Excel 2013
- Excel PowerPivot Basics #02: Import Large Non-Normalized Data Set To Reduce File Size
- Excel PowerPivot Basics #03: Replace VLOOKUP with Excel 2013 Data Model & Relationships
- Excel PowerPivot Basics #04: DAX Formulas Can Be Easier & Faster Than Array Formulas
- Excel PowerPivot Basics #05: Import External Excel Tables, Build Data Model with SUMX function
- Excel PowerPivot Basics #06: Import, Filter, Edit From Multiple Data Sources: Access, Excel, Text
- Excel PowerPivot Basics #07: Calendar Table Calculated Columns: Month Year Quarter Fiscal Quarter
- Excel PowerPivot Basics #08: Edit Existing Connections, Import New Data, Existing Reports Update
- Excel PowerPivot Basics #09: Calculated Fields & DAX Functions 9 Examples
- Excel PowerPivot Basics #10: CALCULATE function to Change Filter Context (14 Examples)
- Excel PowerPivot Basics #11: Group By Date: Excel PivotTable vs. PowerPivot PivotTable
- Excel PowerPivot Basics #12: Show Report Filter Pages Not Available In PowerPivot Pivot Table
- Excel PowerPivot Basics #13: Replace 3 Way Lookup Array Formulas for 1.2 Million Rows of Data
Power Query
- Excel Power Query #01: Merge 3 Tables Into One in PowerPivot or Excel Table
- Excel Power Query #02: Transform Data and Import Into PowerPivot or Excel Table
- Excel Power Query #03: Import Multiple Text Files in 1 Step, and Amazing Pivot Chart For Grade Data
- Excel Power Query #04: Import Multiple CSV Files In 1 Step & Retrieve New Files Automatically
- Excel Power Query #05: Create Dimension Table From Fact Table for PowerPivot During CSV File Import
- Excel Power Query #06: Import Multiple Excel Files From Folder Into One Excel Table or Data Model
- Excel Power Query #07: Extract Unique List For Data Validation List with Power Query
- Excel Power Query #08: Import Multiple Excel Sheets From Multiple Excel Workbooks
- Excel Power Query #09: Merge Multiple Worksheets in Workbook To New Table using Append Feature
- Excel Power Query #10: UnPivot Feature to Create Proper Data Sets (2 Examples)
- Excel Power Query #11: Each Row Has 3 Records, Unwind Table into Proper Data Set
- Excel Power Query #12: Find & Replace, Group By 3 Columns, Load With Existing Connections
Power View
Video tutorials to learn SSIS - SQL server Integration Service
- SQL Server Integration Services (SSIS) Part 1 - Getting Started
- SQL Server Integration Services (SSIS) Part 2 - Performing Basic Tasks
- SQL Server Integration Services (SSIS) Part 3 - Basic Transformations
- SQL Server Integration Services (SSIS) Part 4 - Variables
- SQL Server Integration Services (SSIS) Part 5 - Data Types and Data Conversion
- SQL Server Integration Services (SSIS) Part 6 - Expressions
- SQL Server Integration Services (SSIS) Part 7 - Conditional split and derived column transforms
- SQL Server Integration Services (SSIS) Part 8 - Debugging
- SQL Server Integration Services (SSIS) Part 9 - Lookup Transforms
- SQL Server Integration Services (SSIS) Part 10 - Sequence Containers and FOR Loops
- SQL Server Integration Services (SSIS) Part 11 - Looping Over Files
- SQL Server Integration Services (SSIS) Part 12 - Other Foreach Loops
- SQL Server Integration Services (SSIS) Part 13 - Script Tasks using C#
- SQL Server Integration Services (SSIS) Part 14 - Script Tasks using Visual Basic
- SQL Server Integration Services (SSIS) Part 15 - Script Components
- SQL Server Integration Services (SSIS) Part 16 - Expression and Other Constraints
- SQL Server Integration Services (SSIS) Part 17 - Event-handling and logging
- SQL Server Integration Services (SSIS) Part 18 - Error handling
- SQL Server Integration Services (SSIS) Part 19 - Parameters and deployment
Video tutorials to learn T-SQL Programming
- What is Transact-SQL and How Does It Fit? (2008/R2)
- Basics of Transact-SQL: Batches, Scripts, GO, and Statements
- How to Declare and Initialize Variables in T-SQL (Part 2)
- SQL Server Data Types: An Overview
- Overview of SQL Server Data Types: Numbers
- Overview of SQL Server Data Types: Date and Time
- Overview of SQL Server Data Types: Time Zone Aware Dates
- SQL Server Constraints: Server or Client-Side Constraints?
- Foreign Keys in SQL Server: What They Are and How to Use Them
- Implementing EAV Models in SQL Server (Entity-Attribute-Value)
- The Four Steps SQL Server Goes Through to Run Your Query
- The Basics of Execution Plans and SHOWPLAN in SQL Server
- Creating Scalar UDFs: Syntax and Basics
- Multistatement UDFs in SQL Server 2008/R2: The Syntax and Basics
- How to Encrypt Your Source Code in SQL Server
- Introduction to Indexes in SQL Server
- The Basics of INSERT in T-SQL
- Three Syntaxes for INSERT in T-SQL
- The OUTPUT Clause in T-SQL
- Nested Transactions in T-SQL
- T-SQL Triggers: Why Are They So Popular?
- SQL Server Stored Procedures: Returning Data to the Client
- SQL Server Output Parameters: Understanding the Syntax
- SQL Server Performance Tuning Tools
Subscribe to:
Posts (Atom)