Slides and Demo Files from SPTechCon DC 2017

   Big thanks to Stacy and her crew of organizers, all of the attendees, and fellow speakers at SPTechCon DC 2017.  This was one of the best ones I’ve attended from an engagement and networking perspective.  Below are my slides and source code.  Feel free to let me know about any follow up questions or comments.

PowerApps and Microsoft Flow for Developers

GitHub link to demo project files

https://github.com/BrianTJackett/BTJ.PowerApps.AzureDBSample

Slides

Intro to Power BI for Office 365 Developers

Slides

Sample Financial Data file

http://go.microsoft.com/fwlink/?LinkID=521962

Blog posts on SMAT data report

https://aka.ms/SMAT2013BTJpart1

https://aka.ms/SMAT2013BTJpart2

      -Frog Out

Slides and Demo Files from Dogfood Con 2017

   A big thanks to Cassandra, Trey, Danillo, and all of the other organizers of Dogfood Con 2017.  Thanks also to all of the folks who attended my two sessions.  Below are my slides and source code.  Feel free to let me know about any follow up questions or comments.

PowerApps and Microsoft Flow for Developers

GitHub link to demo project files

https://github.com/BrianTJackett/BTJ.PowerApps.AzureDBSample

Slides

Intro to Power BI for Office 365 Developers

Slides

Sample Financial Data file

http://go.microsoft.com/fwlink/?LinkID=521962

Blog posts on SMAT data report

https://aka.ms/SMAT2013BTJpart1

https://aka.ms/SMAT2013BTJpart2

-Frog Out

Slides and Demo Files from CincyDevelop() Conference

   A big thanks to Phil and all of the other organizers of Cincy.Develop() / Day of Agile Conference.  Thanks also to all of the folks who attended my Integrate All the Things: PowerApps and Flow for Developers session.  Below are my slides and source code.  Feel free to let me know about any follow up questions or comments.

PowerApps and Microsoft Flow for Developers

GitHub link to demo project files

https://github.com/BrianTJackett/BTJ.PowerApps.AzureDBSample

Slides

-Frog Out

Upcoming Speaking Events in 2017

I’m honored to be accepted to speak at the following upcoming events.  Here are the abstracts for these presentations.  If you are at any of these events feel free to stop by and chat.  Registration is still open as of the time of writing as well.

 

Cincy.Develop()

Website: Cincy Day of Agile and Cincy.Develop()

When: Fri. Jul 28, 2:40pm-3:40pm

Title: Integrate All the Things: PowerApps and Microsoft Flow for Developers

Abstract: Securely start a server farm of Azure dev VMs with the tap of a button on your phone. Update data in an on-prem DB from any device without writing any plumbing code or UI layer. In this session we will overview PowerApps and Microsoft Flow which are low-code / no-code solutions that allow forms and workflow development that integrate to hundreds of services including Twilio, Twitter, Azure, GitHub, and more. We will also talk about the developer story for integrating with Custom Connectors and on-prem data sources such as SQL Server and SharePoint. Lastly we will demo a number of scenarios to show how easily you can create and consume apps across Windows, iOS, Android, and web. Prior experience with PowerApps and Flow is not required.

 

DogFood Conference

Website: DogFoodCon

When: Oct 5-6, timeslots TBA

Title: Integrate All the Things: PowerApps and Microsoft Flow for Developers

Abstract: Securely start a server farm of Azure dev VMs with the tap of a button on your phone. Update data in an on-prem DB from any device without writing any plumbing code or UI layer. In this session we will overview PowerApps and Microsoft Flow which are low-code / no-code solutions that allow forms and workflow development that integrate to hundreds of services including Twilio, Twitter, Azure, GitHub, and more. We will also talk about the developer story for integrating with Custom Connectors and on-prem data sources such as SQL Server and SharePoint. Lastly we will demo a number of scenarios to show how easily you can create and consume apps across Windows, iOS, Android, and web. Prior experience with PowerApps and Flow is not required.

 

Title: Intro to Power BI for Office 365 Developers

Abstract: “Power BI is SSRS in the cloud, right?” “I’ll throw a few pie charts on the screen and call it a dashboard, right?” Wrong. In this session we will introduce Office 365 developers to the Power BI service and Power BI Desktop. We will cover data sources that can be used (Azure SQL, SharePoint, files, etc.), direct query vs. imported dataset, report and dashboard creation, and the on-prem data gateway. We will also break down misconceptions of good dashboard design (hint: pie charts and 3D are almost always a bad design). Prior experience with Power BI or Power BI desktop are not required.

 

SPTechCon DC

Website: SPTechCon DC

When: Nov 12-15, timeslots TBA

Title: Integrate All the Things: PowerApps and Microsoft Flow for Developers

Abstract: Securely start a server farm of Azure dev VMs with the tap of a button on your phone. Update data in an on-prem DB from any device without writing any plumbing code or UI layer. In this session we will overview PowerApps and Microsoft Flow which are low-code / no-code solutions that allow forms and workflow development that integrate to hundreds of services including Twilio, Twitter, Azure, GitHub, and more. We will also talk about the developer story for integrating with Custom Connectors and on-prem data sources such as SQL Server and SharePoint. Lastly we will demo a number of scenarios to show how easily you can create and consume apps across Windows, iOS, Android, and web. Prior experience with PowerApps and Flow is not required.

 

