Thank You for Attending in Copenhagen

The Power BI World Tour made a stop in Copenhagen 28-29 August, 2017 and provided unprecedented access to premium Power BI content designed by your local PUG team.

The stop allowed Power BI users to connect and dive deep with hundreds of peers and industry experts through twenty seven sessions targeted for the Business User, Business Analyst, Power User, or Techie. 

Time: Monday, August 28, 2017 (9:00 AM) to Tuesday, August 29, 2017 (5:00 PM) (Romance Time)
Location: Microsoft Office, Kanalvej 7, 2800 Kongens Lyngby, Denmark (Map & Directions)

Read the Copenhagen Recap blog.

Stay connected



Join the virtual Denmark Power BI User Group community and continue the conversation and learning.

Visit Community

AGENDAS

Agenda is subject to change without notice.

Tracks below for Newbie/Business Users, Enterprise Business Intelligence Users, and Technical Users are just general guidelines based on interest and experience. An attendee may switch tracks or sit in on any class below at any time.

08:30 - 09:30Registration and Networking Breakfast
09:30 - 10:30General Session: Microsoft Roadmap | Room: CUST 0.01
Kasper de Jonge - Senior Program Manager - Nikil Gaekwad - Microsoft World Tour Power BI Keynote
With weekly and monthly releases, there are a lot of fantastic new Power BI features to explore. In this session, we will have an overview of what has been just released in Power BI and a look forward. Drill down topics to include the new collaboration features, in the cloud-based business analytics service, the new authoring and modeling features of Power BI Desktop, extending your reach to mobile applications, new Power BI resources and finally, what is new for developers leveraging the Power BI platform.
10:30 - 10:45Session Break (Refreshments)
10:45 - 11:45From Excel to Power BI | Room: CUST 0.02
Erik Svensen - Partner& CEO - CatMan Solutions A/S
This session will take you through the different elements of Power BI and demonstrate how Power BI can replace your Excel models/reports or use it as a complementary tool in your BI Tool belt. You will be introduced to Excel Power Query, Power BI Desktop and the Power BI service and after the session you will have a good overview of the different elements in Power BI – all done via different examples highlighting the benefits of combining Excel and Power BI.
11:45 - 12:45Networking/Lunch N' Learn - 30-min Sponsor Showcase Session (starts at 12:15) | Room: CUST 0.01
Kapacity
11:45 - 12:45Networking/Lunch N' Learn - 30-min Sponsor Showcase Session (starts at 12:15): Comment Your Data | Room: CUST 0.02
Steffen Bendorff Fallesen - Client Director & Partner - Accobat
Your data does not really say anything, so make sure they talk to your users. Add comments and actions in Power BI and add value to the information your data contains.
11:45 - 12:45Networking/Lunch N' Learn - 30-min Sponsor Showcase Session (starts at 12:15): How to Analyze Sales Data With Power BI and Combine it With Actions Using Power Apps | Room: CUST 1.11
CatMan Solutions A/S
12:45 - 13:00Session Break
13:00 - 14:00Connect to Data in Power BI Desktop | Room: CUST 0.01
Just Thorning Blindbæk
With Power BI Desktop you can easily connect to the ever expanding world of data. This session gives an introduction to all the different sorts of data sources there is available including pros/cons of importing data contra live and direct query.
14:00 - 14:15Session Break
14:15 - 15:15Take Your First Steps Towards Power BI by Using DAX | Room: CUST 1.11
Chris Woolderink - PBIG
Power BI is the most beautiful girl (or boy!) in the classroom. She is getting all the attention, but only a few have the courage to take the next step and initiate a chat. In order to be successful, you must also be able to express yourself. Then you realize that you need to speak a language called DAX. The goal of this session is to give you enough courage to make that initial move and start interacting through DAX.
15:15 - 15:30Session Break (Refreshments)
15:30 - 16:30The Importance of Data Visualization – Tips and Tricks for Standard Visualizations | Room: CUST 0.02
Lasse Matthias - Consultant & MSC in Applied Economics and Finance - Accobat
The concept of Data visualization is a cornerstone in building analytical reports for Power BI. If implemented correctly it can help users understand highly complex information in only a matter of seconds. However, if no considerable consideration is given to the subject, it can lead to confusion and misunderstandings. This session takes the user on a short journey through the importance of data visualization, and provides them with some easy to implement tips and tricks for the standard visualizations already embedded in Power BI.
16:30 - 18:00Welcome Reception (Social & Networking)
07:30 - 08:30Networking Breakfast
08:30 - 09:30Sports Analytics - Lionel Messi | Room: CUST 0.02
Tristan Malherbe - Data and BI Consultant - AZEO
This presentation will explain a Power BI dashboard on the football player Lionel Messi. We will be in the eyes of an analyst who wants to get actionable insights from data. The following topics will be covered: Data import & cleansing, Power Query functions, building a data model, analyzing the data with DAX measures, creating user-friendly dashboards. As well as some Power BI tips & tricks.
09:30 - 9:45Session Break (Refreshments)
9:45 - 10:45Power BI using Parameters and Templates | Room: CUST 0.02
Lars Andersen - TSP - Microsoft
Consuming Power BI content in the service or on a mobile device is fantastic for ordinary end users, but what if some of these end users would like to try to build Power BI content in Power BI Desktop - and you do not want to scare them away with no data model and a blank canvas? Join this session to learn how you easily can extent usage of Power BI Desktop in your organization and make the business users add value to data models and visualizations. Learn how you can build parameterized Power BI Desktop reports, e.g. making it easy to change from dev to test to production data sources. You will also learn how you can distribute Power BI Desktop reports without sharing the data you have access to.
10:45 - 11:00Session Break
11:00 - 12:00How to Make Business Data Understandable at a Glance | Room: CUST 0.01
Kasper Ulvedal - Anvido
Excel does not make you a world class math or statistics genius. Word doesn’t make you a famous writer. Neither does Power BI make you a brilliant Data Visualization specialist. In this session, you will learn various data presentation techniques and the does and don’ts of world class Data Visualization. A revolution of the data industry is going on these days - it calls for new and agile methods of working with data, and thereby new skills of data analyst and presenters. A corner stone of these skills will become Data Visualization, hence the volume of data is exploding, you must be empowered to find the needle in the haystack and present it to your audiences.
12:00 - 13:15Networking Lunch
13:15 - 14:15 Customer Story | Room: CUST 0.02
Erik Svensen - Partner & CEO - CatMan Solutions A/S
The case is a supplier to Do It Yourself and Home Design retailers, which gets a lot of POS data from these retailers. The data comes in different formats and had previously been a time-consuming task to handle. By using Power Query to extract, transform and load the data and Power BI to visualize the data – CatMan Solution has delivered a solution that easily handles the load of the data so that the supplier now can spend time on analysis and insight using these data, rather than spending time on separate data in different Excel sheets. The data can now be better used across the organization and as a valuable tool in the collaboration with the retailers to develop their business on both sides.
14:15 - 14:30Session Break (Refreshments)
14:30 - 16:00Use What You Learned | Room: CUST 0.02
If today was a whirlwind of new Power BI knowledge, this session is for you. During the session, we will learn to apply the concepts and methodologies of Power BI, such as visuals, into your real business scenarios to ensure that you walk away from Power BI Thursday with a sound understanding of how Power BI can work for you.

