Power BI - Basics to Advanced
With no prior experience, you will have the opportunity to walk through hands-on examples with Hadoop and Spark frameworks, two ...
Show more
- Description
- Curriculum
- FAQ
- Notice
- Reviews
Power BI – Course Contents
Module 1: Introduction to Power BI (Basics)
- What is Business Intelligence (BI)?
- Overview of Power BI Ecosystem
- Power BI Desktop vs Power BI Service
- Installing & Setting up Power BI Desktop
- Power BI Interface Tour
- Importing Data from Excel, CSV, Web, Databases
Module 2: Data Loading & Transformation (Power Query)
- Understanding ETL (Extract, Transform, Load)
- Power Query Editor Overview
- Data Cleaning Techniques
- Remove Errors
- Remove Duplicates
- Replace Values
- Split Columns
- Merge Queries & Append Queries
- Data Types, Filters & Sorting
- Using Parameters in Power Query
Module 3: Data Modeling (Intermediate)
- Star Schema vs Snowflake Schema
- Creating Relationships
- Cardinality & Cross Filter Direction
- Creating Date Table
- Understanding Fact & Dimension Tables
- Model Optimization Best Practices
Module 4: DAX (Data Analysis Expressions)
- Basic DAX:
- Calculated Columns vs Measures
- Basic Functions: SUM(), COUNT(), AVERAGE(), DISTINCTCOUNT()
- Text Functions, Logical Functions
- Intermediate DAX:
- Time Intelligence Functions
- CALCULATE(), FILTER(), ALL(), ALLEXCEPT()
- IF, SWITCH, RELATED, RELATEDTABLE
- Advanced DAX:
- Advanced Time Intelligence
- Ranking Functions
- Dynamic Measures
- Virtual Tables
- Troubleshooting DAX
Module 5: Data Visualization (Reports)
- Visual Types & Use Cases
- Tables, Matrices, Card Visuals
- KPI & Gauge Charts
- Bar Charts, Line Charts, Pie & Donut Charts
- Slicers & Filters
- Drill-through, Drill-down & Tooltips
- Bookmarks & Page Navigation
- Custom Visuals
Module 6: Power BI Service (Online)
- Publishing Reports to Power BI Service
- Creating & Managing Workspaces
- Dashboards vs Reports
- Power BI App
- Sharing Reports & Permissions
- Data Alerts
Module 7: Data Refresh & Automation
- Scheduled Refresh
- Incremental Refresh
- Dataflow Introduction
Module 8: Security
- Testing Roles
Module 9: Advanced Features
- What-If Parameters
- Field Parameters (Dynamic Visuals)
- Drillthrough & Tooltip Pages
- Sync Slicers
- AI Visuals (Key Influencers, Decomposition Tree)
- Python & R Integration (Optional)
Module 10: Exporting & Integration
- Export to PDF, PPT, Excel
Module 11: Final Project
- Real-Time Business Dashboard
- Sales, Finance, HR or Operations Dashboard (Choose any one)
- Complete end-to-end workflow from raw data to dashboard
FAQ 1
Faq Content 1
FAQ 2
Faq Content 2
Productivity Hacks to Get More Done in 2018
— 28 February 2017
- Facebook News Feed Eradicator (free chrome extension) Stay focused by removing your Facebook newsfeed and replacing it with an inspirational quote. Disable the tool anytime you want to see what friends are up to!
- Hide My Inbox (free chrome extension for Gmail) Stay focused by hiding your inbox. Click "show your inbox" at a scheduled time and batch processs everything one go.
- Habitica (free mobile + web app) Gamify your to do list. Treat your life like a game and earn gold goins for getting stuff done!
Stars 5
3
Stars 4
0
Stars 3
3
Stars 2
0
Stars 1
0
Course details
Duration
10 hours
Lectures
5
Video
9 hours
Quizzes
1
Level
Popular courses
