~Get Your Files Here !

  1. Introduction

   1. Welcome to this course!.srt

   2. Who is the course for.srt

   3. Understanding the exam.srt

   4. How to learn with the course.srt

   5. Our project.srt

   6. Installing Power BI Desktop.srt

  2. Peparing the Data (15-20%)

   10. Append queries.mp4

   10.2 Combine multiple tables into a single table (part I).html

   10.4 sales2019.csv

   11. Merge queries.srt

   11.3 sales_details.csv

   12. Pivot & Unpivot.srt

   12.3 Unpivot tables (Shape the initial data).html

   13. Conditional columns.srt

   14. Columns from examples.mp4

   14.1 Add a column from example.html

   15. Transpose.srt

   16. Data Profiling.mp4

   16.1 Profile data in Power BI.html

   17. Resolve data import errors.srt

   18. -- Getting data from different data sources II --.html

   19. Files from folders.srt

   19.3 sales_details1.csv

   19.5 sales_details3.csv

   19.7 sales_details5.csv

   2. Connect to a data source.srt

   2.2 Get data from files (part I).html

   20. Relational SQL database.srt

   20.2 Get data from relational data sources.html

   21. Select a storage mode.srt

   22. Dataverse.mp4

   23. Data Loading with parameters.mp4

   24. Preparing the Data.html

   3. Change the data source settings.srt

   4. -- Clean, transform and load the data --.html

   5. The Query Editor.srt

   6. Shape and transform tables.mp4

   6.2 Shape the initial data (part II).html

   7. User-friendly naming conventions.srt

   8. Resolving inconsistencies & nulls.mp4

   8.2 Simplify the data structure.html

   9. Evaluate and transform column data types.srt

   Append queries.pbix

   Change data source settings.pbix

   Conditional column.pbix

   Evaluate and change data type.pbix

   Files from folder.pbix

   Files from folder

    sales_details2.csv

    sales_details4.csv

   Merge queries.pbix

   Profiling data.pbix

   Resolving inconsistencies & nulls.pbix

   Shape and transform tables.pbix

   costs table.csv

   sales2019.csv

  3. Model the Data (30-35%)

   10. Mark as date table.mp4

   10.2 Set and use date tables in Power BI Desktop.html

   11. Hierarchies.srt

   12. Data Granularity.mp4

   12.1 Data granularity.html

   13. Role playing dimensions.srt

   13.3 Shipping Date.csv

   15. Calculated columns.mp4

   15.1 Add calculated tables and columns.html

   16. Measures.srt

   17. Iterator functions.mp4

   17.2 Use iterator functions.html

   18. CALCULATE.srt

   19. FILTER.mp4

   2. Why a data model.mp4

   2.1 Relationship purpose.html

   20. ALL.srt

   21. Time intelligence.mp4

   21.2 Use DAX time intelligence in Power BI.html

   22. Semi-additive measures.srt

   23. Statistical functions.mp4

   24. Quick measures.mp4

   24.1 Use quick measures.html

   26. Optimize model performance.mp4

   26.1 Model optimization resource.pdf

   27. Identifiy poorly performing measures, relationships, and visuals.mp4

   27.2 Review performance of measures, relationships, and visuals.html

   3. The star schema.mp4

   3.1 The star schema.html

   4. Creating relationships.mp4

   4.2 dim_products.csv

   5. Cardinality.mp4

   5.1 Cardinality.html

   6. Cross filter direction.srt

   7. Table and column properties.mp4

   7.2 Working with tables.html

   8. Common date table (using DAX).srt

   8.3 Date table (DAX part).html

   9. Common date table (using Power Query).srt

   ALL.pbix

   Calculated columns.pbix

   Creating a date table.pbix

   Data Granularity.pbix

   FactCmpySales_2017.csv

   Identifying measures.pbix

   Mark table as date table.pbix

   Optimize Model Performance.pbix

   Semi-additive measures.pbix

   Statistical functions.pbix

   Time Intelligence.pbix

   Why a data model.pbix

   dim_products.csv

   sales2018.csv

  4. Visualize and Analyze the Data (25-30%)

   10. Configure report page.mp4

   10.1 Design a report layout.html

   11. Conditional formatting.srt

   12. Applying slicing and filtering.mp4

   12.2 Apply slicing, filtering, and sorting.html

   13. Sorting.srt

   14. -- Enhance reports for usability and storytelling --.html

   15. Synch slicers.srt

   16. Using themes.mp4

   16.1 Design a report layout (Themes).html

   17. Drillthroughs and drill downs.srt

   17.3 Setting up drillthrough.html

   18. Bookmarks.srt

   19. Page navigation.mp4

   19.1 Design report navigation.html

   2. Table and matrix.mp4

   2.1 Choose an effective visualization (table and matrix part).html

   20. Edit interactions.srt

   21. Analyze feature.mp4

   21.2 Use the Analyze feature.html

   22. Identify outliers.srt

   23. Create groups, bins and clusters.mp4

   23.1 Apply clustering techniques.html

   24. Analytics pane.mp4

   24.2 Use the Analytics pane.html

   25. Forecast feature.srt

   26. AI features.mp4

   26.2 Apply AI Insights.html

   3. Column charts, line charts and area charts.mp4

   3.1 Choose an effective visualization (bar charts, column charts and area charts).html

   4. Combo charts and treemaps.srt

   5. Card, multi-row card, and gauge visual.mp4

   5.2 Choose an effective visualization (cards, multi-row cards, and gauge visual).html

   6. Pie chart, donut chart and funnel.srt

   7. Scatter chart, waterfall chart and maps.srt

   8. Customize and configure visuals.mp4

   8.1 Format and configure visualizations.html

   9. Custom tool tips.srt

   AI feature.pbix

   Analyze feature.pbix

   Cards, multi-row card and gauge.pbix

   Configure bookmarks.pbix

   Edit interactions.pbix

   Forecast feature.pbix

   Format report page.pbix

   Identifying outliers.pbix

   Pie Chart, Donut Chart and more.pbix

   Sorting.pbix

   Themes.pbix

   Waterfall chart, scatter chart and maps.pbix

   dim_products.csv

   sales2018.csv

   treemaps and combo charts.pbix

  5. Deploy and Maintain Assets (20-25%)

   10. Create a workspace app.mp4

   10.1 Create and configure an app.html

   11. Publish, import, or update assets in a workspace.srt

   12. -- Create dashboards --.html

   13. Manage tiles in a dashboard.srt

   14. Pin live page to a dashboard.mp4

   14.1 Pin a live report page to a dashboard.html

   15. Q&A feature.srt

   16. Apply a dashboard theme.mp4

   16.1 Add a dashboard theme.html

   17. Configure mobile layout.srt

   18. Get insights.mp4

   18.1 Review Quick insights.html

   2. How to go on from here.mp4

   20. Identify when a gateway is required.mp4

   20.1 Use a Power BI gateway to connect to on-premises data sources.html

   21. Configure a dataset scheduled refresh.srt

   22. Subscriptions.mp4

   23. Data alerts.mp4

   23.1 Set data alerts.html

   24. Promote or certify content.srt

   25. Define RLS roles in Power BI Desktop.mp4

   25.1 Define roles and rules in Power BI Desktop.html

   26. Configure row-level security group membership.srt

   27. Dynamic RLS.mp4

   27.1 Security Table.xlsx

   28. Providing access to a dataset.srt

   29. When to use paginated reports.srt

   3. Subscription models.mp4

   30. Import custom visuals.mp4

   30.1 Import a custom visual.html

   31. Analyze in Excel feature.srt

   32. Deploy and Maintain Assets.html

   4. Sign up for Power BI service.srt

   5. Power BI interface.srt

   6. Publish reports and export data.srt

   7. Sensitivity labels.mp4

   7.1 Configure data protection.html

   8. Create a workspace.srt

   9. Assign workspace roles.mp4

   9.1 Assign workspace roles.html

  6. Case studies & final practice test

   1. Mastering the case studies.srt

   3. Tips for the final exam simulation.mp4

   4. Final exam simulation.html

  7. Scheduling the exam & final tips

   1. Schedule the exam & start the exam.srt

   2. Exam tips.srt

   3. Post your certification.srt

   4. Renewing your certification.srt

  Bonus Resources.txt