CIW Data Analyst Specialist

40 Hours / 12 Months / Self-Paced

Course Overview:

Data Analyst is the seventh and final course in the CIW Web and Mobile Design series. In this course you will learn how to use data to analyze all aspects of a company's operation and make appropriate business decisions. You will study how to compare and contrast structured and unstructured data. You will learn how to deploy tools for capturing and analyzing data, including Hadoop, R Project, and custom database solutions.

In addition, you will study how to extrapolate information using data obtained from new and traditional data sources, including Web and social media logs, marketing, sales, technical support, and customer relations. You will also learn how to determine relationships between organizational efforts and business outcomes. Finally, you will study the ways to capture and represent data, including creating dashboards, executive summaries, reports and charts, using both traditional and Web-based tools.

Topics include:
  • Identify typical sources of institutional knowledge, including Customer Relationship Management (CRM) applications, transaction data, social media, marketing sources.
  • Compare and contrast structured and unstructured data.
  • Deploy specific tactics for working with cloud-based data, including cloud-native data, migrating data to or from the cloud.
  • Summarize ways that data is used to drive business decisions.
  • Deploy tools for capturing and analyzing data, including Hadoop, R Project, custom database applications.
  • Extrapolate information using data obtained from new and traditional data sources, including Web and social media logs, marketing, sales, technical support, customer relations.
  • Determine relationships between organizational efforts and business outcomes.
  • Identify ways to capture and represent data, including creating dashboards (e.g., executive summaries), creating reports and charts, using traditional and Web-based tools.
Prerequisites:

The CIW Data Analyst courseware requires an understanding of spreadsheets, databases, business processes, web sites and coding. Suggested prerequisites are the CIW Internet Business Associate, CIW Site Development Associate, CIW Advanced HTML5 & CSS3 Specialist course, and CIW User Interface Designer, or equivalent knowledge.

Target Audience:
  • Web designers
  • Internet consultants
  • IT professionals
  • Marketing professionals
  • Web and graphic artists
  • Business professionals

The CIW Data Analyst Specialist course prepares candidates to take the CIW Data Analyst Specialist exam, which, if passed, earns the individual the CIW Data Analyst Specialist certification.

Course Outline:

Fundamentals of Data Analysis
  • Pre-Assessment Questions
  • The Importance of Good Data
  • Centralized Data Benefits
  • Structured vs. Unstructured Data
  • Forgetting Steve Jobs
  • Typical Sources of Business Data
  • Search Engine Optimization
  • Business Decisions in the Nonprofit Industry
Introduction to Big Data
  • Big Data
  • The Importance of IT Data Management
  • IT Business Environments
  • Cloud-Based Data
  • Cloud-Native Data
  • In-House Data
  • When to Migrate In-House Data to the Cloud
  • Variations of Cloud-Based Systems
  • Typical Databases Used for Data Analysis
  • Data-driven Business Decisions
  • The Internet is Worthless
Working with Data Sources
  • Data E-Harmony: Working with  Different Departments to Bring Data Together
  • The Purpose of Customer Relationship Management (CRM)
  • CRM Integration: A Banking Scenario
  • Obtaining Data from E-Mail and User Forums
  • Obtaining Data from Other Knowledge Bases
  • Obtaining Data from CRM and Business-To-Business Frameworks
  • Transaction, Payment and Inventory Data
  • Using Multiple Data Sources InStyle Publishing
Tools for Capturing and Analyzing Data
  • Capturing Data: Tableau Public
  • Capturing Data: Google Fusion Tables
  • Capturing Data: OpenRefine
  • Overview: Hadoop-Based Environments
  • Capturing and Analyzing Data in Hadoop
  • The R Project
  • Additional Software for Data Capture
  • Playing With Big Data
Analyzing and Reporting Data
  • Network Traffic
  • Organizational Efforts and Business Outcomes
  • Best Methods to Capture and Report Specific Data
  • Data Analysis and Reporting Dashboards
  • Create Reports and Charts
  • Create a Presentation for Reporting Data
  • Frequently Asked Questions for Presentations
  • Better Business Through Data

All necessary materials (online eBook) are included.

Certification(s):

The CIW Data Analyst Specialist course prepares candidates to take the CIW Data Analyst Specialist exam, which, if passed, earns the individual the CIW Data Analyst Specialist certification.


System Requirements:

Internet Connectivity Requirements:
  • Cable and DSL internet connections are recommended.

Hardware Requirements:
  • Minimum Pentium 400 Mhz CPU or G3 Macintosh. 1 GHz or greater CPU recommended.
  • 256MB RAM minimum. 1 GB RAM recommended.
  • 800x600 video resolution minimum. 1025x768 recommended.
  • Speakers/Headphones to listen to Dialogue steaming audio sessions.
  • A microphone to speak in Dialogue streaming audio sessions.
Operating System Requirements:
  • Windows Vista, 7, 8, 8.1, 9, 10
  • Mac OSX 10 or higher.
  • OpenSUSE Linux 9.2 or higher.
Web Browser Requirements:
  • Google Chrome is recommended.
  • Firefox 13.x or greater.
  • Internet Explorer 6.x or greater.
  • Safari 3.2.2 or greater.
Software Requirements:
  • Adobe Flash Player 6 or greater.
  • Oracle Java 7 or greater.
  • Adobe Reader 7 or greater.
Web Browser Settings:
  • Accept Cookies
  • Disable Pop-up Blocker.


**Outlines are subject to change, as courses and materials are updated.**