Phases of a Data Analytics Project

Zur Verfügung gestellt von

Youtube is a video-sharing platform that offers a wide variety of educational content, including lectures, tutorials, and courses on a wide range of subjects....

Beschreibung

The video begins by introducing the course on data analytics using Excel. The speaker explains that the course will cover the phases of an analytics project, including data cleaning, data analysis, and data visualization. They then go over each phase in detail, highlighting the functions in Excel that are used in each one. During the data cleaning phase, the speaker discusses how to set up a problem statement, perform preliminary analysis, fix misspellings and character issues, remove duplicates, and check for bias. The video then moves on to the data analysis phase, where the speaker explains how to use functions like VLOOKUP, conditional formatting, data validation, and pivot tables to analyze data. Finally, the video covers data visualization using Excel, including how to create charts and graphs to present data in a clear and concise manner. lern mehr

Berufe

Weitere Kurse von YouTube