Power BI Course

by Training Hub Claim Listing

Power BI is your enterprise analytics solution, uniting data from diverse sources to create interactive dashboards and Business Intelligence reports. With Power BI Desktop, you craft datasets, reports, and visualizations.

Price : Enquire Now

Contact the Institutes

Fill this form

Advertisement

Training Hub Logo

img Duration

Please Enquire

Course Details

Power BI is your enterprise analytics solution, uniting data from diverse sources to create interactive dashboards and Business Intelligence reports. With Power BI Desktop, you craft datasets, reports, and visualizations.

Monitor your business using dynamic dashboards, powered by this cloud-based suite. It offers a range of solutions for data visualization, including programming services, applications, and data connectors. Unleash the power of data with Power BI, simplifying the path to actionable insights.

 

Course Objectives

  • Explore the key features and components of Power BI Desktop.
  • Acquire the skills to clean, filter, and prepare data for analysis.
  • Gain hands-on experience in DAX formula creation.
  • Collaborate on Power BI reports and dashboards online.
  • Explore the potential of AI-powered analytics in Power BI.
  • Learn how to connect Power BI to various data sources.
  • Understand the principles of data modeling in Power BI.
  • Discover the art of data visualization and report design.
  • Explore AI and data integration's latest advancements.
  • Introduce participants to Microsoft Fabrics and Chat GPT.

 

Student Journey Throughout The Course

Once you enroll in our Power BI training, your journey involves several key steps. You will be trained by our tutor with a minimum of 7+ years of Power BI/relevant IT experience. We will guide you to master Power BI Desktop, Data modeling, DAX, Power BI Services, visualizations & reports.

The training is designed for BI, reporting professionals, data analysts, professionals working with data in any sector, and individuals looking to up-skill their knowledge in Power BI (There are no specific prerequisites for this training, anyone can get this course and get trained in Power BI).

 

Course content

Unit 1: Introducing Microsoft Power BI Desktop

  • Meet Power BI Desktop
  • Downloading Power BI
  • Adjusting Settings
  • Power BI Desktop Interface & Workflow
  • Resources & Monthly Updates
  • Introduction to the Project 1 Dataset
  • Preliminary visualization and dashboard development

 

Unit 2: Connecting & Shaping Data

  • Power BI Front-end and Back-end
  • Types of data connectors
  • Introduction to Power Query Editor Layout
  • Transformations: a. Index and conditional column b. Calculated column c. Grouping & Aggregating d. Pivoting & Un-pivoting e. Merging Queries & Joins f. Appending Queries g. Data source setting and refreshing queries h. Folders and append queries i. Advanced queries, M Language, and customization

 

Unit 3: Data Modeling

  • Fact Table & Dim Table
  • Primary, Foreign & Composite Key
  • Cardinality – 121, 12Many & Many21, Many2Many
  • Cross Filter Direction & Security
  • Data Model Diagrams and how Visuals interact based on the relationships
  • Star & Snowflake Schemas
  • Introduction to Project 2

 

Unit 4: DAX

  • Dax v/s M Language
  • Introduction to Project 3
  • DAX as calculated columns
  • DAX as measures
  • Quick Measures
  • Time intelligence functions
  • Dedicated Measure Tables
  • Parameters
  • DAX Syntax & Operators
  • Maths & Stats Operations
  • Conditional Functions
  • Switch Functions
  • Logical Functions
  • Variables
  • Data Modelling & DAX
  • Data & Time 
  • Running Totals
  • TopN Dynamic DAX Functions
  • DAX for date difference excluding weekends
  • All, SelectAll
  • Filter
  • Iterators
  • DAX Best Practice

 

Unit 5: Visualizing data with reports

 

Unit 6: Power BI Service

  • Introduction to Pro & Premium Capacity 
  • Publishing a dashboard 
  • Workspace & Gateways
  • Security
  • Scheduled refresh
  • Sharing dashboard and managing permissions
  • Subscriptions
  • Live Streaming
  • Connecting to advanced JSON Files 
  • Introduction to Data Mart
  • Introduction to Project 4

 

Unit 7: Bonus Lecture | Power BI, AI, Microsoft Fabrics & Chat GPT – Prototype Introduction

  • Toronto Branch

    #402 - 989 Derry Road East, Toronto

Check out more Power BI courses in Canada

Eccentrix Logo

Power BI Data Analyst Associate (PL300)

This Microsoft certified course covers the various methods and best practices that are in line with business and technical requirements for modeling, visualizing, and analyzing data with Power BI.

by Eccentrix [Claim Listing ]
Juno Logo

Data Analytics Course

Learn to analyze data with our data analytics course for beginners. Through hands-on training, you'll gain a foundational understanding of in-demand data tools and the confidence to apply them in your everyday work.

by Juno [Claim Listing ]
We Cloud Data Logo

Big Data for Data Scientists

Big Data for Data Scientists is a 6-week project-based course that teaches data scientists the necessary tools to work on large-scale data science problems. The entire course is built around an end-to-end real-time machine learning problem.

by We Cloud Data [Claim Listing ]
ACRA Training Logo

Tableau Desktop Fundamentals

In this Tableau Boot Camp class, we will learn how we can leverage the power of visualization. We will explore data visualization and how we can use it to better understand data using Tableau.

by ACRA Training [Claim Listing ]
Coding Classes Toronto Logo

Data Analytics Certificate

Learn the essential skills needed to become a Data Analyst or Business Analyst, including data analysis, data visualization, and statistical analysis. Gain practical experience through real-world projects and prepare for a successful career in the field of data analytics.

by Coding Classes Toronto [Claim Listing ]

© 2024 coursetakers.com All Rights Reserved. Terms and Conditions of use | Privacy Policy