Beginner
7 hrs 35 min
3.76
281
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
281 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 class). You should improve video quality before launch a corse
Ashikur Rahman
"Data Connection" ভিডিওতে আপনি 'sales.xlsx' নামের একটি ফাইল ইমপোর্ট করেছেন, যেখানে Data-2016 থেকে Data-2020 একসাথে একটা ফাইলে সাজানো আছে। কিন্তু Course resource ফোল্ডারে Data গুলো আলাদা আলাদা ফাইলে দেওয়া।
Reply from Ashikur Rahman
3 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
3 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.
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
3 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
3 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
3 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
3 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
Anonymous user
But if you don't give me the data sheet,how do i practice?
Reply from Instructor
প্রিয় শিক্ষার্থী , কোর্স এর মধ্যে Course 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
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
ABU NASER
Sir i need video recording class of Loan portfolio status 1 & 2. Thanks
Reply from Instructor
দুঃখিত কপিরাইট জনিত কারণে আমাদের কোর্সের ভিডিও ডাউনলোড বা শেয়ার করার অপশন নেই।
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
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
BDT 1200 ৳2000
Course Duration
7 hrs 35 min
Course Level
Beginner
Students Enrolled
281
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
(34)
৳ 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
(22)
৳ 0 ৳0
Total Price
BDT 1200 ৳2000
Helpline 01894988285
