In our in-depth video course for 2023, learn the power of Microsoft Power BI Desktop for Business Intelligence. This training resource will provide you the skills and knowledge necessary to utilize Power BI Desktop to its best advantage for your company needs Microsoft Power BI Desktop. It contains more than 30 hours of interesting video content.
Our course, which is only offered on “howtofree.org,” is made to help you master Microsoft Power BI Desktop, the industry-standard business intelligence application. Learn how to turn data into helpful knowledge and produce eye-catching visuals to promote thoughtful decision-making.
You’ll study a variety of topics in this course, such as report development, data modeling, and data display techniques. Our course is your key to success, whether you’re a seasoned expert trying to improve your BI skills or a beginner eager to use the power of data-driven decision-making.
Table of Contents
Join us now and set out on a path to become a skilled Power BI Desktop user, possessing the skills and knowledge required to drive your company’s success through 2023 and beyond. Don’t pass up this chance to improve your business intelligence abilities and have an important impact on your company. Enroll today to begin your profound educational journey!
What You’ll Learn:
- Build professional-quality business intelligence reports from scratch.
- Blend and transform raw data to create engaging interactive dashboards.
- Design and implement tools employed by professional analysts and data scientists.
- Showcase your skills through two comprehensive course projects, complete with step-by-step solutions.
- Explore robust artificial intelligence tools and advanced visualization techniques.
- Benefit from the expertise of a #1 best-selling instructor and professional Power BI developer.
Course Content of Microsoft Power BI Desktop
1. Getting Started
- READ ME: Important Notes for New Students
- Course Introduction
- Course Structure & Outline
- DOWNLOAD: Course Resources
- Introducing the Course Project
- Setting Expectations
2. Introducing Microsoft Power Bl Desktop
- Section Introduction
- Meet Power Bl Desktop
- Downloading Power Bl
- IMPORTANT: Adjusting Settings
- Power Bl Desktop Interface & Workflow
- Resources & Monthly Updates
- QUIZ: Introducing Power Bl Desktop
3. Connecting & Shaping Data
- Section Introduction
- Power Bl Front-End vs. Back-End
- Types of Data Connectors
- The Power Query Editor
- Basic Table Transformations
- ASSIGNMENT: Table Transformations
- SOLUTION: Table Transformations
- PRO TIP: Storage & Connection Modes
- Connecting to a Database
- Extracting Data from the Web
- Data QA & Profiling Tools
- Text Tools
- ASSIGNMENT: Text-specific Tools
- SOLUTION: Text-specific Tools
- Numerical Tools
- ASSIGNMENT: Numerical Tools
- SOLUTION: Numerical Tools
- Date & Time Tools
- Change Type with Locale
- PRO TIP: Rolling Calendars
- ASSIGNMENT: Calendar Tables
- SOLUTION: Calendar Tables
- Index & Conditional Columns
- Calculated Column Best Practices
- Grouping & Aggregating
- Pivoting & Unpivoting
- Merging Queries
- Appending Queries
- PRO TIP: Appending Files from a Folder
- Data Source Settings
- PRO TIP: Data Source Parameters
- Refreshing Queries
- PRO TIP: Importing Excel Models
- Power Query Best Practices
- QUIZ: Connecting & Shaping Data
4. Creating a Data Model
- Section Introduction
- Data Modeling 101
- Database Normalization
- Fact & Dimension Tables
- Primary & Foreign Keys
- Relationships vs. Merged Tables
- Creating Table Relationships
- Managing & Editing Relationships
- Star & Snowflake Schemas
- ASSIGNMENT: Table Relationships
- SOLUTION: Table Relationships
- PRO TIP: Active & Inactive Relationships
- Relationship Cardinality
- Connecting Multiple Fact Tables
- Filter Context & Filter Flow
- Bi-Directional Filters &Ambiguity
- Hiding Fields from Report View
- ASSIGNMENT: Filter Flow
- SOLUTION: Filter Flow
- PRO TIP: Model Layouts
- Data Formats & Categories
- Creating Hierarchies
- ASSIGNMENT: Hierarchies
- SOLUTION: Hierarchies
- Data Model Best Practices
- QUIZ: Creating a Data Model
5. Calculated Fields with DAX
- Section Introduction
- Data Analysis Expressions 101
- DAX vs. M Languages
- Intro to DAX Calculated Columns
- Intro to DAX Measures
- Implicit vs. Explicit Measures
- Quick Measures
- RECAP: Calculated Columns vs. Measures
- PRO TIP: Dedicated Measure Tables
- Understanding Filter Context
- Step&y-Step DAX Measure Calculation
- DAX Syntax & Operators
- Common DAX Function Categories
- Basic Math & Stats Functions
- Counting Functions
- ASSIGNMENT: Math & Stats Functions
- SOLUTION: Math & Stats Functions
- Conditional & Logical Functions
- The SWITCH Function
- ASSIGNMENT: Logical Functions
- SOLUTION: Logical Functions
- Common Text Functions
- ASSIGNMENT: Text Functions
- SOLUTION: Text Functions
- Basic Date & Time Functions
- ASSIGNMENT: Date & Time
- SOLUTION: Date & Time
- Joining Data with RELATED
- The CALCULATE Function
- DAX Measure Totals
- ASSIGNMENT: CALCULATE
- SOLUTION: CALCULATE
- The ALL Function
- ASSIGNMENT: CALCULATE &ALL
- SOLUTION: CALCULATE & ALL
- The FILTER Function
- Iterator (X) Functions
- ASSIGNMENT: Iterators
- SOLUTION: Iterators
- Time Intelligence Patterns
- ASSIGNMENT: Time Intelligence
- SOLUTION: Time Intelligence
- DAX Best Practices
- QUIZ: Calculated Fields with DAX
6. Visualizing Data with Reports
- Section Introduction
- The 3 Key Questions
- Dashboard Design Framework
- Sketching the Dashboard Layout
- Adding Report Pages & Objects
- Naming & Grouping Objects
- Cards & Multi-Row Cards
- ASSIGNMENT: Cards
- SOLUTION: Cards
- Building & Formatting Charts
- Line Charts
- PRO TIP: Trend Lines & Forecasts
- ASSIGNMENT: Line Chart & Trend
- SOLUTION: Line Chart & Trend
- KPI Cards
- Bar & Donut Charts
- Basic Filtering Options
- ASSIGNMENT: Donuts & Filters
- SOLUTION: Donuts & Filters
- Table & Matrix Visuals
- Conditional formatting
- Top N Filtering
- ASSIGNMENT: Tables
- SOLUTION: Tables
- Top N Text Cards
- ASSIGNMENT: Top N Text Cards
- SOLUTION: Top N Text Cards
- Map Visuals
- Report Slicers
- ASSIGNMENT: Slicers
- SOLUTION: Slicers
- PRO TIP: HASONEVALIJE
- Gauge Charts
- PRO TIP: Advanced Conditional Formatting
- Area Charts
- Drill up & Drill Down
- ASSIGNMENT: Drill Up & Drill Down
- SOLUTION: Drill Up & Drill Down
- Drillthrough Filters
- Editing Report Interactions
- ASSIGNMENT: Report Interactions
- SOLUTION: Report Interactions
- Adding Bookmarks
- ASSIGNMENT: Bookmarks
- SOLUTION: Bookmarks
- PRO TIP: Custom Navigation Buttons
- PRO TIP: Slicer Panels
- Numeric Range Parameters
- Fields Parameters
- ASSIGNMENT: Fields Parameters
- SOLUTION: Fields Parameters
- PRO TIP: Custom Tool Tips
- Importing Custom Visuals
- Managing & Viewing Roles
- Mobile Layouts
- PREVIEW: Publishing to Power Bl Service
- Data Visualization Best Practices
- QUIZ: Visualizing Data with Reports
7. Artificial Intelligence (A1)
- Section Introduction
- Anomaly Detection
- Smart Narratives
- Q&A Visuals
- Decomposition Trees
- Key Influencers
8. Power Bl Optimization Tools
- Section Introduction
- The Optimize Ribbon
- Pausing Visuals
- Optimization Presets
- Applying All Slicers
- Performance Analyzer
- External Tools
9. BONUS PROJECT: Maven Market
- Introduction
- PART 1: Connecting & Shaping the Data
- PART 2: Creating the Data Model
- PART 3: Adding DAX Measures
- PART 4: Building the Report
10. BONUS LESSON
- BONUS LESSON
Requirements of Microsoft Power BI Desktop:
- Microsoft Power BI Desktop: Ensure you have the free download of Microsoft Power BI Desktop installed on your computer.
- PC/Windows Operating System: Please note that this course is designed for PC/Windows users. Currently, it is not available for Mac users.
- Experience with Excel (Optional): While not mandatory, having prior experience with Excel Power Query, Power Pivot, and DAX can be advantageous. It’s a plus, but not required, to get the most out of the course.
Who this course is for:
- Hands-On Learners: Individuals seeking a practical, project-based introduction to Microsoft Power BI Desktop.
- Data Enthusiasts: Data analysts and Excel users aiming to enhance their expertise in advanced data modeling, dashboard design, and business intelligence.
- Future Data Professionals: Aspiring data professionals who aspire to master the market’s leading business intelligence tool.
- Engaged Students: Students in search of a comprehensive, engaging, and highly interactive training approach to bolster their skills.
- Career Pursuers: Anyone with ambitions of pursuing a rewarding career in data analysis or business intelligence.
How much time is the course?
With over 30 hours of video content, our Microsoft Power BI Desktop course for Business Intelligence provides thorough covering of the subject.
Is this a beginner-friendly course Microsoft Power BI Desktop?
Without a doubt! From beginners ready to get started with Power BI Desktop to advanced users looking to hone their skills, our course is made to suit students of all ability levels.
Are there any requirements to take this course?
There are no set requirements. To start your BI danger with us, all you need is a PC with Power BI Desktop installed.
Free Join our course on “howtofree.org” today and start your journey towards becoming a Business Intelligence expert!
Wait 15 Second For Download This File For Free
Author : https://www.udemy.com/course/microsoft-power-bi-up-running-with-power-bi-desktop/
if you find any wrong activities so kindly read our DMCA policy also contact us. Thank you for understand us…