SSRS Training Videos with Online Lab

On demand Training Videos accessible your comfortable timings. Our SSRS Video Training Service (Course Code: VC07) offers complete realtime practical knowledge transfer services for aspiring and working SQL BI / Report Developers. Study and Practice Material with Realtime Case Study, Free LIVE Server Access for online Lab are included in this course. Register for SSRS Video Training

Pre-requisites: Participant needs to have knowledge on SQL Server T-SQL Queries & Tuning to join our Real-time Practical MSBI Training Course.

Plans for SSRS Video Training

  PLAN A PLAN B PLAN C
Description SSRS SSRS + Power BI MSBI + Power BI
No.of Videos 10 26 50
Completely Real-time Check-Symbol-for-Yes Check-Symbol-for-Yes Check-Symbol-for-Yes
Resume, Job Support Check-Symbol-for-Yes Check-Symbol-for-Yes Check-Symbol-for-Yes
Real-time Project (ERP) Check-Symbol-for-Yes Check-Symbol-for-Yes Check-Symbol-for-Yes
Power BI Desktop Check-Symbol-for-Yes Check-Symbol-for-Yes Check-Symbol-for-Yes
Power BI Service Croos-symbol-for-No Check-Symbol-for-Yes Check-Symbol-for-Yes
Power BI Report Server Croos-symbol-for-No Croos-symbol-for-No Check-Symbol-for-Yes
Complete MSBI : IS, AS, RS Croos-symbol-for-No Croos-symbol-for-No Check-Symbol-for-Yes
Microsoft BI Certification Croos-symbol-for-No Croos-symbol-for-No Check-Symbol-for-Yes
Total Course Fee INR 6000/-
USD 100
INR 15000/-
USD 250
INR 27000/-
USD 450

SSRS Video Training - How it works?

Real-time, Practical Training Videos, accessible 24x7. Study, Practice Material and Lab Work for every video. Trainer available for doubts clarifications and support. Theory Material to be provided in Advance.

SSRS Training Highlights

  • Completely Real-time and Practical
  • Video wise Lab Work, Tasks, Solutions
  • One Real-time Project + Ticketting Tools
  • Certifications & Interview Guidance
  • Interview FAQs & Resume Guidance
  • 24x7 LIVE Server with Lab, Support

If above schedule does not work for you, Register for SSRS Video Training

For Weekend / FastTrack Trainings Click Here

Trainer : Mr. Sai Phanindra T (12+ Yrs EXP) Profile

 

SSRS Video Training Course Contents:

Basic SSRS Development & Report Authoring

Advanced SSRS Development & Deployments

VIDEO 1: SSRS INSTALLATION, CONFIGURATION

  • Need For Reporting Solutions (SSRS) and Tools
  • Reporting Engine Architecture and Report Databases
  • SSRS Installation, Tools and Database Configuration Process
  • SSRS 2016 : Installation and Report Databases
  • SSRS 2014 : Installation and Report Databases
  • Report Server URL - Purpose, Test Connection, Usage
  • Report Manager URL - Purpose, Test Connection, Usage
  • Report Portal URL in SSRS 2016 - Usage, Web Service
  • Three-Phase Report Life Cycle in Reports (End-End)
  • Report Server Database and Report TempDB Configuration
  • Virtual Directories (VD) in Web Services - Settings, Options
  • Communication Ports and Data Encryption For Web Portal URL
  • Report Design and Work Flow Diagram - Lab Plan, Data Sources
  • Report Design with Report Designer & Report Builder Tools
  • Report Builder Versus Report Designer - Basic Differences
  • SSDT (VS): SQL Server Data Tools Installation, Verification
  • SSDT 2015 and SSDT 2013 Installation, Test Connection
  • SSRS 2016 Report Portals and Accessibility

