CIW

DBM4410: Data Systems Administration

(ANC-DBM4410.AC1)
Lessons
Lab
TestPrep
Get A Free Trial

Skills You’ll Get

Download Course Outline

1

Fundamentals of Data Analysis

  • The Importance of Quality Source Data
  • Data Structure Types
  • Centralized Data Benefits
  • Structured vs. Unstructured Data
  • Types of Data
  • Typical Sources of Business Data
  • Data Protection Policies
  • Search Engine Optimization
  • Data Life Cycle Management (DLM)
  • Data Analysis Process
  • Lesson Summary
2

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
  • Impact of Data Errors
  • Importance of Organizational Strategy and Data Quality in Data Analytics
  • Data Modeling 
  • Importance of Data Maintenance and Data Backup
  • Lesson Summary
3

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 Email 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
  • Lesson Summary
4

Tools for Capturing and Analyzing Data

  • Data Analytics Tools
  • Capturing Data: Tableau Public
  • Capturing Data: Google BigQuery
  • Capturing Data: OpenRefine
  • Overview: Hadoop-Based Environments
  • Capturing and Analyzing Data in Hadoop
  • The R Project
  • Additional Software for Data Capture
  • Lesson Summary
5

Analyzing and Reporting Data

  • Network Traffic
  • Data Integration
  • Why Testing is Important?
  • Statistical Computing and Programming
  • 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
  • Lesson Summary

1

Fundamentals of Data Analysis

  • Learning the Data Analysis Lingo
  • Learning Structured and Unstructured Data in the Real World
  • Analyzing the Metadata and Understanding Search Engine Optimization
  • Using the AdSense and AdWords Services
2

Introduction to Big Data

  • Analyzing and Utilizing Big Data
  • Adapting to Changing Data Requirements
  • Comparing Relational Database Management Systems
  • Analyzing DDDM and Data for Blanket Technology
3

Working with Data Sources

  • Calculating the Churn Rate
  • Analyzing Customer Relationship Management
  • Calculating Consumer Lifetime Value in Banking
  • Understanding the RFM Analysis for Customer Segmentation
4

Tools for Capturing and Analyzing Data

  • Creating a Stacked Bar Chart
  • Using RStudio
5

Analyzing and Reporting Data

  • Creating a Gantt Chart
  • Comparing Prezi and PowerPoint Presentations
  • Creating a PowerPoint Presentation

Related Courses

All Courses