The Day I Got My Cape

About halfway through my time at Wells Fargo, I had become one of the top analysts at the bank. My ability to take on any data project and deliver results on time and on budget established my reputation and gave me credibility to speak frankly with senior executives

Now what I mean by “the day I got my cape”. That was the day I realized that my skills as an analyst, as somebody who works with data, had become somewhat superhuman.

I had previously shared the lead up to the unveiling oh my superhero story. After acquiring Wachovia, Wells Fargo was poised to launch the Express Send remittance service in Miami. I had shared my concerns and even though the data was clear, I was outvoted.

At the end of the meeting, my boss came to me, and my boss; who I had been working for quite a while, and when I raised my hand in a staff meeting to talk about something to do with data, I was usually right. However he pointed out to me, I had talked about a problem but I didn’t offer a solution and he says you know what Daniel, “If we’re going to not launch in Miami you got to follow up with an answer of where we going to launch and why. As well as why should we move it based on solid financials”.

My reply was, “you’re right, I know I need to go back and do some more research”. He told me that I had a couple days go do some research, to figure this out. He said if we have a good business case to move it, we would run it up the flagpole and see what happens. So, I went back to my cubicle, I started crunching numbers, pulling data, basically what I found was indeed the truth. I was right that if we were to launch in Miami. We would not have a very big population of ready to send users. People that are used to us and, our brand that trust has to send money overseas.

It would be something that it would have to take a while for people to adopt to our brand. I started looking for areas where there were other populations, that were more representative of what we had to do traditionally. I came across a couple, if you look at the demographics of Florida in the Orlando and Tampa areas in the middle of the state, there’s a lot more people that have migrated from Central America and Mexico. A lot of them migrated there to work in agriculture, to work in more labor-intensive industries.

I took data form the U.S. Census and I blended that with projections on adoption rates based on the traditional Wells Fargo footprint. I used IBM-Cognos and SQL queries from the banks central data bases to extract the data I needed to build a financial model. The model illustrated that we would make 3x as much over the first three years in remittance transfers in Florida if we started in Central Florida as opposed to South Florida. To bring it all together I used a new software, Tableau, to build a map and supporting visuals. I was ready for round two and this time I had my powers.

So, I took that information and I put together a presentation, and I walked to my boss. He said, “great OK let’s go ahead and talk to the boss about this”, so when my boss said to THE boss that means we are talking to top executives at the bank, including the CEO.

The next day I presented this data and I did it in a new way for me. I built a narrative around the whole challenge we had and used the data told us what we should do. I illustrated with the Tableau map, what the expected benefits of West Orlando instead of Miami. When we did that, we would see a much greater adoption rate, we would see much greater financial benefit much sooner than if we were to launch in the Miami area.

My slides and the data and visuals on them where very convincing. But that was the appeal to the head. I also shared the impact that my suggestion would have not only on the bank bottom line, but the difference it would make to our customers and their families. When I did all that, I put this whole overarching narrative together and what was able to do what we now call data storytelling.

That is a superpower in even more demand today that it was 10 years ago. Being able to write code, to build data models and to work with millions of data points are all very powerful tools in the hands of a good analyst. But data storytelling in my hands, that is a superpower.

Oh, and one more point, mostly because of my work on the merger, I got a really huge bonus that year.

Daniel Meyer heads Sonic Analytics, an analytics firm with offices in Manila, the San Francisco Bay Area and Ocala, FL. With over 20 years in Big Data, Dan is one of the most sought-after public speakers in Asia and offers big data coaching and analytics training seminars on both sides of the Pacific. Dan has also recently joined the Powerteam International family as a small business analytics resource speaker.

Sonic Analytics(www.sonicanalytics.com) brings big data analytics solutions like business intelligence, business dashboards and data storytelling to small and medium sized organizations looking to enhance their data-driven decision-making capabilities. We also advocate the use of analytics for civic responsibility through training, consulting and education.

As citizens of this great democracy, we need to look at the data (analytics), plan a course of action (strategy) and share our data-driven viewpoints (presentation). This approach to a data savvy work force starts in school. So, we started an internship program to empower our youth to use Analytics, plan Strategy and Present their insights… ASP!

