Up & Running with Power BI Desktop Course

Up & Running with Power BI Desktop Course

2 Reviews
10 Hours
Deal Price$19.99
Suggested Price
$80.00
You save 75%
Up & Running with Power BI Desktop Course
2 Reviews
$19.99$80.0075% OFF
Up & Running with Power BI Desktop

116 Lessons (10h)

  • Your First Program

  • Getting Started

    Course Structure & Outline1:43
    DOWNLOAD: Course Resources
    Introducing the Adventure Works Project3:02
    Setting Expectations2:21

  • Introducing Power BI Desktop

    Introduction0:26
    Meet Power BI5:30
    Downloading Power BI & Adjusting Settings4:05
    IMPORTANT: Regional Settings
    The Power BI Interface & Workflow2:34
    Helpful Resources1:44
    UPDATE: New Power BI Ribbon (2020)7:15
    QUIZ: Introducing Power BI Desktop

  • Connecting & Shaping Data

    Introduction0:30
    Types of Data Connectors3:53
    The Query Editor4:28
    Basic Table Transformations10:03
    Text-Specific Tools14:54
    Number-Specific Tools8:37
    Date-Specific Tools8:53
    PRO TIP: Creating a Rolling Calendar7:08
    Index & Conditional Columns8:30
    Grouping & Aggregating Data7:33
    Pivoting & Unpivoting8:04
    Merging Queries6:41
    Appending Queries6:29
    PRO TIP: Appending Files from a Folder7:38
    Data Source Settings5:05
    Query Refresh Settings3:06
    Additional Data Types & Categories7:19
    Defining Hierarchies4:35
    PRO TIP: Importing Models from Excel5:40
    Data Connection Best Practices2:09
    QUIZ: Connecting & Shaping Data
    HOMEWORK: Connecting & Shaping Data
    HOMEWORK SOLUTION: Connecting & Shaping Data12:36

  • Creating a Data Model

    Introduction0:19
    What is a "Data Model"?5:17
    Database Normalization4:07
    Data Tables vs. Lookup Tables7:25
    Relationships vs. Merged Tables2:31
    Creating Table Relationships4:34
    "Snowflake" Schemas3:09
    Managing & Editing Relationships2:44
    Active vs. Inactive Relationships2:45
    Relationship Cardinality5:08
    Connecting Multiple Data Tables8:26
    Understanding Filter Flow6:33
    Two-Way Filters (Use with Caution!)13:16
    Hiding Fields from Report View4:15
    UPDATE: New Model View8:32
    Data Model Best Practices1:34
    QUIZ: Creating a Data Model
    HOMEWORK: Creating a Data Model
    HOMEWORK SOLUTION: Creating a Data Model14:09

  • Adding Calculated Fields with DAX

    Introduction0:32
    Meet DAX1:03
    Intro to Calculated Columns7:33
    Intro to Measures2:51
    RECAP: Calculated Columns vs. Measures1:34
    Adding Columns & Measures3:12
    Implicit vs. Explicit Measures6:27
    Filter Context Examples8:07
    Step-by-Step Measure Calculation2:39
    DAX Syntax & Operators3:49
    Common DAX Function Categories3:16
    Basic Date & Time Functions12:24
    Logical Functions10:06
    Text Functions9:24
    Joining Data with RELATED8:54
    Basic Math & Stats Functions14:01
    COUNT Functions7:46
    IMPORTANT: Order Line Items6:21
    The CALCULATE Function13:06
    CALCULATE & ALL9:25
    CALCULATE & FILTER9:37
    Iterator ("X") Functions12:27
    DAX Time Intelligence Formulas12:29
    DAX Best Practices2:57
    QUIZ: Adding Calculated Fields
    HOMEWORK: Adding Calculated Fields
    HOMEWORK SOLUTION: Adding Calculated Fields15:05

  • Visualizing Data with Reports

    Introduction0:29
    The "Report" View5:33
    Adding Simple Objects3:07
    Inserting Basic Charts & Visuals5:47
    UPDATE: Conditional Formatting2:58
    Formatting Options9:51
    Report Filtering Options11:09
    DEMO: Matrix Visuals6:38
    DEMO: Date Slicers7:14
    DEMO: Cards & KPIs9:24
    DEMO: Text Cards6:14
    DEMO: Map Visuals7:15
    DEMO: Treemaps3:21
    DEMO: Line & Area Charts6:23
    DEMO: Trend Lines & Forecasts5:36
    DEMO: Gauge Charts6:43
    Editing Report Interactions6:38
    Adding Drillthrough Filters5:08
    Adding Report Bookmarks5:49
    "What-If" Parameters11:47
    Managing & Viewing Roles5:27
    PREVIEW: Custom Visuals (Log-In Required)2:05
    PREVIEW: Designing for Phone vs. Desktop2:54
    PREVIEW: Publishing to Power BI Service2:27
    Data Visualization Best Practices1:35
    QUIZ: Visualizing Data with Reports
    HOMEWORK: Visualizing Data with Reports
    HOMEWORK SOLUTION: Visualizing Data with Reports7:22

  • NEW: Artificial Intelligence (AI) Visuals

    The Q&A Visual10:54
    The Key Influencers Visual (Part 1)12:34
    The Key Influencers Visual (Part 2)5:11
    IMPORTANT: Correlation vs. Causation4:24
    The Decomposition Tree Visual8:59

  • Wrapping Up

    More from Maven Analytics
    REFERENCE: Monthly Power BI Updates
