Power BI Syllabus

SUBJECT TITLE

INTRODUCTION TO BUSINESS INTELLIGENCE USING POWER BI

Syllabus

UNIT I: INTRODUCTION TO BUSINESS INTELLIGENCE AND POWER BI:

What is BI, Role of Business Analyst, Stages of BI, Data Visualization Tools, Introduction to Power BI, Features of Power BI, Power BI Components, Difference between Power BI and other Tools, Setting up of Power BI Desktop.

UNIT II: Data Preparation and Transformation: Connecting to various data sources (e.g. Databases, Excel, Web services), Data loading and transformation using Power Query Editor, Data cleansing and shaping techniques.

UNIT III: Data Modeling: Understanding data models in Power BI, Creating relationships between tables, DAX (Data Analysis Expressions) basics for calculations Data Visualization: Building basic visualizations (e.g., charts, tables, matrices), Customizing and formatting visuals, Creating interactive reports and dashboards.

UNIT IV: Advanced Data Modeling and DAX: Advanced DAX functions for complex calculations, Time intelligence calculations, Measures and calculated columns.

UNIT V: Power BI Service and Data Sharing: Publishing reports to Power BI Service, Sharing and Collaboration options, Power BI Mobile app usage

BOOKS:

Text books:

1. "Power BI Step-by-Step" by Mr. Grant Gamble 2.
2.  "Analyzing Data with Power BI and Power Pivot for Excel" by Alberto Ferrari and Marco Russo
3. "Power BI Cookbook" by Brett Powell 4. "Power BI for Data Science" by Debarchan Sarkar and Brett Powell

 Reference Books:

1. "The Definitive Guide to DAX: Business intelligence for Microsoft Power BI, SQL Server Analysis Services, and Excel" by Alberto Ferrari and Marco Russo

 2. "Power BI Desktop and the Power BI Service: Business Intelligence with Power Pivot and Power Query" by Ken Getz and Michael Alexander

 3. "M is for (Data) Monkey: A Guide to the M Language in Excel Power Query" by Ken Puls and Miguel Escobar

 4. "Dashboarding and Reporting with Power BI Desktop and Excel"

 

BLUE PRINT

class:	Semester:	Title of The Paper:	Paper Code:	W.E.F
BBA	V	INTRODUCTION TO BUSINESS INTELIGENCE USING POWER BI		2025-2026

 

SECTION A (5 * 4=20 Marks)

5 Questions to be answered out of 8 Questions

2 Question must be given from each Unit

SECTION B (8 *5=40 Marks)

2 Questions must be given from each Unit with an internal choice Illustration of Model Question Paper

	Section A	Section B
UNIT I	2	2
UNIT II	2	2
UNIT III	2	2
UNIT IV	1	2
UNIT V	1	2
	8	10

 

 

Model Question paper

class:	Semester:	Title of The Paper:	Paper Code:	W.E.F
BBA	V	INTRODUCTION TO BUSINESS INTELLIGENCE USING POWER BI		2025-2026

SECTION-A

Answer any FIVE of the following questions.                                5 x 4 = 20 M

1. What is Business Intelligence? Explain its uses?
2. Write any few differences between Power BI and Other tools?
3. Explain about different data sources in Power BI?
4. Write a short note on Data Cleaning?
5. Explain about measures in Power BI?
6. Write a short note on Data Modeling?
7. Explain about various Data Types in DAX Expressions?
8. What is the use of the Power BI Mobile APP?

SECTION-B

Answer ALL  of the following questions.                           8  x 5= 40 M
9. A) Explain the features of Power BI?

(OR)

B)  Explain about different Visualization Tools?

    10. A) Explain how to connect to different data sources in Power BI?

                                                (OR)

           B) Explain briefly about data cleaning and shaping techniques in detail?

     11.  A) Explain different data models in Power BI?

                                                (OR)

            B) Explain about how to create relationships between tables?

A)  Explain about logical functions in DAX with examples?

 (OR)

B) Explain Date and Time functions in DAX?

 

A)  Explain different features available in Power BI Mobile App?

 (OR)

B) How can you publish a report from Power BI Desktop to the Power BI Service?

 

Question Bank

class:	Semester:	Title of The Paper:	Paper Code:	W.E.F
BBA	V	INTRODUCTION TO BUSINESS INTELLIGENCE USING POWER BI		2025-2026

 

4 MARKS

UNIT-1:

1. What is Business Intelligence? Explain its uses?
2. Write a short note on the role of a business analyst?
3. Write any few differences between Power BI and Other tools?

 

UNIT-2:

1. Explain about different data sources in Power BI?
2. Write a short note on Data Cleaning?
3. Write a short note on shaping techniques in Power BI?

 

UNIT-3:

1. Write a short note on Data Modeling?
2. Explain about measures in Power BI?
3. Explain how to format the visualization in Power BI?

 

UNIT-4:

1.What is DAX? What is need of DAX?

2.Explain about Text functions in DAX?

3. Explain about various Data Types in DAX Expressions?

 

UNIT-5:

1. What is the use of the Power BI Mobile APP?

2. What are Power BI Workspaces and how are they used for collaboration?

3.  What is the purpose of publishing a report to the Power BI Service? 

 

8 MARKS

UNIT-1:

1.Explain the features of Power BI?

2.Explain briefly about Power BI Components?

3.Explain about different Visualization Tools?

 

UNIT-2:

1.Explain how to connect to different data sources in Power BI?

2.How to remove duplicate values using Power Query? Explain with an example.

3. Explain briefly about data cleaning and shaping techniques in detail?

 

UNIT-3:

1.Explain different data models in Power BI?

2.Explain about how to create relationships between tables?

3. Explain about different charts in Power BI?

 

UNIT-4:

1. Explain about logical functions in DAX with examples?

2. Explain about Mathematical and Trigonometrical functions?

3.Explain Date and Time functions in DAX?

 

UNIT-5:

1. Explain different features available in Power BI Mobile App?

2. What are the different ways to share a report in Power BI Service?

3. How can you publish a report from Power BI Desktop to the Power BI Service?