Data Analytics: Hands On [2015, ENG] torrent

Обучающие видео » Компьютерные видеоуроки и обучающие интерактивные DVD » Программирование (видеоуроки)

Data Analytics: Hands On

Год выпуска: 2015
Производитель: Pluralsight
Сайт производителя: pluralsight.com
Автор: Ben Sullins
Продолжительность: 5:02
Тип раздаваемого материала: Видеоклипы
Язык: Английский
Описание: This course covers everything from the basic concepts of data analysis, to data warehouse design and data visualization principles. If you're looking for a career change or already making your way into the world of transforming data into value, this course will help you understand all of the key concepts and get some hands-on skills, while being directed to where you can dig in deeper when you find something you're interested in. If you're already working in the data world, you can use this course as a reference. Each module is broken down into segments that answer the basic questions of what, why, how, and where so you can easily dive in where you want to learn more and jump back out without needing to start watching from the beginning.

Все об анализе данных.
[spoiler="Содержание"]
Getting Started
Introduction
Module Layout
Skills Overview
Our Story
What Is Data Analytics?
Why Data Analytics Exists
How It Works
Where to Find More

Excel Basics
Introduction
What Is Excel?
Why Use Excel?
How It Works
Demo: Formatting Columns
Demo: Basic Functions
Where to Find More

Massaging Data in Excel
Introduction
What Is Massaging Data?
Why Massage Data?
How It Works
Demo: Vlookup
Demo: Vlookup & Match
Demo: Removing Duplicates
Where to Find More
Analyzing Data in Excel
Introduction
What Is Analysis?
Why Analyze Data?
How It Works
Demo: Pivot Tables
Demo: Pivot Charts
Demo: Going Interactive
Where to Find More

Databases Overview
Introduction
What Are Databases?
Why Use a Database?
Types of Databases
How Databases Work
Demo: Setting up SQL Server
Loading Data to SQL Server
Where to Find More

Intro to SQL
Introduction
What Is SQL?
Why Use SQL?
SQL Basics
How SQL Works
Demo: Basic Select Statement
Demo: Filtering Results
Demo: Ordering Results
Demo: Aggregations
Where to Find More

Intro to Data Modeling
Introduction
What Is Data Modeling?
Why Use Data Modeling?
Key Concept: Relationships
Key Concept: Normalization
Demo: Creating a Data Model in SQL Server
Demo: Creating Relationships in SQL Server
Where to Find More

Data Warehousing Basics
Introduction
What Is Data Warehousing?
Why Use Data Warehousing?
How Data Warehousing Works
Key Concept: ETL
Key Concept: Dimensional Modeling
Key Concept: Star Schema
Demo: Building a Star Schema in SQL Server
Where to Find More

Big Data
Introduction
What Is Big Data?
Why Big Data Exists
How Big Data Works
Key Concept: Distributed Computing
Key Concept: CAP Theorem
Where to Find More

Visualizing Data in Charts
Introduction
What Is Data Visualization?
Why Visualize Data?
How Data Visualization Works
Key Concept: Visual Perception
Key Concept: Color
Key Concept: Chart Types
Key Concept: Dashboards
Where to Find More

Building Charts in Tableau
Introduction
What Is Tableau?
Why Use Tableau?
How Tableau Works
Demo: Installing Tableau
Demo: Connecting to Data
Demo: Building Charts
Demo: Calculations
Demo: Dashboards
Demo: Sharing Your Work
Where to Find More

Presenting Findings
Introduction
What Are Presentations?
Why Use Presentations?
How to Present Findings
Key Concept: Audience
Key Concept: Story
Key Concept: Slides
Key Concept: Data
Where to Find More
[/spoiler]
Файлы примеров: присутствуют
Формат видео: MP4
Видео: AVC, 1024x768, 4:3, 15fps, 555kbps
Аудио: AAC, 44.1kHz, 96kbps, stereo
[spoiler="Скриншоты"]

[/spoiler]