Ep 80 – December 2018 Power BI Desktop Update

This is episode 80 recorded on December 17th, 2018 where John & Jason talk about last update to Power BI Desktop in 2018 including features like Smart guides for aligning objects on a page & the preview of Live connect support for Q&A.

Show Notes

Reporting

Analytics

Modeling

Custom visuals

Data connectivity

Data preparation

Other

Useful links

November 2018 Power BI Desktop Update

Ep 79 – Interview with Jen Stirrup

This is episode 79 recorded on November 28th, 2018 where John interviews Jen Stirrup, Microsoft Data Platform MVP and Regional Director about the state of Business Intelligence and its relationship to Machine Learning and Artificial Intelligence. They spends a little time talking about the competitive landscape.

Show Notes


Jen Stirrup is an industry analyst and speaker, an author, Microsoft Data Platform MVP, a data strategist and practitioner in Business Intelligence, Big Data and Data Visualisation. With nearly 20 years’ experience, Jen works for global clients to deliver strategic advice and implementation in data technologies.

She focuses on R, Machine Learning, database technologies, and Big Data solutions. Jen speaks at conferences such as Hadoop Summit, Microsoft Ignite, SQLPass Summit and SQLBits. She also runs an annual Business Analytics conference in London. Jen blogs at jenstirrup.com and her R, ML and Business Intelligence webinars can be found at datascience.sqlpass.org and bi.sqlpass.org

Useful links

Decency Charter for Technical Communities

Mental Health in Consultancy: You do You

Episode 77 – Interview with Arun Ulag

Thisis episode 77 recorded on November 21st, 2018 where John & Jason talk aboutsome new blogs posts from John and interview Arun Ulag, General Manager ofPower BI Engineering at Microsoft, about all things Power BI at MicrosoftIgnite on September 25th, 2018.

Show Notes

About Arun
https://www.linkedin.com/in/arun-ulag-086b576/

John’s blog posts

USE POWER BI DATAFLOWS TO WAREHOUSE SHAREPOINT LIST DATA

GET THE MOST OUT OF POWER QUERY IN POWER BI DATAFLOWS

Have a question you want answered? Drop us a note or send us a .WAV file of your question at info@bifocal.show and we will answer your question on the show in our end of year wrap up show.

Episode 75 – PASS Summit News & Dataflows

Thisis episode 75 recorded on November 9th, 2018 where John & Jason talk aboutthe news coming out of PASS Summit and break down the introduction of Dataflows.

Show Notes

Power BI delivers dataflows, enterprise reporting, and major updates to Power BI Desktop

https://powerbi.microsoft.com/en-us/blog/power-bi-delivers-dataflows-enterprise-reporting-and-major-updates-to-power-bi-desktop/

  • Dataflows expand self-service data prep in Power BI
  • SQL Server Reporting Services technology now in Power BI
  • Power BI Desktop November Update
    • Will cover in detail on a future show once this drops

Introducing: Power BI data prep with dataflows

https://powerbi.microsoft.com/en-us/blog/introducing-power-bi-data-prep-wtih-dataflows/

  • Self-service data prep for big data in Power BI 
  • Advanced Analytics and AI with Azure
  • Support for the Common Data Model
    • Getting started with self-service data prep
    • Ingesting large amounts of data with Incremental Refresh
    • Building complex ETL projects with Linked entities
  • Gaining further insights with Computed entities
    • Connecting datasets to your data

Public Preview of Paginated Reports in Power BI Premium Now Available

https://powerbi.microsoft.com/en-us/blog/public-preview-of-paginated-reports-in-power-bi-premium-now-available

Power BI Paginated Reports also available in Power BI Mobile Apps(preview)

https://powerbi.microsoft.com/en-us/blog/power-bi-paginated-reports-also-available-in-power-bi-mobile-apps-preview

Paginated report metrics and dataflow metrics now available in Premium Capacity Metrics app

https://powerbi.microsoft.com/en-us/blog/paginated-report-metrics-and-dataflow-metrics-now-available-in-premium-capacity-metrics-app/

Premium Capacity Metrics app – query metrics histogram now available

https://powerbi.microsoft.com/en-us/blog/premium-capacity-metrics-app-query-metrics-histogram-now-available/

 

Episode 74 – Interview with Amir Netz

