Top 5 trends in BI-Analytics

Ease of use: In past advanced analytics required command line code. Today with emerging automation techniques the analytics vendors have made interfaces easier to use with advanced visualization capabilities. Blending and preparing the data has become easier. These techniques enable the software to suggest models using the variables and examining the data. The ease of use is enabling organizations to succeed early and become more data driven. With ease of use organizations are socializing BI and Analytics to enable non-IT, business users to engage and do more with their data with help of self-service BI. Embedding analytics into business processes organizations are equipping their business users with powerful analysis and faster decision making.

bi-analytics

Big Data: Big data is not only driving the usage of existing technologies but also the development of new techniques for data analysis. With increasing implementation of new infrastructure such as Hadoop and multi-platform data warehouse environments that manage, process and analyze new forms of data, structured, unstructured and real-time data, big data is playing an important role in analytics needs of organizations. Leveraging on big data processing tools allows analysts to analyze and perform queries on large data sets at real time with robust models and insightful reports.

Open Source Adoption:  Open source is rapidly gaining popularity in infrastructure and analytics space. Hadoop has become the choice of many organizations as the backbone infrastructure for their analytics need. There are many commercial flavors of hadoop that is getting more powerful day by day. With rapidly growing popularity of R language in analytics front, it has provided the impetus to the open source community. Many of the analytics software vendors are already integrating support for R in their solutions. Python is another example of open source programming language that has gained popularity in analytics space. Open source adoption is important as it provides continuous innovation in analytics ecosystem.

BI-Analytics on Cloud: More and more vendors are now offering their BI-Analytics solutions on cloud as it provides more benefits compared to conventional BI-Analytics implementations.  Organizations are moving towards cloud as it offsets cost with no capital expenditure, maintenance and even manpower. Cloud has made BI implementations cost effective and easy to deploy.

Mobile BI-Analytics: With increasing usage of mobile devices new platforms are at disposal to access data and consume analytics. Sales and service personnel can now improve customer engagements with the help of visualizations with relevant data provided on their mobile devices. Top management on the go now analyze their business performance, key metrics and deep dive into granular data to get more insights.

If you’re interested in implementing BI solutions for your business, give us a call at +1 (858) 401 2332.

Features of Tableau 9

Introduction

The new Tableau 9 is packed with game-changing enhancements that take the experience of data analysis to a whole new level. New features like parallel processing are set to deliver massive performance improvements, while the new level of detail calculations will make once complicated table calculations child’s play. So here are the few important new features in Tableau 9.0

  1. New options in Map

The “Tableau Classic” map has been removed from the Map Options. Hover over the map and the map toolbar is shown, the first button is a search tool allows you to search for geographic locations around the globe. Lasso tools have been improved in maps. There is now a circular and freeform polygon tool to select marks on a map.

tableaue-new-map-option

2. Direct connector for SAS, SPSS, R – stats package files

Stats files can now be visualized by Tableau. This new connector brings native support for a number of statistical package files including:

.sas7bdat – the file format used by SAS

.sav – the binary file format used by SPSS

.rdata, .rda – the file formats employed by the R statistical analysis package

Tableaue-Direct-connector-for-SAS

3. Ad-hoc Calculation

The speed of design is faster too along with speed of platform. Now: switch to the Analytics Tab and you have drag and drop analytics! For quick calculations double click a blank space in Rows, Columns, or Marks and type some code to create an Ad-hoc calculation.

Tableaue-Ad-hoc-calculation

4. Updated colour window with hex values and colour picker

The new and improved colour palette dialogue box now allows you to specify and see hex values for all the colours you’re using – very handy for putting together those custom colour palettes, and what’s more you can now also pick a colour from anywhere on your desktop and drop it into the palette.

Tableaue-color-window

5.  Arrow to the right of the new calculation window

