Power BI - Zero To Dashboard

2022

TL; DR

In this single day workshop, we review the capabilities of the Power BI suite of tools and work through hands-on labs to solidify your knowledge.

Session Details

Your boss has heard all the buzz about Power BI and wants you to start using it to make the business users happy and reduce the demands on IT staff. In this single day workshop, we review the capabilities of the Power BI suite of tools and help you realize the following objectives using demos and hands-on labs:

Objectives:

1. Understand the Power BI ecosystem and what it can and can't do for you.

2. Understand the importance of Data Cleansing.

3. Understand the importance of Data Modeling.

4. Understand data visualization principles.

5. Understand the implications of Power BI as it relates to governance.

6. Create a meaningful dashboard based on the previous objectives.

Pre-requisites

1. Bring your own laptop

2. Microsoft Power BI Desktop: you should have downloaded and installed Power BI Desktop from https://go.microsoft.com/fwlink/?LinkId=521662.

3. Microsoft Power BI Desktop requires Internet Explorer 10 or greater.

4. Signup for Power BI, it's free. If you cannot sign up for Power BI, that's okay, there is only one lab at the end that requires a Power BI account.

Feedback Link - https://sqlb.it/?6184

3 things you'll get out of this session

Michael Johnson's previous sessions

Data Lakehouse Vs Data warehouse in Fabric, which is right for you

Microsoft Fabric offers a variety of data engineering solutions that can suit different needs and goals. However, this also means that choosing the right solution can be challenging and confusing for those who want to migrate to Microsoft Fabric.

The accidental administrator's guide Power BI

If not properly planned and managed, your Power BI environment quickly becomes a mess., making it hard to use and improve. Join this session where we will look at 6 key areas that you as a Power BI administrator will need to look at.

Building a robust deployment pipeline in Power BI

Does your organisation need to manage the deployment of Power BI better? Join this session to learn how to shorten the time to deploy new features to your users while ensuring you maintain a standard for high quality using tools such as Azure DevOps and Power BI deployment Pipelines.

Power BI Premium on a budget

Power BI Premium has many features that organisations desire yet the price makes it impractical for most. In this talk you will learn how Power BI Embedded can be used to enable many of these features at a much lower cost.

Analyzing real-time data using Azure Streaming Analytics.

Businesses today require real-time information to make better-informed decisions, this requires a new set of tools. In this session you will learn about Azure Stream analytics and how it can help address real-time data scenarios

Angela Henry's previous sessions

Assessing and Optimize Enterprise SQL Server Environments

To equip DBAs with a comprehensive and enterprise-centric approach to optimizing SQL Server environments. This session aims to shift the focus from isolated server-specific optimizations to a broader, holistic strategy that maximizes overall system health, performance, and efficiency. Attendees will learn how to assess, prioritize, and implement optimization strategies at the enterprise level, understand key metrics that showcase the benefits of their actions, and effectively communicate and secure management buy-in for their recommendations.

Identifying and Preventing Unauthorized Power BI Gateways

If you need to easily identify all your on-premises data gateways or prevent gateways from being installed in your Power BI tenant, then you don't want to miss this quick tip session.

What is Azure Purview and Why Do I Need It?

This session will introduce you to Azure Purview, what problems it was designed to solve for, and show you how to create a Purview Account in your Azure tenant.

Profiling Your Data

What data profiling is & why you should do it.