Running a small business is hard. In fact, most small companies never make it past year five. It takes a scrappy group of individuals to make it last. Long hours. Hard work. Every dollar is earned. Typically, most small organizations require employees to wear several hats. The accounting person might also handle operations. The CEO could be the sales lead. This multi-responsibility environment can be exhausting. There simply is too much work and not enough hours in the day. This kind of situation demands efficiency.
Working smarter, not harder, is where technology comes in. Using Oracle Autonomous Analytics Cloud, businesses are decreasing the amount of time spent on routine tasks and making room for the larger, more important strategic activities. For example, Oracle customers are automating sales reports that provide insights and bring clarity to every-day situations, quickly.
Is Jacob a better sales rep than Aaron? How many sales did each have last month? Last quarter? Did one sell more high-priced items than the other? Is Carlos a better customer than Steven? Which store do each of them prefer? What kinds of products are they buying most recently?
These questions are important to answer before making high-priority decisions such as potential hiring, opening new stores, and which products to order from suppliers. More to the point, getting these insights quickly and easily is critical to moving on to bigger, better things. Oracle Autonomous Analytics Cloud allows customers to capture their data easily and dynamically pivot through the numbers to gain deeper understandings quickly.
Let's look at a fictional chain of fly fishing retail stores. Perhaps the owners of the stores want to understand who their best sales people are. But how they define "best" is important. Is it the number of sales that matter? Is it the amount of revenue? Does the store location influence the numbers? How about the month or type of product? A general question of "who is the best" can be quite complex and could lead to other findings such as training needs, movement of sales people, and predict which months specific stores would expect to see an increase in sales.
For the visualizations below I will be using this spreadsheet.
After uploading any spreadsheet or creating a new data connection, and starting a new project, you see this:
On the left-hand side of the screen, you see the columns of data from the spreadsheet. Click and drag the data you want to look at into the main section of the project.
This is where the fun starts. Now that I have an unsorted, generic data set, I can quickly manipulate the output by filtering, formatting, adding data to consider, etc.
First off, simply clicking "save" in the top right allows me to name my project. Clicking the drop-down box to change from a pivot table allows me to create a bar chart. Right clicking on the graph allows me to sort high-to-low. Dragging "item" into the graph creates this:
That's a good looking sorted chart and answers the general question of "who's the best." In a few short actions, I created, named, sorted, and saved a detailed visualization. When I add filtering to the mix, I can see more useful information.
Dragging "item" into the filter section allows me to click on only the items I want to focus on. Let's say I only want to only see the big-ticket items such as rods and reels. I simply click on those products in the filter, and the graph gets updated instantly.
Notice there are some changes in the order of "who's the best." Not too different as focusing on the larger products is similar to looking at the whole picture. The point is...it was a few clicks to dig a bit deeper. This is a very fast way to see things from multiple perspectives. And that's the goal—saving time.
For instance, if I decide to focus on only flies, tippet, and leader, I see this:
That really changes things. I also added a background graphic that spiced up the visualization a bit. Who says you can't be creative and have fun while saving time too?
As you can see, a simple question of "who's the best salesperson" can be answered a few different ways. These findings were obtained in a very easy, quick manner. And this is the point. Small businesses fight for their existence every day. Spending long hours sorting through spreadsheets doesn't bring in revenue. Oracle Autonomous Analytics Cloud is helping customers get back to the real work.
I hope you found this blog informative and that you make use of the spreadsheet I attached above. To see how easy it is to use data visualization, here is a link to download the tool. Better yet... sign-up for a trial version of Oracle Autonomous Analytics Cloud! Also... be sure to visit our website and take one of our quick tours or try the data visualization simulator. You can also find more resources on our customized content page. Also, for current Oracle Analytics Cloud customers using Data Visualization, be sure to visit the Oracle Analytics Library and download sample files to take your analytics to a new level.
And finally...to see the bigger picture, and learn more about Oracle autonomous cloud services please visit the Oracle Autonomous Cloud website.