Oracle Database directions | Autonomous Database Data Studio demo
- November 8, 2023
- Posted by: MainInstructor
- Category: Oracle Database SQL
![](https://i0.wp.com/allprowebdesigns.com/wp-content/uploads/2023/11/1699417462_maxresdefault.jpg?resize=840%2C430&ssl=1)
Video Title: Oracle Database directions | Autonomous Database Data Studio demo
Here we are every autonomous data warehouse includes a built-in data Studio to streamline the workflow from data load all the way through to analysis there’s nothing more to buy install or maintain so here’s the data studio interface and if I look in my autonomous data
Catalog I’ll see all of the files I have available to me in my autonomous database I want to perform an analysis of movie sales by customer genre and customer value and here I have data for movies customers Time movie titles what I don’t have is data about movie genres but as a data
Lakehouse autonomous datab autonomous database provides access easily to data distributed across a multicloud data Lake I’ve got data in Google Cloud platform object storage in oci in Amazon S3 and in Azure blob storage so I’ve got an awful lot of files distributed across this multicloud data L but it’s easy for
Me to find what I’m looking for I simply search in this case for genre and here’s the file I’m looking for in a bucket in Amazon S3 very good so using data Studio’s data load tool I need to create a link to this file so that I can treat it as if
Its data local to me in my autonomous database even though physically the data remains in S3 great so now I have that file indeed I have all the data I need what remains means now is to transform that data and it’s very easy to do this using the built-in transforms tool I’ve already
Begun work on a data flow to do this data transform so I have um the fact table I want to build here is called customer sales analysis and starting with the individual movie sales I can aggregate by customer and group these into bins by customer value now I need
To join in this genre data that we just found in S3 so I complete this join by hooking this table up to the join and connecting the output to the fact table customer sales analysis so I’ll save and execute this data flow to populate that fact table
Great so now let’s do some data analysis in other words I want to take an analytic view of my data and it so happens that we have a structure in the Oracle database called an analytic view let’s build one here and we’re going to base this on the fact table that we’ve
Just created customer sales analysis I want to measure total sales by various Dimensions or hierarchies let’s use age group customer value and movie genre that we just added okay so we’ll build this analytic View and now it’s time to look at our data here we see a little pivot table
Showing us data analysis of movie consumption by various age groups now if I look at this graphically we see quite a range of um distribution of movie cons consumption across these AG ranges but the analysis I want to perform is based on customer value and on movie genre and here we see
In the lowest sector of customers a strong preference this big bar here for action movies whereas if I slide over here to the right hand side the highest value customers the high rollers have a strong preference for drama very interesting very in ightful sort of information that we can build a
Campaign for this particular Market segment now the great thing about analytic views is that this information can be can be consumed natively um in Oracle aace or Oracle analytics um it can also be exported to Tableau or powerbi or indeed viewed in Excel or Google Sheets through various addins
Let’s have a look at the very same information in Google Sheets and here we have that same analysis of movie consumption by age groups and here movie consumption by customer value and movie genre so this ability to reuse the analytic view in multiple different client tools provides Great
Value and greatly adds to the productivity so to recap what we’ve seen today um I browsed my mother multic cloud data Lake I located the data that I needed in a bucket in S3 I loaded it U by creating a link to that file I transformed the data for analysis we
Built a business model that we could preview in the data analysis tool or indeed consume in any one of the tools we see article analytics sbas powerbi Tableau or a spreadsheet interface so back to you Andy much Patrick thank [Applause] you
Video Keywords: Oracle Database, oracle,oracle cloud,oracle cloud infrastructure,oracle software,oracle hardware,exadata,autonomous database,cloud applications,oracle industry applications,oracle netsuite,oracle supply chain and manufacturing,data cloud,tech products,Oracle Database,Oracle,Database,Autonomous Database,DBA,Database Administrator,SQL,Oracle Cloud,Cloud,Tech,Technology,42396940
-
Sale!
Wireless WIFI Repeater Extender Amplifier Booster 300Mbps
$29.99$14.99 Add to cartWireless WIFI Repeater Extender Amplifier Booster 300Mbps
Categories: Electronics, Wi-Fi Router, Wireless Wi-Fi Extender Tags: 300Mbps, 802.11N, Amplifier, Booster, Extender, mobile wi-fi booster, Remote, WIFI, Wireless, Wireless WIFI, Wireless WIFI Repeater, Wireless WIFI Repeater Extender, Wireless WIFI Repeater Extender Amplifier, Wireless WIFI Repeater Extender Amplifier Booster, Wireless WIFI Repeater Extender Amplifier Booster 300Mbps$29.99$14.99 -
Sale!
Full RGB Light Design Gaming Headset Headphones with Mic
$24.99$14.99 Add to cartFull RGB Light Design Gaming Headset Headphones with Mic
Categories: Electronics, Gaming, Gaming Headsets Tags: Design, Full, Full RGB Light Design Gaming Headset, Full RGB Light Design Gaming Headset Headphones, Full RGB Light Design Gaming Headset Headphones with Mic, Gamer, Gaming, Gaming Headset Headphones, gaming headset wireless, Headphone, Headphones, Headset, Light, Mic, Package, RGB$24.99$14.99 -
Sale!
Wireless BlueTooth Multi-Device Keyboard Mouse Combo
$39.99$19.99 Add to cartWireless BlueTooth Multi-Device Keyboard Mouse Combo
Categories: Electronics, Gaming, Gaming Keyboards, Keyboard Mouse Combos Tags: Combo, Keyboard, keyboard mouse combos, Mouse, MultiDevice, Set, WireKeyboard Mouse Combo, Wireless, Wireless BlueTooth Keyboard Mouse Combo, Wireless BlueTooth Keyboard Mouse Combos, Wireless BlueTooth Multi-Device Keyboard Mouse Combo, Wireless BlueTooth Multi-Device Keyboard Mouse Combos$39.99$19.99 -
Sale!
High Back Leather Executive Adjustable Swivel Gaming Chair with Headrest and Lumbar
$199.99$139.99 Add to cartHigh Back Leather Executive Adjustable Swivel Gaming Chair with Headrest and Lumbar
Categories: Gaming, Gaming Chairs Tags: Adjustable, Chair, computer chairs, Desk, Executive, Gaming, Girl, Headrest, High, High Back Leather Executive Adjustable Swivel Gaming Chair, High Back Leather Executive Adjustable Swivel Gaming Chair with Headrest, High Back Leather Executive Adjustable Swivel Gaming Chair with Headrest and Lumbar, High Back Leather Executive Adjustable Swivel Gaming Chairs, Leather, Lumbar, Office, Racing, Swivel$199.99$139.99 -
Sale!
Professional LED Light Wired Gaming Headphones with Noise Cancelling Microphone
$29.99$19.99 Select optionsProfessional LED Light Wired Gaming Headphones with Noise Cancelling Microphone
SKU: N/A Categories: Electronics, Gaming, Gaming Headsets Tags: Cancelling, Gaming, Gaming Headphones with Noise Cancelling Microphone, gaming headset, Headphones, Headset, LED, Light, Mic, Microphone, Noise, Professional, Professional LED Light Wired Gaming Headphones, Professional LED Light Wired Gaming Headphones with Noise Cancelling Microphone, Wired, Wired Gaming Headphones, Wired Gaming Headphones with Noise Cancelling Microphone$29.99$19.99 -
Sale!
Gaming Desk with LED Lights USB Power Outlets and Charging Ports
$349.99$249.99 Select optionsGaming Desk with LED Lights USB Power Outlets and Charging Ports
SKU: N/A Categories: Computer Desk, Gaming, Gaming Desk Tags: and Charging Ports, Charging, Desk, Desks, Gaming, gaming desk with led lights, Gaming Desks with LED Lights, Home, LED, Lights, Monitor, Office, Outlets, Port, Power, Room, Stand, USB, USB Power Outlets, White, Workstation$349.99$249.99 -
Sale!
Wired Mixed Backlit Anti-Ghosting Gaming Keyboard
$99.99$79.99 Add to cartWired Mixed Backlit Anti-Ghosting Gaming Keyboard
Categories: Electronics, Gaming, Gaming Keyboards Tags: Antighosting, Backlit, Blue, brown, Gaming, Gaming Keyboard, gaming keyboards, gaming keyboards and mouse, Keyboard, Laptop, Switch, Wired, Wired Mixed Backlit Anti-Ghosting Gaming Keyboard, Wired Mixed Backlit Anti-Ghosting Gaming Keyboards, Wired Mixed Backlit Gaming Keyboard$99.99$79.99 -
Sale!
Wireless Bluetooth 5.3 ANC Noise Cancellation Hi-Res Over the Ear Headphones Headset
$119.99$59.99 Add to cartWireless Bluetooth 5.3 ANC Noise Cancellation Hi-Res Over the Ear Headphones Headset
Categories: Electronics, Gaming, Gaming Headsets Tags: 5.3 ANC Noise Cancellation Hi-Res Over the Ear Headphones Headset, ANC, Audio, Bluetooth, Cancellation, Ear, Earphone, gaming headset, Headphones, Headset, Hi-Res Over the Ear Headphones Headset, HiRes, Noise, Wireless, Wireless Bluetooth 5.3 ANC Noise Cancellation Hi-Res Headphones, Wireless Bluetooth 5.3 ANC Noise Cancellation Hi-Res Over the Ear Headphones Headset, Wireless Bluetooth 5.3 ANC Noise Cancellation Hi-Res Over the Ear Headphones Headsets$119.99$59.99 -
Sale!
Wired Sports Gaming Headset Earbuds with Microphone
$19.99$9.99 Select optionsWired Sports Gaming Headset Earbuds with Microphone
SKU: N/A Categories: Gaming, Gaming Headsets Tags: Accessories, Earbud, Earphone, Earphones, Gaming, gaming headset with microphone, Headphones, Headset, IOS, Microphone, Sports, Wired, Wired Sports Gaming Headset Earbuds, Wired Sports Gaming Headset Earbuds with Microphone, Wired Sports Headset Earbuds$19.99$9.99 -
Sale!
150W Universal Multi USB Fast Charger 16 Port MAX Charging Station
$49.99$29.99 Add to cart150W Universal Multi USB Fast Charger 16 Port MAX Charging Station
Categories: Charging Stations, Electronics Tags: 150W, 150W Charging Station, 150W Universal Multi USB Charging Station, 150W Universal Multi USB Fast Charger 16 Port MAX Charging Station, 150W Universal Multi USB Fast Charger 16 Port MAX Charging Stations, 150W Universal Multi USB MAX Charging Station, 16 Port MAX Charging Station, 3.5A, Charger, Charging, Fast, laptop charging stations, Max, Multi, Port, Stand, Station, Universal, USB$49.99$29.99
ORACLE ✓
just wow