SSRS Training

PLAN A PLAN B PLAN C

1. SSRS 1. T-SQL Queries 1. T-SQL Queries
Course Includes 2. SSRS 2. SSRS
3. Power BI
SSRS Installation, Configuration ✓ ✓ ✓
SSRS Groups, Sub Groups ✓ ✓ ✓
SSRS Chart Reports ✓ ✓ ✓
Dashboards, Actions, Bookmarks ✓ ✓ ✓
SSRS Deployment ✓ ✓ ✓
Report Server Management ✓ ✓ ✓
Mobile & KPI Reports ✓ ✓ ✓
OLAP Cube Reports ✓ ✓ ✓
Power BI Report Design X ✓ ✓
Power BI Desktop, Custom Visuals X ✓ ✓
Data Modelling with Power Query X ✓ ✓
Data Modelling with DAX X ✓ ✓
Power BI Cloud, Excel Analysis X ✓ ✓
Power BI Mobile, R, REST API X ✓ ✓
Power BI Datasets, Data Flows X ✓ ✓
Cube Reports in Power BI X ✓ ✓
SSRS Migrations to Power BI X ✓ ✓
Basic SQL, SQL Server X X ✓
SQL Server Architecture X X ✓
SQL Server T-SQL Concepts X X ✓
Joins, Queries, Stored Procedures X X ✓
MCSA Certification Guide X X ✓
Total Course Duration 2 Weeks 4.5 Weeks 8.5 Weeks

www.sqlschool.com For Free Demo: Reach us on 9666 44 0801 or 9666 64 0801 (24x7)
 Module 1: Basics, SQL Server & T-SQL Concepts (For SSRS Plan C)
