What's going on in my Power BI Environment & Automating your documentation for AS & Power BI Models
03/06/2020
Ásgeir Gunnarsson (North Insights)
What’s going on in my Power BI Environment
As Power BI is a self-service tool, it can be hard for administrators to monitor it. Power BI is fast improving in this context but there still isn’t a consistent way of monitoring it. There are compliance, governance, performance, and implementation questions to consider. Who is creating content, how is it being distributed, what data is being used, dataset refreshes, who has a trial license, and what report is the most used? These are just some of the questions you as an administrator of Power BI might want to get answers to.
In this session, we will look at how you can find those answers by monitoring Power BI. We will look at the Power BI Audit log for usage, license, and other audit information. We will look at what the Power BI API can show us about data sets, refresh history, Enterprise Gateway information, premium capacity, and artifact inventory.
Lastly we will show how you can automate the data collection via Azure and PowerShell and report on the results.
Bent Nissen Pedersen (Datheos)
Automating your documentation for AS & PBI Models
Everyone know how difficult it is to keep your documentation up to date and available for the business and super users. There is a solution for that and it utilises automated build, Tabular Editor, Jekyll and a website.
As part of this session you will learn how to use Power Shell and information in a SQL Database to automate documentation and insights for your Analysis Services and Power BI Models. This will ensure that business can access business context, security setup and details information on how the solution is build.
You will learn and get the details for you to set this up and start reducing the time between implementation and documentation available.
Speakers
Ásgeir is a Data Platform MVP and owner of North Insights IVS. He works on Business Intelligence solutions using the whole of the MS BI stack. Ásgeir has been working in BI since 2007 both as a consultant and internal employee. Before turning to BI Ásgeir worked as a technical trainer and currently teaches BI courses at the Continuing Education Department of the University of Iceland.
Ásgeir speaks regularly at events both domestic and internationally and is the group leader of the Icelandic PASS Group as well as the Icelandic Power BI user group.
Ásgeir is passionate about data and loves solving problem with BI.
He has worked both as an internal and external consultant for a variety of companies across many industries. Most recently, he has concentrated on working with devOps, Automation, testing and simplifying development processes for Microsoft BI and Azure Data Platform. Ever since he started working with business intelligence, Bent knew that it was his true passion. As a consultant he gets to assist customers with a range of challenges, and he appreciates the ability to collaborate creatively with his colleagues and the customer teams to solve problems. Producing great solutions has been a daily joy for him. Investigating the newest versions of technology, keeping up with the communities and learning how to enhance solutions with innovative methods has been a continuous development path for him – Bent truly loves his job!
Agenda
| 18u30 | Welcome and introductions |
| 18u45 | What’s on in my Power BI Environment (60 minutes) |
| 20u00 | Automating your documentation for AS & Power BI Models (60 minutes) |
| 21u00 | Sessions end |
A 15 minute break will be held in between sessions.
Location
Virtual Meeting (LINK)