Posts
Hello All
What does Python have to do with BI report? Well maybe no much directly in enterprise environment, but python can be very useful for my garage project. I want to build a Data visualization product that shows real time update of certain market driven products and get users to subscribe to it for a monthly fee, that's what python can be handy for my ETL process.
Just to give an idea, I may choose to store my data in one of these open source DBs like Hadoop Hive, Cassandra or Mongo DB, and I can use python to pull data from whatever source...
Thursday, February 26, 2015
Monday, February 23, 2015
Tableau Visualization -- How to build Waterfall chart
Waterfall chart can be used in accounting to show trends in the horizontal time span usually as result of positive and negative influences in sequential order. We will look at the product's profit over years.
To start, lets have profit in row and product and time in column:
As you can see, some product creates positive profit and some creates negative profit.
Now let's add a new table calculation off profit to get the running total of...
Thursday, February 19, 2015
OBIA Financial analytic AP Process 101
Today we are looking at the basic process of AP or Accounts Payable in Oracle EBS for financial analytic. This is to give you a basic understanding of how AP process works for most companies that implements Oracle EBS. In order to build AP reports out of EBS source, you need to understand the basics.
Although different companies will have different accounting process and different product dealings, the basic AP process is comparable.
Based on the...
Tuesday, February 17, 2015
Tableau Visualization -- How to build Gnatt Chart
Gnatt chart can be useful in showing status of large number of items and things with respect to time. An example of that is displaying the various flight time from each route and determine which has the longest delay or longest flight time as reflected on the chart by the size of each Gnatt.
In my example, i am going to show for a given year, how are the order to ship time is like for each product in the warehouse.
So start with product dimension...
Thursday, February 12, 2015
Tableau Visualization -- How to build lollipop Chart
Lollipop chart is a fancy and cute chart that has become pretty popular. It is named such way because the shape of the graph consist of a bar attached to a circle, forming a shape of Lollipop. This chart can be useful to provide visualization for your measure numbers in terms of 'how long' it occupies the horizontal axis and the precious location of the measure numbers on the horizontal axis as a dot. The length of the bar is determined by the size...
Tuesday, February 10, 2015
Tableau Visualization -- How to build Dot chart
Dot chart is a pretty typically statistical graph where each data point on the graph are marked in a circle shape. Making dot chart in Tableau is pretty simple and standard.
Lets start with sample data set and we put 'state or province' as dimension then 'sales' and 'profit' as measures all into the row section of the report and set the display under 'Mark' as circle:
Then, drag and drop both sales and profit from rows into the highlighted vertical...
Friday, February 6, 2015
Tableau Visualization -- How to build Pareto chart
Pareto chart can be very good for highlighting certain items from a very large set of factors based on certain criteria, Tableau has a very powerful way of creating pareto chart.
We will start with a simple dimension (product name ) in Column and measures (sales) in rows, in order for the chart to make sense, there should be a lot of products:
Now in our particular example, we are comparing the running total and percent of total of the sales...
Sunday, February 1, 2015
Tableau Visualization -- How to build thermometer chart
Thermometer is a cool visual that allows audience to visually look at different matrix that the difference can be visually indicated by the different color, size in one chart as if it was like Thermometer.I experimented a few ways to build a basic thermometer chart using tableau, this is a pretty cool visual.
1. Lets start with 2 dimensions and 2 matrix. Here I am using customer segment and region as dimension and sales and profit as matrix by putting...
Subscribe to:
Posts (Atom)
