Beginner
7 hrs 35 min
3.68
332
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.68
Instructor Rating
19 Reviews
332 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.68
Shahriar Hoque
Great Course worth the money. Especially the visualization part it was very precise. The course was very interactive gave me a great idea about the power query, Dax and M language motivating and giving me a perfect basic idea to learn more about it
RAFI AHMED
আমি কোর্সে এসাইনমেন্ট সাবমিশন করেছি,কিন্তু এখনো সাবমিশান নিচ্ছে না। দেখাচ্ছে যে প্রজেক্ট সাবমিট হয়েছে কিন্তু কোনো আপডেট দেখাচ্ছে না।এর সমাধান কি? ধন্যবাদ।
Reply from RAFI AHMED
7 months agoআর কোন ফরমেটে আপলোড করবো? যেই ফরমেটে সেইভ হয়েছে,অইটা তো আপলোড করা যাচ্ছে না।
Md. Shafiqul Haque
I am new here, registered few minutes ago. How I start? Showing 0 at description option Lesson resources .
Reply from Instructor
প্রিয় শিক্ষার্থী , কোর্স এর মধ্যে Course Resource অপশন থেকে আপনি রিসোর্সে ফাইলগুলো ডাউনলোড করতে পারবেন এবং প্রাকটিস করতে পারবেন।
Reply from Instructor
Did you start the learning? How was the expereince? Please give your constructive feedback and rating
MOHAMMAD SHAH PARAN
Reply from Instructor
Hello Paran,
Did you start the learning? How was the expereince? Please give your constructive feedback and rating
Md Abdul Ahad
The video resolution is too bad.
Reply from Instructor
দুঃখিত বিষয়টির জন্য! ভিডিও এর কোয়ালিটি উন্নত করার জন্য, কোর্স এর ভিডিও কোয়ালিটি পরিবর্তন করুন ।
Reply from Instructor
Hello Ahad,
Did you start the learning? How was the expereince? Please give your constructive feedback and rating
Marufa Akter
Thanks for resolving the issue. I appreciate your effort!
Reply from Instructor
Dear, this is an technical issue. It will be looked into sincerely and your issue will be resolved soon. Please give your rating based on the course content and the teaching delivery. If your rating is based on the technical problems, it will mislead the future learner. If possible, can you please revise the rating. We make a good effort to make a course with good content so that learners can learn and get the best benefit from the course. Thanks in advance for your understanding
Reply from Instructor
Dear, this is an technical issue. It will be looked into sincerely and your issue will be resolved soon. Please give your rating based on the course content and the teaching delivery. If your rating is based on the technical problems, it will mislead the future learner. If possible, can you please revise the rating. We make a good effort to make a course with good content so that learners can learn and get the best benefit from the course. Thanks in advance for your understanding
Md. Ahnaf karim
Overall the course was very good. Speaker approach level is very good enough. The sound and vedio quality is good and i will suggest all over to check out this course.
Sohel Ahmed
video resoulation is quite poor? mostly blurred....can u help?
Reply from Instructor
দুঃখিত বিষয়টির জন্য! ভিডিও এর কোয়ালিটি উন্নত করার জন্য, কোর্স এর ভিডিও কোয়ালিটি পরিবর্তন করুন।
Reply from Instructor
Dear, this is an technical issue. It will be looked into sincerely and your issue will be resolved soon. Please give your rating based on the course content and the teaching delivery. If your rating is based on the technical problems, it will mislead the future learner. If possible, can you please revise the rating. We make a good effort to make a course with good content so that learners can learn and get the best benefit from the course. Thanks in advance for your understanding
Reply from Sohel Ahmed
1 year agookay
ABU NASER
Sir i need video recording class of Loan portfolio status 1 & 2. Thanks
Reply from Instructor
দুঃখিত কপিরাইট জনিত কারণে আমাদের কোর্সের ভিডিও ডাউনলোড বা শেয়ার করার অপশন নেই।
Roksana Akther
In the case of merged, if data remains in two columns then which data will be kept in merged columns?
Reply from Instructor
Example: if first column contains first name (Shah) and second column contains last name (Alam), and both column are merged, the column will show result first and and last name (Shah Alam) I hope it will serve answer to your question
K.M Shafkat Hossain
sir amar poerview software ti open korar por data view singn er jaygay shudu table view lekha astase kivabe etika data view korbo kindly janaben
Reply from K.M Shafkat Hossain
11 months agosir amar power bi software ti openkorar por data view singn er jaygayshudu table view lekha astase kivabeetika data view korbo kindly janaben
Reply from Instructor
Can you please take screen shot and upload here. So that I can provide the best solution
Reply from Instructor
Sorry for the late reply. There are three icons in the left most side One is report view, second one data view and last one model view. You can click on them. however, upload the screen shot
Reply from K.M Shafkat Hossain
10 months agosir chart er moddhe y axis e all time value asbe?
legend er moddhe ki man all time bosbe?
kundly clarify korben
Reply from K.M Shafkat Hossain
10 months agosir chart er moddhe y axis e all time value bosbe?
legend er moddhe kiser man all time bosbe?
kundly clarify korben
Reply from K.M Shafkat Hossain
10 months agosir chart er moddhe y axis e all time value bosbe?
legend ermoddhe kiser man all time bosbe?
kindly clarify korben
Reply from Instructor
Y axis a value and Legend Sub Category. For example, X axis Branch and Legend Gender. It will show each series branch and Gender
Ashikur Rahman
"Data Connection" ভিডিওতে আপনি 'sales.xlsx' নামের একটি ফাইল ইমপোর্ট করেছেন, যেখানে Data-2016 থেকে Data-2020 একসাথে একটা ফাইলে সাজানো আছে। কিন্তু Course resource ফোল্ডারে Data গুলো আলাদা আলাদা ফাইলে দেওয়া।
Reply from Ashikur Rahman
11 months agoOne more thing. There is no PDF in resource folder. So I can't practice the part of connecting data from pdf.
Reply from Instructor
You will get the excel file in the File vs Table folder. If you do not find, please let me know.
Reply from Ashikur Rahman
10 months agoThere is no "File vs Table" folder. I downloaded "Data for Practice" folder from "Resources" tab. Anyway, this was not a major issue. The course is helpful for me.
Hhhh
Dear Bhai, I am hoping the excel sheet so that i can replica your teaching. Generally, in what file instructor is working, is given with lecture below tile, such as in Udemy there always a excel sheet what covered in a lecture.
Reply from Instructor
I got it. I will talk with the concerned person and try to resolve the issue
Reply from Instructor
I got it. I will talk with the concerned person and try to resolve the issue
Reply from Instructor
আপনি কোর্স এর "Related Resource" অপশন থেকে ফাইল গুলো ডাউনলোড করতে পারবেন।
Reply from Instructor
Did you get the data sheet? Did you start the learning? How was the expereince? Please give your constructive feedback and rating
rifat mourtuza
need all the resource files
Reply from Instructor
স্যার, আপনি ভিডিওটিতে ক্লিক করলে "Description" অপশনটি পাবেন। তারপর লেসন এক্সারসাইজ অপশনটিতে সমস্ত ক্লাস পিডিএফ পাবেন এবং সেগুলি ডাউনলোড করতে পারবেন। লেসন ভিডিও পরিবর্তন করলে পিডিএফ ফাইলও পরিবর্তন হবে। আপনি কোর্স এর "Related Resource" অপশন থেকেও ফাইল গুলো ডাউনলোড করতে পারবেন।
Reply from Instructor
Did you get the data sheet? Did you start the learning? How was the expereince? Please give your constructive feedback and rating
Protik Hasan
Hi, I cannot find the File vs Table folder - Sales Data workbook from the resource option. Please help. Thanks
Reply from Instructor
প্রিয় শিক্ষার্থী , কোর্স এর মধ্যে Course Resource অপশন থেকে আপনি রিসোর্সে ফাইলগুলো ডাউনলোড করতে পারবেন এবং প্রাকটিস করতে পারবেন।
Reply from Instructor
Did you get the files? Did you start the learning? How was the expereince? Please give your constructive feedback and rating
BDT 1200 ৳2000
Course Duration
7 hrs 35 min
Course Level
Beginner
Students Enrolled
332
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
(20)
৳ 2000 ৳4000
Most Popular
হজ্ব এবং উমরাহ-র সম্পূর্ণ প্রস্তুতি (Complete Preparation for Hajj & Umrah)
Dr. Mohammad Manzur-E-Elahi & Tareq Hussain
(29)
৳ 300 ৳500
Most Popular
Stock Market Investment: How to Earn by Investing
Rubaiyat Shaimom Chowdhury
(35)
৳ 1000 ৳3000
Most Popular
Practical Accounting Learning for Finance & Non-Finance Professionals
H M Mainuddin Ahammed FCMA
(32)
৳ 1000 ৳2000
Most Popular
উদ্যোগে নারী : ব্যবসায় শিক্ষার সম্পূর্ণ কোর্স (Women Entrepreneurship)
Amal Foundation
(30)
৳ 0 ৳0
Total Price
BDT 1200 ৳2000
Helpline 01894988285
