Business Intelligence using Power BI
Learn the ins and outs of Business Intelligence using Power BI.
RELATED RECENT PLACEMENTS
Rohit Mali
William O'Neil India
NMIMS MUMBAI
Dhiraj Satghare
RD Civil Solution
Acharya Shrimannarayan Polytechnic
Namrata Rao
Piaggio & C. S.p.A.
Rajeev Gandhi College of Engg and Research Institute
Siddhi Parab
C.C Engineers
lokmanya tilak college of engineering
Anil Katarkar
3D engineering
NATIONAL INSTITUTE OF TECHNOLOGY
Bhavesh Kumbhare
Dar Al-Handasah Engineering company
Rashtrasant Tukadoji Maharaj Nagpur University
Akash Bhadkumbe
XS CAD
Dr. D Y Patil College of Engineering & Innovation, Varale
Madhura Joshi
NEILSOFT LIMITED
Government Polytechnic Ratnagiri
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.
Instructors profiles
Our courses are designed by leading academicians and experienced industry professionals.
1 industry expert
Our instructors are industry experts along with a passion to teach.
12 years in the experience range
Instructors with 12 years extensive industry experience.
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.