Course DA-100T00-A Analyzing Data with Power BI

Does this course include tasks performed by data analysts? DA-100T00 course looks at various methods & best practices that are in–line with business procedures and technical [...]

Live session course for Course DA-100T00-A Analyzing Data with Power BI
Live Course
Run date: January 04, 2021
Course Duration: 5 Days

What you will learn

  • Describe the Power BI landscape of products and services
  • Model data for performance and scalability
  • Enhance structure, shape transformations and profile data
  • Identify and retrieve data from different data sources
  • Design and create reports for data analysis
  • Apply and perform advanced report analytics
  • Manage and share report assets
  • Create paginated reports in Power BI
  • Configure, manage & troubleshoot Gateway connectivity
  • Understand and Implement Power BI security

Requirements

  • In addition to their professional experience, students who take this training should have technical knowledge equivalent to the information found in the Azure Fundamentals course.

Warning: Use of undefined constant get_the_content - assumed 'get_the_content' (this will throw an Error in a future version of PHP) in /home/instrui0/public_html/wp-content/themes/flatsome-child/woocommerce/single-product/layouts/product.php on line 101

Description

Does this course include tasks performed by data analysts? DA-100T00 course looks at various methods & best practices that are in-line with business procedures and technical requirements for modeling, visualizing, and data analysis with Power BI. The course instructs how to access and process data from multiple data sources including both relational and non-relational data. This course also explores how to implement proper security standards and policies across the Power BI spectrum including datasets and groups. The course also discusses how to manage & deploy reports along with dashboards for sharing and content distribution. Finally, this course shows how to build paginated reports within the Power BI service and publish them to a workspace for inclusion within Power BI.  Note: DA-100is the replacement course for 20778which is scheduled for retirement on Jan 31, 2021.

Course Content
32 Lectures
13 Quizzes
13 Hands on Labs

Warning: A non-numeric value encountered in /home/instrui0/public_html/wp-content/themes/flatsome-child/woocommerce/single-product/layouts/product.php on line 158

Warning: A non-numeric value encountered in /home/instrui0/public_html/wp-content/themes/flatsome-child/woocommerce/single-product/layouts/product.php on line 158

Warning: A non-numeric value encountered in /home/instrui0/public_html/wp-content/themes/flatsome-child/woocommerce/single-product/layouts/product.php on line 158

Warning: A non-numeric value encountered in /home/instrui0/public_html/wp-content/themes/flatsome-child/woocommerce/single-product/layouts/product.php on line 158

Warning: A non-numeric value encountered in /home/instrui0/public_html/wp-content/themes/flatsome-child/woocommerce/single-product/layouts/product.php on line 158

Warning: A non-numeric value encountered in /home/instrui0/public_html/wp-content/themes/flatsome-child/woocommerce/single-product/layouts/product.php on line 158

Warning: A non-numeric value encountered in /home/instrui0/public_html/wp-content/themes/flatsome-child/woocommerce/single-product/layouts/product.php on line 158

Warning: A non-numeric value encountered in /home/instrui0/public_html/wp-content/themes/flatsome-child/woocommerce/single-product/layouts/product.php on line 158

Warning: A non-numeric value encountered in /home/instrui0/public_html/wp-content/themes/flatsome-child/woocommerce/single-product/layouts/product.php on line 158

Warning: A non-numeric value encountered in /home/instrui0/public_html/wp-content/themes/flatsome-child/woocommerce/single-product/layouts/product.php on line 158

Warning: A non-numeric value encountered in /home/instrui0/public_html/wp-content/themes/flatsome-child/woocommerce/single-product/layouts/product.php on line 158

