Get Job Ready: Power BI Data Analytics for All Levels
4.5 /5- Offered byCode Basics
Get Job Ready: Power BI Data Analytics for All Levels at Code Basics Overview
Duration | 2 hours |
Total fee | ₹2,400 |
Mode of learning | Online |
Credential | Certificate |
Get Job Ready: Power BI Data Analytics for All Levels at Code Basics Highlights
- Certificate of completion
- 17:24 on-demand video
- 189 Lectures
- 6 Practice Business Scenarios with Solution
- 12 Quizzes
- Access on tablet and phone
- Free Lifetime Access
Get Job Ready: Power BI Data Analytics for All Levels at Code Basics Course details
- A practical beginner?s course that will prepare learner for the data analyst, business analyst, or Power BI developer job market through a true end-to-end Power BI project carefully curated to provide you with real organizational experience & business context
Get Job Ready: Power BI Data Analytics for All Levels at Code Basics Curriculum
Course Overview
What is Data Analytics? What is Power BI?
Course Introduction
Data Analyst as a Career Option
Why Power BI?
Why this Course?
Who Can Take this Course?
System Requirements
How to Get Support if I Have a Question?
Chapter Summary
Project Planning and Scoping
Problem Statement
The Email that Started this Project
Project Kick-off Meeting
Learn how a ?Project Charter? is Used in Companies
Project Kick-off: Session Debrief
Senior Data Analyst Sets Up the Next Steps with Junior Data Analyst
Simplified: Profit and Loss Statement
Chapter Summary
Quiz
Data Collection and Exploration
Simplified: Data Warehouse, OLTP vs OLAP, Data Catalog
Install MySQL and Import Data
Simplified: Data Exploration Using SQL, Star Schema, Fact vs Dimension Tables
Chapter Summary
Quiz
Data Load to Power BI & Initial Validation
Install Power BI and Load Data from MySQL Database
Create a Date Dimension Table
Validate Data against Benchmark Numbers
Chapter Summary
Quiz
Data Transformation in Power Query
Review Finance View Mockups
Transform Data in Power Query Editor
Create Calculated Columns in Power Query Editor
Power Query Best Practices
Chapter Summary
Quiz
Data Modelling & Calculated Columns
Power Query or DAX for Generating Calculated Columns?
Data Modelling: Star and Snowflake Schema
Data Modeling: Connect Dimensions with Fact Tables
Simplified: Why Do We Need Dimension Tables?
Mentor Talk: Congratulations! You are Levelling Up!
Create Calculated Columns Using DAX
Easy Way to Verify Your Numbers in Power BI
Optimize Report and Reduce File Size by 25 %
I Need a Favour
Chapter Summary
Quiz
Build Finance View
Finance View: Prepare a List of Metrics
Simplified: Calculate Function & Filter Context
Finance View: Creating Metrics
Finance View: Create P&L Table Structure
Finance View: Create Last Year (LY) Column
Finance View: Build an Ultimate DAX Measure for P & L Table Structure - I
Finance View: Build an Ultimate DAX Measure for P & L Table Structure - II
Finance View: Create ?Quarters? & ?YTD/YTG? Slicers
Mentor Talk: Figuring Out Solutions
Finance View: Create a Line chart to Show Performance Over Time
Finance View: Build Top Product, Market & Region Visuals
Intermediate Review: I Met Product Owner Nick and He Gave this Feedback!
Finance View: Add Net Profit
Chapter Summary
Quiz
Build Sales, Marketing & Supply Chain View
Review Sales View Mockup
Sales View: Build Top Customers & Performance Matrix Visuals
Sales View: Build Product Performance & Unit Economics Visuals
Build Marketing View
Simplified: Supply Chain Basics
Supply Chain View: Review Mock Up
Supply Chain View: Build Key Measures
Supply Chain View: Build Visuals
Chapter Summary
Quiz
Designing an Effective Dashboard
Simplified: Dashboard vs Report
15 Design Rules for an Effective Dashboard
Finalize Page Layout Design
Create Home Page
Design Finance Dashboard
Add Key Elements to Finance Dashboard
Copy the Design to Sales, Marketing & Supply Chain Dashboard
Chapter Summary
Quiz
Data Validation Set Up
Create a User Acceptance Test report
Create a Workspace in Power BI
Create a Live Excel Report from Power BI
Chapter Summary
Quiz
Implementing Stakeholder Feedback
Stakeholder Analysis and its Significance
Peter Recalls the Stakeholder Mapping Meeting
Stakeholder Review Meeting: How did it Go?
This is the secret to be ?Job Ready?!
Practice Exercise: Quick Fixes
Practice Exercise: Implementing Dynamic Benchmark
Practice Exercise: Adding Dynamic Slicer to Filter Visual
Practice Exercise: Create a Toggle Button to Switch between Two Visuals
Practice Exercise: Create a Tool Tip to Show Trend
Learn: Adding Market Share Data
Practice Exercise: Create an Executive Dashboard
Learn: Performance Optimization
Learn: Fix Data Quality Issues
Chapter Summary
Quiz
Deploying the Solution
Power BI Service Overview, Report Sharing, and Apps
How to Set Up Automatic Data Refresh: My SQL
How to Set Up Automatic Data Refresh: Excel
Simplified: Collaboration, Bookmarks, and Insights in Power BI Service
Documentation and Maintenance
Chapter Summary
Quiz
Resume and Interview Tips
Project Portfolio for Your Resume
Resume Writing Tips
Job Application Tips
Interview Tips
Thank You!
Practice Exercise Solutions
Solution: Quick Fixes
Solution: Implementing Dynamic Targets (Add Targets)
Solution: Implementing Dynamic Targets (Create a dynamic switch between Targets and LY)
Solution: Implementing Dynamic Targets (P & L visuals to compare Target or LY based on selection)
Solution: Adding Dynamic Slicer to Filter Visual
Solution: Create a Toggle Button to Switch between Two Visuals
Solution: Create a Tool Tip to Show Trend
Solution: Create an Executive Dashboard (KPI Visuals)
Solution: Create an Executive Dashboard (Key Insights by Subzone )
Solution: Create an Executive Dashboard (Market Share Visual & Conditional Formatting)
Solution: Create an Executive Dashboard (Final Enhancements)
Course Completion Test
Final Test
Other courses offered by Code Basics
Student Forum
Anything you would want to ask experts?