Menu

Executive Programs

Workshops

Projects

Blogs

Careers

Student Reviews



More

Academic Training

Informative Articles

Find Jobs

We are Hiring!


All Courses

Choose a category

Loading...

All Courses

All Courses

logo

Business Intelligence using Power BI

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

Book a Class, for FREE

RELATED RECENT PLACEMENTS

Kirankrishna M

advance technologies

SDM Institute of Technology Institute of technology in Ujire, Karnataka

MUJTABA HILAL

Amit Bangre Consulting Limited

Swami Vivekananda Institute of Science & Technology

ARJUN PP

Altener Solutions Private Limited

Government Polytechnic College Kannur Polytechnic college in Kerala

Smita Suryavanshi

Deloitte

KLE Dr. M.S. Sheshgiri College of Engineering and Technology

Jitendra kumar Vishwakarma

Mando Softtech India Pvt. Ltd.

Ambition institute of technology

Meganath Prabu S

Tech Mahindra

C K College of Engineering and Technology

SRITHARAN N

Tata Technologies

SNS College of Technology

AnilKumar Hubballi

Aakruthi3D pvt ltd

KLE Polytechnic Bailhongal

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.

Google Rating
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

  • 5 Years 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.

Instructors profiles

Our courses are designed by leading academicians and experienced industry professionals.

image

1 industry expert

Our instructors are industry experts along with a passion to teach.

image

12 years in the experience range

Instructors with 12 years extensive industry experience.

image

Areas of expertise

  • Full Stack development
  • SQL

Similar Courses

Got more questions?

Talk to our Team Directly

Please fill in your number & an expert from our team will call you shortly.

Please enter a valid number