VIDEO 6: REPORT DESIGN - V

  • Gauge Report Types - Radial and Linear Gauges
  • Adding Data to Gauge Report - Default Indicators
  • Gauge Data Versus Chart Data - Pointer Options
  • Scale Properties: Maximum, Minimum Dynamic Ranges
  • Browser Compatibility and Offline Report Access
  • Gauge, Gauge Panel and Sub Reports
  • Master Reports and Detailed Reports - Sub Reports
  • Pointers - Properties, Scale Limits, Format Options
  • Ranges & Labels, Report Items, Properties, Needle
  • Adding Multiple Gauges - Dashboards, Dynamic Size
  • #VALX, #VALY, #PERCENT, #SERIES Label Properties
  • #LABEL, #AXISLABEL, #TOTAL, #LEGENDTEXT
  • 3D PieCharts, Funnel and Tree Map Reports.
  • 3D Funnel and Sunburst Reports. Shape Charts
  • Doughnut, Pyramic and 3D Pyramid Reports
  • Parameterized Gauge Reports - Dataset Level Filters
  • Indicator Reports : Value and State Expressions
  • SSRS Expressions and Report Code - Custom Functions

VIDEO 2: REPORT DESIGN - I

  • Working with Visual Studio - SQL Server Data Tools
  • Report Templates and Basic Usage. Project, Solution
  • Designing Basic Reports - Understanding Entities
  • Working with Report Project Wizard - Usage, Reports
  • Defining Data Source Connections, Source Databases
  • Query Designer Options, Query Builder & Import Options
  • Table Reports and Matrix Reports with Report Wizard
  • Layout and Format Options - Drilldown Reports, Blocks
  • Stepped Reports and Multi Field Drilldown Options
  • Report Project Template - Designing Dataset, Reports
  • Report Toolbox and ReportData Options, Textbox Usage
  • Table Headers, Formatting Options, MATH Expressions
  • Alternate Row Colors, Using Report Globals, Expressions
  • Report Formatting Styles, Expressions and Reusability
  • Reporting Functions: IIF, Format, Ceiling, Round, Concat
  • Alternate Row Colors and Dynamic Formatting Options
  • Textbox Properties - Date & Time Formats, Numbers, Styles
  • Report Timeout Options and Tool Box Options, Report Data
  • Initial Catalog For Report Sources, Static/Dynamic Properties

VIDEO 7: REPORT DESIGN - VI

  • Report Builder Tool - 2016, 2014, 2008 R2 Installation
  • Installation Verification Options, msi File Configuration
  • DataSource and DataSet Creation with Report Builder
  • Local Report Specific Entities and RDL File Creations
  • Entity Browsing Options and Query Design Options
  • Dataset Design with Parameters and Filters. Usage Options
  • Query Designer Options with Report Builder, Table Selection
  • Column Aggregates and Auto Group BY. Query Edit Options
  • Adhoc Reports with Drill-down & Column Groups
  • Chart Report using Report Builder - Line Reports & Options
  • Dataset Design with Parameters and Filters. Usage Options
  • Line Reports and XValue Options using Report Builder Tool
  • Trend Analysis and Continuous Data Reports - OLTP / DWH
  • Map Reports - Map Layers, Map Report Items and Options
  • Map Gallery, ESRI Share Files and SQL Server Spatial data
  • Defining Geo Spatial Data for Business Analysis Dashboards
  • Working with Polygon, Tile, Line and Point Map Layers
  • Map Visualization Options and Bubble Map Reports Usage
  • Data Fields, Display Labels and Visualization Indicators

VIDEO 3: REPORT DESIGN - II

  • Grouping Operations: Row Groups, Column Groups
  • Table Report - Row Groups, Parent - Child Groups
  • Adding Groups to Existing Rows and New Rows
  • Group Headers and Group Footers - Usage, Sub Totals
  • Group Field Visibility and Toggle Options @ Parent
  • Row Group Properties, Header/Footer Properties
  • Column Groups for Table Reports, Advanced Options
  • Repeat-On-New-Page Options and Report Properties
  • Column Groups for Matrix Reports, Data Grouping
  • Drill-down Reports using Row Groups and Visibility
  • Drill-down Reports using Column Groups, Visibility
  • Table Reports Vs Matrix Reports - Technical Differences
  • Adding Images to Reports. Tooltip and Size Options
  • Report Headers and Report Footers - Globals, Expressions
  • Merging Report Fields, Sub Totals and Grand Totals
  • Group Edits, Removing Group Totals, Adding Group Headers
  • Column Groups - Advance Mode - Fixed Attributes, Fields
  • Repeating Header on Every Page & RepeatPage Options
  • Working with Report Globals for Metadata, Report Properties