The new calculation window auto-completes your typing with suggested dimensions, measures and formulas. Click on the arrow to the right you get your formula drop-down, complete with explanations and a usage example. It’s a nice way to keep the interface clean while still giving you the option to search the formula list. While we’re on the subject, don’t forget to check out some of the new calculations introduced in v9, like the RANDOM(), HEXBIN, and REGEXP functions.

tableaue-new-calculation

6. The new “Split” function

With this new feature you can convert text to columns in Tableau on a go. What typically used to be a job for Excel, SQL, or a calculated field of LEFTs and RIGHTs has now been made a one-click operation in Tableau. Just right-click on the dimension you want to split, navigate to the new ‘Transform’ menu and click Split. Tableau will automatically try to figure out the delimiter and split the data accordingly, but you can also choose Custom Split and specify the delimiter yourself if you like.

Tableaue-split-function

7. The new “Tableau Discover” side menu on the start page

When you open Tableau v9 for the first time you’ll now notice a new menu on the right that alerts you to a bunch of handy Tableau resources, including links to training for beginners, a highlight section on the Tableau Viz of the Week.

Tableaue-discover

8. “Tableau” button in the top left

Tableau now includes a handy “Tableau” button in the top left of the menu bar, which allows you to quickly flip between your viz and the Tableau Desktop start page.

button-top-left

9. The “Add New Data Source” button drop-down menu

Clicking on the add new data source button in the menu bar now reveals a drop-down menu, which allows you to really quickly connect to a new data source, without having to navigate to another page

Tableaue-new-data-source

10. Tooltips stay shown until you move your mouse, rather than dropping off after a few seconds

In current versions of Tableau, a tooltip only stays alive for 8 seconds and then it disappears. Now in Tableau v9, tooltips stick around for as long as you leave your mouse in place. Furthermore, tooltips are now super responsive, populating with new data for whichever mark you’re hovering over in real-time. You can disable it as well using tooltip window

Tableaue-tool-tips

For More Information about Tableau , Speak to our Tableau expert on: +1 (858) 401 2332

Or email at sales@bistasolutions.com

How Tableau BI Can Help You to Grow Your Business

grow your business
  • by bista-admin
  • May 11, 2015
  • 0
  • Category:

Tableau enables businesses to make decisions using the data visualization features available to business users of any background and industry. It empowers businesses to keep up with the continuously evolving technology and outperform its competition through an innovative means of visualizing their data.

Tableau connects to any data source like Data Warehouse, MS Excel or any web data. Tableau provides immediate insight by transforming data into visually engaging, interactive views in dashboards. With easy to use drag-and-drop interface one can come-up with insights in few moments rather than months or years.

Speed to Market – Tableau processes and analyzes data in easy to follow and logical manner. This helps in saving development time and making decision making faster. The ability to adapt to market needs is a huge competitive advantage. Tableau helps in rapid decision making based on your data that result in competitive advantage

Ease of Use – Tableau data visualization platform simplifies the data analysis and removes unnecessary complications, focuses on what matters most – finding the real value in your data. A simple drag and drop interface in Tableau is easy to learn and eliminates IT staff dependency.

tableau-data-visulization

Tableau capabilities –

  • Big data analysis capabilities
    • Tableau has optimized direct connections for high-performance databases, cloud data source and Hadoop. It enables you to work with your data directly to create reports, dashboards and stories. With in-memory analytical engine Tableau lets you connect to live data
    • Tableau enables the users to do their own analysis with simple drag & drop, point & click feature to easily to build charts, reports, dashboards and stories
    • Tableau’s in-memory data engine is not just restricted to fit data into your machine’s RAM. Tableau’s in-memory technology make use of all the memory on your machine, down to the hard disk, so the analysis is amazingly fast at the same time

tableau-Big-data-analysis-capabilities

  • Connection to all the standard data sources
    • Tableau has provided native connectors to popular databases (list in the below picture). These native connectors have been:
      • Optimized to increase performance
      • Leverage capabilities of each of the data sources
      • Enforce and security protocols

Tableau makes it easy to add new data sets, be it an Excel workbook, a flat file or any database. Tableau automatically blends these data sets using common fields.

