Prashant Philip Vargis
Members
-
Joined
-
Last visited
Solutions
-
Prashant Philip Vargis's post in Data Visualization Tools was marked as the answerBelow is the comparison study between Power BI and Tableau.
Tableau Power BI Can handle large volumes of data. Can handle only limited amount of data. Excellent customer support. Only paid version has good customer support. Works best with large data sets kept in cloud. Does not work well with large amount of data. Experienced people uses Tableau the most Used by both naïve and experienced professionals. Interface is not very user friendly Very easy to learn interface. Tableau server available for storing data. Does not have storing data capabilities. Used in medium and large scale organizations. Used in all types of organizations. MDX is used for measures and dimensions. DAX is used for measures. Embedding report is difficult for Tableau. Embedding is easy in Power BI.
Power BI is used for creating dashboards related to Resource Management, Financial reporting, Sales scorecard, Claims, collection and billing, inventory optimization.
Some of the use cases of Tableau are as follows -
IT — asset inventory, Service desk performance analysis, resource allocation
Finance — Budgeting, accounting, expense tracking
Marketing — Leads management, campaign management
Human Resources — Retention analysis, employee satisfaction.
Sales — Pipeline tracking
Facilities Operations — Workload distribution.
-
Prashant Philip Vargis's post in Earned Value was marked as the answerEarned value of a project provides the progress of a project in terms of schedule and cost. Earned value helps to gauge the project progress in the following manner.
Earned value is the percent of the total budget actually completed at a particular point in time.
EV = %complete *total budget
Actual cost is the actual money spent on the work completed.
Planned value is the budgeted amount for the work panned to be completed.
Cost variance, CV = EV-AC
Cost Performance Index, CPI = EV/AC
Schedule variance, SV = EV-PV
Schedule Performance Index, SPI = EV/PV
If CPI is less than one and CV is negative indicates that project cost performance is below plan.
SPI greater than one and positive SV indicates that more work was established than planned.
This is how Earned value helps gauge project progress.
Earned value may not help in the following cases -
1. Project scope, schedule or budget is not properly defined
2. WBS is not complete
3. Actual cost does not include all the costs.
4. Management influence
5. No time to collect all data.