麻豆果冻传媒

Power BI

Who should attend

This class is for data analysts and managers who want to find business insights by creating impactful and elegant data visualizations.

Power BI

贵谤辞尘听

$995

Summary

Are your usual pie charts getting yawns in meetings? Power BI, like its competitor Tableau, is Microsoft鈥檚 software for building sophisticated 鈥渄ata visualizations鈥: elegant and often interactive graphical representations of your data 鈥 beyond what you can find in Excel or even Crystal Reports. In this class we鈥檒l show you how to navigate the software so you can build and publish the kind of data-based reports that will get the office talking.

Prepping Data. After we鈥檝e shown you the basic navigation and main areas of Power BI, we鈥檒l cover how to import your data and clean it up. You can get data from multiple sources: Excel, SQL Server, XML and online services like Azure and Google Analytics. You can even combine tables from different sources by designating 鈥渏oin鈥 relationships between them. Along the way we鈥檒l show you how to set cleanup rules for any messiness in your imported data.

Different Visualizations. Once your data is ready, you鈥檒l learn how to create stunning visualizations from it: bubble charts, heat maps, geographic shape maps, and more. You鈥檒l learn how to publish them as standalone documents to bring to your next meeting.

Extending Data. In addition to simple data cleanup, Power BI offers tools to shape and combine data, including Power Query and Data Analysis Expressions (DAX), a toolkit of functions and formulas to return calculated values. This lets you incorporate key business summary data into your visualizations.

Publishing Options. Once your visualization is perfected, you can share it with others online by posting it to Office 365 or the Power BI mobile app. You鈥檒l also learn how to embed reports into web pages, or post them to SharePoint or MS Teams. Finally, we鈥檒l show you how to build interactive dashboard reports to combine your different data visualizations.

Course Outline

Day 1: Prepping Data and Creating Visualizations

Lesson 1: Introducing Power BI聽

  • Navigating the Interface
  • Power BI 麻豆果冻传媒b Services
  • Building a Report Using Excel Data
  • Publishing and Sharing Power BI Reports

Lesson 2: Shaping and Combining Data

  • Importing from Multiple Data Sources
  • Using Power Query
  • Shaping, Transforming and Combining Data
  • Producing Reports Using your Data Transformations

Day 2: Modeling Data and Publishing Options


锘縇esson 3: Modeling Data聽

  • Establishing Table Relationships
  • Writing DAX (Data Analysis Expressions)
  • Building Custom Calculated Columns
  • Building Custom Data Measures
  • Incorporating your Custom Columns and Measures in Reports聽

Lesson 4: Publishing Options

  • Overview of Power BI 麻豆果冻传媒b Service Capabilities
  • Building a 麻豆果冻传媒b Service Dashboard
  • Sharing your Dashboards
  • Installing and Using the Power BI Mobile App
  • Embedding Reports in 麻豆果冻传媒b Pages
  • Publishing Reports to MS SharePoint and MS Teams聽

Skills covered

No items found.

Power BI

Reviews

Upcoming LIVE聽ONLINE聽public classes
check mark
June 17 & June 18, 2021
9:00am-11:30am
June 17 & June 18, 2021
9:00am-11:30am
June 17 & June 18, 2021
9:00am-11:30am
June 17 & June 18, 2021
9:00am-11:30am
June 17, 2021
9:00am-11:30am
June 17, 2021
9:00am-11:30am
June 17, 2021
9:00am-11:30am
June 17, 2021
9:00am-11:30am
June 17, 2021
9:00am-11:30am

Interested in a private
workshop for your company?

Thank you! Your submission has been received!
Oops! Something went wrong while submitting the form.

The Swirl logo鈩 is a trademark of AXELOS Limited, used under permission of AXELOS Limited.
All rights reserved. 漏 2024 麻豆果冻传媒!