Login

OTP sent to

Power BI

Home > Courses > Power BI

Power BI

Power BI

Duration
45 Hours

Course Description

         Power BI provides cloud-based BI (business intelligence) services, known as "Power BI Services", along with a desktop-based interface, called "Power BI Desktop". It provides data warehouse capabilities including data preparation, data mining, and interactive dashboards.

Course Outline For Power BI

1. Introduction to Power BI

  • Defining Power BI and its importance in the field of Business Intelligence.

Understanding the different Power BI components:

  • Power BI Desktop: A free desktop application for data modeling, visualization, and report creation.
  • Power BI Service: A cloud-based platform for sharing, collaboration, and managing reports and dashboards.
  • Power BI Mobile: Apps for viewing reports and dashboards on mobile devices.
  • Power BI Report Server: For on-premises report management and sharing.
  • Exploring the benefits of using Power BI, including ease of use, data connectivity, interactive visualizations, and collaboration features. 

2. Connecting to data sources

  • Identifying and connecting to various data sources, including Excel files, SQL Server databases, Azure data services, and online services.
  • Understanding different data connection options: Import, DirectQuery, and Live Connection. 

3. Data transformation and modeling

  • Power Query Editor: Utilizing the Power Query Editor to clean, shape, and transform data from diverse sources.
  • Data Transformation Techniques: Applying transformations like column manipulation, data type conversion, filtering, sorting, merging, and appending tables.
  • Data Modeling with DAX: Building relationships between tables, creating hierarchies, and defining measures and calculated columns using Data Analysis Expressions (DAX).
  • Understanding different types of cardinality and cross-filtering in DAX.
  • Using DAX functions like CALCULATE, FILTER, and aggregation functions for advanced calculations.
  • Optimizing data models for performance. 

4. Visualization and reporting

  • Designing interactive reports using various visualization types, including charts (bar, line, pie, etc.), tables, matrices, and maps.
  • Customizing visualization properties and report layouts.
  • Implementing slicing, filtering, and conditional formatting to enhance report interactivity.
  • Creating dashboards by pinning visuals from reports and customizing their appearance and interactivity.
  • Utilizing bookmarks, drill-through, and tooltips for better data storytelling. 

5. Sharing and collaboration

  • Publishing reports and dashboards to the Power BI Service.
  • Managing workspaces and collaborating with colleagues.
  • Sharing reports and dashboards securely with individuals, groups, or the organization.
  • Configuring row-level security (RLS) to restrict data access based on user roles.
  • Integrating with other Microsoft products like SharePoint and Teams. 

6. Power BI administration and advanced topics

  • Power BI Gateways: Understanding gateway types (standard and personal) and configuring data source connections to refresh on-premises data.
  • Scheduling data refreshes for datasets.
  • Implementing security features, including RBAC, auditing, and data sensitivity labels.
  • Exploring Power BI Embedded for integrating reports and dashboards into custom applications.
  • Using Power BI with R and Python for custom visualizations and advanced analytics. 

7. Real-world applications and certification

  • Exploring practical applications of Power BI in various industries like finance, healthcare, and retail through case studies and examples.
  • Preparation for the Microsoft Certified: Power BI Data Analyst Associate (PL-300) certification exam. 
Enquire Now