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
Description	SSRS	SSRS + Power BI
No.of Videos	10	28
Completely Real-time
Resume, Job Support
Real-time Project (ERP)
Power BI Desktop
Power BI Service
Power BI Report Server
Complete MSBI : IS, AS, RS
Microsoft BI Certification
Total Course Fee	INR 6000/- USD 100	INR 15000/- USD 250

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:

Brouchure Download

Register Today

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

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:

Brochure:

Register Today

Module I: Power BI Basics, Visuals	Module II: ETL and Data Modelling	Module III: Power BI Service (Cloud)
Video 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	Video 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	Video 13 : Power BI Service (Cloud) - 1 Power BI Cloud & Power BI Workspace App Workspace Creation in Real-time Publish Reports from Power BI Desktop Reports and Datasets in Power BI Cloud Pin Visuals and Pin LIVE Report Pages Dashboard Creation and Tiles, Media Images, Web Content, Videos, Q & A Mobile View, Web View, QR Codes, Shares Enabling Interactive Visuals. Embed Codes Report Shares and Dashboard Shares App Publish Options and App Updates Power BI Report Edits in Cloud, Visuals Download PBIX Reports from Cloud Sharepoint Integration, PPTX and Excel
Video 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	Video 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	Video 14 : Power BI Service (Cloud) - 2 Dashboard Properties and Security Report properties and Security Dataset properties and Security Report Insights, Related Items & Metrics Quick Insights. Publishing App Workspace Power BI LIVE Report Edits, Downloads Content Packs : Creation and Use Organizational and Service Level Content Packs from Azure MarketPlace Gateway Clusters - Installation Personal and Enterprise Gateways NT SERVICE\PBIEgwSERVICE Account Dataset Refresh Options and Schedules Azure Databus Integration, ODG Logs
Video 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	Video 9 : Power Query & M Language - 3 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 Removing Duplicate Rows and Columns Column Delimters and Field Formatting Group By Aggregations, Fill, Reverse Rows Format Options in M Language. Bookmarks Pivot and Unpivot Options in Power Query Data Type Conversions & Format Options	Video 15 : 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, Office 365 Excel Uploads & Cloud Imports, Office 365 Cell Selection and PINS in Power BI Excel Online Service - Edits and Pins Excel ODC Connections and Real-time Use Excel Power Pivot and Power BI Cloud Excel Drilldowns and Drillthru Reports Create Key Performance : KPI Reports Excel for Big Data Analysis, Reporting Worksheets and Dashboards with Excel Power Pivot Reports in with Excel Power View Report Options in Excel Change Type and Transform Operations Replace Values & Errors, Transpose
Video 4 : HIERARCHIES and FILTERS Hierarchies - Creation, Purpose & Realtime Usage Using Hierarchies in Power BI Visual Fields Using Hierarchies for Visualization Data Drills Drill-down Reporting Options in Power BI Visuals Drill-thru Reporting Options in Power BI Visuals Drill-down with Isolated and Dependant Options Expand, Goto Next Level and Drill-up Options Data Explore Options : Spotlight & Focus Options See Data, Export Data, See Records in PBI Canvas Include & Exclude Options. Multi-Field Values Filters and Real-time Usage with Power BI Reports Report Filters & Page Filters - Usage in Real-time Visual Filters and Comparison with Slicer Values Drill-down Filters - their visibility in Drilldowns Filter Options: Basic, Advanced and Top N Values Big Data Access with Power BI - Filters Usage	Video 10 : POWER QUERY - PARAMETERS Need for Parameters and Conditions in Power BI Creating Parameters using Power Query (M Lang) Intrinsic Parameters and User Query Parameters Parameter Data Types, Default Value Lists Linking Parameters with Query Results (Tables) Static List Parameters and Invoke Options Defining Dynamic Lists For Parameters, ToTable() Parameters with Table.SelectRows() Functions Testing Parameters with PBIT and PBIX Files Using Parameters in PBIX Edit Query Screens Defining Parameters using Advanced Query Option Parameter Control and Edit and Run Time, Get Data Static Web Page Data Source, Parameterization Defining Value List for Parameters in Power Query Implementing Table Parameters in Power Query Structured Lists, Dynamic Parameter Connections	Video 16: POWER BI REPORT SERVER Need for Power BI Report Server in Intranet Security Advantages with Report Server Database Report Server Settings & Power BI Admin Console Install and Configure Power BI Report Server Report Server Database & ReportTemp Database Webservice URL and Webportal URL - Usage Report Builder Tool - Installation and Usage Creating Report Data Source and Report Dataset Designing Paginated Reports (RDL) and Testing Deploy to Power BI Report Server - Settings Data Source Connections, Report Server Options Register Power BI Report Server to Cloud Tenant IDs Generation and Real-time Usage Publish RDL Reports to Power BI Cloud via URL Pinning Paginated Reports Convert to Intractive Paginated Reports Versus Interactive Reports
Video 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 Adding Text Box, Images, Buttons Shapes	Video 11 : DAX Functions & Usage - 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	Video 17 : REST APIs & Power BI Admin REST APIs with Power BI Cloud Service Streaming Datasets Creation in Power BI API : Usage. SubKeys and Channels Push and Pubnub Datasets in Power BI Azure Stream for Real-time Data Reports Real-time Data Tracking Visuals (Interactive) Power BI Mobile Publisher and Mobile Reports Power BI Vs Tableau, SSRS, Sharepoint Licensing & Pricing Plans in Power BI MSBI SSAS and SSRS with Power BI Custom Visuals in Power BI Configuring Alerts in Power BI Managing and Receiving Alerts Power BI with OneDrive, Google Analytics SaaS Components, OneDrive with PowerBI
Video 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 & PBIVIZ Files. Visual Sync PBI : Options and Settings, VM Settings	Video 12 : DAX Functions & Usage - 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	Video 18 : POWER BI with R LANGUAGE Introduction to R and Microsoft R Open (MRO) MKL (Math Kernel Library) Libraries, R Engine R Script and R Visual Usage in Power BI Tools Using R as General Public License Version (GPL) R Language compiler and mran [R revolution Org] Installing Microsoft R Open in Windows OS Installing RStudio Tool & R Packages Activation Configuring R for Predictive Analysis, Reports Configuring Power BI Desktop for R Script Enabling R Scripts. Executions in Power BI Get Source Data (Dynamic) using R Scripts Using R Visual in Power BI Desktop Tool Using Power BI Canvas for Forecast Analysis Power BI Limitations with R in Real-time New Features from Latest Releases of Power BI
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 New Features from Latest Releases of Power BI

