Data Analytics Process, Cloud Solutions, and Power BI Solutions Training Course

Introduction

Overview of On-Premise and Cloud-Based Data Storage and Analysis Solutions

Understanding Big Data

  • Big Data criteria
  • Big Data structure
  • Working with Big Data

Cloud Solutions

  • Azure SQL Database
  • Azure Data Warehouse
  • Azure Data Factory
  • Azure Databricks
  • Power BI

Working with Databases

  • Data warehouse design
  • Dimensional modelling
  • Implementation and deployment

Data Models – A Comparison

  • SSAS Tabular Data Models
  • SSAS Multidimension Models
  • Power BI Models

Data Cleansing

  • Strategies and tools

Report Models

  • Building Power BI tabular models
  • Understanding DAX

PowerBI Reports

  • Designing Power BI reports

Power BI Architecture

  • Workspace generation
  • Licensing
  • Permissions

Administration

  • Administering Azure solutions
  • Administering the Power BI Service

Security

  • Maintaining a secure Azure architecture
  • Azure SQL Database/Data Warehouse, Data Factory and Data Bricks
  • Data Masking and Privacy Issues

Power BI Dashboard Design Training Course

  • Introduction
  • Overview of the Power BI Dashboard
  • Examples and Comparisons between Well-Designed Dashboards and Poorly-Organized Dashboards
  • Understanding Basic and Key Features of Power BI
  • Essential Rules to Design A Beautiful Dashboard
  • Choosing the Right Visuals for Your Data

Introduction a Power BI Desktop

C’est quoi Power BI

Power BI les differentes editions et licences

Power BI Desktop

Power BI Query

Import de votre dataset

Nettoyage et préparation de vos données

Creation de vos premiers visuels et rapport

Presentation de Power BI Pro

Les workspace

Creation et partage de votre premier dashboard

Requirements

  • Connaître excel est un peu plus

Description

Salut

Dans cette introduction a Power BI Desktop, je vais de montrer comment installer Power BI Desktop et travailler avec des datas.

Qu’est-ce que Power BI ? Power BI est un ensemble de services logiciels, d’applications et de connecteurs qui œuvrent ensemble pour transformer des sources de données disparates en informations visuelles immersives et interactives.

Contenu de la formation

Power BI Desktop
Module 1 Installation de Power BI Desktop

Module 2 Notre premier exemple : import d’un dataset et création d’un visuel (youra !)

Module 3 Présentation de l’interface Power BI Desktop

Module 4 Présentation de query editor et paramétrage de Power BI Desktop

Query editor

Module 5 Nettoyage et préparation de vos données (dataset)

Module 6 Utilisation des Pivot dans les colonnes

Module 7 Split

Module 9 Créations d’un schéma entre les tables

Module 10 Allez plus loin (Langage DAX, Création de report visuel, Power BI pro)

Power BI Desktop est une application gratuite qui s’installe sur un ordinateur local et permet de se connecter à des données, de les transformer et de les visualiser. Avec Power BI Desktop, vous pouvez vous connecter à plusieurs sources de données différentes et les combiner dans un modèle de données (ce qui s’appelle la modélisation ).

Power BI Desktop est inclus dans les plans Office 365. Les utilisateurs de bureau disposent de 10 Go de stockage total dans le cloud Power BI et peuvent télécharger des données de 1 Go à la fois. Desktop donne un accès à la bibliothèque de modèles de visualisation de Power BI. Power BI Desktop a par ailleurs un désavantage.

Who this course is for:

  • Ingenieurs des datas
  • Analyste de datas
  • Toute personne qui voudrait savoir faire des présentations graphiques et visuels
  • Contrôleurs de gestion
  • Analystes financiers

Course content

Microsoft Power Platform Introductory Course (Fundamentals)

Identify the Core Components of Power Platform, including Dataverse (CDS), Connectors and AI Builder

Microsoft Power Platform Fundamentals

Learn about Power Apps, Power Automate, Power BI, the AI Builder and the Dataverse (CDS) – for Microsoft’s PL-900 exam.

Describe the business value of Microsoft’s Power Platform

Identify the Core Components of Power Platform, including Dataverse (CDS), Connectors and AI Builder

Requirements

  • No prior knowledge of Microsoft’s Power Platform or any of its apps are required
  • You need to know how to use a computer, and hopefully know how to use a spreadsheet.
  • You need Windows 7 SP1 or above, or for other machines an internet browser (Edge or Chrome preferred) to access most of the apps used in this course.
  • Why not have a look at the curriculum below and see what you can learn?

Description

HERE’S WHAT YOU WILL LEARN:

Sign Up For Microsoft Dynamics 365 Free Trial and Practice.

Get familiar with Microsoft Power Platform, Dynamics 365 Important Terms

Become comfortable in navigating through the application.

Do you want to become a Common Data Service (Microsoft Dynamics 365 & Power Apps) Technical Consultant or PowerApps Developer? In fact, most of the Dynamics 365 profiles require you to be a developer. Though dealing with configuration is easy but learning to code in Microsoft Dynamics 365 or PowerApps is quite challenging. This course will address the problem.

  1. Targeted for Beginner to Advanced Levels.
  2. Concentration on hands-on.
  3. You will be able to crack technical interview questions with ease.
  4. Lifetime access.
  5. This is a live course. Topics will be added or removed as per industry demand.

This course covers the content required for the PL-900 certification exam, current as per the PL-900 exam update of 10 March 2021.

30 Day Money Back Guarantee

We are offering a 30-day money-back guarantee, so if you are not happy with the course for any reason whatsoever, you can get your money back, no questions asked.

Learn about Dynamics 365 Developer ConceptsFeatures , Customizations, Reporting and lot more.

Module 1: Get Started with Microsoft Power Platform

  • What is Power Platform?
  • What is Power BI?
  • What is Power Automate?
  • What is PowerApps?
  • What is Power Virtual Agent?
  • What is the Dataverse aka. Common data service?
  • What is the Power Portals?
  • What are Power Platform connector?
  • What is the Microsoft AI Builder?

If you want be a Dynamics 365 Developer or Architect or Technical Consultant, this course is right for you.

If you are a beginner at Dynamics 365 Development, and upgrade yourself to a PRO.

Life time access with ample of hands-on practice with development.

You will be able to crack technical interview questions with ease.

This is a live course. Topics will be added or removed on demand and need basis.

30 Day Money Back Guarantee

We are offering 30 day money back guarantee, so if you are not happy with the course for any reason whatsoever, you can get your money back, no questions asked.

Who this course is for:

  • Dynamics 365 Professionals
  • This course is for you if you want to understand what is available on Microsoft’s Power Platform.
  • By the end of this course, after entering the official Practice Tests, you could enter (and hopefully pass) Microsoft’s official PL-900 exam.
  • Wouldn’t the “Microsoft Certified: Power Platform Fundamentals” certification look good on your CV or resume?

Course content