Power BI Quick Start – Create a PBI Dashboard in 90 Minutes
Power BI Quick Start – Create a PBI Dashboard in 90 Minutes, available at Free, has an average rating of 4.54, with 19 lectures, based on 544 reviews, and has 12460 subscribers.
You will learn about Learn my 5 step process to building an Effective Dashboard and why each step is vital. How to create a new Power BI report and import data from Excel. What calculated columns are and how to add them to your data model. What a measure is and how to add it to your data model. Create basic DAX expressions using IF(), SWITCH(), COUNTROWS() and SUMX() Importing a theme to format fonts and colours in Power BI. My recommended report setting. How best to configure the Power BI report options. How to add and configure card visuals. How to add and configure an on-screen filter (slicer) to your report. Set-up a bar graph visual. Set-up a calculated column that segments work orders into days old groupings. Add and configure a matrix visualisation with column and row categories. Add a drillthrough from the home page charts and matrix to a work order details screen. View the detailed transactions that are behind the numbers. How to publish your dashboard to the Power BI Service. This is the starting point to sharing your dashboard with the world. This course is ideal for individuals who are Anyone who wants to learn how to use Power BI to create dashboards to visualise and analyse their data and KPIs. It is particularly useful for Anyone who wants to learn how to use Power BI to create dashboards to visualise and analyse their data and KPIs.
Enroll now: Power BI Quick Start – Create a PBI Dashboard in 90 Minutes
Summary
Title: Power BI Quick Start – Create a PBI Dashboard in 90 Minutes
Price: Free
Average Rating: 4.54
Number of Lectures: 19
Number of Published Lectures: 19
Number of Curriculum Items: 19
Number of Published Curriculum Objects: 19
Original Price: Free
Quality Status: approved
Status: Live
What You Will Learn
- Learn my 5 step process to building an Effective Dashboard and why each step is vital.
- How to create a new Power BI report and import data from Excel.
- What calculated columns are and how to add them to your data model.
- What a measure is and how to add it to your data model.
- Create basic DAX expressions using IF(), SWITCH(), COUNTROWS() and SUMX()
- Importing a theme to format fonts and colours in Power BI.
- My recommended report setting. How best to configure the Power BI report options.
- How to add and configure card visuals.
- How to add and configure an on-screen filter (slicer) to your report.
- Set-up a bar graph visual.
- Set-up a calculated column that segments work orders into days old groupings.
- Add and configure a matrix visualisation with column and row categories.
- Add a drillthrough from the home page charts and matrix to a work order details screen. View the detailed transactions that are behind the numbers.
- How to publish your dashboard to the Power BI Service. This is the starting point to sharing your dashboard with the world.
Who Should Attend
- Anyone who wants to learn how to use Power BI to create dashboards to visualise and analyse their data and KPIs.
Target Audiences
- Anyone who wants to learn how to use Power BI to create dashboards to visualise and analyse their data and KPIs.
Power BI is the fastest-growing data analytics tool on the market. Demand for skills in Power BI is rocketing. Most major organisations are now using it as part of their standard desktop toolkit.
This course is for you if you are pushed for time and want to quickly learn how to create a new dashboard and understand the key features and capability of Power BI.
The good news is that it’s very easy to quickly learn how to start creating effective dashboards.
After completing this short, practical, hands-on courseyou’ll have the knowledge you need to take advantage of Power BI’s capability to create your first dashboard in your organisation or role.
—————————————-
Project Scenario Overview:
—————————————-
For this course, you will play the role of a business analyst who has been tasked with creating a report to analyse the overdue maintenance activities at an oil production facility.
The course takes you step-by-step through the end-to-end process of defining, building and deploying a professional and effective dashboard. The dashboard will allow managers to analyse the company’s overdue maintenance activities and drill into the detailed transactions that make up the overdue work.
I’ll provide you with everything you need to guide you through the process of building the solution and configuring the dashboard, including my key hints and tips for successand how to make the dashboard user-friendly and easy to read (you can learn from my mistakes!).
————————–
Course Overview:
————————–
The course has 4 key learning objectives:
Objective #1: Learn the 5 Step Process for Building an Effective Dashboard
-
My 5 step process provides you with a clear structure to follow when creating a new dashboard. (Note: It’s not just about Power BI)
————————–
Objective #2: Import Data using Power Query
-
Understand how to load data into your Power BI data model.
————————–
Objective #3: Building a Data Analysis Dashboard in Power BI
-
Learn the difference between a calculated column and a measure.
-
Add a new column to your data model based on the IF() function.
-
Create some basic measures using the SUMX() and COUNTROWS() DAX functions.
-
Import a theme to your dashboard – including my best practice recommendation for selecting a colour scheme.
-
Add and configure Card, Bar Chart, Matrixand Tablevisuals.
-
Create an on-screen filter using the Slicer visualisation.
————————–
Objective #4: Publishing the Dashboard to the Power BI Service
-
Share your dashboard through the Web with the Power BI Service.
————————–
By the end of this short project, you’ll understand how to get started with Power BI and will have the skills and knowledge to build your own basic dashboards with confidence.
Note this course is not designed to be a compreshensive Power BI course. It’s a quick start course built to provide you with a solid foundation in key features of Power BI. From here you’ll be in a great position to accelerate your Power BI skills development.
Power BI is currently a highly desirable skill set. It allows you to easily create beautiful dashboards, track KPIs and gain insights into your data, then share these with the world!
Remember, this quick start course is for anyone looking to get started with Power BI. If you are a budding data analyst, an IT professional, a department manager or just someone who wants to add to Power BI to their skillset and CV, this course is for you.
————————–
Sign up today and in under 90 minutes, you’ll be up and running with Power BI.
Included in the course package you’ll get:
-
Downloadable presentation of my 5 Step Process to Building an Effective Dashboard.
-
All the files and resources you need to complete your first dashboard project.
-
Q&A Forum.
-
Final Power BI project file.
Talk to you in the course! – Jason (Founder of Effective Dashboards)
Course Curriculum
Chapter 1: The 5 Step Effective Dashboard Building Process
Lecture 1: Introduction
Lecture 2: The 5 Step Effective Dashboard Building Process
Chapter 2: Importing Data
Lecture 1: Importing Data and Carrying out Basic Transformations
Chapter 3: Building Your Dashboard
Lecture 1: Adding Calculated Columns containing DAX IF() and SWITCH() statements
Lecture 2: Adding Measures containing DAX SUM(), COUNTROWS(), SUMX() Functions
Lecture 3: Best Practice Page Layout, Adding and Customising Cards and Importing a Theme
Lecture 4: Adding Cards and Applying Visual Level Filters
Lecture 5: Adding a Slicer, Sorting One Field By Another and Dealing with (Blank) Values
Lecture 6: Add and Format Column Chart Visuals
Lecture 7: Add Matrix Visual and Heat Map Conditional Formatting
Chapter 4: Adding Interaction To Your Dashboard
Lecture 1: How to Control Cross Filtering of Visuals Using Edit Interactions
Lecture 2: Creating and Configuring a Drillthrough Report
Lecture 3: Adding Colour Conditional Formatting Using a DAX Measure
Lecture 4: Adding a Help Popup Tooltip to a Visualisation
Lecture 5: Creating a Bookmark for Drilling Through to Total Backlog
Lecture 6: Adding a Pop-up Tooltip with Additional Information
Chapter 5: Publishing the Dashboard to the Power BI Service
Lecture 1: Publishing Your Dashboard to the Power BI Service
Lecture 2: Final Overview of Dashboard Functionality
Lecture 3: Copy of Final Power BI Dashboard File
Instructors
-
Jason Davidson
Power BI expert, specialising in maintenance & reliability
Rating Distribution
- 1 stars: 7 votes
- 2 stars: 9 votes
- 3 stars: 54 votes
- 4 stars: 187 votes
- 5 stars: 287 votes
Frequently Asked Questions
How long do I have access to the course materials?
You can view and review the lecture materials indefinitely, like an on-demand channel.
Can I take my courses with me wherever I go?
Definitely! If you have an internet connection, courses on Udemy are available on any device at any time. If you don’t have an internet connection, some instructors also let their students download course lectures. That’s up to the instructor though, so make sure you get on their good side!
You may also like
- Top 10 Video Editing Courses to Learn in November 2024
- Top 10 Music Production Courses to Learn in November 2024
- Top 10 Animation Courses to Learn in November 2024
- Top 10 Digital Illustration Courses to Learn in November 2024
- Top 10 Renewable Energy Courses to Learn in November 2024
- Top 10 Sustainable Living Courses to Learn in November 2024
- Top 10 Ethical AI Courses to Learn in November 2024
- Top 10 Cybersecurity Fundamentals Courses to Learn in November 2024
- Top 10 Smart Home Technology Courses to Learn in November 2024
- Top 10 Holistic Health Courses to Learn in November 2024
- Top 10 Nutrition And Diet Planning Courses to Learn in November 2024
- Top 10 Yoga Instruction Courses to Learn in November 2024
- Top 10 Stress Management Courses to Learn in November 2024
- Top 10 Mindfulness Meditation Courses to Learn in November 2024
- Top 10 Life Coaching Courses to Learn in November 2024
- Top 10 Career Development Courses to Learn in November 2024
- Top 10 Relationship Building Courses to Learn in November 2024
- Top 10 Parenting Skills Courses to Learn in November 2024
- Top 10 Home Improvement Courses to Learn in November 2024
- Top 10 Gardening Courses to Learn in November 2024