Be a Dashboard Architect with great ease and be more effective in delivering insights on business critical information.
TEAM ACADEMY offers an in depth learning on how to use Microsoft Power Bi for automating dashboards across industries and business disciplines,
Power BI is a collection of software services, apps, and connectors that work together to turn your unrelated sources of data into coherent, visually immersive, and interactive insights. Your data may be an Excel spreadsheet, or a collection of cloud-based and on-premises hybrid data warehouses. Power BI lets you easily connect to your data sources, visualize and discover what’s important, and share that with anyone or everyone you want.
A Windows desktop application called Power BI Desktop is used by the report authors to create dashboards and publish it to the end users for analytics.
In this course we learn how to use Power BI desktop for Authoring dashboards , drill down into data and represent data in the most suitable format.
What you’ll learn
- Build professional-quality business intelligence reports from the ground up
- Blend and transform raw data into beautiful interactive dashboards
- Design and implement the same B.I. tools used by professional analysts and data scientists
- Showcase your skills with two full-scale course projects (with step-by-step solutions)
- Understand the business intelligence workflow from end-to-end
- Learn from a best-selling instructor and professional BI developer
Course Curriculum
| Introduction to POWER BI Desktop | |||
| Introduction to Power BI Details | FREE | 00:30:00 | |
| POWER BI – tools & connecting with other apps Details | 00:00:00 | ||
| Downloading Power BI & Adjusting Settings Details | 00:00:00 | ||
| Exploring the Power BI Desktop Interface & Workflow Details | 00:00:00 | ||
| New Power BI Ribbon & other helpful resources Details | 00:00:00 | ||
| Data Transformation | |||
| Types of Data Connectors in Power BI Desktop Details | 00:00:00 | ||
| The Power BI Query Editor Details | 00:00:00 | ||
| Basic Table Transformations in Power BI Details | 00:00:00 | ||
| Power BI Demo: Working with Text Tools Details | 00:00:00 | ||
| Power BI Demo: Working with Numerical Values Details | 00:00:00 | ||
| Power BI Demo: Working with Date & Time Tools Details | 00:00:00 | ||
| Creating a Rolling Calendar in Power BI Desktop Details | 00:00:00 | ||
| Generating Index & Conditional Columns Details | 00:00:00 | ||
| Grouping & Aggregating Records Details | 00:00:00 | ||
| Pivoting & Unpivoting Data Details | 00:00:00 | ||
| Appending Queries in Power BI Desktop Details | 00:00:00 | ||
| Configuring Power BI Data Source Settings Details | 00:00:00 | ||
| Configuring Power BI Query Refresh Settings Details | 00:00:00 | ||
| Data Types & Categories in Power BI Details | 00:00:00 | ||
| Defining Hierarchies in Power BI Desktop Details | 00:00:00 | ||
| Importing Models from Excel to Power BI Details | 00:00:00 | ||
| Power BI Data Connection Best Practices Details | 00:00:00 | ||
| Creating Table Relationships & Data Models in Power BI | |||
| What is a “Data Model”? Details | 00:00:00 | ||
| Principles of Database Normalization Details | 00:00:00 | ||
| Understanding Data Tables vs. Lookup Tables Details | 00:00:00 | ||
| Understanding Table Relationships vs. Merged Tables Details | 00:00:00 | ||
| Creating Table Relationships in Power BI Desktop Details | 00:00:00 | ||
| Managing & Editing Table Relationships in Power BI Desktop Details | 00:00:00 | ||
| Managing Active vs. Inactive Relationships Details | 00:00:00 | ||
| Understanding Relationship Cardinality Details | 00:00:00 | ||
| Connecting Multiple Data Tables in Power BI Desktop Details | 00:00:00 | ||
| Understanding Filter Flow Details | 00:00:00 | ||
| Hiding Fields from the Power BI Report View Details | 00:00:00 | ||
| Power BI Desktop “Model” View Details | 00:00:00 | ||
| Analyzing Data with DAX Calculations in Power BI | |||
| Intro to DAX Calculated Columns Details | 00:00:00 | ||
| Intro to DAX Measures Details | 00:00:00 | ||
| Calculated Columns vs. DAX Measures Details | 00:00:00 | ||
| Adding Columns & DAX Measures in Power BI Desktop Details | 00:00:00 | ||
| Filter Context Examples in Power BI Details | 00:00:00 | ||
| Understanding DAX Syntax & Operators Details | 00:00:00 | ||
| Common DAX Function Categories Details | 00:00:00 | ||
| DAX Demo: Basic Date & Time Functions Details | 00:00:00 | ||
| DAX Demo: Conditional & Logical Functions (IF/AND/OR) Details | 00:00:00 | ||
| DAX Demo: Common Text Functions Details | 00:00:00 | ||
| DAX Demo: Other Useful Functions Details | 00:00:00 | ||
| Visualizing Data with Power BI Reports | |||
| Exploring the “Report” View in Power BI Desktop Details | 00:00:00 | ||
| Adding Simple Objects to the Power BI Report Canvas Details | 00:00:00 | ||
| Inserting Basic Charts & Visuals in Power BI Details | 00:00:00 | ||
| Power BI Report Formatting Options Details | 00:00:00 | ||
| Power BI Report Filtering Options Details | 00:00:00 | ||
| Power BI Demo: Exploring Data with Matrix Visuals Details | 00:00:00 | ||
| Power BI Demo: Filtering with Date Slicers Details | 00:00:00 | ||
| Power BI Demo: Showing Key Metrics with Cards & KPI Visuals Details | 00:00:00 | ||
| Power BI Demo: Inserting Text Cards Details | 00:00:00 | ||
| Power BI Demo: Visualizing Geospatial Data with Maps Details | 00:00:00 | ||
| Power BI Demo: Visualizing Data with Treemaps Details | 00:00:00 | ||
| Power BI Demo: Showing Trends with Line & Area Charts Details | 00:00:00 | ||
| Power BI Demo: Adding Trend Lines & Forecasts Details | 00:00:00 | ||
| Power BI Demo: Goal Pacing with Gauge Charts Details | 00:00:00 | ||
| Editing Power BI Report Interactions Details | 00:00:00 | ||
| Power BI Demo: Adding Drillthrough Filters Details | 00:00:00 | ||
| Testing Scenarios with “What-If” Parameters Details | 00:00:00 | ||
| POWER BI Desktop - Administrative settings | |||
| Managing & Viewing Roles in Power BI Desktop Details | 00:00:00 | ||
| Custom Power BI Visuals (Log-in Required) Details | 00:00:00 | ||
| Designing for Phone vs. Desktop Report Viewers Details | 00:00:00 | ||
| Publishing to Power BI Service Details | 00:00:00 | ||
| Power BI Data Visualization Best Practices Details | 00:00:00 | ||
| NEW: Artificial Intelligence (AI) Visuals & Predictive Analysis with POWER BI | |||
| Power BI Demo: Q&A Visual Details | 00:00:00 | ||
| Power BI Demo: Key Influencers Visual (Part 1) Details | 00:00:00 | ||
| Power BI Demo: Decomposition Tree Visual Details | 00:00:00 | ||
Course Reviews
No Reviews found for this course.
Instructors
8456 STUDENTS ENROLLED
Recent Comments