SSRS Online Training - LIVE, Instructor Led

SSRS Online Training at SQL School Training Institute - is carefully designed to offer complete real-time training on Report Design, Development, Testing, Tuning, Delivery and Automation of Enterprise Reprots as well as Adhoc Reports. This SSRS Online Training includes Paginated Reports, Dashboards, Map Reports, Chart Reports, Shape Charts, SSRS Expressions, Report Builder, Report Server, SSRS Power BI Intergration with Report Builder Paginations, Report Parts, Report Snapshots and Dynamic Email Subscriptions. Our SSRS Training sessions are completely practical with a real-time Project. This course also includes Resume Building and FAQs on the Real-time project [ECommerce Domain].

SSRS (Reporting Services) Training Plans

  PLAN A PLAN B PLAN C
Description SSRS SSRS, Power BI T-SQL, SSRS, Power BI
Total Duration 2 Weeks 5.5 Weeks 8 Weeks
SSRS Installation, Configuration Check-Symbol-for-Yes Check-Symbol-for-Yes Check-Symbol-for-Yes
SSRS Groups, Sub Groups Check-Symbol-for-Yes Check-Symbol-for-Yes Check-Symbol-for-Yes
SSRS Chart Reports Check-Symbol-for-Yes Check-Symbol-for-Yes Check-Symbol-for-Yes
Dashboards, Actions, Bookmarks Check-Symbol-for-Yes Check-Symbol-for-Yes Check-Symbol-for-Yes
SSRS Deployment Check-Symbol-for-Yes Check-Symbol-for-Yes Check-Symbol-for-Yes
Report Server Management Check-Symbol-for-Yes Check-Symbol-for-Yes Check-Symbol-for-Yes
Mobile & KPI Reports Check-Symbol-for-Yes Check-Symbol-for-Yes Check-Symbol-for-Yes
OLAP Cube Reports Check-Symbol-for-Yes Check-Symbol-for-Yes Check-Symbol-for-Yes
Power BI Report Design Check-Symbol-for-Yes Check-Symbol-for-Yes
Power BI Desktop, Custom Visuals Check-Symbol-for-Yes Check-Symbol-for-Yes
Data Modelling with Power Query Check-Symbol-for-Yes Check-Symbol-for-Yes
Data Modelling with DAX Check-Symbol-for-Yes Check-Symbol-for-Yes
Power BI Cloud, Excel Analysis Check-Symbol-for-Yes Check-Symbol-for-Yes
Power BI Mobile, R, REST API Check-Symbol-for-Yes Check-Symbol-for-Yes
Power BI Datasets, Data Flows Check-Symbol-for-Yes Check-Symbol-for-Yes
Cube Reports in Power BI Check-Symbol-for-Yes Check-Symbol-for-Yes
SSRS Migrations to Power BI Check-Symbol-for-Yes Check-Symbol-for-Yes
Basic SQL, SQL Server Check-Symbol-for-Yes
SQL Server Architecture Check-Symbol-for-Yes
SQL Server T-SQL Concepts Check-Symbol-for-Yes
Joins, Queries, Stored Procedures Check-Symbol-for-Yes
Normal Forms and RAID Check-Symbol-for-Yes
MCSA Certification Guide Check-Symbol-for-Yes
Total Course Fee* INR 7,000
USD 95
INR 11,000
USD 149
INR 19,000
USD 257

*+ 18% GST applicable for INR Payments, 6% Paypal Charges for USD Payments

Trainer: Mr. Sai Phanindra T

S. No Timings (IST) Start Date  
SSRS Training Schedules
1 7:15 AM - 8:15 AM Apr 30th Register
2 5 PM - 6 PM May 5th Register
Schedules for SQL Server Basics
1 6:15 AM - 7:15 AM Mar 31st Register
2 8:15 AM - 9:15 AM Apr 21st Register
3 9:30 AM - 10:30 AM Apr 8th Register
4 10:30 AM - 11:30 AM Apr 28th Register
5 11:30 AM - 12:30 PM May 12th Register
6 6 PM - 7 PM May 4th Register
7 7 PM - 8 PM June 2nd Register
8 8 PM - 9 PM Started Register
Power BI Training Schedules
1 8:15 AM - 9:15 AM Mar 31st Register
2 9:30 AM - 10:30 AM May 5th Register
3 11:30 AM - 12:30 PM Apr 14th Register
4 6 PM - 7 PM Apr 6th Register
5 7 PM - 8 PM May 11th Register

