تفاصيل الدورة

In this course, you will learn the basics of data analysis Excel, SQL, and Tableau from Learn Analytics. You will learn how to clean, analyze and visualize data in MS Excel. Then, you will learn about databases and their role in data analysis. You will finish off by learning about visualization and communication with Tableau.

At the end of this course you should have a solid understanding of the following:

  • What data analysis is
  • Why we need to analyze data
  • How clean data in excel by filtering, sorting, using VLOOKUPs and applying conditional formatting
  • How to analyze data in excel with the power of Pivot Tables
  • What databases are
  • Why databases are important, and how they work
  • How to execute basic extraction with SQL 
  • What is Big Data
  • Why Big Data Exists and how they work
  • What data warehousing is
  • Why we use data warehousing
  • What data modeling is and how to model a database
  • What data visualization is
  • Why data visualization is important and how it works

Please note this is a beginner course, so we teach the foundations of data analysis. If you already know what data analysis and how to conduct analysis this course might be too basic for you.


تحديث بتاريخ 14 February, 2018
دورات يمكنك الالتحاق بها على الفور... خذ دورة عبر الإنترنت على Data Science ابتداءً من الآن. See all courses