Tableau 10 Certification Course

Course Content for Tableau Certification and Jobs

1) Introduction
ï‚· Business Intelligence Introduction
ï‚· Gartner Architecture
ï‚· Components Overview

2) Getting Started
ï‚· Getting Started
ï‚· The Tableau Interface
ï‚· Connection, Data Source, Visualization Area
ï‚· Joins & Cardinalities

3) Connecting to Data
ï‚· Getting Started with Data
ï‚· Connecting to Databases and Advanced Features
ï‚· Data Prep with Text and Excel Files
ï‚· Splitting & Custom Splitting
ï‚· Pivot & Data Cleansing
ï‚· Editing Data Connections and Data Sources
ï‚· Editing Metadata and Saving Data Sources
ï‚· Using and Refreshing Extracts
ï‚· Join Types
ï‚· Cardinalities
ï‚· Difference Between Live & Extract
ï‚· Data Blending

4) Visual Analytics
ï‚· Getting Started with Visual Analytics
ï‚· Dimension
ï‚· Measures
ï‚· Drill Down and Hierarchies
ï‚· Sorting
ï‚· Grouping
ï‚· Creating Sets
ï‚· Ways to Filter
ï‚· Using the Filter Shelf
ï‚· Quick Filters
ï‚· General
ï‚· Wildcard
ï‚· Condition
ï‚· Filtering for Top and Top N
ï‚· Parameters
ï‚· Color
ï‚· Size
ï‚· Detail
ï‚· Tool Tip
ï‚· Label
ï‚· Trend Lines
ï‚· Reference Lines
ï‚· Forecasting

5) Mapping
ï‚· Getting Started with Mapping
ï‚· Maps in Tableau
ï‚· Using Latitude & Longitude
ï‚· Editing Unrecognized Locations

6) Calculations
ï‚· Getting Started with Calculations
ï‚· Calculation Syntax
ï‚· Aggregate Calculations
ï‚· Date Calculations
ï‚· Logic Calculations
ï‚· Number Calculations
ï‚· String Calculations

7) Dashboards and Stories
ï‚· Getting Started with Dashboards and Stories
ï‚· Building a Dashboard
ï‚· Dashboard Layouts and Formatting
ï‚· Dashboard Interactivity using Actions
ï‚· Highlight Action
ï‚· URL Action
ï‚· Filter Action
ï‚· Dashboard Best Practices

ï‚· Story Points

8) Different Type Of Charts
ï‚· Column Chart
ï‚· Bar Chart
ï‚· Pie Chart
ï‚· Scatter Plot
ï‚· Bubble Chart
ï‚· Stacked Bars
ï‚· Tree Maps
ï‚· Heat Maps
ï‚· Line Charts
ï‚· Area maps

9) Tableau Online

10) Publish Dashboard Contents

Real-Time Scenarios / Tableau Marathon


Power BI Course Content

Lesson 1 – Business Intelligence & Data Science Introduction
What is Business Intelligence?
The flow of Business Intelligence
Components of Business Intelligence

Lesson 2 – Power BI – First Step
Gartner Architecture
Why Power BI?
Gartner Magic Quadrant Review
Power BI History – When, Where & Why
Installing Power BI Desktop
Signing up for Power BI Service

Lesson 3 – Introduction to Different Interfaces

Getting Started with Power BI
The Power BI Interface
Report Panel
Data Panel
Model Panel
Your first Power BI Visualization

Lesson 4 – Transforming Data Using Power BI Desktop
Introduction to Power BI Desktop

Connecting to Data
Getting Started with Data
Connecting to Databases and Advanced Features
Analyzing the Project Data Warehouse
Changing Locale
Connecting to a Database
Basic Transformations
Managing Query Groups
Splitting Columns
Changing Data Types
Working with Dates
Removing and Reordering Columns
Conditional Columns
Connecting to Files in a Folder
Merge Queries
Query Dependency View
Transforming Less Structured Data
Enter Data
Query Parameters
Data Prep with Excel Files
Data Cleansing
Editing Data Connections and Data Sources
Editing Metadata and Saving Data Sources
Data Blending

