Data Analytics 3.0: A three-day intensive training on Data Analytics and Data Visualization

Data Analytics 3.0: Big Data Analytics, Data Value chain and Data Visualization on June 5-7, 2018 (9AM – 5PM) to be held at Discovery Suites, ADB Ave., Ortigas Center, Pasig. 

COURSE OVERVIEW:

Analytics Experts Dan Meyer (DMAIPH) and Dominic Ligot (Cirrolytix) have joined forces to offer a unique training focusing on both the Analysis, Visualization and Management of Big Data.

Attendees will learn how to identify the right data, how data can be efficiently stored, then transformed into a friendly form for analysis, and finally how data analysis can yield insights.

This training will also lightly touch on each aspect of data identification, collection, storage, transformation, and analysis and involve hands-on use of common data management and analysis tools such as Excel, SQL and in depth learning of the tool “Tableau”, this is also designed for those with little to no prior experience with these tools.

 

LEARNING SESSION OBJECTIVES:

  1. Apply cutting edge technologies to organize, interpret, and summarize Big Data in your business.
  2. Create a process to analyze data and identify patterns not apparent at first glance
  3. Understand the components of The Data Value Chain: Ingestion, Storage, 
Transformation, Analysis – and how they are all important to deriving value from data.
  4. Learn database manipulation and processing basics using the Structured Query Language 
(SQL)
  5. Connect a data analysis tool such as MS Excel or Tableau to a database to be able to 
perform analysis on processed and stored data

 

IN THIS SESSION, YOUR ORGANIZATION WILL BE ABLE TO USE:

  • Specific skills to effectively frame the problem you’re addressing to uncover key opportunities and drive growth
  • Critical marketing steps of orientation necessary before engaging tools and technology
  • How to simply and quickly amplify decision making by separating the signal from the 
noise
  • A framework for asking the right questions, allowing the ability to link analytics to 
business strategy

 

IN THIS SESSION, YOUR PARTICIPANTS WILL BE ABLE TO:

  • Learn the best practices for organizing, summarizing, and interpreting quantitative data
  • Create a repeatable process for analyzing your data
  • Shorten the time between analysis and action to avoid “analysis paralysis”
  • Know how to get from hard data to well-reasoned conclusions

 

WHO SHOULD ATTEND:

  • Business Analysts, Data Analysts and other Analytics Professionals
  • Business professionals who are involved in day-to-day analysis of data.
  • Data analysts who are already performing analysis using spreadsheets but struggle with manual data processing.
  • Managers of analysts or staff who spend a significant amount of their time collecting, analyzing and reporting data.
  • IT and Development Staff that work closely with business leaders and decision-makers.

 

KEY TOPICS: DAY ONE

SECTION ONE – Big Data—It’s Not Just Size That Matters

  • Understand the 3 T’s of Analytics: Talent, Technique and Technology.
  • Describe the importance of effectively, analyzing big data in Business today.
  • Develop a Data Map to analyze the Big Data in your Business.
  • Recognize when to employ Descriptive, Predictive or Prescriptive Analytics.
  • Establish clear objectives when analyzing Big Data.

SECTION TWO – Assess Your Current Analytics Culture

  • Define What Is an Analytics Centric Culture.
  • Describe the issues and trends in today’s analytics field.
  • Discover how to find the most important KPIs.
  • Learn how to build better management reports.
  • Optimize your use of MS Excel for Big Data Analytics

SECTION THREE – Using Business Intelligence Tools

  • An overview of BI Tools.
  • Discuss the Concept of Data Visualization.
  • Build A Business Dashboard Prototype.
  • Apply the key elements of Data Storytelling

SECTION FOUR – Interpreting Your Data and Analysis

  • Articulate the importance of accurately interpreting Data.
  • Determine how to validate your data analysis.
  • Mitigate and analyze Risk, Uncertainty, And Probability.
  • Spot patterns and trends through Statistical Analysis.
  • Use findings from Big Data to Drive Decisions within your Organization.

 

KEY TOPICS: DAY TWO

SECTION FIVE – Presenting the Data Value Chain and Databases

  • Discuss the components of The Data Value Chain and the various users and roles involved in transforming data to value: Database and ETL engineers, Data analysts, Business users.
  • Learn about basic data architecture and the role of databases in processing data.
  • Understand the basics of databases, tables and views.
  • Learn about the Structured Query Language (SQL) and SELECT statements.

SECTION SIX – Data Processing with SQL

  • Discuss the additional value that can be derived from using SQL for Data Processing.
  • Go into detail on various ways of processing and preparing data using SQL.
  • Learn about aggregates, conditions, how to join tables, and run queries within queries.

 SECTION SEVEN – Accessing SQL Tables with Excel

  • Learn about Open Database Connectivity (ODBC) and how Excel uses ODBC to connect to external data sources.
  • Discover how SQL tables and views can be read by Excel into instant Pivot Tables and Pivot Graphs.
  • Understand how changes in database table or view via SQL Inserts, Deletes, and Updates are reflected on Excel.

