Lynda - Excel Workshop: Working with Real-Time Data
Size: 283 MB | Duration: 1h 18m | Video: AVC (.mp4) 1280x720 30fps | Audio: AAC 48KHz 2ch
Genre: eLearning | Level: Intermediate | Language: English
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.
Buy Premium From My Links To Get Resumable Support,Max Speed & Support MeCode:Download ( NitroFlare ) http://nitroflare.com/view/C4AA4D30C2CD09F/dr3fi.rar Download ( Uploaded ) http://uploaded.net/file/in4y2vro/dr3fi.rar Download ( Rapidgator ) http://rapidgator.net/file/3e32c176855c912760ba40d14aea414b/dr3fi.rar.html Download (BigFile) https://www.bigfile.to/file/FTxUMcp3YTea/dr3fi.rar
Please visit our sponsors
Results 1 to 1 of 1
-
17-07-2016, 05:53 AM #1
- Join Date
- Mar 2014
- Posts
- 25,742
- Feedback Score
- 0
- Thanks
- 0
- Thanked 0 Times in 0 Posts
Excel Workshop Working with Real-Time Data
-
Sponsored Links
-
Sponsored Links
Thread Information
Users Browsing this Thread
There are currently 1 users browsing this thread. (0 members and 1 guests)
24 Hour Gold
Advertising
- Over 20.000 UNIQUE Daily!
- Get Maximum Exposure For Your Site!
- Get QUALITY Converting Traffic!
- Advertise Here Today!
Out Of Billions Of Website's Online.
Members Are Online From.
- Get Maximum Exposure For Your Site!
- Get QUALITY Converting Traffic!
- Advertise Here Today!
Out Of Billions Of Website's Online.
Members Are Online From.