Lesson 5 – Power BI – Visualizing Your Data
Pie and Treemap
Hierarchical Axis and Concatenating

Filter (Including TopN)
Bar Chart with Line
Analytics Pane
Focus Mode and See Data
Date Slicer
Map and Filled Map
Table and Matrix
Table Styles
Scatter Chart
Gauge, Card, and KPI
Coloring Charts
Shapes, Textboxes, and Images

Lesson 6 – Visual Analytics – Working With Multiple Visualization
Page Layout and Formatting
Visual Relationship
Duplicate Page
Categories with No Data
Default Summarization and Categorization
Positioning, Aligning, and Sorting Visuals
Custom Hierarchies
Trend Lines

Lesson 7 – Playing With DAX

Introduction to DAX
DAX calculation types
DAX functions
Using variables in DAX expressions
Table relationships and DAX
DAX tables and filtering

Lesson 8 – Working with Power BI Service – Dashboard
Overview of Dashboards and Service
Uploading to Power BI Service
Quick Insights
Configuring a Dashboard
Adding Textbox, Image Widgets
Featured and Favorite Dashboard
Filtering Dashboard
Dashboard Settings
Featured Questions
Sharing a Dashboard
In-Focus Mode
Pinning a Live Page
Custom URL and Title
TV Mode and Collapse Navigation
Printing Dashboard and Exporting Data
Export to CSV and Excel
Publishing to Web

Lesson 9 – Viewing Power BI Dashboard
Viewing in Windows App / Android App / iPad / iPhone

Lesson 10 – Mobile App – Power BI
Report Gallery and Search
Mobile Dashboard Layout
Sharing and Annotating in Power BI Mobile
Platform-Specific Features
Search and Recent

Lesson 11 – Publishing & Projects
Publishing Contents
Interview Tips

Lesson 12 – Final Conclusion – Wrap Up
Submitting Interview Questions
Interview Tips
IT Companies Project Flow
Agile/Scrum & Waterfall


SAS Certified Platform Administrator Certification in India

SAS A00-250 Exam Summary:
Exam Name SAS Certified Platform Administrator for SAS 9
Exam Code A00-250
Exam Duration 3hrs
Exam Questions 70 multiple-choice and short-answer questions
Passing Score 70%
Exam Price $180 (USD)
Training Getting Started with the Platform for SAS Business
SAS Platform Administration: Fast Track SAS Platform
Administration: Metadata Administration SAS Platform
Administration: System Administration
Exam Registration Pearson VUE
Sample Questions SAS Platform Administrator Certification Sample Question
Practice Exam SAS Platform Administrator Certification Practice Exam
SAS A00-250 Exam Topics:
Objective Details
Securing the SAS configuration – Regularly manage and apply hot fixes. – Apply SAS maintenance packs. – Perform SAS license updates
Monitoring the Status and Operation of SAS Metadata Servers – Explain the functionality of the object spawner.
– Use the Server Manager plug-in to monitor SAS servers.
– Use Environment Manager to evaluate the resources available on the SAS servers.
Monitoring, Logging, and Troubleshooting SAS Servers – Change logging levels and locate logs.
– Enable trace logging.
– Explain the difference between default logging and customized logging.
– Utilize dynamic logging.
Backing Up the SAS Environment – View backup and recovery history.
– Run an immediate (ad hoc) backup.
– Customize backups.
– View information about backup and recovery sources.
Administering Users Determine when to store passwords in the metadata.

Manage internal SAS accounts.

Identify SAS server authentication mechanisms.

Administering Data Access Pre-assign a library.

Troubleshoot data access problems.

Use the metadata LIBNAME engine

Managing Metadata – Use the metadata folder structure to manage access to metadata.

Create and use Access Control Templates.

SAS Platform Administrator Course Content, Material and Course Online Training and  Videos Details are available Click here


AWS Online Training, Placement and Job Support

AWS Amazon Web Services (Solution Architect & Sys Ops Administration)

Basics on AWS DevOps Associate.