When not training current and future analysts, you can find Dan championing the use of analytics to empower data-driven citizenship by volunteering his expertise with schools and non-profits dedicated to evidence-based social progress like Saint Leo University’s Women in STEAM 2020 Conference.

Advertisement

So What Is #DataRockPinas?

It is a movement.

It is an advocacy.

It is a great cause.

#DataRockPinas is all about taking analytics training out of Manila and bringing it to the provinces.

#DataRockPinas is all about taking what has traditionally been an expensive, corporate only training and delivering it to hundreds of thousands of Filipinos.

#DataRockPinas is an initiative of several member companies of the Analytics Association of the Philippines. http://www.aap.ph

Screen Shot 2017-11-06 at 9.45.43 AM

  • Data Night UM (University of Mindanao)
  • Big Data 101 Davao
  • Davao Analytics Executive Roundtable
  • Mindanao Analytics Freelancers Meet Up

Screen Shot 2017-11-06 at 9.45.53 AM

  • Big Data Analytics & Data Value Chain
  • Train the Analytics Trainer
  • Data Night Bacolod

Screen Shot 2017-11-06 at 9.46.02 AM

  • Big Data 101 – Iloilo
  • Visayas Analytics Freelancers
  • Data Night Iloilo

Screen Shot 2017-11-06 at 9.46.12 AM

  • Big Data Analytics & Data Value Chain
  • Data Night Cebu 2018

philippines_640

Analytics in the Philippines – The Philippines is at the center of the action when it comes to solutions to the global need for analytics. Blessed with a solid foundation of young, educated and English speaking workforce, companies around the world are look for Filipino analytics talent to fill analytics positions.

Analytics Leadership – DMAIPH is a founding member of the Analytics Association of the Philippines (AAP.PH) and specializes in arming the Data-Driven Leader with the tools and techniques they need to build and empower an analytics centric organization. Analytics leadership requires a mastery of not just analytics skill, but also of nurturing an analytics culture. We have guided thousands of Filipino professionals to become better analytics leaders.

Contact DMAIPH now at analytics@dmaiph.com or connect with me directly to discuss a uniquely tailored strategy to ensure you are the top of your game when it comes to Analytics Leadership.

Moonshot: Unifying the Analytics Ecosystem Across the Philippines

(above image from zazzle.com)

For most of the past five years my efforts to upskill train Filipinos in analytics have been focused on Metro Manila.

A few times a year I’d get a chance to conduct a training, speak at an event or attend a conference outside the National Capitol Region, but for the most part analytics adoption has been slower in the provinces.

That has significantly changed in 2017 and the analytics focus around the provinces is primed to explode is 2018.

As I sit here today in Batangas for the mid week holidays, I can’t help but feel proud for the recent string of partnerships we have been able to build outside the nation’s capitol.

We were just in Cebu twice for a Data Night, a Big Data 101 training and an Analytics Freelancers Meet Up. We followed that up with a Data Night and several speaking engagements and media appliances in General Santos (Gensan to the locals).

Next month we will replicate these events in Davao with the contacts we made in Gensan. In December we will do the same and even add a Train the Analytics Trainer event with a key business partner in Bacolod.

And just yesterday we started laying the ground work for a Data Night and a Big Data 101 training in Iloilo for January.

Our plan for 2018 is to spend one week a month in a different province promoting our analytics advocacy, signing up members for the Analytics Association of the Philippines, conducting trainings with companies like DMAIPH, Cirrolytix, BagoSphere, and Spectres Solutions, using co-working spaces like A Space, the Mabuhay I.T. Park and Dream Space, and working with schools like the University of Mindanao and ACLC Davao.

At the same time we are building upskill training relationships back in Manila with companies like Wells Fargo, Accenture and Emerson, teaching analytics at schools like College of St. Benilde, University of Asia & Pacific, Enderun College and the University of the Philippines just to name a few.

We are also orchestrating the OJT experiences for students from schools like UST, De La Salle, Ateneo, Informatics, and URS in Rizal. Again, that is just the tip of the iceberg.