VIDEO 8: REPORT DEPLOYMENT & SUBSCRIPTIONS

  • Report Deployment Options - Report Builds, Config Files
  • Data Source, Data Set Folders, Report Server URL Targets
  • Report Deployment - UI & Command Line. RSKey Config
  • Report Server URL and Report Manager (Web Portal) URL
  • Report Home, Site Settings and Report Settings
  • Data Sources: Properties, Security Options, Access Options
  • DataSets: Properties, Security Options, Dependent Items
  • Reports: Properties, Security Options, Edits, Downloads
  • Security Roles: Content Manager, Browser, Report Builder
  • MyReports Role, Report Publisher Role. Report User/Groups
  • Report Linking and Default/Hidden Parameter Options
  • Report Tuning: Caching Options, Cache Refresh - Cautions
  • Report Tuning: Snapshot Options and Snapshot Schedules
  • Report Tuning: Off-the-Shelf Reports and Linked Reports
  • Local and Global Schedules, History Management, Jobs
  • Report Builder Connections and Reusability Options
  • Report Parts and RS Storage Options. Paginated Reports
  • Report Delivery & Email / File Share Subscriptions
  • Accessing and Controlling Reports, Email Subscriptions

VIDEO 4: REPORT DESIGN - III

  • Report Parameters - Purpose, Benefits and Usage
  • Creating Parameters using Dataset Query Conditions
  • Creating Parameters using Report Properties, Report Data
  • Single Value Parameters and Multi Value Parameters
  • Dynamic Parameter Values, Dependency Options, Queries
  • Defining Datasets with Parameters, Dynamic Conditions
  • Dataset Links to Parameters, Value Options from List, Query
  • Multi-Value Parameter Options: Data Types, Null, Empty Values
  • Reports using Multiple Data Sets. Performance Issues
  • Advanced Options : Auto Refresh, Manual Refresh Options
  • Dataset Filters, Toolbox Filters - Purpose and Usage
  • Filters versus Parameters - Differences with Performance
  • Using Filter Condition at Dataset Level, Toolbox Level
  • Data Type Conversions with Filters, Expressions & Computations
  • Deciding Parameters and Filters - When to use which, why?
  • SSRS Expressions and Global Fields For Report Parameters
  • JOIN, FIELDS, LABEL and Formatting Options with Parameters
  • Linking Report Parameters to Dataset Parameters and Filters

VIDEO 9: CUBE REPORTS, POWER BI INTEGRATION

  • Scale-Out Deployments and Remote Report Databases
  • Remote Report Database Connections, Recovery Options
  • Scale-Out Joins and Waits. Report Configuration Keys
  • Multi-Report Server Configurations, Execution Accounts
  • Report Designer Versus Report Builder - Advantages
  • Cube Reports with SSRS - MDX Queries. Advantages
  • Cube Reports with MDX Parameters & Filters. Performance
  • Cube Reports with MDX Expressions, YTD, QTD Calculations
  • Reports with SSAS KPIs and Cube Aggregations - MOLAP
  • Cube Reports with Tabular Data Sources. Hierarchy Levels
  • Sub Reports, Dashboards, Action Reports with Report Builder
  • Drill-Up and Drill-Down Reports, Drill Through Reports
  • Report Actions @ SSAS 2016 OLAP Databases. Limitations
  • Power BI Reports with SSRS - Desktop / Mobile Editions
  • Power BI PBX Reports with RDL Sources, Vice Versa
  • Power BI Reports with SSRS and SSAS Connections, Options
  • Power View and Power Pivot Extensions, Usage Examples
  • New SSRS Tuning Features in 2016, Report Migrations

