Episode 50 – Live from SPC18 in Las Vegas

This is episode 50 recorded live on May 21st 2018… where John & Jason talk the announcements & other things happening at the SharePoint Conference North America in Las Vegas.

Facebook Live show: https://www.facebook.com/bifocalshow/videos/255860991644964/ 

Notes:

  • Power BI Insights baked into lists
  • Was that a modern BDC built in?
  • 3D editor site of course
  • SP2019 – still waiting on deprecation statements for PP and PP4SP
  • Our tutorial…. What were people looking for?

Episode 49 – SPCNA session picks with Liz Sundet

This is episode 49 recorded on May 15th 2018… where John & Jason talk to Liz Sundet, Office Servers & Services MVP from Minnesota, about the upcoming SPCNA Conference in Las Vegas next week and some news related to the upcoming GDPR deadline.

Liz Sundet

Liz is a Microsoft Office Servers and Services MVP and is involved with multiple areas of the business as a consultant for SharePoint and Office 365. Her work includes a variety of aspects from developing strategies to aid in collaboration, identifying best practices for SharePoint and Office 365 to run efficiently and working with multiple teams on identifying needs and areas of improvement. Liz loves a challenge, so everything from a business problem to troubleshooting an error in a system is just another learning opportunity. As a trainer and international speaker, she hopes to inspire others to learn something they can apply to their own work immediately. When she is not working in SharePoint or traveling, you may find her in a variety of activities as diverse as she is: playing music, riding motorcycles, training her dog and even a craft or two. You can follow her on twitter @percusn

Liz’s Picks

Three Must Have SharePoint Workflows with Microsoft Flow Level – Vlad Catrinescu
https://www.sharepointna.com/#!/session/Three%20Must-Have%20SharePoint%20Workflows%20with%20Microsoft%20Flow
5 Simple Ways to Improve Business Productivity with SharePoint, OneDrive, and Microsoft Flow Level: 100 Stephanie Donahue
https://www.sharepointna.com/#!/session/5%20Simple%20ways%20to%20improve%20business%20productivity%20with%20SharePoint,%20OneDrive,%20and%20Microsoft%20Flow
Take a Chance and Hire that  Fine Arts Major Liz Sundet
https://www.sharepointna.com/#!/session/Take%20a%20Chance%20and%20Hire%20that%20Fine%20Arts%20Major

John’s Picks

SharePoint Server 2019: A First Look – Bill Baer & Hani Loza
https://www.sharepointna.com/#!/session/SharePoint%20Server%202019:%20A%20First%20Look
Get the Facts from your SharePoint Site with Analytics, Then Improve It! – Liz Sundet
https://www.sharepointna.com/#!/session/Get%20the%20Facts%20from%20your%20SharePoint%20Site%20with%20Analytics,%20Then%20Improve%20It!
Understanding Office 365 Usage Reporting – Scott Hoag
https://www.sharepointna.com/#!/session/Understanding%20Office%20365%20Usage%20Reporting

Jason’s Picks

Keynote – SharePoint and OneDrive connect your workplace – Jeff Teper, Seth Patton, Omar Shahine, Dan Holme
https://aka.ms/watch/SPVS
Be a SPFx Ninja: with these Performance, Debugging, Logging and Telemetry Tricks! – Andrew Connell
https://www.sharepointna.com/#!/session/Be%20a%20SPFx%20Ninja:%20with%20these%20Performance,%20Debugging,%20Logging%20and%20Telemetry%20Tricks!
Developing SharePoint Framework Web Parts with Power BI Embedding – Ted Pattison
https://www.sharepointna.com/#!/session/Developing%20SharePoint%20Framework%20Web%20Parts%20with%20Power%20BI%20Embedding
Using Flow and Azure Functions to Customize your Site Design – Dave Feldman
https://www.sharepointna.com/#!/session/Using%20Flow%20and%20Azure%20Functions%20to%20Customize%20your%20Site%20Design
Mastering Modern Authentication and Authorization for SharePoint and Office 365 Applications – Eric Shupps
https://www.sharepointna.com/#!/session/Mastering%20Modern%20Authentication%20and%20Authorization%20for%20SharePoint%20and%20Office%20365%20Applications

Episode 48 – Power BI Desktop May Updates

This is episode 48 recorded on May 8th 2018… where John & Jason talk about Guy in a Cube’s new video, and walk through the new features of the May 2018 Power BI Desktop which includes the much anticipated incremental refresh.

Guy in a Cube CDSA – Common Data Service for Analytics (CDS-A) and Power BI – an Introduction
https://youtu.be/1vQ0HLNZ06A

Excel Gets custom visuals “soon”
https://powerbi.microsoft.com/en-us/blog/excel-announces-new-data-visualization-capabilities-with-power-bi-custom-visuals/

New PBI Desktop for May
https://powerbi.microsoft.com/en-us/blog/power-bi-desktop-may-2018-feature-summary/

Reporting
• Conditional formatting by a different field
• Advanced slicer syncing
• Log axis improvements
• Data label options for funnel chart
• Set line stroke width to zero

Analytics
• Measure drillthrough

Power BI Premium
• Incremental refresh (preview)

Custom visuals
• Collage by CloudScope
• Chinese Color Map

Data connectivity
• New “From Web” connector – By example data extraction (preview)
• Common Data Service for Apps connector (beta)
• Azure KustoDB connector (beta)
• Google BigQuery and Azure HDInsight Spark connectors now generally available
• Adobe Analytics connector update – Support for multiple domain logins (preview)
• Visual Studio Team Services connector update – Analytics views support
• OLE DB connector update – Support for alternate Windows credentials
• SAP BW DirectQuery connector update – Improved technical name support

Data preparation
• Improvements to Add Column From Examples

Episode 47 – Excel Update with Olaf Hubel

This is episode 47 recorded on April 30th 2018… where John & Jason interview Olaf Hubel, Senior Program Manager at Microsoft on the Excel Engineering team.

Excel User Voice
https://excel.uservoice.com/

Excel Blog
https://techcommunity.microsoft.com/t5/Excel-Blog/bg-p/ExcelBlog

Excel Community
https://techcommunity.microsoft.com/t5/Excel/ct-p/Excel_Cat