The Ultimate Microsoft Excel & Power BI Certification Bundle

7 Reviews
1369 Enrolled
9 Courses & 63 Hours
Deal Price$34.99
Suggested Price
$153.00
You save 77%
🔥 1,000+ Sold! Selling Fast
The Ultimate Microsoft Excel & Power BI Certification Bundle
7 Reviews
$34.99$153.0077% OFF

What's Included

Microsoft Power BI: The Complete Master Class
  • Experience level required: All levels
  • Access 163 lectures & 15 hours of content 24/7
  • Length of time users can access this course: Lifetime

Course Curriculum

163 Lessons (15h)

  • Your First Program
  • Getting started
    Welcome!0:22
    What is Power BI?3:01
    Download & Installing4:06
    The interface (Quick Tour)2:43
    Mini Project - Transform Data6:52
    Mini Project - Visualizing Data5:07
    Mini Project - Data Model7:21
    What will you learn in this course?5:02
    All source files & course slides
  • Preparing the course project
    Working with the attached project files3:51
  • Data Transformation - Beginner to Intermediate
    Exploring the Query Editor6:11
    Connecting to our data source6:48
    Editing and removing rows8:10
    Changing data types8:24
    Replace Values3:27
    Close & Apply3:29
    Connecting Power BI to a csv file3:21
    Connecting to a Web Page5:04
    Extract Characters6:18
    Splitting & Merging Columns9:22
    Create a conditional column5:52
    A little note on the next lecture!
    Columns from examples8:38
    Merging Queries17:23
    Pivoting & Unpivoting5:43
    Appending Tables8:20
    Practise & Solution: PopulationTable14:30
    Fact Dimension Model9:19
    Practise: Load Dimension Table3:48
    Organizing our Queries in Groups2:59
    Text used in the next lecture
    Entering data manually4:43
    Creating an index column3:04
    Workflow & more transformations4:38
    Module Summary5:05
    Excersice: Instructions1:41
    Exercise: Solution11:09
  • Data Transformation - Advanced
    Advanced Editor - Best practise8:43
    References vs. Duplicates9:50
    Enable Disable Load & Report Refresh4:31
    Group by4:47
    Mathematical Operations4:54
    Run R Script14:36
    Using Parameters to dynamically transform data6:28
    M-language Basics6:40
    M-Language Values, Lists & Tables13:57
    M-Language Functions13:13
    M-Language More functions & steps5:02
    Exercise: Instructions0:55
    Exercise: Solution4:31
  • Creating the Data Model
    Understanding relationships5:07
    Create & Edit relationships6:16
    One-to-Many and One-to-One Relationship5:49
    Many-to-Many relationship & Crossfilter direction8:15
    Cross filter direction5:56
    Activate & Deactivate relationships5:52
    Section Summary3:04
    Exercise 3 - Create Model2:27
    Exersice 3 - Solution1:37
  • Data Visualization
    Our first visual7:57
    The format tab11:52
    Tables9:53
    Conditional Formatting8:48
    The pie chart5:32
    All about the Filter visual12:32
    Filter pane for developers8:52
    Cross filtering & Edit interactions3:56
    Exercise 4 - Instructions1:00
    Exercise 4 - Solution6:10
    Syncing slicers across pages7:06
    Drill down8:29
    Drill through6:50
    Tree map visual7:06
    Decomposition tree5:23
    Matrix visual5:17
    Edit pages7:15
    Buttons & Actions9:28
    Bookmarks to customize your report9:31
    Analytics and Forecast with Line Charts10:12
    Working with Custom Visuals7:17
    R scripts for the next lecture
    Get data using R & R Script Visual8:26
    Asking Questions - Q & A Visual3:45
    Wrap up Data Visualization8:09
  • Power BI & Python
    Python in Power BI: Plan of attack2:57
    Setting up Python for Power BI3:03
    Transforming data using Python scripts11:24
    Python script I (for the next lecture)
    Creating visualizations using Python7:55
    Python script II (for the next lecture)
    Violine plots, ridge plots & correlation analysis plots7:13
    Python script III (for the next lecture)
    Machine Learning & Text Analysis using Python9:53
    Performance & Troubleshooting3:27
  • DAX - The Essentials
    Welcome to DAX2:32
    Let's look at our data4:09
    DAX Cheat Sheet
    All files for the DAX sections
    Measures vs. Calculated columns14:37
    Automatically create a date table8:17
    CALENDAR5:08
    Complete date table with additional features3:43
    Script to be used in your future projects
    Key Measures Table3:19
    Aggregation functions6:07
    COUNT and its variations14:05
    SUMX - How does it work8:32
    DAX Exercise 1
    DAX Solutions 1
  • DAX - CALCULATE function
    CALCULATE Basics10:53
    FILTER6:31
    ALL7:53
    ALLSELECTED3:13
    ALLEXCEPT7:24
    DAX Exercise 2
    DAX Solution 2
  • DAX - Time Intelligence
    TimeIntelligence & DATEADD11:18
    Year-to-Date & Month-to-Date5:19
    TOTALYTD VS DATESYTD8:54
    DATESBEETWEEN5:15
  • DAX - Operators, Variables & Quickmeasures
    Logical Operators9:27
    Commenting and Formatting5:48
    Variables9:47
    Quickmeasures - How to use them in a smart way4:46
  • Visualize effectively & Tell a story with your data
    Intro - Best Practises1:01
    Best practise #1 - Show Empathy & Identify the requirements2:37
    Best practise #2 - Finding the most suitable KPIs2:18
    Best Practise #3 - Choose an effective visualization3:39
    Best Practise #4 Make use of natural reading pattern2:58
    Best practise # 5 - Tell a story using visual cues5:21
    Best practise # 6 - Avoid Chaos & Group information2:17
    Wrap up - Stroytelling with data1:41
  • Power BI Cloud - Power BI Service
    How to go from here?3:13
    Power BI Pro vs. Premium & Registration3:48
    An alternative if you don't have a business email
    Exploring the Workspaces4:10
    Discovering the workspaces2:31
    Note on the next lecture
    Connecting Power BI Desktop & Cloud4:00
    Understanding Datasets & Reports3:24
    Working with the reports3:53
    Updating the reports from Power BI Desktop4:29
    Creating and working with Workspaces7:13
    Installing & Using a Data Gateway12:53
    Get Quick Insights2:33
    Creating Dashboards4:05
    Sharing our results through Apps10:09
    Power BI Mobile App5:26
    Creating the layout for the Mobile App3:46
    Cloud Wrap up7:13
  • Row-Level Security
    Intro3:20
    Creating a Row-Level Security4:51
    Row-Level Security in the Cloud3:31
    Row-Level Security & Data Model4:38
    Dynamic Row-Level Security7:28
    Dynamic Many-to-Many RLS4:04
    Hierarchical Row-Level Security12:55
  • Additional data sources
    JSON & REST API9:57
    Setting up a local MySQL database14:01
    Connecting to a SQL database4:59
    Power BI & SQL database (PostgreSQL)5:01
  • Congratulations & how to stay up to date
    Congratulations & Next steps6:24
    More data to practise

