Search

Enroll Now

Your shopping cart

Subtotal:

$121

View Cart
Checkout

PL-300T00

Overview Exclusive - This 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.The course will show how to access and process data from a range of data sources including both relational and non-relational sources. Finally, this course will also discuss how to manage and deploy reports and dashboards for sharing and content distribution.

Submit Call Back Request
Download Course Brochure

Book Demo Now and Start Learning!

Submit Details & Get a Free Demo Session

Overview

 Exclusive - This 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.

The course will show how to access and process data from a range of data sources including both relational and non-relational sources. Finally, this course will also discuss how to manage and deploy reports and dashboards for sharing and content distribution.

Successful Data Analysts start this role with experience of working with data in the cloud.

Specifically:

  • Understanding core data concepts.
  • Knowledge of working with relational data in the cloud.
  • Knowledge of working with non-relational data in the cloud.
  • Knowledge of data analysis and visualization concepts.

Students will learn to,

  • Discover data analysis
  • Get started building with Power BI
  • Get data in Power BI
  • Clean, transform, and load data in Power BI
  • Design a data model in Power BI
  • Add measures to Power BI Desktop models
  • Add calculated tables and columns to Power BI Desktop models
  • Use DAX time intelligence functions in Power BI Desktop models
  • Optimize a model for performance in Power BI
  • Design Power BI reports
  • Configure Power BI report filters
  • Enhance Power BI report designs for the user experience
  • Perform analytics in Power BI
  • Create and manage workspaces in Power BI
  • Manage datasets in Power BI
  • Create dashboards in Power BI
  • Implement row-level security

Module 1 :Discover data analysis

  • Learn about the roles in data.
  • Learn about the tasks of a data analyst.

Module 2 :Get started building with Power BI

  • Learn how Power BI services and applications work together.
  • Explore how Power BI can make your business more efficient.
  • Learn how to create compelling visuals and reports.

Module 3 :Get data in Power BI

  • Identify and connect to a data source
  • Get data from a relational database, like Microsoft SQL Server
  • Get data from a file, like Microsoft Excel
  • Get data from applications
  • Get data from Azure Analysis Services
  • Select a storage mode
  • Fix performance issues
  • Resolve data import errors

Module 4 :Clean, transform, and load data in Power BI

  • Resolve inconsistencies, unexpected or null values, and data quality issues.
  • Apply user-friendly value replacements.
  • Profile data so you can learn more about a specific column before using it.
  • Evaluate and transform column data types.
  • Apply data shape transformations to table structures.
  • Combine queries.
  • Apply user-friendly naming conventions to columns and queries.
  • Edit M code in the Advanced Editor.

Module 5 :Design a data model in Power BI

  • Create common date tables
  • Configure many-to-many relationships
  • Resolve circular relationships
  • Design star schemas

Module 6 : Add measures to Power BI Desktop models

  • Determine when to use implicit and explicit measures.
  • Create simple measures.
  • Create compound measures.
  • Create quick measures.
  • Describe similarities of, and differences between, a calculated column and a measure.

Module 7 : Add calculated tables and columns to Power BI Desktop models

  • Create calculated tables.
  • Create calculated columns.
  • Identify row context.
  • Determine when to use a calculated column in place of a Power Query custom column.
  • Add a date table to your model by using DAX calculations.

Module 8 : Use DAX time intelligence functions in Power BI Desktop models

  • Define time intelligence.
  • Use common DAX time intelligence functions.
  • Create useful intelligence calculations.

Module 9 : Optimize a model for performance in Power BI

  • Review the performance of measures, relationships, and visuals.
  • Use variables to improve performance and troubleshooting.
  • Improve performance by reducing cardinality levels.
  • Optimize DirectQuery models with table level storage.
  • Create and manage aggregations.

Module 10 : Design Power BI reports

  • Learn about the structure of a Power BI report.
  • Learn about report objects.
  • Select the appropriate visual type to use.

Module 11 : Configure Power BI report filters

  • Design reports for filtering.
  • Design reports with slicers.
  • Design reports by using advanced filtering techniques.
  • Apply consumption-time filtering.
  • Select appropriate report filtering techniques.

Module 12 : Enhance Power BI report designs for the user experience

  • Design reports to show details.
  • Design reports to highlight values.
  • Design reports that behave like apps.
  • Work with bookmarks.
  • Design reports for navigation.
  • Work with visual headers.
  • Design reports with built-in assistance.
  • Use specialized visuals.

Module 13 : Perform analytics in Power BI

  • Explore statistical summary.
  • Identify outliers with Power BI visuals.
  • Group and bin data for analysis.
  • Apply clustering techniques.
  • Conduct time series analysis.
  • Use the Analyze feature.
  • Use advanced analytics custom visuals.
  • Review Quick insights.
  • Apply AI Insights.

Module 14 : Create and manage workspaces in Power BI

  • Create and manage Power BI workspaces and items.
  • Distribute a report or dashboard.
  • Monitor usage and performance.
  • Recommend a development lifecycle strategy.
  • Troubleshoot data by viewing its lineage.
  • Configure data protection.

