Analytics for Team Leads: Optimize Analytics & Data Science for More Efficient Operations and Engaged Employees

Join DMAIPH and Augment BPO in a two-day analytics training for Team Leads on August 22-23, 2017 in Ortigas! 

Learning Session Description

Every  organization is looking for a way to better understand what’s working and what’s not working in their operations. By using meaningful Big Data Analytics techniques, your leadership efforts can be greatly enhanced.

Learning Session Outline

In the past few years, we have seen the importance of big data, analytics and data science grow at a dizzying pace.

With real-time operations metrics & reporting, we can finally know what’s happening in our business, with our employees and with our customers.

New technologies like social networks, data rich information systems and business intelligence applications are fundamentally changing the entire operations process.

The pressure to deliver results has never been greater. Team Leaders are now more than ever required to demonstrate the return on investment of their efforts are contributing to the bottom line.

Building analytics centric teams and using techniques taught in this training session will empower more data-driven decision making. This will result in both process efficiency and better return in investment in the operations of your business.

With the global demand for analytics-enabled talent booming and the coming threat of A.I. to the BPO industry, Team Leaders need a deep understanding of analytics.

Learning Session Objectives

  1. Apply Best Practice Techniques and Cutting Edge Technologies to Organize, Interpret, and Summarize Quantitative Data
  2. Create a Process to Analyze Data and Identify Patterns Not Apparent at First Glance
  3. Reduce “Analysis Paralysis” and Go from Hard Data to Well-Reasoned Conclusions in Less Time
  4. Understand the implications of Artificial Intelligence and Machine Learning in regards to the future of work in the Philippines.

Who Should Attend

This session is suitable to a wide range of professionals but will greatly benefit:

  • Managers, Supervisors and Team Leads
  • Business Analysts working as part of an Operations Team
  • Leaders who oversee business operations

Learning Session Process

Based on a Set of Key Data Science and Analytics Competencies developed by the Asia Pacific Economic Cooperation (APEC), our learning sessions are designed for Team Leaders and Managers to use both in the Philippines and across the region.

Session One – Domain Knowledge & Application:  Apply domain-related knowledge and insights to effectively contextualize data, achieved by practical experience and exposure to emerging innovations.

  • Overview of Big Data, Analytics & Data Science in the Philippines
  • Cutting Edge Trends in Big Data
  • How to Apply an Analytics Process to Solving Business Problems

Session Two – Data Management & Governance: Develop and implement data management strategies and governance, incorporating privacy, data security, polices and regulations, and ethical considerations.

  • The 5 V’s of Big Data
  • The 3 Tenants of Data Governance
  • Information Security Guidelines for Filipino Businesses

Session Three – Data Analytics Methods & Algorithms: Capture, clean and inspect data. Evaluate and implement data analytics to derive insights for decision making.

  • Data Warehouses and Data Lakes
  • Blending Data from Across the Organization
  • Cloud Computing and 24/7 Data Access

Session Four – Data Science Engineering Principles for Business Operations: Use analytics software and system engineering principles and modern computer technologies to share findings and tell data stories. Develop analytic processes to improve HR operations.

  • Analytics with Lean and Six Sigma
  • Getting IT: the 3’s I and the 3 T’s of Data
  • Data Science 101: How to Build a Data Science Team

Session Five: Computing Principles for Team Leads: Apply information technology, computational thinking and utilize programming languages to design and develop data analysis processes and techniques.

  • Optimizing the use of MS Excel for Operations
  • Mangement Reporting
  • Working with the IT Team: Buy them Doughnuts

Session Six – Statistical Techniques for Data Analytics: Apply and/or direct the application of statistical concepts and methodologies for data analysis including predictive analytics.

  • Predictive Analytics Case Study: Google’s Top Performer Model
  • Tying Management Reporting to Predictive Models
  • Group Exercise: Build a Top Performer Model

Session Seven – Operational Analytics: Use data analytics and specialized business intelligence techniques for the investigation of all relevant HR data to derive insight in support of decision-making.

  • Competitor Landscapes and Demographic Profiles
  • BI Tools Demo: Tableau Public
  • Social Media Data

Session Eight – Data Visualization & Presentation: Ability to create and communicate compelling and actionable insights from data using visualization and presentation tools and technologies. Build a Business Dashboard prototype.

  • Data Visualization Guidelines
  • Group Exercise: Build a Business Dashboard Prototype
  • The Concept of Enchantment
  • Data Storytelling Case Study: The Best NBA Team of All Time

Case Studies and Exercises

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

coverphoto

Augment BPO

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.

jobspicture2

