The 2023 Ultimate Microsoft Excel & Power BI Certification Bundle
1227 Enrolled
9 Courses & 63 Hours
$34.99$153.00
You save 77%
What's Included
$17.00 Value
Microsoft Power BI: The Complete Master Class
Nikolai Schuler
163 Lessons (15h)
Lifetime
- 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 startedWelcome!0:22What is Power BI?3:01Download & Installing4:06The interface (Quick Tour)2:43Mini Project - Transform Data6:52Mini Project - Visualizing Data5:07Mini Project - Data Model7:21What will you learn in this course?5:02All source files & course slides
- Preparing the course projectWorking with the attached project files3:51
- Data Transformation - Beginner to IntermediateExploring the Query Editor6:11Connecting to our data source6:48Editing and removing rows8:10Changing data types8:24Replace Values3:27Close & Apply3:29Connecting Power BI to a csv file3:21Connecting to a Web Page5:04Extract Characters6:18Splitting & Merging Columns9:22Create a conditional column5:52A little note on the next lecture!Columns from examples8:38Merging Queries17:23Pivoting & Unpivoting5:43Appending Tables8:20Practise & Solution: PopulationTable14:30Fact Dimension Model9:19Practise: Load Dimension Table3:48Organizing our Queries in Groups2:59Text used in the next lectureEntering data manually4:43Creating an index column3:04Workflow & more transformations4:38Module Summary5:05Excersice: Instructions1:41Exercise: Solution11:09
- Data Transformation - AdvancedAdvanced Editor - Best practise8:43References vs. Duplicates9:50Enable Disable Load & Report Refresh4:31Group by4:47Mathematical Operations4:54Run R Script14:36Using Parameters to dynamically transform data6:28M-language Basics6:40M-Language Values, Lists & Tables13:57M-Language Functions13:13M-Language More functions & steps5:02Exercise: Instructions0:55Exercise: Solution4:31
- Creating the Data ModelUnderstanding relationships5:07Create & Edit relationships6:16One-to-Many and One-to-One Relationship5:49Many-to-Many relationship & Crossfilter direction8:15Cross filter direction5:56Activate & Deactivate relationships5:52Section Summary3:04Exercise 3 - Create Model2:27Exersice 3 - Solution1:37
- Data VisualizationOur first visual7:57The format tab11:52Tables9:53Conditional Formatting8:48The pie chart5:32All about the Filter visual12:32Filter pane for developers8:52Cross filtering & Edit interactions3:56Exercise 4 - Instructions1:00Exercise 4 - Solution6:10Syncing slicers across pages7:06Drill down8:29Drill through6:50Tree map visual7:06Decomposition tree5:23Matrix visual5:17Edit pages7:15Buttons & Actions9:28Bookmarks to customize your report9:31Analytics and Forecast with Line Charts10:12Working with Custom Visuals7:17R scripts for the next lectureGet data using R & R Script Visual8:26Asking Questions - Q & A Visual3:45Wrap up Data Visualization8:09
- Power BI & PythonPython in Power BI: Plan of attack2:57Setting up Python for Power BI3:03Transforming data using Python scripts11:24Python script I (for the next lecture)Creating visualizations using Python7:55Python script II (for the next lecture)Violine plots, ridge plots & correlation analysis plots7:13Python script III (for the next lecture)Machine Learning & Text Analysis using Python9:53Performance & Troubleshooting3:27
- DAX - The EssentialsWelcome to DAX2:32Let's look at our data4:09DAX Cheat SheetAll files for the DAX sectionsMeasures vs. Calculated columns14:37Automatically create a date table8:17CALENDAR5:08Complete date table with additional features3:43Script to be used in your future projectsKey Measures Table3:19Aggregation functions6:07COUNT and its variations14:05SUMX - How does it work8:32DAX Exercise 1DAX Solutions 1
- DAX - CALCULATE functionCALCULATE Basics10:53FILTER6:31ALL7:53ALLSELECTED3:13ALLEXCEPT7:24DAX Exercise 2DAX Solution 2
- DAX - Time IntelligenceTimeIntelligence & DATEADD11:18Year-to-Date & Month-to-Date5:19TOTALYTD VS DATESYTD8:54DATESBEETWEEN5:15
- DAX - Operators, Variables & QuickmeasuresLogical Operators9:27Commenting and Formatting5:48Variables9:47Quickmeasures - How to use them in a smart way4:46
- Visualize effectively & Tell a story with your dataIntro - Best Practises1:01Best practise #1 - Show Empathy & Identify the requirements2:37Best practise #2 - Finding the most suitable KPIs2:18Best Practise #3 - Choose an effective visualization3:39Best Practise #4 Make use of natural reading pattern2:58Best practise # 5 - Tell a story using visual cues5:21Best practise # 6 - Avoid Chaos & Group information2:17Wrap up - Stroytelling with data1:41
- Power BI Cloud - Power BI ServiceHow to go from here?3:13Power BI Pro vs. Premium & Registration3:48An alternative if you don't have a business emailExploring the Workspaces4:10Discovering the workspaces2:31Note on the next lectureConnecting Power BI Desktop & Cloud4:00Understanding Datasets & Reports3:24Working with the reports3:53Updating the reports from Power BI Desktop4:29Creating and working with Workspaces7:13Installing & Using a Data Gateway12:53Get Quick Insights2:33Creating Dashboards4:05Sharing our results through Apps10:09Power BI Mobile App5:26Creating the layout for the Mobile App3:46Cloud Wrap up7:13
- Row-Level SecurityIntro3:20Creating a Row-Level Security4:51Row-Level Security in the Cloud3:31Row-Level Security & Data Model4:38Dynamic Row-Level Security7:28Dynamic Many-to-Many RLS4:04Hierarchical Row-Level Security12:55
- Additional data sourcesJSON & REST API9:57Setting up a local MySQL database14:01Connecting to a SQL database4:59Power BI & SQL database (PostgreSQL)5:01
- Congratulations & how to stay up to dateCongratulations & Next steps6:24More 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
$17.00 Value
Statistics & Mathematics for Data Science and Data Analytics
Nikolai Schuler
89 Lessons (11h)
Lifetime
$17.00 Value
Alteryx: The Complete Master Class
Nikolai Schuler
133 Lessons (9h)
Lifetime
$17.00 Value
Excel Pro Tips: Data Visualization
Chris Dutton
20 Lessons (1h)
Lifetime
$17.00 Value
Up & Running with Power BI Desktop
Chris Dutton
117 Lessons (10h)
Lifetime
$17.00 Value
Microsoft Excel: Data Visualization with Charts & Graphs
Chris Dutton
62 Lessons (4h)
Lifetime
$17.00 Value
Data Visualization with R
Juan Galvan
11 Lessons (4h)
Lifetime
$17.00 Value
Mathematics for Data Science
Juan Galvan
12 Lessons (1h)
Lifetime
$17.00 Value
Fullstack Web Development Master Class 2023
John Bura
114 Lessons (8h)
Lifetime
Terms
- Unredeemed licenses can be returned for store credit within 30 days of purchase. Once your license is redeemed, all sales are final.
Your cart is empty. Continue Shopping!
Processing order...