▄▄▄ ▄▄▄
█████▄ ▄▄▄ ▄█████
▄▄▄▄ ▀█████ ▄▄█▓█████▄▄ █████ ▄▄▄ ▄▄▄▄
▄██████████▄████▓ █████████████ ████ ▄█████ ██████
███▓▀▀▀▀█████▓████ █████▀ ▀████▓ ▓███ ▄██▄ █████▓ ▓██████
░▓███▄ ▄████ ████ █████▓ ▓█████▓███ ████ ██████▄ ▄██████▓
████████████▀ ████ █████ █████████ ████▄██▄███████▄███▀████▓
▀███▄ ▄▄▄ ▄████▀ ▓████ █████████ ████████▓███ ▀██▓▀ ████
▀███▄████▄█████ ██████ ████▓█████▄▓████ ▀▀ ████ ▀ ████
▄████▄ ▀▀████████▓ ███████ ▓▓██▀███▀ ▀██████▄██▄ ███ ████
█████████ ▀█▓▀ █████▄▄ ░▓███████▄▄▄████▄██▓ ▀████████████ ████
██████████▄ ▄▄ ▀▀█████▄▄▓████▀███████▀▄███ ▄▄ ████████████ ▓▄▄▄▄ ████▓░
▓█████████████▓▓█▄▄ ▀▀▓▓█████▓░ ▀▀▀ ▄ ▀████▄ ▀██ ████████████ ████▀ ▄███▓
▀███▓▓▓█████████████▄▄▄ ▀▀███▀ ▄███████▄ ▀▀███▄ ▓ ███▓███▓████ ▓█▀ ▄███▀▀
▀▀▀ ▀▀▀▓▓███▄▄▄▄▄███████▀▀▀▀▓ ▀▀ ███▓ ▀▀ ████ ▀ ▀▓▓█▄▄
▀▀▀▀▀▀ ▀▀ ▀██▀ ▀▀▀▀▀
RELEASE NAME....: Lynda.com.Excel.Workshop.Working.with.Real-Time.Data-ELOHiM
RELEASE DATE....: 2016-07-12
RELEASE SIZE....: 18x15Mb
FORMAT..........: Bookware
LANGUAGE........: English
URL.............: http://www.lynda.com
Our Excel Workshop series shows how to develop key data science and
analytics skills through applied learning in Excel. In this course, Chris
Dutton focuses on using real-time data from a web API and supplemental
data from the National Climatic Data Center (NCDC) to understand and
quantify the impact of weather patterns on accident rates.Using
conditional statements and text functions like LEFT, MID, RIGHT, and
CONCATENATE, you'll learn to standardize data sets from the NCDC and
create new dimensions. Then find out how to use VLOOKUP to join the data,
and use COUNTIF statements to analyze trends. Once the historical data is
in place, Chris shows how to use Excel's powerful WEBSERVICE and FILTERXML
functions to tap directly into Weather Underground's API, which provides
real-time weather information for any location and allows you to estimate
accident rates based on current conditions.Last but not least, you'll
learn how to build custom charts to show the expected accident risk based
on real-time inputs, and walk through some additional opportunities for
deeper analysis.
Topics include:
* Standardizing data
* Creating new data dimensions fields
* Joining data
* Analyzing trends in the data with COUNTIF
* Creating an API feed with WEBSERVICE
* Extracting components with FILTERXML
* Visualizing the findings in a custom combo chart
* Applying your new skill set
Subjects: Business, Business Intelligence, IT, Data Analysis,
Spreadsheets, Excel, Office, Office 365
Author: Chris Dutton
Level: Intermediate
Duration: 1h 18m
Released: 7/11/2016