Simultaneously, we are building relationships with influential organizations like IBPAP, CCAP, PSIA, Young Engineers and HIMS to give talks on analytics followed up with upskill training for their members.

And last but not least we are having conversations with provincial LGUs, with central government entities like CHED, DeptEd and TESDA as well as with key members of the Senate to promote the large scale adoption of analytics across the Philippines to keep our workforce competitive in the increasingly data driven world.

I could go on and list more. The names above are just a sample.

When you set out to facilitate the upskill training of half a million people, you have to think big. And thing big is what we do.

That’s our moonshot.

Putting a man on the moon took a national effort from all parts of society to build a space age ecosystem capable of the previously unthinkable.

rocket-moonshot-shutterstock_406207303-resized

Analytics Leadership – DMAIPH is a founding member of the Analytics Association of the Philippines (AAP.PH) and specializes in arming the Data-Driven Leader with the tools and techniques they need to build and empower an analytics centric organization. Analytics leadership requires a mastery of not just analytics skill, but also of nurturing an analytics culture.

We have guided thousands of Filipino professionals to become better analytics leaders. Contact DMAIPH now at analytics@dmaiph.com or connect with me directly to discuss a uniquely tailored strategy to ensure you are the top of your game when it comes to Analytics Leadership.

DMAI - Logo_ver2-02-01

 

 

Meet the Founders of the AAP at the Big Data Conference on Nov 15 @ SM Aura

AAP Logo Option Vertical 5

Meet the Founders…
Daniel Meyer
Executive DirectorPresident and Founder of DMAIPH (Decision-Making, Analytics & Intelligence Philippines), an Analytics, consulting, training and outsourcing company with offices in Manila and the San Francisco Bay Area.He worked as a Senior Analytics Consultant for Wells Fargo Bank for 15 years. He provided executive management analytics for the bank’s remittance service including developing business dashboards, overseeing competitive intelligence gathering, managing data analytics outsourcing projects and facilitating audit and risk management.Catch him on:

  • Oct 18 – Gensan ICT Summit 2017 (SM Gensan)
  • Oct 18 – Data Night Gensan (Mabuhay I.T. Park, Gensan)
  • Oct 24
  • Oct 26-27 – HR Big Data & Predictive Recruitment Analytics
  • Nov. 15 – Big Data Analytics Summit ( SMX Aura )
  • Nov 18 – For Generation Digital by Blogapalooza (City of Dreams)
  • Nov 21-22 – Big Data Analytics and Data Value Chain
  • Nov 23 – Philippines HR Group Summit 2017 (Sequoia Hotel, Quezon City)
  • Nov 24 – Digital Marketing Analytics
  • Nov 28-29 – Analytics for HR Managers (2nd Run)
  • Dec 4-5 – Big Data for 2018
Colin Christie
Governance & Membership ChairA serial entrepreneur, connector and collaborator. He currently serves as the Executive Director of Global Chamber® Manila, and is Dean & Director of Digital Transformation at Enderun Colleges. Colin serves as a President of the Board of Trustees of the Analytics Association of the Philippines (AAP.ph). Colin has practiced a life-long passion for embracing transformative technologies, spanning many industries, from manufacturing, to software, to healthcare and education. Colin is a graduate in Chemical Engineering from the University of California at Berkeley.Catch him on:

  • Nov. 15 – Big Data Analytics Summit ( SMX Aura )
Karlo Panti
External Relations & Marketing ChairA Director of Global Production at QuintilesIMS responsible for mature markets and developed countries in the Asia Pacific and the Country Head of IMS Health Operations Center Philippines, Inc. serving as the President and Chairman. In addition, he is one of the founding members of the Analytics Association of the Philippines, serving in the Board of Trustees as the Head for External Relations.He has more than 16 years of experience in operations and service delivery, having managed large teams in different industries and geographies and migrated new business processes to the Philippines from different Fortune 500 companies.Karlo led teams servicing different verticals mainly in life sciences data analytics, insurance and healthcare, F&A, travel, transportation and logistics, high-tech, consumer and telecommunications.Throughout his career, he has improved the operational processes of different companies as a COPC Practitioner and a Six-Sigma Champion helping them grow their business with his involvement in sales, due diligence, transitions and migrations as well as automations and transformation projects.As a speaker and a facilitator, Karlo has shared his insights on leadership development, operational excellence, team building, business analytics and life sciences.Catch him on:

  • Oct 13 – 15th Philippine Institute of Industrial Engineers (PIIE) National Congress
  • Oct 25 – HIMSCON 2017
