Zero To Dashboard
2022TL; DR
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 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. Create a meaningful dashboard based on the previous objectives.
We also encourage you to bring your own data in a CSV or Excel format, to the workshop. The last 30-60 minutes is dedicated to enabling you to build reports and dashboards with your own data with the support of your instructor.
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: Go to http://aka.ms/pbidiadtraining and sign up for Power BI. If you cannot sign up for Power BI, let the instructor know.
3 things you'll get out of this session
Speakers
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.