If above schedule does not work, opt for SSRS Training Videos

SSRS TRAINING HIGHLIGHTS :

Funel Reports Dashboards
TreeMaps Power BI Integration
Azure Integration Interviews, Job Support
Real-time Project Basic to Advanced DAX
Resume Guidance Certification, Placements
Custom Visuals Power BI Mobile
Big Data Sources R, Python, JSON
Excel Analysis Gateways, Rest API
Power BI Admin Report Server

All Session Are Completely Practical & Real Time

SSRS LIVE Online Training Course Contents:

Ch 1: INTRODUCTION, INSTALLATION

  • Data, Databases and RDBMS Software
  • Microsoft SQL Server Advantages, Use
  • Database Engine Component and OLTP
  • BI Components & Data Science Components
  • SQL : Purpose, Real-time Usage Options
  • SQL Versus Microsoft T-SQL [MSSQL]
  • Microsoft SQL Server - Career Options
  • Real-time Projects & Job Responsibilities
  • Versions and Editions of SQL Server
  • SQL Server and SSMS Installation Plan
  • SQL Server Pre-requisites : S/W, H/W
  • SQL Server 2016 / 2017 Installation
  • SQL Server 2019 Installation
  • Instance Name and Server Features

Ch 5 : CONSTRAINTS, KEYS

  • Constraints and Keys - Data Integrity
  • NULL, NOT NULL Property on Tables
  • UNIQUE KEY Constraint and Usage
  • PRIMARY KEY Constraint and Usage
  • FOREIGN KEY Constraint, References
  • CHECK Constraint Usage & Conditions
  • DEFAULT Constraint Usage and Rules
  • Identity Property : Seed & Increment
  • Database Diagrams (E R), Relations
  • Install and Use Database Diagrams
  • Composite Keys Creation from GUI
  • Candidate Keys and Foreign Keys
  • Adding Keys to Existing Tables
  • Constraint Priority and Executions

Ch 9: View, Procedure, Function Basics

  • Views : Types, Usage in Real-time
  • System Predefined Views and Audits
  • Listing Databases, Tables, Schemas
  • Functions : Types, Usage in Real-time
  • Scalar, Inline and Multi-Line Functions
  • System Predefined Functions, Audits
  • DBId, DBName, ObjectID, ObjectName
  • Variables & Parameters in SQL Server
  • Procedures : Types, Usage in Real-time
  • User & System Predefined Procedures
  • Parameters and Dynamic SQL Queries
  • Sp_help, Sp_helpdb and sp_helptext
  • sp_pkeys, sp_rename and sp_help
  • When to use Which Database Objects

Ch 2: SSMS Tool, SQL BASICS - 1

  • SQL Server Management Studio
  • Local and Remote Connections
  • System Databases: Master and Model
  • MSDB, TempDB, Resource Databases
  • Creating Databases : Files [MDF, LDF]
  • Creating Tables in User Interface
  • Data Insertion & Storage. Limitations
  • SQL : Purpose and Real-time Usage
  • SQL Versus T-SQL : Basic Differences
  • DDL, DML, SELECT, DCL and TCL
  • Creating Tables using SQL Scripts
  • Data Storage, Inserts - Basic Level
  • Table Data Verifications with Select
  • SELECT Statement for Table Retrieval

Ch 6: JOINS, T-SQL Queries : Level 1

  • JOINS - Table Comparisons Queries
  • INNER JOINS For Matching Data
  • OUTER JOINS For (non) Match Data
  • Left Outer Joins with Example Queries
  • Right Outer Joins with Example Queries
  • FULL Outer Joins - Realtime Scenarios
  • Join Queries with "ON" Conditions
  • Join Unrelated Tables in SQL Server
  • NULL, IS NULL Operators in Joins
  • CROSS JOIN and CROSS APPLY
  • CROSS JOIN Versus CROSS APPLY
  • One-way & Two Way Data Comparisons
  • Important Join Queries in T-SQL

Ch 10: Triggers & Linked Servers

  • Triggers - Purpose, Real-world Usage
  • FOR/AFTER Triggers - Real time Use
  • INSTEAD OF Triggers - Real time Use
  • INSERTED, DELETED Memory Tables
  • Enable Triggers and Disable Triggers
  • Database Level, Server Level Triggers
  • Linked Servers and Real-time Usage
  • Creating Linked Servers in SQL Server
  • Security Options and Access Options
  • Data Access, RPC and RPC Out Settings
  • Linked Servers for Remote Joins
  • Using Aliases with Linked Servers