Business Enterprise Intelligence Users

08:30 - 09:30Registration and Networking Breakfast
09:30 - 10:30General Session: Microsoft Roadmap | Room: CUST 0.01
Kasper de Jonge - Senior Program Manager - Nikil Gaekwad - Microsoft World Tour Power BI Keynote
With weekly and monthly releases, there are a lot of fantastic new Power BI features to explore. In this session, we will have an overview of what has been just released in Power BI and a look forward. Drill down topics to include the new collaboration features, in the cloud-based business analytics service, the new authoring and modeling features of Power BI Desktop, extending your reach to mobile applications, new Power BI resources and finally, what is new for developers leveraging the Power BI platform.
10:30 - 10:45Session Break (Refreshments)
10:45 - 11:45Deep Dive Into Data Modeling Using Power BI Desktop and SQL Server Analysis Services | Room: CUST 0.01
Kasper de Jonge - Senior Program Manager - Microsoft
The Analysis Services model used in both Power BI Desktop and SSAS allows the solving of very complex modelling issues. In this session, we will look at solving several complex modeling problems, like many-to-many but also on M vs DAX and using Direct Query.
11:45 - 12:45Networking/Lunch N' Learn - 30-min Sponsor Showcase Session (starts at 12:15) | Room: CUST 0.01
Kapacity
11:45 - 12:45Networking/Lunch N' Learn - 30-min Sponsor Showcase Session (starts at 12:15): Comment Your Data | Room: CUST 0.02
Steffen Bendorff Fallesen - Client Director & Partner - Accobat
Your data does not really say anything, so make sure they talk to your users. Add comments and actions in Power BI and add value to the information your data contains.
11:45 - 12:45Networking/Lunch N' Learn - 30-min Sponsor Showcase Session (starts at 12:15): How to Analyze Sales Data With Power BI and Combine it With Actions Using Power Apps | Room: CUST 1.11
CatMan Solutions A/S
12:45 - 13:00Session Break
13:00 - 14:00Super Charge Power BI and What’s new with Analysis Services | Room: CUST 0.02
Christian Wade -Microsoft
Microsoft Azure Analysis Services enables you to build comprehensive, enterprise-scale analytic solutions that deliver actionable insights through familiar data visualization tools such as Microsoft Power BI and Microsoft Excel. This session introduces Azure Analysis Services as a fully-managed platform as a service (PaaS) in Azure. We will discuss where Analysis Services fits into Microsoft’s BI platform and strategy, reference architectures and cloud efficiencies. Modeling and analytics features covered by the last two compatibility levels will be reviewed and demonstrated, including Power Query connectivity, object-level security, and Detail Rows for non-technical users to drill through to transactional records.
14:00 - 14:15Session Break
14:15 - 15:15Creating Enterprise Grade BI Offerings with Azure Analysis Services | Room: CUST 0.01
Christian Wade - Microsoft
Microsoft Azure Analysis Services enables you to build comprehensive, enterprise-scale analytic solutions that deliver actionable insights through familiar data visualization tools such as Microsoft Power BI and Microsoft Excel. Following on from Super Charge Power BI and What’s New with Analysis Services, this session will discuss how to bridge the gap between self-service and corporate BI. Content focuses on deployment, migration, optimizing configurations, automation, application-lifecycle management (ALM), governance and management of a solution on Analysis Services. The demos will cover new features such as improved Power BI Desktop integration, Power Query connectivity, and techniques for loading large data volumes to enable the best reporting experiences.
15:15 - 15:30Session Break (Refreshments)
15:30 - 16:30Power BI for the Enterprise, Safely Sharing Your Data | Room: CUST 0.01
Nikhil Gaekwad - Microsoft
Once you finish creating a compelling dashboard, what is the best way to share it with your organization? There are many options for dashboard distribution, getting alerts, getting updates, viewing it on various devices, and much more. Learn about Microsoft Power BI for the Enterprise. We talk about security, deployment, best practices, connecting data, hybrid, Gateway, solution templates and consuming everywhere (including mobile) scenarios. Join this session to learn about Power BI for the Enterprise. We will talk about security, deployment, best practices, connecting data, hybrid, Gateway, solution templates and consuming everywhere (including mobile) scenarios. Once you finish creating a compelling dashboard, what is the best way to share it with your organization? There are many options for dashboard distribution, getting alerts, getting updates, viewing it on various devices, and much more.
16:30 - 18:00Welcome Reception (Social & Networking)
07:30 - 08:30Networking Breakfast
08:30 - 09:30Building Fast and Reliable Reporting with Power BI | Room: CUST 0.01
Nikhil Gaekwad - Microsoft
Fast reports are a delight to use. Slow reports languish into obscurity. How do we build reports that are fast and reliable? Join us for a deep dive into Power BI performance tuning and optimization. We’ll cover the basic patterns for Power BI usage, performance implications and best practices, including security, workspaces, apps and content packs, as well as RLS and more.
09:30 - 9:45Session Break (Refreshments)
9:45 - 10:45Power BI Security Deep Dive | Room: CUST 0.01
Kasper de Jonge - Senior Program Manager - Microsoft
The Analysis Services model used in both Power BI Desktop and SSAS allows the solving of very complex modelling issues. In this session, we will look at solving several complex modelling problems, like many-to-many but also on M vs DAX and using Direct Query.
9:45 - 10:45Business Developers Using Power BI for Rapidly Prototyping New Products | Room: CUST 1.13
Simon Kibsgard - Head of Digital Business Development - AS3 A/S
Power BI enables machine learning and even provides businesses a valuable start to artificial intelligence. But, Power BI is also a great prototyping tool for "data noobs", looking for quick ways to visualize and test future customer dashboards based on real (or mock) data. In few steps everyone who understand the subject, but don't know how to program or do heavy stats, can learn about interesting contexts in data, visualize these in interactive dashboards and test their relevance with the product target audience. This presentation will show how data visualization belongs to any Lean Startup / Design Sprint approach to prototyping + testing with the target audience and how Product & Business Developers can take prototyping into their own hands and reach great insights and direction before specifying for "real" pr+B18ogrammers. The presentation will present ideas and experience from a recent case in AS3, where Power BI in connection with Zapier, Firebase and several other SaaS was heavily involved in lean prototyping.
10:45 - 11:00Session Break
11:00 - 12:00Power BI in a Larger Scaled Enterprise Environment | Room: CUST 1.13
Casper Nørskov - Consultant - Inspari A/S
This presentation will take its offset in a real life case where Power BI has been implemented, and is being used, in a conglomerate with multiple companies with several departments – each working in their own specialized field and with several 100 users spanning up to around 1000 potential users. It will cover managing development and distribution of content, utilization of a platform that is almost solely based on the Microsoft Business Intelligence stack, securing and measuring user adoption/activity and much more!
12:00 - 13:15Networking Lunch
13:15 - 14:15 PowerApps and Flow | Room: CUST 1.13
Daniel Laskewitz- Business Productivity Consultant -Young Sogeti Board Member
14:15 - 14:30Session Break (Refreshments)
14:30 - 16:00Certification Opportunity | Room: CUST 1.13
(Virtual Presentation)
Ready yourself for Microsoft Exam 778 with this preparatory readiness class that will include a review of exam coverage, vital ways to prepare and additional details.
08:30 - 09:30Registration and Networking Breakfast
09:30 - 10:30General Session: Microsoft Roadmap | Room: CUST 0.01
Kasper de Jonge - Senior Program Manager - Nikil Gaekwad - Microsoft World Tour Power BI Keynote
With weekly and monthly releases, there are a lot of fantastic new Power BI features to explore. In this session, we will have an overview of what has been just released in Power BI and a look forward. Drill down topics to include the new collaboration features, in the cloud-based business analytics service, the new authoring and modeling features of Power BI Desktop, extending your reach to mobile applications, new Power BI resources and finally, what is new for developers leveraging the Power BI platform.
10:30 - 10:45Session Break (Refreshments)
10:45 - 11:45The How, Why and How Much of Embedding Power BI| Room: CUST 1.11
David Bojsen - Data Solution Architect - Microsoft
A deep dive into embedding. How is it done – how do you develop, test, deploy and redeploy. How do you license such a scenario, and which use cases makes for the best use of PBI in embedded mode.
11:45 - 12:45Networking/Lunch N' Learn - 30-min Sponsor Showcase Session (starts at 12:15) | Room: CUST 0.01
Kapacity
11:45 - 12:45Networking/Lunch N' Learn - 30-min Sponsor Showcase Session (starts at 12:15): Comment Your Data | Room: CUST 0.02
Steffen Bendorff Fallesen - Client Director & Partner - Accobat
Your data does not really say anything, so make sure they talk to your users. Add comments and actions in Power BI and add value to the information your data contains.
11:45 - 12:45Networking/Lunch N' Learn - 30-min Sponsor Showcase Session (starts at 12:15): How to Analyze Sales Data With Power BI and Combine it With Actions Using Power Apps | Room: CUST 1.11
CatMan Solutions A/S
12:45 - 13:00Session Break
13:00 - 14:00Livestreaming and IoT | Room: CUST 1.11
Jens Vestergaard - Sr. BI Architect
This session will begin, with a high level introduction to Azure Internet of Things, Windows 10 Core and Raspberry PI. Once we have established the basics about the technology, we will be connecting the dots with a live demo on some of the parts. The focus during the demo, will mainly be on Azure IoT Hub, Windows 10 Core and the Raspberry PI and how to DIY. As visualization we will be using Power BI to present the data. This session is not for the Enterprise rather has a more DIY approach.
14:00 - 14:15Session Break
14:15 - 15:15Automate Your Power BI Workflows for Continuous Integration | Room: CUST 0.02
Bent Nissen Pedersen - Senior Business Analytics Architect - Kapacity
Learn how to setup automated using the API Improvements for the Service. In addition we will be going through consideration and an example on automated test for validation of the Power BI reports in a automated setup.
15:15 - 15:30Session Break (Refreshments)
15:30 - 16:30Many to Many DAX | Room: CUST 1.11
Tristan Malherbe - Data and BI Consultant - AZEO
In this session, we will see how we can leverage Dax language to cope with a classic issue in Business Intelligence: 'Many To Many'. The following topics will be covered: tabular modeling best practices, advanced DAX concepts (context transition & expanded tables).
16:30 - 18:00Welcome Reception (Social & Networking)
07:30 - 08:30Networking Breakfast
08:30 - 09:30Making Maps in Power BI | Room: CUST 1.13
Andrea Martorana - Senior BI Developer - Banco Popolare
How many ways do you know for making maps in Power BI? Maybe two? Anything else but bubble maps and choropleth? Are you aware of the new Shape maps visual embedded in Power BI? And what about the wonderful custom visuals available for every user? 3D GlobeMap and Synoptic Panel an awesome component that connects areas in a custom image with attributes in the data model and draws the data on a map. How not to mention the new ArcGIS Maps for Power BI feature announced recently? It offers enhanced mapping capability, demographic data, and even more compelling map visualizations. And that’s not all, support for R open doors to the huge number of packages for spatial data analysis and statistical calculations included in the environment. Do you want to draw multi-layered interactive maps? Want to geocode your data with direct calls? With R in Power BI, now you can.
09:30 - 9:45Session Break (Refreshments)
9:45 - 10:45Business Developers Using Power BI for Rapidly Prototyping New Products | Room: CUST 1.13
Simon Kibsgard - Head of Digital Business Development - AS3 A/S
Power BI enables machine learning and even provides businesses a valuable start to artificial intelligence. But, Power BI is also a great prototyping tool for "data noobs", looking for quick ways to visualize and test future customer dashboards based on real (or mock) data. In few steps everyone who understand the subject, but don't know how to program or do heavy stats, can learn about interesting contexts in data, visualize these in interactive dashboards and test their relevance with the product target audience. This presentation will show how data visualization belongs to any Lean Startup / Design Sprint approach to prototyping + testing with the target audience and how Product & Business Developers can take prototyping into their own hands and reach great insights and direction before specifying for "real" pr+B18ogrammers. The presentation will present ideas and experience from a recent case in AS3, where Power BI in connection with Zapier, Firebase and several other SaaS was heavily involved in lean prototyping.
10:45 - 11:00Session Break
11:00 - 12:00All Things R with Power BI | Room: CUST 0.02
David Bojsen - Data Solution Architect - Microsoft
Let’s push the limits and see just how much you can do with R inside of Power BI. We will look both at data transformations, visualizations and how to support all of it deployed to the cloud.
12:00 - 13:15Networking Lunch
13:15 - 14:15 Top 10 Layout Tips | Room: CUST 0.01
Peter Kjær - ProActive A/S
How to make reports look good. Simple tips to attract more viewers. BI is not just about numbers creating your own KPI icons create a visual theme choosing the right background and Images.
14:15 - 14:30Session Break (Refreshments)
14:30 - 16:00Ask The Experts | Room: CUST 0.01
During this session ask the Microsoft team, MVPs, and Industry Experts the questions that you didn't get answered during the regular sessions. This session is always jam packed with information and tidbits from the brightest and the best.

Agenda Icon Legend

  • Registration
  • General Session
  • Session Break
  • Refreshments
  • Newbie/Business User
  • Enterprise Business Intelligence
  • Technical
  • Lunch/Dinner

Thank You to Our Copenhagen Sponsors

400x100mmAccobat_logo_orange_rgb_final.png

Accobat is a BI/CPM consultancy firm with offices in Copenhagen, Aalborg and Aarhus. We deliver flexible, scalable and user-friendly solutions for Corporate Performance Management (CPM) and Business Intelligence (BI) based on Microsoft technology. According to Computerworld (IDG), we are the best at BI in Denmark. Our customers like to think so too. Since 2003, we have implemented our solutions in the most progressive companies and organisations in the country.

Unknown-2.png

We work with Power BI for customers primarily within the retail industry. We provide full service cloud solution with ETL, Datawarehouse and visualization using the latest tools in the Microsoft BI Stack.

Kapacity_logo_2016_RGB_m-tagline.png

Kapacity was founded in 2008 by five ambitious partners, all with the desire to deliver world-class data warehouse and business analytics solutions.  Since then, the company has developed into one of the trendsetting players on the Danish Business Intelligence market and, today, we have offices in Copenhagen, Aarhus and Kolding. We have a nationwide presence and local resources.