Supply Chain Analytics Using Power Bi – The Ultimate Guide

Unleash Supply Chain efficiency with Power BI analytics: Transforming Data into powerful insights!

What you'll learn

Learn how to connect Power BI to various data sources

Master the techniques for cleaning and transforming raw data into usable formats for analysis

Develop skills in creating robust data models, including understanding different table types and modeling techniques

Learn practical supply chain metrics and how to visualize them effectively; like: working capital, Day on hand, coverage, inventory turnover and ISR

Learn how to create impactful visualizations that effectively communicate data insights

Requirements

Microsoft Excel Knowledge: A foundational understanding of Excel functions and formulas, as this will help in grasping data manipulation concepts

No Prior BI Experience Needed: This course is designed for beginners, so no prior knowledge of Business Intelligence or Power BI is required

to explore data analytics and supply chain concepts

Description

This course is designed for professionals seeking to transform raw data into actionable insights that drive business decisions. With a focus on supply chain management, you will learn how to leverage Power BI’s robust features to analyze, visualize, and present data effectively.This course comes in four parts1. Introduction to BI: The journey commences with an exploration of Business Intelligence and its relevance in today's data-driven world.2. Why Power BI: The 7 Reasons to Choose Power BI: Understand the advantages of using Power BI for your analytics needs.3. Applications of Power BI:Installing Power BI Desktop: Step-by-step guide to getting started.Introduction to Power BI Desktop: Overview of features and functionalities.Building a Power BI Report: Hands-on steps with examples and simulations to create your first report.Connecting and Transforming Data: Learn how to import and prepare your data for analysis.Creating a Data Model: Build a robust data model to support your reports.Types of Tables in Power BI: Understand different table types and their applications.Types of Data Models: Explore various data modeling techniques.Calculating and Manipulating Data (DAX): Dive into DAX for powerful data manipulation.Visualizing Data: Create effective visualizations tailored to your audience.Power BI Service: Learn how to publish and share your reports online.Power BI Mobile: Optimize your reports for mobile access.4. Case Studies: Apply your skills to real-world supply chain scenarios, the course integrates theoretical learning with practical application, reinforcing your learning through real-world supply chain use cases.This is what you will learn:Transform Raw Data into Actionable Insights with Ease: Master the art of converting complex data sets into meaningful insights that can influence supply chain strategies.Drag-and-Drop Interface: Get hands-on experience with Power BI’s intuitive interface that allows you to create stunning visualizations without the need for extensive coding.Creating Visualizations and Dashboards: Learn how to build impactful dashboards and visual representations of your data to communicate findings clearly and effectively.Building Interactive Reports: Discover how to create dynamic reports that engage your audience and allow for in-depth exploration of supply chain metrics.Join us in this exciting course and take the first step toward becoming a supply chain analytics expert. Empower your career with the skills to analyze data effectively using Power BI, and make informed decisions that drive success!

Overview

Section 1: Introduction

Lecture 1 Introduction

Lecture 2 Results by the end of this course

Section 2: Table of content

Lecture 3 Table on content

Section 3: Introduction to business intelligence

Lecture 4 Introduction to BI

Section 4: Introduction to Power BI

Lecture 5 Why Power BI and 7 reasons why to choose PBI

Lecture 6 Power BI application

Lecture 7 Install Power BI

Lecture 8 Changing language

Lecture 9 Build BI report

Section 5: Connect & transform data

Lecture 10 Connect & transform data

Lecture 11 Connect to Excel Workbook

Lecture 12 Transform data

Lecture 13 Add columns : Custom columns, conditional columns

Lecture 14 Profiling tools : columns quality, columns distribution, columns profil

Lecture 15 Connect to folder as data source with multiple extractions

Section 6: Data model

Lecture 16 Data model

Lecture 17 Types of table in Power BI

Lecture 18 Different Data models

Lecture 19 Filter flow

Lecture 20 Filter flow exercise

Lecture 21 Creating data model

Lecture 22 Merge Queries

Lecture 23 Append Queries

Section 7: Calculating and manipulating data - DAX

Lecture 24 Calculating and manipulating data - DAX

Lecture 25 DAX functions by category

Lecture 26 Math and stats functions

Lecture 27 Logical functions

Lecture 28 Text functions

Lecture 29 Filter functions

Lecture 30 Date and time functions

Lecture 31 Calculating and manipulating data - WC report

Section 8: Visualizing data

Lecture 32 Visualizing data

Lecture 33 Visualizing data - WC report

Lecture 34 Layout and conditional formatting - WC report

Section 9: Power BI Service

Lecture 35 Power BI Service

Lecture 36 Publish a report in Workspace

Lecture 37 Connect to Sharepoint - Onedrive

Lecture 38 Automatic refresh

Lecture 39 Connect to Snowflake - SQL server using SQL statements

Section 10: Power BI Mobile view

Lecture 40 Power BI mobile

Lecture 41 Create mobile view

Lecture 42 Mobile view

Supply Chain Professionals: Individuals working in supply chain management who want to leverage data analytics to improve operations and decision-making,Data Analysts and Aspiring Analysts: Those looking to enhance their skills in data analysis, visualization, and reporting using Power BI, particularly in the context of supply chain,Students and Recent Graduates: Individuals pursuing careers in business, supply chain, or analytics who want to build a strong foundation in data visualization and reporting,Anyone Interested in Data Visualization: Individuals who want to learn how to create impactful visualizations and dashboards to communicate insights effectively