{"id":1031,"date":"2014-10-17T07:34:25","date_gmt":"2014-10-17T13:34:25","guid":{"rendered":"https:\/\/clarkcreations.net\/blog\/?p=1031"},"modified":"2014-10-17T08:16:44","modified_gmt":"2014-10-17T14:16:44","slug":"sqlsaturday-schedule-now-made-easier","status":"publish","type":"post","link":"https:\/\/clarkcreations.net\/blog\/sqlsaturday-schedule-now-made-easier\/","title":{"rendered":"SQLSaturday Schedule printing, now made easier."},"content":{"rendered":"

I have been playing with Power BI items lately and have found some really good uses and some really big shortcomings. But today while I was playing with something an idea popped into my head. As a SQLSaturday organizer I found creating the schedule for print was a PITA. I have seen people just print the screen, which makes blowing it up to poster size a bit of a\u00a0mess. I had to cut and paste, fix, format and it ends up a hot mess like below so I think I ended up just typing it.<\/p>\n

\"Bad<\/a><\/p>\n

So let me give you a better option. This is so easy I am pretty sure even my non-technical dad could do this.<\/p>\n

Open Excel and be sure that you have POWER QUERY installed. If you don\u2019t a simple Bing search will send you to the download page and it truly only takes a couple seconds. Select the POWER QUERY TAB, now select \u201cFrom Web\u201d.<\/p>\n

\"Ribbon<\/a><\/p>\n

We are going to use SQLSat #272, Nashville\u2019s from January 2014. In the pop up paste the URL to your SQLSaturday Schedule and select ok.<\/p>\n

\"Pop<\/a><\/p>\n

This will take a few seconds but when it is complete on the far right side you will see a pane labeled Navigator.\u00a0 <\/strong><\/span>Under that you\u2019ll see a file folder with your web address and 3 table icons named Table 0, Table 1 and Document. You can click on it once to get a preview of the data. Table 0 is your schedule, Table 1 is all the submitted sessions and Document is HTML data we don\u2019t need. Since we are only after the schedule double click on Table 0. This will open a new window (below).<\/span><\/p>\n

\"Query<\/a><\/p>\n

I renamed my Table 0 to \u2018Schedule 272\u2019. I know it looks like there is only the speaker name, but if you click in a cell you\u2019ll see all the data is there. Now select \u201cClose & Load\u201d<\/p>\n

\"Pre-formatted<\/a><\/p>\n

Now you have very little formatting to do. For me I Hit the design tab and removed the coloring. A couple of formatting items and you now have a schedule that is printable. Best part is that you can right click in the Work Book Queries<\/strong><\/span> pane and Refresh the data.<\/p>\n

My completed schedule, quick and easy.<\/p>\n

\"Print<\/a><\/p>\n","protected":false},"excerpt":{"rendered":"

I have been playing with Power BI items lately and have found some really good uses and some really big shortcomings. But today while I was playing with something an idea popped into my head. As a SQLSaturday organizer I found creating the schedule for print was a PITA. I have seen people just print the screen, which makes blowing it up to poster size a bit of a mess. I had to cut and paste, fix, format and it ends up a hot mess like below so I think I ended up just typing it.<\/p>\n<\/p>\n

So let me give you a better option. This is so easy I . . . → Read More: SQLSaturday Schedule printing, now made easier.<\/a><\/span><\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[221,269,270,148,273,272],"tags":[231,218,309,276,275,277,245,234],"class_list":["post-1031","post","type-post","status-publish","format-standard","hentry","category-sqlsat","category-how-to","category-instructions","category-pass","category-power-bi","category-power-query-technology","tag-sqlcommunity","tag-sqlfamily","tag-sqlsat","tag-how-to-2","tag-instructions-2","tag-schedules","tag-sqlsaturday","tag-technology-2","odd"],"aioseo_notices":[],"_links":{"self":[{"href":"https:\/\/clarkcreations.net\/blog\/wp-json\/wp\/v2\/posts\/1031","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/clarkcreations.net\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/clarkcreations.net\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/clarkcreations.net\/blog\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/clarkcreations.net\/blog\/wp-json\/wp\/v2\/comments?post=1031"}],"version-history":[{"count":0,"href":"https:\/\/clarkcreations.net\/blog\/wp-json\/wp\/v2\/posts\/1031\/revisions"}],"wp:attachment":[{"href":"https:\/\/clarkcreations.net\/blog\/wp-json\/wp\/v2\/media?parent=1031"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/clarkcreations.net\/blog\/wp-json\/wp\/v2\/categories?post=1031"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/clarkcreations.net\/blog\/wp-json\/wp\/v2\/tags?post=1031"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}