Beginner
7 hrs 35 min
3.76
279
Copy link
Lead Academy PTE
License No. 283870
Share this course
Microsoft Power BI
Are you ready to dive into data analysis and visualization with Microsoft Power BI? This course is your gateway to mastering the essential skills needed to harness the power of data and transform it into actionable insights.
Why Is This Course Important to Learn?
In today's data-driven world, the ability to analyze and visualize data effectively is a crucial skill for professionals across various industries. Power BI offers a user-friendly platform to analyze data, create interactive reports, and make informed decisions. Whether you're a data enthusiast, a business analyst, or a decision-maker, this course will equip you with the knowledge and skills to leverage Power BI for your data needs.
Who Is This Course For?
This course is designed for:
- Beginners eager to explore the world of data analysis and visualization
- Professionals seeking to enhance their data analysis skills
- Business owners looking to make data-driven decisions
- Students and educators interested in mastering Power BI
- Anyone eager to harness the power of data for strategic advantage
Why Should You Enroll?
By enrolling in this course, you will:
- Gain proficiency in Microsoft Power BI, a leading business intelligence tool.
- Learn how to connect and transform data from various sources into insightful visualizations.
- Create interactive reports and dashboards that drive actionable insights.
- Develop advanced skills in data modelling, DAX language, and data visualization techniques.
- Access hands-on exercises and real-world projects to reinforce your learning.
What Will You Learn?
Throughout this course, you'll:
- Understand the fundamentals of Power BI and its applications in data analysis and visualization
- Explore data transformation and preparation techniques using Power Query
- Master advanced features such as data modelling, relationships, and DAX expressions
- Create visually stunning reports and dashboards to communicate insights effectively
- Learn best practices for data visualization, storytelling, and report design
- Gain practical experience through guided exercises and real-world case studies
Enroll in the Mastering Power BI Course today and embark on a journey to become a proficient data analyst and storyteller.
Complete This Course and Get Your certificate!
Certify Your Skills
Lead Academy accredited certifies the skills you’ve learned
Stand Out From The Crowd
Add your Lead Certification to your resume and stay ahead of the competition
What Will I Learn?
- Visualization Techniques
- DAX Language
- Data Modeling
- Report Design
- Power BI Basics
- Data Transformation
Course content
- 14 Chapters
- 56 Lessons
- 7 hrs 35 min
Course Overview
Free Preview
00:03:21
What and Why is Power BI
Free Preview
00:04:55
Microsoft Excel vs Microsoft Power BI
00:07:21
Power BI Licensing
00:01:49
Download and Installation of Power BI Software
00:02:39
Power BI Interface
00:02:10
Power BI Workflow
00:01:59
Data Connection
00:14:08
Power Query View
00:02:25
Applied Step and Apply & Close
00:04:08
Transform and Add Column
00:03:28
Data Preparation
00:13:47
Text Manipulation
00:20:06
Number Calculation
00:10:55
Column Management
00:06:33
Date and Time
00:04:57
Merge and Append Queries: Load Enabled
00:24:47
Data Reshaping
00:09:06
Grouping
00:03:13
Mini Project with Microsoft Power BI
00:05:29
What and Why M Language
00:01:33
Syntax of M Language
00:02:48
Object of M Language
00:05:06
Application of M Language
00:11:20
Table Relationship
00:06:12
Types of Relationship
00:09:57
Fact Table, Dimension Table and Star Schema
00:02:36
Dax Introduction
00:05:48
Recap
00:03:11
Dax Measure Filter Context
00:03:41
More Calculation with Dax
00:06:26
More Analysis with Dax
00:11:55
More Analysis with Dax (Extended)
00:29:48
Power BI Related Case Solved
00:05:57
Format Report Page
00:03:42
Create and Modify Different Types of Charts: Part 01
00:20:29
Create and Modify Different Types of Charts: Part 02
00:25:15
Create and Modify Map
00:05:15
Create and Modify Table and Matrix
00:14:09
Apply Conditional Formatting
00:07:46
Apply Conditional Formatting (Extended Part)
00:03:59
Create and Modify Card
00:06:37
Create and Modify Multi-Row Card
00:02:44
Filter Concept of Card and Multi-Row Card
00:05:20
New Card in Power BI
00:09:24
Report and Visual Theme
00:04:41
Tooltips and Interactions
00:07:57
Align Visuals Element
00:03:27
Filter Types
00:02:59
Drill Through
00:02:58
Slicer
00:10:34
Insert Elements - Text, Button, Shapes
00:04:55
Objects and Actions
00:10:03
Closing
00:05:03
Project: Loan Portfolio Status (Part 01)
00:20:53
Project: Loan Portfolio Status (Part 02)
00:23:53
Pre Requisites
- Basic Computer Skill
- Keep video resolution at 1080p
Meet Your Instructor
Md. Shah Alam
Microsoft Certified Trainer
3.76
Instructor Rating
17 Reviews
279 Students
3 Courses
I am Md Shah Alam, a dedicated MS Excel and Power BI professional trainer with over a decade of experience in two leading financial institutions. My career began in 2010 at IDLC Finance Ltd, where I spent four years honing my skills. In 2014, I transitioned to LankaBangla Finance Ltd, eventually becoming the Head of the MIS and Regulatory Reporting Department, where I oversaw central MIS. Driven by a passion for teaching and empowering others, I made a significant shift in 2020 to become a full-time MS Excel and Power BI trainer. As a Microsoft Certified MS Excel Trainer, I now specialize in helping professionals master data tools for impactful decision-making.
Review
3.76
Muhammed Mustafa Kamal
Video Quality is very poor (Third
Ashikur Rahman
"Data Connection"
Reply from Ashikur Rahman
2 months agoOne more thing. There is no PDF in
Reply from Instructor
You will get the excel file in the
Reply from Ashikur Rahman
2 months agoThere is no "File vs Table"
K.M Shafkat Hossain
sir amar poerview software ti open
Reply from K.M Shafkat Hossain
2 months agosir amar power bi software ti
Reply from Instructor
Can you please take screen shot and
Reply from Instructor
Sorry for the late reply. There are
Reply from K.M Shafkat Hossain
2 months agosir chart er moddhe y axis e
legend er
kundly clarify
Reply from K.M Shafkat Hossain
2 months agosir chart er moddhe
legend er
kundly
Reply from K.M Shafkat Hossain
2 months agosir chart er
legend ermoddhe
kindly
Reply from Instructor
Y axis a value and Legend Sub
Anonymous user
But if you don't give me the data
Reply from Instructor
প্রিয়
Reply from Instructor
Did you get the data sheet? Did you
Protik Hasan
Hi, I cannot find the File vs Table
Reply from Instructor
প্রিয়
Reply from Instructor
Did you get the files? Did you start
Md. Shafiqul Haque
I am new here, registered few minutes
Reply from Instructor
প্রিয়
Reply from Instructor
Did you start the learning? How was
ABU NASER
Sir i need video recording class of Loan
Reply from Instructor
দুঃখিত কপিরাইট
MOHAMMAD SHAH PARAN
Reply from Instructor
Hello Paran,
Did you start
Md Abdul Ahad
The video resolution is too bad.
Reply from Instructor
দুঃখিত বিষয়টির
Reply from Instructor
Hello Ahad,
Did you start the
rifat mourtuza
need all the resource files
Reply from Instructor
স্যার, আপনি
Reply from Instructor
Did you get the data sheet? Did you
BDT 1200 ৳2000
Course Duration
7 hrs 35 min
Course Level
Beginner
Students Enrolled
279
Language
English, Bangla
This course includes
1 Project
2 Free Lessons
36 Months Access
Free Exercise Files & Downloadable Resources
Shareable Certificate of Completion
Access on Mobile, Tablet and PC
Facebook Community Group Support
100% online course
Student Helpline
Related Courses
Popular Courses
Most Popular
Certified VAT Management & Application Program
H M Mainuddin Ahammed FCMA
(17)
৳ 2000 ৳4000
Most Popular
হজ্ব এবং উমরাহ-র সম্পূর্ণ প্রস্তুতি (Complete Preparation for Hajj & Umrah)
Dr. Mohammad Manzur-E-Elahi & Tareq Hussain
(26)
৳ 300 ৳500
Most Popular
Stock Market Investment: How to Earn by Investing
Rubaiyat Shaimom Chowdhury
(33)
৳ 1000 ৳3000
Most Popular
Practical Accounting Learning for Finance & Non-Finance Professionals
H M Mainuddin Ahammed FCMA
(29)
৳ 1000 ৳2000
Most Popular
উদ্যোগে নারী : ব্যবসায় শিক্ষার সম্পূর্ণ কোর্স (Women Entrepreneurship)
Amal Foundation
(21)
৳ 0 ৳0
Total Price
BDT 1200 ৳2000
Helpline 01894988285
