Complete Introduction to Microsoft Power BI [2023 Edition]

Focused View

Ian Littlejohn

7:05:47

42 View

01 - Introduction

001 Introduction to Power BI.mp4

02:28

002 About the Course.mp4

01:42

003 Date-Master.xlsx

003 Download the Training Data Files.html

003 Employee-Data.csv

003 Employee-Master.xlsx

003 TrainingData1.xlsx

003 TrainingSample2.xlsx

02 - Sign Up for Power BI

001 Introduction to Signing Up for Power BI.mp4

02:04

002 Signing up for Power BI.mp4

07:10

003 Load Data into the Power BI Service.mp4

09:37

004 Practical Activity.html

03 - The Power BI Desktop

001 Introduction to Power BI Desktop Section.mp4

00:36

002 Overview of Power BI Desktop.mp4

10:27

04 - Creating Reports in Power BI Desktop

001 Create Reports in Power BI Desktop Section.mp4

01:27

002 Creating Tables in Power BI.mp4

08:14

003 Table Styles and Formatting.mp4

07:42

004 Updated Formatting.mp4

06:33

005 Matrix Visualization.mp4

09:35

006 Tables and Matrixes Practical Activity.html

007 Answers to Tables and Matrixes Practical Activity.mp4

06:01

008 Changing the Method of Aggregation.mp4

10:50

009 Methods of Aggregation Challenge.html

010 Methods of Aggregation Challenge Completed.mp4

04:56

011 Cards and Multi Row Cards.mp4

10:54

012 Cards, Matrix and Multi Row Card Challenge.html

013 Answers to Cards Challenge.mp4

08:01

014 Percentage Calculations.mp4

07:06

015 Working with Dates.mp4

05:11

016 Filtering Data - Using Slicers.mp4

09:27

017 Filtering Data - Visual Filters.mp4

09:53

018 Filtering Data - Drill Through Filter.mp4

03:11

019 Practical Activity - Filters.html

020 Practical Activity Filters Completed.mp4

06:30

021 Filtering Data - Page Filters.mp4

02:24

05 - Graphs and Visualizations

001 Introduction to Visualization Section.mp4

01:57

002 Clustered Column Graphs.mp4

11:21

003 Stacked and 100% Graphs.mp4

08:15

004 Column Graph Challenge.html

005 Column Graph Challenge Completed.mp4

03:59

006 Graph Options.mp4

05:16

007 Analytical Features.mp4

07:13

008 Trend Analysis Graphs.mp4

11:34

009 Area Graphs.mp4

05:41

010 Ribbon Graphs.mp4

04:37

011 Additional Graphs.mp4

07:45

012 Scatterplots and Bubbleplots.mp4

07:18

013 Decomposition Tree.mp4

03:23

06 - Interactive Dashboards

001 Creating Interactive Dashboards.mp4

01:57

002 Challenge - Create an Interactive Report.html

003 Completed Challenge - How to Create an Interactive Report.mp4

08:29

004 Publishing Reports to the Power BI Service.mp4

06:59

005 Pinning Visualizations to Dashboards.mp4

07:13

006 Mobile Reports.mp4

04:45

007 Q and A.mp4

07:09

008 App Workspaces.mp4

04:15

009 Publishing an App.mp4

05:10

010 Using Themes in Power BI.mp4

07:57

011 Using Custom Visualizations.mp4

07:01

07 - DAX Formulas

001 Introduction to Calculated Columns.mp4

01:29

002 DAX Calculated Columns.mp4

10:54

003 Date Functions.mp4

07:32

004 Formatting Dates.mp4

08:37

005 Date Master Tables.mp4

10:39

08 - DAX Measures

001 Introduction to Measures Section.mp4

01:35

002 Introduction to DAX Measures.mp4

10:17

003 DAX Measures Practical Activity.html

004 DAX Measures Activity Completed.mp4

07:51

005 The =Calculate Formula.mp4

08:51

09 - Relationships

001 Relationships Section.mp4

00:53

002 Creating and Managing Relationships in Power BI.mp4

06:48

003 Relationship Calculations.mp4

06:37

10 - Power BI Query Editor

001 Introduction to Power BI Query Editor.mp4

01:04

002 Basic Transformations - Part 1.mp4

11:27

003 Basic Transformations - Part 2.mp4

09:10

004 Aggregating Data.mp4

05:55

11 - Analyze Data with Excel

001 Introduction to Power BI and Excel.mp4

00:48

002 Power BI and Excel Connections.mp4

10:28

12 - Corona Virus Case Study

001 Introduction to the Corona Virus Case Study.mp4

01:23

002 Corona Virus Link.html

003 WHO Data Files.mp4

03:06

004 Corona Virus Case Study.mp4

04:36

005 Corona Virus Dashboard on the web.mp4

03:40

13 - Conclusion

001 Conclusion.mp4

00:54

002 Useful Resources and Links.html

Description

A comprehensive guide on how to import, transform & visualise data with Power BI, with practical exercises & case study.

What You'll Learn?

Enjoy CLEAR and CONCISE step by step lessons from a best selling Udemy instructor in FULL HD 1080 P video
Learn to create POWERFUL reports and dashboards with Microsoft Power BI with a few clicks of the mouse
Gain valuable INSIGHT and INTELLIGENCE from your business and marketing data in a FRACTION of the time of traditional spreadsheets
PUBLISH reports and dashboards on the Internet and view using laptops, tablets or smartphones in minutes
Learn to create Data Models and use the DAX Formula language to develop POWERFUL calculations
Easily create a wide range of GRAPHS and VISUALISATIONS using drag and drop technologies
Use the Power BI Q & A feature to easily ask QUESTIONS of your data and provide new insight

