Data Science - Revision history

Rasimsen at 18:29, 30 May 2018

2018-05-30T18:29:27Z

Rasimsen at 18:51, 28 May 2018

2018-05-28T18:51:07Z

Rasimsen at 18:37, 28 May 2018

2018-05-28T18:37:49Z

Show changes

Rasimsen at 18:06, 28 May 2018

2018-05-28T18:06:17Z

Rasimsen at 18:05, 28 May 2018

2018-05-28T18:05:28Z

Rasimsen at 18:03, 28 May 2018

2018-05-28T18:03:44Z

Rasimsen: /* Extract Transform and Load (ETL) */

2018-05-28T18:02:54Z

‎Extract Transform and Load (ETL)

Rasimsen at 17:45, 28 May 2018

2018-05-28T17:45:50Z

Rasimsen at 17:45, 28 May 2018

2018-05-28T17:45:32Z

Rasimsen: Created page with " ==Extract Transform and Load (ETL)== ===Pentaho==="

2018-05-28T16:49:26Z

Created page with " ==Extract Transform and Load (ETL)== ===Pentaho==="

New page

==Extract Transform and Load (ETL)==
===[[Pentaho]]===

← Older revision	Revision as of 18:29, 30 May 2018
Line 1:	Line 1:
	+
	+	== [[R - Quick Guide]] ==
	+

