Data Visualization with Power BI
Overview
Data Visualization is the graphical representation of large datasets using graphs and charts such as bar charts, line graphs, scatterplots, etc. Learn how to elegantly present datasets that allow your audience to quickly digest, understand, and derive insights or see trends from the data. This course teaches students how to navigate the Microsoft Power BI software and to utilize this tool to create effective visualizations of datasets.
A brief demo of what you can expect to learn in this course.
Who Should Take This Course
Audience
The primary audience for this course is business or technical professionals who need to analyze data and produce effective visualizations using Power BI.
Prerequisites
An awareness of large datasets within your organization, what that data represents and where that data is stored is helpful. Comfort with basic charts such as bar charts, line charts, etc. Familiarity with Microsoft Office applications – particularly Excel.
Why You Should Take This Course
Upon completing this course, students will be able to:
- Describe self-service BI.
- Describe the Power BI suite of products.
- Connect to data sources and optimize data models.
- Shape and combine data from different sources.
- Model data.
- Create reports and manage solutions.
- Describe the Power BI developer API.
- Describe the Power BI mobile app.
Course Outline
Data Visualization with Power BI
Days 1&2 (Introduction to Power BI)
- Intro to Data Analysis & Business Intelligence
- Overview of Power BI
- Power BI Desktop
- Power BI Service
- Power BI Mobile
- Business Visualizations
- Best Practices & Guidelines
- Concepts: Change over Time; Correlation; Magnitude; Deviation; Distribution; Ranking; Part-to-Whole
- Power BI Desktop
- Navigation
- Building Visualizations & Interactive Reports
- Standard: Tables; Stacked & Clustered Bar/Column charts; Line & Area charts; Scatter plots; Pie & Donut charts
- Intermediate: Treemaps; Waterfalls; Dual-axis & Combo charts; etc.
- Geographic: Point & Filled maps
- Controls & Actions: Filtering/Slicing; Highlighting; Sorting
- Analytics: Min/Max/Average; Trendlines; Forecasting
- Formatting Visualizations & Interactive Reports
- Power Query Editor
- Getting & Transforming Data
- Working with Queries & Fields
- Power BI Service
- Navigation
- Understanding Workspaces
- Publishing Reports
- Creating Dashboards
Day 3 (Enhanced Power BI)
- Power Query
- Get data from URLs, Excel Tables, Files, Folders, Databases, etc.
- Data Modeling using M
- Power BI Desktop
- Relationships & Filters
- Enhance data using DAX (Data Analysis Expressions)
- Power BI Service
- Subscriptions & Alerts
- Collaboration Workspaces & Apps
- Advanced Visualizations
- Natural Language Q&A
- Customizing & Enhancing Power BI
- Themes
- Visuals
- AppSource
- Advanced Concepts & Visuals