Module I: Power BI Basics, Visuals

Module II: ETL and Data Modelling

Module III: Power BI Service (Cloud)

Video 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

Video 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

Video 13 : Power BI Service (Cloud) - 1

Power BI Cloud & Power BI Workspace
App Workspace Creation in Real-time
Publish Reports from Power BI Desktop
Reports and Datasets in Power BI Cloud
Pin Visuals and Pin LIVE Report Pages
Dashboard Creation and Tiles, Media
Images, Web Content, Videos, Q & A
Mobile View, Web View, QR Codes, Shares
Enabling Interactive Visuals. Embed Codes
Report Shares and Dashboard Shares
App Publish Options and App Updates
Power BI Report Edits in Cloud, Visuals
Download PBIX Reports from Cloud
Sharepoint Integration, PPTX and Excel

Video 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

Video 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

Video 14 : Power BI Service (Cloud) - 2

Dashboard Properties and Security
Report properties and Security
Dataset properties and Security
Report Insights, Related Items & Metrics
Quick Insights. Publishing App Workspace
Power BI LIVE Report Edits, Downloads
Content Packs : Creation and Use
Organizational and Service Level
Content Packs from Azure MarketPlace
Gateway Clusters - Installation
Personal and Enterprise Gateways
NT SERVICE\PBIEgwSERVICE Account
Dataset Refresh Options and Schedules
Azure Databus Integration, ODG Logs

Video 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

Video 9 : Power Query & M Language - 3

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
Removing Duplicate Rows and Columns
Column Delimters and Field Formatting
Group By Aggregations, Fill, Reverse Rows
Format Options in M Language. Bookmarks
Pivot and Unpivot Options in Power Query
Data Type Conversions & Format Options

Video 15 : 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, Office 365
Excel Uploads & Cloud Imports, Office 365
Cell Selection and PINS in Power BI
Excel Online Service - Edits and Pins
Excel ODC Connections and Real-time Use
Excel Power Pivot and Power BI Cloud
Excel Drilldowns and Drillthru Reports
Create Key Performance : KPI Reports
Excel for Big Data Analysis, Reporting
Worksheets and Dashboards with Excel
Power Pivot Reports in with Excel
Power View Report Options in Excel
Change Type and Transform Operations
Replace Values & Errors, Transpose

