MSBI Tutor

About this event With data being seen as the ‘new oil’ in football, teams around the world are seeking to gain a competitive edge by using it to generate as many insights as possible. The ability to translate and communicate data points to practitioners concisely and effectively will enable informed decision-making.  Power BI is a powerful tool that allows users to connect multiple data sources to generate interactive insights. The low-code nature of the software makes it an ideal starting point for anyone looking to engage with football data. Our Power BI Masterclass on Tuesday April 19th will be delivered by Southampton FC Performance Data Analyst Harriet Eastham, who is a Microsoft Certified Data Analyst Associate. Harriet uses Power BI on a daily basis to provide a variety of insights to practitioners across the club’s football department. During this follow-along interactive session she will take you through the process from processing a season’s worth of GPS data within a CSV fil

Creating Business Intelligence solutions no longer has to be a long, arduous process reserved exclusively for those in IT. Power BI now gives you the ability to build beautifully designed reports and dashboards on your own, giving you instant satisfaction to your data needs. This course will take a deep dive into the Power BI ecosystem, you will learn from beginning to end how to develop solutions and solve complex business problems. This begins by importing and applying business rules to your data. Then organize the results into a data model with relationships and calculations. Finally, you will learn the best way to visualize your data on reports through a variety of charts, graphs, maps and gauges. Once complete, learn how to deploy solutions to the Power BI Service and make them dashboards that are visible from any device. Please note, you get  extra 25% off  with your Unlimited On-Demand Learning membership! If you are a member, please contact training@pragmaticworks.com to comple

We are excited to announce improvements to the Power BI activity logs that would help organizations gain insights on users connecting to Power BI datasets from Excel. With these improvements, admins can now track the usage of Power BI datasets in Excel, helping organizations improve data governance or fulfill regulatory compliance. Prerequisites To access the Power BI activity log, you must meet these requirements: Be a global admin or a Power BI administrator Install the Power BI Management cmdlets locally or use the Power BI management cmdlets in Azure Cloud Shell Monitoring usage of Power BI datasets in Excel with PowerShell In this example, a Power BI admin wants to identify users connecting to Power BI datasets from Excel Desktop and Excel for the web with the  Get-PowerBIActivityEvent  activity: Open PowerShell Run the  Get-PowerBIActivityEvent  cmdlet to download event data for the  AnalyzedByExternalApplication  activity. The  AnalyzedByExternalApplication  activity identifies

This SQL course will get you up and running to construct SQL queries, to extract data sub-sets from your data. It helps summarise and analyse data.  SQL Course outline Hour 1 and 2 What is a Relational Database? Tables, Rows and Columns, Data Types Relationships, Primary Keys and Foreign Keys SQL Queries with the Select Statement The Select and From Clause Column Aliases The Order By Clause Conditions and the Where Clause ( > , >=, <, <=,, = , and, or, in, between ) Wildcards Working with null values Hour 3 Expression queries SQL Arithmetic Operation Case, iif, choose Date function and date formatting basics Hour 4 SQL Query Summarizing and Grouping SQL Aggregate Functions Sum, Avg, Count, Max, Min The Group By Clause The Having Clause Combining Queries : The Union, Intersect and Minus Operators Hour 5 Querying Multiple Tables Joining Tables Inner Joins, Left and right Joins, Full Joins, Self Joins, Cross Coins Hour 6 Basic Subqueries: Practical Exercises How does it work:

Taking place in the incredibly cool city of Berlin from 6-8 April 2022, the European Power Platform Conference brings together the  Microsoft Power Platform and Dynamics 365 Communities , for 3 unrivalled days of in-person learning, sharing and networking. Attend the European Power Platform Conference to dive into Microsoft’s Power Platform stack and avail of a host of professional development opportunities, including  2 inspirational keynotes ,  4 expert full day tutorials  and 60+ specialist sessions, delivered by global Power Platform experts and community leaders. Gain expert insight and hear the latest innovations across Power Apps, Power BI, Power Automate, Power Virtual Agents and Dynamics. Alongside 500+ of your professional peers, expect actionable best practice, insight and inspiration from the people who build the tools and solutions you and your teams can use every day to succeed and thrive. Get ready to power up at the European Power Platform Conference Get your Tickets no

In August 2021, we  announced general availability (GA) of backup and restore  for large datasets. Not content, we looked for additional ways to improve this important feature. One area stood out:  performance . After all, the faster you can backup and restore your datasets in Power BI, the more you can minimize downtime in critical situations and uphold your service level agreements (SLAs). Of course, better performance also helps with backup and restore based migrations of Azure Analysis Services (AAS) datasets to Power BI. Today, we’re happy to announce significant performance improvements to backup and restore operations. Our benchmark tests with 1GB, 5GB, and 10GB datasets show backups can now be completed up to 22 times faster than before, and the time required for restore operations can also be reduced by more than 30%. With the goal of improving the speed of backup and restore for large datasets, we evaluated several critical areas in the Analysis Services engine. The Analysis

We are happy to announce that we have just released the February update for the On-premises data gateway (version  3000.114.6 ) Download on-premises data gateway (Standard mode) Download on-premises data gateway (personal mode) Compatible with February PBI Desktop  This version of the gateway will ensure that the reports that you publish to the Power BI Service and refresh via the Gateway will go through the same query execution logic/run-time as in the February Power BI Desktop version. February updates Here are some of the things that we would like to highlight with this month’s release: All certified connectors can be used via the gateway Amazon OpenSearch Service (New Connector) OpenSearch Project (New Connector) Digital Construction Works Insights (New Connector) Azure Databricks (Connector Update) BQE Core (Connector Update) MicroStrategy (Connector Update) Starburst Enterprise (Connector Update)

Welcome to the March 2022 update. We are happy to announce a couple new features this month! How about error bars for line charts and dynamic format strings support for all chart elements? Also, we have some updates to the Azure Maps visual and Sensitivity labels, datasets hub and Power BI Goals. There is more to explore, please read on. Reporting New Format Pane    – general availability coming in May Error bars   Dynamic format strings now supported for all chart elements Updates to the Azure Maps visual   Sensitivity labels update Multi-row card selection Data connectivity and preparation BitSight Security Ratings (New Connector) Bloomberg Enterprise Data and Analytics (Connector Update) Anaplan (Connector Update) FactSet Analytics (Connector Update) AssembleViews (Connector Update) Service Datasets hub improvements Power BI Goals enhancements Custom statuses in Scorecards Power BI Goals Teams notification Embedded Analytics A new improved method for deploying Power BI Embedded mult