Torrent Contents Size: 10.52 GB
Maven Analytics - Power BI Specialist
|
|
Advanced DAX for Power BI
|
|
0. Course Intro
|
|
1. Course Structure - Outline Video
|
|
|
2.DOWNLOAD%3a Course Resources
|
|
|
3. Setting Expectations Video
|
|
|
4. Helpful Resources Video
|
|
|
|
1. Prerequisite Skills Review
|
|
1. Introduction Video
|
|
|
2. Data Modeling Fundamentals Video
|
|
|
3. Basic DAX Video
|
|
|
|
10. Iterator Functions
|
|
1. Introduction Video
|
|
|
10. ASSIGNMENT- Moving Averages Video
|
|
|
11. SOLUTION- Moving Averages Video
|
|
|
12. RANKX Video
|
|
|
13. ASSIGNMENT- RANKX Video
|
|
|
14. SOLUTION- RANKX Video
|
|
|
2. Review- Basic Iterators Video
|
|
|
3. Iterator Cardinality Video
|
|
|
4. CONCATENATEX Video
|
|
|
5. PRO TIP- Adding Dynamic Labels Video
|
|
|
6. ASSIGNMENT- CONCATENATEX Video
|
|
|
7. SOLUTION- CONCATENATEX Video
|
|
|
8. AVERAGEX Video
|
|
|
9. PRO TIP- Moving Averages Video
|
|
|
|
11. Advanced Time Intelligence
|
|
1. Introduction Video
|
|
|
10. Common Time Intelligence Functions Video
|
|
|
11. PARALLELPERIOD Video
|
|
|
12. PREVIOUSQUARTER Video
|
|
|
13. SAMEPERIODLASTYEAR Video
|
|
|
14. ASSIGNMENT- Time Periods Video
|
|
|
15. SOLUTION- Time Periods Video
|
|
|
16. Week-based Calculations Video
|
|
|
17. Previous Fiscal Week Video
|
|
|
18. Fiscal Period to Date Video
|
|
|
19. Fiscal Previous Period Video
|
|
|
2. Automatic Date Tables Video
|
|
|
20. ASSIGNMENT- 4-5-4 Calendar Video
|
|
|
21. SOLUTION- 4-5-4 Calendar Video
|
|
|
3. Date Table Requirements Video
|
|
|
4. CALENDAR Video
|
|
|
5. CALENDARAUTO Video
|
|
|
6. PRO TIP- Building a Reusable Date Table Video
|
|
|
7. Date Formatting Video
|
|
|
8. ASSIGNMENT- Date Formatting Video
|
|
|
9. SOLUTION- Date Formatting Video
|
|
|
|
12. Sneak Peek- Performance Tuning
|
|
1. Introduction Video
|
|
|
2. Performance Analyzer Video
|
|
|
3. PRO TIP- Copy Query Video
|
|
|
4. DAX Studio Video
|
|
|
5. Optimization Workflow Video
|
|
|
|
13. Final Assessment
|
|
1. About your Final Assessment Text
|
|
|
|
14. Feedback Survey - Next Steps
|
|
2. Share the love- Text
|
|
|
3. Next Steps Text
|
|
|
|
2. Introducing the Course Project
|
|
1. Introducing the Course Project Video
|
|
|
2. NOTE- Power BI Options - Settings Text
|
|
|
3. Maven Roasters Data Model Setup Video
|
|
|
4. ASSIGNMENT- Getting to Know Maven Roasters Text
|
|
|
|
3. The DAX Engines
|
|
1. Introduction Video
|
|
|
10. VertiPaq Relationships Video
|
|
|
11. Summary- DAX Engines Video
|
|
|
2. Formula - Storage Engines Video
|
|
|
3. Query Evaluation In Depth Video
|
|
|
4. Data - Storage Types Video
|
|
|
5. VertiPaq Columnar Data Structure Video
|
|
|
6. VertiPaq Compression - Encoding Video
|
|
|
7. Value Encoding Video
|
|
|
8. Hash Encoding Video
|
|
|
9. Run Length Encoding Video
|
|
|
|
4. Tips - Best Practices
|
|
1. Introduction Video
|
|
|
10. PRO TIP- Using Variables for Debugging Video
|
|
|
2. Shortcuts Video
|
|
|
3. Formatting Best Practices Video
|
|
|
4. DAX Evaluation Order Video
|
|
|
5. Commenting Code Video
|
|
|
6. PRO TIP- Dedicated Measure Table Video
|
|
|
7. Error Handling Video
|
|
|
8. Creating - Using Variables Video
|
|
|
9. Variable Evaluation Order Video
|
|
|
|
5. Scalar Functions
|
|
1. Introduction Video
|
|
|
10. ASSIGNMENT- Conversion Functions Video
|
|
|
11. SOLUTION- Conversion Functions Video
|
|
|
12. Logical Functions- SWITCH Video
|
|
|
13. Logical Functions- COALESCE Video
|
|
|
14. ASSIGNMENT- Logical Functions Video
|
|
|
15. SOLUTION- Logical Functions Video
|
|
|
2. Common Scalar Functions Video
|
|
|
3. Aggregation Functions Video
|
|
|
4. PRO TIP- SUM - SUMX Video
|
|
|
5. Rounding Functions Video
|
|
|
6. ASSIGNMENT- Rounding Functions Video
|
|
|
7. SOLUTION- Rounding Functions Video
|
|
|
8. Information Functions Video
|
|
|
9. Conversion Functions Video
|
|
|
|
6. Advanced CALCULATE
|
|
1. Introduction Video
|
|
|
10. PRO TIP- Common CALCULATE Patterns Video
|
|
|
2. Expanded Tables Video
|
|
|
3. Context Transition Video
|
|
|
4. Evaluation Order Video
|
|
|
5. CALCULATE Modifiers Video
|
|
|
6. REMOVEFILTERS Video
|
|
|
7. KEEPFILTERS Video
|
|
|
8. ASSIGNMENT- Advanced CALCULATE Video
|
|
|
9. SOLUTION- Advanced CALCULATE Video
|
|
|
|
7. Table - Filter Functions
|
|
1. Introduction Video
|
|
|
10. ASSIGNMENT- ALLEXCEPT Video
|
|
|
11. SOLUTION- ALLEXCEPT Video
|
|
|
12. ALLSELECTED Video
|
|
|
13. ASSIGNMENT- ALLSELECTED Video
|
|
|
14. SOLUTION- ALLSELECTED Video
|
|
|
15. SELECTCOLUMNS Video
|
|
|
16. ADDCOLUMNS Video
|
|
|
17. SUMMARIZE Video
|
|
|
18. ASSIGNMENT- SUMMARIZE Video
|
|
|
19. SOLUTION- SUMMARIZE Video
|
|
|
2. Common Table - Filter Functions Video
|
|
|
20. Generating Data Video
|
|
|
21. ROW Video
|
|
|
22. DATATABLE Video
|
|
|
23. GENERATESERIES Video
|
|
|
24. Table Constructor Video
|
|
|
25. ASSIGNMENT- Generating Data Video
|
|
|
26. SOLUTION- Generating Data Video
|
|
|
3. Review- Calculated Tables Video
|
|
|
4. DISTINCT Video
|
|
|
5. VALUES Video
|
|
|
6. ASSIGNMENT- VALUES - DISTINCT Video
|
|
|
7. SOLUTION- VALUES - DISTINCT Video
|
|
|
8. SELECTEDVALUE Video
|
|
|
9. ALLEXCEPT Video
|
|
|
|
8. Calculated Table Joins
|
|
1. Introduction Video
|
|
|
2. CROSSJOIN Video
|
|
|
3. UNION Video
|
|
|
4. EXCEPT Video
|
|
|
5. INTERSECT Video
|
|
|
6. ASSIGNMENT- Calculated Table Joins Video
|
|
|
7. SOLUTION- Calculated Table Joins Video
|
|
|
|
9. Relationship Functions
|
|
1. Introduction Video
|
|
|
10. SOLUTION- CROSSFILTER Video
|
|
|
11. TREATAS Video
|
|
|
12. ASSIGNMENT- Sales Targets -TREATAS- Video
|
|
|
13. SOLUTION- Sales Targets -TREATAS- Video
|
|
|
2. Physical vs. Virtual Relationships Video
|
|
|
3. RELATED Video
|
|
|
4. RELATEDTABLE Video
|
|
|
5. ASSIGNMENT- RELATED - RELATEDTABLE Video
|
|
|
6. SOLUTION- RELATED - RELATEDTABLE Video
|
|
|
7. USERELATIONSHIPS Video
|
|
|
8. CROSSFILTER Video
|
|
|
9. ASSIGNMENT- CROSSFILTER Video
|
|
|
|
|
Microsoft Power BI Desktop
|
|
0. Course Intro
|
|
1. Course Structure - Outline Video
|
|
|
2.DOWNLOAD%3a Course Resources
|
|
|
3. Introducing the Course Project Video
|
|
|
4. Setting Expectations Video
|
|
|
|
1. Introducing Power BI Desktop
|
|
1. Introduction Video
|
|
|
2. Meet Power BI Video
|
|
|
3. Downloading Power BI - Adjusting Settings Video
|
|
|
4. IMPORTANT- Regional Settings Text
|
|
|
5. The Power BI Interface - Workflow Video
|
|
|
6. Helpful Resources Video
|
|
|
7. UPDATE- New Power BI Ribbon Video
|
|
|
|
2. Connecting - Shaping Data
|
|
1. Introduction Video
|
|
|
10. Grouping - Aggregating Data Video
|
|
|
11. Pivoting - Unpivoting Video
|
|
|
12. Merging Queries Video
|
|
|
13. Appending Queries Video
|
|
|
14. PRO TIP- Appending Files from a Folder Video
|
|
|
15. Data Source Settings Video
|
|
|
16. Query Refresh Settings Video
|
|
|
17. Additional Data Types - Categories Video
|
|
|
18. Defining Hierarchies Video
|
|
|
19. PRO TIP- Importing Models from Excel Video
|
|
|
2. Types of Data Connectors Video
|
|
|
20. Data Connection Best Practices Video
|
|
|
22. HOMEWORK- Connecting - Shaping Data Text
|
|
|
23. HOMEWORK SOLUTION- Connecting - Shaping Data Video
|
|
|
3. The Query Editor Video
|
|
|
4. Basic Table Transformations Video
|
|
|
5. Text-Specific Tools Video
|
|
|
6. Number-Specific Tools Video
|
|
|
7. Date-Specific Tools Video
|
|
|
8. PRO TIP- Creating a Rolling Calendar Video
|
|
|
9. Index - Conditional Columns Video
|
|
|
|
3. Creating a Data Model
|
|
1. Introduction Video
|
|
|
10. Relationship Cardinality Video
|
|
|
11. Connecting Multiple Data Tables Video
|
|
|
12. Understanding Filter Flow Video
|
|
|
13. Two-Way Filters -Use with Caution-- Video
|
|
|
14. Hiding Fields from Report View Video
|
|
|
15. UPDATE- New Model View Video
|
|
|
16. Data Model Best Practices Video
|
|
|
18. HOMEWORK- Creating a Data Model Text
|
|
|
19. HOMEWORK SOLUTION- Creating a Data Model Video
|
|
|
2. What is a -Data Model-- Video
|
|
|
3. Database Normalization Video
|
|
|
4. Data Tables vs. Lookup Tables Video
|
|
|
5. Relationships vs. Merged Tables Video
|
|
|
6. Creating Table Relationships Video
|
|
|
7. -Snowflake- Schemas Video
|
|
|
8. Managing - Editing Relationships Video
|
|
|
9. Active vs. Inactive Relationships Video
|
|
|
|
4. Adding Calculated Fields with DAX
|
|
1. Introduction Video
|
|
|
10. DAX Syntax - Operators Video
|
|
|
11. Common DAX Function Categories Video
|
|
|
12. Basic Date - Time Functions Video
|
|
|
13. Logical Functions Video
|
|
|
14. Text Functions Video
|
|
|
15. Joining Data with RELATED Video
|
|
|
16. Basic Math - Stats Functions Video
|
|
|
17. COUNT Functions Video
|
|
|
18. IMPORTANT- Order Line Items Video
|
|
|
19. The CALCULATE Function Video
|
|
|
2. Meet DAX Video
|
|
|
20. CALCULATE - ALL Video
|
|
|
21. CALCULATE - FILTER Video
|
|
|
22. Iterator --X-- Functions Video
|
|
|
23. DAX Time Intelligence Formulas Video
|
|
|
24. DAX Best Practices Video
|
|
|
26. HOMEWORK- Adding Calculated Fields Text
|
|
|
27. HOMEWORK SOLUTION- Adding Calculated Fields Video
|
|
|
3. Intro to Calculated Columns Video
|
|
|
4. Intro to Measures Video
|
|
|
5. RECAP- Calculated Columns vs. Measures Video
|
|
|
6. Adding Columns - Measures Video
|
|
|
7. Implicit vs. Explicit Measures Video
|
|
|
8. Filter Context Examples Video
|
|
|
9. Step-by-Step Measure Calculation Video
|
|
|
|
5. Visualizing Data with Reports
|
|
1. Introduction Video
|
|
|
10. DEMO- Cards - KPIs Video
|
|
|
11. DEMO- Text Cards Video
|
|
|
12. DEMO- Map Visuals Video
|
|
|
13. DEMO- Treemaps Video
|
|
|
14. DEMO- Line - Area Charts Video
|
|
|
15. DEMO- Trend Lines - Forecasts Video
|
|
|
16. DEMO- Gauge Charts Video
|
|
|
17. Editing Report Interactions Video
|
|
|
18. Adding Drillthrough Filters Video
|
|
|
19. Adding Report Bookmarks Video
|
|
|
2. The -Report- View Video
|
|
|
20. -What-If- Parameters Video
|
|
|
21. Managing - Viewing Roles Video
|
|
|
22. PREVIEW- Custom Visuals -Log-in Required- Video
|
|
|
23. PREVIEW- Designing for Phone vs. Desktop Video
|
|
|
24. PREVIEW- Publishing to Power BI Service Video
|
|
|
25. Data Visualization Best Practices Video
|
|
|
27. HOMEWORK- Visualizing Data with Reports Text
|
|
|
28. HOMEWORK SOLUTION- Visualizing Data with Reports Video
|
|
|
3. Adding Simple Objects Video
|
|
|
4. Inserting Basic Charts - Visuals Video
|
|
|
5. UPDATE- Conditional Formatting Video
|
|
|
6. Formatting Options Video
|
|
|
7. Report Filtering Options Video
|
|
|
8. DEMO- Matrix Visuals Video
|
|
|
9. DEMO- Date Slicers Video
|
|
|
|
6. NEW- AI Visuals in Power BI
|
|
1. The Q-A Visual Video
|
|
|
2. The Key Influencers Visual -Part 1- Video
|
|
|
3. The Key Influencers Visual -Part 2- Video
|
|
|
4. IMPORTANT- Correlation vs. Causation Video
|
|
|
5. The Decomposition Tree Visual Video
|
|
|
|
7. Monthly Power BI Updates
|
|
1. REFERENCE- Monthly Power BI Updates Text
|
|
|
|
8. Final Assessment
|
|
1. About your Final Assessment Text
|
|
|
|
9. Feedback Survey - Next Steps
|
|
2. Share the love- Text
|
|
|
3. Next Steps Text
|
|
|
|
|
Microsoft Power BI Service
|
|
0. Course Intro
|
|
1. Course Structure - Outline Video
|
|
|
2.DOWNLOAD%3a Course Resources
|
|
|
3. Setting Expectations Video
|
|
|
4. Helpful Resources Video
|
|
|
5. Introducing the Course Project Video
|
|
|
|
1. Introducing Power BI Service
|
|
1. Introduction Video
|
|
|
10. Common Workspace Actions Video
|
|
|
11. Building Blocks of PBI Service Video
|
|
|
2. Meet Power BI Service Video
|
|
|
3. Account Types Video
|
|
|
4. Common User Personas Video
|
|
|
5. Creating a Power BI Account Video
|
|
|
6. PRO TIP- Signing up with a Non-Work Email Video
|
|
|
7. Activating Your Trial Video
|
|
|
8. Quick Tour of the Interface Video
|
|
|
9. Workspaces Video
|
|
|
|
10. Final Assessment - Next Steps
|
|
1. About your Final Assessment Text
|
|
|
3. Share the love- Text
|
|
|
4. Next Steps Text
|
|
|
|
2. Power BI Service Administration
|
|
1. Introduction Video
|
|
|
2. Admin Roles - Types Video
|
|
|
3. Admin Portal Settings - Options Video
|
|
|
4. Tenant Settings Video
|
|
|
5. PRO TIP- Configuring Custom Branding Video
|
|
|
6. BEST PRACTICES- Power BI Service Administration Video
|
|
|
|
3. Connecting to Data
|
|
1. Introduction Video
|
|
|
10. Setting Up a Data Gateway Video
|
|
|
11. Understanding Dataflows Video
|
|
|
12. Common Dataflow Use Cases Video
|
|
|
13. Creating a New Dataflow Video
|
|
|
14. Quick Tour of the Dataflow Interface Video
|
|
|
15. Connecting to a Dataflow in Desktop Video
|
|
|
16. ASSIGNMENT- Connecting to a Dataflow Video
|
|
|
17. INSTRUCTIONS- Connecting to a Dataflow Text
|
|
|
18. SOLUTION- Connecting to a Dataflow Video
|
|
|
19. DEMO- Creating a Dataflow -MySQL- Video
|
|
|
2. Data Connection Options Video
|
|
|
20. DEMO- Creating a Dataflow -Local MySQL- Video
|
|
|
21. Scheduled Refresh of a Dataflow Video
|
|
|
22. DEMO- Real World Automation Setup Video
|
|
|
23. BEST PRACTICES- Connecting to Data Video
|
|
|
24. ASSIGNMENT- Finishing the Power BI File Video
|
|
|
25. INSTRUCTIONS- Finishing the Power BI File Text
|
|
|
26. SOLUTION- Finishing the Power BI File Video
|
|
|
3. Loading a Local File Video
|
|
|
4. Loading Data from Excel Video
|
|
|
5. PRO TIP- Loading Data from SharePoint Video
|
|
|
6. ASSIGNMENT- Loading Local Data to a Workspace Video
|
|
|
7. INSTRUCTIONS- Loading Local Data to a Workspace Text
|
|
|
8. SOLUTION- Loading Local Data to a Workspace Video
|
|
|
9. Understanding Data Gateways Video
|
|
|
|
4. Reports - Dashboards
|
|
1. Introduction Video
|
|
|
10. Pinning Tiles to a Dashboard Video
|
|
|
11. Pinning Entire Reports to a Dashboard Video
|
|
|
12. Dashboard Interface - Tools Video
|
|
|
13. PRO TIP- Adding a Live Page Video
|
|
|
14. ASSIGNMENT- Assembling a Dashboard Video
|
|
|
15. INSTRUCTIONS- Assembling a Dashboard Text
|
|
|
16. SOLUTION- Assembling a Dashboard Video
|
|
|
17. Adding Data Driven Alerts Video
|
|
|
18. Exploring Data with Q-A Video
|
|
|
19. Generating Quick Insights Video
|
|
|
2. Data Lineage Video
|
|
|
20. Designing for Mobile Video
|
|
|
21. Introducing the Power BI Mobile App Video
|
|
|
22. DEMO- Power BI Mobile App Video
|
|
|
23. BEST PRACTICES- Reports - Dashboards Video
|
|
|
24. ASSIGNMENT- Alerts and Q-A Video
|
|
|
25. INSTRUCTIONS- Alerts and Q-A Text
|
|
|
26. SOLUTION- Alerts and Q-A Video
|
|
|
3. Report Interface - Tools Video
|
|
|
4. Inserting - Formatting Basic Visuals Video
|
|
|
5. PRO TIP- Adding Personal Bookmarks Video
|
|
|
6. PRO TIP- Adding an Image Video
|
|
|
7. ASSIGNMENT- Building a Report Video
|
|
|
8. INSTRUCTIONS- Building a Report Text
|
|
|
9. SOLUTION- Building a Report Video
|
|
|
|
5. Sharing - Collaboration
|
|
1. Introduction Video
|
|
|
10. INSTRUCTIONS- Sharing - Collaboration Text
|
|
|
11. SOLUTION- Sharing - Collaboration Video
|
|
|
2. Sharing - Collaboration Options Video
|
|
|
3. Sharing Reports- Dashboards - Apps Video
|
|
|
4. Defining User Roles - Permissions Video
|
|
|
5. Publishing Apps Video
|
|
|
6. Publishing to Web Video
|
|
|
7. PRO TIP- Generating Usage Reports Video
|
|
|
8. BEST PRACTICES- Sharing - Collaboration Video
|
|
|
9. ASSIGNMENT- Sharing - Collaboration Video
|
|
|
|
6. Row-Level Security
|
|
1. Introduction Video
|
|
|
2. Static RLS Video
|
|
|
3. Testing RLS Video
|
|
|
4. Dynamic RLS Video
|
|
|
5. Configuring RLS in Power BI Service Video
|
|
|
6. BEST PRACTICES- Row-Level Security Video
|
|
|
7. ASSIGNMENT- Row-Level Security Video
|
|
|
8. INSTRUCTIONS- Row-Level Security Text
|
|
|
9. SOLUTION- Row-Level Security Video
|
|
|
|
7. Premium Per User -Preview-
|
|
1. Introduction Video
|
|
|
2. Premium Per User Workspace Video
|
|
|
3. Premium Per User Features Video
|
|
|
|
8. Monthly Power BI Updates
|
|
1. REFERENCE- Monthly Power BI Updates Text
|
|
|
Description
Related Torrents
Trackers
| Tracker name |
| udp://tracker.coppersurfer.tk:6969/announce |
| udp://9.rarbg.me:2850/announce |
| udp://9.rarbg.to:2920/announce |
| udp://tracker.opentrackr.org:1337 |
| udp://tracker.leechers-paradise.org:6969/announce |
Torrent hash:
Copied!