The Rock Stars of Data: Big Data Analytics & Data Management

How to master big data analytics and data management?

The Rock Stars of Data: Big Data Analytics & Data Management

2-day Class: Big Data Analytics and Data Management

June 27-28, 2017

Discovery Suites, ADB Ave., Ortigas Center, Pasig City

9AM-5PM

Rock Stars of Data Series: Big Data Analytics & Data Management

Data Rock Stars 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.

To find out more about our next scheduled public learning session on May 18-19, 2017 in Ortigas or to set-up an in-house training, send an e-mail to analytics@dmaiph.com

Learning Session Description

Building The Data Value Chain. Data is pervasive – everything we do in the modern world uses and generates data in some shape or form: from web sites we surf, the social media we consume, to the mobile devices we use to connect and communicate. Modern businesses also use and generate data, from financial data, to customer data, to transaction data and sensor data.

But data is only a raw material. Regardless of amount, the real importance of data is only determined by the value people and businesses derive from it. Getting data is the first step. Then the challenge becomes transforming the raw material into a processed good: information. Information enables decisions, and decisions create value.

This session is about the basics of transforming data into information: the data value chain. Attendees will learn how to identify the right data, about how data can be efficiently stored, then transformed into a friendly form for analysis, and finally how data analysis can yield insights.

This seminar will 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, Tableau and SQL, but is designed for those with little to no prior experience with these tools.

Learning Session Objectives

Apply cutting edge technologies to organize, interpret, and summarize Big Data in your business.
Create a process to analyze data and identify patterns not apparent at first glance
Understand the components of The Data Value Chain: Ingestion, Storage, Transformation, Analysis – and how they are all important to deriving value from data.
Learn database manipulation and processing basics using the Structured Query Language (SQL)
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.

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.
Tableau Public Demonstration,
Discuss the Concept of Data Visualization.
Build A Business Dashboard Prototype.
Apply a Process to Present Big Data Clearly.

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.

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.

Minimum Hardware and Software Requirements.

Laptop with Intel Core i3 and 4GB RAM.
Windows OS with Excel 2007 or greater.
ODBC and database connections will be provided during class.

Case Studies and Exercises

Dan and Doc will use case studies and group exercises throughout the two-day class. In these activities, the group is divided into teams. Each team will analyze datasets using the principals learned in the various learning sessions. These exercises will also use elements from the case studies as we progress from finding data, to conducting analysis on the data and finally presenting the data.

Learning Investment for 2-day Seminar:

Exclusive Offer!!

Early Bird Rate

P 12,000.00 + VAT

(Pay the full amount on or before April 20, 2017)

Group Rate (Minimum of 5)

P13,000.00 + VAT

Regular Rate:

P 14,600.00 + Vat

(starting April 21, 2017)

All investments includes: 2-day Analytics Seminar with two of the most in-demand Analytics and Data Management Guru in the Philippines, complete with Training Materials, AM/PM Snacks, Lunch and Certificates.

ABOUT THE SPEAKERS

Dominic Ligot, Data Scientist

Doc’s areas of expertise focus on Fintech, Big Data Analytics, and Digital Transformation.

Click here to see Doc’s full speaker/trainer profile >>>

Daniel Meyer, Analytics Champion

Dan specializes in a variety of analytics themed training and speaking option including HR& Recruitment Analytics, Data Analytics, Data-Driven Decision-Making and Analytics for CEO’s.

Click here to see Dan’s full speaker/trainer profile >>>

Reserve your seat here >>>

Philippine BPO’s urged to prepare for Artificial Intelligence

Sharing from the Global Chamber® Manila Newsletter

April 7, 2017

Philippine BPO’s urged to prepare for Artificial Intelligence

An American technology and business expert urges Business Process Outsourcing (BPO) companies to prepare for the disruption that will be brought about by artificial intelligence (AI). The Department of Science and Technology (DOST) recently held a talk about how to prepare for the time when intelligent computers take over call center agents’ jobs.

Dr. Ted Ladd, who is on a lecture tour of the Philippines, says the technology for artificial intelligence is already here. While some experts say AI’s impact on BPO’s will be felt in five years, Ladd says BPO’s and entrepreneurs should already be preparing for this and start looking for new opportunities that will be opened up by AI. According to Ladd, “We don’t have to wait for the industry to show cracks before entrepreneurs prepare new solutions.“ AI is not just going to create new products or services but will create new business models which entrepreneurs could take advantage of.

