Professional Power BI: Data Visualization and Dashboards

alyze data and extract actionable insights by building interactive dashboards in PowerBI

3.50 (76 reviews)
Udemy
platform
English
language
Data & Analytics
category
424
students
10 hours
content
Jan 2022
last update
$49.99
regular price

What you will learn

Understand the importance of Data Modeling for optimization and performance.

Create powerful calculations and analytics with DAX.

Create dashboards and real-time reports to share with business users on the web and on mobile.

Integrate Power BI with other tools, including Microsoft Excel to connect your Excel workbooks.

Load, process, and clean data to make an engaging data analysis.

Work with Power Query, DAX, and standard Power BI visualizations to create insightful and actionable reports in Power BI.

Publish your dashboard to the web to have powerful, tile-based, data fusion, and tailor-made data for the effective executive

Get introduced to a narrative-oriented custom visual, Power BI's navigation capabilities, and a powerful storytelling feature

Description

Video Learning Path Overview

A Learning Path is a specially tailored course that brings together two or more different topics that lead you to achieve an end goal. Much thought goes into the selection of the assets for a Learning Path, and this is done through a complete understanding of the requirements to achieve a goal.

Are you wasting time on compiling data from multiple sources instead of analyzing data? If yes, then this course will be your perfect guide and companion to analyze any data with ease!

Tell your data story with Power BI and reach millions of users with a single click on any kind of a device! Using Power BI, you can combine your data sources, create stunning visualizations, and embed your story on your website within seconds saving your cost and time.

In this well thought out step-by-step Learning Path, you'll go from beginner to confident Microsoft PowerBI user with a series of practical sections to help you build out an interactive - functional report and a detailed, insightful dashboard with compelling visualizations to analyze your data more effectively and publish them on PowerBI. You'll take the role of a business analyst and create factful and engaging reports with actionable insights!

By the end of the course, you’ll be able to use Power BI effectively as a business analytics tool to load, pre-process, and model data and create meaningful reports, visualizations, and interactive dashboards.

Key Features

  • Use Power BI to gather data, create reports, and get into action within a few minutes.

  • Hands-on approach showing you how to create the metrics necessary for data stories.

  • Generate interesting interactive visualizations based on your data.

Author Bios

  • Reid Havens is the Founder of Havens Consulting Inc. and a Microsoft MVP. He has a formal background in technology and organizational management, having obtained separate Master's Degrees in Organizational Development & Business Analytics. Additionally, he guest lectures at the University of Washington and other universities, teaching Business Intelligence, Reporting, & Data Visualization. Reid is also currently developing multiple online video series on Learning & Mastering Power BI for Packt Publishing.

  • Murli Rajpurohit is a data scientist with over a year of experience in the business intelligence domain and passionate about machine learning, data science, and artificial intelligence. He focuses on combining the best elements of storytelling with Power BI’s interactive capabilities to engage audiences in a new way. His interest lies in learning every aspect of computer vision. He has expert knowledge and hands-on experience of both quantitative and qualitative analysis, data mining, optimization, and database operations, and is proficient in R, SQL, and Python.

  • Nikita Barsukov is a software developer and data scientist with 10 years' experience in the industry. He went through a traditional data science path at the beginning of his career—for example, learning R and machine learning algorithms using online courses. Then he also quickly grasped the value of visual data storytelling, using charts as a way to communicate and tell something. He lives in Copenhagen, Denmark with his beautiful wife and three awesome sons.

  • Peter MacMurchy has been a professional software developer for over 15 years, focusing on UX, UI, and interactive data visualization tools. He acquired a keen interest in information visualization from coursework while studying Computer Graphics for his M.Sc. in Computer Science at the University of Calgary. Since then, he's continued to develop visualization and interactive software for finance, film, energy, and other industries. At Uncharted, Peter helps clients improve their data visualization capabilities on a consulting basis.

Content

Learning Microsoft Power BI

The Course Overview
What Is the Flow of Report Development for a Business Analyst?
Reviewing Project Requirements and Determining Data Sources
Connecting to (Almost) Any Data Source with Power Query
Importing Data and Power Query Fundamentals
Connecting to a Folder as a Data Source
Table Types and Relational Data Modeling
Common Data Transformations with Power Query
Intelligent Data Filtering with Power Query
Adding New Columns with Power Query
Merging Tables with Power Query
Creating Table Relationships in Power BI
Understanding the Data View in Power BI
Column Settings and Hierarchies In Power BI
Translating Report Requirements into DAX Measures
Report View Walkthrough
DAX Concepts and Fundamentals
Creating Basic DAX Measures
Creating a DAX Measures Table
Referencing DAX Measures
Visual Cues and Chart Types
Creating Visualizations – Matrix Table
Creating Visualizations – Running Total Chart
Creating Visualizations – Column and Line Chart (Year-Over-Year Profits %)
Creating Visualizations – Conditional Formatting and Waterfall Charts
Creating Visualizations – Card Visualizations and Title Section
Slicers and Filter Settings
Formatting and Report Design
Publishing a Report to the Power BI Service
Creating an App Workspace
Creating a Dashboard
Setting Up Scheduled Refreshes
Learning Microsoft Power BI: Course Completed
Test your knowledge

