belladati meetup singapore workshop

MEETUP 2013 at

Prudential Tower, Singapore

06/19/2013

MEETUP SINGAPORE 2013 AGENDA 09:15 - 09:30 AM Welcome and Key Note

Can you imagine what you can achieve with BellaDati as a data analyst? Simon Tan

Regional Director (Asia)

09:30 - 10:15 AM Business Data Mashups and Agile Reporting Data on your fingertip or how to create first reports in 15 minutes.

Peter Fedorocko Data Analyst (Europe)

10:15 - 10:45 AM Collaboration and Sharing Glance to BellaDati native applications and mobile reporting.

Aislinn Chen Data Analyst (Asia)

10:45 - 11:00 AM Break

11:00 - 11:45 AM BellaApps Don't start from zero, be analytical hero! Ready-made templates for your industry.

Aislinn Chen Data Analyst (Asia)

11:45 - 01:00 PM Advanced Analytics with BellaDati Under the hood session including BellaDati Data Warehouse and ETL capabilities.

Peter Fedorocko Data Analyst (Europe)

01:00 PM Lunch

Contacts Simon Tan Regional Director (Asia) Mobile: +65 9857 4993

Office: +65 6274 1260

Email: simon.tan@belladati.com

Aislinn Chen Data Analyst (Asia)

Mobile: +65 8446 7617

Office: +65 6274 1260

Email: aislinn.chenya@belladati.com

Peter Fedorocko Data Analyst (Europe)

Mobile: +420 702 023 558

Office: +420 255 725 405

Email: peter.fedorocko@belladati.com

Welcome and Key Note by

Simon Tan

Beautiful Data

“BellaDati agile analytics and reporting tool reinvents the way how business users interact with business data. All you need is a web browser or a mobile device.”

Martin Trgiňa, BellaDati Founder & CEO

Europe (Prague)

USA (Chicago)

Asia (Singapore)

South Korea (Seoul)

Turkey (Istanbul)

Indonesia Inlite

India iStrategic Cloud

Germany Catenate Czech R.

Aquasoft

Headquarters

Branch

Partner

USA (San Francisco)

Some of Our Customers

Business Data Mashups

and Agile Reporting by

Peter Fedorocko

BellaDati Business Intelligence

Agile Analytics Empowering all users to become data analysts

Web / Mobile Built with collaboration and mobility in its DNA

Cloud / On-Premise Where tradition meets progress

BellaDati Data Discovery Process From raw data to insights in 3 simple steps

1 2 3

Warehouse Reports Dashboards

ETLs Formulas Collaboration Publishing

Publishing Workflow From Data Sets to Reports to Dashboards

Set Set Set Joined Data Sets

Reports

Dashboards

240 +83 % 80.9 % +83 %

80.9 % 240 +83 %

BellaDati Views and Dashlets 240 chart variations, tables, KPI labels, and GEO maps

240 +83 %

Dashboards

Designed for managers and execs

Personalized layout and structure

Mixture of views from various reports

Additional content (filters, news)

Drill-through directly to reports

Reports

Designed for data analysts

Turning data into insights

Mixture of various view types

Numerous analytical functions

What-if and scenario modeling

Various collaboration functions

Attributes and Indicators How to work with dimensions and measures

Name (A) Bred (A) Weight (I) Price (I) Bimbo Elephant 7000 56,000 Emily Monkey 60 23,000 Lucky Kangaroo 110 34,000

Collaboration and Sharing by

Aislinn Chen

Collaboration Cell comments, chat panel and attachments

Sharing

Export as pdf, ppt, excel, png

Schedule emails automatically

Embed into web portals and applications

Publish to dashboard

Share with other users

User Roles

Domain Administrator

Data Manager

Report

Editor

Default Role

Permission Options Single Row Precise Sharing and Access

Data Sets

Reports

Dashboards User / User Group

User / User Group

User / User Group / Global Permission

View / Edit

View / Edit

View / Edit

Full or Only Subset

Native iOS & Android Apps

Online/offline reports & dashboards

Fully-featured interface

Data harvesting forms

Free download

BellaApps by

Aislinn Chen

Tool is Not Enough …

How could I avoid long report development time and service costs?

