u? Power BI? SQL? Excel? Tablea
Which one is
the Best for Your Data Analysis?
www.skillfinlearning.com
On
the
Basic of Use
SQL Tableau can
start small
a desktop
with
version and scale to the largest enterprises with Tableau Server and the Tableau Online cloud version.
To connect
to multiple sources of data like SQL Server, Excel, CSV, JSON, XML, Web and SQL Analysis Services etc.
You can
use SQL to work directly with the source databases.
E
xcel
N o n -t e c h n i c a l business
people can easily learn
to work with d a t a t h a t' s been exported from other applications.
01 www.skillfinlearning.com
On
the
Basic of Vis u ali z a t ion
SQL Create interactive graphs and charts in
the
form of
dashboards and
worksheets to gain business insights.
Visualization
with custom element fits, offers data preparation and discovery in one s o l ut i o n .
The only
way to speak to relational databases and a b o ut d e f i n i n g characteristics in business intelligence.
E
xcel
Visualization
with
static data
for quick
glances like pivot
tables.
02 www.skillfinlearning.com
On
the
Basic of Limi t a t ion
SQL Tableau is limited
It cannot
work
by hardware and
"perceived
with uncleaned data. It lacks data
performance
modeling and
and
u s a b i l i ty."
dictionary
capabilities for Analysts.
Limited
with difficult interface, partial control, and costly programming.
E
xcel
Lack of integration
with another systems, l a c k o f f l e x i b i l i ty a n d a d a p t a b i l i ty to changes.
03 www.skillfinlearning.com
On
the
Basic of Meas u remen t
SQL
Uses MDX for
Uses DAX for
measures and
calculating and
dimensions.
measuring columns.
Uses its own queery
to
a ut o m a t i c a l l y calculate and measure
E
xcel
Uses DAX for calculating and measuring columns.
columns.
04 www.skillfinlearning.com
On
the
Basic of Applica t ion
SQL Used by analysts
Used by both
users mostly use f o r t h e i r a n a l yt i c s purposes.
experienced
and experienced
naïve and
users.
E
xcel
Used by
U s e d e xt e n s i v e l y
admins and
analysts and
database data analysts.
by finance
accountants.
05 www.skillfinlearning.com
Data Taking Over The World.
www.skillfinlearning.com