Power BI is always a popular training topic at Pragmatic Works. The versatile platform brings together data so it can be analyzed in seconds across a multitude of devices. With the numerous recent updates and introduction of Power BI Designer, we’re focusing our free Training on the T’s webinars for April on Power BI.
This month’s free training will include sessions on leveraging Power Query, Power Map, Power Pivot and Excel Power Tools with leaders in the BI community including members of the Pragmatic Works team. We’re even featuring a bonus Power BI Panel to answer your top questions.
In his webinar, Deploying and Managing Power BI, Brad will cover the number of options for deploying reports as well as their restrictions. Additionally, he'll also walk you through all the relevant topics for managing Power BI both to prepare the environment for deployment and how to maintain the environment after reports have been deployed. This is a must see session for anyone getting started in Power BI whether you are a developer or an administrator.
April 2, 2015 11:00 AM EST
Mark’s session, Power Query: Data Chemistry for the Masses, will show how Power Query can be easily used to take advantage of data's properties to drive the change necessary to support goals.
April 7, 2015 11:00 AM EST
The Power Map tool in Power BI uses space and time to tell stories with data. Power Map: Custom Mapping with Restaurant Traffic will look at a scenario using a building layout to show traffic patterns and other interesting information including restaurant seating and sales to determine if where someone sits matters to cost. This implementation is an example of what is possible with custom maps in Power BI.
April 9, 2015 11:00 AM EST
Patrick’s session, Power BI: Data Refresh and SSAS On-Premises Connectivity, will take a Power BI deep dive into two Hybrid Scenarios for Power BI. The session will explore the data refresh capabilities, allowing reports published to Power BI to connect to varying data sources for data refresh. It will also discuss exciting new capabilities that allows Power BI to connect directly to SQL Server Analysis Services on-premises and interactively query.
April 14, 2015 11:00 AM EST
His session, Diving Into Big Data Using Excel Power Tools, will show you where to pick up after a Big Data solution has been designed and implemented. He'll go through the available "Power Tools" in Excel and show how to create a beautiful visualization experience with your data while never leaving your cluster.
April 16, 2015 11:00 AM EST
Power Query is a powerful data transformation tool that allows for self-service data extraction all within a familiar toolset: Excel. While Power Query does have a user interface that allows for simple transformations to be applied, there are some scenarios that go beyond what’s provided in the UI and require code to be written. M is the query language that powers the data transforms utilized by Power Query. This session, M Query Basics for Power Query, covers the basics of using the language and shows real world applications on why you might need to write your own M.
April 21, 2015 11:00 AM EST
Power BI Designer is a new standalone Business Intelligence tool that allows you to design and build Power BI reports outside of the web and Excel. While Power BI Designer is currently only in preview, it shows where Microsoft is going with Power BI to try and make a more complete and well-rounded Business Intelligence solution. This introductory session will explore what is currently offered in the latest version of Power BI Designer with live demos and what might be coming in the future.
April 23, 2015 11:00 AM EST
Intro to DAX for Power Pivot and SSAS Tabular will cover the basics of the DAX query language used in both Excel Power Pivot and SSAS Tabular. Calculated columns and members will be created and navigating the data model will be discussed. The session will start with common calculations before moving on to more complex calculations as time allows.
April 28, 2015 11:00 AM EST
In his session, Automating Power BI Creations, he invites users to come learn how to build and automate data sets and data models in Excel using the Power BI toolset. Data will be pulled from a variety of on-premise and cloud data sources to familiarize the latest capabilities of Power Query and Power Pivot. Then he’ll review the software required to automate a Power BI analysis whether you are trying to refresh your Excel workbooks on a file server, in SharePoint Online, or SharePoint on-premise.
April 30, 2015 11:00 AM EST
Addtionally, this month we'll be featuring a free Power BI Panel with the Pragmatic Works team.
Pragmatic Works Power BI Panel
April 22, 2015 11:00 AM EST