Data Science
Data Visualization with Power BI
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.
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.
Audience
The primary audience for this course is business or technical professionals who need to analyze data and produce effective visualizations using Power BI.
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.
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
Is there a discount available for current students?
UMBC students and alumni, as well as students who have previously taken a public training course with UMBC Training Centers are eligible for a 10% discount, capped at $250. Please provide a copy of your UMBC student ID or an unofficial transcript or the name of the UMBC Training Centers course you have completed. Asynchronous courses are excluded from this offer.
What is the cancellation and refund policy?
Student will receive a refund of paid registration fees only if UMBC Training Centers receives a notice of cancellation at least 10 business days prior to the class start date for classes or the exam date for exams.