Learning Data Analytics MP4 | Video: 720p | Duration: 1:39:38 | English | Subtitles: VTT | 321.1 MB
Every person who works with data has to perform analytics at some point. This popular training courseR12;dramatically expanded and enhanced for 2018R12;teaches analysts and non-analysts alike the basics of data analytics and reporting. Robin Hunt defines what data analytics is and what data analysts do. She then shows how to identify your data setR12;including the data you don't haveR12;and interpret and summarize data. She also shows how to perform specialized tasks such as creating workflow diagrams, cleaning data, and joining data sets for reporting. Coverage continues with best practices for data analytics projects, such as verifying data and conducting effective meetings, and common mistakes to avoid. Then learn techniques for repurposing, charting, and pivoting data. Plus, get helpful productivity-enhancing shortcuts and troubleshooting tips for the most popular data analytics program, Microsoft Excel.
Defining data analysis Understanding the data analyst role and other roles Identifying data, data fields, and data types Learning syntax Finding existing data Cleaning data Data best practices Working with business data Charting data Building pivot tables and charts Using Excel for data analysis