Ch 3: SQL Basics - 2

  • Creating Databases & Tables in SSMS
  • Single Row Inserts, Multi Row Inserts
  • Rules for Data Insertion Statements
  • SELECT Statement @ Data Retrieval
  • SELECT with WHERE Conditions
  • AND and OR Operators Usage
  • IN Operator and NOT IN Operator
  • Between, Not Between Operators
  • LIKE and NOT LIKE Operators
  • UPDATE Statement & Conditions
  • DELETE & TRUNCATE Statements
  • Logged and Non-Logged Operations
  • ADD, ALTER and DROP Columns
  • ALTER & DROP Table Statements

Ch 7: Group By, T-SQL Queries Level 2

  • GROUP BY Queries and Aggregations
  • Group By Queries with Having Clause
  • Group By Queries with Where Clause
  • Using WHERE and HAVING in T-SQL
  • Rollup : Usage and T-SQL Queries
  • Cube : Usage and T-SQL Queries
  • UNION and UNION ALL Operator
  • Date and Time Functions in T-SQL
  • GetDate(), Convert(), Date Styles
  • DateAdd() and DateDiff() Functions
  • String Functions in T-SQL: Replace()
  • SubString, Reverse, Trim Functions
  • RowNumber(), Rank(), DenseRank()
  • PARTITION BY and Sequence Reset

Ch 11: Transactions, Architecture

  • Transactions : Types, ACID Properties
  • Transaction Types and AutoCommit
  • EXPLICIT & IMPLICIT Transactions
  • COMMIT and ROLLBACK Statements
  • Open Transaction Scenarios & Cause
  • Query Blocking Scenarios @ Real-time
  • NOLOCK and READPAST Lock Hints
  • Server Architecture and Protocols
  • Database Engine and Query Processor
  • Parser, Optimizer, SQL & DB Manager
  • Storage Engine Components, SQL OS
  • Transaction Services, Buffer Manager
  • Lock Manager, IO Manager, MDAC
  • CLR, WAL, Lazy Writer, Checkpoint

Ch 4: SQL Basics - 3

  • Schemas : Group Tables in Database
  • Using Schemas for Table Creation
  • Using Schemas in Table Relations
  • Table Migrations across Schemas
  • Using Schemas in Real-world
  • Import and Export Wizard in SSMS
  • Performing Bulk Operations in SSMS
  • Using Default / Named Schemas
  • SQL Server Native Client Connection
  • Temporary Tables : Real-time Use
  • Local and Global Temporary Tables
  • # and ## Prefix, Scope of Usage
  • Temporary Versus Permenant Tables
  • Temprary Tables and Scope Tests

Ch 8: Joins, T-SQL Queries Level 3

  • Joining 2, 3 and 4 Tables in T-SQL
  • T-SQL Joins with Table Aliases
  • Column Aliases and Aggregations
  • Joins with Sub Queries, Conditions
  • GROUP BY Queries in Joins, Where
  • Sub Queries with Joins, Group By
  • Rollup with Joins and Group By
  • Using Views to Store TSQL Queries
  • Database, Table Access For End Users
  • Real-time Cautions for Query Store
  • Excel Data Connections : SQL Server
  • Creating ODC Connections & Refresh
  • Excel Pivot Tables, Pivot Charts
  • Report Fields, Data Labels, Reports

Ch 12: Real-time Case Study

  • Excel Pivot Tables From SQL Data
  • Excel Pivot Charts From SQL Data
  • Writing Sub Queries with Joins
  • Queries with Date/Time Formatting
  • IIF, Case Statement, PIVOT
  • Merge : MATCHED & NOT MATCHED
  • TSQL Queries with Merge, Pivot
  • Normal Forms, Entity Relation Diagram
  • First, Second, Third Normal Forms
  • Boycee-Codd Normal Form : BNCF
  • Functional and Multi-Valued Dependency
  • 4 NF and ETNF Differences, Usage
  • 1:1, 1:M, M:1, M:M Relationships

Module I: REPORT DESIGN

Module II: REPORT DESIGN, MANAGEMENT