The Cloud Computing Training content is developed with the goal of equipping trainees with the skills needed for taking up the coolest job for the next generation. The Training introduces you to the Amazon Cloud and the skills required to work on AWS Amazon infra management on various stages to achieve meaningful insights. Realizing the applications and statistical concepts and building Cloud Architects in the AWS Amazon Cloud field using the Aws Amazon tools is at the heart of the course content. The required tools and techniques for asking the right kind of questions to make inferences and predicting future outcomes are discussed during the course of the training. All along with the training, we will be using the real world and real-time scenarios wherever applicable to give you the comfort in taking up the Cloud Computing job and start performing from day one!

Below are the objectives of AWS Amazon Cloud training:

  1. Get hands-on with the AWS Amazon Management Console environment and Resource Managing
  2. Understanding the Services available in AWS Amazon Console.
  3. Hands-on with AWS resource like EC2, ELB, Auto Scaling, IAM’s, AMI’s, RDS, Cloud Watch, Cloud Front, Route 53, S3, VPC, VPN, SNS, SES, Cloud Formation, Lambda, System Managers, etc.,
  4. Various techniques for AWS Design and Configure the infra using the AWS Amazon management console.
  5. Apply customer views to build the AWS Amazon Infra services for productivity.

This course will cover the following concepts on each day

  • System Operations on AWS Overview
  • Networking in the Cloud
  • Computing in the Cloud
  • Storage and Archiving in the Cloud
  • Monitoring in the Cloud
  • Managing Resource Consumption in the Cloud
  • Configuration Management in the Cloud
  • Creating Scalable Deployments in the Cloud
  • Creating Automated and Repeatable Deployments

Who can undergo Cloud Computing Training?

Every industry is seeking Migrating to Cloud infra for getting an edge over competition in the market. Given the dearth of skilled cloud engineers, there is an enormous opportunity for professionals at all levels in this area.

  1. IT professionals looking to start or Switch career in Cloud Computing.
  2. Professionals working in the field of System and Network Administrator & Graduates planning to build a career in Cloud computing.

Pre-requisites for the Course?

  1. The ideal pre-requisites for this class are prepared individuals who have:
  2. Strong interest in Cloud computing
  3. Background in introductory level of basic concepts of Systems Administration
  4. Background in either software development or systems administration
  5. Inquisitiveness & good communication skills to be a successful Cloud Computing Engineer.
  6. Some experience with maintaining operating systems at the command line (shell scripting in Linux environments, cmd or PowerShell in Windows)

Course Curriculum:

Session 1:  1. Introduction on Linux and Windows

  • Introduction to Unix and Windows, Installation of Linux and Windows
  • User, Group Administration,
  • Disk Partitions
  • Mounting File Systems
  • Backup and Recovery
  1. Introduction to Cloud Computing and AWS Amazon.

Learning Objectives – You will be introduced to the Cloud Computing field and various pre-requisites to succeed as AWS Cloud Engineer. This session gives you the taste of real-world uses cases of AWS Amazon. You will be introduced to the AWS Amazon Console and Managing, which is the basis for the entire training structure. Also, the Cloud environment setup and basic structure will be discussed.

Introduction to Cloud Computing (1 Hour): What is Cloud Computing, Cloud Computing – and why it is the coolest job of next-generation, Cloud Computing skills, Use cases,

Introduction to Aws Amazon Cloud: Getting started with Amazon Web Services (AWS)

  • Creating accounts and analyzing the cost breakdown
  • Evaluating Service Level Agreements (SLA)
  • Console, command-line tools and API

Overview of the architecture

EC2 Glacier
Auto Scaling Route53
IAM’s Trust Advisor
RDS Cloud Formation
VPC System Manager
Cloud Front Cloud Trail
Cloud Watch Lambda
Lucid Charts Tool
DevOps Tools like Code Deploy, Jenkins, Git, etc.,
  1. AWS Amazon EC2:

Learning Objectives – This session deep dives into various AWS Amazon services – EC2 types and their usages. The EC2 overview and types such as Windows, Linux, and Other different types. Various other important commands such as generating sequences and repeats which are vital parts of data analysis will also be discussed.

Topics – Managing the EC2 Infrastructure, EC2 Pricing, AMI’s, Snapshots, EBS, Create and Manage EBS, EC2 AMI’s, Security Groups, Elastic Load Balancers, Auto Scaling, Launch configurations.

