(Livestream Replay) The Data Dojo: A Power BI Community of Practice - with James Bartlett

DESCRIPTION πŸ“„

In recent years, data-driven decision making has become the gold standard for all organizations, and data literacy is more important now than ever before. Organizations large and small must become intimately familiar with their data or risk falling behind the competition and fading into irrelevance. One of the best ways to foster an active, passionate data culture within an organization is to establish a Community of Practice around the technologies the organization uses to process, store, analyze, and consume data.

Join us as we discuss the founding and early stages of The Data Dojo: a Power BI Community of Practice which was established at Des Moines University to facilitate the sharing of knowledge and experience among faculty and staff interested in analyzing data generated by the various departments and other business units in the organization.

We'll also talk about the founding principles and structure of the Data Dojo, some of the topics we've covered at our workshops, what has gone right, what we could have done better, and what we're planning for the future.

GUEST BIO πŸ‘€

James D. Bartlett III is a Senior Business Intelligence Analyst and Power BI Administrator at Des Moines University in Iowa, USA. He started working in IT way back in 2002, while he was a student in the Business Administration program at Colorado State University. After graduation, James dabbled in banking, real estate, healthcare, and even had a short stint as a resident DJ at Denver's top nightclub, before finally stumbling upon his true calling in the Business Intelligence field in 2018.

James is a Microsoft Certified Power BI Data Analyst Associate, co-developer of the Business Ops and Power BI Version Control apps on PowerBI.tips, and co-leader of the Iowa Power BI User Group. In his spare time, James enjoys longboarding, playing the guitar, and producing electronic music in his home studio.

RELATED CONTENT πŸ”—

James Bartlett's Website & Blog
James on LinkedIn
James on GitHub
James on Mastodon
James on Sessionize

Posted on June 23, 2023 and filed under Livestreams, Topics & Discussion, Training & Teaching.

New (AND IMPROVED) Native Card Visual for Power BI !?!

Video by: Reid Havens

Let's explore the NEW and IMPROVED native card visual for Power BI! Not only does it allow multiple values, but it has a lot of additional formatting options, support for SVG charts, and more. Tune in to find out!

RELATED CONTENT πŸ”—

Auto Scaling DAX Formatting
SVG Image Charts
IBCS Inspired SVG Charts

(Livestream Replay) Building Multi-language Reports for Power BI - with Ted Pattinson

DESCRIPTION πŸ“„

Power BI has a history which has made it challenging to build reports that support multiple languages. Fortunately, enhancements to Power BI over the last year have reduced this challenge making it more attainable to Power BI content creators. As an example, Power BI added support for the USERCULTURE function which provides the ability to write measures which implement report label translations dynamically. Power BI enhancements to the report designer now provide more flexibility to bind measures with dynamic translations to visuals and shapes so they can be surfaced on report pages. Furthermore, the recent introduction of Field Parameters in Power BI now offers a far more elegant and efficient strategy to implement data translations.

In this Livestream session, Ted Pattison will discuss how to get started with multi-language report development. Attendees will learn about the three different types of translations involved with multi-language report development as well as the techniques used to implement them. Ted will demonstrate using the Translations Builder utility to automate repetitive localization tasks that would take forever to complete manually. This session will provide content creators using Power BI Desktop with a better understanding of how all the pieces fit together and with a path forward for building multi-language reports in Power BI using a strategy that is reliable, predictable and scalable.

GUEST BIO πŸ‘€

Ted Pattison worked as an independent trainer and software developer whose community efforts earned him the Microsoft MVP award for 15 years in a row. Ted joined the Power BI Customer Advisory Team (PBICAT) at Microsoft in 2020 where he provides guidance to enterprise customers and ISVs in several areas including developing with Power BI embedding, programming with the Power BI APIs and building multi-language reports.

Ted is also the creator of Power BI Dev Camp (https://www.powerbidevcamp.net) which provides a monthly webinar geared toward professional software developers working with Power BI, Fabric and the Microsoft Data Platform.

RELATED CONTENT πŸ”—

Building Multi-language Reports (Guidance Doc)
Building Multi-language Reports (Hands-on Lab)
Building Multi-language Reports (YouTube Video)
Building Multi-language Reports - Part 2 (YouTube Video)
Translations Builder Utility on GitHub
Live Sample of Multi-language Report

(Livestream Replay) Connecting API's with Power Query - Not so Low Code? - with Erik Svensen

DESCRIPTION πŸ“„

In this session Erik will demo how you can get data from web api's and how you can ensure that your model can be refreshed in the service.

We will by using real life examples walk through how to connect to different web api's and how different API's have different authentication methods that you will have to understand and master.

We will look at how you can parameterize your queries and only get the data for a specific period or other ways of specifying parameters that the API supports.

In the session you will also learn how to do a POST request to an API.

And YES we will spend a lot of the time in the Power Query Advanced editor.

After the session you should have a good start so that you can connect to the API's that are relevant for you.

GUEST BIO πŸ‘€

Erik Svensen is a Microsoft MVP. Erik has been working with the Microsoft BI stack for more than 20 years - starting with out with Excel and Microsoft Query for over 25 years ago. He owns the company CatMan Solution who is now serving over 70+ FMCG suppliers with a Power BI solution that provides the supplier with valuable insights in their performance at store level based on point of sales data provided to them by different retailers. He started the Danish Power BI User group and speaks at conferences and meetups. Another great passion besides Power BI is his collection of Danish contemporary art. And if he finds time he occasionally blogs about Power BI as well.

RELATED CONTENT πŸ”—

Erik's Blog
Erik's LinkedIn
Erik's Twitter
CatMan Solutions
Slide Deck Link

Posted on June 9, 2023 and filed under Livestreams, Power Query.