Ch 1: SSRS INSTALLATION, CONFIGURATION

  • Reporting Operations and Report Types
  • Paginated Reports and Interactive Reports
  • Analytical Reports and Mobile Reports
  • Need For Reporting Solutions (SSRS) and Tools
  • Reporting Engine Architecture, Report Databases
  • SSRS Report Server Installation Process
  • Report Databases in SSRS and Real-time Usage
  • Web Service URL : Purpose, Test Connection, Usage
  • Web Portal URL - Purpose, Test Connection, Usage
  • Report Server Database, Report TempDB Configuration
  • SSRS Tools : SQL Server Data Tools (SSDT)
  • Report Builder and Mobile Report Publisher
  • Report Design & Work Flow - Lab Plan, Data Sources
  • Three-Phase Report Life Cycle in Reports (End-End)
  • Report Builder Versus Report Designer : Basics
  • Report Server and Webservice Integration

Ch 6: REPORT BUILDER, GAUGE REPORTS

  • Report Builder Tool Installation & Real-time Use
  • Differences with Report Designer Tool, Limitations
  • Data Source, DataSet Creation with Report Builder
  • Dataset Design with Parameters and Filters. Usage
  • Query Designer with Report Builder, Table Selection
  • Column Aggregates and Auto Group By. Query Edits
  • Adhoc Reports with Drill-down and Column Groups
  • Dynamic Row Colors, Report Expression Options
  • Gauge Reports: Purpose, End User Access
  • Report Types - Radial and Linear Gauges
  • Indicators, Pointers, Scale Range Values
  • Browser Compatibility and Offline Reports
  • Gauge, Gauge Panel Properties and Filters
  • Scale - Properties, Values, Label Options
  • Ranges and Labels, Items, Needle Options
  • Parameterized Gauge Reports and Datasets

Ch 2: BASIC REPORT DESIGN

  • 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
  • Table Headers, Formatting Options, MATH Expressions
  • Alternate Row Colors, Report Globals, Expressions
  • Report Formatting Styles, Expressions & Reusability
  • Reporting Functions: IIF, Format, Ceiling, Round
  • Textbox Properties: DateTime Formats, Numbers, Styles
  • Initial Catalog - Report Sources, Static/Dynamic Properties

Ch 7: REPORT BUILDER REPORTS, MAP REPORTS

  • Map Reports - Map Layers and Map Report Items
  • Map Gallery, ESRI Share Files and Spatial data
  • Geo Spatial Data for Business Analysis Dashboards
  • Polygon, Tile, Line and Point Map Layer Options
  • Map Visualization Options and Bubble Map Reports
  • Data Fields, Display Labels, Visualization Indicators
  • Fields to Visualize, Color Rules and Display Labels
  • Editing Report Builder Reports in Report Designer
  • SSRS Deployment for Report Designer Reports
  • SSRS Deployment for Report Builder Reports
  • Report Deployment - Builds and Config Files
  • Webservice URL and Webportal URL Access
  • Data Source, Data Set Folders and Report URL
  • Report Deployment of Shared Data Source Items
  • Report Deployment of Shared Datasets and Reports
  • Report Manager Uploads for RDL Files, Verification

Ch 3: GROUPING and REPORT PARAMETERS

  • 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
  • Drill-down Reports using Row Groups and Visibility
  • Column Groups - Advance Mode - Fixed Attributes, Fields
  • Repeating Header on Every Page & Repeat Page Options
  • Creating Parameters using Dataset Query Conditions
  • Single Value Parameters and Multi Value Parameters
  • Dynamic Parameter Values, Dependency Options, Queries
  • Defining Datasets with Parameters, Dynamic Conditions
  • Dataset Links to Parameters, Values from List, Query
  • Multi-Value Parameters: Data Types, Null, Empty Values
  • Reports using Multiple Data Sets. Performance Issues
  • SSRS Expressions, Global Fields For Report Parameters
  • Advanced Options : Auto Refresh, Manual Refresh Options

Ch 8: REPORT MANAGEMENT

  • Data Source Management and Subscriptions
  • Dependant Items and Security Operations
  • Editing Shared Data Sources in Web Portal
  • Shared Data Source Operations: Enable, Hide
  • Connection Types, Connection Edits, Security
  • Shared Dataset Operations: Report Builder Edits
  • Data Preview, Data Loads and Dependant Items
  • Report Edits, Download / Upload, Linked Reports
  • Security Management: Browser Role, User Access
  • Content Management, My Reports, Publisher
  • Report Builder, Report Definitions, Uploads
  • Report Tuning: Caching, Rebuilds and Refresh
  • Report Tuning: Report Snapshots and Schedules
  • Subscriptions: Standard and Data Driven
  • Email and File share Subscriptions in SSRS
  • Schedules and Report Delivery Options
  • Report Server Settings, Shared Schedules
  • Report Timeout, Report Parts and Publish
  • Sub Reports and Report Parts in Report Builder

