Duration: 10 days – 70 hrs
Overview
In today’s data-driven world, harnessing the power of data is essential for making informed business decisions and gaining a competitive edge. The Data Analytics Training Course is designed to equip participants with the skills and knowledge needed to extract meaningful insights from vast and complex datasets. This comprehensive course covers various data analytics techniques, tools, and best practices to transform raw data into actionable information.
Objectives
- Tableau Advance Development
- Greenplum
- Datawarehouse Management
- Development
- Maintenance
- Administration
- MSSQL to Data Warehouse
- Oracle to Data Warehouse
Audience
- GARDENIA IT department
Pre- requisites
- Basic understanding of data and business concepts (no programming experience required).
- Familiarity with spreadsheet software (e.g., Microsoft Excel) is beneficial but not mandatory.
Course Content
Day 1: Introduction to Tableau and Data Visualization
- Overview of Tableau and its capabilities
- Understanding the importance of data visualization
- Exploring Tableau interface and basic functionalities
- Connecting Tableau to Greenplum, MS SQL, and Oracle data warehouses
Day 2: Tableau Fundamentals
- Data preparation and cleansing for Tableau
- Building basic visualizations (bar charts, line charts, scatter plots, etc.)
- Applying filters and sorting data
- Creating calculated fields and parameters
- Dashboard creation and design best practices
Day 3: Advanced Tableau Techniques
- Understanding Tableau joins and blending data
- Working with level of detail (LOD) expressions
- Implementing advanced calculations and table calculations
- Introduction to data blending and data aggregations
- Building interactive dashboards with actions and filters
Day 4: Greenplum and Data Warehouse Management
- Introduction to Greenplum as a massively parallel processing (MPP) data warehouse
- Greenplum architecture and components
- Data distribution, segmentation, and partitioning in Greenplum
- Data loading techniques and best practices
- Performance optimization and tuning in Greenplum
Day 5: Tableau and Greenplum Integration
- Connecting Tableau to Greenplum efficiently
- Utilizing Tableau’s data source filters for Greenplum
- Leveraging Tableau’s in-database analytics for Greenplum
- Building complex visualizations with Greenplum data
Day 6: MS SQL to Data Warehouse
- Understanding MS SQL Server as a data source
- Extracting, transforming, and loading (ETL) data from MS SQL to a data warehouse
- Data modeling and schema design for data warehousing
- Scheduling and automating ETL processes
Day 7: Oracle Data Warehouse
- Introduction to Oracle as a data source
- Extracting and transforming data from Oracle to a data warehouse
- Working with Oracle database structures for data warehousing
- Comparing Oracle with other data warehousing solutions
Day 8: Data Warehouse Maintenance and Administration
- Data warehouse maintenance best practices
- Managing data backups, recovery, and security
- Monitoring data warehouse performance
- Data warehouse scaling and capacity planning
Day 9: Tableau for Data Warehouse Administration
- Utilizing Tableau for data warehouse monitoring and reporting
- Building performance dashboards for data warehouses
- Tracking data usage and user activity in Tableau
- Creating custom administrative views in Tableau
Day 10: Project and Recap
- Participants work on a hands-on project combining Tableau, Greenplum, MS SQL, and Oracle data warehouses
- Project presentations and feedback
- Recap of key concepts and takeaways from the training
- Q&A session to address any remaining questions and challenges
