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
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
Slicer
Focus Mode and See Data
Date Slicer
Map and Filled Map
Table and Matrix
Table Styles
Scatter Chart
Waterfall
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
Forecasting
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
– 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 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:
Get hands-on with the AWS Amazon Management Console environment and Resource Managing
Understanding the Services available in AWS Amazon Console.
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.,
Various techniques for AWS Design and Configure the infra using the AWS Amazon management console.
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.
IT professionals looking to start or Switch career in Cloud Computing.
Professionals working in the field of System and Network Administrator & Graduates planning to build a career in Cloud computing.
Pre-requisites for the Course?
The ideal pre-requisites for this class are prepared individuals who have:
Strong interest in Cloud computing
Background in introductory level of basic concepts of Systems Administration
Background in either software development or systems administration
Inquisitiveness & good communication skills to be a successful Cloud Computing Engineer.
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
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
EBS
S3
ELB’s
SNS
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.,
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
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.
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
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
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
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.
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.
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,
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
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.
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.
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.