VIDEO 5: REPORT DESIGN - IV

  • Chart Reports - Design Options, Properties and Usage
  • Series Values Selection - with / without Category Groups
  • Report Categories with Series Groups - Differences, Usage
  • Data Visualization Types: Trend & Discrete Chart Reports
  • Clustered / NonClustered Legend Attributes. Position Options
  • Series Labels : Properties, Number Formatting Options, Visibility
  • Series Actions : Series Properties, Multi - Valued Parameters
  • Report Actions : URL / Reports, Setting for Report Filters
  • Axis Values - Possible Issues with Multiple Axis Items, Solutions
  • Dashboard Creations, Usage. Multiple Chart Areas, Legends
  • Dashboard Exports with Filters (Static, Parameterized)
  • Chart Series, Report Markers Chart Areas & Limitations
  • 3-Dimensional Report Options - Properties, Visibility Options
  • Range & Pie Charts, Line Reports, Data Bars, Area Charts
  • Report Actions with Parameter Values - Report Filter Joins
  • Exploring Toolbox Filters with Type Conversions & Expressions
  • Using Shared DataSources and Shared DataSets - Advantages
  • Data Bar Reports and Sparkline Reports - Stacked Reports - Usage
  • Multiseries Charts, Dynamic Chart Size, Axis Display Control
VIDEO 10: Real-time Project @ ERP 

End-to-End Reporting Solutions, Dashboards, 
KPIs, Mobile Reports, Builds, Deployments, 
Subscriptions, Tuning, Jobs, Audit Logs & more..! 

Versions: SSRS 2014 and SSRS 2016
Environment: SSDT 2013, SSDT 2017
Database Size: 250 GB
No. Of Tables: 40
Platform: ERP
 

Power BI Training Course Contents:

Module I: Power BI Basics, Visuals

Module II: ETL and Data Modelling

Module III: Power BI Service (Cloud)

Chapter 1 : Introduction to Power BI

  • Need for Big Data and BI Technologies
  • Purpose of BI & Power BI Suite of Tools
  • Power BI as a Self-Service BI, Scope
  • Comparing Power BI with Microsoft MSBI
  • Comparing Power BI @ Tableu, QlickView
  • Power BI as an End-to-End BI Tool
  • Microsoft Data Platform Technologies
  • Colloboration, Visualization and IOT
  • Power BI with Reporting Services (SSRS)
  • Power BI For Data Scientists, AI Scope
  • Power BI For Business Analysts
  • Power BI Job Roles and Responsibilities
  • Power BI Component :Overview, Lab Plan
  • MCSA Examination for Power BI: 70-778

Chapter 7 : Power Query & M Language - 1

  • Power Query [M Language] - Purpose
  • Power Query Usage & Operation Types
  • Power Query Architecture and Usage
  • QUERY Concept, Properties, Validations
  • Power Query for Data Mashup Operations
  • Basic Data Types, Literals and Values
  • Expressions and Primitives in M Language
  • LIST : Syntax, Examples and Usage
  • RECORD : Syntax, Examples and Usage
  • TABLE : Syntax, Examples and Usage
  • Power Query Connection Formats, Settings
  • let, source & in statements in M Lang
  • Power BI Canvas: Edits, Applied Steps
  • Queries and Applied Steps, Edit Queries

Chapter 13 : Power BI Service (Cloud) - 1

  • Power BI Cloud Account and WorkFlow
  • Power BI Workspace : Options and Use
  • App Workspace Creation in Real-time
  • Publish Reports from Power BI Desktop
  • Reports and Datasets in Power BI Cloud
  • Pinning Report Pages and Visuals
  • Dashboard Creation and End User Access
  • Creating Tiles in Dashboards. Web, Mobile
  • Creating Mobile Reports with Tiles
  • Adding Images, Web Content and Videos
  • Q & A (Cortana) for Visuals. QR Codes
  • Enabling Interactive Visuals. Embed Codes
  • Report Shares and Dashboard Shares
  • App Publish Options andApp Updates

