Project 2 - Create a report using PowerQuery, Macro VBA, List Functions and Data Validation functions for Data Reporting of Supply Chain Management companies

https://drive.google.com/file/d/1Me8VHmB55N5I_d4P2ebyhYkZf6lLjN5F/view

Sub PDF_Conversion()
Dim r As Range
Dim s As String

If Selection.Count = 1 Then
Set r = Application.InputBox("Select a range", "Get Range", Type:=8)
Else
Set r = Selection
End If

strfile = "Selection" & "_" _
& Format(Now(), "yyyymmdd_hhmmss") _
& ".pdf"
strfile = ThisWorkbook.Path & "" & strfile

myfile = Application.GetSaveAsFilename _
(InitialFileName:=strfile, _
FileFilter:="PDF Files (*.pdf), *.pdf", _
Title:="Select Folder and File Name to Save as PDF")
If myfile <> "False" Then
r.ExportAsFixedFormat Type:=xlTypePDF, Filename:= _
myfile, Quality:=xlQualityStandard, IncludeDocProperties:=True, _
IgnorePrintAreas:=False, OpenAfterPublish:=True
Else
MsgBox "No File Selected. PDF will not be saved", vbOKOnly, "No File Selected"
End If
End Sub

Data Reporting for Supply Chain Management Companies Using Power Query, VBA Macros, List Functions, and Data Validation" is a project that focuses on creating a comprehensive report for supply chain management companies. The project utilizes various Excel features, including Power Query, VBA Macros, list functions, and data validation, to extract, transform, analyze, and present supply chain data effectively.

1. Data Extraction: The project involves extracting relevant data from multiple sources, such as ERP systems, databases, and spreadsheets. Power Query is utilized to connect to these data sources, import the data into Excel, and consolidate it into a structured format suitable for analysis.

2. Data Transformation and Cleansing: The extracted data is transformed and cleansed using Power Query. This includes removing unnecessary columns, handling missing or inconsistent data, standardizing data formats, and applying data quality checks. Transformations may involve merging data from different sources, splitting columns, aggregating data, and performing calculations.

3. Data Analysis: The transformed data is analyzed to derive meaningful insights and key performance indicators (KPIs) related to supply chain management. List functions and Excel formulas are utilized to perform calculations, such as inventory turnover, order fulfillment rate, lead time analysis, and supplier performance metrics. These analyses help monitor and evaluate the efficiency and effectiveness of the supply chain processes.

4. By undertaking this project, supply chain management companies can benefit from a robust reporting system that provides valuable insights into their operations. The use of Power Query, VBA Macros, list functions, and data validation ensures efficient data processing, accurate analysis, and user-friendly interactivity. The report facilitates informed decision-making, performance tracking, and continuous improvement in supply chain management processes.