This is episode 74 recorded on September 24th, 2018 where John & Jason interview Amir Netz, Technical Fellow and Chief Architect of Microsoft BI offerings at Microsoft, about all things Power BI.

Show Notes

About Amir
https://news.microsoft.com/stories/people/amir-netz.html

Elly Gotz’s story
http://fortune.com/2018/11/01/pittsburgh-synagogue-shooting-holocaust/?fbclid=IwAR2SdrRuhIWYVRhH8-vsEmHVfhQ-VLmP7udG0wHsHHVuMpdmKkKn0NovK9s

Chris Finlan’s blog post: “Export to PowerPoint is now generally available and looking ahead at what’s coming next”
https://powerbi.microsoft.com/en-us/blog/export-to-powerpoint-is-now-generally-available-and-looking-ahead-at-what-s-coming-next/

Last week’s interview with Chris Finlan
https://www.bifocal.show/2018/10/30/episode-73-interview-with-chris-finlan/

Episode 73 – Interview with Chris Finlan

This is episode 73 recorded on October 22nd, 2018 where John & Jason talk to Chris Finlan, Senior Program Manager for Power BI at Microsoft, about the Power BI Report Server, Paginated Report in the cloud via Power BI, and much more.

Show Notes

Power BI Report Server release timing update

Chris Finlan on Twitter

PASS Summit (Focus Groups)

Episode 72 – October Power BI Desktop Update

This is episode 72 recorded on October 19th, 2018 where John & Jason talk to about the October release of Power BI Desktop, and a little about publish to web reports.

Show Notes

Reporting

Modeling

Analytics

Custom visuals

Data connectivity

Data preparation

Other

Dave Ruijter’s Public Reports Gallery

https://link.bifocal.show/ruijter

Power BI Report Server release timing update

https://powerbi.microsoft.com/en-us/blog/power-bi-report-server-release-timing-update/

September Desktop Episode

https://bifocal.show/2018/09/18/power-bi-desktop-ignite-session-picks/

Episode 69 – Interview with Sundeep Meda

This is episode 69 recorded live in Orlando at Microsoft Ignite September 26th, 2018 where John & Jason talk to Sundeep Meda Senior Software Engineer at Microsoft, along with Adam Saxton, live at Microsoft Ignite 2018 about RDL in the Cloud, field listener questions, the Power BI webpart in SharePoint Online, updates to Report Builder & Report viewer, Row level security in Power BI Report Server, and much more. This is the second part of the live recording done from the podcast studio at Microsoft Ignite 2018.

Video Version

Show Notes:

Ignite Session – THR2052 – Microsoft Power BI: End-to-end enterprise data reporting Report Viewer Web Part for SharePoint

Guy In a Cube YouTube channel

Episode 68 – Live from Ignite with Adam Saxton

This is episode 68 recorded live in Orlando at Microsoft Ignite September 26th, 2018 where John & Jason talk to Adam Saxton, Microsoft’s “Guy in a Cube”, live at Microsoft Ignite 2018 about the new XMLA end points, Certified Data Sets, the shift to focus on Enterprise BI with Power BI Premium, the new ALM Toolkit, and much more.

Video Version

Show Notes:

Guy In A Cube – YouTube Channel

Power BI “Keynote” at Ignite – BRK2148 – Microsoft Power BI: The future for modern and enterprise BI

Ignite Session – BRK3400 – Microsoft Power BI: Deploying and managing Premium capacities to your entire organization (Josh Caplan and Adam Saxton)

Ignite Session – BRK3106 – Microsoft Power BI: Embedding analytics in your apps and portals (Adam Saxton)

Ignite Session – BRK3108 – Microsoft Power BI: Distributing insights and governing self-service analytics with the Microsoft Power BI service (Lukasz Pawlowski and Adam Saxton)    

Episode 67 – Interview with Josh Caplan

This is episode 67 recorded live in Orlando at Microsoft Ignite on September 25th, 2018 where John & Jason talk to Josh Caplan, Sr. Program Manager for Power BI, live at Microsoft Ignite 2018 about Power BI Premium, the new XMLA end points, and much more. .

Video version

Show Notes:

For the video of this interview, check out our channel on YouTube –https://www.youtube.com/watch?v=cGLwGcWtR94    

Ignite Session – BRK3400 – Microsoft Power BI: Deploying and managing Premium capacities to your entire organization (Josh Caplan and Adam Saxton)