!! Exclusive Republic Day Offer Until 28th !!
  info@vedait.in
  +91 - 7733880344

Course Introduction

  • Introduction

Analytics Overview

  • Introduction
  • Introduction to Business Analytics
  • Types of Analytics
  • Areas of Analytics
  • Analytical Tools
  • Analytical Techniques
  • Quiz
  • Key Takeaways

Introduction to SAS

  • Introduction
  • What is SAS
  • Navigating in the SAS Console
  • SAS Language Input Files
  • Data Step
  • PROC Step and DATA Step - Example
  • DATA Step Processing
  • SAS Libraries
  • Knowledge Check
  • Quiz
  • Key Takeaways

Combining and Modifying Datasets

  • Introduction
  • Why Combine or Modify Data
  • Concatenating Datasets
  • Interleaving Method
  • Data Manipulation
  • Modifying Variable Attributes

PROC SQL

  • Introduction
  • What is PROC SQL
  • Retrieving Data from a Table
  • Selecting Columns in a Table
  • Retrieving Data from Multiple Tables
  • Selecting Data from Multiple Tables
  • Concatenating Query Results

SAS Macros

  • Introduction
  • Need for SAS Macros
  • Macro Functions
  • SQL Clauses for Macros
  • The Macro Statement
  • The Conditional Statement

Basics of Statistics

  • Introduction to Statistics
  • Statistical Terms
  • Procedures in SAS for Descriptive Statistics
  • Descriptive Statistics
  • Hypothesis Testing
  • Variable Types
  • Hypothesis Testing - Process
  • Parametric and Non - parametric Tests
  • Parametric Tests - Advantages and Disadvantages

Statistical Procedures

  • Statistical Procedures
  • PROC Means
  • PROC FREQ
  • PROC UNIVARIATE
  • Proc Corr Options
  • PROC REG
  • PROC ANOVA

Data Exploration

  • Data Preparation
  • General Comments and Observations on Data Cleaning
  • Data Type Conversion
  • Character Functions
  • SCAN Function
  • DateTime Functions
  • Missing Value Treatment
  • Data Summarization

