Executive Programs

Workshops

Projects

Blogs

Careers

Student Reviews

For Business

Academic Training

Informative Articles

Find Jobs

We are Hiring!

All Courses

Choose a category

All Courses

Business Intelligence using Power BI

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

RELATED RECENT PLACEMENTS

Parthiban M

Riverstone

SRM TRP Engineering College

Kotesh Mogudala

Tata Autocomp Systems

Anurag University, Hyderabad

Vipin Jiwane

Orena Solutions

Walchand College of Engineering, Sangli

Chandrakumar ADEPU

Selec Control

Ganapathy Engineering College

Jiji M

Adrasti

Sreepathy Institute of Management And Technology (SIMAT)

Durga Prasad Sunnam

Adrasti

Ucet Technical school in Dokiparru, Andhra Pradesh

Pratik Mankar

Adrasti

B R Harne College Of Engineering

MAHATHIR MOHAMED

TATsunoInida Pvt ltd

K.S.K College of Engineering and Technology

& 1200+ more

Syllabus

This course is full of best-in-class content by leading faculty and industry experts in the form of videos and projects

Course Overview

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.

Course Syllabus

On a daily basis we talk to companies in the likes of Tata Elxsi and Mahindra to fine tune our curriculum.

Week 01 - Introduction to Power BI

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?

Week 02 - Managing Data Source in Power BI

Managing Pages in Power BI
Data Sources in Power BI
Importing Data

Week 03 - Data Formatting with Power BI

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

Week 04 - Data Visualization (Part 1)

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

Week 05 - Data Visualization (Part 2)

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

Week 06 - Power BI Filters and Calculated Fields

Slicer
Basic Filters
Advanced Filters
Top N Filters
Filters on Measures
Page-Level Filters
Report Level Filters
Drillthrough Filters

Week 07 - Basics of DAX

Introduction to DAX
DAX Data Types
DAX Formula Syntax
DAX Measures and Calculations
ROW Context and Filter Context
DAX Operators
DAX Functions

Week 08 - DAX Functions

Aggregate Functions
Date Functions
Logical Functions
Math Functions
String Functions

Week 09 - Advanced DAX Features

Calculated Tables using DAX
Time Intelligence Functions
Cumulative Total
Ranking Function

Week 10 - Power BI Dashboard Creation and Reporting

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

Week 11 - Power Query and M Language

What is Power Query?
Header Row Promotions
Creating an Index Column
Split Column
M Language
Data Types
IF-ELSE Conditions
M Language Functions

Week 12 - Publishing and Sharing

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

Our courses have been designed by industry experts to help students achieve their dream careers

Industry Projects

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 several reports on the given Dataset for analyzing the patterns of reported CVE.

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.

Our courses have been designed by industry experts to help students achieve their dream careers

Ratings & Reviews by Learners

Skill-Lync has received honest feedback from our learners around the globe.

4.8

Business Intelligence using PowerBI

Flexible Pricing

Talk to our career counsellors to get flexible payment options.

Premium

INR 40,000

Inclusive of all charges

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

1 Year Accessto Skill-Lync’s Learning Management System (LMS)
Personalized Pageto showcase Projects & Certifications
Live Individual & Group Sessionsto resolve queries, Discuss Progress and Study Plans.
Personalized & Hands-OnSupport over Mail, Telephone for Query Resolution & Overall Learner Progress.
Job-Oriented Industry Relevant Curriculumavailable at your fingertips curated by Global Industry Experts along with Live Sessions.