Generative AI

Topic

Description

Hours

Module I

Foundation and Basic Concepts

1

Overview of Data Visualization, Introduction to Tableau

• Introduction to  data analysis
• Overview of Data Visualization concepts
• Overview of Power BI
• Key components
• Use cases and benefits
• Navigating the Power BI Interface
• Understanding the workspace
• Basic functionalities

3

Module II

Data Connectivity and Preparation

2

Connecting to Data Sources

• Get data from Excel, SQL Server, and other sources
• DirectQuery vs. Import mode.

3

3

Data Transformation with Power Query

• Data cleaning and shaping
• Using the Query Editor
• M language basics

Module III

Data Modelling

4

Data Modelling Basics

• Relationships between tables
• Creating and managing relationships

3

5

Creating Calculated Columns and Measures

• Introduction to DAX (Data Analysis Expressions)
• Basic DAX functions (SUM, AVERAGE, COUNT, etc.)

3

6

Advanced DAX Functions

• Time Intelligence functions
• Context and filtering

7

Optimizing Data Models

Performance considerations
Best practices for model design

3

Module IV

Visualization and Reporting

8

Creating Visualizations

Types of visuals (charts, tables, maps, etc.)
Customizing visuals

3

9

Building Interactive Reports

Using slicers, filters, and drill-through
Creating dashboards

3

10

Advanced Visualization Techniques

Conditional formatting
Using bookmarks and buttons

3

Module V

Advanced Topics and Power BI Integration

11

Power BI with Other Tools and Power Apps

Integration with Excel, Teams, and other Microsoft tools
Embedding Power BI in Power Apps
Custom visuals and their integration

3

12

Security and Administration

Row-level security
Data governance and compliance

3

Capstone Project

Developing a report from scratch based on given data
Real-world case studies and solutions