SECTION EIGHT – Performing analysis of SQL-based data using Excel

  • Learn about how SQL data can be dissected using the Data Analysis functions in Excel.
  • Talk about form tools and macros that can automate manual reporting.
  • Discuss tips for reporting and sharing the results of your analysis.
  • Understand how data can be prepared for exceptional storytelling.

 

KEY TOPICS: DAY THREE 

At the end of this course, you will be able to:

  • Connect to your data.
  • Edit and save a data source.
  • Understand Tableau terminology.
  • Use the Tableau interface / paradigm to effectively create powerful visualizations.
  • Create basic calculations including basic arithmetic calculations, custom aggregations and ratios, date math, and quick table calculations.
  • Represent your data using the following visualization types:
  • Cross tabs
  • Geographic maps
  • Heat maps
  • Tree maps
  • Pie charts and bar charts
  • Dual axis and combined charts with different mark types
  • Highlight Tables
  • Scatter Plots
  • Build dashboards to share visualizations.

 

Tableau – Fundamentals

  • Introduction
  • Connecting to data
  • Simplifying and sorting your data
  • Organizing your data
  • Slicing your data by date
  • Using multiple measures in a view
  • Showing the relationship between numerical values
  • Mapping data geographically
  • Viewing specific values
  • Customizing your data
  • Analyzing data with quick table calculations
  • Showing breakdowns of the whole
  • Highlighting data with reference lines
  • Making your views available

 

Data Storytelling

Definition of a Data Storyteller. These experts are equally statistically minded and artistically gifted, with experience in programming and building data models that can be visualized and turned into data stories. Data Storytellers must have excellent communication and presentation skills that’s are used in translating data analyses into layman’s terms in order to influence a business decision or action. Their job is to ensure that the derived information is not only well researched and accurate, but also understandable and easily used to explain what the data says in a compelling way.

 

Overview of the Four Keys to Data Storytelling

  • Knowing your audience
  • Preparing your data
  • Choosing the right visual and designing it well
  • Telling the story

 

The Key Elements (D.R.A.P.S.) of Data Storytelling

  • Visualization is the fastest bandwidth channel for transferring high dimensional information into the human brain (Direct)
  • Visualization uncovers cause and effect relationships (Relationships)
  • Visualization grabs attention (Attention)
  • Visualization uncovers hidden patterns (Patterns)
  • Visualization separates data structure from data noise (Structure)

 

We only offer limited seats, register now at:  http://bit.ly/DataAnalyticsTraining30 or email us at info@sonicanalytics.com | marketing@sonicanalytics.com or call at (02) 968 1756

 

 

 

 

 

 

 

 

 

Advertisements

DATA Analytics 3.0: Big Data, Data Value Chain and Data Visualization with Tableau – February 20-22, 2018

DMAIPH is proud to present this 3-day Data Analytics training that covers different aspects of data identification, collection, storage, transformation, and analysis and involve hands-on use of common data management and analysis tools such as Excel, SQL and in depth learning of the tool “Tableau”, this is also designed for those with little to no prior experience with these tools.

Analytics Experts Dan Meyer (DMAIPH) and Dominic Ligot (Cirrolytix) have joined forces to offer a unique training focusing on both the Analysis and the Management of Big Data.

Attendees will learn how to identify the right data, how data can be efficiently stored, then transformed into a friendly form for analysis, and finally how data analysis can yield insights.

 

LEARNING SESSION OBJECTIVES:

  1. Apply cutting edge technologies to organize, interpret, and summarize Big Data in your business.
  2. Create a process to analyze data and identify patterns not apparent at first glance
  3. Understand the components of The Data Value Chain: Ingestion, Storage, 
Transformation, Analysis – and how they are all important to deriving value from data.
  4. Learn database manipulation and processing basics using the Structured Query Language 
(SQL)
  5. Connect a data analysis tool such as MS Excel or Tableau to a database to be able to 
perform analysis on processed and stored data

 

IN THIS SESSION, YOUR ORGANIZATION WILL BE ABLE TO USE:

  • Specific skills to effectively frame the problem you’re addressing to uncover key opportunities and drive growth
  • Critical marketing steps of orientation necessary before engaging tools and technology
  • How to simply and quickly amplify decision making by separating the signal from the 
noise
  • A framework for asking the right questions, allowing the ability to link analytics to 
business strategy

 