Module 15 : Manage datasets in Power BI

  • Use a Power BI gateway to connect to on-premises data sources.
  • Configure a scheduled refresh for a dataset.
  • Configure incremental refresh settings.
  • Manage and promote datasets.
  • Troubleshoot service connectivity.
  • Boost performance with query caching (Premium).

Module 16 : Create dashboards in Power BI

  • Set a mobile view.
  • Add a theme to the visuals in your dashboard.
  • Configure data classification.
  • Add real-time dataset visuals to your dashboards.
  • Pin a live report page to a dashboard.

Module 17 : Implement row-level security

  • Configure row-level security by using a static method.
  • Configure row-level security by using a dynamic method.

Successful Data Analysts start this role with experience of working with data in the cloud.

Specifically:

  • Understanding core data concepts.
  • Knowledge of working with relational data in the cloud.
  • Knowledge of working with non-relational data in the cloud.
  • Knowledge of data analysis and visualization concepts.

Exam PL-300: Microsoft Power BI Data Analyst

Trainer Profile

Mr. Mohammed Gufran

Mr. Mohammed Gufran

Cisco Instructor

Gufran, a Cisco Authorized and CCIE certified instructor, possesses more than 15 years of training mastery in Networking, Security, SDN, and many other advanced courses and technologies. With CCNA, CCNP, and many other diverse Cisco specializations, he's achieved CCIE Security (50220). From foundational concepts to complex Cisco networks & and security topics like Identity Service Engine, Web Security, Email Security, Firewalls, VPN, NGIPS, and NGFW, he's a seasoned instructor. He aptly managed global training projects, collaborating with esteemed institutions like the Bank of Tanzania, EMAL - Abu Dhabi, PIC - Kuwait, and many clients based in the US & and UK. His journey empowers organizations and individuals through roles ranging from Training Consultant to Senior Training Consultant, including contributions to content management and trainer evaluation.

StudentsFeedback
Emanuel Paun

United State

Mohammad was an amazing professor. I do not have a strong networking background and Mohammad was very patient in teaching me the basics in topics like wireless. The way he taught (hands on/labs) really helped solidify everything we learned through the 5 days of classes. I have nothing but positive feedback for the way he taught these course and his personality was amazing. 10/10 professor.

Shreyas Deshpande

India

The training helped me connect dots and taught me a lot new concepts as well. The instructor is very knowledgeable in the subject and the demonstrations are very helpful for me to understand issues, and related solutions. I really appreciate and enjoyed the lectures and learning from instructor. Thank you very much!

Yeiner Carrillo

United State

The  BGP class was very interactive and pleasant, I personally liked the instructor's methodology. Thankyou 

James Ferrell

United State

Very cordial and great expertise,Courteous, knowledgeable, detail orientated Mohammed was an awesome instructor. very knowledgeable. 

Jason Pope

United State

The instructor was an outstanding; very personable and presented the material well. I liked the fact that he worked with us on the daily schedule which helped us take care of some crucial tasks here at the end of the year.

Paul Martinez

United State

Mohammed was great, super flexible and took my pervious experience into account. His adaptability made the learning sessions engaging, and his consideration of my background knowledge significantly enhanced the learning process. Overall, a fantastic experience with a teacher who understands how to make learning both effective and enjoyable."

Asadullah Osmani

Afghanistan

Gurfan, is a very Knowledgeable instructor and delivered the material professionally and was welling to explain and help with questions during the session.Great instructor vert knowledgeable and knew the topic very well and he very knowledgeable , i do recommend others to take courses with him.

Pramod Vidwat

India

Has a good knowledge on the subject and more important we had a lot of labs to practice and get the concepts cleared.

Helder

Mozambique

Is a great instructor, explains very well about the classes, very attentive, dynamic and very motivated, I learned a lot from him and I always hope to count on him during my I.T. careers, he is a excellent teacher.

Hirofumi Takemi

Japan

It was an excellent course and I was very lucky to have you as my trainer. Thanks a lot. Hope to see you again somewhere sometime.

Stevenson Kiteculo

Africa

What to say about the coach, I don't know where to start but I tell you, you have a big picture in your company, he helped me even in having motivation that everything is possible when you believe. He is a great teacher and a great person congratulations on you having him.It was a great pleasure to have you as a teacher, in fact he marked my life and I really want to be able to count on your future help, especially the teacher because thanks to him I was able to motivate myself and smile thinking about a great career all this was possible thanks to the efforts , attention and dedication he had to help me thank you very much

Mark Powell

United States

I learned a lot. His method of teaching and the way he made sure I understand everything will prove well for me passing my test.

Emmanuel A Bankole

Angola

I really appreciate this training, it has really impacted great knowledge and you are cool and perfect instructor if I have to be honest.

Copyright © 2024 Nework Binary. All Rights Reserved