Dominic “Doc” Ligot
Research and Development ChairAn entrepreneur, software developer, trainer, and data consultant. Doc’s passions include advanced analytics, disruptive innovation, organizational change, and obtaining business value from data. He is the Founder and Managing Director of Cirrolytix Research Services which provides data and analytics support to small and medium enterprises and analytics freelancers in the Philippines.Doc teaches digital marketing analytics for the Certified Digital Marketer (CDM) program and financial analysis and management science for the American Academy of Financial Management (AAFM). Prior to becoming a tech entrepreneur, he was Asia Pacific Practice Partner for Advanced Analytics for big data analytics firm Teradata and previously held executive leadership positions at global banks HSBC and ANZ.Catch him on:

  • Oct 26-27 – Global CEM Summit Financial Services Singapore
  • Oct 21 – Bookkeepers Summit 2017
  • Nov. 15 – Big Data Analytics Summit ( SMX Aura )

Brenda A. Quismorio

Education (Academe) Chair and Data Science and Analytics Framework Co-Chair

Dr. Brenda A. Quismorio has a combined fifteen years of experience in consulting, training, project management, process reengineering, application development and maintenance, quality management, and data services work for global firms such as Andersen Consulting (now Accenture) and Watson Wyatt Worldwide (now Willis Towers Watson) and local firms such as First Philippine Holdings and Aboitiz Transport Systems (now 2GO Group Inc.).Brenda joined the academe in 2010 as an Assistant Professor at the University of Asia and the Pacific. She spearheads the undergraduate specialization program in Business Analytics.

She is a founding member of the Analytics Association of the Philippines (AAP) and the Business Analytics Society of Educators (BASE). She forms part of the Advisory Group of the APEC Project DARE (Data Analytics Raising Employment). She is currently the Board Member and Chair of the Education-Academe Committee of the Analytics Association of the Philippines. She is a resource person of a number of professional organizations and training institutes on Business Analytics.   Brenda holds degrees from the University of the Philippines (Diliman) in BS Statistics, MBA, MS in Management and Phd in Business Administration with a dissertation on modeling financial extreme risks.

Catch her on:

  • Oct. 17-18 – 2017 BSP-UP Professorial Chair Lectures (Executive Business Center, BSP Complex)
  • Nov. 15 – Big Data Analytics Summit ( SMX Aura )
Sherwin Pelayo
Data Science and Analytics Framework Chairhas been involved in strategic capability development initiatives at Accenture, IBM, and now at Pointwest Technologies Corporation. In this role, Sherwin has been responsible for defining strategies to initiate and expand key transforming digital services including identifying focus areas, defining competencies, building curricula, enabling practitioners, developing leads and opportunities, architecting solutions, and ensuring project delivery.His current focus is in Analytics and Experience Design. It is in the intersection of these two where Sherwin finds his passion–connecting the science of Analytics and the art of Human-Centered Design not only to bring data-inspired, user-driven solutions for business partners but also deliver greater, more impactful social innovation for the Philippines.Catch him on:

  • Nov. 15 – Big Data Analytics Summit ( SMX Aura )
