KEMBAR78
Belladati Meetup Singapore Workshop | PDF
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	

 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

Belladati Meetup Singapore Workshop

  • 1.
  • 2.
    MEETUP SINGAPORE 2013AGENDA 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
  • 3.
    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
  • 4.
    Welcome and KeyNote by Simon Tan
  • 5.
    Beautiful Data BellaDati agileanalytics 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
  • 6.
    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)
  • 7.
    Some of OurCustomers
  • 8.
    Business Data Mashups andAgile Reporting by Peter Fedorocko
  • 9.
    BellaDati Business Intelligence AgileAnalytics Empowering all users to become data analysts Web / Mobile Built with collaboration and mobility in its DNA Cloud / On-Premise Where tradition meets progress
  • 10.
    BellaDati Data DiscoveryProcess From raw data to insights in 3 simple steps 1 2 3 Warehouse Reports Dashboards ETLs Formulas Collaboration Publishing
  • 11.
    Publishing Workflow From DataSets to Reports to Dashboards Set Set Set Joined Data Sets Reports Dashboards 240 +83 % 80.9 % +83 % 80.9 % 240 +83 %
  • 12.
    BellaDati Views andDashlets 240 chart variations, tables, KPI labels, and GEO maps 240 +83 %
  • 13.
    Dashboards Designed for managersand execs Personalized layout and structure Mixture of views from various reports Additional content (filters, news) Drill-through directly to reports
  • 14.
    Reports Designed for dataanalysts Turning data into insights Mixture of various view types Numerous analytical functions What-if and scenario modeling Various collaboration functions
  • 15.
    Attributes and Indicators Howto 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
  • 16.
  • 17.
    Collaboration Cell comments, chatpanel and attachments
  • 18.
    Sharing Export as pdf,ppt, excel, png Schedule emails automatically Embed into web portals and applications Publish to dashboard Share with other users
  • 19.
    User Roles Domain Administrator Data Manager Report Editor Default Role
  • 20.
    Permission Options Single RowPrecise 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
  • 21.
    Native iOS &Android Apps Online/offline reports & dashboards Fully-featured interface Data harvesting forms Free download
  • 22.
  • 23.
    Tool is NotEnough … 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?
  • 24.
    BellaApps Industry related packagesof reports and dashboards with sample data, which significantly lighten and decrease analysts efforts when developing BI solutions.
  • 25.
    “How could Iavoid long report development time and service costs?” ?
  • 26.
    Speed Up Deployment Downloadand start to explore immediately belladati.com/apps FREE download Search by keywords .bdt package Easy import wizard
  • 27.
    “What kind ofmeasures and KPIs should I observe in my business?” ?
  • 28.
    Best Practices KPI Researchedindustry top measures and indicators Hospitality Gaming Project Management Transportation DAU/MAU (%) EAC PPS REVPAR
  • 29.
    “What if Iam not an experienced data analyst?” ?
  • 30.
    “What kind ofanalyses do industry leaders and competitors look at?” ?
  • 31.
    Common Analyses andViews Industry proven charts and visualizations
  • 32.
    “What if Idon’t know what kind of data do I need?” ?
  • 33.
    General Data Model Recommendeddata 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
  • 35.
    “How should Idesign my reports to be comprehensive and user friendly?” ?
  • 36.
    Best Practices inReport Design Data-oriented visualizations and styles Data discovery report layout Recommended view types Suggested chart combinations Predefined conditional formats Adjusted view appearances
  • 37.
    Best Practices inReport Design Recommended view types Data-oriented visualizations and styles
  • 38.
    Best Practices inReport Design Data-oriented visualizations and styles Data discovery report layout Recommended view types Suggested chart combinations Predefined conditional formats Adjusted view appearances
  • 39.
  • 40.
  • 41.
  • 42.
  • 43.
    BellaDati Data DiscoveryProcess From raw data to insights in 3 simple steps 1 2 3 Warehouse Reports Dashboards ETLs Formulas Collaboration Publishing
  • 44.
    Data Warehouse Built inDWH Existing DWH Data Consolidation Connecting to DWH PostgreSQL
  • 45.
    Super connectivity 100 databases,Web services, Social Networks, Cloud Apps, Local Files..
  • 46.
    ETLs & datawarehouse Almighty proprietary scripting language and fully-fledged warehouse value adult junior group if > 21 < 21 return = string
  • 47.
    Analyzing Twitter Data Themost dedicated followers and their reach My most retweeted tweets Best #hastag combinations The most effective tweeting time during the day
  • 48.
    Sentiment Analysis inMongoDB NoSQL Database Database / Collection / Document { “name” : “Peter” , “movies” : { “title” : “Superman” , “title” : “Batman” } }
  • 49.
    Sentiment Analysis inMongoDB 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
  • 50.
    MEETUP SINGAPORE 2013AGENDA 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