S T U D Y T E C H
Drag

Training

  • Home
  • Data Analytics - Power BI PL300
Image
Image Image Image

Course Overview

Learn the most demanding Microsoft BI Tool used in almost all the industries for Dashboard and Self - Service Reports. This Power BI training course will help you learn Power BI architecture, Power BI Desktop, Power BI DAX Commands and Functions, Power BI Q&A, Visualizations, Reports, Deriving business insights, and Dashboards. This Power BI course is applicable for people who want to understand how to use the Power BI tools and create customized visual reports. It is also suitable for BI and reporting professionals, data analysts, and professionals working with data in any sector.

Who is this for?

  • Anyone who has a basic to intermediate understanding of Power BI and is looking to take the reporting to the next level
  • Anyone who wants to design and develop professional reports
  • This course is not for you if your focus is on Power BI Service. This course is intended to improve your development and analytical skills
  • Anyone who wants to enhance their skill set as a data analyst or BI consultant

Skills Covered

  • Data Integration
  • Data Transformation
  • Data Modelling
  • Data Exploration
  • Data Visualization
  • Storytelling

Things you will learn

  • Learn about Data Visualization, Data Analysis, Data Modelling, Data Management, Integration with ML, Data Forecasting, Business Verticals Know-how, Industry Use cases
  • Demonstrate proficiency with analysis of data
  • Develop the ability to build interactive dashboards and reports
  • Analyse data and extract business insights

Course Benefits

Microsoft Power BI: A Complete Hands-on Training Complete End-to-end Power Bi Report Development Using Real-world Business Case Implement Your Bi Skills in Your Professional or Personal Projects Power BI's Complete ETL Process - Data Analysis, Data Integration, Transformation, Modelling and Visualization Understand and Explore Your Data Using AI-based Power BI Visuals Learn and Implement Dax Calculations Analyze Your Data for Effective Storytelling Using Unique Power BI Features Like - Drill Through, Custom Tooltips, Bookmarks

Prerequisites

  1. Understanding core data concepts.
  2. Knowledge of working with relational data in the cloud.
  3. Knowledge of working with non-relational data in the cloud.
  4. Knowledge of data analysis and visualization concepts.
  5. You can gain the prerequisites and a better understanding of working with data in Azure by completing DP-900 before taking this course.

Learning Objectives of PL-300 Microsoft Power BI Data Analyst Training

  • Participants taking part in this PL 300 certification training will learn about:
  • Ingesting, cleaning, and transforming data
  • Modeling data for performance and scalability
  • Designing and creating reports for data analysis
  • Applying and performing advanced report analytics
  • Managing and sharing report assets
  • Creating paginated reports in Power BI

Data Analytics - Power BI Training Course Curriculum

1: Introduction to Power BI
  • Why Power BI?
  • Why Industries use Power BI?
  • How Industries use Power BI?
  • Installation of Power BI Desktop
  • Architecture, Components, and Flow
  • Date, Time and Complex Data Types
2: Power Query - Load and Transform Data
  • Connecting to a data Sources
  • Import, Direct Query, Live, and Composite mode
  • Optimizing Data Models
  • Modeling Data
  • Manage Data Relationship
  • The Power Query
  • Introduction to Query Editor
  • Data transformation –column formatting, transpose table, splitting, formatting data, Merge Join, relational operators, date, time calculations, and all the remaining functions available in Power Query.
  • Query Editor in Power BI
  • Combining Data – Merging and Appending
  • Cleaning irregularly formatted data
3: Data Analysis Expressions (DAX) Queries
  • DAX Syntax
  • Data Types in DAX
  • DAX Functions
  • DAX in Measures
  • DAX in Calculated Fields
  • How to use the CALCULATE() function
  • Date and time DAX functions
  • DAX Operators
  • DAX tables and filtering
  • DAX queries
  • DAX Parameters
4: Data Analytics and Data Visualizations
  • Visuals in Power BI
  • Matrixes and tables
  • Slicers
  • Map Visualizations
  • Card Visuals
  • Modifying colors in charts and visuals
  • Shapes, text boxes, and images
  • KPI Visuals
  • Visualization interaction
  • Drill down Visuals
  • Hierarchies in Visualizations
  • Power Q & A Visual - How to import? How to use it? When to use? Working
5: Advance Filtration Techniques
  • Filter on Specific Visuals
  • Filter on the full report
  • Filter on all the reports
  • Filters showing Top and Botton values on the visuals
  • Customize filtrations
  • Date and time filters
  • Row-level security (RLS), static and dynamic
  • Manage Roles
6: Dashboards, Reports and Publish Online
  • Reports in Power BI
  • Customized reports with KPI, visuals, slicers, filters, cards.
  • Buttons and Logos on Reports
  • Reports Publish online
  • Introduction to app.powerbi.com - How to use? When to use? Working?
  • Pin visuals and reports for making Dashboard
  • Customized dashboards
  • Convert then into presentation, pdf, and on the web.

© Study tech International Owned by Appsron