About Us

We are a professional services firm dedicated to delivering full life-cycle meta data management, enterprise architecture, business intelligence/data warehousing, and technology solutions to our clients.

Asquare Technologies is an award-winning, professional services firm dedicated to delivering full life-cycle meta data management, enterprise architecture. Business intelligence/data warehousing, and technology solutions to our clients. We deliver project success – no matter the scope and complexity of your business need.

We started operating from 2009 onwards. We have trained over hundreds of Corporate on Various Technologies and have helped them to implement the Business Intelligence/Data warehouse Platforms and Siebel CRM Applications. We have experienced trainers, consultants and certified professionals on various BI Tools, Siebel / MDM Applications and Fusion Middle-ware technologies who can provide excellent corporate training . Asquare has recently delivered trainings for the clients in Abu Dhabi (UAE) like Union National Bank and Darwish Bin Ahmed Group on Oracle Data Integrator , OBIEE and OBIA Technologies. We have also supported our clients for OBIEE Implementation projects in UAE. Asquare has delivered a training on Oracle Data Integrator at Kuwait for Info center Training Institute



Why Business Analytics?

Professional Courses

Experienced Instructor

Practical Training

Validated Certificate

Our Courses

We are a professional services firm dedicated to delivering full life-cycle meta data management, enterprise architecture, business intelligence/data warehousing, and technology solutions to our clients.

Testimonial

Srijith A

One of the best data analytics and business intelligence training centers in Kochi, Well organized training and real time assignments will make you well versed with the multiple analytics tools and methodologies.

Manju Jacob

Institute gave me great experience and practical knowledge. This institute helped to grow technically and professionally. Highly recommend this institute for people who like to study Business Analytics and start updated and catch up with the competitive world.Now I am working at Vittree Professional Insight LLP as a Business Analyst.

Saju Thomas

Great place to learn Business Intelligence skills with the help of Qualified trainer and good hands-on experience. Flexible timings.

Athira Krishna

One of the best BI training Institute, more over hands on training and live projects exposure... Thank You Ashik sir for the great initiative.

Rohini Venugopalan

One of the best BI training institutes in Cochin and with an experienced trainer , it cant get better. Would highly recommend this place to anyone interested in BI.



BUSINESS ANALYTICS COURSE OUTLINE

  • Oracle - SQL
  • Oracle SQL - Home
  • Oracle - SQL - Introduction
  • Oracle - SQL - Environment Setup
  • Oracle - SQL - Getting Started
  • Oracle - SQL - DDL Statements
  • Oracle - SQL - Create Table
  • Oracle - SQL - Alter Table
  • Oracle - SQL - Drop Table
  • Oracle - SQL - Truncate Table
  • Oracle - SQL - Constraints
  • Oracle - SQL - Not Null Constraint
  • Oracle - SQL - Unique Constraint
  • Oracle - SQL - Primary Key Constraint
  • Oracle - SQL - Check Constraint
  • Oracle - SQL - Foreign Key Constraint
  • Oracle - SQL - Managing Constraints
  • Oracle - SQL - Data Manipulation Language
  • Oracle - SQL - Insert Statement
  • Oracle - SQL - Update Statement
  • Oracle - SQL - Delete Statement
  • Oracle - SQL - Select Statement
  • Oracle - SQL - Sorting Data
  • Oracle - SQL - Filtering Data
  • Oracle - SQL - Functions
  • Oracle - SQL - General Functions
  • Oracle - SQL - Joins
  • Oracle - SQL - Group Functions
  • Oracle - SQL - Group By Clause
  • Oracle - SQL - Creating Users

Business Intelligence Basics / Data warehouse Fundamentals

  • What is a Data Warehouse?
  • Data Warehousing Schemas
  • Modelling Types
  • BI Architecture Overview
  • Star and Snow Flake Examples and differences
  • Dimensions and Fact Table types
  • Overview of BI and Data Integration Products