tableau-easy-to-add-dataset

  • R Integration
    • R functions and models can be used in Tableau by creating new calculated fields that dynamically calls the R engine and pass the result values to R. The visualization engine in Tableau utilizes the results returned back
    • A user with proficiency in R
      • Is able to do statistical analysis on their Tableau data
      • Is able to access any R package or function that has been installed in an R server which they can access
      • Is able to take advantage of all of the visualization capabilities in Tableau to further analyze and understand their data without having to manipulate their data in R (which can be cumbersome) for the same effect.

tableau-R-integration

Interested in implementing Tableau? Get in touch with us today or read for more information.

What are the Key Features of Tableau 9.0

Key Features of Tableau 9.0 

The new Tableau 9 is packed with game-changing enhancements that take the experience of data analysis to a whole new level. New features like parallel processing are set to deliver massive performance improvements, while the new level of detail calculations will make once complicated table calculations child’s play. So here are the few important new features in Tableau 9.0

1. New options in Map

The “Tableau Classic” map has been removed from the Map Options. Hover over the map and the map toolbar is shown, the first button is a search tool allows you to search for geographic locations around the globe. Lasso tools have been improved in maps. There is now a circular and freeform polygon tool to select marks on a map.

tabeulo-map-option
2. Direct connector for SAS, SPSS, R – stats package files

Stats files can now be visualized by Tableau. This new connector brings native support for a number of statistical package files including:

.sas7bdat – the file format used by SAS

.sav – the binary file format used by SPSS

.rdata, .rda – the file formats employed by the R statistical analysis package

Direct connector for SAS

3. Ad-hoc Calculation

The speed of design is faster too along with speed of platform. Now: switch to the Analytics Tab and you have drag and drop analytics! For quick calculations double click a blank space in Rows, Columns, or Marks and type some code to create an Ad-hoc calculation.

ad-hoc-calculation

4. Updated color window with hex values and color picker

The new and improved color palette dialogue box now allows you to specify and see hex values for all the colors you’re using – very handy for putting together those custom color palettes, and what’s more you can now also pick a color from anywhere on your desktop and drop it into the palette.

updated-color-window
5. Arrow to the right of the new calculation window

The new calculation window auto-completes your typing with suggested dimensions, measures and formulas. Click on the arrow to the right you get your formula drop-down, complete with explanations and a usage example. It’s a nice way to keep the interface clean while still giving you the option to search the formula list. While we’re on the subject, don’t forget to check out some of the new calculations introduced in v9, like the RANDOM(), HEXBIN, and REGEXP functions.

new-calculation-window
6. The new “Split” function

With this new feature you can convert text to columns in Tableau on a go. What typically used to be a job for Excel, SQL, or a calculated field of LEFTs and RIGHTs has now been made a one-click operation in Tableau. Just right-click on the dimension you want to split, navigate to the new ‘Transform’ menu and click Split. Tableau will automatically try to figure out the delimiter and split the data accordingly, but you can also choose Custom Split and specify the delimiter yourself if you like.

 split-function
7. The new “Tableau Discover” side menu on the start page

When you open Tableau v9 for the first time you’ll now notice a new menu on the right that alerts you to a bunch of handy Tableau resources, including links to training for beginners, a highlight section on the Tableau Viz of the Week.

tableau-discover
8. “Tableau” button in the top left

Tableau now includes a handy “Tableau” button in the top left of the menu bar, which allows you to quickly flip between your viz and the Tableau Desktop start page.tableau-BUTTON-TOPLEFT
9. The “Add New Data Source” button drop-down menu

Clicking on the add new data source button in the menu bar now reveals a drop-down menu, which allows you to really quickly connect to a new data source, without having to navigate to another page

add-new-data
10. Tool tips stay shown until you move your mouse, rather than dropping off after a few seconds