Dr. Eugene Rex L. Jalao
Education (Academe) and Research and Development Co-ChairAn Associate Professor of Analytics and Industrial Engineering in the University of the Philippines Diliman, Department of Industrial Engineering and Operations Research. He specializes in Decision Support Systems, Business Analytics Solutions, Data Mining, Optimization and Systems Simulation. He obtained his Ph.D. in Industrial Engineering from Arizona State University (ASU) in May 2013. Additionally, he obtained his Masters of Science in Industrial Engineering degree as well as his Bachelor of Science in Industrial Engineering from the University of the Philippines Diliman in 2009 and 2007 respectively. He was inducted into the Alpha Phi Mu, Industrial Engineering Honor Society in 2012.His ten years of work and research experience are in the fields of business analytics both here in the Philippines and in the United States of America, specifically in the Banking, FMCG, Manufacturing, Real Estate, Healthcare, Telecommunications and Information Technology industries. Also, he is the current director of the Business Analytics Certification Program of UP National Engineering Center. Furthermore, he was part of 50-person APEC team that drafted the Recommended Data Science and Analytics Competencies last May 2017 in Singapore. He is also a certified SAP ERP Materials Management consultant, a Matlab computing associate and an advocate of the R Programming language.Catch him on:

  • UP NEC Analytics Certification Training Modules
  • Oct 18 – 20 – Module C – Descriptive Analytics
  • Nov 22 – 24 – Module B – Data Warehousing
  • Dec 6 – 8 – Module D – Predictive Analytics
  • Nov. 15 – Big Data Analytics Summit ( SMX Aura )

Michelle Alarcon

Education (Professional) Chair

With more than 20 years of IT consulting experience in the Philippines, US and Europe, she started her own consulting firm 4 years ago that specializes in analytics, her passion ever since she graduated with a degree in Statistics from the University of the Philippines. She trained on and practiced data mining in Spain for two years, and later on pioneered the Analytics Department of the largest local private bank in 2005.

In 2011, she was the Consulting Director for a top software company where she led a team of 150 consultants in implementing enterprise solutions for companies worldwide. Now as President and Managing Director of Z-Lift Solutions, she brings all these experiences to her clients as she defines their roadmap towards a smarter business with analytics, and enables them to make it part of their new culture as a data-driven organization. She is also the organizer of the R Users Group of the Philippines, a 4-year-old community that aims to promote the use of open source R for statistical programming in the country.

Catch her on:

  • Oct 18 – R Users Group (RUG-PH) Meetup (TIP Manila)
  • Oct 17 – Big Data and Analytics (Colegio de San Agustin)
  • Nov. 15 – Big Data Analytics Summit ( SMX Aura )
  • Nov 16 – RUG-PH Meetup (Manulife UP-Ayala Technopark)

Screen Shot 2017-10-02 at 4.25.28 PM

The Past Week Reminds Me Why I Love Analytics in the Philippines

When I left the U.S. five years ago, it was to chase a dream.

The dream although simple to me was one that many people thought impossible at the time… to see analytics becoming a topic of everyday conversations.

In business, in education, in the government and in the media over the past week, I have been part of conversations about how to empower 100,000s of Filipinos to get more analytics in what they do.

There is still so much to be done to turn this dream into a reality, but as I have talked with journalists, professors, political figures and business leaders, I keep getting the same result… the dream is now one that many share.

Some examples of the new reality…

The Analytics Association of the Philippines (AAP.PH) will be the umbrella on which so many analytics initiatives incubate, grow and prosper.

Schools like De La Salle – College of St. Benilde, the University of Asia & Pacific, and UP will continue to offer new and innovative courses built around regional standards for the enablement of data science and analytics.

New batches of students like CSB’s SMIT students taking Business Analytics subjects will enter the workforce armed with more skills then any batch before them.  They kids are learning Tableau while still in school. How cool is that?

Advocacies like Augment BPO will rise up to address clear and present threats like the one that AI presents to the BPO industry.

And that’s just the tip of the proverbial ice berg.

It’s been a really good week.  No, check that… its been a great week.

And it all reminds me of why I love this adopted country of mine so much.

jobspicture2

The Augment BPO Data Science and Analytics Advocacy Project (Augment BPO) is empowering BPO Companies, Executives, and Workers in the Philippines to prepare for and address the clear and present danger posed by Artificial Intelligence Chatbots (AI Chatbots) to BPO revenue growth and jobs through Data Science and Analytics strategy planning, awareness building and upskill training.

DMAIPH is a founding member of the Analytics Association of the Philippines and specializes in arming the Data-Driven Leader with the tools and techniques they need to build and empower an analytics centric organization. Analytics leadership requires a mastery of not just analytics skill, but also of nurturing an analytics culture. We have guided thousands of Filipino professionals to become better analytics leaders. Contact DMAIPH now at analytics@dmaiph.com or connect with me directly to discuss a uniquely tailored strategy to ensure you are the top of your game when it comes to Analytics Leadership.