Microsoft Power BI Desktop Visualisation

  • Basics of Data warehouse Concepts / BI Concepts (Data Model types , Facts and Dimensions)
  • Overview of Power BI Tools.
  • Introduction to Tools and Terminology.
  • Connecting to Microsoft Excel , Web Data , Overview of Power Query Editor , Data Model.
  • Gives you an overview of the interface and gets you started in creating
  • your first Power BI Report
  • gets you started with the Power Query Editor (cleaning up messy data)
  • create your custom datestable using MCode Method.
  • you learn advanced Power Query Transformation Steps
  • Using Themes and Import Custom Themes from Gallery.
  • How to set up your data model – Setup and Manage relationships.
  • Using Edit Interactions.
  • Creating Calculated Columns.
  • Starting with Measures and Quick Measures.
  • DAX: SUMX function
  • Create a measures table to keep all the custom measures at single Place.
  • DAX: SUMX with RELATED
  • DAX Timeintelligence: CALCULATE, SAMEPERIODLASTYEAR, FILTER,
  • ALLSELECTED, MAX
  • Build your Report, use custom visuals
  • DAX Timeintelligence: CALCULATE, SAMEPERIODLASTYEAR, DATEADD
  • RANKX, ALL, GENERATESERIES, IF with Parameter
  • DAX Timeintelligence: CALCULATE, FILTER, ALLSELECTED, MAX (=>
  • cumulative Sales)
  • Visualizing DAX Calculations.
  • Hierarchies and Groups Concepts.
  • Using Various types of graphs and Slicers to filter the data.
  • Using Filters - Page and Report Level.
  • Using Tool Tips at Page Level and Field Level
  • Conditional Formatting in Tables and Graphs.
  • Using Buttons and Actions.
  • Creating Bookmarks with Various actions.
  • Using Ask a Questions to create Custom visuals.
  • Using Market Place to add Custom visuals to Visualisations (Aster , Radar , Sankey and Chord Plots demo)
  • Use Scrollers and Hierarchy Slicers from Market Place.
  • Sample Reports using Database Tables - Demo to connect any database.
  • Publish reports to Power BI Service.
  • Creating Dashboards and Insights.
  • Interacting with your Dashboards
  • Sharing Dashboards and Reports.

Additional Topics: (with DAX)

  • Text functions
  • Mathematical functions
  • Time intelligence functions
  • Filter functions
  • Aggregate functions
  • Logical functions
  • Count functions
  • Information functions

Advanced Topics: (With DAX)

  • Inter and Intra column operation
  • Data handling with tables
  • Variables
  • Conditional operation
  • Introduction and Overview
  • BI and Data warehouse Overview
  • Why Tableau? Why Visualization?
  • Getting Started - creating some powerful visualizations quickly
  • The Tableau Product Line
  • Things you should know about Tableau
  • Getting Started
  • Connecting to Data and introduction to data source concept
  • Working with data files versus database server
  • Understanding the Tableau workspace
  • Dimensions and Measures
  • Using Show Me!
  • Tour of Shelves (How shelves and marks work)
  • Building Basic Views
  • Help Menu and Samples
  • Saving and sharing your work
  • Creating Views
  • Marks
  • Size and Transparency
  • Highlighting
  • Working with Dates
  • Date aggregations and date parts
  • Discrete versus Continuous
  • Dual Axis / Multiple Measures
  • Combo Charts with different mark types
  • Geographic Map Page Trails
  • Heat Map
  • Density Chart
  • Scatter Plots
  • Pie Charts and Bar Charts
  • Small Multiples
  • Working with aggregate versus disaggregate data
  • Analyzing
  • Sorting & Grouping
  • Aliases
  • Filtering and Quick Filters
  • Cross-Tabs (Pivot Tables)
  • Totals and Subtotals Drilling and Drill Through
  • Aggregation and Disaggregation
  • Percent of Total
  • Working with Statistics and Trend lines
  • Getting Started with Calculated Fields
  • Working with String Functions
  • Basic Arithmetic Calculations
  • Date Math
  • Working with Totals
  • Custom Aggregations
  • Logic Statements
  • Formatting
  • Options in Formatting your Visualization
  • Working with Labels and Annotations
  • Effective Use of Titles and Captions
  • Introduction to Visual Best Practices
  • Building Interactive Dashboard
  • Combining multiple visualizations into a dashboard
  • Making your worksheet interactive by using actions and filters
  • An Introduction to Best Practices in Visualization
  • Sharing Workbooks
  • Packaged Workbooks
  • Publish to Tableau Server and Sharing over the Web
  • Putting it all together
  • Scenario-based Review Exercises
  • Best Practices

Repository Basics

  • Exploring Oracle BI architecture components
  • Exploring a repository's structure, features, and functions
  • Using the Oracle BI Administration Tool
  • Creating a repository
  • Loading a repository into Oracle BI Server memory

