{"id":736,"date":"2020-05-07T11:17:46","date_gmt":"2020-05-07T03:17:46","guid":{"rendered":"http:\/\/www.yohz.com\/blogs\/?p=736"},"modified":"2020-05-07T12:01:23","modified_gmt":"2020-05-07T04:01:23","slug":"sql-data-analysis-guide","status":"publish","type":"post","link":"https:\/\/www.yohz.com\/blogs\/2020\/05\/07\/sql-data-analysis-guide\/","title":{"rendered":"SQL Data Analysis guide"},"content":{"rendered":"

The SQL Data Analysis Getting Started Guide<\/h2>\n

getting started<\/a>
\nExplains how to connect to a database, run a query, and use the data set in an analysis table.<\/p>\n

connecting to database servers<\/a>
\nExplains how to connect to your database server in greater detail.<\/p>\n

using data files<\/a>
\nExplains data files, and how they can be used to share data with other users without having to grant them access to your databases.<\/p>\n

running internal queries<\/a>
\nExplains how SQL Data Analysis allows you to run SQL queries on data sets retrieved from different database servers.<\/p>\n

using analysis tables<\/a>
\nExplains how to create groups, summaries, and use charts with your data sets.<\/p>\n

working with copies of the same data sets<\/a>
\nExplains how you can create multiple analysis and pivot tables from the same data set without having to repeatedly run the same query.<\/p>\n

working with analysis table columns<\/a>
\nExplains how to hide and freeze columns, and create multi-row headers in your analysis tables.<\/p>\n

working with charts<\/a>
\nExplains 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.<\/p>\n

 <\/p>\n

<\/fb:like><\/div>
<\/div><\/div>","protected":false},"excerpt":{"rendered":"

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 […]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_monsterinsights_skip_tracking":false,"_monsterinsights_sitenote_active":false,"_monsterinsights_sitenote_note":"","_monsterinsights_sitenote_category":0,"footnotes":""},"categories":[86],"tags":[101,87],"_links":{"self":[{"href":"https:\/\/www.yohz.com\/blogs\/wp-json\/wp\/v2\/posts\/736"}],"collection":[{"href":"https:\/\/www.yohz.com\/blogs\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.yohz.com\/blogs\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.yohz.com\/blogs\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.yohz.com\/blogs\/wp-json\/wp\/v2\/comments?post=736"}],"version-history":[{"count":5,"href":"https:\/\/www.yohz.com\/blogs\/wp-json\/wp\/v2\/posts\/736\/revisions"}],"predecessor-version":[{"id":747,"href":"https:\/\/www.yohz.com\/blogs\/wp-json\/wp\/v2\/posts\/736\/revisions\/747"}],"wp:attachment":[{"href":"https:\/\/www.yohz.com\/blogs\/wp-json\/wp\/v2\/media?parent=736"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.yohz.com\/blogs\/wp-json\/wp\/v2\/categories?post=736"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.yohz.com\/blogs\/wp-json\/wp\/v2\/tags?post=736"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}