Computer Science · Course

Business Intelligence using Power BI

Learn the ins and outs of Business Intelligence using Power BI.

Talk to a counsellor →View curriculum

Duration: 12 weeks
Content: 23 hours
Projects: 2
Mode: Online

Overview

What you'll
be able to do.

This course enables the learners to work on advanced features of Power BI with the inclusion of extensive hands-on sessions in the program.
From this course, learners can blend and transform raw data into stunning interactive dashboards.
This course helps the learners build professional-quality business intelligence reports using the same BI tools and techniques used by professional analysts.

Tools you'll use

Power BI

Curriculum

12 modules,
built with industry.

01Business Intelligence using Power BI12 modules
1. Introduction to Power BIW01
  - What is Business Intelligence?
  - What is Microsoft Power BI?
  - Why Power BI?
  - Power BI Components
  - Power BI Architecture
  - Types of Power BI Tools
  - Installation of Power BI Desktop
  - Introduction to Power BI User Interface
  - What is a Power BI Developer?
  - What is a Power BI Analyst?
  - What is Power BI Consultant?
  - What is Power BI Manager?
2. Managing Data Source in Power BIW02
  - Managing Pages in Power BI
  - Data Sources in Power BI
  - Importing Data
3. Data Formatting with Power BIW03
  - Introduction to Query Editor
  - Data Types
  - Data Transformation
  - Change the Data Type of Columns
  - Creating Bins
  - Combining Data from Multiple Tables
  - Date Formatting
  - Grouping in Power BI
  - Creating Hierarchy in Power BI
  - Columns Customization
  - Pivot Table
  - Unpivot Table
  - Data Transpose
  - Data Sorting
4. Data Visualization (Part 1)W04
  - Card
  - Line Chart
  - Area Chart
  - Clustered Column Chart
  - Clustered Bar Chart
  - Donut Chart
  - Funnel Chart
  - Matrix
  - Clustered Column and Line
  - Line and Stacked Column
  - Multi-Row Card
5. Data Visualization (Part 2)W05
  - Pie Chart
  - Ribbon Chart
  - Stacked Area
  - Scatter Chart
  - Stacked Bar Chart
  - Stacked Column
  - Table
  - TreeMap
  - Waterfall Chart
  - 100% Stacked Bar
  - 100% Stacked Column
  - Map
  - Filled Map
6. Power BI Filters and Calculated FieldsW06
  - Slicer
  - Basic Filters
  - Advanced Filters
  - Top N Filters
  - Filters on Measures
  - Page-Level Filters
  - Report Level Filters
  - Drillthrough Filters
7. Basics of DAXW07
  - Introduction to DAX
  - DAX Data Types
  - DAX Formula Syntax
  - DAX Measures and Calculations
  - ROW Context and Filter Context
  - DAX Operators
  - DAX Functions
8. DAX FunctionsW08
  - Aggregate Functions
  - Date Functions
  - Logical Functions
  - Math Functions
  - String Functions
9. Advanced DAX FeaturesW09
  - Calculated Tables using DAX
  - Time Intelligence Functions
  - Cumulative Total
  - Ranking Function
10. Power BI Dashboard Creation and ReportingW10
  - Add Reports to a Dashboard
  - How to Add an Image to the Dashboard?
  - Add Video to Dashboard
  - Add Web Content to the Dashboard
  - Dashboard Settings
  - Creating a Report
  - Creating a Report using Excel
  - Get Insights into a Report
11. Power Query and M LanguageW11
  - What is Power Query?
  - Header Row Promotions
  - Creating an Index Column
  - Split Column
  - M Language
  - Data Types
  - IF-ELSE Conditions
  - M Language Functions
12. Publishing and SharingW12
  - Power BI Sharing Option
  - Publish from Power BI Desktop
  - Printing, PDFs, and Exporting to PowerPoint
  - Export Data from a Visualization
  - Data Refreshing
  - Replacing a Dataset
  - Format Row Level Security

Industry projects

2 projects
you'll ship.

Our projects are designed by experts in the industry to reflect industry standards. By working through our projects, Learners will gain a practical understanding of what they will take on at a larger-scale in the industry. In total, there are 2 Projects that are available in this program.

Analysis of Reported CVEs Pattern

Learners are provided with Dataset for January 2022 to June 2022 of CVE (Common Vulnerabilities and Exposures) Records. Using the given records, learners are required to create sev…

Behavioral Analysis of Android Ransomware Attacks

Generate a Report and Dashboard on Analysis of the Behaviour of Android Ransomware Attacks. The learners are required to create a dashboard for the charts and export the reports.

Fee

One fee.
Everything included.

Become job ready with our comprehensive industry focused curriculum for freshers & early career professionals

Premium

₹40,000

Inclusive of all charges

1 Year Access
Personalized Page
Live Individual & Group Sessions
Personalized & Hands-On
Job-Oriented Industry Relevant Curriculum

Check eligibility →

You might also like.

PG program · 24 weeksData Science and Machine Learning→PG program · 24 weeksData Analytics and Data Science→PG program · 16 weeksPre-Graduate Program in Data Analytics and Data Science→Course · 12 weeksMachine Learning Fundamentals In Depth→Course · 12 weeksMath behind Machine Learning & Artificial Intelligence using Python→Course · 12 weeksIntroduction to Machine Learning Algorithms and their Implementation in Python→

Next step

Not sure it's
the right fit?

A counsellor will walk you through the syllabus, projects and fee options — and tell you honestly if another course suits you better.

Call us Enquire

Business Intelligence using Power BI

What you'llbe able to do.

12 modules,built with industry.

2 projectsyou'll ship.