Chapter 1: SQL SERVER INTRODUCTION
Data, Databases and RDBMS Software; Database Types : OLTP, DWH, OLAP; Microsoft SQL Server
Advantages, Use; Versions and Editions of SQL Server; SQL : Purpose, Real-time Usage Options; SQL Versus
Microsoft T-SQL [MSSQL]; Microsoft SQL Server - Career Options; Database Engine Component and OLTP; BI
Components, Data Science Components; ETL, MSBI and Power BI Components; Course Plan, Resume,
Project; 24 x 7 Lab; Software Installation Pre-Requisites;
Chapter 2: SQL SERVER INSTALLATIONS
System Configuration Checker Tool; Versions and Editions of SQL Server; SQL Server Pre-requisites : S/W,
H/W; SQL Server 2016 / 2017 Installation; SQL Server 2019 Installation; Instance Name; Instances : Types;
Default Instance, Named Instances; Port Numbers; Service and Service Account; Authentication Modes and
Logins; FileStream, Collation Properties;
Chapter 3: 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 GUI; Data
Insertion & Storage; SQL : Real-time Usage; DDL, DML, SELECT, DCL and TCL Statements; Data Storage,
Inserts - Basic Level; SELECT; Table Data Retrieval;
Chapter 4: 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; IN and NOT
IN; Between, Not Between; LIKE and NOT LIKE; UPDATE Statement; DELETE & TRUNCATE; Logged and Non-
Logged Operations; ADD, ALTER and DROP Statements;
Chapter 5: SQL BASICS - 3, T-SQL Introduction
Schemas : Group Tables in Database; Using Schemas for Table Creation; Using Schemas in Table Relations;
Table Migrations across Schemas; Default Schema : "dbo"; Import and Export Wizard; Bulk Operations; Excel
File Imports / Exports; SQL Server Native Client; Executing SSIS Packages, Data Loads; Local and Global
Temporary Tables; # & ## Prefix; Temporary Vs Permanent Tables;
Chapter 6: CONSTRAINTS & INDEXES BASICS
Constraints and Keys - Data Integrity; NULL, NOT NULL Property on Tables; UNIQUE KEY Constraint;
PRIMARY KEY Constraint; FOREIGN KEY Constraint, References; CHECK Constraint; DEFAULT Constraint;
Identity Property : Seed & Increment; Database Diagrams and ER Models; Indexes : Basic Types and
Creation; Clustered and Non Clustered Indexes; Primary Key and Unique Key Indexes;
Chapter 7: JOINS and TSQL Queries : Level 1
JOINS; INNER JOINS For Matching Data; OUTER JOINS For (non) Match Data; Left Outer Joins; Right Outer
Joins; FULL Outer Joins; One-way & Two Way Comparisons; "ON" Conditions; NULL, IS NULL; CROSS JOIN
and CROSS APPLY; Join Options: Merge, Loop and Hash Joins;
Chapter 8: GROUP BY, T-SQL Queries : Level 2
GROUP BY Queries and Aggregations; Group By Queries with Having Clause & Where Clause; WHERE and
HAVING in T-SQL; Rollup : T-SQL Queries; Cube : Usage and T-SQL Queries; UNION and UNION ALL; EXISTS;
Sub Queries; Joins with Group By Queries; Nested Sub Queries; UNION and UNION ALL; Nested Sub Queries
with Group By, Joins; Comparing WHERE, HAVING Conditions;
SQL School Training Institute. #101, 1st Floor, UMA Residency, Road #1, SR Nagar, Hyderabad - 38.
Trainings are completely practical. real-time. www.sqlschool.com For Free Demo: 9666 44 0801 (24 x 7)
Chapter 9: JOINS & T-SQL Queries : Level 3
GetDate, Year, Month, Chapter Functions; Date & Time Styles, Data Formatting; DateAdd and DateDiff
Functions; Cast and, Convert Functions in Queries; String Functions: SubString, Relicate; Len, Upper, Lower,
Left and Right; LTrim, RTrim, CharIndex Functions; MERGE Statement - Comparing Tables; WHEN MATCHED
and NOT MATCHED; IIF() Function for Value Compares; CASE Statement : WHEN, ELSE, END;
ROW_NUMBER() and RANK() Queries; Dense Rank and Partition By;
Chapter 10: 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; System Predefined Functions, Audits; DBId, DBName, ObjectID,
ObjectName; Variables & Parameters; System Predefined Procedures; Parameters; Sp_help, Sp_helpdb and
sp_helptext; sp_pkeys, sp_rename and sp_help;
Chapter 11: TRIGGERS & TRANSACTIONS
Triggers Real-world Usage; FOR/AFTER Triggers; INSTEAD OF Triggers; INSERTED, DELETED Memory Tables;
DML Automations using Memory Tables; Read Only Tables; Enable Triggers and Disable Triggers; ACID
Properties; Auto Commit; EXPLICIT & IMPLICIT; COMMIT and ROLLBACK; Open Transactions; Query Blocking
Scenarios @ Real-time; NOLOCK and READPAST Lock Hints;
Chapter 12: ER MODELS, NORMAL FORMS
Normal Forms for Entity Relationships; First, Second, Third Normal Forms Usage; Boycee-Codd Normal
Form: BNCF : Usage; 4 NF, EKNF, ETNF. Functional Dependency; Multi-Valued, Transitive Dependencies;
Composite Keys and Composite Indexes; 1:1, 1:M, M:1, M:M Relationship Types; SQL Queries Access in
Reporting Tools; Office Data Connection Files; Excel Pivot Reports; SQL Queries in BI Tools; FETCH OFFSET,
NEXT ROWS; Data Refresh (Manual, Automated);
REAL-TIME CASE STUDY – 2 (Sales & Retail), EXCEL INTEGRATION

Module 2: SQL Server Reporting Services (SSRS)

{For SSRS Plans A, B, C}
Chapter 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 and Report
Databases; SRS 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 and 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 Web Service Integration
Chapter 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; Report Toolbox
and Report Data Options, Textbox Usage; Table Headers, Formatting Options, MATH Expressions; Alternate Row
Colors, Using Report Globals, Expressions; Report Formatting Styles, Expressions and Reusability; Reporting

SQL School Training Institute. #101, 1st Floor, UMA Residency, Road #1, SR Nagar, Hyderabad - 38.
Trainings are completely practical. real-time. www.sqlschool.com For Free Demo: 9666 44 0801 (24 x 7)
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;
Chapter 3: GROUPING, 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, Value Options from List,
Query; Multi-Value Parameter Options: Data Types, Null, Empty Values; Reports using Multiple Data
Sets. Performance Issues; SSRS Expressions and Global Fields For Report Parameters; Advanced Options
: Auto Refresh, Manual Refresh Options;
Chapter 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 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; 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; 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;
Chapter 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
State Expressions; SSRS Expressions - Custom Functions;
Chapter 6: REPORT BUILDER REPORTS & GAUGE REPORTS
Report Builder Tool Installation & Real-time Use; Differences with Report Designer Tool, Limitations;
Data Source 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; Query Designer Options with Report Builder, Table Selection; Column Aggregates and Auto
Group BY. Query Edit Options; Adhoc Reports with Drill-down and Column Groups; Dynamic Row Colors
and Report Expression Options; Gauge Reports: Purpose, End User Access; Report Types - Radial and
SQL School Training Institute. #101, 1st Floor, UMA Residency, Road #1, SR Nagar, Hyderabad - 38.
Trainings are completely practical. real-time. www.sqlschool.com For Free Demo: 9666 44 0801 (24 x 7)
Linear Gauges; Adding Data to Gauge Report – Indicators; Gauge Data Versus Chart Data – Pointers;
Maximum, Minimum Scale Range Values; Browser Compatibility and Offline Reports; Gauge, Gauge
Panel Properties and Filters; Scale - Properties, Values, Label Options; Pointers, Scale Limits and Format
Options; Ranges and Labels, Items, Needle Options; Adding Multiple Gauges - Dashboard Design;
Parameterized Gauge Reports and Datasets;