DMAIPH is working on a new learning session offering entitled Surfing Into The Storm; A Guidebook on How to Turn Your Call Center into an Analytics Hub. Stay tuned for more info on the upcoming course.

482x140

You can also catch the topic on Augmented Intelligence: Robotic Process Automation in BPO at the Digital Transformation Summit on May 24 & 25 at SMX Aura Convention Center, BGC

As a founding member of Gloabl Chamber Manila, DMAIPH specializes in a variety of analytics consulting solutions designed to empower analysts, managers and leaders with the tools needed for more data-driven decision-making. We have helped dozens of companies get more analytics in their business. Contact DMAIPH now at analytics@dmaiph.com or connect with me directly so we can tailor an analytics solution made just for your unique requirements.

Decision-Making with Data Learning Session with Ariva Events

This coming Friday, March 31, in Ortigas, I will be Data-Driven Decision-Making for Executives, Managers and Leaders. I will focus on proven strategies of data mastery go a long way to becoming a Data-Driven Leader.

This master class is for you if you feel like you’re drowning in data and unsure which data to use to drive your companies decision-making processes.

Information is supposed to make decision-making faster and easier, but more often than not, it simply overwhelms our ability to accurately use the data we have in our business.

The truth is that the amount of data available to help run your business is greater than ever before. To effectively use this information, exeuctives, managers and leaders must consider the practical side of big data and how best to use it to make better decisions…because what matters to you is how do you grow and build a team to make smarter decisions. Much of the information out there just discusses the promise of the data deluge.

The challenge is not the volume of data but rather the judgment needed to use it. This learning session is specifically designed for executives, managers and leaders to learn techniqeues that will ensure reliable business decisions can be made based on the massive amounts of data at your fingertips.

Through a series of case studies, exercises and interactive lecture, we will cover the following:

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

Attendees will also be able to learn how to do the following things for their team:

Learn the best practices for organizing, summarizing, and interpreting quantitative data
Create a repeatable process for analyzing your data
Bring out patterns in data that were not apparent at first glance
Identify and explain tools for data analysis
Shorten the time between analysis and action to avoid “analysis paralysis”
Know how to get from hard data to well-reasoned conclusions

There are still seats available, contact me at danmeyer@dmaiph.com so I can connect with you my events partner, Ariva.

http://www.ariva.com.ph/data-driven-decision-making/

Radio DWDD today @ 11am – The Analytics of Blogging

Blogging has been around for quite some time now, but many who venture into blogging do not realize who is reading their blogs, what are they reading, why are they visiting and reading their blogs, and so on.

So, today I have the honor of being a special guest on DWDD to help listeners go through the realms of the analytics of blogging.

The topics I plan on covering include:
– What is analytics?
– What title/position/employee is involved in anlytics?
– What university/college course do you take to learn analytics?
– What kind of companies uses analytics?

And Blogger-specific topics will include:
– Should bloggers learn to use analytics?
– Why use analytics in blogging?
– How does a blogger begin to use analytics?
– Can analytics make the blogger earn money?

Come join me and my good friends Raffy, Ron and Ian to discuss how to get more data into your blogging efforts. Its easy and for the most part its free.
#TODAY 20th March at 11:00AM, the BLOGGERS’ HOUR talks about Blogging and Analytics, and why bloggers need to start measuring their blogs beyond just views and hits. To help us understand how to do this is Analytics Expert Dan Meyer from San Francisco who has set up shop in the Philippines with his advocacy of teaching Filipinos the art of analytics.

Tweet or post your questions in advance using the Hashtag #BLOGGERSHOUR.

LIKE http://www.facebook.com/bloggershour to be notified when the Facebook LIVE stream begins.

Tune in to DWDD 1134 kHz AM or live streaming via http://www.dwdd.com.ph or http://www.ustream.tv/channel/dwdd-katropa-live.

TWITTER:

Listen to the #BLOGGERSHOUR talk radio show, Monday 20th March 11:00AM as we talk about blogging & analytics with Dan Meyer @BPOElite1

Data Science Philippines – Feb 2017 Meet Up

My talk is the 2nd one, a little over half way through the video. Listen first to some real data scientists talking about their trade, then it’s my turn where I talk about just how many data scientists there are in the Philippines right now. Thanks to DataSeer for asking us to sponsor and for setting up the event. Looking forward to many more to come! 🙂

Stone Age Analytics

I was chatting with a friend about Peter Drucker’s famous quote, “Culture eats strategy for breakfast.”

He made a point that made me think this lesson is still hard to actually put into practice even though it’s a 50+ year old concept. In fact the idea that a good culture is more important than a good strategy is as probably as old as man.