Hands-On Data Visualization with Microsoft Power BI

The Course Overview
Basic Concepts of Business Intelligence
Installing Power BI
Connecting to Different Data Sources
Basic Data Transformations
Splitting Columns and Changing Data Types
Conditional Columns and Merge Queries
Creating Calculated Columns
Manage Your Data Relationships
Introducing Various Visuals
Communicating with Charts – Part 1
Communicating with Charts – Part 2
R Language Plotting Basics
R Visual Integration
Page Layout and Formatting
Introduction to Power BI Service
Uploading Reports to Power BI Service and Quick Insights
Natural Language Querying
Alerts and Notifications in Power BI Service
Personal Gateway
Using Excel Data in Power BI
Connecting to Excel Workbook on OneDrive for Business
Pinning Excel Tables or Visuals
Introduction to Content Pack, Security, and Groups
Creating a Group
Creating, Using, and Editing Content Pack
Row-Level Security (RLS)
Integrate and Share OneDrive for Business with Power BI
Introduction to Power BI Mobile
Mobile Dashboard Layout
Sharing and Annotating in Power BI Mobile
Using Custom Charts from Marketplace
Test your knowledge

Getting Actionable Insights from Power BI

The Course Overview
Introducing a Company – What It Does, Where It Operates
Exploring Sales Data
Loading and Transforming Data in Power BI
Simplifications in the Dataset
Defining Requirements, Metrics, and Charts
Build Charts in Power BI
Analyzing Sales over Time Series in Power BI
Using Charts to Finalize Sales over Time Report
Looking Closer at DAX Measures
Requirements, Metrics, and Charts
Creating DAX Metrics for Comparison
Use of Power BI Tables
Using Line Charts
Visualize Ranking in Power BI
Requirements and Metrics
DAX Measure for Deviation from Average
Visualizing Deviation from Average
Understanding the Requirements and Metrics
Installing Dependencies, Preparing Data, and Making a Correlation Matrix
Test your knowledge

Building Interactive Dashboards with Microsoft Power BI

The Course Overview
The Visualization Palette, Reports, and Dashboards
Link Them Up – Enabling Visual Interactions
Key to Performance – Calculating Your KPIs
Helpful Hints – Adding Tooltips and Legends
Introducing the Analytical Dashboard Example
Time Matters – Time Series Chart
Some Like It Hot – Heat Map Charts
What-if – Using Parameters and Slicers to Filter and Explore
Detail Oriented – Exporting Data from Visuals
Introducing the Tactical Dashboard Example
Point of Reference – Creating a Dot Plot
Statistics Never Lie – Box and Whisker Plots
Big Spenders – Building a Funnel Chart
Where It Is – Geographical Map Charts
Introducing the Strategic Dashboard Example
Are We There Yet? – Calculating Period-over-Period Changes
On Target – Visualizing Comparisons with Bullet Charts
Mash It Up – Pinning Visuals to Dashboards
Make It Pop – Adding Media Tiles to a Dashboard
Introducing the Data Stories Dashboard Example
Meet the Players – Presenting Data with the Card Browser Custom Visual
Space Travel – Linking Together Dashboards with Actions
Time Travel – Telling a Story with Bookmarks
Click for More – Embedded Links and Hyperlink Dashboard Tiles
Formatting Concepts and Best Practices
Formatting Visuals and Reports
Creating Relevant Labels and Effective Number Formats
Formatting Dashboards
Course Conclusion
Test your knowledge

Screenshots

Professional Power BI: Data Visualization and Dashboards - Screenshot_01Professional Power BI: Data Visualization and Dashboards - Screenshot_02Professional Power BI: Data Visualization and Dashboards - Screenshot_03Professional Power BI: Data Visualization and Dashboards - Screenshot_04

Reviews

Robin
July 5, 2023
no logic, differnt instructors, repeative sections, poor sound on some. it appears they just add a new section every few months with bascially the same topics and it is outdated of course - appears to use a version from 2021.
Baranyai
April 23, 2022
The first section was very good and professional. The second part is unfortunately more ad-hoc and demonstrative, a long demo and less educational. Unfortunately, there are quite a few repetitions between instructor lessons. Recommended for very patient students.
Junior
March 20, 2021
The more I am advancing in the learning the much appetite to want to practice and master this amazing knowledge
Chantal
May 14, 2020
some of the content is duplicated in each section, so there is room to reduce the number of lecture hours by removing duplicate content. Overall very good
Francesco
May 3, 2020
The first part of the course was simply OUTSTANDING. Probably the best online course I have ever seen. Very well structured, great usage of materials and very clear expectations of what to learn on every single video. Parts 2 and 3 absolutely under the expectations, basics are repetitive but in an approximative way compared to Part 1. Few interesting elements from these. Part 4 is on average good, it gives some more specific ideas.

Charts

Price

Professional Power BI: Data Visualization and Dashboards - Price chart

Rating

Professional Power BI: Data Visualization and Dashboards - Ratings chart

Enrollment distribution

Professional Power BI: Data Visualization and Dashboards - Distribution chart
2285343
udemy ID
3/22/2019
course created date
5/19/2022
course indexed date
Bot
course submited by