Menu

Executive Programs

Workshops

Projects

Blogs

Careers

Student Reviews


For Business / Universities

Corporate Training

Hire from US

Academic Up-skilling



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.

nsdc
Approved Training Partner

Book a Class, for FREE

Please enter a valid email
Please enter a valid number

RELATED RECENT PLACEMENTS

Omkar Dinkar

Akkodis

Top Engineering College in Nashik - MET Institute of Engineering, Bhujbal Knowledge City

Pushkar Sonwane

Akkodis

Deogiri Institute Of Technology & Manegement

Pravin Magar

Technorithmengg

Dr. D. Y. Patil Institute of Technology

Shruti Jadhav

Speed Engineering Solutions

Sandip University

Shubham Nashirkar

UPR Engineering Pvt Ltd

Shri Datta Meghe Polytechnic

Ritik Rathi

Cyient

Prof.Ram Meghe Institute of Technology & Research

Meghraj Patil

Tech Mahindra

Sinhgad College of Engineering, Pune

Akshay Pawar

Equilibrium Solutions

MET's Institute Of Engineering, Nashik, Maharashtra, India

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

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