Data Analytics
Home Courses Offering Data Analytics
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