IN THIS SESSION, YOUR PARTICIPANTS WILL BE ABLE TO:

  • Learn the best practices for organizing, summarizing, and interpreting quantitative data
  • Create a repeatable process for analyzing your data
  • Shorten the time between analysis and action to avoid “analysis paralysis”
  • Know how to get from hard data to well-reasoned conclusions

 

WHO SHOULD ATTEND:

  • Business Analysts, Data Analysts and other Analytics Professionals
  • Business professionals who are involved in day-to-day analysis of data.
  • Data analysts who are already performing analysis using spreadsheets but struggle with manual data processing.
  • Managers of analysts or staff who spend a significant amount of their time collecting analyzing and reporting data.
  • IT and Development Staff that work closely with business leaders and decision-makers.

 

Continue reading “DATA Analytics 3.0: Big Data, Data Value Chain and Data Visualization with Tableau – February 20-22, 2018”

We’re looking for Digital Marketing and Business Development Officers

Digital Marketing Officer

Job Scope:

  • Devise strategies to drive online traffic to company website.
  • Manage and Develop Digital Marketing Campaigns.
  • Manage and oversee the company website and other digital/social media channels as well as implementing digital marketing campaigns.
  • Assist in the planning and budgetary control of all digital marketing campaigns
  • Evaluate digital SOV and competitor data
  • Managing the company’s design requirements, particularly print and digital collaterals and PowerPoint presentations
  • Must be amenable to work in Kapitolyo, Pasig City and Ortigas Center.

 

Qualifications:

  • Graduate of Digital Marketing and Multimedia Arts or similar courses preferred.
  • Proficient in Photo and Video Editing (Adobe Photoshop or other tools).
  • Experience using all or any of the following: Adword, Adsense, FB and Linkedin Ad is an advantage.
  • Proficient in MS Office.
  • At least 2 years relevant experience in a similar role is required.
  • Good command in both written and spoken English.
  • Excellent interpersonal, communications, analytical and problem- solving skills.
  • Can keep up with latest Digital Marketing trend.

 

Business Development Officer

Job Scope:

  • Act as representative of the company during external and internal events
  • Assist in the implementation of Digital Marketing Strategies created by DMO.
  • POC for any analytics trainings/services related inquiries.
  • Manage and organize Analytics Trainings in or outside Metro Manila.
  • Supervise database of client relationship management and utilize the result to manage customers and update mailing lists.
  • Assist in Social Media Blitzes and email invitations.
  • Update and maintain financial related trackers.
  • Provide guidance to interns/OJT.

Qualifications:

  • Candidate must possess at least Bachelor’s/College Degree in Business Administration, Marketing, Accounting/Finance or equivalent.
  • At least 2 years of working experience in the related field is required for this position (Preferably as in Marketing or Business Development).
  • Excellent communication skills.
  • Ability to get along with people at all levels.
  • Strong problem solving and creative skills.
  • Can work with minimal supervision, under pressure and can keep to deadlines.
  • Strong sales and negotiation techniques.
  • Organizational Skills and attention to details.
  • Must be amenable to work in Kapitolyo, Pasig City and Ortigas Center.
  • Self-Motivated and have initiative.
  • Proficient in MS Office (Word, Excel, PPT, etc.).

 

These are full-time 8-hour office job in Pasig City.

Send your resume at info@sonicanalytics.com

Big Data Analytics 101 in Cebu

Our first ever Big Data Analytics 101 Training in Cebu was a success.

About 40 people have attended the training last October 16 in Hotel Asia, Cebu City. Analytics and Data Science experts Mr. Dan Meyer and Mr. Dominic “Doc” Ligot did an exceptional job of sharing their knowledge and expertise in Big Data Analytics and Data Value Chain.

Cebu has proven that Philippines indeed can be an Analytics Hub, despite that our participants came from different industries and has different background; they’ve expressed equal interest in improving their business operation and career with Analytics. This type of enthusiasm shows that even though Philippines has a long way to go when it comes to Data Science and Analytics, we are still on the right track in building talents and businesses that can be as competitive as other countries in this Digital Age.

On the first half of the training, Dan was able to demonstrate how to build a strong foundation for Data Analytics. From establishing clear objectives when using data, to giving out relatable examples of how can you effectively use analytics in your business. Doc then took the second half of the training with a more technical approach. Using excel, attendees were able to learn statistical analysis, linear regression, time prediction, what – if analysis and a lot more.

 

Here are some key takeaways from the training:

  1. Establishing clear objectives when using data: Context, Needs, Vision, Strategy and Outcomes.
  2. Identify and resolve problems associated with Data Collection
  3. Use of Data Map to analyze big data in your business.
  4. 3 I’s of cutting edge analytics: Identify, Inventory and Integrate data.
  5. 3 T’s of cutting edge analytics: Talent, Technology and Technique.
  6. Important KPIs
  7. Ways to improve Management Reportings
  8. Building a data map
  9. Business Intelligence
  10. Elements of Data Storytelling
  11. System Preparation using Excel
  12. Defining a Regression Problem
  13. Predictive Analytics
  14. Data Applications (Prescriptive Analytics)
  15. What- if Analysis

 