Who is this for?

All Excel users who work with data, reports or dashboards

All existing Business Intelligence developers and users

Anyone who wants to get an excellent foundation in how to use Power BI from beginner level

What You Need to Know?

Recommended to know the basics of working with data in Excel

In the course you will need a work email address to sign up for the free Microsoft Power BI service

Download the Power BI Desktop app which is available free from Microsoft for Windows

More details

Description
If you are new to Power BI or want to fill in some gaps in your knowledge, THIS is the course for you.Â We've focused on providing you with the fundamentals you need to work with Power BI effectively!
Don't sit through days of boring training to understand how Power BIÂ works!Â This course will get you up to speed and working in half the time, giving you the crucial foundation to start you on the journey to becoming a Power BI expert.Â
This course has been updated for 2023 in full HD video quality, so you will learn on the latest Power BI interface. Students who have taken this course have this to say:
WHATÂ STUDENTSÂ AREÂ SAYING:
"Amazing and captivating course! I have started it with a zero knowledge about Power BI. Now I feel very comfortable and knowledgeable to use it. Thank you for the great course. Highly recommended!"
"Best course content and trainer I have had. Can translate the new skills learnt directly into my role and elevate our business. Thank you"
"This was a very informative course even though I was already a user of Power BI and had followed another course previously. Enjoyed it and learnt a lot which will be useful in my day to day work! Thank you Ian :)"
WHATÂ YOUÂ CANÂ EXPECT:
Understand the flow of using Power BI, from connecting to various data sources, importing these into Power BI, transforming the data and then presenting it effectively
Learn how to use Power BI Desktop, Power BIÂ Query Editor &Â the Power BIÂ Service
Learn how to create relationships between related data sources
Learn how to build reports with various types of aggregations and filters
Learn about the various types of visualizations possible in Power BIÂ and how to use them
Learn how to create interactive dashboards with drill throughs and relative date filters
Learn how to publish dashboards to the web and mobile app
Learn how to use themes and custom visualizations
Learn about DAXÂ and how to use it to build measures
Learn how to work with Excel & Power BI to create a dynamic and effective business solution
Learn how to put this all into practice with a case study about the Corona Virus.Â
REQUIREMENTS:
You will need to have a PC/Windows laptop loaded with the latest version of Microsoft Power BI (available as a free download).Â Note that Power BIÂ does not currently run natively on a Mac.
Whilst this course is designed to cover Power BI from the ground up, some experience of working with data in Excel would be beneficial.
ABOUTÂ THEÂ TRAINER:
Ian Littlejohn has been a top-rated trainer on the Udemy platform for over 5 years and has more than 10 years' experience in training &Â management consulting.Â He specialises in Data Analysis, covering Excel, Power BI, Google Data Studio and Amazon QuickSight.Â
Ian has over 200,000 students and 80,000 reviews and an average course rating of over 4.5 out of 5.Â He has a reputation for delivering excellent, logically structured courses which are easy to follow and get the point across without wasting learners' time.Â
You can see all of Ian's other Data Analysis courses by searching for his name on Udemy.Â
WHYÂ YOUÂ SHOULDÂ SIGNÂ UP:
Learners buying this course get:
Full access to almost 7 hours of Full HDÂ quality video
Lifetime access
Money-back guarantee (see Udemy terms and Conditions)
Certificate of completion upon course conclusion
COURSEÂ ROADMAP:
This course will take you from beginner to intermediate level.Â Look out for Ian's follow on courses to take your skills onto the next level!
Complete Introduction to Power BIÂ Query Editor
Power BI Master Class-Data Models and DAX Formulas
Power BI Master Class - Dashboards and Power BI Service
We look forward to having you on the course!
Who this course is for:
All Excel users who work with data, reports or dashboards
All existing Business Intelligence developers and users
Anyone who wants to get an excellent foundation in how to use Power BI from beginner level

User Reviews

Rating

average 0

Total votes0

Focused display

Microsoft Power BI

Ian Littlejohn

Instructor's Courses

Ian is a trainer that specializes in Microsoft Power BI, Excel Pivot Tables, Power Pivot, Power Query, Google Data Studio and AWS QuickSight. Ian is an experienced trainer that teaches techniques and tools making it easy for learners to harness the power of business intelligence tools to easily turn data into insight and intelligence.Ian has been training learners on these powerful technologies for over 10 years making it easy for business users to easily create management reports, develop interactive dashboards and generate new insight and intelligence from business data. Ian has over 10 years of Management Consulting experience and he brings this knowledge and skills to his training course showing Excel and Google Data Studio users how to easily create sophisticated management reports, perform data analysis and create amazing interactive dashboards without using any complex programming or specialized tools. Ian has consulted and worked with major organizations in the Banking, Insurance, Manufacturing, Telecommunications and Logistics industries across a number of countries and continents.

Udemy

View courses Udemy

Students take courses primarily to improve job-related skills.Some courses generate credit toward technical certification. Udemy has made a special effort to attract corporate trainers seeking to create coursework for employees of their company.