Data Science and Big Data Analytics For Finance

Was recently asked to do a one hour talk on data science and big data analytics for Finance… so I created A Step By Step Process To Get More Value Out Of Your Finance and Accounting Data.

To get started, we will discuss at a high level what is analytics, big data and data science and how it can be used in Finance and Accounting to get more value out of all the numbers you have in your business.

Per Deloitte, “In today’s highly competitive business environment, companies need more from Finance than accurate financial statements and reports. They need forward-looking, predictive insights that can help shape tomorrow’s business strategy and improve day-to-day decision-making in real time. “

New IT applications and infrastructure such as big data technologies, predictive analytics, as well as modern mathematical methods are opening up new possibilities for gathering and processing large amounts of data and opportunities for generating value.

They keys to a sound data science and analytics approach to Finance include the following:

  • A Process for Using Big Data to Answer Business Questions
  • A Well Mapped Data Lake of all the Data Finance Needs
  • The Right Mix of Analytics Talent, Technique and Technology
  • A Top Down Embrace of an Analytics Centric Culture

By translating data into insights around financial statements and operations, the finance team can unlock and create new value. Being able to identify unrealized and often unexpected potential as well as quickly and decisively mitigating risk, data science and analytics can take your team to a new level of insight and performance.

This in turn supports the finance function to make better decisions by being able to understand what has happened and why, and then predict what may happen next. The end result is a strategy built on data and one with a much higher rate of success then ones based on intuition or gut feel.

jobspicture2

The Fundamental of Business Analytics – Business Analytics is the application of talent, technology and technique on business data for the purpose of extracting insights and discovering opportunities. DMAIPH specializes in empowering organizations, schools, and businesses with a mastery of the fundamentals of business analytics. Contact DMAIPH now at analytics@dmaiph.com or connect with me directly to find out how you can strengthen your business analytics fundamentals.

APEC Data Science & Analytics Key Competency #4: Domain Knowledge and Application

According to the APEC (Asia Pacific Economic Cooperation) Advisory Group, Domain Knowledge and Application is one of the key competencies of a Data Science & Analytics professional working in the region.

By definition, a DSA professional can apply domain-related knowledge and insights to effectively contextualize data, achieved by practical experience (e.g. apprenticeships) and exposure to emerging innovations.

In my own experience, I knew Wells Fargo data like the back of my hand, but my domain knowledge would have easily allowed me to the same great things with other big banks. When I toyed with the idea of moving into the health services industry, it was obvious my skills would be useful but I had a lot ot learn about the domain knowledge of healthcare data.

Since, domain knowledge represents knowledge and insight that is unique to the organization or industry and that analysts need to consider when conducting any data project. Without this knowledge, analytics solutions may not entirely address the real business problem.

In my experience, domain knowledge about the data being analyzed can sometimes be acquired through exploration of the raw data.  Often, good analysts become subject experts just by playing with the data and asking questions to domain experts about the data.

Given the dearth of analytics talent in many areas, reality will dictate that a lot of data projects will have to be done without sufficient domain knowledge. However, most experts would agree the best results come when the ones using the data, know the data.

So, it behooves companies to invest more in educating and enabling internal resources then looking outside for DSA talent. My solution to this is to introduce apprenticeship programs where subject matter experts train current staff with high DSA affinity who are currently working in other roles.

As an example, there are likely thousands of current call center agents who have the aptitude to be analysts an data scientists, but never had the opportunity to of into DSA. Given they are already employees with proven track records of success, they would be much more likely to have the domain knowledge needed.

IMG_9107

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.

APEC Data Science & Analytics Key Competency #3: Data Management and Governance

According to the APEC (Asia Pacific Economic Cooperation) Advisory Group, Data Management and Governance is one of the key competencies of a Data Science & Analytics professional working in the region.

By definition, a DSA professional can develop and implement data management strategies and governance, while incorporating privacy, data security, polices and regulations, and ethical considerations.

