Users Online

· Guests Online: 62

· Members Online: 0

· Total Members: 188
· Newest Member: meenachowdary055

Forum Threads

Newest Threads
No Threads created
Hottest Threads
No Threads created

Latest Articles

DEMO - Data Analytics Hands On

DEMO - Data Analytics Hands On
Analytics Courses
Categories Most Recent Top Rated Popular Courses
 
Uploader Date Added Views Rating
Superadmin 01.01.70 594 No Rating
Description
Learn all of the key concepts in the world of data analytics. This course will walk you through everything you need to know to brush up on your data analytics knowledge or introduce you to every key area if you're entirely new to the subject.
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.

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

Ratings

Rating is available to Members only.

Please login or register to vote.

No Ratings have been Posted.

Comments

No Comments have been Posted.

Post Comment

Please Login to Post a Comment.
Render time: 0.94 seconds
10,844,550 unique visits