Data Integration, Management, Visualization and Warehousing

Talend data integration provides an easy way to get integration projects done quickly and with less overhead. It has several tools that make it a powerful, cost-effective suite. Predictive analytics uses data management techniques, such as statistics and machine learning, to build predictive models, often using big data to test and validate these models. It is becoming a key component for organizational success. It is becoming more common to present data in a visual way to engage audiences with what the data is saying. To ensure the audiences understand what is being presented, effective data visualizations need to be created, and this all start with knowing who your audience is and what your data is all about. Explore the fundamentals of data warehousing and the approaches of implementing it; as well as examine architectures of data warehouse implementations, including logical and physical design.

Training topics to be covered include:
Talend Data Integration
• Getting Started with the Software and Integrating Data
• Working with Data Mapping, Jobs, and Automation

Data Management/Predictive Analytics
• Predictive Analytics and Big Data
• Process and Application
• Key Statistical Concepts
• Correlation and Regression
• Data Collection and Exploration
• Data Mining, Data Distribution, and Hypothesis Testing
• Data Preprocessing
• Data Reduction and Exploratory Data Analysis (EDA)
• K-Nearest Neighbor (k-NN) and Artificial Neural Networks
• A/B Testing, Bayesian Networks, and Support Vector Machine
• Clustering Techniques
• Linear and Logistic Regression
• Text Mining and Social Network Analysis
• Time Series Modeling
• Machine Learning, Propensity Score, and Segmentation Modeling
• Random Forests and Uplift Models
• Model Life Cycle Management
• Model Development, Validation, and Evaluation

Data Visualization
• Data Visualization Essentials
• Creating Realtime Dashboards
• A Complete and Comprehensive Guide to Excel
• Visualizing Data Online Using Google Chart Tools
• Business Reporting Using Power BI
• Getting Started with Tableau for Data Visualization
• Interactive Visualization Using Plotly Chart Studio
• Data Visualization in Excel
• Data Visualization with Matplotlib
• Data Visualization with QlikView
• Creating Infographics Using Infogram
• Data Visualization Best Practices
• Creating Infographics with Visme
• Data Visualization with Bokeh and Plotly

Data Warehousing
• Data Warehousing Essentials
• Data Warehousing with Azure
• Data Warehousing with Hadoop

Course Outcomes

Upon the completion of this course, students will be able to:
• Recognize how to work with projects, dependencies, data files, the Talend framework and various basic techniques in Talend
• Recognize key differences between predictive analytics and traditional business intelligence
• Use best practices to add effective visuals, text, functionality and color to a draft of a data visualization
• Build Box Plots, Sunburst Plots, Gantt Charts, and More using Excel for better visualization
• Load data from the Azure Data Lake Storage to SQL Data Warehouse
• Create Gen 1 and Gen 2 Azure Data Lake Storage using the Azure portal and PowerShell

Target Student

The target students for this course consists of developers, project managers, business intelligence specialists, system architects, analysts, and consultants who would like to work on data integration, management, visualization and warehousing projects.


Modality: Self-paced
Duration: 86 hours
Offered: 24/5
Start Date: On the first Monday of every month
Registration Ends: One week before start date
Certificate: Yes

Data Integration, Management, Visualization and Warehousing

1 year of access
This course does not have any sections.
Share this Course