Posts filed under Topics & Discussion

Simplifying [DAX] with Staging Tables & Relationships in Power BI

Video by: Reid Havens

Learn how to leverage model tables/columns, and relationships to simplify your DAX code for your Power BI datasets (models), leading to simpler measures, and potentially more efficient (faster) calculations and visual queries. Tune in to learn more!

(Livestream Replay) The Unplanned Career: 25 Years in Tech Without a 3 Year Plan - with Matthew Roche

DESCRIPTION 📄

Matthew Roche has been working in technology for 25 years, including time spent as a trainer, mentor, consultant, developer, and architect. He's been self-employed, he's co-founded startups, he's worked for small- and medium-sized companies, and for the past 13 years he's been a program manager at Microsoft, working on a wide range of products and services. Starting from humble beginnings, Matthew has achieved successes he could never have imagined...

...but he has never had a plan.

If you've ever looked at people planning their careers but have never quite gotten started on your own, don't despair - this might just be the session you've been looking for.

In this candid talk, Matthew will reflect on the ups and downs of his career and share some of the lessons he's learned along the way. No matter where you are on your career path, there will be something you can take away from this session, which is part inspirational success story, part cautionary tale, and all unplanned.

GUEST BIO 👤

Matthew Roche is a Principal Program Manager in Microsoft’s Cloud + AI Group, where he focuses on data culture, business intelligence, enterprise information management, metadata, and data warehousing. Matthew is currently a member of the Fabric CAT team, where he was saddened to learn that there were not actually any cats. Previously Matthew has worked on Power BI, Azure Data Catalog, Power BI for Office 365, SQL Server Integration Services, Master Data Services, and Data Quality Services. Before joining Microsoft, he worked as an architect, consultant, and trainer focusing on ETL, data warehousing, and business intelligence.

RELATED CONTENT 🔗

Matthew's Blog
Matthew's LinkedIn
Matthew's Mastodon

Posted on July 7, 2023 and filed under Livestreams, Topics & Discussion.

Engaging Q&A and Discussion (with Amir Netz) - Microsoft Fabric's CTO !!

DESCRIPTION 📄

Please join Microsoft Fabric's CTO Amir Netz and me as I host this special livestream where we'll have an engaging discussion and audience Q&A on everything Microsoft Fabric. We'll discuss everything from: data and AI, Synapse, Spark/Notebook, OneLake/DirectLake, and what Fabric means for the future of Power BI. Tune in to find out!

GUEST BIO 👤

Amir Netz is a Technical Fellow and the Chief Technology Officer of Microsoft Fabric.

Microsoft Fabric is a complete, unified, SaaS data platform that brings together all tools that organizations need to run their data estate. Fabric integrates technologies like Azure Data Factory, Azure Synapse Analytics, and Power BI into a unified product, empowering data, and business professionals alike to unlock the potential of their data and lay the foundation for the era of AI.

Before that Amir served as the founder and CTO of Microsoft Power BI.

Used by 98% of the Fortune 500 companies, Power BI is widely recognized as the market’s leading Business Intelligence product, with the fastest growth and the highest usage.

Amir is the leading world expert in BI and Business Analytics technology. The products invented, designed, and developed by Amir have repeatedly defined the business analytics market. In 1997 Amir founded SQL Server Analysis Services, a product that with its ease-of-use and low-cost had democratized the BI industry and quickly became the most popular BI server in the world. Today, Power BI is driving a similar transformation in the Cloud.

The technologies that Amir invented are shipping as part of SQL Server, Excel, and the Microsoft Power Platform. Some of his latest contributions include VertiPaq, Microsoft’s revolutionary in-memory column-oriented data engine that excels at performance and flexibility for data analysis, Q&A – the natural language BI exploration experience, Dataflows – a popular self-service data preparation platform, and the Power BI experience – for interactive ad-hoc data visualization and exploration.

The special designation of “Technical Fellow” is Microsoft’s acknowledgement of the key role a top technical leader plays in driving intentional innovation with broad industry impact. A Technical Fellow's technical vision, expertise and world-class leadership is commensurate with that of a corporate vice president focused on business leadership.

RELATED CONTENT 🔗

Power BI Blog—Updates and News | Microsoft Power BI
Amir Netz (@AmirNetz) / Twitter
Amir Netz | LinkedIn

Posted on June 30, 2023 and filed under Livestreams, Fabric, Topics & Discussion.

(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.