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