← Older revision		Revision as of 18:51, 28 May 2018
Line 238:		Line 238:


		+	===[[TabLeau]]===
		+	Tableau Server is an online Data warehousing with 3 versions Desktop, Server, and Online. It is secure, shareable and mobile friendly data warehouse solution.

		+	Features:
		+
		+	*Connect to any data source securely on-premise or in the cloud
		+	*Ideal tool for flexible deployment
		+	*Big data, live or in-memory
		+	*Designed for mobile-first approach
		+	*Securely Sharing and collaborating Data
		+	*Centrally manage metadata and security rules
		+	*Powerful management and monitoring
		+	*Connect to any data anywhere
		+	*Get maximum value from your data with this business analytics platform
		+	*Share and collaborate in the cloud
		+	*Tableau seamlessly integrates with existing security protocols
		+
		+	TabLeau link:[https://public.tableau.com/en-us/s/download https://public.tableau.com/en-us/s/download]
		+
		+
		+	===[[MicroStrategy]]===
		+	MicroStrategy is an enterprise business intelligence application software. This platform supports interactive dashboards, scorecards, highly formatted reports, ad hoc query and automated report distribution.
		+
		+	Features:
		+
		+	*Unmatched speed, performance, and scalability
		+	*Maximize the value of investment made by enterprises
		+	*Eliminating the need to rely on multiple tools
		+	*Support for advanced analytics and big data
		+	*Get insight into complex business processes for strengthening organizational security
		+	*Powerful security and administration feature
		+
		+	MicroStrategy link:[https://www.microstrategy.com/us/get-started https://www.microstrategy.com/us/get-started]


	===[[Pentaho]]===		===[[Pentaho]]===
−	===[[]]===	+	Pentaho is a Data Warehousing and Business Analytics Platform. The tool has a simplified and interactive approach which empowers business users to access, discover and merge all types and sizes of data.
		+
		+	Features:
		+
		+	*Enterprise platform to accelerate the data pipeline
		+	*Community Dashboard Editor allows the fast and efficient development and deployment
		+	*Big data integration without a need for coding
		+	*Simplified embedded analytics
		+	*Visualize data with custom dashboards
		+	*Ease of use with the power to integrate all data
		+	*Operational reporting for mongo dB
		+	*Platform to accelerate the data pipeline
		+
		+	Pentaho link : [https://www.hitachivantara.com/en-us/products/big-data-integration-analytics/pentaho-trial-download.html?source=pentaho-redirect https://www.hitachivantara.com/en-us/products/big-data-integration-analytics/pentaho-trial-download.html?source=pentaho-redirect]
		+
		+
		+
		+	===[[Google BigQuery]]===
		+	Google's BigQuery is an enterprise-level data warehousing tool. It reduces the time for storing and querying massive datasets by enabling super-fast SQL queries. It also controls access to both the project and also offering the feature of view or query the data.
		+
		+	Features:
		+
		+	*Offers flexible Data Ingestion
		+	*Read and write data in via Cloud Dataflow, Hadoop, and Spark.
		+	*Automatic Data Transfer Service
		+	*Full control over access to the data stored
		+	*Easy to read and write data in BigQuery via Cloud Dataflow, Spark, and Hadoop
		+	*BigQuery provides cost control mechanisms
		+
		+	Google BigQuery link: [https://cloud.google.com/bigquery/ https://cloud.google.com/bigquery/]
		+
		+	===[[Numetric]]===
		+	Numetric is the fast and easy BI tool. It offers business intelligence solutions from data centralization and cleaning, analyzing and publishing. It is powerful enough for anyone to use. This data warehousing tool helps to measure and improve productivity.
		+
		+	Features:
		+
		+	*Data benchmarking
		+	*Budgeting & forecasting
		+	*Data chart visualizations
		+	*Data analysis
		+	*Data mapping & dictionary
		+	*Key performance indicators
		+
		+	Numetric link : [https://www.numetric.com/schedule-a-demo/ https://www.numetric.com/schedule-a-demo/]
		+
		+	===[[Solver BI360 Suite]]===
		+	Solver BI360 is a most comprehensive business intelligence tool. It gives 360º insights into any data, using reporting, data warehousing, and interactive dashboards. BI360 drives effective, data-based productivity.
		+
		+	Features:
		+
		+	*Excel-based reporting with predefined templates
		+	*Currency conversion and inter-company transactions elimination can be automated
		+	*User-friendly budgeting and forecasting feature
		+	*It reduces the amount of time spent for the preparation of reports and planning
		+	*Easy configuration with User-friendly interface
		+	*Automated data loading
		+	*Combine Financial and Operational Data
		+	*Allows to view data in Data Explorer
		+	*Easily add modules and dimensions
		+	*Unlimited Trees on any dimension
		+	*Support for Microsoft SQL Server/SQL Azure
		+
		+	Solver link : [http://www.solverglobal.com/products/ http://www.solverglobal.com/products/]

← Older revision		Revision as of 18:06, 28 May 2018
Line 6:		Line 6:


−	=== [[QuerySurge] ===	+	=== [[QuerySurge]] ===
	[[QuerySurge]] is ETL testing solution developed by RTTS. It is built specifically to automate the testing of Data Warehouses & Big Data. It ensures that the data extracted from data sources remains intact in the target systems as well.		[[QuerySurge]] is ETL testing solution developed by RTTS. It is built specifically to automate the testing of Data Warehouses & Big Data. It ensures that the data extracted from data sources remains intact in the target systems as well.

@@ Line 6: / Line 6: @@
-== QuerySurge ==
+=== [[QuerySurge] ===
 [[QuerySurge]] is ETL testing solution developed by RTTS. It is built specifically to automate the testing of Data Warehouses & Big Data. It ensures that the data extracted from data sources remains intact in the target systems as well.
@@ Line 19: / Line 19: @@
 *Deliver shareable, automated email reports and data health dashboards
-[https://goo.gl/exoNtY|https://goo.gl/exoNtY]
+QuerySurge site: [https://goo.gl/exoNtY https://goo.gl/exoNtY]
-==[[Pentaho]]==
+===[[Pentaho]]===
-==[[IBM InfoSphere DataStage]]==
+===[[IBM InfoSphere DataStage]]===

@@ Line 19: / Line 19: @@
 *Deliver shareable, automated email reports and data health dashboards
-[https://goo.gl/exoNtY]
+[https://goo.gl/exoNtY|https://goo.gl/exoNtY]
-===[[Pentaho]]===
+==[[Pentaho]]==
-===[[IBM InfoSphere DataStage]]===
+==[[IBM InfoSphere DataStage]]==

← Older revision		Revision as of 17:45, 28 May 2018
Line 3:		Line 3:
	==Extract Transform and Load (ETL)==		==Extract Transform and Load (ETL)==
	===[[Pentaho]]===		===[[Pentaho]]===
		+	===[[IBM InfoSphere DataStage]]==