Ch 4: CHART REPORTS, DASHBOARDS, FITLERS

  • 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 / Non Clustered Attributes. Position Options
  • Series Labels : Properties, Number Formatting, Visibility
  • Series Actions : Series Properties, Multi - Valued Parameters
  • Report Actions : URL / Reports, Setting for Report Filters
  • 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
  • Dataset Filters, Toolbox Filters and Bookmarks Usage
  • Filters versus Parameters - Differences with Performance
  • Filter Condition at Dataset Level, Toolbox Level

Ch 9: MOBILE, KPI, CUBE REPORTS

  • Mobile Reports : Creation & Usage
  • Excel and Report Server Sources
  • Working with Mobile Report Publisher
  • Report Elements and Design Options
  • Layout: Master, Tablet and Phone
  • Grids and Color Palette. Deployment
  • RSMobile Formats: Uploads, Downloads
  • Shared Dataset in Report Builder Tool
  • KPI Reports: Design from Web Portal
  • KPI: Value, Goal, Status, Trend
  • KPI Visuals: Bar, Line, Step, Area
  • Custom URLs and Mobile Reports
  • SSRS Cube Reports with SSAS MDX Queries
  • SSRS Cube Reports with SSAS DAX Queries
  • SSRS Cube Reports with Parameters
  • MDX Default Parameters and Options
  • MSBI SSAS OLAP Cube Actions with SSRS

Ch 5: SSRS EXPRESSIONS, SHARED DATASETS

  • Defining Shared Data Sources and Shared DataSets
  • Date and Time Expressions with RDL Files
  • FORMAT Function in SSRS, Date Parameters
  • Data Type Conversions and Integer / String Types
  • String Functions and Page Breaks in SSRS
  • LOOKUP Function and Dataset Joins in SSRS
  • Field Value Replacement with Datasets
  • Using LIST Item from SSRS Toolbox
  • Field Expressions and Field Properties
  • #VALX, #VALY, #PERCENT, #SERIES Label Properties
  • #LABEL, #AXISLABEL, #TOTAL, #LEGENDTEXT
  • 3D Pie Charts, Funnel and Tree Map Reports.
  • 3D Funnel and Sunburst Reports. Shape Charts
  • Doughnut, Pyramid and 3D Pyramid Reports
  • Parameterized Gauge Reports - Dataset Level Filters
  • Indicator Reports : Value and State Expressions
  • SSRS Expressions, Report Code - Custom Functions

Ch 10: PROJECT WORK in SSRS

  • Using SQL Server Data Sources and Datasets
  • Designing RDL [Paginated Reports], Expressions
  • Chart Reports, Line Reports and Options
  • Dataset with Parameters and Filters. Usage
  • Trend Analysis and Continuous Data Reports
  • Data Bar Reports and Stacked Reports - Usage
  • Multi-series Charts and Dynamic Chart Size
  • Axis Display Control in SSRS Paginated Reports
  • Parameters and Filters - When to use which, why?
  • Complete Project Solution with Explanation
  • Work Flow Operations and Report Types
  • Report Design, Builds and Report Deployment
  • Report Edits, Data Source Changes to Azure
  • Using Azure SQL Database for SSRS DB Source
  • Report Management, Security, Subscriptions
  • Report Tuning, Caching and Snapshot Options
  • Project FAQs and Explanations for Resume

Module I: Power BI Basics, Visuals

Module II: ETL and Data Modeling

Module III: Power BI Service (Cloud)

DAY 1 : POWER BI INTRO, INSTALL

  • Need for Big Data and BI Technologies
  • Power BI : Self-Service BI, Usage Scope
  • Data Analyst, Data Scientists Job Roles
  • Power BI Developer, Admin - Job Roles
  • Power BI Vs MSBI & SSRS Vs Tableau
  • Career Options: SQL + Power BI + MSBI
  • MCSA 70-778 Power BI Examination Plan
  • Power BI Architecture and EcoSystem
  • Report Types and Power BI Licensing Plans
  • Developer Tools, Mobile Apps, Gateways
  • Power BI Cloud Account Creation, Usage
  • Power BI Desktop and Power BI DesktopRS
  • Report Builder and Power BI Mobile Tools
  • Power BI Training Course - Lab Plan