Chapter 2: Power BI Architecture

  • Power BI Architecture - in Detail, Tools
  • Power BI - Integrations in Real-time
  • Need for Power BI Service and Cloud
  • Need for Power BI Report Server, SSDT
  • Power BI Report Server & Report Builder
  • Power BI Mobile Report Publisher Tool
  • Types of Reports in Power BI - Interactive
  • Analytical, Paginated & Mobile Reports
  • Office Online Server & SharePoint Server
  • Content Packs, Cortana - Q&A Features
  • API Integration: LIVE Streaming DataSets
  • Configure Power BI Cloud, Basic Usage
  • Installing Power BI Desktop, Gateways
  • Installing Excel Publisher & Analyzer

Chapter 8 : Power Query & M Language - 2

  • Data Sources with Excel, File Formats
  • Data Sources with Database Connections
  • BLANK Data Sources Creation & Scope
  • Creating LIST, RECORD, TABLE Queries
  • Functions in Power Query and Usage
  • Defining Functions and Invoke Options
  • Mashup Operations in Power Query Editor
  • Row Filters, Column Filters, Renames
  • Promoting Headers and Query Settings
  • MERGE Queries For Combining Queries
  • Inner Join and Left/Right Outer Joins
  • Left Anti Join, Right Anti Join, Full Join
  • UNION All, Group By and Aggregations
  • Close and Apply Options. Data Imports

Chapter 14 : Power BI Service (Cloud) - 2

  • Power BI Report Edits in Cloud, Visuals
  • Download PBIX Reports from Cloud
  • Sharepoint Integration, PPTX and Excel
  • Dashboard Properties and Operations
  • Report properties and Operations
  • Dataset properties and Operations
  • Report Insights, Related Items and Metrics
  • Quick Insights and Shared URLs
  • Publishing App Workspace
  • Adding Tiles to Dashboards
  • Configuring Alerts in Power BI
  • Managing and Receiving Alerts
  • Subscriptions in Power BI Cloud
  • Settings and Power BI Admin Console

Chapter 3 : Using Power BI Desktop

  • Install and Configure Power BI Desktop
  • Understanding Power BI Desktop Tool
  • In-Memory, SMDL and Vertipaq Options
  • Visuals, Fields, Pages and Filters
  • Report, Data and Relationship Options
  • Concept & Use of PBIX and PBIT Files
  • Designing Simple / Basics Reports in PBI
  • Get Data from DAT Files, Basic Reports
  • Enter Data from Excel Files, Basic Reports
  • Creating PBIX Files and Re-Use
  • Creating PBIT Files & Data Import Options
  • Database Connections with Power BI
  • Import and DirectQuery - Data Loads
  • Table Reports, Matrix and Chart Reports
  • Interactive Visuals and Focus Mode

Chapter 9 : Power Query & M Language - 3

  • Creating Parameters in Power Query
  • Intrinsic & Query Parameters, Usage
  • Parameter Data Types, Default Value Lists
  • Static Lists, Dynamic Lists For Parameters
  • Reports with Range Values - Usage
  • Parameters with PBIT Reports, Prompts
  • New Queries from Dataset Fields, Usage
  • Removing Duplicate Rows and Columns
  • Column Delimters and Field Formatting
  • Change Type and Transform Operations
  • Replace Values & Errors, Transpose
  • Group By Aggregations, Fill, Reverse Rows
  • Format Options in M Language
  • Pivot and Unpivot Options in Power Query
  • Data Type Conversions & Format Options

Chapter 15 : Power BI Service (Cloud) - 3

  • Content Packs : Creation and Use
  • Organizational and Service Level
  • Content Packs from Azure MarketPlace
  • Worksheets and Dashboards with Excel
  • Gateways - Installation, Configuration
  • Personal and Enterprise Gateways
  • NT SERVICE\PBIEgwSERVICE Account
  • Dataset Refresh Options and Schedules
  • Managing Gateways - Gateway Clusters
  • Azure Databus Integration, ODG Logs
  • Dataset Security and Management Options
  • Power BI Reports with Azure Data Sources
  • Power BI Reports with Microsoft OneDrive
  • Power BI Reports with Google Analytics
  • SaaS Components, OneDrive with PowerBI

