Index

Sr. No. Topics Date Sign
1 Power BI
Chart Creation. 11-03-2025
2 KPI Cards and Top N Analysis 25-03-2025
3 DAX Functions. 25-03-2025
4 Customer Churn Analysis Dashboard. 01-04-2025
5 Tableau
Chart Creation in Tableau. 29-04-2025
6 Storyboard in Tableau. 29-04-2025
7 Advanced Excel
Demonstrate Pivot Tables and Pivot Charts. 15-04-2025
8 Demonstrate the following Excel functions:
Logical: IF, AND, OR, IFERROR.
Lookup: VLOOKUP, XLOOKUP,
INDEX-MATCH.
Data Analysis: SUMIFS, COUNTIFS. 15-04-2025
9 Dashboard using charts, slicers, and
conditional formatting. 15-04-2025
10 Perform What-If Analysis using the following tools:
Scenario Manager
Goal Seek
Data Table 23-01-2025
11 Data Mining:
Write a Python program to demonstrate
Clustering for Segmentation 08-04-2025
12 Market Basket Analysis:
Apriori Algorithm 08-04-2025
13 Time Series Forecasting with Python:
ETS
ARIMA
Prophet Model 22-04-2025

Session 1 (Power BI Chart Creation)

  1. Types of services provide by Power BI.

    1. Mobile BI
    2. Real-time BI
    3. Operational BI
    4. Open-source BI (OSBI)
    5. Collaborative BI
    6. Location Intelligence (LI)
    7. Software-as-a-service BI (SaaS BI)
    8. Online analytical processing (OLAP)
    9. Ad hoc analytics

  2. Components of Power BI.

    1. Data Management Gateway
    2. Data Catalog
    3. Power Query
    4. Power Pivot
    5. Power View
    6. Power Map
    7. Power BI Service
    8. Power BI Q&A

  3. Intro to Power BI app.

    1. Visuals from power BI

      image.png

  4. Sample Data File

    Sample - Superstore.xlsx

  5. Open Power BI

    1. From the Home tab. Click on Get Data > Excel Workbook > Select above file and click on Orders and Load.

      image.png

    2. After the is loaded successfully, mark country and

      image.png

    3. Line and stacked column chart

      1. Column X-axis: Sub-category

      2. Column Y-axis: Sales

      3. Column legend: Region

        1. Column legend will only accept categorical data.

      4. Format visual

        image.png

    4. Region wise profit on Pie chart.

      1. Legend: Region

      2. Values: Profit

        image.png

    5. Region wise Sales on Donut Chart

      1. Legend: Region

      2. Values: Sales

        image.png

    6. Sub Category wise Sales on Funnel

      1. Category: Sub Category

      2. Values: Sales

        image.png

    7. Ribbon Chart

      1. Column X-axis: Order-Date

      2. Column Y-axis: Sales

      3. Column legend: Region

        1. Column legend will only accept categorical data.

      4. Format visual

        image.png

    8. Include and Exclude

      image.png

      image.png

      image.png

    9. View Data Export

    10. Map Chart

    11. Table

    12. Matrix

  6. Power BI File where all the above operations were performed (Practical).