In this talk you will learn how to use Power BI to prototype/develop a BI solution in days and then evolve it into a fully scalable Azure BI solution.
This is a session for the all of you with short attention spans (like me!) In this session, we will rapid fire tip after tip to help you be a better report author. We'll use the popular Microsoft tools, SSRS and Power BI.
Learn about the component of Power BI and best practices for implementations
DevOps and continuous integration provide huge benefits to data warehouse development. John will be showing how you can use VSTS and Octopus Deploy to build, test and deploy your data warehouse
DirectQuery best practices in Analysis Services and Power BI
How does Big Data with Hadoop, Cloud Computing in Azure, Self Service BI and “classic” BI with SQL 2016 interact with each other to build a modern enterprise BI architecture at InnoGames? Watch my talk and you will know!
Microsoft Power BI supports custom visuals from the Office Store ( In this session I will demonstrate what is needed for starting building your own.
Come learn how to make your BI projects perform at their max!!
It takes minutes to create and share Power BI reports and users who has relevant Power BI access can do many things in the PBI service. In this session, Prathy will show how having a deployment strategy helps maintaining Power BI service.
Microsoft announced the retirement of Power BI Embedded and recommended that everyone migrate to Power BI Premium and embed those reports. Unfortunately the documentation on doing this is "light" to say the least. This session will enlighten you
So, you think you know everything you need to know about the Power BI Report Server because you use traditional SQL Server Reporting Services. Well, don’t believe it!
One hot topic with Power BI is security, in this deep dive session we will look at all the aspects of security of Power BI, from users, logging to where and how your data is stored andleverage additional Azure services to secure it even more.
In this session, I'm going to show you six amazing tools that must be in your developer/consultant toolbelt. These tools help you develop, manage, monitor and optimize your Tabular model, in other words, it makes your day to day job easier.
Text analysis of financial documents using R & Power BI.
In this session we will look at all the important topics that are needed to get your Power BI modelling skills to the next level. We will cover the in memory engine, relationships, DAX filter context, DAX vs M and DirectQuery.
Learn how to get the most of your SSAS MD cubes when using Power BI as a front-end
Learn the basic knowledge to use the R language in Power BI as source, transformation or visualization
This session will reveal what's new for Azure Analysis Services in the areas of performance, scalability, advanced calculations, model management, and monitoring.
Pyramid Analytics BI Office’s Enterprise BI Platform and PrecisionPoint’s data warehousing solution for MS Dynamics ERP systems combine to deliver simplified access to key Business and Financial data.
Continuous Integration has not yet been fully integrated into our BI standards and methods. Tool support is still somewhat unsatisfactory. Let’s look into requirements for a SSAS solution and on ways to approach your self-made solution.
Industry independent analysts say “Pyramid Analytics is essentially the best-in-class, on-premises offering for Microsoft BI today and tomorrow” What does this mean for you and PowerBI?
Demonstrating an end to end IoT solution providing real-time sensor data from a Raspberry Pi into an Azure IoT Hub, through Stream Analytics, then with outputs to Power BI and SQL DB. Learn how to build this simplified IoT solution from scratch.
The Analysis Services model used in both Power BI Desktop and SSAS allows solving of very complex modelling issue. In this session we will look at solving several complex modelling problems like many-to-many and RLS.
Make the right career move impressing your CEO and C-Level suite executives! Meet their specific needs with the right metrics and data visualisation. Power BI can help to bring clarity & predictability to the CEO to make strategic decisions.
By using open data and web scraping in Power BI we will examine if weather has an impact on games in the English Premier League. We will look at the advantages and disadvantages of using open data and web page data how Power BI works with it.
Learn to build Analysis Services models in the cloud
We have assembled a hub of technical experts from SQLCAT, Tiger team, Product Group, Customer Support Services (CSS) and others. We'll have folks from across all our data, BI and Advanced Analytics teams plus some managers - ask us what you want.
What are the pros and cons of SSRS compared to Power BI? How can you benefit from Power BI on-premises?
Loved by business users, yet loathed by IT, Excel is the world’s most popular analytics tool by far. See how XLCubed helps users work smarter in data-connected Excel and Web, while addressing IT concerns about Excel’s role in the BI landscape.
I look at how you can take advantage of an on-premises gateway to make use of local data when creating reports and dashboards for Power BI. This will start with Power BI Desktop, and the choices you have for SQL Server and Analysis Services.
Learn to use the M language to load data into the next version of SQL Server Analysis Services Tabular.
ETL Development takes time. Allen will show how PowerShell and BIML combine to make the development process seamless, consistent and reduces costly development time dramatically.
Join this session on moving a legacy enterprise organisation into the modern BI world using the power of positive disruption and the Attunity tool set. This real world case study will explore Zurich Insurance’s journey featuring both the challenges and successes they faced.
In this session we will talk through the process of gathering user requirements to provide a good starting point for your data model. We will use the Sun Modelling technique to aid us in this.
The typical performance bottleneck in your data warehouse is using SSIS to insert massive amount of data into SQL Server. In this session, you will learn how to improve the load performance with SSIS into SQL Server.
Learn from a real customer how they developed and deployed a series of BI Office solutions to support various business functions including: Finance, Web Analytics Supply, Pricing.
Virtualization has had a major impact on computing. While data professionals have adjusted to this for database servers, many BI workloads have moved there as well. Learn about the impact of virtualization on BI.
These two Microsoft analytic platforms share lots of technologies and users can import and model data in any one of the environments and use the results across both.
Tabular offers only one-to-many relationships on a single column: it seems poor when compared with Multidimensional. However, with DAX, you can handle any relationship. We analyze and solve scenarios with calculated, virtual and complex many-to-many.
BI systems are increasingly mission critical, but they’re only as good as the quality of data they contain. Learn how you can use SQL Server MDS and Profisee’s Master Data Maestro to ensure data quality and improve BI value.
Learn how BI Office from Pyramid Analytics can turn your company into a data driven organisation heading for the stars, whilst combining the best of PowerBI on Premises.
Releasing new features every month, Power BI is moving faster than ever towards letting you experience any data, any way, anywhere. Join this session to learn how the current Power BI suite can be leveraged by all users and see the new updates
Do you get involved in the creation of Business Intelligence solutions within your organisation? This session will show you the new features of SQL Server 2016 Business Intelligence components.
Exposing the lighter side of Business Intelligence. If you've never been to a Power Hour session before then you definitely shouldn't miss this one.
The Internet of Things starts with your things. It's a great time to take a look at game changing technologies you can use today to make your IoT ideas stand out from the rest using Microsoft Azure.
R extends statistical and mathematical capabilities of SQL Server 2016.
Data Warehouses are changing. This session will run through the architecture of the modern warehouse, from structured/unstructured Azure Data Lakes to platform as a service Azure Data Warehouse and bringing the two together.
This session will show you what is possible in the Power BI Offering of Microsoft in relation to Data Governance
A fun session showing some amazing things you can do with Power BI
In this session we will look in detail into some of the features for the Power BI designer and take it for a spin and investigating some of the new capabilities it has to offer for different relationships and new DAX formulas.
Understanding how SQL Server performance tuning works is not just a job for DBA's. It is important for BI professionals to understand as well
The Power BI Preview service offers developers a rich API service for anyone to interact with Power BI programmatically and create applications for Power BI. In this session we will introduce you to the Power BI developer story
Today’s BI systems are often perceived as mission critical, but their value depends on the quality of data they contain. Learn to use SQL Server Master Data Services and Profisee’s Master Data Maestro to ensure data quality and improve BI value.
The attendees will get a overview of the possibilities with Excel Services 2013 in a Business Intelligence perspective. (1) Overview of the publish options (2) How to control the layout (3) Tips & Trick from real world examples
According to The New York Times, data scientists may spend as much as 80% of their time on “data janitor work.” Attend this session and discover five ways you can become the data hero in your organisation.
SQL Server provides the ability to deliver solutions for BI users with all experience levels. See the ease of collaboration of business intelligence reporting between business users and IT departments and demonstrate a real world use case.
Microsoft has totally reimagined the Power BI platform and user experience for BI professionals, developers and business users. Please join me to further explore all these great changes and enjoy a fun demo-intensive session.
BI Office can help you achieve your quest for insights and timely business information. By demonstrating how to build a BI Solution, this session will show you how BI Office can make you a BI Superhero in your organisation
Learn how to use the Power BI tools to help you analyse, specify and test the concepts and requirements of your next data Warehouse project.
Power BI offers new features for creating dashboards on the cloud. In this session, you will learn how to create data models, display visualizations and synchronize cloud data with on premise data sources.
SAP HANA is ubiquitous nowadays and its market share is growing steadily. But being foremost a backend technology opens the trail for other frontend tools like Office 365 &Power BI. How to combine these two technologies will be shown in the session.
In this session you will learn about common MDM scenarios, and get Real Life examples on how to handle these Scenarios by building a MDM Architecture using SQL Server and Master Data Services.
In this interactive session, Matthew Roche from the Data Catalog team will present the capabilities of the catalog in Power BI, as showcased in an end-to-end self-service scenario.
Setting up SharePoint BI applications and services to work in an enterprise environment
Exposing the lighter side of Business Intelligence. If you've never been to a Power Hour session before then you definitely shouldn't miss this one.
Gain insights into what is behind the media storm surrounding the Economic Crisis, by diving into publically available data using PowerBI . Learn how the use of analytical tools can empower us by answering the questions we need to ask.
The world of data is changing rapidly. Come learn what this means for your role as a data professional and what you can do to make sure you stay at the front of your field.
Power BI is the Self-Service BI offering of Microsoft to all Information Workers out there, but hey: Is there anything for developers? We will have a look.
Each of the default SSAS client tools (Pivot Tables, SSRS, Power BI etc.) have strengths, but numerous limitations. See how XLCubed extends business users abilities in reporting, dashboards & data discovery, in any version of of SSAS & Office.
In this intensive one hour session, learn how to analyse and visualise your data using the Data Analysts Toolkit - Microsoft Power BI complemented with R
In this session Pyramid analytics will show how to use BI Office to easily build an adhoc Analysis Services Tabular Edition analytic data set and perform associative analysis using the unique features of BI Office.
Impress the boss and your colleagues by delivering Dashboards, KPIS, maps and Scorecards wrapped in a tablet-ready interface with SSRS
Learn how to use performance counters, report execution log data, and trace files to troubleshoot performance problems. Learn how to set up a monitoring solution to capture data and diagnose slow queries.
Information Workers and Data Analysts do “myth busting" on corporate performance and forecasts on regular basis. This session uncovers ways to take advantage of Power BI as Software as a Service (SaaS) for a "myth busting" lab you can try at home!
In this session we will discuss Data Governance around Power BI and on-prem platforms. How to avoid dataset-hell. What are the best practices for sharing queries? Who is the famous Data Steward ?
Learn how XLCubed unlocks the value of Multi-dimensional and Tabular SSAS and SQL for power users in Excel; providing pixel perfect delivery of reporting, dashboards for both Web and Mobile and with or without SharePoint.
Attend this session to learn more about Governed Data discovery, get an overview of BI Office and find out why so many Microsoft customers are investing in this innovative BI Platform.
Big Data has triggered the need for organisations to build real-time Operational Data Store (ODS) layers to feed the ‘Data Lake’ on Hadoop. Attend this lunchtime session to learn why a real-time ODS should be at the heart of your data architecture
Explore Power Query features to import data from existing Corporate BI systems.
T4 templating will be a first class citizen in SSDT for SQL Server 2014. This session will show why you should use this technology for SQL code generation and how you can automate the process. The session will be demo rich.
In this session we will explore the Irish Economic Crisis from multiple perspectives, using Microsoft’s latest Visualisation tools including Power BI, Power Query, Power Map, Power View and Q&A.
In the ideal world, all information and structures are static, but in the real world almost everything is dynamic, and changes are constant. This session reviews different methods for generating MSBI content (SSIS, SSRS) dynamically.
Big Data is hot! And the magic word is Hadoop. But what is it? And more important: what can I do with it? In this session we will cover some basics of Hadoop, MapReduce, Pig and Hive.
You probably already heard a lot of the wonders of PowerPivot and Power View, but will you have any other cool new BI features with Excel 2013. The answer is a big YES! This session will demo a lot of those.
There has been rapid development in the capabilities of SQL Server to support big data and hadoop following introduction of the HDInsight Service and HDInsight Server. This session covers SQL Server capability and integration points.
This session will introduce you to the Pyramid Analytics Platform and Architecture and demonstrate some of its innovative and game changing capabilities, from analytics to dashboards to reporting, with full central management and control.
This session will discuss what a modern strategy for data warehousing can be in this era, considering how the use of technologies like PowerPivot or Analysis Services Tabular affect the way you should model your data.
In this lunchtime session, Attunity will highlight real customer implementations of Attunity Replicate and the Microsoft BI technology stack that enabled them to achieve competitive advantage.
PowerPivot is a breakthrough for self-serve BI but is not easily deployed in the enterprise. Join us for this fast-paced, technical demonstration on how to upgrade PowerPivot into secure and scalable Analysis Services tabular cubes
Learn how Varigence tools accelerate BI development, enhance reusability, and improve agility through the use of customizable patterns and automation scripts and transform your metadata into comprehensive BI solutions.
In this session, you will learn how to combine data from web services, tables and cubes to build a powerful model, and visualise it in Excel.
The Microsoft BI stack has a number of tools for data visualization - Excel, Power View, native Reporting Services, and Performance Point. Come see each visualization applied to the new tabular model in Analysis Services.
Most of us use Excel in our Daily work, but are you familiar with the Business Intelligence features in Excel? In this session we'll look at some of the most common and useful BI features in Excel 2010 and discuss limitations and best practices.
But were afraid to ask. Pyramid Analytics burst onto the Microsoft BI scene with not only a full roadmap for ProClarity users, but also with cube driven dashboards that offer rich functionality – yet are easy to design and deploy by business users.
In this first of two sessions, we review the architecture of SQL Server and its BI components and deployment options for optimal performance. We'll also discuss how to optimize data warehouse load operations.
This one hour session will provide insight on what to expect when deploying a highly available end to end SQL Server 2012 Business Intelligence environment as experienced from the field.
Learn all about the integration of Business Intelligence Markup Language (BIML) into BIDS Helper and see what it can do for you. BIML can help you automate the creation of SSIS packages, reduce maintenance and help code re-use across projects.
Snapshots without that possible? Take a "Classic" snapshot fact table, add some temporal data theory and you'll get a new fact table than can store snapshot data without doing snapshots. A life saver when you have a lot of data.
This session explains what the BI Semantic Model in SQL Server Denali is, how it is related to Analysis Services, and provides a brief introduction to the new Tabular model.
This session will drill into some of the details on the shipping HP BDA and BDW appliances and how they can work well together to deliver a comprehensive BI and DW solution for customers using the Microsoft Application Platform.