Warning: A non-numeric value encountered in /home/instrui0/public_html/wp-content/themes/flatsome-child/woocommerce/single-product/layouts/product.php on line 158
  • Module 1: Get Started with Microsoft Data Analytics
    This module explores the different roles in the data space, outlines the important roles and responsibilities of a Data Analysts, and then explores the landscape of the Power BI portfolio.
    Lessons Duration
    Data Analytics and Microsoft
    Getting started with Power BI
    Labs Duration
    Getting started with Power BI environment
  • Module 2: Prepare Data in Power BI
    This module explores identifying and retrieving data from various data sources. You will also learn the options for connectivity, data storage and understand the difference and performance implications of connecting directly to data vs. importing it.
    Lessons Duration
    Get data from various data sources
    Optimize performance
    Resolve data errors
    Labs Duration
    Lab: Transforming and Loading Data
  • Module 3: Clean, Transform, and Load Data in Power BI
    This module teaches you the process of profiling and understanding the condition of the data. They will learn how to identify anomalies, look at the size and shape of their data, and perform the proper data cleaning and transforming steps to prepare the data for loading into the model.
    Lessons Duration
    Data shaping
    Enhance the data structure
    Data Profiling
    Labs Duration
    Lab: Transforming and Loading Data
  • Module 4: Design a Data Model in Power BI
    This module teaches the fundamental concepts of designing and developing a data model for proper performance and scalability. This module will also help you understand and tackle many of the common data modeling issues, including relationships, security, and performance.
    Lessons Duration
    Introduction to data modeling
    Working with tables
    Dimensions and Hierarchies
    Labs Duration
    Lab: Data Modeling in Power BI Desktop
    Lab: Advanced Data Modeling in Power BI Desktop
  • Module 5: Create Measures using DAX in Power BI
    This module introduces you to the world of DAX and its true power for enhancing a model. You will learn about aggregations and the concepts of Measures, calculated columns and tables, and Time Intelligence functions to solve calculation and data analysis problems.
    Lessons Duration
    Introduction to DAX
    DAX context
    Advanced DAX
    Labs Duration
    Lab: Introduction to DAX in Power BI Desktop
    Lab: Advanced DAX in Power BI Desktop
  • Module 6: Optimize Model Performance
    In this module you are introduced to steps, processes, concepts, and data modeling best practices necessary to optimize a data model for enterprise-level performance.
    Lessons Duration
    Optimize the model for performance
    Optimize DirectQuery Models
    Create and manage Aggregations
  • Module 7: Create Reports
    This module introduces you to the fundamental concepts and principles of designing and building a report, including selecting the correct visuals, designing a page layout, and applying basic but critical functionality. The important topic of designing for accessibility is also covered.
    Lessons Duration
    Design a report
    Enhance the report
    Labs Duration
    Lab: Designing a report in Power BI
    Lab: Enhancing Power BI reports with interaction and formatting
  • Module 8: Create Dashboards
    In this module you will learn how to tell a compelling story through the use of dashboards and the different navigation tools available to provide navigation. You will be introduced to features and functionality and how to enhance dashboards for usability and insights.
    Lessons Duration
    Create a Dashboard
    Real-time Dashboards
    Enhance a Dashboard
    Labs Duration
    Lab: Designing a report in Power BI Desktop - Part 1
  • Module 9: Create Paginated Reports in Power BI
    This module will teach you about paginated reports, including what they are how they fit into Power BI. You will then learn how to build and publish a report.
    Lessons Duration
    Paginated report overview
    Create Paginated reports
    Labs Duration
    Lab: Creating a Paginated report
  • Module 10: Perform Advanced Analytics
    This module helps you apply additional features to enhance the report for analytical insights in the data, equipping you with the steps to use the report for actual data analysis. You will also perform advanced analytics using AI visuals on the report for even deeper and meaningful data insights.
    Lessons Duration
    Advanced Analytics
    Data Insights through AI visuals
    Labs Duration
    Lab: Data Analysis in Power BI Desktop
  • Module 11: Create and Manage Workspaces
    This module will introduce you to Workspaces, including how to create and manage them. You will also learn how to share content, including reports and dashboards, and then learn how to distribute an App.
    Lessons Duration
    Creating Workspaces
    Sharing and Managing Assets
    Labs Duration
    Lab: Publishing and Sharing Power BI Content
  • Module 12: Manage Datasets in Power BI
    In this module you will learn the concepts of managing Power BI assets, including datasets and workspaces. You will also publish datasets to the Power BI service, then refresh and secure them.
    Lessons Duration
    Parameters
    Datasets
  • Module 13: Row-level security
    This module teaches you the steps for implementing and configuring security in Power BI to secure Power BI assets.
    Lessons Duration
    Security in Power BI

About the Instructor


Brandon Ahmad, MCSE

Microsoft Certified Trainer Regional Lead - USA

8.8 out of 9.0 Average Instructor Rating

Top Instructor Award Twice

MCSE Certification in Dynamics 365

Freelances as hands-on Technical Lead with very advanced development scenarios for Day Job

Brandon Teaches D365 for Finance and Operations Programming

Brandon Ahmad is a pre-eminent hands-on Microsoft Dynamics Lead Technical Architect and a passionate instructor. He believes that the best way to teach programming is by example with many custom real-world scenarios. He also believes that anyone can become good at development as long as they have the right teaching, work ethic, and curriculum.

To date he has personally consulted over 60 implementations across the globe while often solving and implementing many very advanced development scenarios.

His biggest secret to teaching is to simply care about the people who take his courses. His best reward is to hear of someone who saved a lot of time and mastered Dynamics while knowing that his course played a part in that success.

Frequently Asked Questions

  • How many hours should I spent each week on the course?
    We suggest you spending from 60 to 80 hours a week to complete this course on time.
  • Is this course intended for a Microsoft exam?
    Yes, it is. This is required knowledge for their DA-100 exam: Analyzing Data with Microsoft Power BI.
  • Does this course include Lab Practice hours?
    Yes, certainly. Every course we provide includes hands-on lab practices, with real world-based scenarios.
  • Do I need any previous knowledge?
    Yes, for sure. You should have some experience on relational and non-relational data in the cloud. Also, data analysis and visualization concepts.
  • What skills will I gain with this course?
    This course aims to teach you how to ingest, clean, and transform data. Also, model data for performance and scalability, as well as design and create reports for data analysis.
  • Does this course include tasks performed by data analysts?
    Yes, it does, starting right in the first module.
  • Will I learn about Preparing Data in Power BI?
    Yes, definitely. Including how to identify and retrieve data from different data sources, understanding the connection methods and their performance implications, optimizing query performance, and resolving data import errors.
  • Does this course include Data Transformation lessons?
    Yes, for sure. There is a module about how to clean, transform, and load data in Power BI.
  • Do you teach how to Design a Data Model in this course?
    Yes, sure thing. This course includes the basics of data modeling, defining relationships and their cardinality, implementing dimensions and hierarchies, and creating histograms and rankings.
  • Is there a module about Creating Measures using DAX in Power BI?
    Yes, definitely. There, it is included understanding DAX, using DAX for simple formulas and expressions, creating calculated tables and measures, building simple measures, working with Time Intelligence and Key Performance Indicators.
  • Do you teach how to create a Report in this course?
    Yes, for sure. Everything about designing a report page layout, selecting and adding effective visualization, adding basic report functionality, adding report navigation and interactions, improving report performance, and designing for accessibility.
  • Is Row-Level Security included in this course?
    Yes, sure thing. With this you could understand the aspects of Power BI security, and configure row-level security roles and group membership.

Course DA-100T00-A Analyzing Data with Power BI

$2,500.00

    Prominent Features
  • Interactive video lessons & quizzes
  • Mobile app
  • Dedicated support (16 hours a day)
  • Course completion certification
  • Licenses