Overview:
Learn how to create powerful interactive dashboards, custom reports, analyze data and share insights in this course. After the completion of this course you will be able to create rich dashboards available on every device, which will allow you to monitor your business and get answers quickly.
Audience:
Business Analysts, Financial Analysts, Quants, Data Scientists who need to use Power BI for producing reports from Excel, SQL Server and other databases
Course Curriculum
| Power BI Introduction | |||
| Power BI Details | 00:00:00 | ||
| Desktop vs Services Details | 00:00:00 | ||
| Power BI vs other BI tools Details | 00:00:00 | ||
| Power BI Desktop | |||
| Data Models Details | 00:00:00 | ||
| Schemas Details | 00:00:00 | ||
| Relationships Details | 00:00:00 | ||
| Connectivity Details | 00:00:00 | ||
| Design Environment Details | 00:00:00 | ||
| Importing Data Details | 00:00:00 | ||
| Dashboards in Desktop Details | 00:00:00 | ||
| Get data from different sources Details | 00:00:00 | ||
| Custom Colours Details | 00:00:00 | ||
| PowerBi template Details | 00:00:00 | ||
| Desktop Three views Details | 00:00:00 | ||
| Data View: Column Sort, formatting, hiding columns Details | 00:00:00 | ||
| Relation ship view: create and manage relationships Details | 00:00:00 | ||
| Relationship Cardinality: 1-to-1, 1-to-many, many-to-many Details | 00:00:00 | ||
| Create and format visuals Details | 00:00:00 | ||
| Slicers Details | 00:00:00 | ||
| Highlight and filter Details | 00:00:00 | ||
| Control Filter interaction Details | 00:00:00 | ||
| Hierarchies Details | 00:00:00 | ||
| Drill Down Details | 00:00:00 | ||
| Show data and show records in Drilldown Details | 00:00:00 | ||
| Publish reports/Dashboards Details | 00:00:00 | ||
| Monthly Updates Details | 00:00:00 | ||
| Power BI Service | |||
| Self-service BI Details | 00:00:00 | ||
| Organisational BI Details | 00:00:00 | ||
| Portal Details | 00:00:00 | ||
| Content Items Details | 00:00:00 | ||
| Datasets Details | 00:00:00 | ||
| Connecting to Data Details | 00:00:00 | ||
| Visualizing Data Details | 00:00:00 | ||
| Licence schema Details | 00:00:00 | ||
| Load data in Power BI services Details | 00:00:00 | ||
| Create Reports in Power BI services Details | 00:00:00 | ||
| Pin visuals to dashboard Details | 00:00:00 | ||
| Dashboard Flow and Navigation Details | 00:00:00 | ||
| Power BI for Mobile Details | 00:00:00 | ||
| Dashboard Tiles Details | 00:00:00 | ||
| Dashboard customization Details | 00:00:00 | ||
| Natural Language Queries Details | 00:00:00 | ||
| Quick Insights Details | 00:00:00 | ||
| Inbuilt Demo Samples Details | 00:00:00 | ||
| Web publication Details | 00:00:00 | ||
| Power BI to PowerPoint export Details | 00:00:00 | ||
| Data Modelling | |||
| Queries & the Query Editor Details | 00:00:00 | ||
| Shaping & Cleansing Data Details | 00:00:00 | ||
| Combining Datasets Details | 00:00:00 | ||
| Functions Details | 00:00:00 | ||
| Date Tables – Building customised time intelligence Details | 00:00:00 | ||
| Loading Transformed Data Details | 00:00:00 | ||
| Query Editor in brief Details | 00:00:00 | ||
| Query Design explained Details | 00:00:00 | ||
| Query editors tabs and menus Details | 00:00:00 | ||
| Best Practice for Queries Details | 00:00:00 | ||
| Applied Steps Details | 00:00:00 | ||
| Advanced Query Editor Details | 00:00:00 | ||
| Data Transformations Details | 00:00:00 | ||
| Data cleaning Details | 00:00:00 | ||
| Dataset merges Details | 00:00:00 | ||
| Unpivoting Details | 00:00:00 | ||
| Accessing data from a Folder Details | 00:00:00 | ||
| Appending techniques Details | 00:00:00 | ||
| Columns Details | 00:00:00 | ||
| Dynamic Fiscal Calendar Tables Details | 00:00:00 | ||
| Reports/Dashboards | |||
| Reading View Details | 00:00:00 | ||
| Editing View Details | 00:00:00 | ||
| Visualisations and Custom Visualisations Details | 00:00:00 | ||
| Dashboards Details | 00:00:00 | ||
| Creating & formatting Dashboards Details | 00:00:00 | ||
| Creating visuals Details | 00:00:00 | ||
| Choosing the best visual Details | 00:00:00 | ||
| Interactivity between visuals Details | 00:00:00 | ||
| Visuals in Preview and Custom Visuals Details | 00:00:00 | ||
| Formatting visuals Details | 00:00:00 | ||
| Types of Conditional Formatting Details | 00:00:00 | ||
| Optimizing the Matrix Layouts Details | 00:00:00 | ||
| Adding Drill-Downs Details | 00:00:00 | ||
| Viewing the Underlying Data Driving a Visualization Details | 00:00:00 | ||
| Understanding Row Level Security Details | 00:00:00 | ||
| Creating and Testing Security Roles Details | 00:00:00 | ||
| DAX & Calculations | |||
| Data Analysis Expressions Details | 00:00:00 | ||
| Calculated Columns Details | 00:00:00 | ||
| Measures – How your data is summarised Details | 00:00:00 | ||
| DAX Syntax Details | 00:00:00 | ||
| DAX Functions Details | 00:00:00 | ||
| Advanced Relationships Details | 00:00:00 | ||
| Dax Operators Details | 00:00:00 | ||
| Calculated Measures & Calculated Columns Details | 00:00:00 | ||
| Implicit Vs Explicit Details | 00:00:00 | ||
| Base Measures & Metrics Details | 00:00:00 | ||
| Commonly Used DAX Functions Details | 00:00:00 | ||
| DAX Aggregate functions Details | 00:00:00 | ||
| Iterators: SUMX, MAXX, AVERAGEX Details | 00:00:00 | ||
| IF conditional statements Details | 00:00:00 | ||
| Cross Table Lookups Details | 00:00:00 | ||
| Evaluating Context in the relationship Details | 00:00:00 | ||
| CALCULATE: the magic function Details | 00:00:00 | ||
| USERELATIONSHIP function Details | 00:00:00 | ||
| Time Intelligence prerequisites Details | 00:00:00 | ||
| Time intelligence functions (MTD, QTD, YTD, Prior Year) Details | 00:00:00 | ||
| Create a time Intelligence report Details | 00:00:00 | ||
| Publishing & Sharing Dashboards & Reports | |||
| Sharing Dashboards Details | 00:00:00 | ||
| Creating Workspace Details | 00:00:00 | ||
| Publish App Details | 00:00:00 | ||
| Security Details | 00:00:00 | ||
| Publishing Models to the Cloud Service Details | 00:00:00 | ||
| Adding Users to Security Defined Roles Details | 00:00:00 | ||
| Basic Sharing of Dashboards & Reports Details | 00:00:00 | ||
| Multiple ways of sharing reports and Dashboards Details | 00:00:00 | ||
| Creating App Workspaces Details | 00:00:00 | ||
| Collaborating on Reports Details | 00:00:00 | ||
| Publishing Organisational Apps for Distribution of Content Details | 00:00:00 | ||
| Adding Users & Editing Workspaces Details | 00:00:00 | ||
| Connecting to Apps Details | 00:00:00 | ||
| Data Refreshing | |||
| The Data Gateway Details | 00:00:00 | ||
| Data Refresh schedules Details | 00:00:00 | ||
| On-Demand Refresh Details | 00:00:00 | ||
| Power BI Mobile | |||
| Native Applications (iOS/Android/Windows) Details | 00:00:00 | ||
| Optimising deployment on different platforms Details | 00:00:00 | ||
| Configure reports for Mobile view Details | 00:00:00 | ||
| Configure Dashboard for Mobile view Details | 00:00:00 | ||
| Viewing Content Details | 00:00:00 | ||
| Sharing & Collaboration Details | 00:00:00 | ||
| Configuring Alerts Details | 00:00:00 | ||
Course Reviews
No Reviews found for this course.
0 STUDENTS ENROLLED