In this episode of Kasper On BI we are talking about AI, LLM’s and CoPilots. This is such a hot topic in the industry that I wanted to take the opportunity to learn more about it. Starting with what is Artificial Intelligence? How does it work? What are models? How are they trained and what are some use cases? Then we will discuss LLM’s (Large Language Models) and what they are and how they work. Why are they so popular and what use cases do they help with?  Then finally we cross over to CoPilot in Fabric and how they work. We close off talking about the future of AI, what are the concern ..read more

In this episode of Kasper On BI we are talking about Power BI embedded. Power BI is something that we don’t often think about as BI practitioners but can play a central part to extend Power BI in your own portal for users, partners and customers using your own UI and security systems while still levering all the cool capabilities of Power BI. With Power BI embedded you also extend and modify reports and datasets even further through code. In this episode we will discuss all of this in detail. The expert on today’s episode is Ted Pattison, Ted is Principal Program Manager at the Microsoft Fabri ..read more

In this episode of Kasper On BI we are talking about the rise of self-service BI and how that is different from traditional BI. It had fundamental changes to how we work, not just for the organizations themselves but also for the consulting firms. We also talk about the early days of BI in Excel and Power BI with the development of PowerPivot for Excel. The expert on today’s episode, Rob Collie, had a front seat to all of it. Rob runs a Power BI consulting firm, is a former Microsoft PM that worked on Excel, the early days of DAX and PowerPivot before becoming the world’s first PowerPivot cele ..read more

In this episode of Kasper On BI we are talking about AI, Machine Learning and Power BI. What is AI and Machine Learning? What is the difference? How has it evolved over time? What is the future and how can we use it in Power BI? The expert on today’s episode is Rafal Lukawiecki. Rafal is a Data Scientist at his training and consulting company Project Botticelli Ltd. He has been around for over a decade starting with OLAP and traditional BI but fell in love with the Microsoft data mining addins and started going down the ML and AI path. He has been an expert in this area for many years now and ..read more

In this episode of Kasper On BI we are talking about the history of Business Intelligence at Microsoft with one of the early founders and Technical Fellow at Microsoft Amir Netz. We talk about the rise of MOLAP and the dominance of Enterprise BI at Microsoft and the rise of Self-service BI tools that brought Microsoft to a tipping point. With that came the rise of PowerPivot with its groundbreaking column store engine VertiPaq, PowerView with new ways to present data and PowerQuery to transform and connect to any data. All of this turned into Power BI as we know it that is again dominating the ..read more

In this episode of Kasper On BI we are talking about rolling out Power BI in a large organization. What is a Center of Excellence? How does a it help your users get more of out their data? What are the roles and responsibilities for the COE? Finally, how to guide users that need to make decisions with data but don’t have a BI or programmer background. The expert on today’s episode is Alex Garcia. Alex is the head of a Power BI Centre of Excellence for a multi-billion organization. Here he is managing one of the largest Power BI implementations in the world. Working towards aiding the busi ..read more

Some time ago I had the honor to be a guest on the Raw Data By P3 podcast. The episode got released yesterday. I had a lot of fun here, it was great to catch up with @robcolli3 and @SQLRockstar and talk about the rise of #powerpivot and #powerbi, basketball, rising sea levels and working at #microsoft! They also made this awesome Gif that I wanted to share here: Listen to it here: Kasper de Jonge | P3 (powerpivotpro.com) The post Guest on the Rob Collie (PowerPivotPro), Raw Data By P3 podcast appeared first on Kasper On BI ..read more

In this episode of Kasper On BI we are talking about Power BI Dataflows, how to position it, where to use it and general best practices. The expert on today’s episode is Matthew Roche, Program Manager on the Power BI Customer Advisory Team. Matthew has a wealth of background in software development and teaching before joining Microsoft. At Microsoft he worked on SSIS, MDS and data lineage before joining the Power BI CAT team where he works with large enterprise customers today. One of his passions is Dataflows and he will share his thoughts about how to position dataflows (do we still need a d ..read more

On this episode of Kasper On BI we are talking with Kim Manis, Kim is the group Program manager on the Power BI team responsible for all creation and consumption of content (this includes Power BI desktop). In this episode we talk about what how she got started at Microsoft and what it means to be a Program manager. We will also discuss how features at get prioritized; how do we pick the features to work on and deliver? With her background in startups too we are talking about the difference between shipping features in both. The Podcast of this episode is available here: https://www.kasperonb ..read more

I have been spending less time on blogging as I am spending more and more time on my new Kasper On BI format. In this episode of Kasper On BI we are talking about on making the journey from Excel to Power BI with Shannon Lindsey. Shannon has no computer background but gradually starting to work with data through Excel. Then she found PowerQuery in Excel which led to Power BI. We will talk about how she learned these new tools and what the challenges were along the way. You can listen to the podcast of this episode on Itunes or Spotify or listen to it here: Kasper On BI on the journey from Exc ..read more