Dataprix's blog

Data Integration: ETL or ELT?

 

Data integration: ETL vs ELTModern enterprises gather data from many disparate sources, including social media, websites, customer databases (CRM systems, sales records etc), customer support systems, and HR software.

Merely collecting lots of data isn't useful in itself—it's the insights you get from such data that can drive more informed business decisions. This post aims to teach you about the bedrock processes required for obtaining insights from your data—ETL and ELT.

We'll begin by discussing data integration, before moving on to two vital forms of data integration—ETL and ELT. When you're finished reading, you'll fully understand what ETL and ELT are, and which process is better suited to your business in terms of getting actionable insights from different data sources..  

Popular Agile Testing Metrics and KPIs and How to Use Them

 

Cumulative flow diagramAgile test metrics and KPIs are measurements that enable Agile teams to assess how effective their software tests are and whether their testing efforts help achieve specific business objectives. An important aim of Agile software testing is to get testing up to speed with development—metrics and KPIs can assess the efficacy of the Agile testing team in this context.

In this article, you'll find out about the important difference between a metric and a KPI, and why you need to distinguish between the two. You'll also get some examples of KPIs and metrics relevant to Agile software testing efforts. Finally, you'll learn exactly how KPIs and metrics can lead to overall improvement in software testing within an Agile framework in addition to understanding some important measuring pitfalls..

Data Warehouse Security Best Practices

 

DWH securityData warehouse security is vital for organizations that take the huge step of collating all their important data in one place. Unauthorized access to data warehouses can have devastating consequences, ranging from compromised customer information to exposing of high-level business intelligence that gives an enterprise its competitive advantage.

This article introduces warehouse security, discusses some of the challenges involved in securing a data warehouse, and offers some best practices for data warehouse security, including the use of FIPS 140-2 certified software and hardware..

Trying to Defining the Next Decade

 

In 2007 when we hosted the first The Finance and Investment Forum event in Cass Business School in London the data centre and cloud industry was still, in a sense, in it’s infancy. Even then few predicted not only the sector expansion but the technological advances and energy innovation that would come to recent prominence..

Use SEMrush to win the battle to your competitors

 

Herramienta Semrush para análisis SEM y SEO

 

SEMrush is one of the best tools of SEM and SEO for marketing online professionals.

If you are a professional of online marketing, either offering services of SEM and SEO positioning to third parties, or belong to the marketing department of a company that invests in Adwords, I am convinced that after trying it you can't stop using it..

..

Interview with Matt Mayevsky, author of "The Clouds Economy"

 

Matt Mayevsky, author of Clouds EconomyThis time we interviewed Matt Mayevsky to explain to us in their own words what their Cloud Economics, objectives and motivations, the difficulties found along the way, and where it is headed 'The Clouds Economy' project ..

Interview with the authors of "Pentaho 5.0 Reporting by example"

 
 
Pentaho Reporting by ExampleMariano Garcia and Dario Bernabeu recently announced on his blog of Dataprix the publication of his new book 'Pentaho Reporting 5.0 by Example: Beginner's Guide'.
 

Knowing both authors and their previous work, we are confident on the utility of that book for anyone who wants to work with Pentaho Report Designer, but we'd rather interview them to explain it themselves..

 

Export data from a SQL Server table

 

To import and export data from SQL Server,  Microsoft provides the tool bpc, which operates by command line. Although it would be appreciated if SQL Server Management Studio would provide some

Results of the last Forrester Wave about Enterprise Business Intelligence Platforms

 

In his blog Boris Evelson explains the more relevant results of the las Forrester Wave about Enterprise Business Intelligence Platforms.

These are the last movements, extracted from it:

  1. IBM Cognos, SAP BusinessObjects, Oracle, and SAS continue to lead the pack.
  2. Information Builders, Microsoft, and MicroStrategy move into the Leaders category.
  3. TIBCO Spotfire and Actuate maintain their Strong Performer status.
  4. QlikTech and Panorama Software move into the Strong Performer category.

 

Changes in the major categories of Dataprix

 

Cambios en las categorías principales de DataprixWe have changed the hitherto category 'Free Software' from Dataprix a broader call 'Technology Trends. " In this way we include also other content and views on emerging technologies, such as the 'Cloud computing' or other new or emerging, or where someone wants to talk...

 

Syndicate content