What you'll learn
Create and use Groups
Understand the difference between Groups and Sets
Create and use Static Sets
Create and use Dynamic Sets
Combine Sets into more Sets
Use Sets as filters
Create Sets via Formulas
Control Sets with Parameters
Control Reference Lines with Parameters
Use multiple fields in the colour property
Create highly interactive Dashboards
Develop an intrinsic understanding of how table calculations work
Use Quick Table calculations
Write your own Table calculations
Combine multiple layers of Table Calculations
Use Table Calculations as filters
Use trendlines to interrogate data
Perform Data Mining in Tableau
Create powerful storylines for presentation to Executives
Create powerful storylines for presentation to Executives
Understand Level Of Details
Implement Advanced Mapping Techniques
MIS Training – Advance Excel + Macro + Access + SQL
AÂ Management Information System (MIS) provides organizations with the information they …
What you'll learn
Advance Level Excel
Expertise in Using Text Function
Expertise in Using Logical Function
Expertise in Using Math Function
Expertise in Using Lookup & Reference Function
Expertise in Using Date and Time Function
Expertise in Using Pivot Table and Chart
Expertise in Power Pivot and Power Map
Expertise in Using What If Analysis Tools
Many Others Excel Tools
MS Access Knowledge on Table, Form, Queries and Reports
SQL Queries
Macro Recording
Excel VBA Object Handling with practical Project
Excel VBA Variable with practical Project
Excel VBA IF & Case with practical Project
3 Types of Loop with practical Project
Create your own Function
Events in VBA
FSO in Excel VBA
Userform in Excel VBA
Automate Pivot and Outlook in Macro
Many More Macro Topics and Projects
What you'll learn
This course is suitable for the SAS BASE certifications including SAS Certified Specialist and SAS Certified Associate (Exam ID A00-231, A00-233, A00-215)
All critical and essential SAS BASE Data manipulation and data preparation skills
Handle Error by identify and solve SAS errors
Combine, merge and restructure data sets
SAS Statistical Procedures
Reports generating
SAS advanced topic: Proc SQL Essentials
SAS advanced topic: SAS Macros Essentials
What you'll learn
Installing R and R Studio
Manipulating R Vectors, Arrays and Matrixes
Manipulating R Data Frames
Plotting Data Using R
Analyzing Real Datasets using R
Organizing your Code in R
Develop your own Functions in R
Summarizing Data with R
Load Excel Files with R
Compute Basic Statistics about a Dataset
Install External Libraries to Power up R
Aggregate and Sort Data
Subset Data
Power BI Course
In this course, you’ll be playing the role of Lead Business Intelligence …
What you'll learn
Build professional-quality business intelligence reports from the ground up
Blend and transform raw data into beautiful interactive dashboards
Design and implement the same B.I. tools used by professional analysts and data scientists
Showcase your skills with two full-scale course projects (with step-by-step solutions)
Understand the business intelligence workflow from end-to-end
Learn from a best-selling instructor and professional BI developer
Excel VBA Macros Course
Excel VBA programming can seem baffling, especially when you don’t fully …
What you'll learn
By the end of this course, you will be confidently writing VBA macros which automate procedures in Microsoft Excel.
You will fully understand the purpose and syntax of each line of code that you write.
You will not simply be entering lines of code because you have been told they will produce a certain result.
You will gain a solid understanding of both the VBA and Excel object models which underly VBA programming.
QTP Software Testing
Course Overview QTP Software Testing Course is designed in a …
What you'll learn
Perform API Testing for any application with ease and efficiency
Create 100s of API Tests for their applications
Understand what API tests to create, when to create them, and how to make management happy
Create Data Driven automated API tests
Set up checkpoints for their API tests
Apply real world examples to their learning
Create a UFT solution and nest UFT tests in the solution
Test SOAP Web Services
Test the very popular REST Services
LoadRunner Testing Course
Course Overview The course follows various aspects where students learn …
What you'll learn
Students reported that they were able to troubleshoot the issues faced in the real projects after taking this class
Even if you are using any other performance testing tool, this course will provide you core guidelines for utilizing it for maximum benefits in less time.
By end of the course, you will learn to develop a workable strategy for load testing of an enterprise system and be ready to handle any performance testing project