Microsoft Power BI: The Complete Master Class

NS
Nikolai SchulerNikolai Schuler | Professional Data Scientist und BI Consultant
4.6/5 Instructor Rating: ★ ★ ★ ★ ★ ★
In his work as a data scientist and BI consultant, Nikolai saw that there's a lot of new tools that bring a lot of benefits. Yet it is not always easy to learn working with these tools beside the daily other tasks we have to do. For that reason, he decided to create these courses that are high quality on the one hand and easy to learn with on the other hand. These courses now have reached people in more than 130 countries and he is really glad to help spread these IT skills and enable people to pursue the career they are after.

Description

Learn, step-by-step, everything that is important in Power BI from scratch. You will learn how to work with Power BI, how to connect the various data sources with Power BI, how to transform and structure the data up to the creation of impressive reports with practical tips on storytelling with data. After reporting, you will learn how to publish your reports in the Power BI Cloud and how to effectively share your results with the right people. This course takes you by the hand and leads you from a Power BI beginner to advanced.

4.6/5 average rating: ★ ★ ★ ★ ★ ★

  • Access 163 lectures & 15 hours of content 24/7
  • Create professional, high-quality reports from scratch
  • Confidently use the tools in Power BI
  • Develop your skills on your own project
  • Understand the entire work workflow from start to finish
  • Learn from a professional data scientist & BI consultant
  • Have the knowledge you need to delve deeper into Power BI & deal with even more advanced features
  • Integrate various data sources from Excel to databases

NOTE: Software NOT included.

Specs

Important Details

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

Requirements

  • Microsft Power BI Desktop & Cloud

Terms

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

Jeremy Moss

Verified Buyer

Well worth the price, especially the Power BI course. Very comprehensive and easy to understand. I will recommend to others!

Feb 4, 2023
Nicholas Padlosky profile picture

Nicholas Padlosky

Verified Buyer

Good teaching styles and detailed instructions... I would buy again especially at reduced prices....

Jan 9, 2023
KD

Kevin Donovan

Verified Buyer

I got this to help supplement training for new entry level analysts at my job. This will be a big help getting them upto speed, especially since excel is being taught less and less in college. Power BI training is very useful as well. Being able build good visuals for data analysis results is a must in today's landscape.

Oct 14, 2022
JC

John Cadena

Verified Buyer

This is a great set of courses to advance from other applications and take Excel further. PowerBI is not just an add on tool for Excel but a visualization tool to dovetail with other MS products and environments.

Sep 18, 2022
VL

Viễn Lê Quang

Verified Buyer

Perfect for everyone who wanna learn at a competitive course price offered. The course gives us very useful tips and lessons that we never can find them elsewhere.

May 4, 2022
FF

Fran Fabyanic

Verified Buyer

Incredible amount of training information for this price! The Power BI training alone is extremely valuable.

Feb 2, 2022
Your Cart
Your cart is empty. Continue Shopping!
Processing order...