Building the Physical Layer of a Repository

  • Importing data sources
  • Setting up connection pool properties
  • Defining keys and joins
  • Examining physical layer object properties
  • Creating alias tables

Building the Business Model and Mapping Layer of a Repository

  • Building a business model
  • Building logical tables, columns, and sources
  • Defining logical joins
  • Building measures
  • Examining business model object properties

Building the Presentation Layer of a Repository

  • Exploring Presentation layer objects
  • Creating Presentation layer objects
  • Modifying Presentation layer objects
  • Examining Presentation layer object properties

Testing and Validating a Repository

  • Checking repository consistency
  • Turning on logging
  • Defining a repository in the initialization file
  • Executing analyses to test a repository
  • Inspecting the query log

Managing Logical Table Sources

  • Adding multiple logical table sources to a logical table
  • Specifying logical content

Adding Calculations to a Fact

  • Creating new calculation measures based on existing logical columns
  • Creating new calculation measures based on physical columns
  • Creating new calculation measures using the Calculation Wizard
  • Creating measures using functions

Working with Logical Dimensions

  • Creating logical dimension hierarchies
  • Creating level-based measures
  • Creating share measures
  • Creating dimension-specific aggregation rules
  • Creating presentation hierarchies
  • Creating parent-child hierarchies
  • Using calculated members

Using Aggregates

  • Modeling aggregate tables to improve query performance
  • Setting the number of elements in a hierarchy
  • Testing aggregate navigation
  • Using the Aggregate Persistence Wizard

Using Partitions and Fragments

  • Exploring partition types
  • Modeling partitions in an Oracle BI repository
  • Using the Calculation Wizard to create derived measures

Using Repository Variables

  • Creating session variables
  • Creating repository variables
  • Creating initialization blocks
  • Using the Variable Manager
  • Using dynamic repository variables as filters

Modeling Time Series Data

  • Using time comparisons in business analysis
  • Using Oracle BI time series functions to model time series data

Security

  • Exploring Oracle BI default security settings
  • Creating users and groups
  • Creating application roles
  • Setting up object permissions
  • Setting row-level security (data filters)
  • Setting query limits and timing restrictions

Creating Oracle Business Intelligence Dashboards

  • Introduction to dashboards and dashboard pages
  • Creating and editing dashboards
  • Using the Dashboard Builder
  • Exploring dashboard object properties and options
  • Publishing dashboard pages
  • Creating personal customizations and using other page options

Configuring Oracle Business Intelligence Dashboards

  • Types of dashboard content
  • Embedding content in dashboards

Creating Dashboard Prompts and Variables

  • Overview of variables
  • Introduction to dashboard prompts and prompt types
  • Adding a named dashboard prompt to a dashboard
  • Adding a hidden named dashboard prompt to a dashboard
  • Creating additional prompt page and setting page preferences
  • Variables and prompts
  • Adding variable prompts to a dashboard
  • Wiring dashboard prompts

Using Oracle Business Intelligence Delivers

  • Introduction to Oracle BI Delivers
  • Configuring delivery devices and adding delivery profiles
  • Introduction to alerts
  • Adding an Alert Section to a dashboard
  • Overview of Agents
  • Configuring an Agent
  • Using Analysis and KPI conditions to deliver content with Agents
  • Subscribing to an Agent

Oracle Data Integrator 12c Administration and Development

  • Lesson 1: Introduction
  • Lesson 2: Administering ODI Repositories
  • Lesson 3: ODI Topology Concepts
  • Lesson 4: Describing the Physical and Logical Architecture
  • Lesson 5: Oracle Data Integrator Model Concepts
  • Lesson 6: Setting Up a New ODI Project
  • Lesson 7: Organizing ODI Models and Creating ODI Data stores
  • Lesson 8: ODI Mapping Concepts
  • Lesson 9: Designing Mappings
  • Lesson 10: Mappings: Monitoring and Debugging
  • Lesson 11: Designing Mappings: Advanced Topics 1
  • Lesson 12: Designing Mappings: Advanced Topics 2
  • Lesson 13: Using ODI Procedures
  • Lesson 14: Using ODI Packages
  • Lesson 15: Managing ODI Versions
  • Lesson 16: Managing ODI Scenarios
  • Lesson 18: Working with Changed Data Capture
  • Lesson 19: Advanced ODI Administration



Our Partners