We are a group of Power BI users and data enthusiasts, interested on leveraging data analytics in real business scenarios. Our group will cover several areas, from Data Engineering, Data Modelling, Data Visualization, to more advanced analytics such as Machine Learning, Storytelling or Open Data, always learning from peers and industry experts.
Why Power BI? Power BI is creating a real buzz in the business analytics space, counts with more than 5 million subscribers. It allows Business users to get data from almost any source, perform sophisticated data preparation and data modelling and then build powerful dashboards. Predictive Analytics, Data Visualization, Storytelling, Natural Language Processing, are some of the more advanced capabilities we want to explore as well!
In our meetings, we usually have a general presentation about important news, updates and meetup content. Then we’ll offer a mix of introductory talks, workshops, live demos and deep dive sessions from experts as well.
We meet monthly on the first Tuesday of the month. Please come along - you will be sure of a warm welcome from the organizers and the community.
Meetups are organized as discussions and all questions and experiences are welcome. Tell us about your cases using the above mentioned tools and we’ll find the best solution for you as part of the meeting to share the experience with other group members.
Looking forward to exploring the outdoors with everybody.
Once you have built a Power BI dataset there are several options for displaying the data in it: classic Power BI reports, paginated reports and Excel. This session is all about the third option, Excel. You’ll learn how to connect Excel to a Power BI dataset and use PivotTables, Excel cube functions and the new Excel data types to build reports. You’ll also get a sneak preview of upcoming functionality which allows your Power BI-connected Excel reports to work in the browser and not just in Excel on the desktop.
About the Speaker: Chris Webb is a member of the Power BI Customer Advisory Team at Microsoft. He specialises in Analysis Services, Power BI, M, MDX and DAX. He is the author of "Power Query for Power BI and Excel" and a co-author of "SQL Server Analysis Services 2012: The BISM Tabular Model", "Expert Cube Development with SQL Server 2008 Analysis Services", and "MDX Solutions with Microsoft SQL Server Analysis Services 2005 and Hyperion Essbase"; he also co-authored the white paper "Planning a Power BI Enterprise Deployment". He blogs at http://blog.crossjoin.co.uk