Power BI | Score Sentiment | Text Analytics | AI Functions | Matrix Chart | Gauge Chart | Video 19
In this video, we will use Power BI Desktop to create a report page.
1. In the Power Query Editor, we will select Summary Column from the UFO Sightings table, then click on Text Analytics, and select Score Sentiment.
2. In Power BI Desktop, we will create a new calculated column (Sentiment Type)
3. We will create 6 measures and use them in a report page that has a custom visual (Play Axis), 3 Gauge charts, Matrix and a Bar Chart.
4. Upon clicking the play button in Play Axis visual, all the values in the visuals will dynamically change.
We will use 1 dataset - UFO Sightings dataset - from the Tidytuesday R Repository
FYI: Periodically we will create additional report pages & add more videos using the same datasets so that we will create a dedicated playlist for all these videos.
Datasets:
https://github.com/rfordatascience/ti...
More datasets @Tidytuesday R
https://github.com/rfordatascience/ti...
TIMESTAMPS
00:00 Intro to Text Analytics(AI Functions)
00:31 Score Sentiment
01:38 Remove blanks and change data type to decimal
02:04 Create a new column Sentiment Type
03:54 Create 6 Measures
05:13 Using Model View Create folders and Sub-Folders
09:01 Create a Report Page
09:05 Downloaad Custom Visual (Play Axis)
09:40 Create a Matrix Visual
09:55 Create 3 Gauge Charts
10:07 Create a Bar Chart
10:40 Recap and Conclusion
Watch video Power BI | Score Sentiment | Text Analytics | AI Functions | Matrix Chart | Gauge Chart | Video 19 online without registration, duration hours minute second in high quality. This video was added by user Linknet Analytics 19 November 2024, don't forget to share it with your friends and acquaintances, it has been viewed on our site 48 once and liked it 0 people.