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
Смотрите видео Power BI | Score Sentiment | Text Analytics | AI Functions | Matrix Chart | Gauge Chart | Video 19 онлайн без регистрации, длительностью часов минут секунд в хорошем качестве. Это видео добавил пользователь Linknet Analytics 19 Ноябрь 2024, не забудьте поделиться им ссылкой с друзьями и знакомыми, на нашем сайте его посмотрели 48 раз и оно понравилось 0 людям.