Advanced Statistics

  • Introduction to Cluster
  • Clustering Methodologies
  • K Means Clustering
  • Decision Tree
  • Regression
  • Logistic Regression
  • Power BI- Features
  • Architecture
  • Building Blocks
  • Components
  • Installation
  • Pros and Cons
  • Data Modeling
  • Create Workspae
  • Create Dashboard
  • Share Dashboard
  • View Dashboard
  • Desktop
  • Connect to Data in Power BI desktop
  • Archived Workspace
  • Data Source
  • Supported DataSource
  • Admin Roles
  • Report Server
  • DAX Basics
  • Integration with existing Dashboard
  • Integration of Microsoft Flow and Power BI
  • Work with TAble
  • Conditional formatting - Background, Font, Data Bars
  • Gateway
  • Filters
  • Add Filters
  • Query
  • Slicer
  • API
  • REST API
  • KPI
  • Mobile Apps
  • Hyperlink
  • Boolmark
  • Matrix Visual
  • Admin Portal
  • Treemap
  • Shape Map
  • Scatter & Bubble charts, Data Bars
  • Security
  • TroubleShooting
  • Introduction
  • Comprehensive Guide
  • Features
  • Pros and Cons
  • Applications
  • Architecture
  • Download
  • Installation
  • Terminologies
  • Navigation
  • Design Flow
  • Field Types
  • Data Types
  • Operators
  • DashBoard
  • String functions
  • Data Functions
  • Logical Functions
  • Aggregate Functions
  • User Functions
  • Joins
  • Type Conversion
  • Show Me Part I
  • Show Me Part 2
  • DataSources
  • Data Extraction
  • Data Blending
  • Field Operations
  • Data Join
  • Custom Data View
  • Custom Territories
  • Filters
  • Sorting
  • Formatting
  • Background Image
  • Add & Rename Worksheet
  • Save, Reorder & Delete Worksheet
  • Paged Workbook
  • Reference Band
  • Metadata
  • Charts
  • Data Quality Problems
  • TreeMap
  • Highlight Table
  • Predictive Analysis
  • Forecasting
  • Reporting
  • Calculation
  • Clustering and Visualizing
  • World Map service
  • Security
  • Introduction to SQL
  • RDBMS Concepts in SQL
  • SQL RDBMS Database System
  • SQL Data Types
  • SQL Clauses- Part 1
  • SQL Clauses- Part 2
  • SQL Operators- Arithmetic, Comparison, Logical
  • SQL Operators- Alias, IN, BETWEEN
  • Expressions in SQL
  • CREATE, DROP, and SELECT Database in SQL
  • CREATE, ALTER & DROP Table in SQL
  • SQL Comments: Single- and Multi-line
  • SQL Primary & Foreign Keys
  • SQL Statements
  • SQL DISTINCT Keyword
  • SQL Constraints
  • DEFAULT and CHECK Constraints in SQL
  • COUNT Function in SQL Server
  • SUM Function in SQL Server
  • SQL LIKE Clause
  • Wildcard Characters in SQL
  • TRUNCATE & ALTER Commands
  • Null Values and the UNION Clause in SQL
  • SQL Date & Time Functions
  • Joins in SQL- Inner, Left, Right, Full
  • SQL Null Functions
  • SQL Sequences
  • SQL Subqueries
  • SQL Query Optimization Tools
  • SQL Duplicate Records
  • Stored Procedures in SQL
  • SQL Cursors and their Types
  • SQL Indexes & their Types
  • SQL Server Transactions
  • SQL Auto Increment Field
  • SQL Injection (SQLi)
  • SQL Database Tuning Tutorial
  • Pseudocolumn in Oracle SQL
  • Embedded SQL

PL/SQL

Getting started with PL/SQL

  • What is PL/SQL
  • Anonymous Block
  • Data Types
  • Variables
  • Comments
  • Constants

Conditional control

  • IF statements
  • CASE statements
  • GOTO
  • NULL statement

Iterative processing with loops

  • Basic LOOP statement
  • Numeric FOR LOOP statement
  • WHILE loop
  • CONTINUE

Select Into

  • SELECT INTO

Exception handlers

  • Exception
  • Raise exceptions
  • Using raise_application_error
  • Exception propagation
  • Handling other unhandled exceptions

Records

  • Record

Cursors

  • Cursor
  • Cursor FOR LOOP
  • Cursor with parameters
  • Cursor Variables with REF CURSOR Updatable cursor

Stored procedures and Functions

  • Procedure
  • Implicit statement results
  • Function
  • Cursor variables

Packages

  • Introduction to the PL/SQL package
  • Package specification
  • Package body
  • Drop Package

Triggers

  • Triggers
  • Statement-level triggers
  • Row-level triggers
  • INSTEAD OF triggers
  • Disable triggers
  • Enable triggers
  • Drop Triggers
  • How to fix the mutating table error

PL/SQL Collections

Associative Arrays

Nested Tables

    • Introduction to MS Excel
    • Working with Tables
    • Understanding Cell References
    • Basics Functions of Excel
    • Sorting Data
    • Filtering Data
    • Data Consolidation / Basics of Formula/Functions
    • If Functions and text Functions
    • Working with Dates, CountIfs, and SumIfs
    • Module 10: Lookup and Information Functions
    • Using Named Ranges
    • Data Validation
    • Dynamic Array Formula
    • Using Conditional Formatting
    • Macros (Only Recording, Non VBA)
    • Summarizing Data with Pivot Tables
    • Working with Slicers
    • Power Pivot / Power Query
    • Charts
    • Excel Dashboard
    • Protecting and Security
    • Mail Merge
Chat on WhatsApp