The SQL Data Analysis Getting Started Guide
getting started
Explains how to connect to a database, run a query, and use the data set in an analysis table.
connecting to database servers
Explains how to connect to your database server in greater detail.
using data files
Explains data files, and how they can be used to share data with other users without having to grant them access to your databases.
running internal queries
Explains how SQL Data Analysis allows you to run SQL queries on data sets retrieved from different database servers.
using analysis tables
Explains how to create groups, summaries, and use charts with your data sets.
working with copies of the same data sets
Explains how you can create multiple analysis and pivot tables from the same data set without having to repeatedly run the same query.
working with analysis table columns
Explains how to hide and freeze columns, and create multi-row headers in your analysis tables.
working with charts
Explains how charts can be used to get a big picture analysis of your data set, and used as a navigation tool to support the analysis table.
How do data files facilitate secure data sharing between users without granting direct access to underlying databases, and what are the advantages of using them for controlled information exchange?
Visit us IT Telkom
You can extract a subset of the database and let users analyse the data however they want using SQL Data Analysis.