My reply was the best run caves where probably run by the caveman with the most efficient hunters and gathers, who felt a common purpose that their leader empowered in them.

In many senses, analytics has been around since day one. Even before we had basic math, just by observation cave men that survived told stories to explain where the best hunting grounds where and things like saber toothed tigers are bad for your health.

Centuries before Lean and Six Sigma, human engaged in process improvement. And Im sure the smartest cave man (or woman) in the cave ended up being the data guy who did some kind of simple analytics to advice the chief on who was the best hunter and who was the best candidate to use as bait to stampede a mammoth into a box canyon.

My point is, analytics is not anything new. In fact most businesses don’t have good analytics because they think its too complicated and too expensive. Now maybe employing a data scientist to build a state of the art predictive modeling tool, is a bit to Space Age for some, but everyone needs to have at least Stone Age Analytics.

That’s where DMAIPH comes in. We specialize in helping companies who feel like their analytics are stuck in the Stone Age evolve.

Analytics Training – DMAIPH offers a wide range of analytics centric training solutions for professionals and students via public, in-house, on-site, and academic settings. We tailor each training event to meet the unique needs of the audience. If you need empowerment and skills enhancement to optimize the use of analytics in your organization, we are here to help. Contact DMAIPH now at analytics@dmaiph.com or connect with me directly to set up a free consultation to learn which of our DMAIPH analytics training solutions is best for you.

Data Analytics or HR Analytics? Which Should I Attend?

Here at DMAIPH we offer a variety of analytics training solutions to organizations here in the Philippines.

Our two most popular offerings are Data Analytics and HR/Recruitment Analytics.

We get asked a lot, what is the difference.

Well, in general the Data Analytics classes like our Big Data Analytics & Business Intelligence training this coming May 18, are designed for a general audience.

HR/Recruitment Analytics classes like the upcoming HR Big Data & Recruitment Analytics training on March 14 in Ortigas, is designed for a much more specific audience of HR and Recruitment professionals.

Data Analytics attendees come from a wide range of companies and have perform a variety of job functions. The one thing they all have in common is that they are looking for data analytics techniques and technologies to help them get a handle on all the Big Data they have to work with everyday.

HR/Recruitment Analytics attendees are all working as part of Talent Management teams in HR, Recruitment, Training, Operations and other parts of an organization that primarily handle people data. So case studies, exercises and the lesson plan itself are all focused on how to use the people data in the business to enhance and empower people centric decision-making.

HR and Recruitment professionals can benefit a lot from attending the Data Analytics trainings and we generally have a few do just that. However, for a more focused approach to getting a handle on people data, the ones who attend the HR/Recruitment Analytics trainings will probably get a little more practical application to use when they return to the office.

Target Attendees for Data Analytics:

Data and Business Analysts
Managers and Supervisors of Analysts
Professional Staff who create reports and manage data
Decision-Makers who need more analytics

Target Attendees for HR/Recruitment Analytics:

HR and Recruitment Analysts
HR and Recruitment Managers and Supervisors
HR and Recruitment staff who work with a lot of people data
Data and Business Analysts who work closely with people data

Hope that helps you decide which one to attend.

HR & Recruitment Analytics: 3 Reasons You Need More (Mar 28 – Ortigas)

On March 14, 2017 in Ortigas, I will be conducting a learning session on HR and recruitment analytics entitled HR Big Data & Recruitment Analytics.

Click here for more details and instructions on how to register >>>

The 3 top reasons for anyone working in human resources and/or recruitment to attend are:

To learn analytics techniques that will allow quicker, deeper and more impactful analysis of HR Big Data & Recruitment Analytics.
To be exposed to cutting edge technology being used to build predictive HR models for all aspects of talent management from recruitment to training to retention.
To assess the current state of analytics in your business and build a strategy to empower the greater use of both descriptive and predictive analytics in your organization’s decision-making processes.

HR Big Data & Recruitment Analytics – The recruitment and retention of top talent is the biggest challenge facing just about every organization. You really have to Think Through The Box to come up with winning solutions to effectively attract, retain and manage talent in the Philippines today.

DMAIPH is a leading expert in empowering HR & Recruitment teams with analytics techniques to optimize their talent acquisition and management processes. Contact DMAIPH now at analytics@dmaiph.com or connect with me directly to learn how to get more analytics in your HR & Recruitment process so you can rise to the top in the ever quickening demand for top talent.

HR & Recruitment Analytics: Win The Talent War (Mar 28 in Ortigas)