Provisioning resources:

Create an instance and custom AMI. Connecting to Instance and Modify all settings. Create and Add Elastic Block Store (EBS) and instance store root devices Assigning elastic IP addresses  Mapping instance types to computing needs, Persisting off–instance storage with EBS volumes  Creating backups with snapshots

  1. AWS Amazon RDS:

Learning Objectives – The biggest challenge in RDS while working with massive databases involves various sources. These RDS might be in a variety of formats likes MS SQL, MySQL, Oracle, PostgreSQL. This session targets to understand how to create RDS using AWS which might be available in varied formats for creating RDS. You will be introduced to types of RDS and its sources. These RDS will be used for our case studies throughout the training.

Topics – Relation Databases(RDS) Overview, Multi-AZ & Read Replicas, Types of RDS, Creating Database, Creating Read Replicas, Managing Master, and Read Replicas, RDS Failover, Security Groups, Parameter Groups, Managing and accessing RDS using Open Source Tools, Create Backups and Snapshots.

  1. Storage Services: S3 & Glacier

Learning Objectives – We will work on S3 for data uploads like images, pdfs, and videos. We will also work on storing all the logs and managing data logs in S3. The objective of this session is to prepare you to handle such real-world challenges that come at your doorstep along with the data that was acquired. This session focusses on various tools and techniques in S3 for uploading the data into buckets and content for further data.

Topics – S3 Overview, create an S3 Bucket, create an S3 Bucket, S3 Version Control, S3 Life Cycle Management & Glacier, S3 Security and Encryption, Storage Gateway, Import-Export, S3 Transfer Acceleration, Creating and Managing S3 Buckets, Uploading Data to S3, Security settings for S3, Managing Logs in S3, Managing Archiving to Glacier.

Achieving high durability with Simple Storage Service  Transmitting data in/out of the Amazon cloud

  1. VPC Learning Objectives – At the core, VPC is Firewall in AWS Amazon. It provides very powerful security to handle other services in a simple way. This session starts with providing techniques for handling VPC such as creating subnets, VPN’s, and then it exposes you to various infra required for performing descriptive and inferential in the cloud.

Topics – VPC Overview, Types of VPC’s, Creating VPC, Subnets, Route tables, Read Replicas, Security Groups, Parameter Groups, Managing and accessing RDS using Open Source Tools, Create Backups and Snapshots   Session

  1. Cloud Front and Cloud Watch and Cloud Formation

Learning Objectives – Data visualization is an essential part of content delivery during the data exploration and data delivery and communication of inferences from the study. You will be made to understand the content delivery capabilities using Cloud Front and its flexible to the development environment. You will learn to generate CDN for delivering the application at the end or edge locations.

Topics – Create A Cloud Watch Role, Monitoring EC2 with Custom Metrics, Monitoring EBS, Monitoring RDS, Monitoring ELB, Monitoring, Centralizing Monitoring Servers, Consolidated Billing, Billing and Alerts, Monitoring and Metrics Quiz

  1. Route 53

Learning Objectives – Route 53 is Domain Registration, Domain Management, and Health Check of Domains. This session provides you knowledge on Domain registration and Domain Management. You will learn how to create or manage the Hosting of Domains during this session.

Topics – Route 53 Overview, Types of DNS Records, Understanding the DNS Records, Creating Hosted Zones, Managing Hosted Zones.

  1. IAM’s – Identity and Access Management

Learning Objectives – This IAM’s is user management. You will learn how to create or manage users, groups, roles, and policies during this session

Topics – IAM’s Overview, Understanding the IAM’s, creating users, groups, roles and policies, Managing Access Keys and Secret Keys, Authentication.

  1. Trust Advisor.

Learning Objectives – With the increase of servers or services in the cloud, the data generated has increased many folds, bringing in the huge scope for gaining insights into the untapped security of cloud services and its data. This Session helps you learn various techniques to optimize cloud resources and cost.

Topics – Trust Advisor Overview, Fundamental of Trust Advisor, Cost Optimization,

  1. Real-Time Scenarios and Q&A