The concepts of data management and data governance are kind of the like the chicken… you really can’t have one without the other. Although to the layman, data management includes data governance.

The simplest way to put it, is that data management is the physical aspects of data collecting, capturing, storing, segmenting, etc. Data governance is then the rules or guiding principles that direct how data management works.

There are a lot of data management resources out there. There are not a lot of data governance resources out there. This is why in a majority of companies, we have raw data that needs a lot of cleaning and refining before it can be used in a business.

Organizations that are good in data governance, generally have solid data management. Mature analytics companies have data that is easy to access, is accurate and is used in decision-making.

Data Governance is composed on three parts: People, Process and Technology.

DMAI_DataGovernanceThe people have titles like database admins, data stewards and data warehouse experts. They enforce the laws and rules around data within an organization.

The technology used is generally programming languages, coding and joining data structures to layout the blueprint of how data flows throughout the organization’s hardware.

The process is the rules, generally set down by senior management, and often in line with government or industry regulations that govern how data should be used.

If your organization has a lot of data, has people that are well versed in data management, and uses data to feed decision-making, then you need to make sure you have solid data governance.

If you don’t, DMAIPH can help. Likely you are missing key people, clear processes, and/or the right technology to ensure your data is being governed correctly.

jobspicture2

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.

Worried Your Call Center Job Might Be Taken by a Robot? You should be.

http://news.abs-cbn.com/business/05/12/17/bpos-gearing-up-for-impact-of-artificial-intelligence-on-industry

I shared this article on an FB group and got a lot of inquires from people who are indeed seeing an opportunity to move from a call center job to a Data Science and Analytics (DSA) job.

Most of the questions revolved around how to transition.

Want to get Data Science and Analytics Training. Not sure how, here are some tips!

  1. Self-Teach a Skill. (YouTube has thousands of free resources)
  2. Volunteer at Work. (Find out what skills are in demand in your company and ask if you can help)
  3. Take a Training Class (there are a lot of public training classes out there, including some that DMAIPH does).
  4. Read a Book (Experts share a lot… like my book Putting Your Data to Work: An Analytics Guidebook for Filipino Professionals)
  5. Find a Mentor (Jedi Knights start as an apprentice, so do many analysts and data scientists)
  6. Join a Group (there are a lot of meet up groups like Data Science Philippines you can use to network)
  7. Go Back to School (a few dozen schools here in the Philippines are either already offering data science an analytics programs are kicking them off soon)
  8. Follow a Blog. (Besides reading books, there are a lot of good ideas shared on blogs like mine, dmaiph.com)
  9. Become a Member (join associations like aap.ph aka Analytics Association of the Philippines)

Another question that came up often was, “What should you learn first?”

Find a tool, technique or technology that is high demand and fits your interests and aptitude. The best way to find out what to focus on is do a job search for the kind of job you want and look at the requirements. For newbies some of the in demand skills are

  • SQL (the most widely used language used for data analytics)
  • Microsoft Excel (if you know pivot tables, simple formulas and can make decent visuals you will be in high demand)
  • Tableau (a free version called Tableau Public can be downloaded and is easy to learn)
  • R (the most widely used tool for predictive analytics and data science and its free)

And then a lot more people added me on FB, hoping to network and find new opportunities. Thats a good tip too. Networking is key.

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.

jobspicture2If 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.

IMG_9107

Also if you own or manage a call center, we can help. In fact, DMAIPH has successfully set up Filipino analytics teams for over a dozen U.S. based businesses. Offering both virtual and office based teams that specialize in problem solving using data, new technology and analytics techniques is our strength.

Finding and empowering analytics talent is increasingly challenging, but we have mastered Surfing Into The Storm and can show you how to succesfully set up a team. Contact DMAIPH now at analytics@dmaiph.com or connect with me directly to learn more about how to set up an analytics-centric team in the Philippines.

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.

RS_Data Management_062717

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

  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.

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.

  1. Laptop with Intel Core i3 and 4GB RAM.
  2. Windows OS with Excel 2007 or greater.
  3. 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.

16649482_10155094449802425_5080201225679087647_n

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 >>>