In the second half of this session, we'll connect to Azure SQL DW, load some risk data, improve the data model, create some insightful reports and dashboards, ask some questions then analyse in Excel. We'll use an example of financial market risk data. This is stored in data warehouses since a bank can easily generate a few hundred million rows of each day and risk managers need to analyse this data over several days and months. Such large volumes make this data a prime candidate for moving to Azure SQL DW. In addition, the elastic capabilities of SQL DW are very useful for example at UAT phases when users need an additional large dataset available for a (hopefully) short period of time. In the demo, we will use the scenario of an equity trading division with a bank. I will spend a couple of minutes introducing a small fictional dataset of the profit and loss (P&L) and VaR over a few years. (VaR, stands for Value At Risk, and is a common measure of the riskiness of the portfolio of trades.) We will load the data into Power BI desktop. We will improve the data model; build a hierarchy, and hide columns of no interest to our users, and calculate a few useful quantities using DAX. We will build a typical market risk report known as a back test chart which compares our P&L and VaR. We'll do this firstly using the standard and custom visuals then using the R Script visual to give us a more precise visualisation that meet the demands of regulators. Once done, we are ready to publish data and reports to the Power BI service. There will we pin a few visuals to a dashboard and then interrogate the data using plain English with the Q&A feature. Finally we will analyse our data in Excel. This is a very exciting new(ish) feature of Power BI and very useful to the risk managers in our scenario who traditionally do analyse their risk data in Excel pivot tables. This allows them to have their cake and eat it – to be able to visualise, explore and share their data with Power BI but also to take advantage of all the analytical power of Excel.
Come to this session to learn how Microsoft is improving the productivity of its in-house counsel with intuitive document management and collaboration tools and enabling access from any device at any time. Learn how Microsoft is using Office 365, Matter Center, and other tools to boost productivity of its in-house counsel, without sacrificing compliance, security or manageability, and take away best practices that you can take advantage of in your own organization.
Jak dobrze policzyć, okaże się że usług Azure jest dobrze ponad kilkaset. W tej sesji nie będziemy się zajmować szczegółami technicznymi albo omawiać, jakie są cechy poszczególnych usług, a skupimy się na tym – jakie rozwiązania da się zbudować. Też kilka realnych "case study".
Printing has been a key role of computing since the beginning of the personal computer. While users have moved more and more towards smartphones and tablets as their primary computing device, many critical business functions, or common activities, still rely on printed output. This session will discuss how application developers can use Universal Windows Platform SDK to write Windows apps that print (on both PC and phone). This talk includes discussion of important industry standards like PWG Raster, PCLm, OpenXPS, and MS XPS. We will also cover UI considerations when implementing printing. Speaker: Justin Hutchings.