Duration : 60 days | 1hr theory/day 1hr Practical

 

 

About BUSINESS ANALYTICS Course

Business and the governments are finding ways to make sense of all the available data. Business Analytics thus finds favor as it is the use of tools and techniques like data mining, pattern matching, data visualizations and predictive modeling to predict and optimize outcomes and derive value from the data. Equipped with this useful information, organizations can compete better in cut-throat markets both locally and globally.

 

The Ideal Candidate for Business Analytics:

There are no real skills you need to take this course, although basic mathematics and good analytical skills will be beneficial.

The use of Business Analytics is widespread across all industries and functions, including Information Technology, Web/E-commerce, Healthcare, Law Enforcement, Banking and Insurance, Biotechnology, Human Resource Management. Some of the application areas include critical product analysis, target marketing, customer lifecycle management, customer service, social media behavior and link analysis, fraud detection, genetic research, inventory management, etc

 
Career Benefits, Pre-Requisites and Course Structure

 

The use of Business Analytics is widespread across all industries and functions, including Information Technology, Web/E-commerce, Healthcare, Law Enforcement, Banking and Insurance, Biotechnology, Human Resource Management. Some of the application areas include critical product analysis, target marketing, customer lifecycle management, customer service, social media behavior and link analysis, fraud detection, genetic research, inventory management, etc


Below a List of a Few Business Analytics Roles Across Industries:

Data Analyst

Financial Analyst

Pricing Analyst

Website Analyst

Retail Sales Analyst

Business Analyst

Marketing Analytics Manager

Supply Chain Analyst

Fraud Analyst

Clinical Analyst

 

Students can Option any one combo

Combo courses with SAS Advanced Excel, SAS (Base and Advance)) or

Combo courses with Tableau (Advanced Excel, SQL, Tableau (Server and Desktop)

 

Course outline

 

Advanced Excel

 

PAGE LAYOUT MENU

 

FORMULA MENU

MATHEMATICAL FUNCTIONS

SUM, SUMIF, SUMIFS, COUNT, COUNTIF, COUNTIFS,

MOD, SQRT, ROUND, ROMAN, COUNTA, AVERAGEIF

CHARACTER FUNCTIONS

UPPER, LOWER, PROPER, CONCATENATE,

LEFT, RIGHT,LENGTH

 

DATE FUNCTIONS

TODAY(), NOW(), EDATE() ,EOMONTH(),NETWORKDAYS(), DATEDIF()

 

BOOLEAN FUNCTIONS

AND, OR IF CONDITION,

TRACE PRECEDENCTS,

TRACE DEPENDENTS,

 

DATA MENU

SUBTOTAL,GROUP,UNGROUP,

 

REVIEW MENU

 

COMMENT,

 

PROTECT SHEET,

PROTECT WORKBOOK,

ALLOWS USER TO EDIT RANGES.

 

 

SHOW HIDE, ZOOM,

NEW WINDOW,

FREEZE PANES,

SAVE WORK SPACE

OTHER FUNCTIONS

 

VLOOKUP


HLOOKUP


MATCH
INDEX
INDIRECT
ISNA

 

VISUAL BASIC APPLICATION(VBA)

 

CONTROLE FLOW STRUCTURES

LINEAR

SEQUENTIAL

 

IF STATEMENTS

 

 

DO LOOP (ENTRY CONDITIONAL LOOP)

 

 

ASIGNING MACROS TO SHAPES

 

 

USER DEFINED FUNCTIONS

 

CLASSES AND OBJECTS

 

Please click on this link to Know more on Advanced Excel Course Outline

 

SQL (Database)

 

Introduction to SQL

Retrieving Data

Updating Data

Inserting Data

Deleting Data

Sorting and Filtering Data

Advanced Filtering

Summarizing Data

Grouping Data

Using Subqueries

Joining Tables

Managing Tables

Using Views

Stored Procedures

Using Cursors

Using Transactions

 

Please click on this link to Know more on SQL Course Outline

 

SAS (Base & Advanced)

 

Data Structures

  • Introduction to SAS interface and library structure and definition
  • Reading data using Datalines and importing and exporting datasets
  • Infiles statement - reading raw data
  • Formats and Informats
  • Variable attributes and data modification using Data and Set statements
  • Data Management

  • Using conditional statements to modify data - Where, If and Nested IF
  • Appending and Merging datasets
  • SAS Functions for data manipulation
  • Loops and Arrays in SAS
  • Report Generation

  • Basic Proc steps - like Proc Contents
  • Proc Format, Proc Report and Proc Tabulate
  • Proc steps for basic statistics - like Proc Univariate and Proc Means
  • Proc SQL

  • Introduction to SQL - basic DBMS and RDBMS concepts
  • Using SQL Procedures in SAS Using conditional statements in SQL and aggregate functions
  • Data manipulation using Proc SQL
  • SAS Macros

  • Introduction to Macros
  • Local and Global declarations
  • Using built-in macro procedures and functions
  •  

    Please click on this link to Know more on SAS Base and SAS Advanced Course Outline

     

    OR

     

    Tableau (Server & Desktop)

     

    The Tableau Environment

    Connect to Data

    Editing Field Properties

    Building Data Views

    Filtering

    Advanced Analysis

    Trend Lines and Statistics

    Background Images

    Background Maps

    Publish and Share

    Dashboards

    Saving and Exporting

    Tableau Server Comprehensive

     

    Please click on this link to Know more on Tableaul Course Outline

     


    Contact US


    A : :PHILLOS,

    #257, (BIIT Building),9th A Main, Near Upahaara Darshini,

     3rd Block, Jayanagar, Bangalore - 560011

     

    E : : nishu.phillos@gmail.

     

    Ph : : 984488 5059 / 96208 90035 / 903588 5059

     

    Whatsapp : 984488 5059 / 96208 90035

     

    Facebook | Linked in | Google + | Google Web


     



    ANIMATION & MULTIMEDIA

     

    Adobe photoshop Course


     

    Adobe illustrator Course



    Corel draw Course



    Graphic designing Course



    Infographics



    DTP Course



    Web designing Course



    Video editing Course



    Audio editing Course



    2D Animation Course



    3D Animation Course



     



    BUSINESS ANALYTICS & REPORTING TOOLS



     

    Microsoft Advanced Excel Course


     

    VBA & Macros Course


     

    Microsoft Access Course


     

    SAS Base & Advanced Course



    Clinical sas Course



    Statistical SAS Course



    MSBI SSIS SSRS SSAS Course



    Tableau Course



    Business Analytics


     

     



    SAP ERP Course



     

     

    SAP fico Course


     

    SAP ABAP Course


     

    SAP WM Course



    SAP PP Course



    SAP SD Course



    SAP MM Course



    SAP HANA Course



    SAP BI BO Course


     

     



    .net Course



    java / J2EE Course



    Android Course



    Oracle Sql & Plsql Course



    Sql Server Course



    PHP and MYSQL Course



    Sql Course



    Vmware Course



    Tally ERP Course



    Basic Excel


     

     



    Why Phillos.....?


     

    In Depth technical Knowledge

     

    Live Project guidence

     

    Real Time Working Environment

     

    100% Placement Support

     

    One On One Sessions availablity

     

    Fast track & Super fast track classes

     



     

     

     

     

    Related Links

    Related Links