Chapter 4 : Hierarchies and Filters

  • Creating Hierarchies with Report Fields
  • Data / Drill Options - Auto & Manual
  • Data Explore Options : Spotlight, Focus
  • Expand, Goto Next Level and Drill-up
  • See Data, Export Data, See Records
  • Include and Exclude Options, Multi-Field
  • Filters and Real-time Usage with Power BI
  • Using Report Filters and Page Filters
  • Using Drill-down Filters and Visual Filters
  • Apply and Clear Options with Value Filters
  • Adding Text Box, Images, Buttons Shapes
  • Big Data Access with Power BI

Chapter 10 : Power Query & M Language - 4

  • Data Modeling Options with Power Query
  • Modeling Operations - Custom Columns
  • Query Transforms, Sort Direction, Statistics
  • Enabling / Disabling Loads. ToList Options
  • Creating Parameters & Variables. Functions
  • Date and Time Columns. String Functions
  • Advanced Edit Options, Custom Queries
  • Custom Functions in Power Query M Lang
  • Grouping and Sub Groups with Queries
  • Binning with Groups and Query Formats
  • SubString Functions, Splits (Row, Column)
  • Parsing XML and JSON Files. Formatting

Chapter 16 : Excel with Power BI

  • Using Excel with Power BI Reports
  • Using Excel Analyser in Power BI
  • Using Excel Publisher in Cloud
  • Creating Datasets with Excel
  • Excel Uploads and Imports
  • Cell Selection and PINS in Power BI
  • Excel Online - Edits and Pins
  • Excel ODC Connections and Real-time Use
  • Excel Power Pivot and Power BI
  • Excel Drilldowns and Drillthru
  • Create Performance KPIs in Excel
  • Excel for Big Data Analysis, Reporting

Chapter 5 : Power BI Visual Properties - 1

  • Fields, Formats and Analytics Options
  • Table Visuals & Properties, Filters
  • Data Bar and Data Scaling Options
  • Divergent Property, Data Labels
  • Matrix : Sub Totals, Grand Totals
  • Drilldown Options : Row and Column
  • Stacked Bar Chart, Clustered Colum Chart
  • Stacked and Clustered Colum Chart
  • 100% Stacked Bar and Column Charts
  • Area & Stacked Area Chart. Ribbon Chart
  • Waterfall Chart, Scatter Chart, Pie Chart
  • Line, Doughnut TreeMap, Funnel, Gauge
  • DETAILED Properties of Every Visual
  • General, Labels, Values, Legend Options
  • Axis, Title, Markers, Filter Options

Chapter 11 : DAX Functions, Expressions - 1

  • DAX : Importance and Real-time Usage
  • DAX Data Types and DAX Calculations
  • Syntax, Functions, Context Options
  • ROW Context and Filter Context in DAX
  • DAX Functions. Aggregates and Usage
  • Creating and Using Measures with DAX
  • Creating and Using Columns with DAX
  • Vertipaq Engine & Special Characters
  • Operators in DAX - Real-time Usage
  • Quick Measures in DAX - Auto validations
  • PowerPivot xVelocity & Vertipaq Store
  • In-Memory Processing : DAX Performance
  • Date and Time & Text Functions
  • Time Intelligence Functions in DAX
  • Logical & Mathematical Functions

Chapter 17 : REST APIs & Power BI Admin

  • REST APIs with Power BI Cloud
  • Steaming Datasets Creation in Power BI
  • API : Usage. SubKeys and Channels
  • Push and Pubnub Datasets in Power BI
  • Azure Stream for Real-time Data Reports
  • Using Streaming Sets in Tiles
  • Real-time Data Tracking Visuals (Interactive)
  • Power BI Report Server & Integration
  • Tenant IDs, Subscriptions. Paginated Reports
  • Power BI Mobile Publisher
  • Power BI Vs Tableau, SSRS, Sharepoint
  • Licensing & Pricing Plans in Power BI
  • MSBI SSAS and SSRS with Power BI
  • Power BI Cloud with Power Point
  • Custom Visuals in Power BI

