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 Check-Symbol-for-Yes Check-Symbol-for-Yes
Resume, Job Support Check-Symbol-for-Yes Check-Symbol-for-Yes
Real-time Project (ERP) Check-Symbol-for-Yes Check-Symbol-for-Yes
Power BI Desktop Check-Symbol-for-Yes Check-Symbol-for-Yes
Power BI Service Croos-symbol-for-No Check-Symbol-for-Yes
Power BI Report Server Croos-symbol-for-No Croos-symbol-for-No
Complete MSBI : IS, AS, RS Croos-symbol-for-No Croos-symbol-for-No
Microsoft BI Certification Croos-symbol-for-No Croos-symbol-for-No
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:

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)

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

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.