High-quality data analysis and visualization requires structured data. Data preparation tasks require 80% of time in data analytics process. The skills of preparing and integrating are necessary because in the modern business the quantity of data and the data sources are increased and it is necessary to extract high quality business information from the vast amount of data. Within the training Data preparation and visualization the student will become familiar with the best practices of data preparation for analysis and visualization of data. Education covers the topic of getting to know different formats of data preparation, data cleansing and profiling, data merging, and best practices for data preparation. Tableau Prep enables business users to prepare data without advanced technical knowledge. This training is a great background for visualization and analysis of data in tools such as Tableau Software.
The aim of education is to introduce the trainees to the best practice of preparing and combining data in modern tools. After training, learners will learn how to join data from different data sources, clean, transform, and improve data quality using self-service tools that automate these steps and deliver the correct data for analytical tools such as Power BI and Tableau Software.
Education is intended for all business users who want to speed up the process of data preparation for analytical and visualization solutions. There is no need for prior knowledge of data preparation, the basics of computer work are required.
- Introduction to Data Modeling
- Connecting to Data Sources (Excel, Relational Database)
- Data profiling
- Merging Data
- Cleaning and Data Transformation
- Best practice for data preparation
- Exercises (Tableau Prep)