Up & Running with Power BI Desktop Course
2 Reviews
$19.99$80.0075% OFF
View similar items
DescriptionInstructorImportant DetailsReviewsRelated Products

Transform, Analyze & Visualize Data with 10 Hours of Content on Microsoft Power BI Desktop

CD
Chris DuttonMaven Analytics | Award-Winning Analytics & BI Training
4.6/5 Instructor Rating: ★ ★ ★ ★ ★ ★

Maven Analytics transforms everyday people into data rockstars by streamlining, simplifying, and personalizing the online learning experience. Since 2014, they've helped students and teams across 150+ countries develop the most sought-after analytics and business intelligence skills, through on-demand courses, skills assessments, curated learning paths, and enterprise training.

Chris Dutton | Founder of Maven Analytics
4.6/5 Instructor Rating: ★ ★ ★ ★ ★ ★
Chris Dutton is a certified Microsoft Excel Expert, analytics consultant, and best-selling instructor with more than a decade of experience specializing in business intelligence, marketing analytics and data visualization. He founded Excel Maven in 2014 to provide high-quality, applied analytics training and consulting to clients around the world, and now mentors 25,000+ students in more than 150 countries. He has developed award-winning data analytics and visualization tools, featured by Microsoft, the New York Times, and the Society of American Baseball Research.

Description

What You'll Learn With This Power BL Desktop Course Deal

If you're looking for a comprehensive, hands-on guide to learning Microsoft Power BI Desktop, you've come to the right place. Power BI is quickly becoming the world's most powerful self-service business intelligence platform, and an absolutely essential tool for data professionals and beginners alike. With Power BI you can connect to hundreds of data sources, build complex relational models, and design stunning, interactive dashboards from scratch.

18,830 positive ratings from 73,732 students enrolled

  • Access 116 lectures & 10 hours of content 24/7
  • Build professional-quality business intelligence reports from the ground up
  • Understand the business intelligence workflow from end-to-end
  • Blend and transform raw data into beautiful interactive dashboards
  • Design and implement the same B.I. tools used by professional analysts & data scientists

Note: Software NOT included

Specs

Important Details

  • Length of time users can access this course: lifetime
  • Access options: desktop & mobile
  • Certification of completion included
  • Redemption deadline: redeem your code within 30 days of purchase
  • Updates included
  • Experience level required: all levels
  • Have questions on how digital purchases work? Learn more here

Requirements

  • Microsoft Power BI Desktop (NOT included)
  • Experience with Excel Power Query, Power Pivot & DAX is a plus, but not required

Terms

  • Unredeemed licenses can be returned for store credit within 30 days of purchase. Once your license is redeemed, all sales are final.
2 Reviews
5/ 5
All reviews are from verified purchasers collected after purchase.
Eamonn O'Neill profile picture

Eamonn O'Neill

Verified Buyer

I love excel and am really interested in upskilling and learning how to create tables for reporting.

Aug 4, 2020
TR

Trey Russell

Verified Buyer

I love the lecture and descriptions. It allows me to rerun lectures and understand steps to cement theory and function.

Jul 31, 2020
Your Cart
Your cart is empty. Continue Shopping!
Processing order...