Learning Objectives – This session gives an overview of the various cloud environments and learning tools to manage cloud infra. Also, this session gives a brief overview of the AWS architect and sysops, which is very useful to deploy an environment.

Topics – Real-time scenarios, Real-Time Architect, how to identify the resource in AWS cloud to manage an application. Last Q&A

Advanced Successfactors EC Payroll Online Training

What is CRM in Salesforce? |

What is CRM in Salesforce?

CRM stands for Customer Relationship Management and it is software that stores various types of customer information like name, address, the phone number to keep track of customer activates like the websites they visit, phone calls, emails, and other essential activities. It is the ultimate solution to bring customers and companies together. CRM provides a platform to all kind of departments like marketing, sales, commerce, and even services; it is one integrated platform which allows every single customer to share their point of view. CRM is an on-demand Salesforce cloud that offers applications for all types of organizations like small, mid-size and even enterprise organizations. They mainly focus on the efficient work of the sales and services. This software also helps the businesses to create strong relationships with the customers by boasting the conversations, improving revenue rates on customer data.

What is Salesforce Integration?

If you want something for a little design of each individual app inside Salesforce, then user interference Integration is a great solution. It provides the single point of entry of the user into multiple applications, which have no such coding requirement in Salesforce. It is an advantage as it provides easy use. The integration provides features to different layers of an enterprise. The different types of integration are

  • User Interference Integration is used for accessing multiple applications from a single entry, Facebook is an example of these.
  • Business Logic Integration allows extending the business logic which is present in outside platform, the inbound logic integration is handled by Apex Web Services. They allow writing logic and to expose web service is external applications.
  • Data Integration maintains the consistency between the application data and multiple systems which are needed to be in Synchronizations of the data. They can be synced between the systems by using SOAP APIs and other different applications.

How does Salesforce work on mobile?

The use of Salesforce can be done just by downloading it from the App Store or Google play store. They have no setup required as it works out of the box. This app acts as a container which can have a set of name, logo even an order set of tabs and so on which helps visually to group things together. Mobile is an important part of our daily life, people spends a lot of time on mobile phones and thus introducing the enterprise to the people through the app can be a huge success. Even in the case of big enterprise, people want easy access to the business tools on mobile phones. These apps provide access to the company’s CRM data from any phone or tablet instantly. The apps include every Salesforce license, cross-platform, offline services, provides a good experience as well as a Salesforce platform to the customers as these apps are customizable.


Salesforce Online Training for Beginners

What is Apex in Salesforce?

The software companies that provide cloud computing services, which look after customer relationship management is known as Salesforce and Apex is a type of programming language which is strongly typed and is object-oriented. Apex executes the flow and transaction on the Salesforce server acting as controlling statements.  They usually look like Java but acts like database stored procedures and allows most system events to add logic to the business including record updates, button clicks, and visual force pages. Apex Code can be initiated from triggers on an object by Web Service requests.

The advantages of Apex as a language are,

  • They are very easy to use as the apex is usually based on familiar Java idioms, syntax, array notification, etc. The Lightroom Platform is made easy with the introduction of new elements of Apex.
  • They are data-focused as they are designed to thread together the bunch of DMLs, quarries into a single unit of work to help in the Salesforce Servers.
  • They are rigors as well as multitenant aware and are easy to test.

What is security in Salesforce?

The Salesforce usually has a security feature that helps and empowers the users for efficient and secure work by limiting the exposure of the data to the users who are able to act on it. The sensitive data of the user are fully safe by implementing these security measures. The authorized data are protected from inappropriate usage and illegal access. There are various threads that can harm the security of the data like Malware, Fishing, etc.

Malware and Fishing can give a serious threat to the insensitive data. Salesforce provides ultimate security from suspicious threads and even loss of important data.

They protect the users from downloading any malicious link by alerting them whenever they click any link that takes them outside the Salesforce domain.

Salesforce provides the most advance technology for internet security which is available. They also provide health checks to provide ultimate protection, they also provide auditing and Salesforce shield to develop the ultimate trust and guarantee to the customer.


SAP BI Online Training India | Course Objectives

