POWER BI - JUMPSTART IN 60 MINUTES

Name: POWER BI - JUMPSTART IN 60 MINUTES
Rating: 4.8 (17 reviews)

GET UP AND RUNNING WITH VISUALIZATIONS, CUSTOM VISUALS, TOOLTIPS AND AI

Created byHavish Madhvapaty

Last updated 3/2020

English

English [Auto],

What you'll learn

Power BI
Data Analytics
Data Visualization

Course content

1 section • 14 lectures • 59m total length

001 - LOADING DATA, CONNECTORS, COLUMN CHART, DRILL DOWN9:00
002 - CONNECTING VISUALS, TIMELINE SLICER2:22
Explore how the timeline slicer in Power BI links visuals like a pie chart and a column chart to filter by year and consumer segment.
003 - TREEMAP VS PIE CHART2:54
Compare treemap and pie chart in Power BI, showing how a dream map reveals numbers more clearly, supports multi-level drill, and interactive filtering beyond pie charts.
004 - WATERFALL CHART, RIBBON CHART3:14
Learn to use waterfall and ribbon charts for financial analysis, with Power BI jumpstart in 60 minutes, revealing year-to-year changes and regional contributions with automatic change calculations.
005 - EDIT INTERACTIONS2:00
Edit interactions in Power BI to keep some visuals static while others react to a timeline; set a visual to none to always show the grand total.
006 - Q&A4:18
Learn to use the Q&A visual in Power BI to ask natural language questions and view counts by region, state, and year in matrix or trend formats.
007 - FORECASTING2:11
Explore forecasting in Power BI using analytics to estimate the cost of claim with a 40-point forecast over four years, and see how slices and vertical-to-horizontal orientation affect results.
008 - TOOLTIP3:26
Build a Power BI tooltip page linked to a main visual; hover to slice data and display related visuals such as a column chart and a treemap for monthly sales.
009 - PIVOT TABLES2:11
Explore how Power BI's matrix visual, similar to pivot tables, uses region and segment in columns, applies average values, and enables conditional formatting with icons and interactive drill into elements.
010 - POWER QUERY8:40
Learn how Power Query in Power BI transforms data by duplicating queries, removing columns, adding columns from examples, and splitting or merging columns with applied steps and M language.
011 - BOOKMARKS2:36
Master bookmarking with buttons to switch between column and bar chart views on one Power BI dashboard, delivering a fluid, page-free data presentation for clients.
012 - CUSTOM VISUALS4:19
Import custom visuals and explore over 170 options. Create drill-downs across region, segment, and category, apply top-N filters, and harness a natural language visual to narrate insights.
013 - ADVANCED - MERGE, CREATING A MODEL6:37
Merge 13, 14, 15 and 2016 data in Power BI, append and refresh queries, transform headers, and build a model with one-to-many relationships.
014 - FINAL DASHBOARD, PUBLISHING AND QUICK INSIGHTS6:01
Publish and share the final dashboard from my workspace or publish to web, and explore quick insights with auto-generated visuals.

Requirements

Description

Power BI is a business analytics service that delivers insights to enable fast, informed decisions. The first release of Power BI was based on the Microsoft Excel–based add-ins: Power Query, Power Pivot and Power View. In 2015 it was released to general public. In February 2020, Gartner confirmed Microsoft as Leader in the “2020 Gartner Magic Quadrant for Analytics and Business Intelligence Platform” as result of the capabilities of Power BI platform.

The coursei s a quick introduction to the capabilities of Power BI for a new user. Power BI has a monthly update cycle – and will surely continue to be an excellent BI tool as the market moves towards self-service BI.

Who this course is for:

B School Students
Corporate professional stepping into data visualization