Chapter 6 : Power BI Visual Properties - 2

  • Map Reports and Filled Map Reports
  • ArcGIS Maps and Real-time Usage. Options
  • Longitudes and Latitudes. Bing Maps
  • Color Analytical Maps, Styles, Options
  • KPI Reports - Target, Value and Trend
  • Plot Area & Responsiveness Properties
  • Sentiment Colors, Color Saturations
  • Breakdowns, Title, Axis Properties
  • Category & Data Lables, Constant Lines
  • Working with SLICER Visual : Value Filters
  • Horizontal and Vertical Slicer Filters
  • Single Select and MultiSelect Options
  • Frown (Errors), Details. Lock Aspects
  • Custom Visuals and PBIVIZ File
  • PBI : Options and Settings, VM Settings

Chapter 12 : DAX Functions, Expressions - 2

  • Data Modeling with DAX. Creating Roles
  • Currency Conversions, Field Formatting
  • SUM and SUMX Functions: Differences
  • CALCULATE(), CALCULATEX() Functions
  • CALCULATETABLE Functions. VAR, VARP
  • DATESMTD, DATESQTD, DATESYTD
  • ENDOF(), FirstDay(), LastDay()
  • SAMEPERIODLASTYEAR, STARTOF()
  • Other DAX Functions and Examples
  • DAX Expressions with Quick Measure
  • DAX Usage for Row Level Security
  • Creating Roles with Power BI Desktop
  • DAX Filters and Multi Value Conditions
  • Manage Roles and Membership Options
  • VIEW AS ROLE. Information Functions

Real-time Project 1 :

For Power BI Registrations: Real-time Project Implementation @ Climate Control Datasets and REST API

Real-time Project 2 :

For Power BI with SQL Server T-SQL Registrations: Real-time Project Implementation @ ERP Database

 
Our SSRS Trainings are completely practical, realtime. Register today for free Demo

Benefits of our SSRS Training Course :

  • Completely Practical and Realtime
  • Theory Material provided in Advance
  • Highly Interactive and Interesting
  • Daily Tasks and Weekly Assignments
  • Certification Guidance and FAQs
  • 24x7 Server Access with Realtime DBs

After the SSRS Video Training course participants should be able to:

  • Design and Understand Datawarehouses (DWH)
  • Decide to use SCD, CDC and Checksum Techniques
  • Design MDX Queries and Expressions for Cube Reports
  • Tune OLAP Cube Structures with UBO and Partitions
  • Perform Aggregation Design and KPIs with DAX Expressions
  • Deploy and Implement SSAS OLAP Databases with Data Mining

Please find the Guidelines for Video Based Training (VBT) - Online

1. How does Video Training Works

> Videos are accessible 24x7. You can opt to access any number of videos each day or same video for multiple days.

> Video Course to be completed within 3 months from the date of registration.

> To ensure secured delivery of our services the participant shall connect to our video cloud in a secured environment.

2. Access the videos

> Each video is for duration of 80 - 90 minutes, can be paused/replayed for writing running notes and understanding.

> Each video can be accessible any number of times.

> A Technical Test / Mock Interview is conducted and a Course completion certificate to be issued upon completion of the course.

3. Study Material, Practice and Doubts/clarifications

> Study Material and Practice examples used in every video to be provided on email.

> Software Installation Assistance and access to our 24x7 LIVE Server to be provided for duration of the course.

> Trainers are available for doubts clarifications. On Skype, Email as well as on Call.

Register today for SSAS Video Training
 
Who can benefit from this SSRS Video Training course?

This course is helpful for aspiring MSBI Developers, BI Architects, SQL Developers, Database Testers, BI Analysts, DB Architects and .NET Professionals. All training videos are completely practical and realtime. Session Material and LIVE Server with Lab included in the course.