[vc_section full_width=”stretch_row” css=”.vc_custom_1532085157436{margin-top: 0px !important;margin-bottom: 0px !important;padding-top: 0px !important;padding-bottom: 0px !important;background-color: #ffffff !important;}”][vc_row full_width=”stretch_row” css=”.vc_custom_1765786188100{margin-top: 0px !important;margin-bottom: 0px !important;padding-top: 40px !important;}”][vc_column css=”.vc_custom_1765786174267{margin-top: 10px !important;padding-top: 0px !important;padding-bottom: 0px !important;}”][vc_column_text css=”.vc_custom_1765784972619{margin-top: 0px !important;margin-bottom: 35px !important;}” el_class=”text-block”]
Inventory and Supply Chain Planning Analytics Led to Improved Inventory Management, Supply Chain Planning and Management Reporting
[/vc_column_text][vc_column_text css=”.vc_custom_1765785199993{margin-top: 0px !important;margin-bottom: 35px !important;}” el_class=”text-block”]The client is a biopharmaceutical company involved in the Research and Development of novel products for the treatment of rare and ultra-rare genetic diseases for which there are typically no approved treatments and high unmet medical needs.[/vc_column_text][vc_column_text css=”.vc_custom_1765785089345{margin-top: 0px !important;margin-bottom: 20px !important;}” el_class=”text-block”]
Background
[/vc_column_text][vc_column_text css=”.vc_custom_1765785181330{margin-top: 0px !important;margin-bottom: 35px !important;}” el_class=”text-block”]The client was generating reports related to inventory management and supply chain in Microsoft Excel which was not only time-consuming, inflexible, and visually unappealing but also did not cover all reporting scenarios needed by the client. [/vc_column_text][vc_column_text css=”.vc_custom_1765786267447{margin-top: 0px !important;margin-bottom: 35px !important;}” el_class=”text-block”]
DiLytics’ Solution
[/vc_column_text][vc_column_text css=”.vc_custom_1765785321705{margin-top: 0px !important;margin-bottom: 10px !important;}” el_class=”text-block”]DiLytics implemented a Microsoft Power BI solution consisting of reports, metrics, and visualizations for the client’s supply chain team. DiLytics solution entailed the following:[/vc_column_text][rt_list_style list_style=”seven” list_content=”
- List Item Text One
- List Item Text Two
- List Item Text Three
” list_css=”.vc_custom_1765785634188{margin-bottom: 10px !important;padding-left: 35px !important;}” list_extra_class=”text-block”]
- Document business requirements for analytical reports
- Extract, transform, and load data from different source systems
- Apply filter, split, group by, merge, and conditional column transformations
- Design and develop datasets using star and Snowflake data modeling strategies
- Implement Dimension Hierarchies, Measures, Aggregation Rules, and Time Series functionalities
- Create reports, prompts, and custom visuals on the Power BI desktop to meet business requirements.
- Develop complex calculated measures using (DAX) Data Analysis Xpression language
- Publish Power BI reports and dashboards on Power BI Web covering the following:
[/rt_list_style][vc_column_text css=”.vc_custom_1765785613394{margin-top: 0px !important;margin-bottom: 10px !important;padding-left: 55px !important;}” el_class=”text-block”]- Demand Forecast
– Inventory and Shipments
– Supplier Ratings
– Months on Hand
– Projected Balances
– Shipment Details[/vc_column_text][rt_list_style list_style=”seven” list_content=”
- List Item Text One
- List Item Text Two
- List Item Text Three
” list_css=”.vc_custom_1765785776669{margin-bottom: 35px !important;padding-left: 35px !important;}” list_extra_class=”text-block”]
- Conduct Conference Room pilot
- Perform System and UAT testing
[/rt_list_style][vc_column_text css=”.vc_custom_1765785731705{margin-top: 0px !important;margin-bottom: 35px !important;}” el_class=”text-block”]
Business Benefits
[/vc_column_text][vc_column_text css=”.vc_custom_1765785865854{margin-top: 0px !important;margin-bottom: 10px !important;}” el_class=”text-block”]The client received several benefits such as:[/vc_column_text][rt_list_style list_style=”seven” list_content=”
- List Item Text One
- List Item Text Two
- List Item Text Three
” list_css=”.vc_custom_1765785929857{margin-bottom: 35px !important;padding-left: 35px !important;}” list_extra_class=”text-block”]
- Improved inventory management and supply chain planning
- Improved management reporting – ease in generating more relevant and targeted reporting content having greater visual appeal; enhanced ability to explore, filter and analyze data
[/rt_list_style][vc_column_text css=”” el_class=”text-block”]
Technical Stack
[/vc_column_text][vc_column_text css=”.vc_custom_1765786042844{margin-bottom: 0px !important;}” el_class=”text-block”]Source Systems: Excel, MS Access DB
Reporting Tool: Microsoft Power BI[/vc_column_text][/vc_column][/vc_row][/vc_section][vc_row full_width=”stretch_row” equal_height=”yes” content_placement=”middle” css=”.vc_custom_1684237429473{margin-top: 0px !important;margin-bottom: 0px !important;padding-top: 35px !important;padding-bottom: 35px !important;background-color: #ffffff !important;background-position: center !important;background-repeat: no-repeat !important;background-size: cover !important;}”][vc_column width=”1/3″ css=”.vc_custom_1531997568277{margin-top: 0px !important;margin-bottom: 10px !important;padding-top: 0px !important;padding-bottom: 0px !important;}”][/vc_column][vc_column width=”1/3″][vc_column_text css=”” el_class=”text-block”]
DiLytics Delivers
[/vc_column_text][/vc_column][vc_column width=”1/3″][vc_custom_heading text=”View all Success Stories →” font_container=”tag:h6|font_size:16px|text_align:right|color:%23dd3333|line_height:26px” use_theme_fonts=”yes” css=”.vc_custom_1660717315754{margin-top: 0px !important;margin-bottom: 10px !important;}” el_class=”font-weight-medium” link=”url:https%3A%2F%2Fdilytics.com%2Fsuccess-stories%2F|title:Success%20Stories”][/vc_column][vc_column css=”.vc_custom_1661424713241{margin-bottom: 25px !important;}”][rt_case_study_style case_study_style_variation=”seven” case_study_display_filter=”no” case_study_enable_title=”yes” case_study_enable_excerpt=”yes” case_study_spacing=”30″ case_study_looping_sort=”ASC” no_of_case_studies=”3″][/vc_column][/vc_row]