{"id":8485,"date":"2017-11-18T00:00:55","date_gmt":"2017-11-18T00:00:55","guid":{"rendered":"http:\/\/craftydba.com\/?p=8485"},"modified":"2024-12-26T21:05:54","modified_gmt":"2024-12-26T21:05:54","slug":"boston-code-camp-28","status":"publish","type":"post","link":"https:\/\/craftydba.com\/?p=8485","title":{"rendered":"Boston – Code Camp #28 – November 2017"},"content":{"rendered":"

I am excited about the opportunity to present at Code Camp 28<\/a> in the surrounding Boston area. It will be a good time to meet old friends and make new ones. <\/p>\n

I hope you have time to attend this awesome free event on November 18, 2017 at the Microsoft Office, Five Wayside Road, Burlington, MA. <\/p>\n

 <\/p>\n

Here are the details behind the first presentation<\/a> that I gave that day.<\/p>\n

Topic:<\/span><\/p>\n

Power BI Desktop Designer<\/p>\n

Abstract:<\/span><\/p>\n

The Power BI Desktop Designer has been adopted as a free reporting tool for many companies. Learn how X-Velocity uses super compression to query data faster than ever. See how Power Query can access virtually any data anywhere turning it into business information. Discover how disparate data can be conceptualized into a single business view. New visualization technology brings all this together to see your business like never before. <\/p>\n

Business Case:<\/span><\/p>\n

You have been asked by upper management to provide new dashboards to describe how the North Wind Traders company is doing, find new business opportunities, and make sure sales are going in the right direction.<\/p>\n

How can you leverage the Power BI Desktop Designer to complete this request?<\/p>\n

Coverage:<\/span><\/p>\n

1.\tLoad company data into the model
\n2.\tLoad additional data for new analysis
\n3.\tUse the M(ashup) language to format data
\n4.\tCreate relationships between the datasets
\n5.\tUse the DAX language to add additional measures
\n6.\tGraph the results using cool visual elements
\n7.\tCollate a bunch of graphs into a dashboard presentation
\n8.\tMake the dashboard dynamic with slicers
\n9.\tPublish the results to the cloud for sharing.<\/p>\n

Presentation Bundle<\/a><\/p>\n

 <\/p>\n

Here are the details behind the second presentation<\/a> that I gave that day.<\/p>\n

Topic:<\/span><\/p>\n

Basic Database Programming<\/p>\n

Abstract:<\/span><\/p>\n

You just found out that a client needs a SQL database to be designed from scratch. However, you existing DBA has given two week notice. This presentation is meant for the Accidental DBA that has little to no experience with creating Transaction SQL objects. After this presentation, will be ready to meet that clients need. <\/p>\n

This presentation will review the following topics to get you ready to code.<\/p>\n

Coverage:<\/span><\/p>\n

1 – How is a view better than ad-hoc SQL?
\n2 – Abstracting underlying tables via a view.
\n3 – Avoiding DML updates to views.
\n4 – Using triggers to enforce business rules.
\n5 – Using triggers to prevent data modifications.
\n6 – What are the different types of functions?
\n7 – Simple use of each type.
\n8 – Using stored procedures as an application interface.
\n9 – Batch programming using stored procedures.
\n10 – How to schedule batch jobs.<\/p>\n

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

I am excited about the opportunity to present at Code Camp 28 in the surrounding Boston area. It will be a good time to meet old friends and make new ones. I hope you have time to attend this awesome free event on November 18, 2017 at the Microsoft Office, Five Wayside Road, Burlington, MA.   Here are the details behind the first presentation that I gave that day. Topic: Power BI Desktop Designer Abstract: The Power BI Desktop Designer has been adopted as a free reporting tool for many…<\/p>\n","protected":false},"author":1,"featured_media":7300,"comment_status":"closed","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[600],"tags":[1115],"class_list":["post-8485","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-pres","tag-john-miner-presenter-boston-code-camp-26-microsoft-office-burlington-ma-power-bi-desktop-designer-tsql-basic-database-programming"],"_links":{"self":[{"href":"https:\/\/craftydba.com\/index.php?rest_route=\/wp\/v2\/posts\/8485","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/craftydba.com\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/craftydba.com\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/craftydba.com\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/craftydba.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=8485"}],"version-history":[{"count":1,"href":"https:\/\/craftydba.com\/index.php?rest_route=\/wp\/v2\/posts\/8485\/revisions"}],"predecessor-version":[{"id":10338,"href":"https:\/\/craftydba.com\/index.php?rest_route=\/wp\/v2\/posts\/8485\/revisions\/10338"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/craftydba.com\/index.php?rest_route=\/wp\/v2\/media\/7300"}],"wp:attachment":[{"href":"https:\/\/craftydba.com\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=8485"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/craftydba.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=8485"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/craftydba.com\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=8485"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}