DAY 7 : POWER QUERY - LEVEL 1

  • Power Query [M Language] - Architecture
  • Basic Data Types, Literals and Values
  • M Language : Data Mash Up & Primitives
  • let, source, in statements in M Lang
  • Functions, Parameters, Frowns, Invoke
  • Advanced Editor, Grouping, Load / Unload
  • Query Reference, Query Duplicate, Steps
  • Power Query Transformations Categories
  • Query Combine & Union Transformations
  • Merge Transformation Join Kinds, Grouping
  • Truncate, Replace, Split, Reduce Rows
  • Manage Columns, Aggregation Column Formats
  • Transpose, Reverse Rows Transformations
  • Power Query - Row Count and Replace

DAY 13 : POWER BI CLOUD

  • Power BI Service (Cloud) Architecture
  • App Workspace Creation in Real-time
  • Publish Reports from Power BI Desktop
  • Reports, Datasets in Power BI Cloud
  • Dashboards : Pins, Tiles and Shares
  • Pin Visuals and Pin LIVE Report Pages
  • Dashboard Actions : Metrics, Themes
  • REST APIs and Streamining Datasets
  • Pubnub Datasets, API Tiles @ LIVE Data
  • Report Actions: Metrics, Shares
  • Insights, Q & A, Visual Options
  • Persistent Filters, Cross Filtering
  • Report Edits, Filters, Embed Codes
  • Performance Inspector and QR Codes

DAY 2: REPORT DESIGN CONCEPTS

  • Designing Reports using Power BI Desktop
  • Report Visuals, Fields, Pages and Filters
  • Report, Data and Relationship Options
  • Enter Data and Get Data in PBI Canvas
  • Power BI Visualizations & Types, Reports
  • SPOTLIGHT, Web / Mobile, View Options
  • PBIX and PBIT File Formats. Differences
  • Table Visual : Grid Properties and Pages
  • Visual Options : Export and Focus Mode
  • Basic Modelling - Summary,Format,Currency
  • Visual Interactions & Values in Power BI
  • Edit Interactions - Filter, Slice Options
  • Slicer : Number, Text and Date Conditions
  • Visual Sync Property and Limitations

DAY 8 : POWER QUERY - LEVEL 2

  • Data Type Detections and Conversions
  • Fill Up/Fill Down, Rename, Move, Split
  • PIVOT and UNPIVOT Transformations
  • FORMAT, FILTER and ConvertToList()
  • EXTRACT, PARSE, NUMBER, COMBINE
  • DELETE and DELETE UNTIL END
  • Step Edits, New Steps, Step Inserts
  • Working with Date, Time Transformations
  • Deriving Year, Quarter, Month, Day
  • Add Column / Custom Column Transformation
  • Columns From Examples, Index Columns
  • JSON, XML and Query Combine - M Language

DAY 14 : POWER BI CLOUD, EXCEL

  • Defining Datasets in Cloud : Imports
  • Defining Workbooks in Cloud : Uploads
  • Reports from Excel Imports and Datasets
  • Dashboards from Workbooks, Excel Online
  • Creating and Using Content Packs
  • Organizational, Service Content Packs
  • Publishing App Workspace, Updates
  • Using Excel with Power BI Reports
  • Using Excel Analyzer in Power BI
  • Using Excel Publisher in PBI Cloud
  • Excel with Power BI Profiles, Pivot
  • Excel ODC Connections - Power Pivot
  • Connect Options : Excel to PBI Cloud
  • DAX Measures with Excel Analyser

DAY 3 : HIERARCHIES, FILTERS

  • Grouping and Binning with Fields
  • Bin Size and Biz Limits (Max, Min)
  • Creating Hierarchies. DrillDown Reports
  • Drill Thru Reports and Conditional Filters
  • Expand, Expand All Down, Goto Next Level
  • Drill Up, Drill Down. Exclude and Include
  • See Data, Export Data, See Records Options
  • Filters : Types and Usage in Real-time
  • Visual Filters, Page Filters, Report Filters
  • Drill-thru Filters with Hierarchy Levels
  • Basic, Advanced, TOP N Filters - Usage
  • Filtering at Category Level, Summary Level
  • Slicer Versus Filters - Comparisons

