Microsoft Business Intelligence power bi
Hafnarfjörður, Capital Region, Iceland
Á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 the co-author of Pro Power BI Administration from APRESS and the Power BI MVP book
Ásgeir is passionate about data and loves solving problem with BI.
Power BI Administration and Governance
In this training session we will cover everything you need to know as a Power BI administrator or Power BI responsible. We will use theory and practice to learn concepts and apply them.
We will provision a Power BI environment, we will look at the main settings and figure out which of them are important and how the should be set according to best practices. We will then setup Power BI premium and look through the administration options when it comes to dedicated capacity. We will investigate the role of the Enterprise Gateway, set it up, configure it and talk about how to administer it. We will look at Power BI governance and see how you can set governance strategy, create processes and roles and lastly but not least how you can monitor your Power BI environment.
This course trains Power BI Administrators, lead developers, governance responsible and other with interest in Power BI Administration and Governance in the concepts and best practices of the subject.
1. Introduction – 15 min
2. Power BI Administration – 1,5 hour
3. Power BI Premium – 1 hour
4. Enterprise Gateway administration – 30 min
5. Introduction to governance – 15 min
6. Governance strategy – 15 min
7. Governance Best practices – 1 hour
8. Monitoring – 2 hours
9. Training – 30 min
10. Roles – 30 min
11. Wrap up – 15 min
In this course we will learn tips and tricks to add onto your prior knowledge of Power BI.
The emphasis is on tips and tricks that can help the participants take the next step in their Power BI journey as well as best practices in Power Query, data modelling and reporting.
We will cover more advanced techniques in Power Query, data modelling best practices, report design and storytelling techniques.
Power BI comes in two different versions, free and paid. This course will use the free version so there is no need to have any kind of Power BI license to attend the course.
The participants need to come with their own laptop with Power BI Desktop installed.
The course contains the following:
Ingesting data in Power BI Desktop
• Importing data from folder
• Pivot and Unpivot
• Add columns
• Append and Merge queries
• Last updated date
• SharePoint and OneDrive for Business as source
• Organizing queries
Modelling in Power BI
• Star schema
• Different cardinality
• Modelling views
• Auto Date/Time Hierarchies
• Row level security
• Power BI Theming
• Background images
• Custom visualizations
• Storytelling with bookmarks, drillthrough, report page tooltip and DAX
• What is Power BI data flows?
• Reusing your logic
• Scheduling and sharing
What you gain from the course:
• Advance your Power BI skills
• Learn best practices
• Learn tips and tricks when importing data
• Learn to present more compelling reports
Who should attend this course:
This course is best suited for users with some Power BI knowledge that want to take the next step in their Power BI journey. It is assumed that the participants know the basics of Power BI and how some experienced in using it.
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.
In this session we will create an Power App that will allow users to checkin their location. We will then create a Flow that will take that location and write to a Power BI data source and refresh it. We will then create a Power BI report that will display the data on a map.
Power Apps is a great tool that allows you to create a desktop or mobile app with minimal coding. The app we are creating in this session uses the Bing location services to get the users location when a button is pressed. Microsft Flow is similarly a tool that allows you to create data flows and logic with minimal coding. The flow we create in this session will take the location and user information and write it to a Excel. We will then create a custom connector in Flow that will allow us to refresh a Power BI data set. This will mean that the data will be visible in the Power BI report almost as soon as the user presses the checkin button. Power BI is a self-service reporting tool that allows you to connect to multiple data sources and mash up data into a beutiful report or dashboard. In the report we will create in this session we will connect to a Excel file with the location information in it and display it in a report including the location on a map.
The audience will take away useful information about Power Apps, Flow and Power BI including all the code created during this demo.
When your development team is up to a certain size and often no matter what size it is you want to start following best development practises. These include things like source control, multiple environments, deployment processes and governance.
As Power BI content is developed using Power BI Desktop and not Visual Studio as most Microsoft BI solutions are these things can get tricky.
In this session we will look at what Power BI has to offer when it comes to development lifecycle. We will look at the different options available to the developer when it comes to source control, dev, test and production and deployment of Power BI content. We will then look at the different options when it comes to distribution of content to the end user. Lastly, we will look at governance and see how it is possible to secure the content and audit the usage of Power BI.
You have created great cubes, Power BI reports and Reporting Services reports but how do you know if it is being used? Learn how to set up the collection of the usage data and how you can use this data in your decision making.
We will talk about how to collect the data, how to build something meaningful from the data and how you can report on top of the data. We will do this for SSAS cubes (tabular and multidimensional), for Power BI reports and for Reporting Services Reports and we will explore ways you can further develop this for your own organization.
At the end of the session all participants will leave with all the code as well as the know how to get started with the collection of usage statistics for their Microsoft BI Solutions.
Have you ever wanted an overview of your cubes and their dimensions, attributes and measures?
This session will show you how you can use Analysis Services DMVs to extract information about your cubes and collect it for later use. We will then see how you can report on top of it thus documenting your SSAS cubes. We will then hear about different scenarios where this data might be useful.
By attending this session, you will learn how to extract, transform and load the data into a database using SSIS. You will learn how you can create reports that show you the relevant information for different scenarios and how my company is making use of these information for different purposes. Some of the use cases for this data can be aligning dimensions across cubes or creating a bus matrix for documentation purposes.
At the end of the session the attendees leave with all the code needed to start on their own as well as the knowledge on how to extend and further the solution for their own company or clients.
In this session we will hear about a method to govern your Power BI environment. This method is built upon my experience as a Power BI lead for a multinational company as well as my work with various customers of different sizes.
In my experience many organizations start thinking Power BI governance too late. Users are already working with Power BI and used to be in the Power BI Wild West. No matter if you are starting your Power BI journey or already in the Power BI Wild West this session will help you start with Power BI governance or enhance your existing one.
The method has four main pillars:
All these pillars are equally important but with different complexity. We will dive into each pillar and look at examples on documents and implementation methods. We will then bind it all together into a cohesive method and suggest how to approach the implementation.