Microsoft Power BI Desktop for Business Intelligence

Course Name : Microsoft Power BI Desktop for Business Intelligence
Students : 582,804
Duration : 16 hours, 9 articles & 8 downloadable resources
Avg Rating : 4.6 (146,791 ratings)
Original Price : $119.99
Discount Price : $14
Instructor / Provider : Chris Dutton, Maven Analytics, Udemy
Course Type : Self Paced Online Course. Lifetime Access
Coupon : Click on ENROLL NOW to apply discount code

By the End of This Course You will Learn: 

Connecting & Shaping Data

• Data Connectors: Explore connections to databases, web sources, and Excel models.
• Storage & Import Modes: Understand storage options for optimized performance.
• Query Editing Tools: Leverage tools to shape and refine your data.
• Table Transformations: Perform grouping, aggregating, pivoting, and unpivoting.
• Data Profiling: Use QA and profiling tools for cleaner, more reliable datasets.
• Calculated Fields: Create index and conditional columns.
• Dynamic Tools: Work with rolling calendars and text, numerical, and date tools.
• Merging & Appending Queries: Combine data from multiple sources effectively.

Creating a Relational Data Model

• Normalization: Organize data into fact and dimension tables.
• Schema Design: Create star and snowflake schemas for optimal performance.
• Relationships: Manage primary and foreign keys, active/inactive relationships, and cardinality.
• Filter Context: Understand bi-directional filters and filter flow.
• Formatting: Establish model layouts and set data formats, categories, and hierarchies.

Frequently Bought Together

Adding Calculated Fields with DAX

• DAX Fundamentals: Understand syntax, operators, and differences between DAX and M.
• Calculated Fields: Build calculated columns and measures.
• Functions: Master math, statistical, conditional, logical, text, and date functions.
• Core DAX Tools: Use CALCULATE, FILTER, and ALL for advanced data manipulation.
• Iterators: Apply X functions for row-level computations.
• Time Intelligence: Implement patterns for analyzing trends over time.

Visualizing Data with Reports

• Data Visualization Best Practices: Build clean, professional-quality visuals.
• Interactive Features: Add slicers, bookmarks, tooltips, and drillthrough options.
• Visual Elements: Use cards, KPIs, trend lines, maps, and conditional formatting.
• Advanced Techniques: Incorporate custom visuals, field parameters, and role-based views (RLS).
• Publishing: Publish reports to Power BI Service and design mobile-friendly layouts.

FAQs on Udemy Coupon