Title: Intro to Power BI for Office 365 Developers

Abstract: “Power BI is SSRS in the cloud, right?” “I’ll throw a few pie charts on the screen and call it a dashboard, right?” Wrong. In this session we will introduce Office 365 developers to the Power BI service and Power BI Desktop. We will cover data sources that can be used (Azure SQL, SharePoint, files, etc.), direct query vs. imported dataset, report and dashboard creation, and the on-prem data gateway. We will also break down misconceptions of good dashboard design (hint: pie charts and 3D are almost always a bad design). Prior experience with Power BI or Power BI desktop are not required.

 

      -Frog Out

Slides and Demo Scripts from SharePoint Saturday Twin Cities 2016

A big thank you out to the organizers, attendees, and sponsors from SharePoint Saturday Twin Cities.  It has been a number of years since I was last at this event and great to see it alive and well.  I had a great time getting to talk with attendees and fellow speakers as well as presenting two sessions.  Slides, code, and scripts from my sessions are below.  If you have any feedback or follow up questions please leave a comment below.

 

On a personal note I was completely flattered when Jeff Teper (“father of SharePoint” himself) and James Phillips (CVP for Business Apps at Microsoft) tweeted back to me during my prep time this morning.  Great to see the Corporate Vice President or SharePoint and OneDrive engaged and supporting community events.  A sign of good things to come from the SharePoint and PowerApps leadership.

 

image

 

PowerApps and Microsoft Flow Intro for Developers

GitHub link to demo project files

https://github.com/BrianTJackett/BTJ.PowerApps.AzureDBSample

Slides

 

Running Your Azure Dev / Test VMs for Cheap

PowerShell script for creating new Azure RM VM

Slides

 

-Frog Out

Slides and Demo Scripts from Dog Food Conference 2016

   A big thank you out to the organizers, attendees, and sponsors from Dog Food Conference.  I had a great time getting to talk with attendees and fellow speakers as well as presenting two sessions.  Slides, code, and scripts from my sessions are below.  If you have any feedback or follow up questions please leave a comment below.

 

PowerApps and Microsoft Flow Intro for Developers

GitHub link to demo project files

https://github.com/BrianTJackett/BTJ.PowerApps.AzureDBSample

Slides

 

Running Your Azure Dev / Test VMs for Cheap

PowerShell script for creating new Azure RM VM

Slides

 

      -Frog Out

Upcoming Speaking Events September 2016

   After many months away from blogging and speaking (baby #2 was born recently) I’m speaking at a few conferences in the coming months.  If you are attending any of these conferences please stop by and say hi.  Looking forward to returning to each of these events.  Here are the sessions and abstracts.

 

Sessions

SharePoint Saturday Detroit (Sept 17th, 2016)

Title: PowerApps and Microsoft Flow for the SharePoint Developer

Abstract: PowerApps and Microsoft Flow are enterprise services (currently in preview) that allows power users and developers to build scalable applications that connect with numerous consumer and enterprise sources using PowerPoint and Excel-like tools. In this session we will overview the integration points for PowerApps and Microsoft Flow with various sources such as OneDrive, Twitter, Azure, and more. We will also talk about the developer story for integrating with custom APIs and on-prem data sources such as SQL Server and SharePoint. Lastly we will demo a number of scenarios to show how easily you can create and consume apps across Windows, iOS, Android, and web.

 

DogFood Con (Oct 5-6, 2016)

Title: PowerApps and Microsoft Flow Intro for Developers

Abstract: PowerApps and Microsoft Flow are enterprise services (currently in preview) that allows power users and developers to build scalable applications that connect with numerous consumer and enterprise sources using PowerPoint and Excel-like tools.  In this session we will overview the integration points for PowerApps and Microsoft Flow with various sources such as OneDrive, Twitter, Azure, and more.  We will also talk about the developer story for integrating with custom APIs and on-prem data sources such as SQL Server and SharePoint.  Lastly we will demo a number of scenarios to show how easily you can create and consume apps across Windows, iOS, Android, and web.

 

Title: Running Your Dev / Test VMs in Azure for Cheap

Abstract: With an MSDN subscription you can run your dev / test environment in Azure IaaS for less than the cost of a cup of coffee each day. In this session we will overview the basics of Azure IaaS (Infrastructure as a Service), the pieces you will use to be successful deploying SharePoint in Azure (including the new Azure Resource Manager templates), and how to use resources as efficiently as possible to reduce your costs and boost your farm performance. This session is targeted to SharePoint developers and administrators. Prior knowledge of Azure is helpful but not a requirement.

 

SharePoint Saturday Twin Cities (Oct 29, 2016)

Title: PowerApps and Microsoft Flow for Developers

Abstract: PowerApps and Microsoft Flow are enterprise services (currently in preview) that allows power users and developers to build scalable applications that connect with numerous consumer and enterprise sources using PowerPoint and Excel-like tools.  In this session we will overview the integration points for PowerApps and Microsoft Flow with various sources such as OneDrive, Twitter, Azure, and more.  We will also talk about the developer story for integrating with custom APIs and on-prem data sources such as SQL Server and SharePoint.  Lastly we will demo a number of scenarios to show how easily you can create and consume apps across Windows, iOS, Android, and web.​

 

      -Frog Out