Skip to main content
  • Log in
  • twitter
  • linkedin
  • facebook

Dataprix main menu

  • Blogs
  • Software
  • News and resources
Home

Main tematic navigation

  • Business Intelligence
  • Data Science
  • Cloud
  • Databases
  • Security
  • ERP

Entradas de blog

7 Tips to Optimize Data Visualizations

By guest on Fri, 12/06/2019 - 12:34
  • Read more about 7 Tips to Optimize Data Visualizations
  • Log in or register to post comments

Data has become a central asset to organizations and visualizations are critical to present data in a clear way. Visualization helps organizations make data-driven decisions. Optimizing data visualizations conveys the information in an accessible way that enhances the user experience. This article provides seven practices you can follow to improve your data visualization process..

Data Integration: ETL or ELT?

By guest on Sat, 11/18/2017 - 19:08
  • Read more about Data Integration: ETL or ELT?
  • 1 comment
  • Log in or register to post comments

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..  

more posts
Más software empresarial

Documentación y recursos

Tableau Dashboard Cookbook: Chapter 1 - A short dash to dashboarding

Tableau Dashboard CookbookThis book follows a step-by-step approach to taking a data source and building up a series of dashboard elements, ultimately resulting in a series of dashboards for your business.

 

Download chapter 1 of Tableau Dashboard Cookbook:
A short dash to dashboarding!

 

Whitepaper: The Power of Predictive Analytics

The power of analytics - WhitepaperPredictive analytics provide companies the ability to systematically leverage data from across the value chain to peer into the future and identify the most likely outcomes.

Learn about using predictive analytics to help new product introductions and promotions succeed

Más recursos sobre software empresarial
Más videos IT

Publicaciones en la red

Join Us! Power BI Dev Camp! Thursday 28 January,
2021

Learn how to get started designing and implementing custom visuals
for Power BI. Attendees will learn how to define the capabilities
and data mappings for a custom visual and how to program D3-style
data binding using categorical data from a Power BI dataset. The
session also demonstrates how to extend a visual with custom
properties and how to package a custom…

Read on:

https://powerbi.microsoft.com/en-us/blog/join-us-power-bi-dev-camp-thur…

Shaping vs Modelling in Power BI

Level: Beginners The objective of this article is to help you
understand the differences between shaping your data (using Power
Query) and modelling your data (using the modelling tools inside
Power BI). You will need to do both to build a robust Power BI
report.  I first wrote this article [...]

…

Read on:

https://exceleratorbi.com.au/shaping-modelling-power-bi/

More publications from the net

Popular today

How to do an update from a select with summarized registers in SQLServer

A very powerful way to do a table's update in a SQL Server database is to link it with another table with a join, and updating the fields…

How to know the DB2 connection port

Maybe there are other methods, in this short article, a simple way to know the port that serves DB2 server.

AWR Formatter

Anyone who usually look at AWR performance reports to analyze Oracle performance problems, often have their own reading process and…

Remote access with Oracle dblink global_names or without

"Without knowing how easy the item may seem difficult" Creating a database link to point to an oracle database to another in principle is…

Useful Oracle SQL queries and scripts

Don't you have a chop with useful queries to use in your daily adventures and desventures with the database? I include in this first post a…

Easily export data from Oracle to flat file

A simple way to export data from a query, table, etc.. of an oracle database to a flat file is to use the SPOOL command in SQLPlus. This…

Avoiding errors concatenating fields with numerical values in SQL Server

The operator to concatenate in SQL Server is '+', but this operator is also used to add values.   Being the same operator for both, the…

Tips for UPSERT or update using insert in SQL Server

In many cases, especially in ETL processes or data loading to a data warehouse, for example, we would rather use a single sentence or the…

How to recover the password of the user sa on SQL Server

With SQL Server, when we forget or we lose the password of the DBA user 'sa', and we are the administrators of the database, we have a…

How to connect from Oracle SQL Developer with a remote SQL Server

I tried to create a connection in SQL Developer with a remote SQL Server database.

Breadcrumb

  1. Home
  2. Business Intelligence

Creative Commons License  This work is licensed under a Creative Commons Attribution-Share Alike 3.0 Unported License.

Footer menu

  • Contact
Clear keys input element