Working with Real-Time Data in Excel Год выпуска: 2016 Производитель: Lynda Сайт производителя: lynda.com/Excel-tutorials/Excel-Workshop-Working-Real-Time-Data/471973-2.html Автор: Chris Dutton Продолжительность: 1:18 Тип раздаваемого материала: Видеоурок Язык: Английский Описание: 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. Из этого курса вы узнаете, как создавать пользовательские диаграммы, чтобы показать ожидаемые риски, основанные на вложениях в реальном времени, и изучите некоторые дополнительные возможности для более глубокого анализа.
Содержание
00 - Introduction Welcome What you should know before watching this course Using the exercise files Using the knowledge checks 01 - Project Files Download and explore files 02 - Standardize Date Fields Custom date dimensions Date formatting Combine fields with concatenate Knowledge check 03 - Create New Data Dimensions Categorize data Calculate percentiles Join data with VLOOKUP Knowledge check 04 - Combine Data to Evaluate Impact Move tabs across workbooks Combine VLOOKUP and MATCH to join data Use COUNTIF to analyze trends Scale values to a custom range Knowledge check 05 - Real-Time Data Integration Create an API feed with WEBSERVICE Extract components with FILTERXML Categorize real-time data Knowledge check 06 - Custom Combo Chart Visualization Generate dynamic chart source data Build a combo chart Customize formatting Knowledge check 07 - Wrapping Up Key analytics concepts Apply the skill set Knowledge check 08 - Conclusion Next steps: Share, connect, and explore Exercise Files
You cannot post new topics in this forum You cannot reply to topics in this forum You cannot edit your posts in this forum You cannot delete your posts in this forum You cannot vote in polls in this forum You cannot attach files in this forum You can download files in this forum
![[Quote]](./templates/default/images/lang/en/icon_quote.gif "Reply with quote"){kind=icon}
![[Profile]](./templates/default/images/lang/en/icon_profile.gif "View user's profile"){kind=icon}
![[PM]](./templates/default/images/lang/en/icon_pm.gif "Send private message"){kind=icon}
