SQL Srinivas
Expert in SQl Server/MSBI(SSIS/SSAS/SSRS) and Power BI,Leading online/Corporate Trainer
Wednesday, November 23, 2016
Sunday, June 5, 2016
Tuesday, February 9, 2016
Sunday, January 24, 2016
Friday, December 25, 2015
Thursday, November 5, 2015
New MSBI SSRS Batch on 14th Nov
Hi,
I am very happy to announce new MSBI SSRS batch is going to start on 14th NOV.
Course will be of 5 days ,each day 3 hours.Within 5 days resource will become expert on SSRS reporting.
For more details Observe the same space here.
Thanks
Sri
I am very happy to announce new MSBI SSRS batch is going to start on 14th NOV.
Course will be of 5 days ,each day 3 hours.Within 5 days resource will become expert on SSRS reporting.
For more details Observe the same space here.
Thanks
Sri
Thursday, October 1, 2015
Tableau Desktop & Server Course Content
Day 1
Introduction- Tableau workspace and various options
- Tableau Structure
- Connect to Data
- Different Type of data source
- Tableau Repository
- Saving Your Work
- Tableau Files and File types
- Connecting to flat and local files
- Connecting to DB files
- Connecting to server
- Data Roles
- Data Types
- Converting measures to dimensions
- Tabular report
- Graphs
Day 2
Building Views
Create new report and graphAdding reference line
Viewing Specific Values
Formatting the graphs-Color and size
Sorting
Floating
ADMIN
- Creating Crosstabs
- Creating Highlight Tables
- Grand Totals, Sub-totals and Changing Aggregation
Formatting the graphs-Color and size
Day 3
Customizing your Data
- Working with Calculations
- Working with Logic statements
- Table Calculations
Simplifying and Sorting Your Data
Data Filtering
- Dimension
- Measures
Filter Types
- Traditional filters
- Custom Sql Filters
- Cascading Filters
- Context Filters
Sorting
Labels and its work
Day 4
Advanced Data Options
- Joins
- Join types
- Data Blending
- Renaming the connection
- Duplicating connection
- Close Connection
Slicing your Data by Date
- Working with Dates
- Using Discrete Date Parts
- Creating Date Filters
- Defining a Fiscal Year
Day 5
Dashboard
Dashboard containers- Horizontal
- Vertical
- Images
- WebPages
- Text
Floating
Day 6
Dashboard Actions- Actions
- Filter Actions
- Highlight Actions
- URL Actions
Day 7
Advanced Graph Options- Parameters
- How to create Parameter
- How to link calculation and parameters
- Filters with parameters
- Trend lines
- Shapes
- Annotations
Day 8
Advanced Data Options
Measure values and Measure names
Sharing Your Work
Sharing Your Work
- Export to an Image File
- Exporting the Data Only
- Other Sharing Options
Using Sets
Alias
Alias
- Bins
Day 9
Organizing your Data
- Using Groups
- Creating and Using Hierarchies
- Creating a Combined Field
Chart and Chart Types
- Type of charts
- Comparing Views with Multiple Measures
- Using Measure Values and Measure Names
- Multiple measures with line Charts
- Creating Dual Axis Charts
Day 10
Tableau Server configuration (single server and worker server)
- Server Installation
- Server configuration
- General
- Data Connections
- Alerts and Subscriptions
- SSL
- SAML
Day 11
Admin
- Admin Maintenance
- Creating Sites
- Creating Users
- Assign permissions
- Creating Groups
- Creating new Schedule
- Task
- Subscriptions
Day 12
Sharing your views and Datasource and security
- Publish Data Source to server
- Publish workbook to server
- Publishing dashboard with embedded
- Publishing data source with embedded
- User Filters and Row Level Security
Day 13
Tabcmd
- Tabcmd Installation
- Tabcmd examples
TabAdmin
- Server Backup
- Enabling the REST API
- Server Restore
- Server Cleanup
Email Scheduling
- Email Scheduling with Snapshot
- Automated Email Scheduling with Pdf attachment
- Export view as pdf and image
ADMIN
Wednesday, September 30, 2015
Tuesday, September 1, 2015
Java Script Course Content
JAVASCRIPT
Introduction to javascript
o Syntax
o Statements
o Comments
·
Enabling in various browsers
·
Popup Boxes
o Alert
o Confirm
o Prompt
·
Variables
·
Operators
o Arithmetic
o Assignment
o Comparison
o Logical
o Conditional
·
Conditional Statements
o if
o if...else
o if...else
if...else
o Switch
·
Loops
o while
o do...while
o for
o for...in
Statement
o Break
o Continue
·
Functions
o User-defined
Functions
§ Function
Syntax
§ Function
with Arguments
§ Returning
Values from Functions
§ Local
and Global Variables
o Built-in
Functions
§ paraseInt
and parseFloat
·
Events
o Introduction
o Mouse
Events
o Keyboard
Events
o Form
Events
o Document/Window
Events
·
Cookies
·
Page redirection
·
Page Printing
·
Built-in Objects
o Introduction
o Number
o Strings
o Math
o Arrays
§ Associative
§ Array
Properties and Methods
o Date
o Boolean
o Regexp
o HTML
DOM
·
Advanced javascript
o Error
handling
o Form
Validations
§ Basics
of Form Validation
§ Validating
Radio Buttons
§ Validating
Checkboxes
§ Validating
Select Menus
§ Validating
Textareas
o Debugging
o Browsers
Thanks
SQL Srinivas
91-9059361460
Subscribe to:
Posts (Atom)