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.
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.
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.
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.