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 Advanced Excel, Tableau) 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

 

 

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


 

Basic & 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