Professional Power BI: Data Visualization and Dashboards
- 10 hours on-demand video
- 1 downloadable resource
- Full lifetime access
- Access on mobile and TV
- Certificate of Completion
Get your team access to 4,000+ top Udemy courses anytime, anywhere.Try Udemy for Business
- 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
- Taking up this Course doesn't need you to be an expert with Microsoft Power BI. A Data Analyst, Business Analyst or a Digital Marketing Analyst who already know the fundamentals of working with data, who is able to load data from an Excel file on a laptop and add a simple bar chart, will feel perfectly comfortable in understanding the topics presented in this Course.
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.
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.
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.
- BI professionals, Data Professionals, BI Consultants, Data Analysts, Business Analysts, and Digital Marketing Analysts, Developers, Engineers, who want to gain insights from their business data using Microsoft Power BI as well as create interactive dashboards and more. It’s also ideal for Professionals who want to create customized visuals with the Power BI Developer tools.
In this video, we will learn about the flow of the report development process.
Connect to your various data sources
Fix the different errors and inconsistencies in your data using Power Query
If your data is already clean, you can simply use it as a data connector
In this video, we are going to review project requirements and determine data sources.
Learn how to take a given set of requirements
Understand what finalizing the requirements by multiple refinement and review iterations means
Interpret the refined requirements into action items like visualizations, tables, and filters
In this video, we will learn some crucial concepts about data modeling and table types in data models.
Understand why we did not import a single table
Understand the advantages of using multiple tables in our data models
Identify and eliminate duplication on your single table to convert it into a multi-table model
In this video, we will cover the three most common transformations you will apply to any table.
Open up the query editor to look at the seven queries that can be edited
Apply the different steps to the DIMProduct table
Rinse and repeat the transformation practices to the remaining tables
In this video, we will learn more about relationships and how to create them in the data model.
Further understand why key columns are important for relationships
Create relationships between the data and lookup tables
Learn how to organize the relationship view visually by separating data and lookup tables
In this video, we will learn how to identify column attributes and change relevant settings for reporting.
Understand the important differences between column data type and formatting
Learn how to hide key columns from the report view in the data model
Learn how to delete unused columns from the data model
In this video, we will learn how to translate project requirements into calculations needed for a data model.
Learn how to break down project requirements into the needed DAX measures
Understand the types of basic DAX measures that be can be calculated
Learn about time intelligence calculations in DAX
In this video, we will learn about the design, form, and function of the report view.
Learn about the characteristics of Power BI, compared to other tools
Learn about the various sections of the report layout
Learn about the visualizations pane, and how to create a visualization
In this video, we will learn important fundamentals of DAX, including what it is and what it’s used for.
Understand that DAX exists in multiple tools, not just Power BI
Learn how DAX formulas work compared to Excel formulas
Understand how filters play an important role in the functionality of DAX
We will learn visual cues, chart type selection, and how to tell a story with data.
Understand how visual cues influence how we perceive data
Learn to pick the right visualization based on visual cues
Learn about the Visuals Reference guide and how to use it to pick the right visualization
In this video, we will learn how to create a running total chart and supporting DAX measure.
Create a running total measure using the DAX quick measures tool
Create a calendar table and learn why it is important in a data model
Create a chart using the newly created DAX measure and calendar table
In this video, we will learn how to create a line and column combo chart and supporting DAX measures.
Learn about the DAX CALCULATE function and how it incorporates filters inside the measure
Understand the ways in which filters can be added, removed, or modified with CALCULATE
Create the line and column combo chart in Power BI, and use the hierarchy controls with date data types
In this video, learn how to apply conditional formatting to tables, and create a waterfall chart.
Learn the three ways to apply conditional formatting to tables
Understand how conditional formatting works when using the hierarchy controls
Understand the benefits of using waterfall charts when displaying data that can have positive and negative values
In this video, we will explore the top title section of the report and see what types of information should be displayed there.
Add a title and image to the report
Understand what types of information should be displayed on card visuals
Create multiple card visualizations with DAX measures
In this video, we will learn about the Power BI Service and how to publish reports.
Understand the components of the Power BI Service and how they tie together
Publish the completed report to the Power BI Service
Learn how the report looks and functions when accessed from PowerBI.com
In this video, we will learn about app workspaces, what they are for, and how to create one. Refer to this link: https://powerbi.microsoft.com/en-us/blog/enable-your-team-with-new-workspaces-experiences-preview/
Understand the important differences between publishing to my workspace versus a shared workspace
Learn the types of objects that can be published to an app workspace
Create and set up an app workspace in the Power BI Service
In this video, we will learn about dashboards, what they are for, and how they’re different from reports.
Understand the important differences between a report and a dashboard
Create a new dashboard by adding visualizations from the published report
Learn how to interact with and configure the dashboard
Most working professionals don’t know what BI is and how it can help them. They can then understand the business better and take some decisions with help of insights from the data.
Learn some basic concepts of BI
Learn how BI works
Understand where Power BI comes in the big picture of business intelligence
Data transformation is very important step for data cleaning, without data transformation analyzing data will become very difficult and hence outcome will not be accurate.
Understand how to navigate to Query Editor in Power BI
Learn about the Applied Steps that keeps track of all the changes made to the data
Analyze different transformations that can be done to the data like duplicating column, removing empty rows etc
Due to sampling of data, Power BI doesn’t always get it right when it comes to data type. So it is important to change data type.
Understand how to split the columns with Delimiter
Know how to split columns with Fixed number of characters
Change data type of a particular column
It is important to learn merging queries similar to joins in SQL to perform operation on different datasets simultaneously.
Understand how create a new column based on conditions
Learn how to merge two different queries together
Explore conditional column and merge queries
It is impossible to do calculation on things across multiple tables without creating a relationship between tables.
Understand how to create a relationship between tables
See how to hide a table in the report view
Discover another way of creating & managing the relationships
It is difficult to know when and which chart to be used. Knowing importance of a particular visual is important.
Learn different ways of creating a chart in Power BI
See how to create bar chart, Pie chart in Power BI
Understand how to create Tree map and how to convert one visual into other
It is important to know components of Power BI Service before jumping straight to Service functionality.
Learn how to sign up for Power BI Service
Explore the difference between reports, dashboard and datasets
Attach different tiles from different reports onto a single dashboard
It is very important to upload Report onto Power BI service and getting quick insights with just one click makes it very easy to get insights from data.
Learn how to publish report on to Power BI Service
Understand how to get quick insights from the data
Look at pinning insight visual onto dashboard
It is important to know who commented or added a Dashboard or when a particular metric exceeds a threshold.
See how to read notifications in Power BI Service
Learn how to set an alert for a particular tile
Understand how to check status of Alert directly through email
You have tables and charts in Excel Workbook and you want to pin directly to Power BI. But it could be difficult to draw a chart again in Power BI. So instead, using Add-in, you can directly pin charts from Excel into Power BI.
See how to pin a table into Power BI Service
Look at how to update the tile when the data changes
Learn how to pin a chart from Excel Workbook directly to Power BI Service
If you are working in an organization and you don’t have any private data to work on, you can pick a content pack directly from the organization if it’s available and start working on it.
Learn how to create a content pack
Understand how to use a content pack from the organization
See how to edit the content pack that was shared with the organization
It is important to give a particular set of access to particular people so that they can see only the data that is necessary for them.
Learn how to use the manage roles tab in Power BI Desktop to create roles
Understand how to use DAX to create a particular role for particular data
Add users to particular roles created by us
If a file is available on OneDrive for Business, you can directly share and collaborate with Office 365 groups from there itself. And if any changes are made to the data, they will directly reflect or update in Power BI also.
Understand how to use version history to track changes made to the file
Learn how to import files directly from OneDrive for Business into Power BI
Before seeing a dashboard in a mobile device, we can look at it in the Power BI Service itself in phone view to see how it will look on the phone. So we can adjust it in advance.
Understand how to get the phone view in the Power BI service
See how to remove a tile from the dashboard
Learn how to resize and move tiles in a dashboard
You are working in an organization and you will have to share and collaborate on reports and dashboard. Using Power BI Mobile, you can share from your mobile itself. No need to log in to laptop or PC!
Learn how to share a report and dashboard with a colleague
See how to add a comment to the dashboard or a report
What should we calculate and how should we plot metrics to explore sales over time and evaluate the success of a product launch?
Explore the context
Use bar chart with Power BI hierarchy for sales chart
Use column and 100% stacked column to get share of sales of a product/shop
How can we add DAX measures that calculate rolling 28 days sales and month-over-month change of sales?
Look at filter functions allowing us to modify evaluation context accordingly
Add 28-days rolling sales
Add month-over-month change of rolling 28 days sales measure
What should we calculate and how should we plot metrics to visualize deviation from average?
Identify that existing sales measures are not optimal for current task
Determine that profit, not sales, is better metrics for performance
Define that profit margin will allow us correctly compare difference from average
How to add DAX measure that will allow us to calculate difference between shop profit margin and overall company profit margin?
Add new data column Profit and convert it to Euro
Add DAX measures that calculate overall profit and profit by shop
Add a DAX measure showing profit margin difference from company average
What extra dependencies should we install and how to process the data to visualize correlation?
Install dependencies: R language: https://cran.r-project.org/bin/windows/base/ Download corplot visual: https://store.office.com/addinsinstallpage.aspx?rs=en-US&assetid=WA104380814
Transform dataset Power Query
Add correlation plot
This video will give you an overview about the course.
Introduce the author
Describe the course workflow
This video will help us understand what tools analysts can use to compare hot spots, over time and geography.
Introduce the heat streams and heat map visuals
Introduce the marketplace and create a heat streams visual
Create a heat map visual to find geographic hot spots
How can analysts slice and dice their data? How do what-if questions work in BI? In this video, you will learn about slicers and parameters to filter.
Build three slicers
Create a parameter and associated parameterized metric
Create a what-if tax scenario using the parameter
How can we calculate and visualize period-over-period changes in Power BI?
Introduce period-over-period concepts
Use merge queries, a calculated column, and quick measures to calculate period-over-period changes
Visualize period-over-period changes in KPI and clustered column chart visuals