In current versions of Tableau, a tooltip only stays alive for 8 seconds and then it disappears. Now in Tableau v9, tooltips stick around for as long as you leave your mouse in place. Furthermore, tooltips are now super responsive, populating with new data for whichever mark you’re hovering over in real-time. You can disable it as well using tooltip window

final-image

Are you looking for Tableau Implementation?  Speak to our Tableau expert on:  +1 404 631 6219

Or email at sales@bistasolutions.com

Tableau as “Leader” in BI and Analytics

Tableau implementation Company
  • by bista-admin
  • May 04, 2015
  • 0
  • Category:

As more data is analysed and collected, today every company needs Data visualization to make better decisions and Tableau is comprehensive software for Rapid fire, easy to use Business analytics. Many Business professionals are depending upon Tableau as it allows user to quickly visualize, manipulate and explore the data.

Tableau Implementation Company

Gartner positioned Tableau as “Leader” in its Magic Quadrant for Business Intelligence and Analytics Platforms; this is the third time in a row that Tableau has been rated in the Leaders quadrant.

This report evaluated 24 different software vendors on 15 criteria and placed Tableau in the Leaders quadrant.

According to Gartner, “The year 2014 has been another year of challenging execution for the market share leaders in the BI and analytics market, juxtaposed against strong execution for data discovery vendors, particularly Tableau, that are satisfying customers, meeting their buying requirements and delivering greater business value.”

Gartner also says “Customers often use the product for business-user-driven reporting as a complement to more analyst-oriented data discovery tools such as Tableau. The road map includes enhancements for data access and integration as well as to the visualization capabilities.”

To access full report Click Here

Are you planning to Implement Tableau for your organisation?

You Need a Right Tableau Implementation Company

While finding a right BI Consultant, you need to consider skills and experience and at the same time you also have to match your Business goals. At Bista Solutions, we provide comprehensive Tableau services with personalized approach to you and your data.

Bista has strong expertise in Implementing Tableau BI and we are confident that we will meet all your Tableau and data requirements.

For Quick Chat with our Tableau Expert

Contact: USA – +1 (858) 401 2332 / Other Regions: +91 89760 98984 or Email : sales@bistasolutions.com

How To Manage & Forecast Your Resource Planning ERP

resource planning erp

The success of a project depends on planning, organising and managing resources.  A project begins with resource mapping and for any Project manager Resource mapping is important and challenging task. . Improper resource planning affects project delivery, control on project, leads to lack of task accountability and clarity. Research says only 34% of the projects are delivered on time and on budget with desired functionality, because of improper resource planning.

Organizations have limited resources to perform tasks. Hence it becomes important for project manager to successfully execute a project within the available resources.

Bista has developed customized module in OpenERP Odoo which helps Project Managers to track which resource is engaged on a project and monitor resource level during/end of the project.

With the help of this module you can actually simplify your Resource planning as you easily track the number of resources available and resources that are busy and the resource that are on leave.

track-resource-erp

The different bar indicates different constraints.

 Blue – Busy Time

Green – Free Time

Red – Leave

Yellow – Entire Duration

Understanding more about resource mapping sheet

Start with the selection of the duration. The working mechanism depends upon calendar defined and working hours, number of working days in a week is also picked form calendar. Whenever any holiday or non-working day encountered during task duration, system automatically shift that day to next working day.

track-resource-erp-bar

The result will be shown corresponding to the selected duration only.

 Hovering over the bars will show the details such as project name in which the resource is busy, the duration in figures and the start date.

 Extremely useful for project planning activities and to identify and schedule the resources needed to delivery of project successfully.

 track-resource-erp-graph

When resource allocation becomes a challenge, this customization of Odoo will help you to overcome them. If you are looking for similar module, kindly contact on

Email Id: sales@bistasolutions.com

Contact: USA:  +1 (858) 401 2332 / Other Regions +91 89760 98984

Also see our reporting dashboards for project management.

How to Simplify Fleet Management process using ERP System

fleet management

Fleet managers face many critical issues; the major challenges are vehicles/Fleets, Cost and Contract Management.

