Microsoft Power BI
Md. Shah Alam
Instructor
Md. Shah Alam
Course Level
Beginner
Duration
Duration 7 hrs 35 min
Rating
Rating 3.76
Students
Students 279

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

Muhammed Mustafa Kamal

1 month ago

Video Quality is very poor (Thirdclass). You should improve video qualitybefore launch a corse

Ashikur Rahman

Ashikur Rahman

2 months ago

"Data Connection"ভিডিওতে আপনি'sales.xlsx' নামেরএকটি ফাইলইমপোর্টকরেছেন, যেখানেData-2016 থেকে Data-2020একসাথে একটাফাইলে সাজানোআছে। কিন্তু Courseresource ফোল্ডারে Dataগুলো আলাদাআলাদা ফাইলেদেওয়া। 

Reply from Ashikur Rahman

2 months ago

One more thing. There is no PDF inresource folder. So I can't practicethe part of connecting data frompdf.

Reply from Instructor

You will get the excel file in theFile vs Table folder. If you do notfind, please let meknow.

 

Reply from Ashikur Rahman

1 month ago

There is no "File vs Table"folder. I downloaded "Data forPractice" folder from"Resources" tab. Anyway, thiswas not a major issue. The course ishelpful for me.

K.M Shafkat Hossain

K.M Shafkat Hossain

2 months ago

sir amar poerview software ti openkorar por data view singn er jaygayshudu table view lekha astase kivabeetika data view korbo kindly janaben

Reply from K.M Shafkat Hossain

2 months ago

sir amar power bi software tiopenkorar por data view singn erjaygayshudu table view lekha astasekivabeetika data view korbo kindlyjanaben

Reply from Instructor

Can you please take screen shot andupload here. So that I can provide thebest solution

Reply from Instructor

Sorry for the late reply. There arethree icons in the left most side One isreport view, second one data view andlast one model view. You can click onthem. however, upload the screenshot

Reply from K.M Shafkat Hossain

1 month ago

sir chart er moddhe  y axis eall time value asbe?

legend ermoddhe ki man all timebosbe?

kundly clarifykorben

 

Reply from K.M Shafkat Hossain

1 month ago

sir chart er  moddhe  y  axis e all timevalue  bosbe?

legend ermoddhe kiser  man all time  bosbe?

kundly clarify korben

 

Reply from K.M Shafkat Hossain

1 month ago

sir chart er moddhe  y   axise  all   time  value   bosbe?

legend ermoddhekiser  man all time bosbe?

kindly clarify korben

 

Reply from Instructor

Y axis a value and Legend SubCategory. For example, X axis Branch andLegend Gender. It will show each seriesbranch and Gender

Anonymous user

4 months ago

But if you don't give me the datasheet,how do i practice?

Reply from Instructor

প্রিয়শিক্ষার্থী ,কোর্স এর মধ্যেCourse Resource অপশনথেকে আপনিরিসোর্সেফাইলগুলোডাউনলোড করতেপারবেন এবংপ্রাকটিস করতেপারবেন।

Reply from Instructor

Did you get the data sheet? Did youstart the learning? How was theexpereince? Please give yourconstructive feedback and rating

Protik Hasan

Protik Hasan

4 months ago

Hi, I cannot find the File vs Tablefolder - Sales Data workbook from theresource option. Please help. Thanks

Reply from Instructor

প্রিয়শিক্ষার্থী ,কোর্স এর মধ্যেCourse Resource অপশনথেকে আপনিরিসোর্সেফাইলগুলোডাউনলোড করতেপারবেন এবংপ্রাকটিস করতেপারবেন।

Reply from Instructor

Did you get the files? Did you startthe learning? How was the expereince?Please give your constructive feedbackand rating

Md. Shafiqul Haque

Md. Shafiqul Haque

5 months ago

I am new here, registered few minutesago. How I start? Showing 0 atdescription option Lesson resources .

Reply from Instructor

প্রিয়শিক্ষার্থী ,কোর্স এর মধ্যেCourse Resource অপশনথেকে আপনিরিসোর্সেফাইলগুলোডাউনলোড করতেপারবেন এবংপ্রাকটিস করতেপারবেন।

Reply from Instructor

Did you start the learning? How wasthe expereince? Please give yourconstructive feedback and rating

ABU NASER

ABU NASER

5 months ago

Sir i need video recording class of Loanportfolio status 1 & 2. Thanks

Reply from Instructor

দুঃখিত কপিরাইটজনিত কারণেআমাদের কোর্সেরভিডিও ডাউনলোডবা শেয়ার করারঅপশন নেই।

MOHAMMAD  SHAH PARAN

MOHAMMAD SHAH PARAN

6 months ago

Reply from Instructor

Hello Paran,

Did you startthe learning? How was the expereince?Please give your constructive feedbackand rating

Md Abdul Ahad

Md Abdul Ahad

6 months ago

The video resolution is too bad.

Reply from Instructor

দুঃখিত বিষয়টিরজন্য! ভিডিও এরকোয়ালিটি উন্নতকরার জন্য,কোর্স এর ভিডিওকোয়ালিটিপরিবর্তন করুন

Reply from Instructor

Hello Ahad,

Did you start thelearning? How was the expereince? Pleasegive your constructive feedback andrating

rifat mourtuza

rifat mourtuza

6 months ago

need all the resource files

Reply from Instructor

স্যার, আপনিভিডিওটিতেক্লিক করলে"Description" অপশনটিপাবেন। তারপরলেসনএক্সারসাইজঅপশনটিতে সমস্তক্লাস পিডিএফপাবেন এবংসেগুলি ডাউনলোডকরতে পারবেন।লেসন ভিডিওপরিবর্তন করলেপিডিএফ ফাইলওপরিবর্তনহবে। আপনিকোর্স এর "RelatedResource" অপশন থেকেওফাইল গুলোডাউনলোড করতেপারবেন।

Reply from Instructor

Did you get the data sheet? Did youstart the learning? How was theexpereince? Please give yourconstructive feedback and rating

Total Price

BDT 1200 ৳2000

Buy Now

Helpline 01894988285

Secured with SSL

Hotline 1: +88 01894988285

Hotline 2: +88 01896177223

Pay with
© 2021 - 2024 Lead Academy, All Rights Reserved. Made with in Bangladesh.
App Version : v2024.1.6.0