Updated 11/19/16

It’s pretty clear to anyone who is paying attention that the current talent acquisition challenges facing BPO’s in the Philippines is getting worse at an alarming pace.

This trend is echoed across the planet as we have had a global failure in approaches to preparing the youth for the careers we need them to fill. There are several initiative underway in the Philippines to address this, but at this point its just a drop in the bucket when you look at the projections for talent with analytics skills, management potential and a strong work ethic.

Check out our next training on March 14 in Ortigas. Here is the link >>>

I recently came across this post on LinkedIn that outlined 5 things that we need to work together to do to make sure the generation hitting the workforce now and especially the generation now in school, ready for prime time.

The talent shortage is particularly serious at the middle-management level as companies dither over how to develop high-potential entry-level employees into more senior roles within their organisations.

Solving it requires planning for the long-term and building a talent investment strategy into the corporate culture, which suggests that solving the talent shortage calls for new thinking, new approaches, and collaboration on an industry-wide scale.

Relying on the traditional education path – universities – to fill the talent needs won’t work because that will take years. We a faster solution – one that combines a multi-pronged approach, and one that is collaborative across all players in the business.

The article concludes with five ways of helping to solve the talent crisis threatening companies small and large all across the globe.

Industry collaboration: Industry leaders joining forces to work with universities, colleges and trade associations to develop specific education programs to fill the expected openings.
Expanded in-house and external education options: A growing number of firms are developing their own education programs making full use of senior existing internal expertise.
Job rotation programs: A ‘talent exchange’ rotation to promote cross-functional development, which would also keep employee interest.
Formalised knowledge transfer: Capturing people’s knowledge before it “literally walks out of the door” into retirement.
Becoming an employer of choice: Taking steps to ensure that the company is an attractive place to work by providing competitive salaries linked to a valued career path.

DMAIPH can help you by consulting with your management team on how to get ahead of the curve, by providing training to your team on how to optimize your talent acquisition an retention programs and/or by providing you with talent to fill your open positions.

HR & Recruitment Analytics – The recruitment and retention of top talent is the biggest challenge facing just about every organization. You really have to Think Through The Box to come up with winning solutions to effectively attract, retain and manage talent in the Philippines today.

Using Data To Recruit Better Candidates (Next Training Mar 28)

A few blog posts ago I mentioned 2 important recruitment analytics data points that can be used to help better understand attrition; distance to work and difficulty of commute. If a recruitment team has a way to use data on these two metrics in their screening process, they will be able to spend less time on high risk candidates and more time on candidates who have a much higher chance of sticking with the company.

It is not hard to start tracking these data points, as long as you have their home address, a general knowledge of traffic patterns and two very useful free tools to help in your analysis. The free tools can be found at www.itouchmap.com and www.tableau.com/public

Based on the 50 Customer Care Analysts my team has hired for our 17 seat customer care team over the past 2.5 years, you can see some clear patterns when you look at their home addresses and commute on a map.

As you can see below, the majority of our candidates who turn into long term hires live closer to the office and along easier traffic routes. As a general rule, one direct ride (bus, train or shuttle) generally equates to stickiness of the candidate. Even some who live closer distance wise, but face multiple rides have a higher attrition rate than those who live a little further but have one ride. For example, taking a bus from the central part of Quezon City might be easier then 2-3 jeepney rides from Taugig, even though the distance from Taguig is much closer.

The map, created in Tableau Public, is generated on knowing the latitude and longitude of their home address (from their resume), which can be looked on using itouchmap. The whole project took less then 2 hours to compile, organize and upload the data into Tableau, then seconds to build the map.

During our first year as we hired people from a wider range of places we had much higher attrition (65%), but as we matured as a business along with our understanding of these and other key metrics, our attrition has dropped significantly in the past year (28%).

As elaborated on more in detail in previous posts, distance to work and difficulty of commute are not on their own data points to be used to screen candidates, but when combined with their interview scores, test and assessment results and reference checks, you can have a much more well-rounded view of the candidate’s potential.

If you would like some help us setting up this same process of capturing distance to work and difficulty of commute and building a map to visualize them, feel free to reach out to me. I have a book, this blog, lots of training materials and I speak about analytics frequently. I’m here to help.

Our next training is March 14 in Ortigas, click here to learn more >>>

	DMAIPH on You Don’t Build A Busine…
	Ioliveiraserpa on You Don’t Build A Busine…
	DMAIPH on The Current Analytics Talent L…
	John on The Current Analytics Talent L…
	Dominic on Outsourcing Tip > Size the…