fleet_managemwnt_softwarefleet_managemwnt_software

In this article Here, we will discuss these challenges and how to overcome them using ERP Software

In an ERP system, there is a module called Fleet Management which helps to manage fleets and transportation departments effectively. With the help of this module you can easily track vehicle+ contracts, their fuels intake, servicing history, odometer tracking etc.

Some of the benefits offered by Fleet Management Module in ERP are as below:

Vehicle Management:

This Feature allows you to register the vehicles/fleets into the system such as vehicle Registration number, Supplier information, Contract Type, Driver associated with the vehicle and other information. It contains almost all the car manufacturing details at one place. You can easily edit, remove and process in a  single click.

fLEET_MANAGEMENT

Cost Management:

Cost management becomes easy with this feature.  It allows you to calculate and track the actual cost incurred on a particular vehicle. It also helps you to track services that were consumed by the vehicle, overall fuel consumption and odometer tracking.

fleet_cost_management

As Shown in above image: each vehicle is tracked with its exact date and kilometer reading.

For each and every trip that fleet covers, you can make an entry in ERP System, about how much fuel has been consumed and what is total kilometer covered. This way you can easy maintain the records and make better decision about controlling and managing fuel consumption

Contract Management:

This feature is helpful in managing the contracts of the vehicles which are been hired. Some of the key benefits of this feature are:

  1. Type of contracts can be defined e.g. Leased or Owned.
  2. Duration of the contract i.e. period from starting date to end date
  3. Frequency of the contract e.g. Monthly, Quarterly or Yearly.

Overall the Fleet Management Module helps you to

  • Improve record keeping,
  • Improve Employee Efficiency,
  • Reducing Fuel Consumption,
  • Tracks your vehicle location at a given time Manages vehicle’s Lifecycle

If you are looking for an ERP system for Fleet Management Services, you can simply email us on sales@bistasolutions.com or contact us on USA :  +1 (858) 401 2332  / Other Regions : +91 89760 98984

Manage Your Project Effectively: Introducing Reporting Dashboards

In a professional company, there are many projects that need to be managed. It’s a project manager responsibility to understand how each project is performing. In today’s busy scenario it’s important for the project manager to get detailed status reports pertaining to all aspects of the project without investing too much time.

A project manager needs to view the status of his work such as check how many projects has been assigned to him, how much work has been completed and is pending etc. The challenge is to have all this information handy and available at a fingertip.

From this purpose, grew the concept of Dashboard, a simple graphical representation of diverse data which can provide on underlying facts and information. Just as a car’s dashboard gives all relevant and up-to-date information, such as speedometer about the speed of the vehicle, water temperate gauges the amount of gas in the tank and temperature of the engine.

Bista has developed Customized Dashboards which helped customer with easy and amazing reporting structure of Project Management.

The dashboard definitely provides decision makers with the input necessary to drive the business.

We came up with idea of creating the dashboards showing the necessary details pictorially & in the form of tables. The resulting dashboard that shows all the things are:

screen

screen2

The Number of projects & tasks for the user are shown the table as:

screen3

Also the lists of tasks assigned to a user are shown as:

screen5

Showing the current week’s hours of a user categorized as billable hours, non-billable hours & process improvement hours would look good graphically. A pie chart shows all the worked hours. Hovering over the chart show the hours in numbers.

Clicking on the ‘Bar Graph’ shows the bar graph for the hours.
screen6

Clicking on the ‘Line Chart’ shows the Line chart for the hours

screen7

Clicking on ‘Export Data’ will export the details into an excel file:

screen8

Thus it helps organization’s key performance indicators to enable instantaneous & informed decisions to be made at a glance.

If you are looking for similar feature, simply email us on sales@bistasolutions.com
For Any Urgent Sales Enquiry Please Contact: US –  +1 (858) 401 2332 / Other Regions- +91 89760 98984

How To Create multiple websites with single administration panel in magento

Magneto

Can you imagine making multiple websites with single administration panel?
Yes, it is possible.