What kind of measures and KPIs should I observe in my business?

What if I am not an experienced data analyst?

What kind of analyses do industry leaders and competitors look at?

What if I don’t know what kind of data do I need?

How should I design my reports to be comprehensive and user friendly?

BellaApps Industry related packages of reports and dashboards with sample data, which significantly lighten and decrease analysts’ efforts when developing BI solutions.

“How could I avoid long report development time and service costs?”

?

Speed Up Deployment Download and start to explore immediately

belladati.com/apps

FREE download

Search by keywords

.bdt package

Easy import wizard

“What kind of measures and KPIs should I observe in my business?”

?

Best Practices KPI Researched industry top measures and indicators

Hospitality Gaming

Project Management Transportation

DAU/MAU (%)

EAC PPS

REVPAR

“What if I am not an experienced data analyst?”

?

“What kind of analyses do industry leaders and competitors look at?”

?

Common Analyses and Views Industry proven charts and visualizations

“What if I don’t know what kind of data do I need?”

?

General Data Model Recommended data structures, dimensions and measures

Common database schemas

Industry standard sources or public data sets Facebook, Twitter, Google, Salesforce API, MS Project, POS, MICROS, MoE

Mandatory and arbitrary fields Inspiration for new dimensions and measures

Suggested relations and cardinalities Modeled data marts and joins

Usual transformation scripts Handling dates, intervals, clustering

Possible drill-downs

“How should I design my reports to be comprehensive and user friendly?”

?

Best Practices in Report Design Data-oriented visualizations and styles

Data discovery report layout

Recommended view types

Suggested chart combinations

Predefined conditional formats

Adjusted view appearances

Best Practices in Report Design

Recommended view types

Data-oriented visualizations and styles

Best Practices in Report Design Data-oriented visualizations and styles

Data discovery report layout

Recommended view types

Suggested chart combinations

Predefined conditional formats

Adjusted view appearances

Importing BellaApps

Creating BellaApps

BellaApps Marketplace

Request from BellaDati

3rd party Data Analysts

Advanced Analytics

with BellaDati by

Peter Fedorocko

BellaDati Data Discovery Process From raw data to insights in 3 simple steps

1 2 3

Warehouse Reports Dashboards

ETLs Formulas Collaboration Publishing

Data Warehouse

Built in DWH

value value value

Existing DWH

Data Consolidation Connecting to DWH

PostgreSQL

Super connectivity 100 databases, Web services, Social Networks, Cloud Apps, Local Files..

ETLs & data warehouse Almighty proprietary scripting language and fully-fledged warehouse

value

“adult”

“junior”

group

if

> 21

< 21

return

=

string

Analyzing Twitter Data The most dedicated followers and their reach

My most retweeted tweets

Best #hastag combinations

The most effective tweeting time during the day

Sentiment Analysis in MongoDB

NoSQL Database

Database / Collection / Document

{

“name” : “Peter” ,

“movies” : {

“title” : “Superman” , “title” : “Batman”

}

}

Sentiment Analysis in MongoDB 1,000 tweets about Tesla stored in MongoDB

Index “text” field for Full Text Search capabilities

Run sentiment analysis (best, top, amazing, incredible, perfect)

Report in BellaDati

MEETUP SINGAPORE 2013 AGENDA 09:15 - 09:30 AM Welcome and Key Note

Can you imagine what you can achieve with BellaDati as a data analyst? Simon Tan

Regional Director (Asia)

09:30 - 10:15 AM Business Data Mashups and Agile Reporting Data on your fingertip or how to create first reports in 15 minutes.

Peter Fedorocko Data Analyst (Europe)

10:15 - 10:45 AM Collaboration and Sharing Glance to BellaDati native applications and mobile reporting.

Aislinn Chen Data Analyst (Asia)

10:45 - 11:00 AM Break

11:00 - 11:45 AM BellaApps Don't start from zero, be analytical hero! Ready-made templates for your industry.

Aislinn Chen Data Analyst (Asia)

11:45 - 01:00 PM Advanced Analytics with BellaDati Under the hood session including BellaDati Data Warehouse and ETL capabilities.

Peter Fedorocko Data Analyst (Europe)

01:00 PM Lunch