Video 4 : HIERARCHIES and FILTERS

Hierarchies - Creation, Purpose & Realtime Usage
Using Hierarchies in Power BI Visual Fields
Using Hierarchies for Visualization Data Drills
Drill-down Reporting Options in Power BI Visuals
Drill-thru Reporting Options in Power BI Visuals
Drill-down with Isolated and Dependant Options
Expand, Goto Next Level and Drill-up Options
Data Explore Options : Spotlight & Focus Options
See Data, Export Data, See Records in PBI Canvas
Include & Exclude Options. Multi-Field Values
Filters and Real-time Usage with Power BI Reports
Report Filters & Page Filters - Usage in Real-time
Visual Filters and Comparison with Slicer Values
Drill-down Filters - their visibility in Drilldowns
Filter Options: Basic, Advanced and Top N Values
Big Data Access with Power BI - Filters Usage

Video 10 : POWER QUERY - PARAMETERS

Need for Parameters and Conditions in Power BI
Creating Parameters using Power Query (M Lang)
Intrinsic Parameters and User Query Parameters
Parameter Data Types, Default Value Lists
Linking Parameters with Query Results (Tables)
Static List Parameters and Invoke Options
Defining Dynamic Lists For Parameters, ToTable()
Parameters with Table.SelectRows() Functions
Testing Parameters with PBIT and PBIX Files
Using Parameters in PBIX Edit Query Screens
Defining Parameters using Advanced Query Option
Parameter Control and Edit and Run Time, Get Data
Static Web Page Data Source, Parameterization
Defining Value List for Parameters in Power Query
Implementing Table Parameters in Power Query
Structured Lists, Dynamic Parameter Connections

Video 16: POWER BI REPORT SERVER

Need for Power BI Report Server in Intranet
Security Advantages with Report Server Database
Report Server Settings & Power BI Admin Console
Install and Configure Power BI Report Server
Report Server Database & ReportTemp Database
Webservice URL and Webportal URL - Usage
Report Builder Tool - Installation and Usage
Creating Report Data Source and Report Dataset
Designing Paginated Reports (RDL) and Testing
Deploy to Power BI Report Server - Settings
Data Source Connections, Report Server Options
Register Power BI Report Server to Cloud
Tenant IDs Generation and Real-time Usage
Publish RDL Reports to Power BI Cloud via URL
Pinning Paginated Reports Convert to Intractive
Paginated Reports Versus Interactive Reports

Video 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
Adding Text Box, Images, Buttons Shapes

Video 11 : DAX Functions & Usage - 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

Video 17 : REST APIs & Power BI Admin

REST APIs with Power BI Cloud Service
Streaming Datasets Creation in Power BI
API : Usage. SubKeys and Channels
Push and Pubnub Datasets in Power BI
Azure Stream for Real-time Data Reports
Real-time Data Tracking Visuals (Interactive)
Power BI Mobile Publisher and Mobile Reports
Power BI Vs Tableau, SSRS, Sharepoint
Licensing & Pricing Plans in Power BI
MSBI SSAS and SSRS with Power BI
Custom Visuals in Power BI
Configuring Alerts in Power BI
Managing and Receiving Alerts
Power BI with OneDrive, Google Analytics
SaaS Components, OneDrive with PowerBI

Video 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 & PBIVIZ Files. Visual Sync
PBI : Options and Settings, VM Settings

Video 12 : DAX Functions & Usage - 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

Video 18 : POWER BI with R LANGUAGE

Introduction to R and Microsoft R Open (MRO)
MKL (Math Kernel Library) Libraries, R Engine
R Script and R Visual Usage in Power BI Tools
Using R as General Public License Version (GPL)
R Language compiler and mran [R revolution Org]
Installing Microsoft R Open in Windows OS
Installing RStudio Tool & R Packages Activation
Configuring R for Predictive Analysis, Reports
Configuring Power BI Desktop for R Script
Enabling R Scripts. Executions in Power BI
Get Source Data (Dynamic) using R Scripts
Using R Visual in Power BI Desktop Tool
Using Power BI Canvas for Forecast Analysis
Power BI Limitations with R in Real-time
New Features from Latest Releases of Power BI

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

New Features from Latest Releases of Power BI

Note : Above course curriculum applicable for registrations from July 9th, 2018.

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

Click Here for Free Demo Video and Video Training Registration

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.

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.