DAY 9 : POWER QUERY - LEVEL 3

  • Parameter Creation, Edits and Real-time Use
  • Parameter Data Types, Default / Current Values
  • Static Lists, Dynamic Lists For Parameters
  • Creating Parameters in Data Set Queries
  • Converting Columns to Lists in Power Query
  • Dynamic Dropdowns, Multi Valued Parameters
  • Data Conversions and toText() Functions
  • Data Modeling Options - Custom Columns
  • Columns From Examples, Indexed Column
  • Conditional Column, Custom Functions
  • Variables, Parameters - Power Query
  • IF..ELSE Conditions in Power Query
  • Loops and Cases in Power Query Expressions
  • Using Power Query Result in Power BI

DAY 15 : POWER BI CLOUD (ADMIN)

  • Power BI Data Gateway - Architecture
  • Gateway Installation, Configuration
  • Single Sign On Security, Kerberos
  • Incremental Loads and Privacy Levels
  • PBIEngw Service and ODG Logs, Audits
  • DataFlows Creation - Gateway Connections
  • Using Data Flows and Power BI Datasets
  • Security Levels in Power BI Cloud
  • Dashboard Security, Report Security
  • Dataset Security - Read and Reshare
  • App Workspace Security Management
  • Content Pack Security, Featured Items
  • Creating, Managing Alerts in Cloud
  • Row Level Security (RLS) with DAX

DAY 4 : BOOKMARKS, BIG DATA

  • Using Buttons, Images in Power BI Canvas
  • Bookmarks in Power BI Desktop - Usage
  • Buttons, Actions and URLs with Text
  • Using Bookmarks for Visual Filters
  • Using Bookmarks for Page Navigations
  • Using Selection Pane with Bookmarks
  • Buttons, Images in Power BI Desktop
  • Power BI Reports with OLTP Databases
  • Power BI Reports with OLAP Databases
  • Power BI Reports with DWH Databases
  • Power BI Reports with Big Data Sources
  • On-premise, Azure Cloud Database Access
  • Import and Direct Query with Power BI
  • Connect LIVE options in OLAP Databases

DAY 10 : DAX FUNCTIONS - LEVEL 1

  • DAX : Importance and Real-time Usage
  • DAX as library of Functions, Operators
  • Real-world usage of DAX with Power BI
  • Formulation Rules and DAX Data Types
  • In-Memory xVelocity Vertipaq Engine
  • Syntax, Functions, Context Options
  • ROW Context and Filter Context in DAX
  • Creating and Using Measures with DAX
  • Creating and Using Columns with DAX
  • Data Modeling Options in DAX
  • Detecting & Adding Relations for DAX
  • Power BI DAX Functions - Types, Usage
  • Quick Measures in DAX - Auto validations
  • Deciding / Identifying Measures & Columns

DAY 16: Report Server, Mobile Reports

  • Power BI Report Server - Installation
  • Report Server Databases and Web URLs
  • Hybird Cloud [Tenant] Configuration
  • Deploying Reports to Power BI Server
  • Report Builder Paginated Reports, Upload
  • SQL Server Agent, Credentials, Pins
  • Paginated Reports Vs Interactive Reports
  • Power BI Mobile Reports - Configurations
  • Mobile Report Design Tools, Data Sources
  • Power BI Mobile Elements and Grid Counts
  • Excel Data for Power BI Mobile Reports
  • Report Server Sources and Report Hosting
  • Navigation Options with Power BI Mobile
  • Mobile Reports Vs Interactive Reports

DAY 5 : POWER BI VISUALS - LEVEL 1

  • Table Visual and Matrix Visuals: Styles
  • Column Formatting, Conditional Formatting
  • Divergent Colors, Grids, Groups, Totals
  • Chart Reports : Axis, Legend, Value, Labels
  • Stacked Bar Chart, Stacked Column Chart
  • Clustered Bar and Clustered Column Chart
  • 100% Stacked Bar and Stacked Column Charts
  • Line Chart, Area Chart, Stacked Area Chart
  • Ribbon Chart and Scater Chart : Play Axis
  • Match Series, Plot Area, Color Saturation
  • Waterfall Chart - Sentiment Colors
  • Breakdown Count - Decrease / Increase
  • Join Types, Lines: Round, Bevel, Miter
  • Shapes and Markers in Power BI Visuals