Magento provides the flexibility to setup and manage multiple e-commerce websites from a common administration panel, so that administrators can easily generate reports, get payments and do shipping configurations of their web shops using single administration panel.

Let us first  understand how to create two  websites in magento.

  1. Login to your administration panel and move to “Manage Stores” menu present inside System >configuration.
  2. There is already a default website called as the main website.
  3. Enter the below fields – Description of each field is given. Below are the fields required to enter and description of each field.
    1. Name * (Mandatory): This is the name of the Website which will display across the orders to all customers.
    2. Code * (Mandatory): This is a unique code of the website which is used to uniquely identify the website. It should be unique for each of the websites.
    3. Sort Order (Non -Mandatory): Defines the order in which these websites will be listed.
    4. Default Store: Every website displays content related to a web store. This field is a drop down which lists all the web stores created. Hence we need to create a web store to assign it to our website. Process to create a web store is listed below.

Now, Let’s see the process of creating Web Store:

  1. Inside Manage Store, there is a button to create a store which starts the process to create a store.
  2. Enter the below fields, description of each is mentioned.
    1. Website * (Mandatory): Select the website you want to associate the store to.
    2. Name *: Provide a name for the store.
    3. Root Category *: List of Root categories created in Catalog->Manage Categories.

So now we have 2 different websites. We can add more store views to each of the websites.

If you are looking for Magento development and customization or Magento Integration with ERP, you can email us on sales@bistasolutions.com

How Loyalty Program Runs in Odoo POS Module.

What is Loyalty Program:

A loyalty program offered by company to customers who frequently make purchases.
After Customer get registered their personal information with the company and they are given a unique identifier, such as a numerical ID or membership card, and use that identifier when making a purchase.

Going forward in this article we will see how to handle Loyalty Program by offering Rewards Card in Odoo.

We have integrated Rewards Program and Store Credit Concept in the POS Module.

Following section describes that.

Rewards Program:

Rewards Points Rules:
Each Company has some rules for Earned and Redeemed Points calculation. Following screenshot shows how to configure those rules in the system

Page-1-Image-1.

From the above screenshot following is the significance of each field configuration:

Points : how much points you will get for each purchase based on the monetary value and  purchase total.

Monetary Value : Minimum POS order total amount to earn the specified points.

Threshold Points : Minimum Points which allows the customer to redeem it in the next purchases.

Threshold Monetary Value : Amount you can pay for purchases using rewards points.

Reward Journal :  Accounting Journal Configuration which will track all the transactions paid by Rewards.

We are storing all the information about whether customer is eligible for the rewards program or not, earned and redeemed points in the customer profile which look as follows:

Earned and Redeemed points are getting calculated during POS Transactions only if “Activate My Rewards” Configuration in the customer profile is checked.

Page-2-Image-2

 Following screenshot shows how customer can redeemed their earned points during POS transactions.

Page-2-Image-3

While doing payment processing for POS transactions above window will be visible which shows Total Points as Total Earned Points, Points Balance as Subtraction of Earned and Redeemed points and Points Value as how much amount they can pay by using reward points based on the rules configured in the system.

Store Credit Concept:

Store credit comes into picture when customer asks for the returning of product i.e for refunding of amount that time company may denies to give them money in the Cash or to deposit money in the Credit Card, but they can store that amount so that customer can use that same amount during the next purchases.

Store Credit Configuration:

Following screenshot shows the configuration of the Store Credit:

Page-3-Image-4

Store Credit Journal :  Accounting Journal Configuration which will track all the transactions paid  by Store Credit.

We are storing all the information about Store credit amount stored and used in the Customer Profile which looks as follows:

Page-3-Image-5

Following screenshot shows how the customer can use stored store credit amount during purchases:

Page-4-Image-6

Are you looking for similar customization? To know more send your inquiry on sales@bistasolutions.com

Contact Sales Team :

USA:  +1 (858) 401 2332 / Other Regions – +91 89760 98984