CIW Data Analyst Specialist

Hours: 40 / Access Length: 12 Months / Delivery: Online, Self-Paced
Online Hours: 40
Retail Price: $419.00

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

  • Connection Type: Broadband (Cable, Fiber, DSL) or LEO Satellite (e.g., Starlink)
  • Minimum Speed: 10 Mbps download / 5 Mbps upload

Note: While cellular hotspots may allow basic access, high latency and fluctuating speeds can cause disconnects during videos, quizzes, or live sessions. Cellular hotspots are not recommended as a primary connection.

Hardware

  • Processor: Dual-core 2.0 GHz or higher
  • Memory (RAM): 8 GB or higher (4 GB minimum)
  • Display Resolution: 1280 x 720 minimum (1920 x 1080 recommended)
  • Audio/Video: Speakers or headphones; microphone and webcam (recommended for Live Online sessions)

Operating Systems

  • Windows: Windows 10 or Windows 11
  • Mac: macOS 13 (Ventura) or newer
  • ChromeOS / Linux: Latest supported release

Note: While courses may load on iOS and Android devices, phones and small tablets are not recommended. Their smaller screen sizes and mobile browsers do not provide an optimal environment for coursework or live online sessions.

Web Browsers

  • Google Chrome (Latest version — Recommended)
  • Mozilla Firefox (Latest version)
  • Microsoft Edge (Latest version)
  • Apple Safari (Latest version)

Tip: Ensure JavaScript and cookies are enabled, and pop-up blockers are disabled for the learning portal.

Recommended Software

The following software is recommended for viewing and completing general course materials (individual courses may require additional software as noted in the course outline above):

  • Productivity Suite: Microsoft 365/Office, Google Workspace, or LibreOffice
  • PDF Reader: Adobe Acrobat Reader, Foxit PDF Reader, or a built-in browser PDF viewer


** The course outlines displayed on this website are subject to change at any time without prior notice. **