belladati meetup singapore workshop
DESCRIPTION
TRANSCRIPT
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: [email protected]
Aislinn Chen Data Analyst (Asia)
Mobile: +65 8446 7617
Office: +65 6274 1260
Email: [email protected]
Peter Fedorocko Data Analyst (Europe)
Mobile: +420 702 023 558
Office: +420 255 725 405
Email: [email protected]
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