Download - Analytics training v0.01
TRAINING MANUAL Analytics Training
JUNE 7 2016 ORANE INTELLI SOLUTIONS
N A Chambers 1st Floor 3 J 7th C Main 3rd cross 3rd block Koramangala Bangalore- 560 034
Page 1 of 14
Creating value addition in young software engineers
Orane N A Chambers 1st Floor 3 J 3rd cross 7th C Main 3rd block Koramangala
Bangalore- 560034
wwworanetechcom T +91 80 4145 6644
Orane is an emerging force in the IT industry with a global foot print Our
objective is to create an organization with a philosophy that is carefully
aligned to affable culture our growth strategy and most importantly
sound value for people To provide the requisite impetus for ORANE and to
deliver unique value preposition to the young bright and creative
engineers We have developed the internship training which caters to the
fresh engineers as a stepping stone towards their academic and career
success
We hope that by providing the outline details and practical experience insights
of our successful Training Internship Programs the esteemed organization will
be encouraged to join us in providing meaningful work experiences to
engineering resources
Our staffs sincerely enjoys working with your team and contributing
meaningfully to their growth as engineers The peerrsquos enthusiasm energizes us
and we have observed many occasions where our co-workers spontaneously
develop informal mentoring relationships outside the formal team structure we
have provided in our program
Upcoming Events
May 1
Launch of new training modules
May 31
Quiz day
June 17
Hi- tea party for trainers
Work In Progress
Complete execution of
documentation project for a large
company
Company Mars India- Bangalore
Task
SRS Document
DD Document
Master Document
Trained expertise
Business Analyst
Techno-Functional
Consultant
Documentation Specialist
Page 2 of 14
Most Important
Paint a picture
Training expands the concept of learning beyond simply educating the staff we
already have on board to include reaching out to train candidates wersquod all like
to have on board full-time someday
Given the competition for an ever-dwindling number of qualified entry-level
engineers itrsquos an innovative investment worth considering We also are happy
to report that we are finding the ldquogrow our ownrdquo approach successful
We just hired our first official intern who has now graduated as a full-time
member of our engineering staff Leading the team in complex project execution
Be a step closer to higher level
Training on key technologies provides a hands on experience to our team and
who doesnrsquot wish to have a team that excels in internal activities thus enabling
us to raise above the rest They provide us the edge in representing ourselves
as the most wanted vendor to our clients
When engineers elevate their skills they bring more confidence energy and
enthusiasm into work They better their execution at all levels of activities This
perhaps is the most important internal factor why few organization are ahead
of othershellip
Recent Achievements
Christ University- Bangalore
Group of international students
were part of our internship
program hailing from Korea
Orane was one of the chosen
vendors to deliver internal training
and also internship for these
young engineers We are happy to
inform our success because we
see couple of them hired into
prominent positions in MNCs as a
key member in project execution
Training Internship
Focused Training on Data
Analytics Business Intelligence-
Data warehousing
Tools Tableau Qlikview Power BI
Page 3 of 14
Contents
Upcoming Events 1
May 1 1
May 31 1
June 17 1
Work In Progress 1
Most Important 2
Recent Achievements 2
Christ University- Bangalore 2
Training Internship 2
Be a step closer to higher level 2
T SQL 4
SSRS 4
Qlikview- Basics 5
Business Dashboard Fundamentals 7
Access Training 8
Advance Access Programming 10
Other Courses We Offer 11
Orane Projects 13
Orane- Services 14
Page 4 of 14
T SQL
SQL (Structured Query Language) is a non-procedural language for querying and modifying data in the database SQL
allow you to define select modify data and also allow the control access to them SQL commands can be embedded
in programs written in other languages as CC++ Java PHP and Python SQL encompassed several components of
which the most important are DDL - Data Description Language and DML Data Manipulation Language
This is a T-SQL training dedicated to all developers beginners and advanced covering the main areas of T-SQL language
starting from the simple operations like select insert update create delete and ending with advanced operations
such as procedures functions triggers and views The entire course consists of 22 modules of 50 hrs dedicated
training
Figure 1 T-SQL Course details amp Hours
SSRS
SQL Server Reporting Services (SSRS) is a server-based report generating software system from Microsoft It is part of suite of Microsoft SQL Server services including SSAS (SQL Server Analysis Services) and SSIS (SQL Server Integration Services) SSRS is a full-featured application that provides report design development testing and deployment of reports by the use of Business Intelligence Development Studio (BIDS) developer tool for all its operations Below are the stages of SQL Server Reporting Services we are going to cover in this article
1 Architecture 2 Installation 3 Role of Business Intelligence Development Studio (BIDS) 4 Report Creation with the Wizard 5 Report Creation with the Report Designer 6 Reports Deployment 7 Security Configuration
3 2 2
4
2 1 2 2 34
2 2 1 2 2 1 2 2
43 3 1 1 1
CHAPTERS
T- SQL- Course Details
Capter 1 Query Query Select ANY Chapter 2 Insert| Delete| Update Insert Delete
Chapter 3 Table Create Table DROP TABLE Chapter 4 Table Join Table Join Self join
Chapter 5 Data Types bigint nchar Chapter 6 Set Operations EXCEPT Union
Chapter 7 Constraints Constraints Create Default Chapter 8 Subquery Subquery Inline view
Chapter 9 Aggregate Functions Aggregate function Min Chapter 10 Date Functions CURRENT_TIMESTAMP DATEPART
Chapter 11 Math Fucntions ABS LOG10 Chapter 12 String Functions ASCII REPLACE
Page 5 of 14
Figure 2 SSRS- Course Details amp Hours
Qlikview- Basics
Qlik- is a leader in data discovery delivering intuitive solutions for self-service data visualization and guided analytics Approximately 33000 customers rely on Qlik solutions to gain meaning out of information from varied sources exploring the hidden relationships within data that lead to insights that ignite good ideas
Control Create business-driven data discoveries with guided analysis paths that are highly customizable and
tightly governed
o Guided analytics Beautiful controlled analytic experiences guide employees toward discovering
insights and making meaningful decisions
o Secure Top-down control of analytics apps permissions and data management
o Centralized Apps Granular control of dashboards layouts and design
Flexibility Build the exact tools you need for your organization and teams
o Customizable Develop custom apps with QlikView scripting and extend development with QlikView
Workbench
o Combinable Integrate QlikView into your business applications and system management software
with extensive APIs
o Global SearchUse natural search to navigate complex information to accelerate discovery
Consistency Provide one set of data and apps for use across your entire organization
o Data integration Unify data sources for a complete view of information centrally managed data and
apps make it easier to discover insights
0
05
1
15
2
25
3
35
Intr
o t
o F
eatu
res
SSR
S A
rch
ite
chu
re
Rep
ort
ing
Serv
er P
roje
cts
Cre
atin
g Ta
bu
lar
Rep
ort
Ad
din
g C
on
tro
ls
Cre
atin
g Li
st R
epo
rt
Cre
atin
g Ex
pre
ssio
ns
Glo
bal
Co
llect
ion
s
Form
atti
ng
Cre
atin
g G
rou
ps
Cal
cula
tin
g To
tals
Inte
ract
ive
Sort
ing
Cre
atin
g P
aram
ete
rs
Dro
p D
ow
n L
ist
Par
amet
ers
Pa
ram
ete
r So
rtin
g
Cre
atin
g M
atri
x R
ep
ort
s
SSR
S 20
08
Mat
rix
Feat
ure
s
Cre
atin
g A
Ch
art
Ad
din
g G
auge
s
Dep
loy
Rep
ort
s
Rep
ort
Man
ager
Rep
ort
ing
Serv
ice
s Se
curi
ty
SSL
Dat
a So
urc
e S
ecu
rity
Rep
ort
ing
Serv
ice
s A
PIs
Rep
ort
Vie
wer
Co
ntr
ols
Web
Se
rvic
e
Web
Se
rvic
e Su
bsc
rip
tio
n
Cu
sto
m A
ssem
blie
s
Rep
ort
Cac
hin
g
Sub
scri
pti
on
s
Two
Rep
ort
Bu
ilder
s
Cre
atin
g R
ep
ort
s
Ch 1 Ch 2 Ch 3 Ch 4 Ch 5 Ch 6 Ch 7 Ch 8 Ch 9 Ch10
Ch11
Ch12
Ch13 Ch14
Ch15
Ch16
Ch17
Ch18
Ch19
Ch20
Ch21
Ch22
Ch23
Ch24
Ch25
Ch26
Ch27
Ch28
Ch29
Ch30
Ch31
Ch32
Ch33
Ho
urs
Chapters
Page 6 of 14
o Advanced reporting Create and distribute consistent reports and templates plus embed them in
Microsoft Office documents with QlikViewreg NPrinting
o Enterprise scalability The advantages of guided analytics with secure enterprise-level governance of
data and analytics
Figure 3 QV Basics Course Details
Figure 4 QV- Advanced Training course details
0
1
2
3
4
5
6
What Is QlikView Natural Joins Make forEasy Data Models
Filters Selections and KPIs ndash Quick-look
Dashboard Elements
Dig Deep with Charts andGraphs
Dashboard Presentation Isthe Key to Dashboard
Adoption
Ch 1 Ch 2 Ch 3 Ch 4 Ch 5
HO
UR
S
CHAPTERS
Qlikview- Basics
1 1
2 2
3
2
3
2 2 2
1 1
2 2
1
2 2 2
1
3 3
2
1
2 2 2 2
4
CH
1
QL
IKV
IEW
hellip
CH
2
INT
RO
TO
hellip
CH
3
INT
RO
TO
hellip
CH
4
QL
IKV
IEW
hellip
CH
5
LO
AD
ING
hellip
CH
6
CR
EA
TIN
G hellip
CH
7
SC
RIP
TIN
G hellip
CH
8
AD
DIN
G hellip
CH
9
GE
NE
RA
TE
hellip
CH
10
M
AP
PIN
G hellip
CH
11
Q
V D
AT
A hellip
CH
12
Q
V hellip
CH
12
A
DV
hellip
CH
1
US
ING
QV
hellip
CH
2
SH
EE
TS
amp hellip
CH
3
TH
E L
IST
hellip
CH
4
TH
E T
AB
LE
hellip
CH
5
TH
E M
UL
TI hellip
CH
6
TH
E T
EX
T hellip
CH
7
CH
AR
TS
CH
8
MU
LT
I-hellip
CH
9
GU
AG
ES
CH
10
B
UT
TO
NS
CH
11
T
HE
hellip
CH
12
hellip
CH
13
O
TH
ER
hellip
CH
14
S
ET
TIN
GS
hellip
CH
15
R
EP
OR
TS
hellip
P A R T 1 P A R T 2 U S E R I N T E R F A C E D E S I G N I N G
HOURS
Page 7 of 14
Business Dashboard Fundamentals
Ch 1 Visual Perception Dashboard Examples
Why Stats Arent Enough
How to Make Data Beautiful
Demo Eliminating Chart Junk
Summary
Ch 2 Common Charts Basic Data Presentation Methods
Basic Chart Types
Choosing a Chart Type
Advanced Chart Types
Chart Types to Avoid
Summary
Ch 3 Dashboard Planning Dashboard Development Process
Request Process
Prioritization
Documentation
Summary
Ch 4 Dashboard Design Dashboard Design Considerations
Knowing Your Audience
Choosing the Right Data
Dashboard Layout
Summary
Ch 5 Building Dashboards in Excel Part 1 - Working with Data
DEMO Acquiring Data
DEMO Massaging Data
Summary
Ch 6 Building Dashboards in Excel Part 2 - Visualizing Data
DEMO Building Charts
DEMO Building Dashboards
DEMO Building Scorecards
DEMO Preparing for Distribution
Summary
Page 8 of 14
Ch 7 Building Dashboards in Tableau Part 1- Working with Data
DEMO Getting Setup
DEMO Connecting to Data
DEMO Working with Data
Summary
Ch 8 Building Dashboards in Tableau Part 2 - Visualizing Data
DEMO Building Charts
DEMO Building Dashboards
DEMO Formatting
DEMO Sharing Your Work
Summary
Figure 5 Course Outline
Figure 6 Course Details amp Hours
With all the acronyms bandied about in the world of computing its easy to get some terms confused VB stands for Visual Basic and it is not the same as VBA Though both VB and VBA are programming languages derived from BASIC and created by Microsoft they are otherwise very different
VB is a language that enables you to create standalone executable applications that do not even require its users to have Office or Excel loaded onto their computers VBA cannot create standalone applications and it exists within a host application such as Excel and the workbook containing the VBA code For a VBA macro to run its host application workbook must be open This book is about VBA and how it controls Excel
Access Training
Access is an excellent (many would say logical) next step for the analyst who faces an ever-increasing data pool Access
takes very few performance hits with larger datasets It has no predetermined row limitations And it can effectively
manage the relationships between disparate data tables In addition Access comes with tools that help you build your
own distributable applications
Today when we have more data than ever and more demands for complex data analysis power analysts need to add
some tools to their repertoire in order to get away from being simply ldquospreadsheet mechanicsrdquo Thats why this book is
such an important step in the evolution of your skillset Throughout this book not only will you get an introduction to
45 5 5
2
5
22
Ch 1 Ch 2 Ch 3 Ch 4 Ch 5 Ch 6 Ch 7 Ch 8
Hours
Page 9 of 14
Access but youll also learn various ways in which you can use Access to improve your daily data management and
analysis
Figure 7 Access Course Details amp Hours
Part 1- Access Building Blocks| 3 hrs
bull An Introduction to Database Development
bull Getting Started with Access
Part 2- Understanding Access Tables| 8 hrs
bull Creating Access Tables
bull Understanding Table Relationships
bull Working with Access Tables
bull Importing and Exporting Data
bull Linking to External Data
Part 3-Working with Access Queries| 6 hrs
bull Selecting Data with Queries
bull Using Operators and Expressions in Access
Part 4- Analyzing Data in Access| 7 hrs
bull Transforming Data in Access
bull Working with Calculations and Dates
bull Performing Conditional Analyses
bull Fundamentals of Using Access SQL
bull Subqueries and Domain Aggregate Functions
bull Running Descriptive Statistics in Access
Part 5- Working with Access Forms and Reports| 8 hrs
bull Creating Basic Access Forms
bull Working with Data on Access Forms
bull Working with Form Controls
bull Presenting Data with Access Reports
bull Advanced Access Report Techniques
Page 10 of 14
Advance Access Programming
Figure 8 Advanced Access Course details amp Hours
Advanced
Access
Programming
Techniques
10 hrs
Debugging Your Access Applications
-Organizing VBA Code
-Testing Your Applications
-Traditional Debugging Techniques
-Using the Access Debugging Tools
-Trapping Errors in Your Code
Accessing Data with VBA Code
-Working with Data
-Understanding ADO Objects
-Understanding DAO Objects
-Writing VBA Code to Update a Table
Advanced Data Access with VBA
-Adding an Unbound Combo Box to a Form to Find Data
-Filtering a Form
Integrating Access and SQL Server
-Introducing SQL Server Express
-Understanding Data Types in SQL Server
-Installing SQL Server Express
-Connecting to SQL Server
-Working with SQL Server Objects
Customizing the Ribbon
-The Ribbon Hierarchy
-Editing the Default Ribbon
-Working with the Quick Access Toolbar
-Developing Custom Ribbons
-Creating a Custom Ribbon
-The Basic Ribbon XML
-Adding Ribbon Controls
-Attaching Ribbons to Forms and Reports
Completely Removing the Ribbon
Preparing Your Access Application for Distribution
-Defining the Current Database Options
-Developing the Application
-Polishing Your Application
-Bulletproofing an Application
Securing the Environment
Page 11 of 14
Other Courses We Offer
1 Business Intelligence Data warehousing
2 Data Analytics
3 Data Analysis
4 Business Analysis
Tools amp Applications
1 Microsoft Office
a MS-Excel amp Macros (VBA)
b MS-Access amp Macros (VBA)
c VBA for PowerPoint
d Access
e MS Sql Server 2005 2008 2012 2014
f T-SQL Programming
g Sql Server Reporting Services 2005 to 2014
h Power BI (Power Pivots Power View Power Designer Power Maps) 2010 2013 2016
i Statistics using Excel Data Analysis Toolpak
2 Tableau 80 to 93 Desktop Server Online Public Reader
3 Sisense v60 with Elasticube
4 Qlik Tech Products
a Qlikview 11
b Qliksense 22
5 Database
a RDBMS
b SQL
c Dimensional modelling
6 Domain Specific
a Financial Modeling
b Cost Modeling
c Spend Analytics
d Retail Analytics
e HR Analytics
f HealthcarePharma Analytics
g PMO
h Infrastructure Management (ITO)
7 Big Data ndash Hadoop
8 HDFS (Hadoop File System)
9 Oracle
a Oracle BRM
b Oracle suite
10 Technical Writing
Page 12 of 14
11 Business Analysis
12 Project Consulting and academic project assistance and final year project certification
Web amp Mobile Technologies
Web Development Tools amp Applications
1 ASPNET
2 CNET
3 Python
4 D3JS
5 Java scripting
6 JQuery
7 PHP
8 JSP
9 Content Management using WordPress amp Joomla
10 HTML5
11 CSS3
12 Bootstrap
13 Rest API implementation using PHP
14 Google Cloud Messaging Server using PHP
15 APNS server implementation using PHP
16 Additional API Web Connectors creation using Python amp PHP
Mobile Application (All Platforms)
1 AngularJS
2 Server development of Android and iPhone application
3 Mobile Application
4 MySQL
5 SQLite
Testing Modules
1 Black Box Testing
2 White Box Testing
3 Selenium
4 QTP
Page 13 of 14
Orane Projects
Mobile Apps
Mars Telecom- a Hyderabad based IT company providing solutions to various industries across the globe has been kind
to utilize Oranersquos ever efficient and skilled consultants to deliver Mobile application solution that is part of the
Mumbai municipal authority The app was focused on enable the authorities of the MUDA community to effectively
use technology for its project completion and approval online The mobile app was designed to work with Samsun
mobile phones and tablets
Training amp Internship Programs
Christ University- Bangalore is known for its vast knowledge sharing and goodness to accommodate the aspiring
student from across the world to complete their graduate and under-graduate programs By decades of excellence and
mastery into the academic system Christ has carved a niche in the education field Today they also cater to masters
and PhD degrees in variety of subjects Orane is pleased to have been their chosen vendors to deliver internship amp
training program to Korean students under their CART- ldquoCenter for Advance Research and Trainingrdquo department
Website Social Media amp CRM Solutions
Stratum Ventures LLP- A Land Development company based in Bangalore working towards investment properties for
short and long term investors from across the globe Orane shares its gratitude to Stratum Ventures LLP team to have
shortlisted us to deliver their end-to-end IT solution starting from Website to CRM implementation
Orane ndash Global IT Consulting and Services
Industries Served Manufacturing
Energy and Petrochemical
Banking and Finance Government
Services Offered BIDW amp EPM ERP Enterprise Products and Solutions Mobile Device Development Consulting Managed Service Support Testing Maintenance and Upgrade
Value Proposition Relationship driven Business Agility Delivery ROI Quick Response
Page 14 of 14
Orane Intelli Solutions
NA Chambers 1st Floor
3 J 7th C Main Road 3rd Block
3rd Cross Road Koramangala
Bangalore-560034
Email infooranetechcom| Web wwworanetechcom| Ph +91 80 4145 6644
Large- Enterprise Solutions
Big Data
Data Visualization
BI DW
ERP
Enterprise Mobile App
Enterprise Solutions for Medium Scale
Data Visualization
Analytics
ERP- Standalone Cloud
Application Dev
Mobile apps
Small Industries
Cloud Solutions Application Dev Enterprise Portals Mobile apps
Orane- Services
Offshore Development Centers | Outsourced Product Development | Staff Augmentation |Trainings
Fact Sheet
Orane founded in year 2011- primarily focused in providing Business Intelligence and ERP solutions Headquartered in Bangalore having strong alliance across various geographies Strong and experienced management with several years of industry experience and solid leadership Ensuring quality delivery and support Projects Completed Al-Shirawi Ent Modern Plastics Industry Kanva Fashions The Address Makers
In the pipeline SCANIA Bangalore Bristle Cone Bataviarsquos Textile Live-in- Space Pvt Ltd etc
Value Proposition Relationship
driven Business
Agility
Page 1 of 14
Creating value addition in young software engineers
Orane N A Chambers 1st Floor 3 J 3rd cross 7th C Main 3rd block Koramangala
Bangalore- 560034
wwworanetechcom T +91 80 4145 6644
Orane is an emerging force in the IT industry with a global foot print Our
objective is to create an organization with a philosophy that is carefully
aligned to affable culture our growth strategy and most importantly
sound value for people To provide the requisite impetus for ORANE and to
deliver unique value preposition to the young bright and creative
engineers We have developed the internship training which caters to the
fresh engineers as a stepping stone towards their academic and career
success
We hope that by providing the outline details and practical experience insights
of our successful Training Internship Programs the esteemed organization will
be encouraged to join us in providing meaningful work experiences to
engineering resources
Our staffs sincerely enjoys working with your team and contributing
meaningfully to their growth as engineers The peerrsquos enthusiasm energizes us
and we have observed many occasions where our co-workers spontaneously
develop informal mentoring relationships outside the formal team structure we
have provided in our program
Upcoming Events
May 1
Launch of new training modules
May 31
Quiz day
June 17
Hi- tea party for trainers
Work In Progress
Complete execution of
documentation project for a large
company
Company Mars India- Bangalore
Task
SRS Document
DD Document
Master Document
Trained expertise
Business Analyst
Techno-Functional
Consultant
Documentation Specialist
Page 2 of 14
Most Important
Paint a picture
Training expands the concept of learning beyond simply educating the staff we
already have on board to include reaching out to train candidates wersquod all like
to have on board full-time someday
Given the competition for an ever-dwindling number of qualified entry-level
engineers itrsquos an innovative investment worth considering We also are happy
to report that we are finding the ldquogrow our ownrdquo approach successful
We just hired our first official intern who has now graduated as a full-time
member of our engineering staff Leading the team in complex project execution
Be a step closer to higher level
Training on key technologies provides a hands on experience to our team and
who doesnrsquot wish to have a team that excels in internal activities thus enabling
us to raise above the rest They provide us the edge in representing ourselves
as the most wanted vendor to our clients
When engineers elevate their skills they bring more confidence energy and
enthusiasm into work They better their execution at all levels of activities This
perhaps is the most important internal factor why few organization are ahead
of othershellip
Recent Achievements
Christ University- Bangalore
Group of international students
were part of our internship
program hailing from Korea
Orane was one of the chosen
vendors to deliver internal training
and also internship for these
young engineers We are happy to
inform our success because we
see couple of them hired into
prominent positions in MNCs as a
key member in project execution
Training Internship
Focused Training on Data
Analytics Business Intelligence-
Data warehousing
Tools Tableau Qlikview Power BI
Page 3 of 14
Contents
Upcoming Events 1
May 1 1
May 31 1
June 17 1
Work In Progress 1
Most Important 2
Recent Achievements 2
Christ University- Bangalore 2
Training Internship 2
Be a step closer to higher level 2
T SQL 4
SSRS 4
Qlikview- Basics 5
Business Dashboard Fundamentals 7
Access Training 8
Advance Access Programming 10
Other Courses We Offer 11
Orane Projects 13
Orane- Services 14
Page 4 of 14
T SQL
SQL (Structured Query Language) is a non-procedural language for querying and modifying data in the database SQL
allow you to define select modify data and also allow the control access to them SQL commands can be embedded
in programs written in other languages as CC++ Java PHP and Python SQL encompassed several components of
which the most important are DDL - Data Description Language and DML Data Manipulation Language
This is a T-SQL training dedicated to all developers beginners and advanced covering the main areas of T-SQL language
starting from the simple operations like select insert update create delete and ending with advanced operations
such as procedures functions triggers and views The entire course consists of 22 modules of 50 hrs dedicated
training
Figure 1 T-SQL Course details amp Hours
SSRS
SQL Server Reporting Services (SSRS) is a server-based report generating software system from Microsoft It is part of suite of Microsoft SQL Server services including SSAS (SQL Server Analysis Services) and SSIS (SQL Server Integration Services) SSRS is a full-featured application that provides report design development testing and deployment of reports by the use of Business Intelligence Development Studio (BIDS) developer tool for all its operations Below are the stages of SQL Server Reporting Services we are going to cover in this article
1 Architecture 2 Installation 3 Role of Business Intelligence Development Studio (BIDS) 4 Report Creation with the Wizard 5 Report Creation with the Report Designer 6 Reports Deployment 7 Security Configuration
3 2 2
4
2 1 2 2 34
2 2 1 2 2 1 2 2
43 3 1 1 1
CHAPTERS
T- SQL- Course Details
Capter 1 Query Query Select ANY Chapter 2 Insert| Delete| Update Insert Delete
Chapter 3 Table Create Table DROP TABLE Chapter 4 Table Join Table Join Self join
Chapter 5 Data Types bigint nchar Chapter 6 Set Operations EXCEPT Union
Chapter 7 Constraints Constraints Create Default Chapter 8 Subquery Subquery Inline view
Chapter 9 Aggregate Functions Aggregate function Min Chapter 10 Date Functions CURRENT_TIMESTAMP DATEPART
Chapter 11 Math Fucntions ABS LOG10 Chapter 12 String Functions ASCII REPLACE
Page 5 of 14
Figure 2 SSRS- Course Details amp Hours
Qlikview- Basics
Qlik- is a leader in data discovery delivering intuitive solutions for self-service data visualization and guided analytics Approximately 33000 customers rely on Qlik solutions to gain meaning out of information from varied sources exploring the hidden relationships within data that lead to insights that ignite good ideas
Control Create business-driven data discoveries with guided analysis paths that are highly customizable and
tightly governed
o Guided analytics Beautiful controlled analytic experiences guide employees toward discovering
insights and making meaningful decisions
o Secure Top-down control of analytics apps permissions and data management
o Centralized Apps Granular control of dashboards layouts and design
Flexibility Build the exact tools you need for your organization and teams
o Customizable Develop custom apps with QlikView scripting and extend development with QlikView
Workbench
o Combinable Integrate QlikView into your business applications and system management software
with extensive APIs
o Global SearchUse natural search to navigate complex information to accelerate discovery
Consistency Provide one set of data and apps for use across your entire organization
o Data integration Unify data sources for a complete view of information centrally managed data and
apps make it easier to discover insights
0
05
1
15
2
25
3
35
Intr
o t
o F
eatu
res
SSR
S A
rch
ite
chu
re
Rep
ort
ing
Serv
er P
roje
cts
Cre
atin
g Ta
bu
lar
Rep
ort
Ad
din
g C
on
tro
ls
Cre
atin
g Li
st R
epo
rt
Cre
atin
g Ex
pre
ssio
ns
Glo
bal
Co
llect
ion
s
Form
atti
ng
Cre
atin
g G
rou
ps
Cal
cula
tin
g To
tals
Inte
ract
ive
Sort
ing
Cre
atin
g P
aram
ete
rs
Dro
p D
ow
n L
ist
Par
amet
ers
Pa
ram
ete
r So
rtin
g
Cre
atin
g M
atri
x R
ep
ort
s
SSR
S 20
08
Mat
rix
Feat
ure
s
Cre
atin
g A
Ch
art
Ad
din
g G
auge
s
Dep
loy
Rep
ort
s
Rep
ort
Man
ager
Rep
ort
ing
Serv
ice
s Se
curi
ty
SSL
Dat
a So
urc
e S
ecu
rity
Rep
ort
ing
Serv
ice
s A
PIs
Rep
ort
Vie
wer
Co
ntr
ols
Web
Se
rvic
e
Web
Se
rvic
e Su
bsc
rip
tio
n
Cu
sto
m A
ssem
blie
s
Rep
ort
Cac
hin
g
Sub
scri
pti
on
s
Two
Rep
ort
Bu
ilder
s
Cre
atin
g R
ep
ort
s
Ch 1 Ch 2 Ch 3 Ch 4 Ch 5 Ch 6 Ch 7 Ch 8 Ch 9 Ch10
Ch11
Ch12
Ch13 Ch14
Ch15
Ch16
Ch17
Ch18
Ch19
Ch20
Ch21
Ch22
Ch23
Ch24
Ch25
Ch26
Ch27
Ch28
Ch29
Ch30
Ch31
Ch32
Ch33
Ho
urs
Chapters
Page 6 of 14
o Advanced reporting Create and distribute consistent reports and templates plus embed them in
Microsoft Office documents with QlikViewreg NPrinting
o Enterprise scalability The advantages of guided analytics with secure enterprise-level governance of
data and analytics
Figure 3 QV Basics Course Details
Figure 4 QV- Advanced Training course details
0
1
2
3
4
5
6
What Is QlikView Natural Joins Make forEasy Data Models
Filters Selections and KPIs ndash Quick-look
Dashboard Elements
Dig Deep with Charts andGraphs
Dashboard Presentation Isthe Key to Dashboard
Adoption
Ch 1 Ch 2 Ch 3 Ch 4 Ch 5
HO
UR
S
CHAPTERS
Qlikview- Basics
1 1
2 2
3
2
3
2 2 2
1 1
2 2
1
2 2 2
1
3 3
2
1
2 2 2 2
4
CH
1
QL
IKV
IEW
hellip
CH
2
INT
RO
TO
hellip
CH
3
INT
RO
TO
hellip
CH
4
QL
IKV
IEW
hellip
CH
5
LO
AD
ING
hellip
CH
6
CR
EA
TIN
G hellip
CH
7
SC
RIP
TIN
G hellip
CH
8
AD
DIN
G hellip
CH
9
GE
NE
RA
TE
hellip
CH
10
M
AP
PIN
G hellip
CH
11
Q
V D
AT
A hellip
CH
12
Q
V hellip
CH
12
A
DV
hellip
CH
1
US
ING
QV
hellip
CH
2
SH
EE
TS
amp hellip
CH
3
TH
E L
IST
hellip
CH
4
TH
E T
AB
LE
hellip
CH
5
TH
E M
UL
TI hellip
CH
6
TH
E T
EX
T hellip
CH
7
CH
AR
TS
CH
8
MU
LT
I-hellip
CH
9
GU
AG
ES
CH
10
B
UT
TO
NS
CH
11
T
HE
hellip
CH
12
hellip
CH
13
O
TH
ER
hellip
CH
14
S
ET
TIN
GS
hellip
CH
15
R
EP
OR
TS
hellip
P A R T 1 P A R T 2 U S E R I N T E R F A C E D E S I G N I N G
HOURS
Page 7 of 14
Business Dashboard Fundamentals
Ch 1 Visual Perception Dashboard Examples
Why Stats Arent Enough
How to Make Data Beautiful
Demo Eliminating Chart Junk
Summary
Ch 2 Common Charts Basic Data Presentation Methods
Basic Chart Types
Choosing a Chart Type
Advanced Chart Types
Chart Types to Avoid
Summary
Ch 3 Dashboard Planning Dashboard Development Process
Request Process
Prioritization
Documentation
Summary
Ch 4 Dashboard Design Dashboard Design Considerations
Knowing Your Audience
Choosing the Right Data
Dashboard Layout
Summary
Ch 5 Building Dashboards in Excel Part 1 - Working with Data
DEMO Acquiring Data
DEMO Massaging Data
Summary
Ch 6 Building Dashboards in Excel Part 2 - Visualizing Data
DEMO Building Charts
DEMO Building Dashboards
DEMO Building Scorecards
DEMO Preparing for Distribution
Summary
Page 8 of 14
Ch 7 Building Dashboards in Tableau Part 1- Working with Data
DEMO Getting Setup
DEMO Connecting to Data
DEMO Working with Data
Summary
Ch 8 Building Dashboards in Tableau Part 2 - Visualizing Data
DEMO Building Charts
DEMO Building Dashboards
DEMO Formatting
DEMO Sharing Your Work
Summary
Figure 5 Course Outline
Figure 6 Course Details amp Hours
With all the acronyms bandied about in the world of computing its easy to get some terms confused VB stands for Visual Basic and it is not the same as VBA Though both VB and VBA are programming languages derived from BASIC and created by Microsoft they are otherwise very different
VB is a language that enables you to create standalone executable applications that do not even require its users to have Office or Excel loaded onto their computers VBA cannot create standalone applications and it exists within a host application such as Excel and the workbook containing the VBA code For a VBA macro to run its host application workbook must be open This book is about VBA and how it controls Excel
Access Training
Access is an excellent (many would say logical) next step for the analyst who faces an ever-increasing data pool Access
takes very few performance hits with larger datasets It has no predetermined row limitations And it can effectively
manage the relationships between disparate data tables In addition Access comes with tools that help you build your
own distributable applications
Today when we have more data than ever and more demands for complex data analysis power analysts need to add
some tools to their repertoire in order to get away from being simply ldquospreadsheet mechanicsrdquo Thats why this book is
such an important step in the evolution of your skillset Throughout this book not only will you get an introduction to
45 5 5
2
5
22
Ch 1 Ch 2 Ch 3 Ch 4 Ch 5 Ch 6 Ch 7 Ch 8
Hours
Page 9 of 14
Access but youll also learn various ways in which you can use Access to improve your daily data management and
analysis
Figure 7 Access Course Details amp Hours
Part 1- Access Building Blocks| 3 hrs
bull An Introduction to Database Development
bull Getting Started with Access
Part 2- Understanding Access Tables| 8 hrs
bull Creating Access Tables
bull Understanding Table Relationships
bull Working with Access Tables
bull Importing and Exporting Data
bull Linking to External Data
Part 3-Working with Access Queries| 6 hrs
bull Selecting Data with Queries
bull Using Operators and Expressions in Access
Part 4- Analyzing Data in Access| 7 hrs
bull Transforming Data in Access
bull Working with Calculations and Dates
bull Performing Conditional Analyses
bull Fundamentals of Using Access SQL
bull Subqueries and Domain Aggregate Functions
bull Running Descriptive Statistics in Access
Part 5- Working with Access Forms and Reports| 8 hrs
bull Creating Basic Access Forms
bull Working with Data on Access Forms
bull Working with Form Controls
bull Presenting Data with Access Reports
bull Advanced Access Report Techniques
Page 10 of 14
Advance Access Programming
Figure 8 Advanced Access Course details amp Hours
Advanced
Access
Programming
Techniques
10 hrs
Debugging Your Access Applications
-Organizing VBA Code
-Testing Your Applications
-Traditional Debugging Techniques
-Using the Access Debugging Tools
-Trapping Errors in Your Code
Accessing Data with VBA Code
-Working with Data
-Understanding ADO Objects
-Understanding DAO Objects
-Writing VBA Code to Update a Table
Advanced Data Access with VBA
-Adding an Unbound Combo Box to a Form to Find Data
-Filtering a Form
Integrating Access and SQL Server
-Introducing SQL Server Express
-Understanding Data Types in SQL Server
-Installing SQL Server Express
-Connecting to SQL Server
-Working with SQL Server Objects
Customizing the Ribbon
-The Ribbon Hierarchy
-Editing the Default Ribbon
-Working with the Quick Access Toolbar
-Developing Custom Ribbons
-Creating a Custom Ribbon
-The Basic Ribbon XML
-Adding Ribbon Controls
-Attaching Ribbons to Forms and Reports
Completely Removing the Ribbon
Preparing Your Access Application for Distribution
-Defining the Current Database Options
-Developing the Application
-Polishing Your Application
-Bulletproofing an Application
Securing the Environment
Page 11 of 14
Other Courses We Offer
1 Business Intelligence Data warehousing
2 Data Analytics
3 Data Analysis
4 Business Analysis
Tools amp Applications
1 Microsoft Office
a MS-Excel amp Macros (VBA)
b MS-Access amp Macros (VBA)
c VBA for PowerPoint
d Access
e MS Sql Server 2005 2008 2012 2014
f T-SQL Programming
g Sql Server Reporting Services 2005 to 2014
h Power BI (Power Pivots Power View Power Designer Power Maps) 2010 2013 2016
i Statistics using Excel Data Analysis Toolpak
2 Tableau 80 to 93 Desktop Server Online Public Reader
3 Sisense v60 with Elasticube
4 Qlik Tech Products
a Qlikview 11
b Qliksense 22
5 Database
a RDBMS
b SQL
c Dimensional modelling
6 Domain Specific
a Financial Modeling
b Cost Modeling
c Spend Analytics
d Retail Analytics
e HR Analytics
f HealthcarePharma Analytics
g PMO
h Infrastructure Management (ITO)
7 Big Data ndash Hadoop
8 HDFS (Hadoop File System)
9 Oracle
a Oracle BRM
b Oracle suite
10 Technical Writing
Page 12 of 14
11 Business Analysis
12 Project Consulting and academic project assistance and final year project certification
Web amp Mobile Technologies
Web Development Tools amp Applications
1 ASPNET
2 CNET
3 Python
4 D3JS
5 Java scripting
6 JQuery
7 PHP
8 JSP
9 Content Management using WordPress amp Joomla
10 HTML5
11 CSS3
12 Bootstrap
13 Rest API implementation using PHP
14 Google Cloud Messaging Server using PHP
15 APNS server implementation using PHP
16 Additional API Web Connectors creation using Python amp PHP
Mobile Application (All Platforms)
1 AngularJS
2 Server development of Android and iPhone application
3 Mobile Application
4 MySQL
5 SQLite
Testing Modules
1 Black Box Testing
2 White Box Testing
3 Selenium
4 QTP
Page 13 of 14
Orane Projects
Mobile Apps
Mars Telecom- a Hyderabad based IT company providing solutions to various industries across the globe has been kind
to utilize Oranersquos ever efficient and skilled consultants to deliver Mobile application solution that is part of the
Mumbai municipal authority The app was focused on enable the authorities of the MUDA community to effectively
use technology for its project completion and approval online The mobile app was designed to work with Samsun
mobile phones and tablets
Training amp Internship Programs
Christ University- Bangalore is known for its vast knowledge sharing and goodness to accommodate the aspiring
student from across the world to complete their graduate and under-graduate programs By decades of excellence and
mastery into the academic system Christ has carved a niche in the education field Today they also cater to masters
and PhD degrees in variety of subjects Orane is pleased to have been their chosen vendors to deliver internship amp
training program to Korean students under their CART- ldquoCenter for Advance Research and Trainingrdquo department
Website Social Media amp CRM Solutions
Stratum Ventures LLP- A Land Development company based in Bangalore working towards investment properties for
short and long term investors from across the globe Orane shares its gratitude to Stratum Ventures LLP team to have
shortlisted us to deliver their end-to-end IT solution starting from Website to CRM implementation
Orane ndash Global IT Consulting and Services
Industries Served Manufacturing
Energy and Petrochemical
Banking and Finance Government
Services Offered BIDW amp EPM ERP Enterprise Products and Solutions Mobile Device Development Consulting Managed Service Support Testing Maintenance and Upgrade
Value Proposition Relationship driven Business Agility Delivery ROI Quick Response
Page 14 of 14
Orane Intelli Solutions
NA Chambers 1st Floor
3 J 7th C Main Road 3rd Block
3rd Cross Road Koramangala
Bangalore-560034
Email infooranetechcom| Web wwworanetechcom| Ph +91 80 4145 6644
Large- Enterprise Solutions
Big Data
Data Visualization
BI DW
ERP
Enterprise Mobile App
Enterprise Solutions for Medium Scale
Data Visualization
Analytics
ERP- Standalone Cloud
Application Dev
Mobile apps
Small Industries
Cloud Solutions Application Dev Enterprise Portals Mobile apps
Orane- Services
Offshore Development Centers | Outsourced Product Development | Staff Augmentation |Trainings
Fact Sheet
Orane founded in year 2011- primarily focused in providing Business Intelligence and ERP solutions Headquartered in Bangalore having strong alliance across various geographies Strong and experienced management with several years of industry experience and solid leadership Ensuring quality delivery and support Projects Completed Al-Shirawi Ent Modern Plastics Industry Kanva Fashions The Address Makers
In the pipeline SCANIA Bangalore Bristle Cone Bataviarsquos Textile Live-in- Space Pvt Ltd etc
Value Proposition Relationship
driven Business
Agility
Page 2 of 14
Most Important
Paint a picture
Training expands the concept of learning beyond simply educating the staff we
already have on board to include reaching out to train candidates wersquod all like
to have on board full-time someday
Given the competition for an ever-dwindling number of qualified entry-level
engineers itrsquos an innovative investment worth considering We also are happy
to report that we are finding the ldquogrow our ownrdquo approach successful
We just hired our first official intern who has now graduated as a full-time
member of our engineering staff Leading the team in complex project execution
Be a step closer to higher level
Training on key technologies provides a hands on experience to our team and
who doesnrsquot wish to have a team that excels in internal activities thus enabling
us to raise above the rest They provide us the edge in representing ourselves
as the most wanted vendor to our clients
When engineers elevate their skills they bring more confidence energy and
enthusiasm into work They better their execution at all levels of activities This
perhaps is the most important internal factor why few organization are ahead
of othershellip
Recent Achievements
Christ University- Bangalore
Group of international students
were part of our internship
program hailing from Korea
Orane was one of the chosen
vendors to deliver internal training
and also internship for these
young engineers We are happy to
inform our success because we
see couple of them hired into
prominent positions in MNCs as a
key member in project execution
Training Internship
Focused Training on Data
Analytics Business Intelligence-
Data warehousing
Tools Tableau Qlikview Power BI
Page 3 of 14
Contents
Upcoming Events 1
May 1 1
May 31 1
June 17 1
Work In Progress 1
Most Important 2
Recent Achievements 2
Christ University- Bangalore 2
Training Internship 2
Be a step closer to higher level 2
T SQL 4
SSRS 4
Qlikview- Basics 5
Business Dashboard Fundamentals 7
Access Training 8
Advance Access Programming 10
Other Courses We Offer 11
Orane Projects 13
Orane- Services 14
Page 4 of 14
T SQL
SQL (Structured Query Language) is a non-procedural language for querying and modifying data in the database SQL
allow you to define select modify data and also allow the control access to them SQL commands can be embedded
in programs written in other languages as CC++ Java PHP and Python SQL encompassed several components of
which the most important are DDL - Data Description Language and DML Data Manipulation Language
This is a T-SQL training dedicated to all developers beginners and advanced covering the main areas of T-SQL language
starting from the simple operations like select insert update create delete and ending with advanced operations
such as procedures functions triggers and views The entire course consists of 22 modules of 50 hrs dedicated
training
Figure 1 T-SQL Course details amp Hours
SSRS
SQL Server Reporting Services (SSRS) is a server-based report generating software system from Microsoft It is part of suite of Microsoft SQL Server services including SSAS (SQL Server Analysis Services) and SSIS (SQL Server Integration Services) SSRS is a full-featured application that provides report design development testing and deployment of reports by the use of Business Intelligence Development Studio (BIDS) developer tool for all its operations Below are the stages of SQL Server Reporting Services we are going to cover in this article
1 Architecture 2 Installation 3 Role of Business Intelligence Development Studio (BIDS) 4 Report Creation with the Wizard 5 Report Creation with the Report Designer 6 Reports Deployment 7 Security Configuration
3 2 2
4
2 1 2 2 34
2 2 1 2 2 1 2 2
43 3 1 1 1
CHAPTERS
T- SQL- Course Details
Capter 1 Query Query Select ANY Chapter 2 Insert| Delete| Update Insert Delete
Chapter 3 Table Create Table DROP TABLE Chapter 4 Table Join Table Join Self join
Chapter 5 Data Types bigint nchar Chapter 6 Set Operations EXCEPT Union
Chapter 7 Constraints Constraints Create Default Chapter 8 Subquery Subquery Inline view
Chapter 9 Aggregate Functions Aggregate function Min Chapter 10 Date Functions CURRENT_TIMESTAMP DATEPART
Chapter 11 Math Fucntions ABS LOG10 Chapter 12 String Functions ASCII REPLACE
Page 5 of 14
Figure 2 SSRS- Course Details amp Hours
Qlikview- Basics
Qlik- is a leader in data discovery delivering intuitive solutions for self-service data visualization and guided analytics Approximately 33000 customers rely on Qlik solutions to gain meaning out of information from varied sources exploring the hidden relationships within data that lead to insights that ignite good ideas
Control Create business-driven data discoveries with guided analysis paths that are highly customizable and
tightly governed
o Guided analytics Beautiful controlled analytic experiences guide employees toward discovering
insights and making meaningful decisions
o Secure Top-down control of analytics apps permissions and data management
o Centralized Apps Granular control of dashboards layouts and design
Flexibility Build the exact tools you need for your organization and teams
o Customizable Develop custom apps with QlikView scripting and extend development with QlikView
Workbench
o Combinable Integrate QlikView into your business applications and system management software
with extensive APIs
o Global SearchUse natural search to navigate complex information to accelerate discovery
Consistency Provide one set of data and apps for use across your entire organization
o Data integration Unify data sources for a complete view of information centrally managed data and
apps make it easier to discover insights
0
05
1
15
2
25
3
35
Intr
o t
o F
eatu
res
SSR
S A
rch
ite
chu
re
Rep
ort
ing
Serv
er P
roje
cts
Cre
atin
g Ta
bu
lar
Rep
ort
Ad
din
g C
on
tro
ls
Cre
atin
g Li
st R
epo
rt
Cre
atin
g Ex
pre
ssio
ns
Glo
bal
Co
llect
ion
s
Form
atti
ng
Cre
atin
g G
rou
ps
Cal
cula
tin
g To
tals
Inte
ract
ive
Sort
ing
Cre
atin
g P
aram
ete
rs
Dro
p D
ow
n L
ist
Par
amet
ers
Pa
ram
ete
r So
rtin
g
Cre
atin
g M
atri
x R
ep
ort
s
SSR
S 20
08
Mat
rix
Feat
ure
s
Cre
atin
g A
Ch
art
Ad
din
g G
auge
s
Dep
loy
Rep
ort
s
Rep
ort
Man
ager
Rep
ort
ing
Serv
ice
s Se
curi
ty
SSL
Dat
a So
urc
e S
ecu
rity
Rep
ort
ing
Serv
ice
s A
PIs
Rep
ort
Vie
wer
Co
ntr
ols
Web
Se
rvic
e
Web
Se
rvic
e Su
bsc
rip
tio
n
Cu
sto
m A
ssem
blie
s
Rep
ort
Cac
hin
g
Sub
scri
pti
on
s
Two
Rep
ort
Bu
ilder
s
Cre
atin
g R
ep
ort
s
Ch 1 Ch 2 Ch 3 Ch 4 Ch 5 Ch 6 Ch 7 Ch 8 Ch 9 Ch10
Ch11
Ch12
Ch13 Ch14
Ch15
Ch16
Ch17
Ch18
Ch19
Ch20
Ch21
Ch22
Ch23
Ch24
Ch25
Ch26
Ch27
Ch28
Ch29
Ch30
Ch31
Ch32
Ch33
Ho
urs
Chapters
Page 6 of 14
o Advanced reporting Create and distribute consistent reports and templates plus embed them in
Microsoft Office documents with QlikViewreg NPrinting
o Enterprise scalability The advantages of guided analytics with secure enterprise-level governance of
data and analytics
Figure 3 QV Basics Course Details
Figure 4 QV- Advanced Training course details
0
1
2
3
4
5
6
What Is QlikView Natural Joins Make forEasy Data Models
Filters Selections and KPIs ndash Quick-look
Dashboard Elements
Dig Deep with Charts andGraphs
Dashboard Presentation Isthe Key to Dashboard
Adoption
Ch 1 Ch 2 Ch 3 Ch 4 Ch 5
HO
UR
S
CHAPTERS
Qlikview- Basics
1 1
2 2
3
2
3
2 2 2
1 1
2 2
1
2 2 2
1
3 3
2
1
2 2 2 2
4
CH
1
QL
IKV
IEW
hellip
CH
2
INT
RO
TO
hellip
CH
3
INT
RO
TO
hellip
CH
4
QL
IKV
IEW
hellip
CH
5
LO
AD
ING
hellip
CH
6
CR
EA
TIN
G hellip
CH
7
SC
RIP
TIN
G hellip
CH
8
AD
DIN
G hellip
CH
9
GE
NE
RA
TE
hellip
CH
10
M
AP
PIN
G hellip
CH
11
Q
V D
AT
A hellip
CH
12
Q
V hellip
CH
12
A
DV
hellip
CH
1
US
ING
QV
hellip
CH
2
SH
EE
TS
amp hellip
CH
3
TH
E L
IST
hellip
CH
4
TH
E T
AB
LE
hellip
CH
5
TH
E M
UL
TI hellip
CH
6
TH
E T
EX
T hellip
CH
7
CH
AR
TS
CH
8
MU
LT
I-hellip
CH
9
GU
AG
ES
CH
10
B
UT
TO
NS
CH
11
T
HE
hellip
CH
12
hellip
CH
13
O
TH
ER
hellip
CH
14
S
ET
TIN
GS
hellip
CH
15
R
EP
OR
TS
hellip
P A R T 1 P A R T 2 U S E R I N T E R F A C E D E S I G N I N G
HOURS
Page 7 of 14
Business Dashboard Fundamentals
Ch 1 Visual Perception Dashboard Examples
Why Stats Arent Enough
How to Make Data Beautiful
Demo Eliminating Chart Junk
Summary
Ch 2 Common Charts Basic Data Presentation Methods
Basic Chart Types
Choosing a Chart Type
Advanced Chart Types
Chart Types to Avoid
Summary
Ch 3 Dashboard Planning Dashboard Development Process
Request Process
Prioritization
Documentation
Summary
Ch 4 Dashboard Design Dashboard Design Considerations
Knowing Your Audience
Choosing the Right Data
Dashboard Layout
Summary
Ch 5 Building Dashboards in Excel Part 1 - Working with Data
DEMO Acquiring Data
DEMO Massaging Data
Summary
Ch 6 Building Dashboards in Excel Part 2 - Visualizing Data
DEMO Building Charts
DEMO Building Dashboards
DEMO Building Scorecards
DEMO Preparing for Distribution
Summary
Page 8 of 14
Ch 7 Building Dashboards in Tableau Part 1- Working with Data
DEMO Getting Setup
DEMO Connecting to Data
DEMO Working with Data
Summary
Ch 8 Building Dashboards in Tableau Part 2 - Visualizing Data
DEMO Building Charts
DEMO Building Dashboards
DEMO Formatting
DEMO Sharing Your Work
Summary
Figure 5 Course Outline
Figure 6 Course Details amp Hours
With all the acronyms bandied about in the world of computing its easy to get some terms confused VB stands for Visual Basic and it is not the same as VBA Though both VB and VBA are programming languages derived from BASIC and created by Microsoft they are otherwise very different
VB is a language that enables you to create standalone executable applications that do not even require its users to have Office or Excel loaded onto their computers VBA cannot create standalone applications and it exists within a host application such as Excel and the workbook containing the VBA code For a VBA macro to run its host application workbook must be open This book is about VBA and how it controls Excel
Access Training
Access is an excellent (many would say logical) next step for the analyst who faces an ever-increasing data pool Access
takes very few performance hits with larger datasets It has no predetermined row limitations And it can effectively
manage the relationships between disparate data tables In addition Access comes with tools that help you build your
own distributable applications
Today when we have more data than ever and more demands for complex data analysis power analysts need to add
some tools to their repertoire in order to get away from being simply ldquospreadsheet mechanicsrdquo Thats why this book is
such an important step in the evolution of your skillset Throughout this book not only will you get an introduction to
45 5 5
2
5
22
Ch 1 Ch 2 Ch 3 Ch 4 Ch 5 Ch 6 Ch 7 Ch 8
Hours
Page 9 of 14
Access but youll also learn various ways in which you can use Access to improve your daily data management and
analysis
Figure 7 Access Course Details amp Hours
Part 1- Access Building Blocks| 3 hrs
bull An Introduction to Database Development
bull Getting Started with Access
Part 2- Understanding Access Tables| 8 hrs
bull Creating Access Tables
bull Understanding Table Relationships
bull Working with Access Tables
bull Importing and Exporting Data
bull Linking to External Data
Part 3-Working with Access Queries| 6 hrs
bull Selecting Data with Queries
bull Using Operators and Expressions in Access
Part 4- Analyzing Data in Access| 7 hrs
bull Transforming Data in Access
bull Working with Calculations and Dates
bull Performing Conditional Analyses
bull Fundamentals of Using Access SQL
bull Subqueries and Domain Aggregate Functions
bull Running Descriptive Statistics in Access
Part 5- Working with Access Forms and Reports| 8 hrs
bull Creating Basic Access Forms
bull Working with Data on Access Forms
bull Working with Form Controls
bull Presenting Data with Access Reports
bull Advanced Access Report Techniques
Page 10 of 14
Advance Access Programming
Figure 8 Advanced Access Course details amp Hours
Advanced
Access
Programming
Techniques
10 hrs
Debugging Your Access Applications
-Organizing VBA Code
-Testing Your Applications
-Traditional Debugging Techniques
-Using the Access Debugging Tools
-Trapping Errors in Your Code
Accessing Data with VBA Code
-Working with Data
-Understanding ADO Objects
-Understanding DAO Objects
-Writing VBA Code to Update a Table
Advanced Data Access with VBA
-Adding an Unbound Combo Box to a Form to Find Data
-Filtering a Form
Integrating Access and SQL Server
-Introducing SQL Server Express
-Understanding Data Types in SQL Server
-Installing SQL Server Express
-Connecting to SQL Server
-Working with SQL Server Objects
Customizing the Ribbon
-The Ribbon Hierarchy
-Editing the Default Ribbon
-Working with the Quick Access Toolbar
-Developing Custom Ribbons
-Creating a Custom Ribbon
-The Basic Ribbon XML
-Adding Ribbon Controls
-Attaching Ribbons to Forms and Reports
Completely Removing the Ribbon
Preparing Your Access Application for Distribution
-Defining the Current Database Options
-Developing the Application
-Polishing Your Application
-Bulletproofing an Application
Securing the Environment
Page 11 of 14
Other Courses We Offer
1 Business Intelligence Data warehousing
2 Data Analytics
3 Data Analysis
4 Business Analysis
Tools amp Applications
1 Microsoft Office
a MS-Excel amp Macros (VBA)
b MS-Access amp Macros (VBA)
c VBA for PowerPoint
d Access
e MS Sql Server 2005 2008 2012 2014
f T-SQL Programming
g Sql Server Reporting Services 2005 to 2014
h Power BI (Power Pivots Power View Power Designer Power Maps) 2010 2013 2016
i Statistics using Excel Data Analysis Toolpak
2 Tableau 80 to 93 Desktop Server Online Public Reader
3 Sisense v60 with Elasticube
4 Qlik Tech Products
a Qlikview 11
b Qliksense 22
5 Database
a RDBMS
b SQL
c Dimensional modelling
6 Domain Specific
a Financial Modeling
b Cost Modeling
c Spend Analytics
d Retail Analytics
e HR Analytics
f HealthcarePharma Analytics
g PMO
h Infrastructure Management (ITO)
7 Big Data ndash Hadoop
8 HDFS (Hadoop File System)
9 Oracle
a Oracle BRM
b Oracle suite
10 Technical Writing
Page 12 of 14
11 Business Analysis
12 Project Consulting and academic project assistance and final year project certification
Web amp Mobile Technologies
Web Development Tools amp Applications
1 ASPNET
2 CNET
3 Python
4 D3JS
5 Java scripting
6 JQuery
7 PHP
8 JSP
9 Content Management using WordPress amp Joomla
10 HTML5
11 CSS3
12 Bootstrap
13 Rest API implementation using PHP
14 Google Cloud Messaging Server using PHP
15 APNS server implementation using PHP
16 Additional API Web Connectors creation using Python amp PHP
Mobile Application (All Platforms)
1 AngularJS
2 Server development of Android and iPhone application
3 Mobile Application
4 MySQL
5 SQLite
Testing Modules
1 Black Box Testing
2 White Box Testing
3 Selenium
4 QTP
Page 13 of 14
Orane Projects
Mobile Apps
Mars Telecom- a Hyderabad based IT company providing solutions to various industries across the globe has been kind
to utilize Oranersquos ever efficient and skilled consultants to deliver Mobile application solution that is part of the
Mumbai municipal authority The app was focused on enable the authorities of the MUDA community to effectively
use technology for its project completion and approval online The mobile app was designed to work with Samsun
mobile phones and tablets
Training amp Internship Programs
Christ University- Bangalore is known for its vast knowledge sharing and goodness to accommodate the aspiring
student from across the world to complete their graduate and under-graduate programs By decades of excellence and
mastery into the academic system Christ has carved a niche in the education field Today they also cater to masters
and PhD degrees in variety of subjects Orane is pleased to have been their chosen vendors to deliver internship amp
training program to Korean students under their CART- ldquoCenter for Advance Research and Trainingrdquo department
Website Social Media amp CRM Solutions
Stratum Ventures LLP- A Land Development company based in Bangalore working towards investment properties for
short and long term investors from across the globe Orane shares its gratitude to Stratum Ventures LLP team to have
shortlisted us to deliver their end-to-end IT solution starting from Website to CRM implementation
Orane ndash Global IT Consulting and Services
Industries Served Manufacturing
Energy and Petrochemical
Banking and Finance Government
Services Offered BIDW amp EPM ERP Enterprise Products and Solutions Mobile Device Development Consulting Managed Service Support Testing Maintenance and Upgrade
Value Proposition Relationship driven Business Agility Delivery ROI Quick Response
Page 14 of 14
Orane Intelli Solutions
NA Chambers 1st Floor
3 J 7th C Main Road 3rd Block
3rd Cross Road Koramangala
Bangalore-560034
Email infooranetechcom| Web wwworanetechcom| Ph +91 80 4145 6644
Large- Enterprise Solutions
Big Data
Data Visualization
BI DW
ERP
Enterprise Mobile App
Enterprise Solutions for Medium Scale
Data Visualization
Analytics
ERP- Standalone Cloud
Application Dev
Mobile apps
Small Industries
Cloud Solutions Application Dev Enterprise Portals Mobile apps
Orane- Services
Offshore Development Centers | Outsourced Product Development | Staff Augmentation |Trainings
Fact Sheet
Orane founded in year 2011- primarily focused in providing Business Intelligence and ERP solutions Headquartered in Bangalore having strong alliance across various geographies Strong and experienced management with several years of industry experience and solid leadership Ensuring quality delivery and support Projects Completed Al-Shirawi Ent Modern Plastics Industry Kanva Fashions The Address Makers
In the pipeline SCANIA Bangalore Bristle Cone Bataviarsquos Textile Live-in- Space Pvt Ltd etc
Value Proposition Relationship
driven Business
Agility
Page 3 of 14
Contents
Upcoming Events 1
May 1 1
May 31 1
June 17 1
Work In Progress 1
Most Important 2
Recent Achievements 2
Christ University- Bangalore 2
Training Internship 2
Be a step closer to higher level 2
T SQL 4
SSRS 4
Qlikview- Basics 5
Business Dashboard Fundamentals 7
Access Training 8
Advance Access Programming 10
Other Courses We Offer 11
Orane Projects 13
Orane- Services 14
Page 4 of 14
T SQL
SQL (Structured Query Language) is a non-procedural language for querying and modifying data in the database SQL
allow you to define select modify data and also allow the control access to them SQL commands can be embedded
in programs written in other languages as CC++ Java PHP and Python SQL encompassed several components of
which the most important are DDL - Data Description Language and DML Data Manipulation Language
This is a T-SQL training dedicated to all developers beginners and advanced covering the main areas of T-SQL language
starting from the simple operations like select insert update create delete and ending with advanced operations
such as procedures functions triggers and views The entire course consists of 22 modules of 50 hrs dedicated
training
Figure 1 T-SQL Course details amp Hours
SSRS
SQL Server Reporting Services (SSRS) is a server-based report generating software system from Microsoft It is part of suite of Microsoft SQL Server services including SSAS (SQL Server Analysis Services) and SSIS (SQL Server Integration Services) SSRS is a full-featured application that provides report design development testing and deployment of reports by the use of Business Intelligence Development Studio (BIDS) developer tool for all its operations Below are the stages of SQL Server Reporting Services we are going to cover in this article
1 Architecture 2 Installation 3 Role of Business Intelligence Development Studio (BIDS) 4 Report Creation with the Wizard 5 Report Creation with the Report Designer 6 Reports Deployment 7 Security Configuration
3 2 2
4
2 1 2 2 34
2 2 1 2 2 1 2 2
43 3 1 1 1
CHAPTERS
T- SQL- Course Details
Capter 1 Query Query Select ANY Chapter 2 Insert| Delete| Update Insert Delete
Chapter 3 Table Create Table DROP TABLE Chapter 4 Table Join Table Join Self join
Chapter 5 Data Types bigint nchar Chapter 6 Set Operations EXCEPT Union
Chapter 7 Constraints Constraints Create Default Chapter 8 Subquery Subquery Inline view
Chapter 9 Aggregate Functions Aggregate function Min Chapter 10 Date Functions CURRENT_TIMESTAMP DATEPART
Chapter 11 Math Fucntions ABS LOG10 Chapter 12 String Functions ASCII REPLACE
Page 5 of 14
Figure 2 SSRS- Course Details amp Hours
Qlikview- Basics
Qlik- is a leader in data discovery delivering intuitive solutions for self-service data visualization and guided analytics Approximately 33000 customers rely on Qlik solutions to gain meaning out of information from varied sources exploring the hidden relationships within data that lead to insights that ignite good ideas
Control Create business-driven data discoveries with guided analysis paths that are highly customizable and
tightly governed
o Guided analytics Beautiful controlled analytic experiences guide employees toward discovering
insights and making meaningful decisions
o Secure Top-down control of analytics apps permissions and data management
o Centralized Apps Granular control of dashboards layouts and design
Flexibility Build the exact tools you need for your organization and teams
o Customizable Develop custom apps with QlikView scripting and extend development with QlikView
Workbench
o Combinable Integrate QlikView into your business applications and system management software
with extensive APIs
o Global SearchUse natural search to navigate complex information to accelerate discovery
Consistency Provide one set of data and apps for use across your entire organization
o Data integration Unify data sources for a complete view of information centrally managed data and
apps make it easier to discover insights
0
05
1
15
2
25
3
35
Intr
o t
o F
eatu
res
SSR
S A
rch
ite
chu
re
Rep
ort
ing
Serv
er P
roje
cts
Cre
atin
g Ta
bu
lar
Rep
ort
Ad
din
g C
on
tro
ls
Cre
atin
g Li
st R
epo
rt
Cre
atin
g Ex
pre
ssio
ns
Glo
bal
Co
llect
ion
s
Form
atti
ng
Cre
atin
g G
rou
ps
Cal
cula
tin
g To
tals
Inte
ract
ive
Sort
ing
Cre
atin
g P
aram
ete
rs
Dro
p D
ow
n L
ist
Par
amet
ers
Pa
ram
ete
r So
rtin
g
Cre
atin
g M
atri
x R
ep
ort
s
SSR
S 20
08
Mat
rix
Feat
ure
s
Cre
atin
g A
Ch
art
Ad
din
g G
auge
s
Dep
loy
Rep
ort
s
Rep
ort
Man
ager
Rep
ort
ing
Serv
ice
s Se
curi
ty
SSL
Dat
a So
urc
e S
ecu
rity
Rep
ort
ing
Serv
ice
s A
PIs
Rep
ort
Vie
wer
Co
ntr
ols
Web
Se
rvic
e
Web
Se
rvic
e Su
bsc
rip
tio
n
Cu
sto
m A
ssem
blie
s
Rep
ort
Cac
hin
g
Sub
scri
pti
on
s
Two
Rep
ort
Bu
ilder
s
Cre
atin
g R
ep
ort
s
Ch 1 Ch 2 Ch 3 Ch 4 Ch 5 Ch 6 Ch 7 Ch 8 Ch 9 Ch10
Ch11
Ch12
Ch13 Ch14
Ch15
Ch16
Ch17
Ch18
Ch19
Ch20
Ch21
Ch22
Ch23
Ch24
Ch25
Ch26
Ch27
Ch28
Ch29
Ch30
Ch31
Ch32
Ch33
Ho
urs
Chapters
Page 6 of 14
o Advanced reporting Create and distribute consistent reports and templates plus embed them in
Microsoft Office documents with QlikViewreg NPrinting
o Enterprise scalability The advantages of guided analytics with secure enterprise-level governance of
data and analytics
Figure 3 QV Basics Course Details
Figure 4 QV- Advanced Training course details
0
1
2
3
4
5
6
What Is QlikView Natural Joins Make forEasy Data Models
Filters Selections and KPIs ndash Quick-look
Dashboard Elements
Dig Deep with Charts andGraphs
Dashboard Presentation Isthe Key to Dashboard
Adoption
Ch 1 Ch 2 Ch 3 Ch 4 Ch 5
HO
UR
S
CHAPTERS
Qlikview- Basics
1 1
2 2
3
2
3
2 2 2
1 1
2 2
1
2 2 2
1
3 3
2
1
2 2 2 2
4
CH
1
QL
IKV
IEW
hellip
CH
2
INT
RO
TO
hellip
CH
3
INT
RO
TO
hellip
CH
4
QL
IKV
IEW
hellip
CH
5
LO
AD
ING
hellip
CH
6
CR
EA
TIN
G hellip
CH
7
SC
RIP
TIN
G hellip
CH
8
AD
DIN
G hellip
CH
9
GE
NE
RA
TE
hellip
CH
10
M
AP
PIN
G hellip
CH
11
Q
V D
AT
A hellip
CH
12
Q
V hellip
CH
12
A
DV
hellip
CH
1
US
ING
QV
hellip
CH
2
SH
EE
TS
amp hellip
CH
3
TH
E L
IST
hellip
CH
4
TH
E T
AB
LE
hellip
CH
5
TH
E M
UL
TI hellip
CH
6
TH
E T
EX
T hellip
CH
7
CH
AR
TS
CH
8
MU
LT
I-hellip
CH
9
GU
AG
ES
CH
10
B
UT
TO
NS
CH
11
T
HE
hellip
CH
12
hellip
CH
13
O
TH
ER
hellip
CH
14
S
ET
TIN
GS
hellip
CH
15
R
EP
OR
TS
hellip
P A R T 1 P A R T 2 U S E R I N T E R F A C E D E S I G N I N G
HOURS
Page 7 of 14
Business Dashboard Fundamentals
Ch 1 Visual Perception Dashboard Examples
Why Stats Arent Enough
How to Make Data Beautiful
Demo Eliminating Chart Junk
Summary
Ch 2 Common Charts Basic Data Presentation Methods
Basic Chart Types
Choosing a Chart Type
Advanced Chart Types
Chart Types to Avoid
Summary
Ch 3 Dashboard Planning Dashboard Development Process
Request Process
Prioritization
Documentation
Summary
Ch 4 Dashboard Design Dashboard Design Considerations
Knowing Your Audience
Choosing the Right Data
Dashboard Layout
Summary
Ch 5 Building Dashboards in Excel Part 1 - Working with Data
DEMO Acquiring Data
DEMO Massaging Data
Summary
Ch 6 Building Dashboards in Excel Part 2 - Visualizing Data
DEMO Building Charts
DEMO Building Dashboards
DEMO Building Scorecards
DEMO Preparing for Distribution
Summary
Page 8 of 14
Ch 7 Building Dashboards in Tableau Part 1- Working with Data
DEMO Getting Setup
DEMO Connecting to Data
DEMO Working with Data
Summary
Ch 8 Building Dashboards in Tableau Part 2 - Visualizing Data
DEMO Building Charts
DEMO Building Dashboards
DEMO Formatting
DEMO Sharing Your Work
Summary
Figure 5 Course Outline
Figure 6 Course Details amp Hours
With all the acronyms bandied about in the world of computing its easy to get some terms confused VB stands for Visual Basic and it is not the same as VBA Though both VB and VBA are programming languages derived from BASIC and created by Microsoft they are otherwise very different
VB is a language that enables you to create standalone executable applications that do not even require its users to have Office or Excel loaded onto their computers VBA cannot create standalone applications and it exists within a host application such as Excel and the workbook containing the VBA code For a VBA macro to run its host application workbook must be open This book is about VBA and how it controls Excel
Access Training
Access is an excellent (many would say logical) next step for the analyst who faces an ever-increasing data pool Access
takes very few performance hits with larger datasets It has no predetermined row limitations And it can effectively
manage the relationships between disparate data tables In addition Access comes with tools that help you build your
own distributable applications
Today when we have more data than ever and more demands for complex data analysis power analysts need to add
some tools to their repertoire in order to get away from being simply ldquospreadsheet mechanicsrdquo Thats why this book is
such an important step in the evolution of your skillset Throughout this book not only will you get an introduction to
45 5 5
2
5
22
Ch 1 Ch 2 Ch 3 Ch 4 Ch 5 Ch 6 Ch 7 Ch 8
Hours
Page 9 of 14
Access but youll also learn various ways in which you can use Access to improve your daily data management and
analysis
Figure 7 Access Course Details amp Hours
Part 1- Access Building Blocks| 3 hrs
bull An Introduction to Database Development
bull Getting Started with Access
Part 2- Understanding Access Tables| 8 hrs
bull Creating Access Tables
bull Understanding Table Relationships
bull Working with Access Tables
bull Importing and Exporting Data
bull Linking to External Data
Part 3-Working with Access Queries| 6 hrs
bull Selecting Data with Queries
bull Using Operators and Expressions in Access
Part 4- Analyzing Data in Access| 7 hrs
bull Transforming Data in Access
bull Working with Calculations and Dates
bull Performing Conditional Analyses
bull Fundamentals of Using Access SQL
bull Subqueries and Domain Aggregate Functions
bull Running Descriptive Statistics in Access
Part 5- Working with Access Forms and Reports| 8 hrs
bull Creating Basic Access Forms
bull Working with Data on Access Forms
bull Working with Form Controls
bull Presenting Data with Access Reports
bull Advanced Access Report Techniques
Page 10 of 14
Advance Access Programming
Figure 8 Advanced Access Course details amp Hours
Advanced
Access
Programming
Techniques
10 hrs
Debugging Your Access Applications
-Organizing VBA Code
-Testing Your Applications
-Traditional Debugging Techniques
-Using the Access Debugging Tools
-Trapping Errors in Your Code
Accessing Data with VBA Code
-Working with Data
-Understanding ADO Objects
-Understanding DAO Objects
-Writing VBA Code to Update a Table
Advanced Data Access with VBA
-Adding an Unbound Combo Box to a Form to Find Data
-Filtering a Form
Integrating Access and SQL Server
-Introducing SQL Server Express
-Understanding Data Types in SQL Server
-Installing SQL Server Express
-Connecting to SQL Server
-Working with SQL Server Objects
Customizing the Ribbon
-The Ribbon Hierarchy
-Editing the Default Ribbon
-Working with the Quick Access Toolbar
-Developing Custom Ribbons
-Creating a Custom Ribbon
-The Basic Ribbon XML
-Adding Ribbon Controls
-Attaching Ribbons to Forms and Reports
Completely Removing the Ribbon
Preparing Your Access Application for Distribution
-Defining the Current Database Options
-Developing the Application
-Polishing Your Application
-Bulletproofing an Application
Securing the Environment
Page 11 of 14
Other Courses We Offer
1 Business Intelligence Data warehousing
2 Data Analytics
3 Data Analysis
4 Business Analysis
Tools amp Applications
1 Microsoft Office
a MS-Excel amp Macros (VBA)
b MS-Access amp Macros (VBA)
c VBA for PowerPoint
d Access
e MS Sql Server 2005 2008 2012 2014
f T-SQL Programming
g Sql Server Reporting Services 2005 to 2014
h Power BI (Power Pivots Power View Power Designer Power Maps) 2010 2013 2016
i Statistics using Excel Data Analysis Toolpak
2 Tableau 80 to 93 Desktop Server Online Public Reader
3 Sisense v60 with Elasticube
4 Qlik Tech Products
a Qlikview 11
b Qliksense 22
5 Database
a RDBMS
b SQL
c Dimensional modelling
6 Domain Specific
a Financial Modeling
b Cost Modeling
c Spend Analytics
d Retail Analytics
e HR Analytics
f HealthcarePharma Analytics
g PMO
h Infrastructure Management (ITO)
7 Big Data ndash Hadoop
8 HDFS (Hadoop File System)
9 Oracle
a Oracle BRM
b Oracle suite
10 Technical Writing
Page 12 of 14
11 Business Analysis
12 Project Consulting and academic project assistance and final year project certification
Web amp Mobile Technologies
Web Development Tools amp Applications
1 ASPNET
2 CNET
3 Python
4 D3JS
5 Java scripting
6 JQuery
7 PHP
8 JSP
9 Content Management using WordPress amp Joomla
10 HTML5
11 CSS3
12 Bootstrap
13 Rest API implementation using PHP
14 Google Cloud Messaging Server using PHP
15 APNS server implementation using PHP
16 Additional API Web Connectors creation using Python amp PHP
Mobile Application (All Platforms)
1 AngularJS
2 Server development of Android and iPhone application
3 Mobile Application
4 MySQL
5 SQLite
Testing Modules
1 Black Box Testing
2 White Box Testing
3 Selenium
4 QTP
Page 13 of 14
Orane Projects
Mobile Apps
Mars Telecom- a Hyderabad based IT company providing solutions to various industries across the globe has been kind
to utilize Oranersquos ever efficient and skilled consultants to deliver Mobile application solution that is part of the
Mumbai municipal authority The app was focused on enable the authorities of the MUDA community to effectively
use technology for its project completion and approval online The mobile app was designed to work with Samsun
mobile phones and tablets
Training amp Internship Programs
Christ University- Bangalore is known for its vast knowledge sharing and goodness to accommodate the aspiring
student from across the world to complete their graduate and under-graduate programs By decades of excellence and
mastery into the academic system Christ has carved a niche in the education field Today they also cater to masters
and PhD degrees in variety of subjects Orane is pleased to have been their chosen vendors to deliver internship amp
training program to Korean students under their CART- ldquoCenter for Advance Research and Trainingrdquo department
Website Social Media amp CRM Solutions
Stratum Ventures LLP- A Land Development company based in Bangalore working towards investment properties for
short and long term investors from across the globe Orane shares its gratitude to Stratum Ventures LLP team to have
shortlisted us to deliver their end-to-end IT solution starting from Website to CRM implementation
Orane ndash Global IT Consulting and Services
Industries Served Manufacturing
Energy and Petrochemical
Banking and Finance Government
Services Offered BIDW amp EPM ERP Enterprise Products and Solutions Mobile Device Development Consulting Managed Service Support Testing Maintenance and Upgrade
Value Proposition Relationship driven Business Agility Delivery ROI Quick Response
Page 14 of 14
Orane Intelli Solutions
NA Chambers 1st Floor
3 J 7th C Main Road 3rd Block
3rd Cross Road Koramangala
Bangalore-560034
Email infooranetechcom| Web wwworanetechcom| Ph +91 80 4145 6644
Large- Enterprise Solutions
Big Data
Data Visualization
BI DW
ERP
Enterprise Mobile App
Enterprise Solutions for Medium Scale
Data Visualization
Analytics
ERP- Standalone Cloud
Application Dev
Mobile apps
Small Industries
Cloud Solutions Application Dev Enterprise Portals Mobile apps
Orane- Services
Offshore Development Centers | Outsourced Product Development | Staff Augmentation |Trainings
Fact Sheet
Orane founded in year 2011- primarily focused in providing Business Intelligence and ERP solutions Headquartered in Bangalore having strong alliance across various geographies Strong and experienced management with several years of industry experience and solid leadership Ensuring quality delivery and support Projects Completed Al-Shirawi Ent Modern Plastics Industry Kanva Fashions The Address Makers
In the pipeline SCANIA Bangalore Bristle Cone Bataviarsquos Textile Live-in- Space Pvt Ltd etc
Value Proposition Relationship
driven Business
Agility
Page 4 of 14
T SQL
SQL (Structured Query Language) is a non-procedural language for querying and modifying data in the database SQL
allow you to define select modify data and also allow the control access to them SQL commands can be embedded
in programs written in other languages as CC++ Java PHP and Python SQL encompassed several components of
which the most important are DDL - Data Description Language and DML Data Manipulation Language
This is a T-SQL training dedicated to all developers beginners and advanced covering the main areas of T-SQL language
starting from the simple operations like select insert update create delete and ending with advanced operations
such as procedures functions triggers and views The entire course consists of 22 modules of 50 hrs dedicated
training
Figure 1 T-SQL Course details amp Hours
SSRS
SQL Server Reporting Services (SSRS) is a server-based report generating software system from Microsoft It is part of suite of Microsoft SQL Server services including SSAS (SQL Server Analysis Services) and SSIS (SQL Server Integration Services) SSRS is a full-featured application that provides report design development testing and deployment of reports by the use of Business Intelligence Development Studio (BIDS) developer tool for all its operations Below are the stages of SQL Server Reporting Services we are going to cover in this article
1 Architecture 2 Installation 3 Role of Business Intelligence Development Studio (BIDS) 4 Report Creation with the Wizard 5 Report Creation with the Report Designer 6 Reports Deployment 7 Security Configuration
3 2 2
4
2 1 2 2 34
2 2 1 2 2 1 2 2
43 3 1 1 1
CHAPTERS
T- SQL- Course Details
Capter 1 Query Query Select ANY Chapter 2 Insert| Delete| Update Insert Delete
Chapter 3 Table Create Table DROP TABLE Chapter 4 Table Join Table Join Self join
Chapter 5 Data Types bigint nchar Chapter 6 Set Operations EXCEPT Union
Chapter 7 Constraints Constraints Create Default Chapter 8 Subquery Subquery Inline view
Chapter 9 Aggregate Functions Aggregate function Min Chapter 10 Date Functions CURRENT_TIMESTAMP DATEPART
Chapter 11 Math Fucntions ABS LOG10 Chapter 12 String Functions ASCII REPLACE
Page 5 of 14
Figure 2 SSRS- Course Details amp Hours
Qlikview- Basics
Qlik- is a leader in data discovery delivering intuitive solutions for self-service data visualization and guided analytics Approximately 33000 customers rely on Qlik solutions to gain meaning out of information from varied sources exploring the hidden relationships within data that lead to insights that ignite good ideas
Control Create business-driven data discoveries with guided analysis paths that are highly customizable and
tightly governed
o Guided analytics Beautiful controlled analytic experiences guide employees toward discovering
insights and making meaningful decisions
o Secure Top-down control of analytics apps permissions and data management
o Centralized Apps Granular control of dashboards layouts and design
Flexibility Build the exact tools you need for your organization and teams
o Customizable Develop custom apps with QlikView scripting and extend development with QlikView
Workbench
o Combinable Integrate QlikView into your business applications and system management software
with extensive APIs
o Global SearchUse natural search to navigate complex information to accelerate discovery
Consistency Provide one set of data and apps for use across your entire organization
o Data integration Unify data sources for a complete view of information centrally managed data and
apps make it easier to discover insights
0
05
1
15
2
25
3
35
Intr
o t
o F
eatu
res
SSR
S A
rch
ite
chu
re
Rep
ort
ing
Serv
er P
roje
cts
Cre
atin
g Ta
bu
lar
Rep
ort
Ad
din
g C
on
tro
ls
Cre
atin
g Li
st R
epo
rt
Cre
atin
g Ex
pre
ssio
ns
Glo
bal
Co
llect
ion
s
Form
atti
ng
Cre
atin
g G
rou
ps
Cal
cula
tin
g To
tals
Inte
ract
ive
Sort
ing
Cre
atin
g P
aram
ete
rs
Dro
p D
ow
n L
ist
Par
amet
ers
Pa
ram
ete
r So
rtin
g
Cre
atin
g M
atri
x R
ep
ort
s
SSR
S 20
08
Mat
rix
Feat
ure
s
Cre
atin
g A
Ch
art
Ad
din
g G
auge
s
Dep
loy
Rep
ort
s
Rep
ort
Man
ager
Rep
ort
ing
Serv
ice
s Se
curi
ty
SSL
Dat
a So
urc
e S
ecu
rity
Rep
ort
ing
Serv
ice
s A
PIs
Rep
ort
Vie
wer
Co
ntr
ols
Web
Se
rvic
e
Web
Se
rvic
e Su
bsc
rip
tio
n
Cu
sto
m A
ssem
blie
s
Rep
ort
Cac
hin
g
Sub
scri
pti
on
s
Two
Rep
ort
Bu
ilder
s
Cre
atin
g R
ep
ort
s
Ch 1 Ch 2 Ch 3 Ch 4 Ch 5 Ch 6 Ch 7 Ch 8 Ch 9 Ch10
Ch11
Ch12
Ch13 Ch14
Ch15
Ch16
Ch17
Ch18
Ch19
Ch20
Ch21
Ch22
Ch23
Ch24
Ch25
Ch26
Ch27
Ch28
Ch29
Ch30
Ch31
Ch32
Ch33
Ho
urs
Chapters
Page 6 of 14
o Advanced reporting Create and distribute consistent reports and templates plus embed them in
Microsoft Office documents with QlikViewreg NPrinting
o Enterprise scalability The advantages of guided analytics with secure enterprise-level governance of
data and analytics
Figure 3 QV Basics Course Details
Figure 4 QV- Advanced Training course details
0
1
2
3
4
5
6
What Is QlikView Natural Joins Make forEasy Data Models
Filters Selections and KPIs ndash Quick-look
Dashboard Elements
Dig Deep with Charts andGraphs
Dashboard Presentation Isthe Key to Dashboard
Adoption
Ch 1 Ch 2 Ch 3 Ch 4 Ch 5
HO
UR
S
CHAPTERS
Qlikview- Basics
1 1
2 2
3
2
3
2 2 2
1 1
2 2
1
2 2 2
1
3 3
2
1
2 2 2 2
4
CH
1
QL
IKV
IEW
hellip
CH
2
INT
RO
TO
hellip
CH
3
INT
RO
TO
hellip
CH
4
QL
IKV
IEW
hellip
CH
5
LO
AD
ING
hellip
CH
6
CR
EA
TIN
G hellip
CH
7
SC
RIP
TIN
G hellip
CH
8
AD
DIN
G hellip
CH
9
GE
NE
RA
TE
hellip
CH
10
M
AP
PIN
G hellip
CH
11
Q
V D
AT
A hellip
CH
12
Q
V hellip
CH
12
A
DV
hellip
CH
1
US
ING
QV
hellip
CH
2
SH
EE
TS
amp hellip
CH
3
TH
E L
IST
hellip
CH
4
TH
E T
AB
LE
hellip
CH
5
TH
E M
UL
TI hellip
CH
6
TH
E T
EX
T hellip
CH
7
CH
AR
TS
CH
8
MU
LT
I-hellip
CH
9
GU
AG
ES
CH
10
B
UT
TO
NS
CH
11
T
HE
hellip
CH
12
hellip
CH
13
O
TH
ER
hellip
CH
14
S
ET
TIN
GS
hellip
CH
15
R
EP
OR
TS
hellip
P A R T 1 P A R T 2 U S E R I N T E R F A C E D E S I G N I N G
HOURS
Page 7 of 14
Business Dashboard Fundamentals
Ch 1 Visual Perception Dashboard Examples
Why Stats Arent Enough
How to Make Data Beautiful
Demo Eliminating Chart Junk
Summary
Ch 2 Common Charts Basic Data Presentation Methods
Basic Chart Types
Choosing a Chart Type
Advanced Chart Types
Chart Types to Avoid
Summary
Ch 3 Dashboard Planning Dashboard Development Process
Request Process
Prioritization
Documentation
Summary
Ch 4 Dashboard Design Dashboard Design Considerations
Knowing Your Audience
Choosing the Right Data
Dashboard Layout
Summary
Ch 5 Building Dashboards in Excel Part 1 - Working with Data
DEMO Acquiring Data
DEMO Massaging Data
Summary
Ch 6 Building Dashboards in Excel Part 2 - Visualizing Data
DEMO Building Charts
DEMO Building Dashboards
DEMO Building Scorecards
DEMO Preparing for Distribution
Summary
Page 8 of 14
Ch 7 Building Dashboards in Tableau Part 1- Working with Data
DEMO Getting Setup
DEMO Connecting to Data
DEMO Working with Data
Summary
Ch 8 Building Dashboards in Tableau Part 2 - Visualizing Data
DEMO Building Charts
DEMO Building Dashboards
DEMO Formatting
DEMO Sharing Your Work
Summary
Figure 5 Course Outline
Figure 6 Course Details amp Hours
With all the acronyms bandied about in the world of computing its easy to get some terms confused VB stands for Visual Basic and it is not the same as VBA Though both VB and VBA are programming languages derived from BASIC and created by Microsoft they are otherwise very different
VB is a language that enables you to create standalone executable applications that do not even require its users to have Office or Excel loaded onto their computers VBA cannot create standalone applications and it exists within a host application such as Excel and the workbook containing the VBA code For a VBA macro to run its host application workbook must be open This book is about VBA and how it controls Excel
Access Training
Access is an excellent (many would say logical) next step for the analyst who faces an ever-increasing data pool Access
takes very few performance hits with larger datasets It has no predetermined row limitations And it can effectively
manage the relationships between disparate data tables In addition Access comes with tools that help you build your
own distributable applications
Today when we have more data than ever and more demands for complex data analysis power analysts need to add
some tools to their repertoire in order to get away from being simply ldquospreadsheet mechanicsrdquo Thats why this book is
such an important step in the evolution of your skillset Throughout this book not only will you get an introduction to
45 5 5
2
5
22
Ch 1 Ch 2 Ch 3 Ch 4 Ch 5 Ch 6 Ch 7 Ch 8
Hours
Page 9 of 14
Access but youll also learn various ways in which you can use Access to improve your daily data management and
analysis
Figure 7 Access Course Details amp Hours
Part 1- Access Building Blocks| 3 hrs
bull An Introduction to Database Development
bull Getting Started with Access
Part 2- Understanding Access Tables| 8 hrs
bull Creating Access Tables
bull Understanding Table Relationships
bull Working with Access Tables
bull Importing and Exporting Data
bull Linking to External Data
Part 3-Working with Access Queries| 6 hrs
bull Selecting Data with Queries
bull Using Operators and Expressions in Access
Part 4- Analyzing Data in Access| 7 hrs
bull Transforming Data in Access
bull Working with Calculations and Dates
bull Performing Conditional Analyses
bull Fundamentals of Using Access SQL
bull Subqueries and Domain Aggregate Functions
bull Running Descriptive Statistics in Access
Part 5- Working with Access Forms and Reports| 8 hrs
bull Creating Basic Access Forms
bull Working with Data on Access Forms
bull Working with Form Controls
bull Presenting Data with Access Reports
bull Advanced Access Report Techniques
Page 10 of 14
Advance Access Programming
Figure 8 Advanced Access Course details amp Hours
Advanced
Access
Programming
Techniques
10 hrs
Debugging Your Access Applications
-Organizing VBA Code
-Testing Your Applications
-Traditional Debugging Techniques
-Using the Access Debugging Tools
-Trapping Errors in Your Code
Accessing Data with VBA Code
-Working with Data
-Understanding ADO Objects
-Understanding DAO Objects
-Writing VBA Code to Update a Table
Advanced Data Access with VBA
-Adding an Unbound Combo Box to a Form to Find Data
-Filtering a Form
Integrating Access and SQL Server
-Introducing SQL Server Express
-Understanding Data Types in SQL Server
-Installing SQL Server Express
-Connecting to SQL Server
-Working with SQL Server Objects
Customizing the Ribbon
-The Ribbon Hierarchy
-Editing the Default Ribbon
-Working with the Quick Access Toolbar
-Developing Custom Ribbons
-Creating a Custom Ribbon
-The Basic Ribbon XML
-Adding Ribbon Controls
-Attaching Ribbons to Forms and Reports
Completely Removing the Ribbon
Preparing Your Access Application for Distribution
-Defining the Current Database Options
-Developing the Application
-Polishing Your Application
-Bulletproofing an Application
Securing the Environment
Page 11 of 14
Other Courses We Offer
1 Business Intelligence Data warehousing
2 Data Analytics
3 Data Analysis
4 Business Analysis
Tools amp Applications
1 Microsoft Office
a MS-Excel amp Macros (VBA)
b MS-Access amp Macros (VBA)
c VBA for PowerPoint
d Access
e MS Sql Server 2005 2008 2012 2014
f T-SQL Programming
g Sql Server Reporting Services 2005 to 2014
h Power BI (Power Pivots Power View Power Designer Power Maps) 2010 2013 2016
i Statistics using Excel Data Analysis Toolpak
2 Tableau 80 to 93 Desktop Server Online Public Reader
3 Sisense v60 with Elasticube
4 Qlik Tech Products
a Qlikview 11
b Qliksense 22
5 Database
a RDBMS
b SQL
c Dimensional modelling
6 Domain Specific
a Financial Modeling
b Cost Modeling
c Spend Analytics
d Retail Analytics
e HR Analytics
f HealthcarePharma Analytics
g PMO
h Infrastructure Management (ITO)
7 Big Data ndash Hadoop
8 HDFS (Hadoop File System)
9 Oracle
a Oracle BRM
b Oracle suite
10 Technical Writing
Page 12 of 14
11 Business Analysis
12 Project Consulting and academic project assistance and final year project certification
Web amp Mobile Technologies
Web Development Tools amp Applications
1 ASPNET
2 CNET
3 Python
4 D3JS
5 Java scripting
6 JQuery
7 PHP
8 JSP
9 Content Management using WordPress amp Joomla
10 HTML5
11 CSS3
12 Bootstrap
13 Rest API implementation using PHP
14 Google Cloud Messaging Server using PHP
15 APNS server implementation using PHP
16 Additional API Web Connectors creation using Python amp PHP
Mobile Application (All Platforms)
1 AngularJS
2 Server development of Android and iPhone application
3 Mobile Application
4 MySQL
5 SQLite
Testing Modules
1 Black Box Testing
2 White Box Testing
3 Selenium
4 QTP
Page 13 of 14
Orane Projects
Mobile Apps
Mars Telecom- a Hyderabad based IT company providing solutions to various industries across the globe has been kind
to utilize Oranersquos ever efficient and skilled consultants to deliver Mobile application solution that is part of the
Mumbai municipal authority The app was focused on enable the authorities of the MUDA community to effectively
use technology for its project completion and approval online The mobile app was designed to work with Samsun
mobile phones and tablets
Training amp Internship Programs
Christ University- Bangalore is known for its vast knowledge sharing and goodness to accommodate the aspiring
student from across the world to complete their graduate and under-graduate programs By decades of excellence and
mastery into the academic system Christ has carved a niche in the education field Today they also cater to masters
and PhD degrees in variety of subjects Orane is pleased to have been their chosen vendors to deliver internship amp
training program to Korean students under their CART- ldquoCenter for Advance Research and Trainingrdquo department
Website Social Media amp CRM Solutions
Stratum Ventures LLP- A Land Development company based in Bangalore working towards investment properties for
short and long term investors from across the globe Orane shares its gratitude to Stratum Ventures LLP team to have
shortlisted us to deliver their end-to-end IT solution starting from Website to CRM implementation
Orane ndash Global IT Consulting and Services
Industries Served Manufacturing
Energy and Petrochemical
Banking and Finance Government
Services Offered BIDW amp EPM ERP Enterprise Products and Solutions Mobile Device Development Consulting Managed Service Support Testing Maintenance and Upgrade
Value Proposition Relationship driven Business Agility Delivery ROI Quick Response
Page 14 of 14
Orane Intelli Solutions
NA Chambers 1st Floor
3 J 7th C Main Road 3rd Block
3rd Cross Road Koramangala
Bangalore-560034
Email infooranetechcom| Web wwworanetechcom| Ph +91 80 4145 6644
Large- Enterprise Solutions
Big Data
Data Visualization
BI DW
ERP
Enterprise Mobile App
Enterprise Solutions for Medium Scale
Data Visualization
Analytics
ERP- Standalone Cloud
Application Dev
Mobile apps
Small Industries
Cloud Solutions Application Dev Enterprise Portals Mobile apps
Orane- Services
Offshore Development Centers | Outsourced Product Development | Staff Augmentation |Trainings
Fact Sheet
Orane founded in year 2011- primarily focused in providing Business Intelligence and ERP solutions Headquartered in Bangalore having strong alliance across various geographies Strong and experienced management with several years of industry experience and solid leadership Ensuring quality delivery and support Projects Completed Al-Shirawi Ent Modern Plastics Industry Kanva Fashions The Address Makers
In the pipeline SCANIA Bangalore Bristle Cone Bataviarsquos Textile Live-in- Space Pvt Ltd etc
Value Proposition Relationship
driven Business
Agility
Page 5 of 14
Figure 2 SSRS- Course Details amp Hours
Qlikview- Basics
Qlik- is a leader in data discovery delivering intuitive solutions for self-service data visualization and guided analytics Approximately 33000 customers rely on Qlik solutions to gain meaning out of information from varied sources exploring the hidden relationships within data that lead to insights that ignite good ideas
Control Create business-driven data discoveries with guided analysis paths that are highly customizable and
tightly governed
o Guided analytics Beautiful controlled analytic experiences guide employees toward discovering
insights and making meaningful decisions
o Secure Top-down control of analytics apps permissions and data management
o Centralized Apps Granular control of dashboards layouts and design
Flexibility Build the exact tools you need for your organization and teams
o Customizable Develop custom apps with QlikView scripting and extend development with QlikView
Workbench
o Combinable Integrate QlikView into your business applications and system management software
with extensive APIs
o Global SearchUse natural search to navigate complex information to accelerate discovery
Consistency Provide one set of data and apps for use across your entire organization
o Data integration Unify data sources for a complete view of information centrally managed data and
apps make it easier to discover insights
0
05
1
15
2
25
3
35
Intr
o t
o F
eatu
res
SSR
S A
rch
ite
chu
re
Rep
ort
ing
Serv
er P
roje
cts
Cre
atin
g Ta
bu
lar
Rep
ort
Ad
din
g C
on
tro
ls
Cre
atin
g Li
st R
epo
rt
Cre
atin
g Ex
pre
ssio
ns
Glo
bal
Co
llect
ion
s
Form
atti
ng
Cre
atin
g G
rou
ps
Cal
cula
tin
g To
tals
Inte
ract
ive
Sort
ing
Cre
atin
g P
aram
ete
rs
Dro
p D
ow
n L
ist
Par
amet
ers
Pa
ram
ete
r So
rtin
g
Cre
atin
g M
atri
x R
ep
ort
s
SSR
S 20
08
Mat
rix
Feat
ure
s
Cre
atin
g A
Ch
art
Ad
din
g G
auge
s
Dep
loy
Rep
ort
s
Rep
ort
Man
ager
Rep
ort
ing
Serv
ice
s Se
curi
ty
SSL
Dat
a So
urc
e S
ecu
rity
Rep
ort
ing
Serv
ice
s A
PIs
Rep
ort
Vie
wer
Co
ntr
ols
Web
Se
rvic
e
Web
Se
rvic
e Su
bsc
rip
tio
n
Cu
sto
m A
ssem
blie
s
Rep
ort
Cac
hin
g
Sub
scri
pti
on
s
Two
Rep
ort
Bu
ilder
s
Cre
atin
g R
ep
ort
s
Ch 1 Ch 2 Ch 3 Ch 4 Ch 5 Ch 6 Ch 7 Ch 8 Ch 9 Ch10
Ch11
Ch12
Ch13 Ch14
Ch15
Ch16
Ch17
Ch18
Ch19
Ch20
Ch21
Ch22
Ch23
Ch24
Ch25
Ch26
Ch27
Ch28
Ch29
Ch30
Ch31
Ch32
Ch33
Ho
urs
Chapters
Page 6 of 14
o Advanced reporting Create and distribute consistent reports and templates plus embed them in
Microsoft Office documents with QlikViewreg NPrinting
o Enterprise scalability The advantages of guided analytics with secure enterprise-level governance of
data and analytics
Figure 3 QV Basics Course Details
Figure 4 QV- Advanced Training course details
0
1
2
3
4
5
6
What Is QlikView Natural Joins Make forEasy Data Models
Filters Selections and KPIs ndash Quick-look
Dashboard Elements
Dig Deep with Charts andGraphs
Dashboard Presentation Isthe Key to Dashboard
Adoption
Ch 1 Ch 2 Ch 3 Ch 4 Ch 5
HO
UR
S
CHAPTERS
Qlikview- Basics
1 1
2 2
3
2
3
2 2 2
1 1
2 2
1
2 2 2
1
3 3
2
1
2 2 2 2
4
CH
1
QL
IKV
IEW
hellip
CH
2
INT
RO
TO
hellip
CH
3
INT
RO
TO
hellip
CH
4
QL
IKV
IEW
hellip
CH
5
LO
AD
ING
hellip
CH
6
CR
EA
TIN
G hellip
CH
7
SC
RIP
TIN
G hellip
CH
8
AD
DIN
G hellip
CH
9
GE
NE
RA
TE
hellip
CH
10
M
AP
PIN
G hellip
CH
11
Q
V D
AT
A hellip
CH
12
Q
V hellip
CH
12
A
DV
hellip
CH
1
US
ING
QV
hellip
CH
2
SH
EE
TS
amp hellip
CH
3
TH
E L
IST
hellip
CH
4
TH
E T
AB
LE
hellip
CH
5
TH
E M
UL
TI hellip
CH
6
TH
E T
EX
T hellip
CH
7
CH
AR
TS
CH
8
MU
LT
I-hellip
CH
9
GU
AG
ES
CH
10
B
UT
TO
NS
CH
11
T
HE
hellip
CH
12
hellip
CH
13
O
TH
ER
hellip
CH
14
S
ET
TIN
GS
hellip
CH
15
R
EP
OR
TS
hellip
P A R T 1 P A R T 2 U S E R I N T E R F A C E D E S I G N I N G
HOURS
Page 7 of 14
Business Dashboard Fundamentals
Ch 1 Visual Perception Dashboard Examples
Why Stats Arent Enough
How to Make Data Beautiful
Demo Eliminating Chart Junk
Summary
Ch 2 Common Charts Basic Data Presentation Methods
Basic Chart Types
Choosing a Chart Type
Advanced Chart Types
Chart Types to Avoid
Summary
Ch 3 Dashboard Planning Dashboard Development Process
Request Process
Prioritization
Documentation
Summary
Ch 4 Dashboard Design Dashboard Design Considerations
Knowing Your Audience
Choosing the Right Data
Dashboard Layout
Summary
Ch 5 Building Dashboards in Excel Part 1 - Working with Data
DEMO Acquiring Data
DEMO Massaging Data
Summary
Ch 6 Building Dashboards in Excel Part 2 - Visualizing Data
DEMO Building Charts
DEMO Building Dashboards
DEMO Building Scorecards
DEMO Preparing for Distribution
Summary
Page 8 of 14
Ch 7 Building Dashboards in Tableau Part 1- Working with Data
DEMO Getting Setup
DEMO Connecting to Data
DEMO Working with Data
Summary
Ch 8 Building Dashboards in Tableau Part 2 - Visualizing Data
DEMO Building Charts
DEMO Building Dashboards
DEMO Formatting
DEMO Sharing Your Work
Summary
Figure 5 Course Outline
Figure 6 Course Details amp Hours
With all the acronyms bandied about in the world of computing its easy to get some terms confused VB stands for Visual Basic and it is not the same as VBA Though both VB and VBA are programming languages derived from BASIC and created by Microsoft they are otherwise very different
VB is a language that enables you to create standalone executable applications that do not even require its users to have Office or Excel loaded onto their computers VBA cannot create standalone applications and it exists within a host application such as Excel and the workbook containing the VBA code For a VBA macro to run its host application workbook must be open This book is about VBA and how it controls Excel
Access Training
Access is an excellent (many would say logical) next step for the analyst who faces an ever-increasing data pool Access
takes very few performance hits with larger datasets It has no predetermined row limitations And it can effectively
manage the relationships between disparate data tables In addition Access comes with tools that help you build your
own distributable applications
Today when we have more data than ever and more demands for complex data analysis power analysts need to add
some tools to their repertoire in order to get away from being simply ldquospreadsheet mechanicsrdquo Thats why this book is
such an important step in the evolution of your skillset Throughout this book not only will you get an introduction to
45 5 5
2
5
22
Ch 1 Ch 2 Ch 3 Ch 4 Ch 5 Ch 6 Ch 7 Ch 8
Hours
Page 9 of 14
Access but youll also learn various ways in which you can use Access to improve your daily data management and
analysis
Figure 7 Access Course Details amp Hours
Part 1- Access Building Blocks| 3 hrs
bull An Introduction to Database Development
bull Getting Started with Access
Part 2- Understanding Access Tables| 8 hrs
bull Creating Access Tables
bull Understanding Table Relationships
bull Working with Access Tables
bull Importing and Exporting Data
bull Linking to External Data
Part 3-Working with Access Queries| 6 hrs
bull Selecting Data with Queries
bull Using Operators and Expressions in Access
Part 4- Analyzing Data in Access| 7 hrs
bull Transforming Data in Access
bull Working with Calculations and Dates
bull Performing Conditional Analyses
bull Fundamentals of Using Access SQL
bull Subqueries and Domain Aggregate Functions
bull Running Descriptive Statistics in Access
Part 5- Working with Access Forms and Reports| 8 hrs
bull Creating Basic Access Forms
bull Working with Data on Access Forms
bull Working with Form Controls
bull Presenting Data with Access Reports
bull Advanced Access Report Techniques
Page 10 of 14
Advance Access Programming
Figure 8 Advanced Access Course details amp Hours
Advanced
Access
Programming
Techniques
10 hrs
Debugging Your Access Applications
-Organizing VBA Code
-Testing Your Applications
-Traditional Debugging Techniques
-Using the Access Debugging Tools
-Trapping Errors in Your Code
Accessing Data with VBA Code
-Working with Data
-Understanding ADO Objects
-Understanding DAO Objects
-Writing VBA Code to Update a Table
Advanced Data Access with VBA
-Adding an Unbound Combo Box to a Form to Find Data
-Filtering a Form
Integrating Access and SQL Server
-Introducing SQL Server Express
-Understanding Data Types in SQL Server
-Installing SQL Server Express
-Connecting to SQL Server
-Working with SQL Server Objects
Customizing the Ribbon
-The Ribbon Hierarchy
-Editing the Default Ribbon
-Working with the Quick Access Toolbar
-Developing Custom Ribbons
-Creating a Custom Ribbon
-The Basic Ribbon XML
-Adding Ribbon Controls
-Attaching Ribbons to Forms and Reports
Completely Removing the Ribbon
Preparing Your Access Application for Distribution
-Defining the Current Database Options
-Developing the Application
-Polishing Your Application
-Bulletproofing an Application
Securing the Environment
Page 11 of 14
Other Courses We Offer
1 Business Intelligence Data warehousing
2 Data Analytics
3 Data Analysis
4 Business Analysis
Tools amp Applications
1 Microsoft Office
a MS-Excel amp Macros (VBA)
b MS-Access amp Macros (VBA)
c VBA for PowerPoint
d Access
e MS Sql Server 2005 2008 2012 2014
f T-SQL Programming
g Sql Server Reporting Services 2005 to 2014
h Power BI (Power Pivots Power View Power Designer Power Maps) 2010 2013 2016
i Statistics using Excel Data Analysis Toolpak
2 Tableau 80 to 93 Desktop Server Online Public Reader
3 Sisense v60 with Elasticube
4 Qlik Tech Products
a Qlikview 11
b Qliksense 22
5 Database
a RDBMS
b SQL
c Dimensional modelling
6 Domain Specific
a Financial Modeling
b Cost Modeling
c Spend Analytics
d Retail Analytics
e HR Analytics
f HealthcarePharma Analytics
g PMO
h Infrastructure Management (ITO)
7 Big Data ndash Hadoop
8 HDFS (Hadoop File System)
9 Oracle
a Oracle BRM
b Oracle suite
10 Technical Writing
Page 12 of 14
11 Business Analysis
12 Project Consulting and academic project assistance and final year project certification
Web amp Mobile Technologies
Web Development Tools amp Applications
1 ASPNET
2 CNET
3 Python
4 D3JS
5 Java scripting
6 JQuery
7 PHP
8 JSP
9 Content Management using WordPress amp Joomla
10 HTML5
11 CSS3
12 Bootstrap
13 Rest API implementation using PHP
14 Google Cloud Messaging Server using PHP
15 APNS server implementation using PHP
16 Additional API Web Connectors creation using Python amp PHP
Mobile Application (All Platforms)
1 AngularJS
2 Server development of Android and iPhone application
3 Mobile Application
4 MySQL
5 SQLite
Testing Modules
1 Black Box Testing
2 White Box Testing
3 Selenium
4 QTP
Page 13 of 14
Orane Projects
Mobile Apps
Mars Telecom- a Hyderabad based IT company providing solutions to various industries across the globe has been kind
to utilize Oranersquos ever efficient and skilled consultants to deliver Mobile application solution that is part of the
Mumbai municipal authority The app was focused on enable the authorities of the MUDA community to effectively
use technology for its project completion and approval online The mobile app was designed to work with Samsun
mobile phones and tablets
Training amp Internship Programs
Christ University- Bangalore is known for its vast knowledge sharing and goodness to accommodate the aspiring
student from across the world to complete their graduate and under-graduate programs By decades of excellence and
mastery into the academic system Christ has carved a niche in the education field Today they also cater to masters
and PhD degrees in variety of subjects Orane is pleased to have been their chosen vendors to deliver internship amp
training program to Korean students under their CART- ldquoCenter for Advance Research and Trainingrdquo department
Website Social Media amp CRM Solutions
Stratum Ventures LLP- A Land Development company based in Bangalore working towards investment properties for
short and long term investors from across the globe Orane shares its gratitude to Stratum Ventures LLP team to have
shortlisted us to deliver their end-to-end IT solution starting from Website to CRM implementation
Orane ndash Global IT Consulting and Services
Industries Served Manufacturing
Energy and Petrochemical
Banking and Finance Government
Services Offered BIDW amp EPM ERP Enterprise Products and Solutions Mobile Device Development Consulting Managed Service Support Testing Maintenance and Upgrade
Value Proposition Relationship driven Business Agility Delivery ROI Quick Response
Page 14 of 14
Orane Intelli Solutions
NA Chambers 1st Floor
3 J 7th C Main Road 3rd Block
3rd Cross Road Koramangala
Bangalore-560034
Email infooranetechcom| Web wwworanetechcom| Ph +91 80 4145 6644
Large- Enterprise Solutions
Big Data
Data Visualization
BI DW
ERP
Enterprise Mobile App
Enterprise Solutions for Medium Scale
Data Visualization
Analytics
ERP- Standalone Cloud
Application Dev
Mobile apps
Small Industries
Cloud Solutions Application Dev Enterprise Portals Mobile apps
Orane- Services
Offshore Development Centers | Outsourced Product Development | Staff Augmentation |Trainings
Fact Sheet
Orane founded in year 2011- primarily focused in providing Business Intelligence and ERP solutions Headquartered in Bangalore having strong alliance across various geographies Strong and experienced management with several years of industry experience and solid leadership Ensuring quality delivery and support Projects Completed Al-Shirawi Ent Modern Plastics Industry Kanva Fashions The Address Makers
In the pipeline SCANIA Bangalore Bristle Cone Bataviarsquos Textile Live-in- Space Pvt Ltd etc
Value Proposition Relationship
driven Business
Agility
Page 6 of 14
o Advanced reporting Create and distribute consistent reports and templates plus embed them in
Microsoft Office documents with QlikViewreg NPrinting
o Enterprise scalability The advantages of guided analytics with secure enterprise-level governance of
data and analytics
Figure 3 QV Basics Course Details
Figure 4 QV- Advanced Training course details
0
1
2
3
4
5
6
What Is QlikView Natural Joins Make forEasy Data Models
Filters Selections and KPIs ndash Quick-look
Dashboard Elements
Dig Deep with Charts andGraphs
Dashboard Presentation Isthe Key to Dashboard
Adoption
Ch 1 Ch 2 Ch 3 Ch 4 Ch 5
HO
UR
S
CHAPTERS
Qlikview- Basics
1 1
2 2
3
2
3
2 2 2
1 1
2 2
1
2 2 2
1
3 3
2
1
2 2 2 2
4
CH
1
QL
IKV
IEW
hellip
CH
2
INT
RO
TO
hellip
CH
3
INT
RO
TO
hellip
CH
4
QL
IKV
IEW
hellip
CH
5
LO
AD
ING
hellip
CH
6
CR
EA
TIN
G hellip
CH
7
SC
RIP
TIN
G hellip
CH
8
AD
DIN
G hellip
CH
9
GE
NE
RA
TE
hellip
CH
10
M
AP
PIN
G hellip
CH
11
Q
V D
AT
A hellip
CH
12
Q
V hellip
CH
12
A
DV
hellip
CH
1
US
ING
QV
hellip
CH
2
SH
EE
TS
amp hellip
CH
3
TH
E L
IST
hellip
CH
4
TH
E T
AB
LE
hellip
CH
5
TH
E M
UL
TI hellip
CH
6
TH
E T
EX
T hellip
CH
7
CH
AR
TS
CH
8
MU
LT
I-hellip
CH
9
GU
AG
ES
CH
10
B
UT
TO
NS
CH
11
T
HE
hellip
CH
12
hellip
CH
13
O
TH
ER
hellip
CH
14
S
ET
TIN
GS
hellip
CH
15
R
EP
OR
TS
hellip
P A R T 1 P A R T 2 U S E R I N T E R F A C E D E S I G N I N G
HOURS
Page 7 of 14
Business Dashboard Fundamentals
Ch 1 Visual Perception Dashboard Examples
Why Stats Arent Enough
How to Make Data Beautiful
Demo Eliminating Chart Junk
Summary
Ch 2 Common Charts Basic Data Presentation Methods
Basic Chart Types
Choosing a Chart Type
Advanced Chart Types
Chart Types to Avoid
Summary
Ch 3 Dashboard Planning Dashboard Development Process
Request Process
Prioritization
Documentation
Summary
Ch 4 Dashboard Design Dashboard Design Considerations
Knowing Your Audience
Choosing the Right Data
Dashboard Layout
Summary
Ch 5 Building Dashboards in Excel Part 1 - Working with Data
DEMO Acquiring Data
DEMO Massaging Data
Summary
Ch 6 Building Dashboards in Excel Part 2 - Visualizing Data
DEMO Building Charts
DEMO Building Dashboards
DEMO Building Scorecards
DEMO Preparing for Distribution
Summary
Page 8 of 14
Ch 7 Building Dashboards in Tableau Part 1- Working with Data
DEMO Getting Setup
DEMO Connecting to Data
DEMO Working with Data
Summary
Ch 8 Building Dashboards in Tableau Part 2 - Visualizing Data
DEMO Building Charts
DEMO Building Dashboards
DEMO Formatting
DEMO Sharing Your Work
Summary
Figure 5 Course Outline
Figure 6 Course Details amp Hours
With all the acronyms bandied about in the world of computing its easy to get some terms confused VB stands for Visual Basic and it is not the same as VBA Though both VB and VBA are programming languages derived from BASIC and created by Microsoft they are otherwise very different
VB is a language that enables you to create standalone executable applications that do not even require its users to have Office or Excel loaded onto their computers VBA cannot create standalone applications and it exists within a host application such as Excel and the workbook containing the VBA code For a VBA macro to run its host application workbook must be open This book is about VBA and how it controls Excel
Access Training
Access is an excellent (many would say logical) next step for the analyst who faces an ever-increasing data pool Access
takes very few performance hits with larger datasets It has no predetermined row limitations And it can effectively
manage the relationships between disparate data tables In addition Access comes with tools that help you build your
own distributable applications
Today when we have more data than ever and more demands for complex data analysis power analysts need to add
some tools to their repertoire in order to get away from being simply ldquospreadsheet mechanicsrdquo Thats why this book is
such an important step in the evolution of your skillset Throughout this book not only will you get an introduction to
45 5 5
2
5
22
Ch 1 Ch 2 Ch 3 Ch 4 Ch 5 Ch 6 Ch 7 Ch 8
Hours
Page 9 of 14
Access but youll also learn various ways in which you can use Access to improve your daily data management and
analysis
Figure 7 Access Course Details amp Hours
Part 1- Access Building Blocks| 3 hrs
bull An Introduction to Database Development
bull Getting Started with Access
Part 2- Understanding Access Tables| 8 hrs
bull Creating Access Tables
bull Understanding Table Relationships
bull Working with Access Tables
bull Importing and Exporting Data
bull Linking to External Data
Part 3-Working with Access Queries| 6 hrs
bull Selecting Data with Queries
bull Using Operators and Expressions in Access
Part 4- Analyzing Data in Access| 7 hrs
bull Transforming Data in Access
bull Working with Calculations and Dates
bull Performing Conditional Analyses
bull Fundamentals of Using Access SQL
bull Subqueries and Domain Aggregate Functions
bull Running Descriptive Statistics in Access
Part 5- Working with Access Forms and Reports| 8 hrs
bull Creating Basic Access Forms
bull Working with Data on Access Forms
bull Working with Form Controls
bull Presenting Data with Access Reports
bull Advanced Access Report Techniques
Page 10 of 14
Advance Access Programming
Figure 8 Advanced Access Course details amp Hours
Advanced
Access
Programming
Techniques
10 hrs
Debugging Your Access Applications
-Organizing VBA Code
-Testing Your Applications
-Traditional Debugging Techniques
-Using the Access Debugging Tools
-Trapping Errors in Your Code
Accessing Data with VBA Code
-Working with Data
-Understanding ADO Objects
-Understanding DAO Objects
-Writing VBA Code to Update a Table
Advanced Data Access with VBA
-Adding an Unbound Combo Box to a Form to Find Data
-Filtering a Form
Integrating Access and SQL Server
-Introducing SQL Server Express
-Understanding Data Types in SQL Server
-Installing SQL Server Express
-Connecting to SQL Server
-Working with SQL Server Objects
Customizing the Ribbon
-The Ribbon Hierarchy
-Editing the Default Ribbon
-Working with the Quick Access Toolbar
-Developing Custom Ribbons
-Creating a Custom Ribbon
-The Basic Ribbon XML
-Adding Ribbon Controls
-Attaching Ribbons to Forms and Reports
Completely Removing the Ribbon
Preparing Your Access Application for Distribution
-Defining the Current Database Options
-Developing the Application
-Polishing Your Application
-Bulletproofing an Application
Securing the Environment
Page 11 of 14
Other Courses We Offer
1 Business Intelligence Data warehousing
2 Data Analytics
3 Data Analysis
4 Business Analysis
Tools amp Applications
1 Microsoft Office
a MS-Excel amp Macros (VBA)
b MS-Access amp Macros (VBA)
c VBA for PowerPoint
d Access
e MS Sql Server 2005 2008 2012 2014
f T-SQL Programming
g Sql Server Reporting Services 2005 to 2014
h Power BI (Power Pivots Power View Power Designer Power Maps) 2010 2013 2016
i Statistics using Excel Data Analysis Toolpak
2 Tableau 80 to 93 Desktop Server Online Public Reader
3 Sisense v60 with Elasticube
4 Qlik Tech Products
a Qlikview 11
b Qliksense 22
5 Database
a RDBMS
b SQL
c Dimensional modelling
6 Domain Specific
a Financial Modeling
b Cost Modeling
c Spend Analytics
d Retail Analytics
e HR Analytics
f HealthcarePharma Analytics
g PMO
h Infrastructure Management (ITO)
7 Big Data ndash Hadoop
8 HDFS (Hadoop File System)
9 Oracle
a Oracle BRM
b Oracle suite
10 Technical Writing
Page 12 of 14
11 Business Analysis
12 Project Consulting and academic project assistance and final year project certification
Web amp Mobile Technologies
Web Development Tools amp Applications
1 ASPNET
2 CNET
3 Python
4 D3JS
5 Java scripting
6 JQuery
7 PHP
8 JSP
9 Content Management using WordPress amp Joomla
10 HTML5
11 CSS3
12 Bootstrap
13 Rest API implementation using PHP
14 Google Cloud Messaging Server using PHP
15 APNS server implementation using PHP
16 Additional API Web Connectors creation using Python amp PHP
Mobile Application (All Platforms)
1 AngularJS
2 Server development of Android and iPhone application
3 Mobile Application
4 MySQL
5 SQLite
Testing Modules
1 Black Box Testing
2 White Box Testing
3 Selenium
4 QTP
Page 13 of 14
Orane Projects
Mobile Apps
Mars Telecom- a Hyderabad based IT company providing solutions to various industries across the globe has been kind
to utilize Oranersquos ever efficient and skilled consultants to deliver Mobile application solution that is part of the
Mumbai municipal authority The app was focused on enable the authorities of the MUDA community to effectively
use technology for its project completion and approval online The mobile app was designed to work with Samsun
mobile phones and tablets
Training amp Internship Programs
Christ University- Bangalore is known for its vast knowledge sharing and goodness to accommodate the aspiring
student from across the world to complete their graduate and under-graduate programs By decades of excellence and
mastery into the academic system Christ has carved a niche in the education field Today they also cater to masters
and PhD degrees in variety of subjects Orane is pleased to have been their chosen vendors to deliver internship amp
training program to Korean students under their CART- ldquoCenter for Advance Research and Trainingrdquo department
Website Social Media amp CRM Solutions
Stratum Ventures LLP- A Land Development company based in Bangalore working towards investment properties for
short and long term investors from across the globe Orane shares its gratitude to Stratum Ventures LLP team to have
shortlisted us to deliver their end-to-end IT solution starting from Website to CRM implementation
Orane ndash Global IT Consulting and Services
Industries Served Manufacturing
Energy and Petrochemical
Banking and Finance Government
Services Offered BIDW amp EPM ERP Enterprise Products and Solutions Mobile Device Development Consulting Managed Service Support Testing Maintenance and Upgrade
Value Proposition Relationship driven Business Agility Delivery ROI Quick Response
Page 14 of 14
Orane Intelli Solutions
NA Chambers 1st Floor
3 J 7th C Main Road 3rd Block
3rd Cross Road Koramangala
Bangalore-560034
Email infooranetechcom| Web wwworanetechcom| Ph +91 80 4145 6644
Large- Enterprise Solutions
Big Data
Data Visualization
BI DW
ERP
Enterprise Mobile App
Enterprise Solutions for Medium Scale
Data Visualization
Analytics
ERP- Standalone Cloud
Application Dev
Mobile apps
Small Industries
Cloud Solutions Application Dev Enterprise Portals Mobile apps
Orane- Services
Offshore Development Centers | Outsourced Product Development | Staff Augmentation |Trainings
Fact Sheet
Orane founded in year 2011- primarily focused in providing Business Intelligence and ERP solutions Headquartered in Bangalore having strong alliance across various geographies Strong and experienced management with several years of industry experience and solid leadership Ensuring quality delivery and support Projects Completed Al-Shirawi Ent Modern Plastics Industry Kanva Fashions The Address Makers
In the pipeline SCANIA Bangalore Bristle Cone Bataviarsquos Textile Live-in- Space Pvt Ltd etc
Value Proposition Relationship
driven Business
Agility
Page 7 of 14
Business Dashboard Fundamentals
Ch 1 Visual Perception Dashboard Examples
Why Stats Arent Enough
How to Make Data Beautiful
Demo Eliminating Chart Junk
Summary
Ch 2 Common Charts Basic Data Presentation Methods
Basic Chart Types
Choosing a Chart Type
Advanced Chart Types
Chart Types to Avoid
Summary
Ch 3 Dashboard Planning Dashboard Development Process
Request Process
Prioritization
Documentation
Summary
Ch 4 Dashboard Design Dashboard Design Considerations
Knowing Your Audience
Choosing the Right Data
Dashboard Layout
Summary
Ch 5 Building Dashboards in Excel Part 1 - Working with Data
DEMO Acquiring Data
DEMO Massaging Data
Summary
Ch 6 Building Dashboards in Excel Part 2 - Visualizing Data
DEMO Building Charts
DEMO Building Dashboards
DEMO Building Scorecards
DEMO Preparing for Distribution
Summary
Page 8 of 14
Ch 7 Building Dashboards in Tableau Part 1- Working with Data
DEMO Getting Setup
DEMO Connecting to Data
DEMO Working with Data
Summary
Ch 8 Building Dashboards in Tableau Part 2 - Visualizing Data
DEMO Building Charts
DEMO Building Dashboards
DEMO Formatting
DEMO Sharing Your Work
Summary
Figure 5 Course Outline
Figure 6 Course Details amp Hours
With all the acronyms bandied about in the world of computing its easy to get some terms confused VB stands for Visual Basic and it is not the same as VBA Though both VB and VBA are programming languages derived from BASIC and created by Microsoft they are otherwise very different
VB is a language that enables you to create standalone executable applications that do not even require its users to have Office or Excel loaded onto their computers VBA cannot create standalone applications and it exists within a host application such as Excel and the workbook containing the VBA code For a VBA macro to run its host application workbook must be open This book is about VBA and how it controls Excel
Access Training
Access is an excellent (many would say logical) next step for the analyst who faces an ever-increasing data pool Access
takes very few performance hits with larger datasets It has no predetermined row limitations And it can effectively
manage the relationships between disparate data tables In addition Access comes with tools that help you build your
own distributable applications
Today when we have more data than ever and more demands for complex data analysis power analysts need to add
some tools to their repertoire in order to get away from being simply ldquospreadsheet mechanicsrdquo Thats why this book is
such an important step in the evolution of your skillset Throughout this book not only will you get an introduction to
45 5 5
2
5
22
Ch 1 Ch 2 Ch 3 Ch 4 Ch 5 Ch 6 Ch 7 Ch 8
Hours
Page 9 of 14
Access but youll also learn various ways in which you can use Access to improve your daily data management and
analysis
Figure 7 Access Course Details amp Hours
Part 1- Access Building Blocks| 3 hrs
bull An Introduction to Database Development
bull Getting Started with Access
Part 2- Understanding Access Tables| 8 hrs
bull Creating Access Tables
bull Understanding Table Relationships
bull Working with Access Tables
bull Importing and Exporting Data
bull Linking to External Data
Part 3-Working with Access Queries| 6 hrs
bull Selecting Data with Queries
bull Using Operators and Expressions in Access
Part 4- Analyzing Data in Access| 7 hrs
bull Transforming Data in Access
bull Working with Calculations and Dates
bull Performing Conditional Analyses
bull Fundamentals of Using Access SQL
bull Subqueries and Domain Aggregate Functions
bull Running Descriptive Statistics in Access
Part 5- Working with Access Forms and Reports| 8 hrs
bull Creating Basic Access Forms
bull Working with Data on Access Forms
bull Working with Form Controls
bull Presenting Data with Access Reports
bull Advanced Access Report Techniques
Page 10 of 14
Advance Access Programming
Figure 8 Advanced Access Course details amp Hours
Advanced
Access
Programming
Techniques
10 hrs
Debugging Your Access Applications
-Organizing VBA Code
-Testing Your Applications
-Traditional Debugging Techniques
-Using the Access Debugging Tools
-Trapping Errors in Your Code
Accessing Data with VBA Code
-Working with Data
-Understanding ADO Objects
-Understanding DAO Objects
-Writing VBA Code to Update a Table
Advanced Data Access with VBA
-Adding an Unbound Combo Box to a Form to Find Data
-Filtering a Form
Integrating Access and SQL Server
-Introducing SQL Server Express
-Understanding Data Types in SQL Server
-Installing SQL Server Express
-Connecting to SQL Server
-Working with SQL Server Objects
Customizing the Ribbon
-The Ribbon Hierarchy
-Editing the Default Ribbon
-Working with the Quick Access Toolbar
-Developing Custom Ribbons
-Creating a Custom Ribbon
-The Basic Ribbon XML
-Adding Ribbon Controls
-Attaching Ribbons to Forms and Reports
Completely Removing the Ribbon
Preparing Your Access Application for Distribution
-Defining the Current Database Options
-Developing the Application
-Polishing Your Application
-Bulletproofing an Application
Securing the Environment
Page 11 of 14
Other Courses We Offer
1 Business Intelligence Data warehousing
2 Data Analytics
3 Data Analysis
4 Business Analysis
Tools amp Applications
1 Microsoft Office
a MS-Excel amp Macros (VBA)
b MS-Access amp Macros (VBA)
c VBA for PowerPoint
d Access
e MS Sql Server 2005 2008 2012 2014
f T-SQL Programming
g Sql Server Reporting Services 2005 to 2014
h Power BI (Power Pivots Power View Power Designer Power Maps) 2010 2013 2016
i Statistics using Excel Data Analysis Toolpak
2 Tableau 80 to 93 Desktop Server Online Public Reader
3 Sisense v60 with Elasticube
4 Qlik Tech Products
a Qlikview 11
b Qliksense 22
5 Database
a RDBMS
b SQL
c Dimensional modelling
6 Domain Specific
a Financial Modeling
b Cost Modeling
c Spend Analytics
d Retail Analytics
e HR Analytics
f HealthcarePharma Analytics
g PMO
h Infrastructure Management (ITO)
7 Big Data ndash Hadoop
8 HDFS (Hadoop File System)
9 Oracle
a Oracle BRM
b Oracle suite
10 Technical Writing
Page 12 of 14
11 Business Analysis
12 Project Consulting and academic project assistance and final year project certification
Web amp Mobile Technologies
Web Development Tools amp Applications
1 ASPNET
2 CNET
3 Python
4 D3JS
5 Java scripting
6 JQuery
7 PHP
8 JSP
9 Content Management using WordPress amp Joomla
10 HTML5
11 CSS3
12 Bootstrap
13 Rest API implementation using PHP
14 Google Cloud Messaging Server using PHP
15 APNS server implementation using PHP
16 Additional API Web Connectors creation using Python amp PHP
Mobile Application (All Platforms)
1 AngularJS
2 Server development of Android and iPhone application
3 Mobile Application
4 MySQL
5 SQLite
Testing Modules
1 Black Box Testing
2 White Box Testing
3 Selenium
4 QTP
Page 13 of 14
Orane Projects
Mobile Apps
Mars Telecom- a Hyderabad based IT company providing solutions to various industries across the globe has been kind
to utilize Oranersquos ever efficient and skilled consultants to deliver Mobile application solution that is part of the
Mumbai municipal authority The app was focused on enable the authorities of the MUDA community to effectively
use technology for its project completion and approval online The mobile app was designed to work with Samsun
mobile phones and tablets
Training amp Internship Programs
Christ University- Bangalore is known for its vast knowledge sharing and goodness to accommodate the aspiring
student from across the world to complete their graduate and under-graduate programs By decades of excellence and
mastery into the academic system Christ has carved a niche in the education field Today they also cater to masters
and PhD degrees in variety of subjects Orane is pleased to have been their chosen vendors to deliver internship amp
training program to Korean students under their CART- ldquoCenter for Advance Research and Trainingrdquo department
Website Social Media amp CRM Solutions
Stratum Ventures LLP- A Land Development company based in Bangalore working towards investment properties for
short and long term investors from across the globe Orane shares its gratitude to Stratum Ventures LLP team to have
shortlisted us to deliver their end-to-end IT solution starting from Website to CRM implementation
Orane ndash Global IT Consulting and Services
Industries Served Manufacturing
Energy and Petrochemical
Banking and Finance Government
Services Offered BIDW amp EPM ERP Enterprise Products and Solutions Mobile Device Development Consulting Managed Service Support Testing Maintenance and Upgrade
Value Proposition Relationship driven Business Agility Delivery ROI Quick Response
Page 14 of 14
Orane Intelli Solutions
NA Chambers 1st Floor
3 J 7th C Main Road 3rd Block
3rd Cross Road Koramangala
Bangalore-560034
Email infooranetechcom| Web wwworanetechcom| Ph +91 80 4145 6644
Large- Enterprise Solutions
Big Data
Data Visualization
BI DW
ERP
Enterprise Mobile App
Enterprise Solutions for Medium Scale
Data Visualization
Analytics
ERP- Standalone Cloud
Application Dev
Mobile apps
Small Industries
Cloud Solutions Application Dev Enterprise Portals Mobile apps
Orane- Services
Offshore Development Centers | Outsourced Product Development | Staff Augmentation |Trainings
Fact Sheet
Orane founded in year 2011- primarily focused in providing Business Intelligence and ERP solutions Headquartered in Bangalore having strong alliance across various geographies Strong and experienced management with several years of industry experience and solid leadership Ensuring quality delivery and support Projects Completed Al-Shirawi Ent Modern Plastics Industry Kanva Fashions The Address Makers
In the pipeline SCANIA Bangalore Bristle Cone Bataviarsquos Textile Live-in- Space Pvt Ltd etc
Value Proposition Relationship
driven Business
Agility
Page 8 of 14
Ch 7 Building Dashboards in Tableau Part 1- Working with Data
DEMO Getting Setup
DEMO Connecting to Data
DEMO Working with Data
Summary
Ch 8 Building Dashboards in Tableau Part 2 - Visualizing Data
DEMO Building Charts
DEMO Building Dashboards
DEMO Formatting
DEMO Sharing Your Work
Summary
Figure 5 Course Outline
Figure 6 Course Details amp Hours
With all the acronyms bandied about in the world of computing its easy to get some terms confused VB stands for Visual Basic and it is not the same as VBA Though both VB and VBA are programming languages derived from BASIC and created by Microsoft they are otherwise very different
VB is a language that enables you to create standalone executable applications that do not even require its users to have Office or Excel loaded onto their computers VBA cannot create standalone applications and it exists within a host application such as Excel and the workbook containing the VBA code For a VBA macro to run its host application workbook must be open This book is about VBA and how it controls Excel
Access Training
Access is an excellent (many would say logical) next step for the analyst who faces an ever-increasing data pool Access
takes very few performance hits with larger datasets It has no predetermined row limitations And it can effectively
manage the relationships between disparate data tables In addition Access comes with tools that help you build your
own distributable applications
Today when we have more data than ever and more demands for complex data analysis power analysts need to add
some tools to their repertoire in order to get away from being simply ldquospreadsheet mechanicsrdquo Thats why this book is
such an important step in the evolution of your skillset Throughout this book not only will you get an introduction to
45 5 5
2
5
22
Ch 1 Ch 2 Ch 3 Ch 4 Ch 5 Ch 6 Ch 7 Ch 8
Hours
Page 9 of 14
Access but youll also learn various ways in which you can use Access to improve your daily data management and
analysis
Figure 7 Access Course Details amp Hours
Part 1- Access Building Blocks| 3 hrs
bull An Introduction to Database Development
bull Getting Started with Access
Part 2- Understanding Access Tables| 8 hrs
bull Creating Access Tables
bull Understanding Table Relationships
bull Working with Access Tables
bull Importing and Exporting Data
bull Linking to External Data
Part 3-Working with Access Queries| 6 hrs
bull Selecting Data with Queries
bull Using Operators and Expressions in Access
Part 4- Analyzing Data in Access| 7 hrs
bull Transforming Data in Access
bull Working with Calculations and Dates
bull Performing Conditional Analyses
bull Fundamentals of Using Access SQL
bull Subqueries and Domain Aggregate Functions
bull Running Descriptive Statistics in Access
Part 5- Working with Access Forms and Reports| 8 hrs
bull Creating Basic Access Forms
bull Working with Data on Access Forms
bull Working with Form Controls
bull Presenting Data with Access Reports
bull Advanced Access Report Techniques
Page 10 of 14
Advance Access Programming
Figure 8 Advanced Access Course details amp Hours
Advanced
Access
Programming
Techniques
10 hrs
Debugging Your Access Applications
-Organizing VBA Code
-Testing Your Applications
-Traditional Debugging Techniques
-Using the Access Debugging Tools
-Trapping Errors in Your Code
Accessing Data with VBA Code
-Working with Data
-Understanding ADO Objects
-Understanding DAO Objects
-Writing VBA Code to Update a Table
Advanced Data Access with VBA
-Adding an Unbound Combo Box to a Form to Find Data
-Filtering a Form
Integrating Access and SQL Server
-Introducing SQL Server Express
-Understanding Data Types in SQL Server
-Installing SQL Server Express
-Connecting to SQL Server
-Working with SQL Server Objects
Customizing the Ribbon
-The Ribbon Hierarchy
-Editing the Default Ribbon
-Working with the Quick Access Toolbar
-Developing Custom Ribbons
-Creating a Custom Ribbon
-The Basic Ribbon XML
-Adding Ribbon Controls
-Attaching Ribbons to Forms and Reports
Completely Removing the Ribbon
Preparing Your Access Application for Distribution
-Defining the Current Database Options
-Developing the Application
-Polishing Your Application
-Bulletproofing an Application
Securing the Environment
Page 11 of 14
Other Courses We Offer
1 Business Intelligence Data warehousing
2 Data Analytics
3 Data Analysis
4 Business Analysis
Tools amp Applications
1 Microsoft Office
a MS-Excel amp Macros (VBA)
b MS-Access amp Macros (VBA)
c VBA for PowerPoint
d Access
e MS Sql Server 2005 2008 2012 2014
f T-SQL Programming
g Sql Server Reporting Services 2005 to 2014
h Power BI (Power Pivots Power View Power Designer Power Maps) 2010 2013 2016
i Statistics using Excel Data Analysis Toolpak
2 Tableau 80 to 93 Desktop Server Online Public Reader
3 Sisense v60 with Elasticube
4 Qlik Tech Products
a Qlikview 11
b Qliksense 22
5 Database
a RDBMS
b SQL
c Dimensional modelling
6 Domain Specific
a Financial Modeling
b Cost Modeling
c Spend Analytics
d Retail Analytics
e HR Analytics
f HealthcarePharma Analytics
g PMO
h Infrastructure Management (ITO)
7 Big Data ndash Hadoop
8 HDFS (Hadoop File System)
9 Oracle
a Oracle BRM
b Oracle suite
10 Technical Writing
Page 12 of 14
11 Business Analysis
12 Project Consulting and academic project assistance and final year project certification
Web amp Mobile Technologies
Web Development Tools amp Applications
1 ASPNET
2 CNET
3 Python
4 D3JS
5 Java scripting
6 JQuery
7 PHP
8 JSP
9 Content Management using WordPress amp Joomla
10 HTML5
11 CSS3
12 Bootstrap
13 Rest API implementation using PHP
14 Google Cloud Messaging Server using PHP
15 APNS server implementation using PHP
16 Additional API Web Connectors creation using Python amp PHP
Mobile Application (All Platforms)
1 AngularJS
2 Server development of Android and iPhone application
3 Mobile Application
4 MySQL
5 SQLite
Testing Modules
1 Black Box Testing
2 White Box Testing
3 Selenium
4 QTP
Page 13 of 14
Orane Projects
Mobile Apps
Mars Telecom- a Hyderabad based IT company providing solutions to various industries across the globe has been kind
to utilize Oranersquos ever efficient and skilled consultants to deliver Mobile application solution that is part of the
Mumbai municipal authority The app was focused on enable the authorities of the MUDA community to effectively
use technology for its project completion and approval online The mobile app was designed to work with Samsun
mobile phones and tablets
Training amp Internship Programs
Christ University- Bangalore is known for its vast knowledge sharing and goodness to accommodate the aspiring
student from across the world to complete their graduate and under-graduate programs By decades of excellence and
mastery into the academic system Christ has carved a niche in the education field Today they also cater to masters
and PhD degrees in variety of subjects Orane is pleased to have been their chosen vendors to deliver internship amp
training program to Korean students under their CART- ldquoCenter for Advance Research and Trainingrdquo department
Website Social Media amp CRM Solutions
Stratum Ventures LLP- A Land Development company based in Bangalore working towards investment properties for
short and long term investors from across the globe Orane shares its gratitude to Stratum Ventures LLP team to have
shortlisted us to deliver their end-to-end IT solution starting from Website to CRM implementation
Orane ndash Global IT Consulting and Services
Industries Served Manufacturing
Energy and Petrochemical
Banking and Finance Government
Services Offered BIDW amp EPM ERP Enterprise Products and Solutions Mobile Device Development Consulting Managed Service Support Testing Maintenance and Upgrade
Value Proposition Relationship driven Business Agility Delivery ROI Quick Response
Page 14 of 14
Orane Intelli Solutions
NA Chambers 1st Floor
3 J 7th C Main Road 3rd Block
3rd Cross Road Koramangala
Bangalore-560034
Email infooranetechcom| Web wwworanetechcom| Ph +91 80 4145 6644
Large- Enterprise Solutions
Big Data
Data Visualization
BI DW
ERP
Enterprise Mobile App
Enterprise Solutions for Medium Scale
Data Visualization
Analytics
ERP- Standalone Cloud
Application Dev
Mobile apps
Small Industries
Cloud Solutions Application Dev Enterprise Portals Mobile apps
Orane- Services
Offshore Development Centers | Outsourced Product Development | Staff Augmentation |Trainings
Fact Sheet
Orane founded in year 2011- primarily focused in providing Business Intelligence and ERP solutions Headquartered in Bangalore having strong alliance across various geographies Strong and experienced management with several years of industry experience and solid leadership Ensuring quality delivery and support Projects Completed Al-Shirawi Ent Modern Plastics Industry Kanva Fashions The Address Makers
In the pipeline SCANIA Bangalore Bristle Cone Bataviarsquos Textile Live-in- Space Pvt Ltd etc
Value Proposition Relationship
driven Business
Agility
Page 9 of 14
Access but youll also learn various ways in which you can use Access to improve your daily data management and
analysis
Figure 7 Access Course Details amp Hours
Part 1- Access Building Blocks| 3 hrs
bull An Introduction to Database Development
bull Getting Started with Access
Part 2- Understanding Access Tables| 8 hrs
bull Creating Access Tables
bull Understanding Table Relationships
bull Working with Access Tables
bull Importing and Exporting Data
bull Linking to External Data
Part 3-Working with Access Queries| 6 hrs
bull Selecting Data with Queries
bull Using Operators and Expressions in Access
Part 4- Analyzing Data in Access| 7 hrs
bull Transforming Data in Access
bull Working with Calculations and Dates
bull Performing Conditional Analyses
bull Fundamentals of Using Access SQL
bull Subqueries and Domain Aggregate Functions
bull Running Descriptive Statistics in Access
Part 5- Working with Access Forms and Reports| 8 hrs
bull Creating Basic Access Forms
bull Working with Data on Access Forms
bull Working with Form Controls
bull Presenting Data with Access Reports
bull Advanced Access Report Techniques
Page 10 of 14
Advance Access Programming
Figure 8 Advanced Access Course details amp Hours
Advanced
Access
Programming
Techniques
10 hrs
Debugging Your Access Applications
-Organizing VBA Code
-Testing Your Applications
-Traditional Debugging Techniques
-Using the Access Debugging Tools
-Trapping Errors in Your Code
Accessing Data with VBA Code
-Working with Data
-Understanding ADO Objects
-Understanding DAO Objects
-Writing VBA Code to Update a Table
Advanced Data Access with VBA
-Adding an Unbound Combo Box to a Form to Find Data
-Filtering a Form
Integrating Access and SQL Server
-Introducing SQL Server Express
-Understanding Data Types in SQL Server
-Installing SQL Server Express
-Connecting to SQL Server
-Working with SQL Server Objects
Customizing the Ribbon
-The Ribbon Hierarchy
-Editing the Default Ribbon
-Working with the Quick Access Toolbar
-Developing Custom Ribbons
-Creating a Custom Ribbon
-The Basic Ribbon XML
-Adding Ribbon Controls
-Attaching Ribbons to Forms and Reports
Completely Removing the Ribbon
Preparing Your Access Application for Distribution
-Defining the Current Database Options
-Developing the Application
-Polishing Your Application
-Bulletproofing an Application
Securing the Environment
Page 11 of 14
Other Courses We Offer
1 Business Intelligence Data warehousing
2 Data Analytics
3 Data Analysis
4 Business Analysis
Tools amp Applications
1 Microsoft Office
a MS-Excel amp Macros (VBA)
b MS-Access amp Macros (VBA)
c VBA for PowerPoint
d Access
e MS Sql Server 2005 2008 2012 2014
f T-SQL Programming
g Sql Server Reporting Services 2005 to 2014
h Power BI (Power Pivots Power View Power Designer Power Maps) 2010 2013 2016
i Statistics using Excel Data Analysis Toolpak
2 Tableau 80 to 93 Desktop Server Online Public Reader
3 Sisense v60 with Elasticube
4 Qlik Tech Products
a Qlikview 11
b Qliksense 22
5 Database
a RDBMS
b SQL
c Dimensional modelling
6 Domain Specific
a Financial Modeling
b Cost Modeling
c Spend Analytics
d Retail Analytics
e HR Analytics
f HealthcarePharma Analytics
g PMO
h Infrastructure Management (ITO)
7 Big Data ndash Hadoop
8 HDFS (Hadoop File System)
9 Oracle
a Oracle BRM
b Oracle suite
10 Technical Writing
Page 12 of 14
11 Business Analysis
12 Project Consulting and academic project assistance and final year project certification
Web amp Mobile Technologies
Web Development Tools amp Applications
1 ASPNET
2 CNET
3 Python
4 D3JS
5 Java scripting
6 JQuery
7 PHP
8 JSP
9 Content Management using WordPress amp Joomla
10 HTML5
11 CSS3
12 Bootstrap
13 Rest API implementation using PHP
14 Google Cloud Messaging Server using PHP
15 APNS server implementation using PHP
16 Additional API Web Connectors creation using Python amp PHP
Mobile Application (All Platforms)
1 AngularJS
2 Server development of Android and iPhone application
3 Mobile Application
4 MySQL
5 SQLite
Testing Modules
1 Black Box Testing
2 White Box Testing
3 Selenium
4 QTP
Page 13 of 14
Orane Projects
Mobile Apps
Mars Telecom- a Hyderabad based IT company providing solutions to various industries across the globe has been kind
to utilize Oranersquos ever efficient and skilled consultants to deliver Mobile application solution that is part of the
Mumbai municipal authority The app was focused on enable the authorities of the MUDA community to effectively
use technology for its project completion and approval online The mobile app was designed to work with Samsun
mobile phones and tablets
Training amp Internship Programs
Christ University- Bangalore is known for its vast knowledge sharing and goodness to accommodate the aspiring
student from across the world to complete their graduate and under-graduate programs By decades of excellence and
mastery into the academic system Christ has carved a niche in the education field Today they also cater to masters
and PhD degrees in variety of subjects Orane is pleased to have been their chosen vendors to deliver internship amp
training program to Korean students under their CART- ldquoCenter for Advance Research and Trainingrdquo department
Website Social Media amp CRM Solutions
Stratum Ventures LLP- A Land Development company based in Bangalore working towards investment properties for
short and long term investors from across the globe Orane shares its gratitude to Stratum Ventures LLP team to have
shortlisted us to deliver their end-to-end IT solution starting from Website to CRM implementation
Orane ndash Global IT Consulting and Services
Industries Served Manufacturing
Energy and Petrochemical
Banking and Finance Government
Services Offered BIDW amp EPM ERP Enterprise Products and Solutions Mobile Device Development Consulting Managed Service Support Testing Maintenance and Upgrade
Value Proposition Relationship driven Business Agility Delivery ROI Quick Response
Page 14 of 14
Orane Intelli Solutions
NA Chambers 1st Floor
3 J 7th C Main Road 3rd Block
3rd Cross Road Koramangala
Bangalore-560034
Email infooranetechcom| Web wwworanetechcom| Ph +91 80 4145 6644
Large- Enterprise Solutions
Big Data
Data Visualization
BI DW
ERP
Enterprise Mobile App
Enterprise Solutions for Medium Scale
Data Visualization
Analytics
ERP- Standalone Cloud
Application Dev
Mobile apps
Small Industries
Cloud Solutions Application Dev Enterprise Portals Mobile apps
Orane- Services
Offshore Development Centers | Outsourced Product Development | Staff Augmentation |Trainings
Fact Sheet
Orane founded in year 2011- primarily focused in providing Business Intelligence and ERP solutions Headquartered in Bangalore having strong alliance across various geographies Strong and experienced management with several years of industry experience and solid leadership Ensuring quality delivery and support Projects Completed Al-Shirawi Ent Modern Plastics Industry Kanva Fashions The Address Makers
In the pipeline SCANIA Bangalore Bristle Cone Bataviarsquos Textile Live-in- Space Pvt Ltd etc
Value Proposition Relationship
driven Business
Agility
Page 10 of 14
Advance Access Programming
Figure 8 Advanced Access Course details amp Hours
Advanced
Access
Programming
Techniques
10 hrs
Debugging Your Access Applications
-Organizing VBA Code
-Testing Your Applications
-Traditional Debugging Techniques
-Using the Access Debugging Tools
-Trapping Errors in Your Code
Accessing Data with VBA Code
-Working with Data
-Understanding ADO Objects
-Understanding DAO Objects
-Writing VBA Code to Update a Table
Advanced Data Access with VBA
-Adding an Unbound Combo Box to a Form to Find Data
-Filtering a Form
Integrating Access and SQL Server
-Introducing SQL Server Express
-Understanding Data Types in SQL Server
-Installing SQL Server Express
-Connecting to SQL Server
-Working with SQL Server Objects
Customizing the Ribbon
-The Ribbon Hierarchy
-Editing the Default Ribbon
-Working with the Quick Access Toolbar
-Developing Custom Ribbons
-Creating a Custom Ribbon
-The Basic Ribbon XML
-Adding Ribbon Controls
-Attaching Ribbons to Forms and Reports
Completely Removing the Ribbon
Preparing Your Access Application for Distribution
-Defining the Current Database Options
-Developing the Application
-Polishing Your Application
-Bulletproofing an Application
Securing the Environment
Page 11 of 14
Other Courses We Offer
1 Business Intelligence Data warehousing
2 Data Analytics
3 Data Analysis
4 Business Analysis
Tools amp Applications
1 Microsoft Office
a MS-Excel amp Macros (VBA)
b MS-Access amp Macros (VBA)
c VBA for PowerPoint
d Access
e MS Sql Server 2005 2008 2012 2014
f T-SQL Programming
g Sql Server Reporting Services 2005 to 2014
h Power BI (Power Pivots Power View Power Designer Power Maps) 2010 2013 2016
i Statistics using Excel Data Analysis Toolpak
2 Tableau 80 to 93 Desktop Server Online Public Reader
3 Sisense v60 with Elasticube
4 Qlik Tech Products
a Qlikview 11
b Qliksense 22
5 Database
a RDBMS
b SQL
c Dimensional modelling
6 Domain Specific
a Financial Modeling
b Cost Modeling
c Spend Analytics
d Retail Analytics
e HR Analytics
f HealthcarePharma Analytics
g PMO
h Infrastructure Management (ITO)
7 Big Data ndash Hadoop
8 HDFS (Hadoop File System)
9 Oracle
a Oracle BRM
b Oracle suite
10 Technical Writing
Page 12 of 14
11 Business Analysis
12 Project Consulting and academic project assistance and final year project certification
Web amp Mobile Technologies
Web Development Tools amp Applications
1 ASPNET
2 CNET
3 Python
4 D3JS
5 Java scripting
6 JQuery
7 PHP
8 JSP
9 Content Management using WordPress amp Joomla
10 HTML5
11 CSS3
12 Bootstrap
13 Rest API implementation using PHP
14 Google Cloud Messaging Server using PHP
15 APNS server implementation using PHP
16 Additional API Web Connectors creation using Python amp PHP
Mobile Application (All Platforms)
1 AngularJS
2 Server development of Android and iPhone application
3 Mobile Application
4 MySQL
5 SQLite
Testing Modules
1 Black Box Testing
2 White Box Testing
3 Selenium
4 QTP
Page 13 of 14
Orane Projects
Mobile Apps
Mars Telecom- a Hyderabad based IT company providing solutions to various industries across the globe has been kind
to utilize Oranersquos ever efficient and skilled consultants to deliver Mobile application solution that is part of the
Mumbai municipal authority The app was focused on enable the authorities of the MUDA community to effectively
use technology for its project completion and approval online The mobile app was designed to work with Samsun
mobile phones and tablets
Training amp Internship Programs
Christ University- Bangalore is known for its vast knowledge sharing and goodness to accommodate the aspiring
student from across the world to complete their graduate and under-graduate programs By decades of excellence and
mastery into the academic system Christ has carved a niche in the education field Today they also cater to masters
and PhD degrees in variety of subjects Orane is pleased to have been their chosen vendors to deliver internship amp
training program to Korean students under their CART- ldquoCenter for Advance Research and Trainingrdquo department
Website Social Media amp CRM Solutions
Stratum Ventures LLP- A Land Development company based in Bangalore working towards investment properties for
short and long term investors from across the globe Orane shares its gratitude to Stratum Ventures LLP team to have
shortlisted us to deliver their end-to-end IT solution starting from Website to CRM implementation
Orane ndash Global IT Consulting and Services
Industries Served Manufacturing
Energy and Petrochemical
Banking and Finance Government
Services Offered BIDW amp EPM ERP Enterprise Products and Solutions Mobile Device Development Consulting Managed Service Support Testing Maintenance and Upgrade
Value Proposition Relationship driven Business Agility Delivery ROI Quick Response
Page 14 of 14
Orane Intelli Solutions
NA Chambers 1st Floor
3 J 7th C Main Road 3rd Block
3rd Cross Road Koramangala
Bangalore-560034
Email infooranetechcom| Web wwworanetechcom| Ph +91 80 4145 6644
Large- Enterprise Solutions
Big Data
Data Visualization
BI DW
ERP
Enterprise Mobile App
Enterprise Solutions for Medium Scale
Data Visualization
Analytics
ERP- Standalone Cloud
Application Dev
Mobile apps
Small Industries
Cloud Solutions Application Dev Enterprise Portals Mobile apps
Orane- Services
Offshore Development Centers | Outsourced Product Development | Staff Augmentation |Trainings
Fact Sheet
Orane founded in year 2011- primarily focused in providing Business Intelligence and ERP solutions Headquartered in Bangalore having strong alliance across various geographies Strong and experienced management with several years of industry experience and solid leadership Ensuring quality delivery and support Projects Completed Al-Shirawi Ent Modern Plastics Industry Kanva Fashions The Address Makers
In the pipeline SCANIA Bangalore Bristle Cone Bataviarsquos Textile Live-in- Space Pvt Ltd etc
Value Proposition Relationship
driven Business
Agility
Page 11 of 14
Other Courses We Offer
1 Business Intelligence Data warehousing
2 Data Analytics
3 Data Analysis
4 Business Analysis
Tools amp Applications
1 Microsoft Office
a MS-Excel amp Macros (VBA)
b MS-Access amp Macros (VBA)
c VBA for PowerPoint
d Access
e MS Sql Server 2005 2008 2012 2014
f T-SQL Programming
g Sql Server Reporting Services 2005 to 2014
h Power BI (Power Pivots Power View Power Designer Power Maps) 2010 2013 2016
i Statistics using Excel Data Analysis Toolpak
2 Tableau 80 to 93 Desktop Server Online Public Reader
3 Sisense v60 with Elasticube
4 Qlik Tech Products
a Qlikview 11
b Qliksense 22
5 Database
a RDBMS
b SQL
c Dimensional modelling
6 Domain Specific
a Financial Modeling
b Cost Modeling
c Spend Analytics
d Retail Analytics
e HR Analytics
f HealthcarePharma Analytics
g PMO
h Infrastructure Management (ITO)
7 Big Data ndash Hadoop
8 HDFS (Hadoop File System)
9 Oracle
a Oracle BRM
b Oracle suite
10 Technical Writing
Page 12 of 14
11 Business Analysis
12 Project Consulting and academic project assistance and final year project certification
Web amp Mobile Technologies
Web Development Tools amp Applications
1 ASPNET
2 CNET
3 Python
4 D3JS
5 Java scripting
6 JQuery
7 PHP
8 JSP
9 Content Management using WordPress amp Joomla
10 HTML5
11 CSS3
12 Bootstrap
13 Rest API implementation using PHP
14 Google Cloud Messaging Server using PHP
15 APNS server implementation using PHP
16 Additional API Web Connectors creation using Python amp PHP
Mobile Application (All Platforms)
1 AngularJS
2 Server development of Android and iPhone application
3 Mobile Application
4 MySQL
5 SQLite
Testing Modules
1 Black Box Testing
2 White Box Testing
3 Selenium
4 QTP
Page 13 of 14
Orane Projects
Mobile Apps
Mars Telecom- a Hyderabad based IT company providing solutions to various industries across the globe has been kind
to utilize Oranersquos ever efficient and skilled consultants to deliver Mobile application solution that is part of the
Mumbai municipal authority The app was focused on enable the authorities of the MUDA community to effectively
use technology for its project completion and approval online The mobile app was designed to work with Samsun
mobile phones and tablets
Training amp Internship Programs
Christ University- Bangalore is known for its vast knowledge sharing and goodness to accommodate the aspiring
student from across the world to complete their graduate and under-graduate programs By decades of excellence and
mastery into the academic system Christ has carved a niche in the education field Today they also cater to masters
and PhD degrees in variety of subjects Orane is pleased to have been their chosen vendors to deliver internship amp
training program to Korean students under their CART- ldquoCenter for Advance Research and Trainingrdquo department
Website Social Media amp CRM Solutions
Stratum Ventures LLP- A Land Development company based in Bangalore working towards investment properties for
short and long term investors from across the globe Orane shares its gratitude to Stratum Ventures LLP team to have
shortlisted us to deliver their end-to-end IT solution starting from Website to CRM implementation
Orane ndash Global IT Consulting and Services
Industries Served Manufacturing
Energy and Petrochemical
Banking and Finance Government
Services Offered BIDW amp EPM ERP Enterprise Products and Solutions Mobile Device Development Consulting Managed Service Support Testing Maintenance and Upgrade
Value Proposition Relationship driven Business Agility Delivery ROI Quick Response
Page 14 of 14
Orane Intelli Solutions
NA Chambers 1st Floor
3 J 7th C Main Road 3rd Block
3rd Cross Road Koramangala
Bangalore-560034
Email infooranetechcom| Web wwworanetechcom| Ph +91 80 4145 6644
Large- Enterprise Solutions
Big Data
Data Visualization
BI DW
ERP
Enterprise Mobile App
Enterprise Solutions for Medium Scale
Data Visualization
Analytics
ERP- Standalone Cloud
Application Dev
Mobile apps
Small Industries
Cloud Solutions Application Dev Enterprise Portals Mobile apps
Orane- Services
Offshore Development Centers | Outsourced Product Development | Staff Augmentation |Trainings
Fact Sheet
Orane founded in year 2011- primarily focused in providing Business Intelligence and ERP solutions Headquartered in Bangalore having strong alliance across various geographies Strong and experienced management with several years of industry experience and solid leadership Ensuring quality delivery and support Projects Completed Al-Shirawi Ent Modern Plastics Industry Kanva Fashions The Address Makers
In the pipeline SCANIA Bangalore Bristle Cone Bataviarsquos Textile Live-in- Space Pvt Ltd etc
Value Proposition Relationship
driven Business
Agility
Page 12 of 14
11 Business Analysis
12 Project Consulting and academic project assistance and final year project certification
Web amp Mobile Technologies
Web Development Tools amp Applications
1 ASPNET
2 CNET
3 Python
4 D3JS
5 Java scripting
6 JQuery
7 PHP
8 JSP
9 Content Management using WordPress amp Joomla
10 HTML5
11 CSS3
12 Bootstrap
13 Rest API implementation using PHP
14 Google Cloud Messaging Server using PHP
15 APNS server implementation using PHP
16 Additional API Web Connectors creation using Python amp PHP
Mobile Application (All Platforms)
1 AngularJS
2 Server development of Android and iPhone application
3 Mobile Application
4 MySQL
5 SQLite
Testing Modules
1 Black Box Testing
2 White Box Testing
3 Selenium
4 QTP
Page 13 of 14
Orane Projects
Mobile Apps
Mars Telecom- a Hyderabad based IT company providing solutions to various industries across the globe has been kind
to utilize Oranersquos ever efficient and skilled consultants to deliver Mobile application solution that is part of the
Mumbai municipal authority The app was focused on enable the authorities of the MUDA community to effectively
use technology for its project completion and approval online The mobile app was designed to work with Samsun
mobile phones and tablets
Training amp Internship Programs
Christ University- Bangalore is known for its vast knowledge sharing and goodness to accommodate the aspiring
student from across the world to complete their graduate and under-graduate programs By decades of excellence and
mastery into the academic system Christ has carved a niche in the education field Today they also cater to masters
and PhD degrees in variety of subjects Orane is pleased to have been their chosen vendors to deliver internship amp
training program to Korean students under their CART- ldquoCenter for Advance Research and Trainingrdquo department
Website Social Media amp CRM Solutions
Stratum Ventures LLP- A Land Development company based in Bangalore working towards investment properties for
short and long term investors from across the globe Orane shares its gratitude to Stratum Ventures LLP team to have
shortlisted us to deliver their end-to-end IT solution starting from Website to CRM implementation
Orane ndash Global IT Consulting and Services
Industries Served Manufacturing
Energy and Petrochemical
Banking and Finance Government
Services Offered BIDW amp EPM ERP Enterprise Products and Solutions Mobile Device Development Consulting Managed Service Support Testing Maintenance and Upgrade
Value Proposition Relationship driven Business Agility Delivery ROI Quick Response
Page 14 of 14
Orane Intelli Solutions
NA Chambers 1st Floor
3 J 7th C Main Road 3rd Block
3rd Cross Road Koramangala
Bangalore-560034
Email infooranetechcom| Web wwworanetechcom| Ph +91 80 4145 6644
Large- Enterprise Solutions
Big Data
Data Visualization
BI DW
ERP
Enterprise Mobile App
Enterprise Solutions for Medium Scale
Data Visualization
Analytics
ERP- Standalone Cloud
Application Dev
Mobile apps
Small Industries
Cloud Solutions Application Dev Enterprise Portals Mobile apps
Orane- Services
Offshore Development Centers | Outsourced Product Development | Staff Augmentation |Trainings
Fact Sheet
Orane founded in year 2011- primarily focused in providing Business Intelligence and ERP solutions Headquartered in Bangalore having strong alliance across various geographies Strong and experienced management with several years of industry experience and solid leadership Ensuring quality delivery and support Projects Completed Al-Shirawi Ent Modern Plastics Industry Kanva Fashions The Address Makers
In the pipeline SCANIA Bangalore Bristle Cone Bataviarsquos Textile Live-in- Space Pvt Ltd etc
Value Proposition Relationship
driven Business
Agility
Page 13 of 14
Orane Projects
Mobile Apps
Mars Telecom- a Hyderabad based IT company providing solutions to various industries across the globe has been kind
to utilize Oranersquos ever efficient and skilled consultants to deliver Mobile application solution that is part of the
Mumbai municipal authority The app was focused on enable the authorities of the MUDA community to effectively
use technology for its project completion and approval online The mobile app was designed to work with Samsun
mobile phones and tablets
Training amp Internship Programs
Christ University- Bangalore is known for its vast knowledge sharing and goodness to accommodate the aspiring
student from across the world to complete their graduate and under-graduate programs By decades of excellence and
mastery into the academic system Christ has carved a niche in the education field Today they also cater to masters
and PhD degrees in variety of subjects Orane is pleased to have been their chosen vendors to deliver internship amp
training program to Korean students under their CART- ldquoCenter for Advance Research and Trainingrdquo department
Website Social Media amp CRM Solutions
Stratum Ventures LLP- A Land Development company based in Bangalore working towards investment properties for
short and long term investors from across the globe Orane shares its gratitude to Stratum Ventures LLP team to have
shortlisted us to deliver their end-to-end IT solution starting from Website to CRM implementation
Orane ndash Global IT Consulting and Services
Industries Served Manufacturing
Energy and Petrochemical
Banking and Finance Government
Services Offered BIDW amp EPM ERP Enterprise Products and Solutions Mobile Device Development Consulting Managed Service Support Testing Maintenance and Upgrade
Value Proposition Relationship driven Business Agility Delivery ROI Quick Response
Page 14 of 14
Orane Intelli Solutions
NA Chambers 1st Floor
3 J 7th C Main Road 3rd Block
3rd Cross Road Koramangala
Bangalore-560034
Email infooranetechcom| Web wwworanetechcom| Ph +91 80 4145 6644
Large- Enterprise Solutions
Big Data
Data Visualization
BI DW
ERP
Enterprise Mobile App
Enterprise Solutions for Medium Scale
Data Visualization
Analytics
ERP- Standalone Cloud
Application Dev
Mobile apps
Small Industries
Cloud Solutions Application Dev Enterprise Portals Mobile apps
Orane- Services
Offshore Development Centers | Outsourced Product Development | Staff Augmentation |Trainings
Fact Sheet
Orane founded in year 2011- primarily focused in providing Business Intelligence and ERP solutions Headquartered in Bangalore having strong alliance across various geographies Strong and experienced management with several years of industry experience and solid leadership Ensuring quality delivery and support Projects Completed Al-Shirawi Ent Modern Plastics Industry Kanva Fashions The Address Makers
In the pipeline SCANIA Bangalore Bristle Cone Bataviarsquos Textile Live-in- Space Pvt Ltd etc
Value Proposition Relationship
driven Business
Agility
Page 14 of 14
Orane Intelli Solutions
NA Chambers 1st Floor
3 J 7th C Main Road 3rd Block
3rd Cross Road Koramangala
Bangalore-560034
Email infooranetechcom| Web wwworanetechcom| Ph +91 80 4145 6644
Large- Enterprise Solutions
Big Data
Data Visualization
BI DW
ERP
Enterprise Mobile App
Enterprise Solutions for Medium Scale
Data Visualization
Analytics
ERP- Standalone Cloud
Application Dev
Mobile apps
Small Industries
Cloud Solutions Application Dev Enterprise Portals Mobile apps
Orane- Services
Offshore Development Centers | Outsourced Product Development | Staff Augmentation |Trainings
Fact Sheet
Orane founded in year 2011- primarily focused in providing Business Intelligence and ERP solutions Headquartered in Bangalore having strong alliance across various geographies Strong and experienced management with several years of industry experience and solid leadership Ensuring quality delivery and support Projects Completed Al-Shirawi Ent Modern Plastics Industry Kanva Fashions The Address Makers
In the pipeline SCANIA Bangalore Bristle Cone Bataviarsquos Textile Live-in- Space Pvt Ltd etc
Value Proposition Relationship
driven Business
Agility