DAY 11 : DAX FUNCTIONS - LEVEL 2

  • Date and Time & Text Functions
  • Time Intelligence Functions in DAX
  • Logical & Mathematical Functions
  • Data Modeling with DAX. Creating Roles
  • SUM and DATEDIFF Examples in DAX
  • TODAY, DATE, DAY Arguments with DAX
  • DIVIDE, CALCULATE, Variables
  • IF..ELSE..THEN, RELATED & COUNTROWS
  • SELECTEDVALUE, FORMAT Functions
  • CALCULATE, SUM, ALL Functions
  • FILTER with ROWCOUNT, USERELATIONSHIP
  • EARLIER for Time Based Comparisons
  • Using Variables in DAX Computations
  • Considerations for Quick Measures

DAY 17: POWER BI INTEGRATIONS

Power BI with MSBI Integrations
  • Power BI with MSBI - SSAS OLAP Database
  • Multidimensional, Tabular Mode Databases
  • Import Data and Connect LIVE Options
  • Using MDX & DAX with Power BI Reports
  • Excel Integration with Power BI, SSAS
  • Converting SSRS Reports to Power BI
Power BI for Data Scientists
  • Enabling R Script in Power BI, RMAN
  • Installing R Studio, FORECAST Packages
  • Using R Script Visuals in Power BI
  • Python Visuals in Power BI
  • ETL, Data Modeling with Python

DAY 6 : POWER BI VISUALS - LEVEL 3

  • Tree Map Visual and Funnel Visual
  • Gauge, Donut, Single Row, MultiRow Card
  • Callout Values in KPI Reports and Use
  • Indicator, Trend and Target Goals in KPIs
  • Map Reports and Filled Map Reports
  • ArcGIS Maps - Latitudes and Longitudes
  • Data Points, Series and Data Analytics
  • Constant Lines and Threshold Values
  • Marketplace Visuals and PBIVIZ Files
  • HeatMaps - Visual, Real-time Usage
  • FlowMaps - Visual, Real-time Usage
  • Table HeatMaps with Real-time Usage
  • GanttChart - Visual, Real-time Usage
  • Power BI Infographics, Custom Visuals
  • PBI Infographics with Big Data Sources
  • Custom Visual Limitations & Migrations

DAY 12 : DAX FUNCTIONS - LEVEL 3

  • AVERAGEX and AVERAGE in DAX
  • KEEPFILTERS, COUNTROWS, RELATED
  • DIVIDE with FILTER, ALLSELECTED
  • ALL, MAX, PARALLELPERIOD, DATEDADD
  • CALCULATE with PREVIOUSMONTH
  • FILTER with ROWCOUNT, USERELATIONSHIP
  • TOTALYTD , TOTALQTD, TOTALMTD
  • SAMEPERIODLASTYEAR, IF, VARIANCE
  • DATESINPERIOD and AVERAGEX
  • DAX Variables, Time Type Dimensions
  • HOUR, NOW, SWITCH, TRUE - RETURNs
  • DAX Modeling Components - use
  • TABLES, COLUMNS, RELATIONS
  • MEASURES and HIERARCHIES
  • INTELLISENSE with DAX Editors
  • DISTINCTCOUNT and DIVIDE

DAY 18 - 20 : Real-time Project

Case 1: Real-time Project for Power BI
  • Includes Power BI Dev, Data Modeling
  • Includes Power BI Cloud, Report Server

Case 2: Real-time Project for SQL + Power BI
  • Includes Power BI Dev, Data Modeling
  • Includes Power BI Cloud, Report Server
  • Includes SQL Database Queries, Joins

Case 3: Real-time Project for MSBI + Power BI
  • Includes Power BI Dev, Data Modeling
  • Includes Power BI Cloud, Report Server
  • Includes SQL Database Queries, Joins
  • Includes OLAP, DWH and HTAP Data Sources
 
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 Online Training course participants should be able to :

  • Understand Report design, Identify DataSets, Joined Queries
  • Work with Report Parameters, Dataset Parameters and Filters
  • Design Linked Reports with Dynamic Filters and Parameters
  • Design Report variants including Gauge, Map & Indicator Reports
  • Tuning OLTP Reports and OLAP Reports - Caching and Snapshots
  • Deploy, Secure and Deliver Subscriptions and Email Reports
 

SQL Server, SQL DBA, MSBI DWH Trainings @ SQL School Training Institute: