Complete Introduction to Microsoft Power BI

COMPREHENSIVE guide on how to IMPORT, TRANSFORM, VISUALIZE data with Power BI, with practical exercises and case studies

4.57 (35594 reviews)
Udemy
platform
English
language
Data & Analytics
category
instructor
Complete Introduction to Microsoft Power BI
118,199
students
7.5 hours
content
Mar 2024
last update
$99.99
regular price

What you will 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

Why take this course?

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 250,000 students  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!

Content

Introduction

Introduction Section
Introduction to PowerBI
Download the Training Data Files and Learner Guide
Signing up for PowerBI
Load Data into the Power BI Service
Practical Activity

The Power BI Desktop Designer

Intro to PowerBI Desktop Section
Introduction to the Power BI Desktop

Creating Reports in Power BI Desktop

Create Reports in Power BI Desktop Section
Creating Tables in Power BI
Table Styles and Formatting
Matrix Visualization
Tables and Metrics Practical Activity
Answers to Tables and Metrics Practical Activity
Changing the Method of Aggregation
Methods of Aggregation Challenge
Methods of Aggregation Challenge Completed
Cards and Multi Row Cards
Cards, Matrix and Multi Row Card Challenge
Answers to Cards Challenge
Percentage Calculations
Filtering Data - Using Slicers
Filtering Data - Visual Filters
Filtering Data - Page Filters
Filtering Data - DrillThrough Filter
Practical Activity - Filters
Practical Activity Filters Completed

Graphs and Visualizations

Introduction to Visualization Section
Clustered Column Graphs
Stacked and 100% Graphs
Column Graph Challenge
Column Graph Challenge Completed
Graph Options
Trend Analysis Graphs
Area Graphs
Ribbon Graphs
Additional Graphs
Scatterplots and Bubbleplots

Interactive Dashboards

Creating Interactive Dashboards
Challenge - Create an Interactive Report
Completed Challenge - How to Create an Interactive Report
Publishing Reports to the Power BI Service
Pinning Visualizations to Dashboards
Mobile Reports
Q and A
App Workspaces
Publishing an App
Using Themes in Power BI
Using Custom Visualizations

DAX Formulas

DAX Formulas Section
DAX Formulas
Date Functions
Formatting Dates
Date Master Tables

DAX Measures

DAX Measures Section
Introduction to DAX Measures
The =Calculate Formula

Relationships

Relationships Section
Creating and Managing Relationships in Power BI
Relationship Calculations

Enhancing Power BI

Enhancing Power BI Section
Basic Transformations - Part 1
Basic Transformations - Part 2
Aggregating Data

Analyze Data with Excel

Setting up Power BI Data to work with Excel
Power BI and Excel Connections
Pinning Excel into Power BI

Conclusion

Conclusion
Useful Resources and Links

Screenshots

Complete Introduction to Microsoft Power BI - Screenshot_01Complete Introduction to Microsoft Power BI - Screenshot_02Complete Introduction to Microsoft Power BI - Screenshot_03Complete Introduction to Microsoft Power BI - Screenshot_04

Our review

--- ## Course Overview & Rating **Global Course Rating:** 4.57 The course has received high praise from recent reviewers, with a focus on its comprehensive introduction to Power BI and its practical applications in data analytics. The majority of users found the course to be informative, well-structured, and suitable for both beginners and those looking to deepen their understanding of Power BI. --- ## Pros - **Comprehensive Introduction:** The course provides a solid foundation for understanding Power BI's capabilities and functions. - **Easy to Understand:** Instructors present the material in an accessible manner, making complex topics easier to grasp. - **Practical Examples:** Real-world scenarios and examples are used to illustrate concepts, enhancing the learning experience. - **Flexible Learning:** The ability to pause, rewind, or replay videos allows students to process information at their own pace. - **Well-Designed Materials:** The course content is well-organized, helping maintain interest and engagement throughout the learning process. - **Knowledgeable Instructors:** Instructors are described as extremely knowledgeable and patient in explaining concepts. - **Useful for Various Levels:** Suitable for beginners all the way to those looking to refine their skills with Power BI. - **Positive Impact on Skill Set & Job Opportunities:** Users reported an improvement in their data analytics capabilities and increased job opportunities. --- ## Cons - **Practical Case Studies:** Some users suggested including more practical case studies towards the end of the course to summarize skills learned. - **Technical Issues:** One review mentioned a glitch in the practical activity, where answers were shown before attempting themself. - **Email Address Requirement:** A few users were unaware that they needed a work or school email address to access certain course materials, which may limit its use for some learners. - **Occasional Hurry:** At times, the course is presented a bit hurriedly, which might require viewers to pause for better comprehension. - **Limited Conectivity with External Databases:** Some users expected more content on connecting Power BI with external databases. --- ### Additional Notes - **Course Accessibility:** The course is accessible with a company email, which was a positive surprise for some users who were initially unsure about this requirement. - **Value for Money:** Users reported that the course offered great value for the money spent and has practical applications in the real world. - **Overall Satisfaction:** The overall sentiment among reviewers is very positive, with many indicating their satisfaction with both the course content and the teaching style. --- ### Recommendations for Improvement - **Include More Case Studies:** Incorporate a few more practical case studies at the end of the course to solidify the learning experience. - **Clear Communication:** Ensure that students are clearly informed about the technical requirements, such as the need for a work or school email address. - **Pacing:** Consider slowing down the pace at certain points to allow for better digestion of information. - **Advanced Topics:** Expand on advanced topics like connectivity with external databases to cater to more experienced users. --- ### User Feedback Highlights **Positive Feedback:** - "It was an amazing course!" - Learner appreciated the comprehensive introduction and practical examples. - "Definitely enables me to provide insightful reports and dashboards." - Learner found the course useful for their professional development. - "Easy to understand, well-designed materials, and knowledgeable instructors." - These aspects contributed to a positive learning experience. **Areas for Improvement:** - "More practical case studies at the end would be beneficial." - Learner suggested adding more real-world applications. - "A heads-up about needing a work or school email address would be helpful." - Learner pointed out a lack of clarity regarding course requirements. - "Some parts were a bit rushed." - Learner recommended a slower pace for better understanding. **Overall Experience:** The course is highly regarded by its users, with many finding it to be an excellent tool for developing data analytics skills and enhancing job prospects in the field of data analytics. The positive reviews indicate that the course meets and exceeds user expectations for learning Power BI.

Charts

Price

Complete Introduction to Microsoft Power BI - Price chart

Rating

Complete Introduction to Microsoft Power BI - Ratings chart

Enrollment distribution

Complete Introduction to Microsoft Power BI - Distribution chart
468172
udemy ID
4/5/2015
course created date
6/10/2019
course indexed date
Bot
course submited by