DMAIPH

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.

APEC Data Science & Analytics Key Competency #1: Operational Analytics

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

By definition, a DSA professional uses data analytics and specialized business analytics (i.e. business intelligence) techniques for the investigation of all relevant data to derive insight in support of decision-making.

Operational analytics is made up of all the analytics processes within an organization that take data and transforms the data into actionable intelligence. In short, this is management reporting.

Without a doubt the most widely used form of analytics, management reporting is deeply ingrained into the culture of data-driven organizations.

I often liken management reporting to a pyramid. The bottom of the pyramid is the data or the base of decision-making in an organization.

The middle of the pyramid is the processes of operational analytics. Where the data is transformed.

The top of the pyramid is the decision-making. Managers need intelligence that comes in the form of insights. Great analysts deliver these insights in reports, dashboards and visualizations.

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.

Top 5 Reasons to Attend the Digital Transformation Summit 2017

From the Global Chamber® Manila Newsletter

May 9, 2017

  1. Be inspired by an all-star lineup of speakers, who are already gaining significant benefits from adapting new technologies
  2. Learn about various technological platforms such as AI, IOT, Big Data, Analytics, and how it’s disrupting businesses
  3. Reflect, reexamine your company’s issues and goals, and set your vision and new strategy for the next decade
  4. Engage and network with executives and fellow thought leaders
  5. Empower the culture of innovation within you!

Not registered yet? It’s not too late to sign up!

I will be one of the speakers, talking about Data Storytelling. It is quite an honor to part of this awesome event! 🙂

Attend one or both days of the Digital Transformation Summit this May 24 and 25 at SMX Aura Convention Center.

Become a Data Science & Analytics Pro! Apply for the DMAIPH Apprenticeship Program

A standard definition of Apprenticeship is a kind of job training that involves following and studying a master of the trade on the job instead of in school.

Learning to become an analyst for the most part has been something done on the job.  after working in a company and gaining subject matter expertise, those who had good analytics skills often found themselves going down the analyst career path.

Big Data and technological advancements in analytics processing and data science have changed all that.

IMG_9107

Nowadays, there are so many analyst jobs available that the natural order of learning to become an analyst isn’t working fast enough.

Higher education is trying to come up with solutions to offer analytics themed course, a few are already in place. But that’s only training 100’s when industry needs 1,000’s.

SO, to help fill the skills gap between the very finite supply of Data Science and Analytics (DSA) talent and the huge demand in the form of open jobs, we have to get outside the box.

You will see a lot more ideas like the DMAIPH Data Science & Analytics Apprenticeship program coming in the near term.

But don’t wait for the future, get ahead of the game.

Learn the DSA skills you need for a long and profitable career as an analyst.

E-mail me your resume today if you would like to learn more.  danmeyer@dmaiph.com

I will be taking on a few more apprentices in the coming months as we grow the program to implement APEC’s Project DARE recommended approach to gaining a basic understanding of what it means to be a DSA professional.

Hope to hear from you soon!

Dan

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.

The Automation Storm is Coming… is Your IT-BPO Ready?

The number of posts like this one that talk about downsizing in traditional IT-BPO firms are getting more and more common every day.

Some naysayers think statements like this are just hyperbole, “saw their aggregate workforce shrink by seven the same year, highlighting a situation created by a perfect storm of tough business conditions and increasing automation.” But not me. I’m preparing for it.

And then there is this statement… that can easily be talking directly about the IT-BPOs in the Philippines. “This is a war of many battles being fought where smart service providers are aggressively implementing RPA (robotic process automation) into their own operations to drive down their delivery costs and reduce their own headcount. Hence, services providers will be hell-bent on destroying each other and the winners will be those who eventually succeed in winning more work than they lose amidst all the destruction”

I would add to this nationalistic pressures to counter the flow of globalization and “bring jobs back home”.

There are plenty of signs on the horizon that will spell doom for companies that aren’t ready for the coming storm.

Which is where DMAIPH can help.

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.

may 17-18

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.

DMAIPH was set up to facilitate these solutions and bring the talent and the business together. And that is exactly why I wrote Putting Your Data to Work, the first analytics guidebook designed specifically for the Philippines. Contact DMAIPH now at analytics@dmaiph.com or connect with me directly so we can help you take advantage of this unique global opportunity.

 

Why Focus on Data Analytics Competencies?

Later this week I will be attending the APEC Project DARE (Data Analytics Raising Awareness) Advisory Council in Singapore to discuss Recommended APEC Data Analytics Competencies.

Why Focus on Data Analytics Competencies?

