Excel + Power BI For Business Analytics Bundle By Kenji Farre – Free Download Course Career Principles – Kenji Explains
Learn how you can master Power BI, the leading business intelligence tool to transform, analyze and visualize data!
✅ About This Bundle:
✅ Course Author: Kenji Farre @ Career Principles
✅ Official Course Price: $279
✅ Free For Our VIP Members? : Yes
✅ Download Links : Mega & Google Drive
✅ Updatable? : Yes, all future updates included.
✅ Sales Page : You can check at the bottom of this page.
🏆 Here’s What You Get & Learn With This Bundle:
This course will teach you how to efficiently transform raw business data into beautiful and dynamic dashboards on Power BI. We’ll start with the basics, and gradually progress through more advanced modules covering Power Query transformations, data pivots, merging queries, DAX measures, calculated columns, and more. Course modules will frequently introduce practical exercises in the form of built-from-scratch reports and dashboards designed to help you visualize meaningful insights with complex data.
90+ High Quality Lessons
Downloadable Power BI, Excel, and PDF Files
Two Built-From-Scratch Sales and Finance Dashboards
Please note Power BI only works on a Windows OS
Course Curriculum:
Module 1: Course Introduction
Course Overview
What is Power BI
Download Power BI
Important Power BI Settings
Power BI Interface View Options
Course Resources: DAX Measures Glossary
Module 2: Importing & Transforming Data
Importing Data (SQL, Excel, Web, etc.)
Introduction to the Power Query Editor
Basic Transformations in Power Query
Text Tools & Functions
Numerical Values
Date & Time Tools
Grouping
Pivot & Unpivot
Relationships
Merge Queries
Append Queries
File Path Error
Case Study: Data Cleaning
Module 3: Data Visualization
Report View
Dashboard Setup
Inserting Elements
Creating Charts & Visuals
Adding Forecasts & Analytics
Creating Maps
Conditional Formatting
Creating Tables & Matrices
KPI Cards
Slicers
Filters
Case Study: Create a Beautiful Dashboard
Module 4: DAX: Data Analysis Expressions
Introduction to Measures and Calculated Columns
Data Overview and Upload
Creating Calculated Columns
Creating Measures
Measure Tools: Naming & Formatting
DAX Syntax & Other Measures
Applying Other Measures
Intermediate Measures
Adding Comments & Quick Measures
Module 5: Advanced DAX
Logic Functions & Operators
CALCULATE Function
CALCULATE with ALL & FILTER Functions
Related
Iterators
Switch
Text Functions
Date Functions
Time Intelligence Functions
Variables
Module 6: McDonald’s Business Case Study
Case Study Instructions
Data Cleaning
Relationships
Report Formatting
Slicers & KPIs
Area and Pie Charts
Country Breakdown Table
Map Chart
Manager Demographics
Grouping Age Brackets
Case Study Conclusion
Module 7: Nike Financial P&L Case Study
Case Study Introduction
Data Overview
Cleaning and Importing Data
Base P&L Statement Setup
SELECTEDVALUE Function
P&L Base Values and Subtotals
P&L Subpercentages
ISFILTERED & ISBLANK Function
P&L Subcategory Line Items
FORMAT Function
P&L Formatting Fix
Base Colors Setup
Stacked Column Chart
Regional Doughnut Chart
KPI Cards
Dashboard Slicer & Title
Module 8: Sharing & Collaborating: Power BI Service
Power BI Service – Workspaces Overview
Publishing Desktop Power BI into Online Power BI Service
Report View on Power BI Service
Datasets on Power BI Service
Dashboards on Power BI Service
Share a Web URL Power BI Report
Power BI Mobile Optimization
Report Export Options (Excel, PowerPoint, PDF)
Commenting
Share Feature (Power BI Pro)
Module 9: Next Steps
Next Steps After Power BI
The Bundle Includes:
Access to Full Power BI Curriculum
Power BI Course Completion Certificate
Power BI DAX Measures Cheat Sheet
Downloadable Start & End Files
Business Case Study: McDonald’s Data Visualization Report
Finance Case Study: Nike P&L Dashboard
Access to Full Excel Curriculum
Excel Course Completion Certificate
Case Study: Excel Interview Test
Case Study: Excel Interactive Dashboard
✅ Great X Courses Guarantee : At Great X Courses, we insist in providing high quality courses, with direct download links (no paid links or torrents). What you see is exactly what you get, no bad surprises or traps. We update our content as much as possible, to stay up to date with the latest courses updates.
You can find more details about the course according to the sales page.
