BMBA153 Business Intelligence Using Power BI Syllabus — AKTU 2024-25

Syllabus

5 units · 30 lecture hours

Unit1

Unit 1: Introduction to Power BI

3 hrs

What is BI (Business Intelligence), What is Power BI and Why choose Power BI? Power BI VS Power Excel, Installing Power BI Desktop, Power BI Interface, Report View Tab, Data View Tab, Power BI Architecture.

Unit2

Unit 2: Connecting and Shaping Data

5 hrs

Data Load in Power BI, why to use Power BI Query Editor? How to open or access Power Query Editor, Power Query Editor Interface, Manage Rows and columns, Text, Date and Number Transformations, grouping by using Power Query Editor, Pivot & Unpivot using Power Query Editor, Merge and Append Query using Power Query Editor.

Unit3

Unit 3: Data Model in Power BI

6 hrs

What is Data Modeling? Database Normalization, Primary Key vs Foreign Key, Active and Inactive Relationship, Data Tables and Fact tables, Star Schema, Direction of Relationship, Relationship Cardinality, Connecting Multiples Tables

Unit4

Unit 4: Creating Measures with Dax

6 hrs

What is Dax (Data Analysis Expression)? Purpose and usage of DAX, Calculated Columns, Measures, Difference Between Calculated Column and Measures, Calculate Function, Implicit Measures and Explicit Measures, Time Intelligence Dax Function, Filter Dax Functions, Table Manipulation Dax Functions, Iterate Functions, Logical Dax Functions, Relationship Functions

Unit5

Unit 5: Data Visualization in Power BI

10 hrs

What is Data Visualization? Data Visualization Using Power BI, Matrix Visual in Power BI, Conditional Formatting, Charts, How to Publish reports and creation Work Space? Dashboard Creation and Setting Alerts using a case study.

Course Objectives5 points

To introduce students to the fundamentals of Business Intelligence (BI) and Power BI, enabling them to understand the architecture and interface of Power BI for effective data visualization and analysis.
To equip students with the skills to connect, load, and transform data using Power Query Editor, facilitating the management and preparation of data for analysis in Power BI.
To develop students' understanding of data modeling concepts and techniques, including the creation of relationships between data tables, to build a robust data model in Power BI.
To enable students to create and utilize DAX expressions for calculating and analyzing data within Power BI, enhancing their ability to perform complex data analysis.
To teach students how to effectively visualize data using Power BI’s various tools and features, culminating in the ability to publish reports and create interactive dashboards.

Course Outcomes (COs)5 outcomes

After completion of the course student will be able to:

CO1Students will be able to explain the concept of Business Intelligence (BI) and navigate the Power BI interface effectively.K2 (Understand)
CO2Students will be able to perform data connections, load data, and apply transformations using Power Query Editor.K3 (Apply)
CO3Students will be able to design and implement data models, including creating and managing relationships in Power BI.K4 (Analyze)
CO4Students will be able to create and apply DAX formulas for advanced data calculations and analysis in Power BI.K5 (Create)
CO5Students will be able to design and publish interactive dashboards and reports, applying data visualization techniques.K6 (Evaluate)

Official AKTU syllabus

This subject is on page 20, 21 of the original AKTU PDF.

Official AKTU syllabus PDF ↗

Business Intelligence Using Power BI