Workshop on Power BI & Tableau (Visualization)
About Course
This 2-day hands-on workshop on Power BI and Tableau aims to introduce engineering students to two of the most powerful data visualization and business intelligence tools used by professionals worldwide. Participants will gain a comprehensive understanding of how to transform raw data into actionable insights using interactive dashboards and visual reports. By the end of the workshop, students will be proficient in both tools, enabling them to create compelling visualizations and make data-driven decisions.
Course Objectives:
- To provide participants with advanced skills in Microsoft Excel for data analysis and reporting.
- To introduce participants to Power BI for data visualization, analysis, and dashboard creation.
- To equip participants with the skills to leverage both Excel and Power BI for business intelligence purposes.
- To prepare participants for real-world data analysis and reporting tasks
Workshop Outcomes:
- Understand the fundamentals of data visualization and the importance of BI tools.
- Be able to use Power BI and Tableau to create visual reports and dashboards.
- Know how to clean, manipulate, and analyze datasets from various sources.
- Develop skills to visualize complex data and present it in an understandable format.
- Gain practical experience in using BI tools to solve real-world data problems.
Course Curriculum:
POWER BI :
Session 1: Introduction to Power BI
- Overview of Business Intelligence (BI) & Data Visualization
- Introduction to Power BI: Features and Capabilities
- Power BI Interface Overview
- Connecting to Data Sources (Excel, CSV, Web)
Session 2: Data Preparation and Modeling in Power BI
- Data Transformation: Cleaning and Formatting Data
- Creating Relationships Between Tables
- Introduction to DAX (Data Analysis Expressions)
- Calculated Columns and Measures
Session 3: Creating Visualizations in Power BI
- Building Interactive Reports: Charts, Graphs, Maps
- Slicers and Filters for Dynamic Analysis
- Best Practices for Data Visualization Design
Session 4: Power BI Dashboards
- Creating Interactive Dashboards
TABLEAU
Session 1: Introduction to Tableau
- Overview of Tableau: Features and Capabilities
- Tableau Interface Overview
- Data Preparation in Tableau
Session 2: Data Analysis and Visualizations in Tableau
- Creating Basic Visualizations: Bar Charts, Line Charts, Maps
- Filters, Parameters, and Calculated Fields in Tableau
- Building Dashboards in Tableau: Layout and Interactivity
Session 3: Advanced Visualizations in Tableau
- Heat Maps, Tree Maps, Scatter Plots, and Gantt Charts
- Storytelling with Data: Creating Story Points in Tableau
- Best Practices for Designing Effective Visualizations
Session 4: Tableau Projects and Integration with Other Tools
- Working on Real-World Case Studies in Tableau
Perks/Take Away:
- Certification: certification given to participants
- LMS Access: No LMS access given to participants
Company requirements:
- Seminar hall/Labs with projector and internet connectivity.
- Each student must have a laptop/desktop with Power BI and Excel software
- Accommodation and food for resource person
- Trainer is subject to change as per the workshop and trainer availability dates.