Course Objectives;

  • Describe the architecture of SAP NetWeaver and BI/BW 7.3 and explain their advantages.
  • Manage metadata.
  • Define various BI objects, Info Objects, Data Sources, Info Cubes, Data Store objects and so on.
  • Describe the different ETL flows.
  • Create and use data transformations and Data Transfer processes to load and transform data from flat files and from SAP Systems.
  • Define Info providers and when they should be used in your BI implementation.
  • Schedule and monitor data loading processes with BI
  • Activate BI Content in BI.
  • Use Aggregates to improve query performance.
  • Understand BI IP (Integrated Planning) at a High Level.

Course Introduction

Ground Rules

  • Participate – Ask Questions
  • Learn from Everyone’s Comments
  • Please turn off cellular phones
  • Honour time schedule
  • Relax and Have Fun
  • Introduce Yourself
  • Name, Operating Group, Location
  • Your SAP BI Bootcamp objective(s)

Reference Material

  • Key Fields in SAP Tables
  • List of codes of be used in BI Key fields in SAP tables
  • SAP BI Bootcamp Transaction Codes
  • List of Transaction Codes used in BI

SAP SF Compensation Certification Questions


1 Question Which of the following options reflects a best practice for configuring compensation plan guidelines?
Answer Please choose the correct answer.
2 Question You have created a route map and have entered information for all options in each step. You have also configured To Dos for the Home Page.
Question Which field appears in the planner’s To Do List on the Home Page when the worksheet is in their inbox?
Answer Step Name
3 Question Which of the following can a user do to export all of the compensation data from SuccessFactors to another system?
Answer Select the Aggregate Export option from Compensation Home.
Answer Create a Compensation Planning ad hoc report.
4 Question Which actions can you control using role-based permissions?
Answer Read and write compensation data via executive review.
Answer View budget rollup information.
Answer Change eligibility rules in a compensation plan template.
5 Question You have defined the eligibility rules as shown in the attached screenshot. Budgeting is done as a percent of the current salary.
Question What can you see on the compensation form for an employee in Salary Plan PRM? C_THR86_1605 dumps, C_THR86_1605 questions
The employee appears on the form and is included in the total budget basis but CANNOT receive an award amount in merit, adjustment or lump sum.
6 Question Your customer needs a budget that calculates a percentage of imported values for each employee on the compensation worksheet.
Question Which Based On option can you use to fulfill this requirement?
Answer User
7 Question Your client notices that data on compensation worksheets is incorrect. The attached screenshot shows the user data file (UDF) that was
Question uploaded. Which columns cause this problem?
8 Question Your customer has different compensation plan templates for stock and compensation. This customer therefore wants to use
Question one combined compensation statement. What can you use to achieve this?
Answer The Secondary Plan option
9 Question You want to export user compensation data from your customer’s SuccessFactors system. Which option in the Employee Data
Question Export tool prevents any user compensation data from being downloaded?
Answer Short format: only system fields
10 Question You want to display the percentage of employees in each pay grade who are eligible to receive a stock grant.
Question Which of the following activities must you perform to do this?
Answer Upload a stock participation guideline table CSV file in the Admin Tools.


Register today to attend free Demo sessionClick Here for More Details 


Microsoft Azure 8.1 Certification Online Training

What is Virtual Machine in Azure ?

Azure windows virtual machine (VM) generally uses windows server to support on high level, secure & on-demand virtualized infrastructure. Virtual Machines are typically used to gain control over small or multi-tier applications running on another rack in your datacentres. This tutorial will help you understand how to create, manage and deploy virtual machines in Azure. Azure virtual machines can be created through azure portal and this process also assists in providing a browser based interface for understanding, creating and deploying virtual machines.

Let us now understand the creation of Azure virtual machine:

  • Start by logging into the azure portal and then by clicking on new project and selecting compute, windows 2017 data server can be opened where virtual machine information can be created.
  • Then, on entering the portal, the sizes of VM can be selected here and also the disk type filters can be changed. Once done, by not changing the defaults (will be there in settings) and clicking OK on the summary page will deploy the virtual machine. Once the deployment is done, VM will be pinned to the dashboard of Azure portal, so it opens automatically.

Understand more about the Virtual Machine in Azure, here.