Chapter 7: REPORT BUILDER REPORTS & MAP REPORTS

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; Data Fields,
Display Labels and 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 Sources, Cautions; Report Deployment of Shared Datasets and Reports; Report Manager
Uploads for RDL Files, Verification;
Chapter 8: REPORT MANAGEMENT
Data Source Management Options, 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 Item Operations: Edits in Report Builder; Report Downloads & Uploads,
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;

Chapter 9: MOBILE, KPI, CUBE REPORTS

Mobile Reports : Creation & Usage; Excel and Report Server Sources; Working with Mobile Report
Publisher; Report Elements and Design Option; Layout: Master, Tablet and Phone; Grids and Color
Palette. Deployment; RSMobile Formats: Uploads, Downloads; KPI Reports: Design from Web Portal;
Shared Dataset in Report Builder Tool; KPI: Value, Goal, Status, Trend; KPI Visuals: Bar, Line, Step, Area;
KPI Report Uploads to Webportal; KPI Link to Custom URL, Mobile Reports; KPI Reports : Real-time
Limitations; SSRS Reports with SSAS OLAP Cubes; SSRS Cube Reports with MDX Queries; SSRS Cube
Reports with DAX Queries; SSRS Cube Reports with Parameters; MDX Default Parameters and Options;
MSBI SSAS OLAP Cube Actions with SSRS;
Chapter 10: SSRS Project Work For Resume, Job Work

Module 3: Power BI (Reports, Cloud, Server)

{For SSRS Plan B, C}

Chapter 1 : POWER BI BASICS

SQL School Training Institute. #101, 1st Floor, UMA Residency, Road #1, SR Nagar, Hyderabad - 38.
Trainings are completely practical. real-time. www.sqlschool.com For Free Demo: 9666 44 0801 (24 x 7)
Power BI Job Roles in Real-time; Power BI Data Analyst Job Roles; Business Analyst - Job Roles; Power BI
Developer - Job Roles; Power BI for Data Scientists Comparing MSBI and Power BI; Comparing Tableau
and Power BI; MCSA 70-778, MCSA 70-779 Exam; Types of Reports in Real-World; Interactive &
Paginated Reports; Analytical & Mobile Reports; Data Sources Types in Power BI; Licensing Plans; Power
BI Training : Lab Plan; Power BI Dev, Prod Environments;

Chapter 2 : BASIC REPORT DESIGN

Power BI Desktop Installation; Data Sources & Visual Types; Canvas, Visualizations and Fields; Get Data
and Memory Tables; In-Memory xvelocity Database; Table and Tree Map Visuals; Format Button and
Data Labels; Legend, Category and Grid; PBIX and PBIT File Formats; Visual Interaction, Data Points;
Disabling Visual Interactions; Edit Interactions - Format Options; SPOTLIGHT & FOCUSMODE; CSV and
PDF Exports. Tooltips; Power BI EcoSystem, Architecture;

Chapter 3 : VISUAL SYNC, GROUPING

Slicer Visual : Real-time Usage; Orientation, Selection Properties; Single & Multi Select, CTRL Options;
Slicer : Number, Text and Date Data; Slicer List and Slicer Dropdowns; Visual Sync Limitations; Disabling
Slicers; Grouping : Real-time Use, Examples; List Grouping and Binning Options; Grouping Static / Fixed
Data Values; Grouping Dynamic / Changing Data; Bin Size and Bin Limits (Max, Min); Bin Count and
Grouping Options; Grouping Binned Data, Classification;

Chapter 4 : HIERARCHIES, FILTERS