Jobs requiring a familiarity with data analysis are forecasted to dramatically rise, resulting in a massive shortage of qualified employees. According to reports, some economies face a shortage of up to 1.5 million data analytics-enabled managers and analysts, costing billions of dollars in lost revenue annually. There is an urgent need to ensure that the future workforce is equipped with data analytics competencies to secure the jobs of tomorrow and move with ease in the labor market.

This is where Project DARE comes in. Project DARE aims to facilitate development of a data analytics-enabled workforce across the APEC region to effectively support sustainable economic growth and prosperity in the Asia-Pacific region. To do so, Project DARE developed a set of Recommended APEC Data Analytics Competencies which will be a resource to academic institutions and governments to align curricula, courses and programs so APEC economies are equipped to educate its workforce with the data analytics skills needed by employers in a data-driven future.

How was the Recommended Data Analytics Competencies Developed?

The Recommended APEC Data Analytics Competencies was developed through a public-private partnership with input from over 40 Advisory Group members (see Acknowledgements) comprised of distinguished business and higher education leaders who oversee data science and analytics needs for their organization and data science inter-disciplinary initiatives and curriculum. The Advisory Group was led by the private sector partner co- chairs, global skills and knowledge company Wiley and the Business Higher Education Forum (BHEF), with technical support by the EDISON (Education for Data Intensive Science to Open New Science Frontiers) Project.

17426122_1095825400562902_5936762267508985241_n

DMAIPH and Analytics Education

Facilitating a mastery of the fundamentals of analytics is what DMAIPH does best. As a key parnter of the Data Science Philippines Meetup Group, DMAIPH champions the use of using data. All across the world, companies are scrambling to hire analytics talent to optimize the big data they have in their businesses. We can empower students and their instructors with the knowledge they need to prepare for careers in analytics. Contact DMAIPH now at analytics@dmaiph.com or connect with me directly so we can set a guest lecturer date, On-the-Job Training experience or other analytics education solution specifically tailored to your needs.

About Project DARE

Project DARE is an initiative of the Asia-Pacific Economic Cooperation led by the United States (U.S. Department of Labor) with co-sponsorship from the governments of Australia, Japan, Malaysia, Peru, Chinese Taipei, and Viet Nam. As a project of APEC’s Human Resources and Development Working Group (HRDWG), Project DARE seeks to enable APEC workforce with the data analytics competencies demanded by employers today and to secure the jobs of tomorrow.

DMAIPH Analytics Apprenticeship Program Starts May 15, 2017

Analytics Apprenticeship Program Starts May 15, 2017

This is a 3-6 month, paid apprenticeship program that will provide in-depth and hands on training with a range of analytics skills needed across various industries today. At the end of the apprenticeship, you will a very strong change of staying with DMAIPH or being referred to one of our key business partners.

We are looking for 3-4 highly motivated, tech savvy, young professionals or fresh grads to join our program. Past apprentices have gone on to have successful analyst careers in a wide range of companies including HP, Emerson, Citibank, Wells Fargo and

Skills all analysts will learn

  • How to apply the DMAI methodology of business analytics
  • Advanced Excel Skills like Pivot Tables, Marcos, Formulas and Data Visualization
  • Using Tableau for Business Dashboards
  • Using SQL and R for Predictive Analytics
  • The key aspects of Data Storytelling

In addition, each track will focus on specific skill sets including but not limited to:

  1. Business Analyst
  • Analytics Assessment Facilitation
  • Project Planning and Documentation
  • Management Metrics Reporting
  1. Finance Analyst
  • Financial Forecasts
  • Budget Planning
  • Expense Tracking & Reporting
  1. Events Management Analyst
  • Competitor Intelligence
  • Market Research
  • Lead Generation, Tracking and Reporting

Compensation package is dependent on experience and skills, but in the range of P20,000 a month.

Interested applicants should send an updated resume to danmeyer@dmaiph.com as well as plan on attending a group interview exercise on April 29 in Ortigas.  Group interviews will be held from 10am-12noon and from 5pm-7pm at Unit 1704 Prestige Tower on Emerald Ave (F. Ortigas Jr. Rd) at the office of IBA.

jobspicture2

Analytics Jobs – DMAIPH hires, refers and connects Filipino analytics talent. The Philippines is at the center of the action when it comes to solutions to the global need for analytics. Working with DMAIPH to find work, hire analytics talent or set up analytics teams will ensure you are tapped into the best of the best when it comes to analytics in the Philippines. Contact DMAIPH now at analytics@dmaiph.com or connect with me directly to find out how to take advantage of this booming opportunity.

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