Advanced Power BI Custom Visuals with d3.js
3h 38mAdvanced2021-05-06
Authors
Emma Saunders
Data Consultant specializing in data visualization on the web
Course details
Power BI is rapidly becoming one of the most popular reporting and visualization tools and is a great way for non-technical users to build their own reports and data visualizations. However, Power BI comes with a rather limited set of standard visuals, and creating custom visuals can be a daunting process, one that requires JavaScript or TypeScript programmers. In this course, Emma Saunders shows programmers who are experienced at creating data visualizations on the web how to create custom visuals in Power BI. Emma starts with the basics of setting up your environment and installing the multitude of requisite files, then shows how to set up an account to access Power BI service. She explains the folder structure for the over 5,000 files you need for a single custom visual, before diving into the creation of custom visuals using single, categorical, and grouped data aggregation.
Skills covered
Power BIBusiness AnalyticsBusiness IntelligenceAdvancedFront-End Web DevelopmentData AnalysisWeb DevelopmentData ScienceBusiness Analysis and StrategyBusiness Software and ToolsMicrosoft
Concepts
0. Introduction
- 01 - Intro to Microsoft Power BI
- 02 - Who this course is for
- 03 - What is Power BI
- 04 - What is a custom visual
1. Set Up Your Environment
- 05 - Understand the target set up
- 06 - Licensing, software, and version requirements
- 07 - Create your first (demo) custom visual
2. Understand the File Setup
- 08 - Understand the folder structure of your new project
- 09 - Understand key files and Identify the ones to change
3. Build a KPI Box Visual Using Single Data
- 10 - See the target visual, data, and formatting
- 11 - Edit capabilities.json and inspect the resulting data
- 12 - Edit visual.ts to display a KPI value in Power BI
- 13 - Edit visual.ts to access the user's formatting choices
- 14 - Add a responsive SVG using D3
- 15 - Add rectangles and text to your KPI visual
- 16 - Use formatting utils API to set text size dynamically
- 17 - Use font size and fill color from the formatting pane
- 18 - Challenge - Add fill opacity to the formatting pane
- 19 - Solution - Add fill opacity to the formatting pane
- 20 - Challenge - Change the font color the KPI and label
- 21 - Solution - Change the font color the KPI and label
- 22 - Challenge - Place label at top or bottom
- 23 - Solution - Place label at top or bottom
4. Build a Scatter Chart Using Categorical Data
- 24 - Tell Power BI to accept categorical data
- 25 - Create D3 linear scales and axes in your custom visual
- 26 - Add some dots to make a scatterplot
- 27 - Add some dots to make a scatterplot
- 28 - Challenge - Make the dots responsive
- 29 - Solution - Make the dots responsive
5. Convert to a Bubble Chart with Group by Data
- 30 - Grouping your data to help make a bubble chart
- 31 - Create grouped scatter plot data, to allow different colors per category
- 32 - Update your D3 code to reflect your new grouped data
- 33 - Add a size dimension to create a bubble chart
- 34 - Distributing your visual
- 35 - Challenge - Change the hard coding of colors into dynamic coloring based on an array
- 36 - Solution - Change the hard coding of colors into dynamic coloring based on an array
Conclusion
- 37 - Goodbye