Creating Hierarchies in Power BI; Independent Drill-Down Options; Dependant Drill-Down Options;
Conditional Drilldowns, Data Points; Drill Up Buttons and Operations; Expand & Show Next Level
Options; Dynamic Data Drills Limitations; Show Data and See Records; Filters : Types and Usage in Real-
time; Visual Filter, Page Filter, Report Filter; Basic, Advanced and TOP N Filters; Category and Summary
Level Filters; DrillThru Filters, Drill Thru Reports; Keep All Filters" Options in DrillThru; CrossReport
Filters, Include, Exclude;

Chapter 5 : BOOKMARKS, AZURE, MODELING

Drill-thru Filters, Page Navigations; Bookmarks : Real-time Usage; Bookmarks for Visual Filters;
Bookmarks for Page Navigations; Selection Pane with Bookmarks; Buttons, Images with Actions;
Buttons, Actions and Text URLs; Bookmarks View & Selection Pane; OLTP Databases, Big Data Sources;
Azure Database Access, Reports; Import &Direct Query with Power BI; Enter Data; Data Modeling :
Currency, Relations; Summary, Format, Synonyms; Web & Mobile View in PBI;

Chapter 6 : VISUALIZATION PROPERTIES

Stacked Charts and Clustered Charts; Line Charts, Area Charts, Bar Charts; 100% Stacked Bar and
Column Charts; Map Visuals: Tree, Filled, Bubble; Cards, Funnel, Table, Matrix; Scatter Chart : Play Axis,
Labels; Series Clusters; Waterfall Chart; ArcGIS Maps; Infographics; Color Saturation, Sentiment Colors;
Column Series, Column Axis in Lines; Join Types : Round, Bevel, Miter; Shapes, Markers, Axis, Plot Area;
Data Colors; Series, Custom Series and Legends;

Chapter 7 : POWER QUERY LEVEL 1

SQL School Training Institute. #101, 1st Floor, UMA Residency, Road #1, SR Nagar, Hyderabad - 38.
Trainings are completely practical. real-time. www.sqlschool.com For Free Demo: 9666 44 0801 (24 x 7)
Power Query Architecture and M Language; Data Types, Literals and Values; Power Query
Transformation Types; Table & Column; Text & Number Transformations; Date, Time and Structured
Data; List, Record & Table; let, source, in statements @ M Lang; Power Query Functions, Parameters;
Invoke Functions; Get Data, Table Creations, Edit; Merge and Append Transformations; Join Kinds,
Advanced Editor, Apply; ETL Operations with Power Query;

Chapter 8 : POWER QUERY LEVEL 2

Query Duplicate, Query Reference; Group By and Advanced Options; Aggregations with Power Query;
Transpose, Header Row Promotion; Reverse Rows and Row Count; Data Type Changes & Detection;
Replace Columns: Text, NonText; Replace Nulls: Fill Up, Fill Down; PIVOT, UNPIVOT; Move Column and
Split Column; Extract, Format; Date & Time Transformations; Deriving Year, Quarter, Month, Chapter;
Add Column : Query Expressions; Query Step Inserts and Step Edits;

Chapter 9 : POWER QUERY LEVEL 3

Creating Parameters in Power Query; Parameter Data Types, Default Lists; Static/Dynamic Lists For
Parameters; Removing Columns and Duplicates; Convert Tables to List Queries; Linking Parameters to
Queries; Parameters and PBI Canvas; Multi-Valued Parameter Lists; Creating Lists in Power Query;
Converting Lists to Table Data; Advanced Edits and Parameters; Data Type Conversions, Expressions;
Columns From Examples, Indexes; Conditional Columns, Expressions;

Chapter 10 : DAX Functions - Level 1

DAX : Importance in Real-time; Real-world usage of Excel, DAX; DAX Architecture, Entity Sets; DAX Data
Types, Syntax Rules; DAX Measures and Calculations; ROW Context and Filter Context; DAX Operators,
Special Characters; DAX Functions, Types in Real-time; Vertipaq Engine, DAX Cheat Sheet; Creating,
Using Measures with DAX; Creating, Columns with DAX; Quick Measures; SUM, AVERAGEX,
KEEPFILTERS; Dynamic Expressions, IF in DAX;

Chapter 11 : DAX Functions - Level 2

