CIW Data Analyst Specialist

40 Hours / Access Length: 12 Months / Delivery: Online, 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 for the best experience.
Hardware Requirements:
  • CPU: 1 GHz or higher
  • RAM: 2 GB or higher
  • Resolution: 1280 x 720 or higher
  • Speakers / Headphones
  • Microphone (Webinar / Live Online sessions)
Operating System Requirements:
  • Microsoft Windows 7 or 10 (Home, Pro)
  • Mac OSX 10 or higher.
  • Latest Chrome OS
  • Latest Linux Distributions

NOTE: While we understand that our courses can be viewed on Android and iPhone devices, we do not recommend the use of these devices for our courses. The size of these devices do not provide a good learning environment for students taking online or live online based courses.

Web Browser Requirements:
  • Latest Google Chrome is recommended for the best experience.
  • Latest Mozilla FireFox
  • Latest Microsoft Edge
  • Latest Apple Safari
Basic Software Requirements (These are recommendations of software to use):
  • Office suite software (Microsoft Office, OpenOffice, or LibreOffice)
  • PDF reader program (Adobe Reader, FoxIt)
  • Courses may require other software that is denoted in the above course outline.