Sharing some feedback from our participants when asked how this training would change their practice today:

After this training, I’ll be more open minded on what data points can be used other than the typical/common volume, frequencies, FTEs, etc.

“I hope to create a customized data analytics system in my scope of work using this training as guidance “

“Being more efficient with data and improve my output.”

“Innovation on my teaching career”

“Bank on good data governance and start with basic analysis”

“Be aware and look for opportunities to gather and let data drive business decision”

 


 

Picture1

Visayas Analytics Freelancers

After Big Data Analytics 101 training, Mr. Dominic Ligot conducted the first ever Analytics Freelancers Meet-up of the Visayas Chapter with the help of our ground partner, Joseph Rivera. Cebuanos who participated was able to learn different ways to monetize their skills and how to solve real – life problems using data. To be a member of this group, you can join at https://www.meetup.com/Visayas-Analytics-Freelancers/

Being able to witness this group of talent joining together to make a difference in our country was very humbling. Special thanks to Dan and Doc for sharing their knowledge and offering their time and resources to uplift our filipino talents.

Picture2

In pursuit of making a difference, Dan and Doc is part of an association called “Analytics Association of the Philippines”. AAP is the enabling organization formed to take the lead in driving the growth and evolution of Data Science and Analytics (DSA) in the country. AAP aims to serve the DSA needs of the government, the academe, the business sector, DSA consultants, training providers, DSA practitioners and aspiring professionals. Its goal is to cut across different sectors and industry horizontals and verticals to propagate and advocate DSA in the Philippines.

To learn more about their association visit their website at www.aap.ph or like their FB page at www.fb.com/analytics-association-of-the-philippines-2050534708499754

Sending my thanks and appreciation to Leenah – Leen Arandia, Jacquelyn Belmonte and my whole marketing team for assisting and helping us in the preparation and implementation of Big Data Analytics 101 in Cebu, you are a big part of making this event possible. 🙂

Next run:

Big Data Analytics 101 in Davao on November 25

Big Data Analytics 101 in Bacolod on December 8-9 (Details will be made available soon)

Big Data Analytics 101 in Ilo-ilo on January 12 (Details will be made available soon)

 

Photos from the event:

 

Digital Marketing Analytics on November 24

In partnership with Cirrolytix, DMAIPH presents to you Digital Marketing Analytics Training happening on November 24 (Friday, 9AM – 5PM) at Astoria Plaza, Escriva Dr., Ortigas Center, Pasig City.

This course builds on the theory and foundations of marketing analytics and focuses on practical application by demystifying the use of data in marketing and helping you realize the power of visualizing data with artful use of numbers found in the digital space.

Session One: Digital Marketing and Analytics

  • Objectives of Digital Marketing
  • Data Value Chain in Digital Marketing
  • Data analytics roles in Digital Marketing
  • Analytics: Descriptive, Predictive and Prescriptive

Session Two: Data Visualization Primer

  • Which chart for which question
  • Time-series analysis in Digital
  • Composition analysis in Digital
  • Scatterplots and comparative analysis in Digital
  • Heatmap analysis in Digital

Session Three: Predictive market segmentation

  • Market segmentation concepts
  • Market behaviour analysis
  • Assigning customers to the right clusters

Session Four: Recommendation engines

  • Market basket analysis and product affinity
  • Predicting next best product purchases

Session Five: Marketing Attribution

  • Creating an attribution model
  • Predicting marketing to sales performance
  • Marketing model optimization and sensitivity

Session Six: Sentiment Analysis

  • Text analysis primer
  • Processing unstructured data
  • Predicting social media response

Session Seven: Digital Analytics Maturity

  • Review of analytic maturity levels
  • Creating a data-driven culture
  • Learnings from disruptive data-driven companies

 

Training Investment:

EXCLUSIVE OFFER! Pay on or before October 30, 2017
P4,000 + VAT/ Participant

EARLY BIRD: Pay on or before November 10, 2017
P6,000 + VAT/ Participant

GROUP RATE
P6,500 + VAT/ Participant

REGULAR RATE: Starting November 11, 2017
P7,300 + VAT/ Participant

Investment includes AM/PM Snacks, Buffet Lunch, Workbook, Copy of the Presentation, Training Materials, Raffle Prices and Certificate of Completion. 

To register: http://bit.ly/2pzFQxx

For inquiries: analytics@dmaiph.com | (02) 959- 8017 | 0917-799-2827 |www.sonicanalytics.com