Data Modeling Options in DAX; Detecting Relations for DAX; Using Calculated Columns in DAX; Using
Aggregated Measures in DAX; Working with Facts & Measures; Modeling : Missing Relations; Modeling :
Relation Management; CALCULATE Function Conditions; CALCULATE & ALL Member Scope; RELATED &
COUNTROWS in DAX; Slicing; Dynamic Expressions, RETURN; Date, Time, Text Functions; Logical,
Mathematical Functions; Running Total, EARLIER Function;

Chapter 12 : DAX FUNCTIONS - Level 3

1:1, 1:M and M:1 Relations; Connection with CSV, MS Access; AVERAGEX and AVERAGE in DAX;
KEEPFILTERS and CALCUALTE; COUNTROWS, RELATED, DIVIDE; PARALLELPERIOD, DATEDADD;
CALCULATE & PREVIOUSMONTH; USERELATIONSHIP, DAX Variables; TOTALYTD , TOTALQTD; DIVIDE,
CALCULATE, Conditions; IF..ELSE..THEN Statement; SELECTEDVALUE, FORMAT; SUM, DATEDIFF
Examples; TOCHAPTER, DATE, CHAPTER with DAX; Time Intelligence Functions;

Chapter 13 : POWER BI CLOUD - 1

Power BI Service Architecture; Power BI Cloud Components, Use; App Workspaces, Report Publish
Related Datasets Cloud; Creating New Reports in Cloud; Report Publish and Report Uploads;
Dashboards Creation and Usage; Adding Tiles to Dashboards; Pining Visuals and Report Pages; Visual
SQL School Training Institute. #101, 1st Floor, UMA Residency, Road #1, SR Nagar, Hyderabad - 38.
Trainings are completely practical. real-time. www.sqlschool.com For Free Demo: 9666 44 0801 (24 x 7)
Pin Actions in Dashboards; LIVE Interaction in Dashboard; Adding Images, Custom Links; Videos &
Embed Links; API Data Sources; Streaming Dataset Tiles (REST API);

Chapter 14 : POWER BI CLOUD - 2

Dashboards Actions, Report Actions; DataSet Actions: Create Report; Share, Metrics and Exports;
Mobile View & Dashboard Themes; Q & A [Cortana], Pin Visuals; Export, Subscribe, Subscribe;
Favourite, Insights, Embed Code; Featured Dashboards and Refresh; Gateways Configuration, PBI
Service; Gateway Types; Gateway Clusters, Data Refresh : Manual, Automatic; PBIEngw Service;
DataFlows, Power Query Expressions; Adding Entities, JSON Files;

Chapter 15 : EXCEL, ROW LEVEL SECURITY

Import and Upload Options in Excel; Excel Workbooks and Dashboards; Datasets in Excel and
Dashboards; Using Excel Analyzer in Power BI; Using Excel Publisher in PBI Cloud; Excel Workbooks,
PINS in Power BI; Excel ODC Connections, Power Pivot; Row Level Security (RLS) with DAX; Need for RLS
in Power BI Cloud; Data Modelling; DAX Roles Creation and Testing; Power BI Users to Roles; Custom
Visualizations; Histogram, Gantt Chart, Info graphics;

Chapter 16: REPORT SERVER, REPORT BUILDER

Need for Report Server in PROD; Install, Configure Report Server; Report Server DB, Temp Database;
Webservice URL, Webportal URL; Creating Hybrid Cloud with Power BI; Using Power BI DesktopRS;
Uploading Interactive Reports; Report Builder; Report Builder For Power BI Cloud; Designing Paginated
Reports (RDL); Deploy to Power BI Report Server; Data Source Connections, Report; Power BI Report
Server to Cloud; Tenant IDs; Mobile Report Publisher;

Chapter 17 : MSBI INTEGRATIONS WITH POWER BI

Power BI with SQL Server Source; Power BI with SQL Data Warehouse; Power BI with SSAS OLAP Server;
Power BI with Azure SQL DB Source; Power BI with Azure SQL Warehouse; Power BI with Azure Analysis
Server; Power BI with SSRS (RDL) Reports; Power BI Report Builder Tool; Paginated Reports Design, Use;
Data Sources, Datasets, RDL; Report Publish (RDL) to Cloud; Report Verifications; Interactive Vs
Paginated Reports; Configuring & Managing Alerts in Cloud;

Chapter 18: Real-time Project [Sales & Customers]

Resume, Project Oriented FAQs and Solutions

SQL School Training Institute. #101, 1st Floor, UMA Residency, Road #1, SR Nagar, Hyderabad - 38.
Trainings are completely practical. real-time. www.sqlschool.com For Free Demo: 9666 44 0801 (24 x 7)