{"id":235,"date":"2025-04-01T14:51:10","date_gmt":"2025-04-01T12:51:10","guid":{"rendered":"https:\/\/konstancjaopryszek.pl\/?page_id=235"},"modified":"2025-04-03T12:40:59","modified_gmt":"2025-04-03T10:40:59","slug":"portfolio-2","status":"publish","type":"page","link":"https:\/\/konstancjaopryszek.pl\/index.php\/portfolio-2\/","title":{"rendered":"Portfolio &#8211; Konstancja Opryszek"},"content":{"rendered":"\t\t<div data-elementor-type=\"wp-page\" data-elementor-id=\"235\" class=\"elementor elementor-235\" data-elementor-settings=\"[]\">\n\t\t\t\t\t\t\t<div class=\"elementor-section-wrap\">\n\t\t\t\t\t\t\t<section class=\"elementor-section elementor-top-section elementor-element elementor-element-0edb2cf elementor-section-full_width elementor-section-stretched elementor-section-height-default elementor-section-height-default\" data-id=\"0edb2cf\" data-element_type=\"section\" data-settings=\"{&quot;stretch_section&quot;:&quot;section-stretched&quot;,&quot;background_background&quot;:&quot;classic&quot;}\">\n\t\t\t\t\t\t<div class=\"elementor-container elementor-column-gap-no\">\n\t\t\t\t\t<div class=\"elementor-column elementor-col-100 elementor-top-column elementor-element elementor-element-42a5847\" data-id=\"42a5847\" data-element_type=\"column\">\n\t\t\t<div class=\"elementor-widget-wrap elementor-element-populated\">\n\t\t\t\t\t\t\t\t<div class=\"elementor-element elementor-element-b181a1f elementor-position-left elementor-vertical-align-middle elementor-widget elementor-widget-image-box\" data-id=\"b181a1f\" data-element_type=\"widget\" data-widget_type=\"image-box.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t<div class=\"elementor-image-box-wrapper\"><figure class=\"elementor-image-box-img\"><img width=\"768\" height=\"607\" src=\"https:\/\/konstancjaopryszek.pl\/wp-content\/uploads\/2025\/04\/DSC04915-Edytuj-scaled-e1743510261659-768x607.jpg\" class=\"attachment-medium_large size-medium_large\" alt=\"\" loading=\"lazy\" \/><\/figure><div class=\"elementor-image-box-content\"><h2 class=\"elementor-image-box-title\">Konstancja Opryszek<\/h2><p class=\"elementor-image-box-description\">Improvements | Data Analyst | Automation Specialist | Process optimization | Power BI | Python | Low-Codes<br>\n<\/p><\/div><\/div>\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t<section class=\"elementor-section elementor-top-section elementor-element elementor-element-2324a88 elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"2324a88\" data-element_type=\"section\">\n\t\t\t\t\t\t<div class=\"elementor-container elementor-column-gap-default\">\n\t\t\t\t\t<div class=\"elementor-column elementor-col-100 elementor-top-column elementor-element elementor-element-68b9b24\" data-id=\"68b9b24\" data-element_type=\"column\">\n\t\t\t<div class=\"elementor-widget-wrap elementor-element-populated\">\n\t\t\t\t\t\t\t\t<div class=\"elementor-element elementor-element-e0dd79e elementor-widget elementor-widget-spacer\" data-id=\"e0dd79e\" data-element_type=\"widget\" data-widget_type=\"spacer.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t<div class=\"elementor-spacer\">\n\t\t\t<div class=\"elementor-spacer-inner\"><\/div>\n\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-7eb7d86 elementor-widget elementor-widget-heading\" data-id=\"7eb7d86\" data-element_type=\"widget\" data-widget_type=\"heading.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t<h2 class=\"elementor-heading-title elementor-size-default\">Featured Projects<\/h2>\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<section class=\"elementor-section elementor-inner-section elementor-element elementor-element-208a0b3 elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"208a0b3\" data-element_type=\"section\">\n\t\t\t\t\t\t<div class=\"elementor-container elementor-column-gap-default\">\n\t\t\t\t\t<div class=\"elementor-column elementor-col-100 elementor-inner-column elementor-element elementor-element-bd53fa6\" data-id=\"bd53fa6\" data-element_type=\"column\" data-settings=\"{&quot;background_background&quot;:&quot;classic&quot;}\">\n\t\t\t<div class=\"elementor-widget-wrap elementor-element-populated\">\n\t\t\t\t\t\t\t\t<div class=\"elementor-element elementor-element-86cd5c5 elementor-widget elementor-widget-heading\" data-id=\"86cd5c5\" data-element_type=\"widget\" data-widget_type=\"heading.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t<h2 class=\"elementor-heading-title elementor-size-default\">\ud83d\uded2 Automating Product Creation \u2013 Bridging User Input with Two Systems<\/h2>\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-9142d60 elementor-widget elementor-widget-text-editor\" data-id=\"9142d60\" data-element_type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t<p>Python (selenium, gspread, googleapiclient, python-dotenv, requests)<\/p>\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-1bc9041 elementor-widget elementor-widget-text-editor\" data-id=\"1bc9041\" data-element_type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t<p>One of the most technically rewarding automations I developed was a solution for automatically creating new products in two different platforms \u2014 <strong data-start=\"542\" data-end=\"584\">SalesCRM by Imker (without API access)<\/strong> and <strong data-start=\"589\" data-end=\"614\">WooCommerce (via API)<\/strong> \u2014 based on a single user input.<\/p>\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-14a0a59 elementor-widget elementor-widget-toggle\" data-id=\"14a0a59\" data-element_type=\"widget\" data-widget_type=\"toggle.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t<div class=\"elementor-toggle\" role=\"tablist\">\n\t\t\t\t\t\t\t<div class=\"elementor-toggle-item\">\n\t\t\t\t\t<div id=\"elementor-tab-title-2161\" class=\"elementor-tab-title\" data-tab=\"1\" role=\"tab\" aria-controls=\"elementor-tab-content-2161\" aria-expanded=\"false\">\n\t\t\t\t\t\t\t\t\t\t\t\t<span class=\"elementor-toggle-icon elementor-toggle-icon-left\" aria-hidden=\"true\">\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<span class=\"elementor-toggle-icon-closed\"><i class=\"fas fa-caret-right\"><\/i><\/span>\n\t\t\t\t\t\t\t\t<span class=\"elementor-toggle-icon-opened\"><i class=\"elementor-toggle-icon-opened fas fa-caret-up\"><\/i><\/span>\n\t\t\t\t\t\t\t\t\t\t\t\t\t<\/span>\n\t\t\t\t\t\t\t\t\t\t\t\t<a href=\"\" class=\"elementor-toggle-title\">Click here to see more details<\/a>\n\t\t\t\t\t<\/div>\n\n\t\t\t\t\t<div id=\"elementor-tab-content-2161\" class=\"elementor-tab-content elementor-clearfix\" data-tab=\"1\" role=\"tabpanel\" aria-labelledby=\"elementor-tab-title-2161\"><p class=\"\" data-start=\"648\" data-end=\"1031\">\ud83d\udca1 <strong data-start=\"651\" data-end=\"665\">Challenge:<\/strong><br data-start=\"665\" data-end=\"668\" \/>The company\u2019s workflow for adding new products was fragmented and manual. Product data was collected via a <strong data-start=\"775\" data-end=\"790\">Google Form<\/strong>, then manually copied and entered into <strong data-start=\"830\" data-end=\"851\">SalesCRM by Imker<\/strong> and <strong data-start=\"856\" data-end=\"871\">WooCommerce<\/strong> \u2014 two separate systems with very different interfaces. The biggest challenge: SalesCRM didn\u2019t provide any API access, making automation particularly difficult.<\/p><p class=\"\" data-start=\"1033\" data-end=\"1155\">\u2699\ufe0f <strong data-start=\"1036\" data-end=\"1049\">Solution:<\/strong><br data-start=\"1049\" data-end=\"1052\" \/>I created a <strong data-start=\"1064\" data-end=\"1091\">Python-based automation<\/strong> that handled the entire process from input to product creation:<\/p><p><img loading=\"lazy\" class=\"aligncenter wp-image-294 size-full\" src=\"https:\/\/konstancjaopryszek.pl\/wp-content\/uploads\/2025\/04\/python-1.png\" alt=\"\" width=\"399\" height=\"274\" srcset=\"https:\/\/konstancjaopryszek.pl\/wp-content\/uploads\/2025\/04\/python-1.png 399w, https:\/\/konstancjaopryszek.pl\/wp-content\/uploads\/2025\/04\/python-1-300x206.png 300w\" sizes=\"(max-width: 399px) 100vw, 399px\" \/><\/p><p><em>Necessary sensitive data as e.g. passwords were stored in .env and credentials.json which were files ignored by GitHub to ensure data safety.<\/em><\/p><p><img loading=\"lazy\" class=\"aligncenter wp-image-295 size-full\" src=\"https:\/\/konstancjaopryszek.pl\/wp-content\/uploads\/2025\/04\/python-2.png\" alt=\"\" width=\"540\" height=\"307\" srcset=\"https:\/\/konstancjaopryszek.pl\/wp-content\/uploads\/2025\/04\/python-2.png 540w, https:\/\/konstancjaopryszek.pl\/wp-content\/uploads\/2025\/04\/python-2-300x171.png 300w\" sizes=\"(max-width: 540px) 100vw, 540px\" \/><\/p><p>\u00a0<\/p><ul><li data-start=\"1158\" data-end=\"1257\"><strong data-start=\"1158\" data-end=\"1185\">Google Form submissions<\/strong> were stored in a connected Google Sheet, acting as the source of truth.<\/li><\/ul><p><img loading=\"lazy\" class=\"aligncenter wp-image-297 size-full\" src=\"https:\/\/konstancjaopryszek.pl\/wp-content\/uploads\/2025\/04\/python-4.png\" alt=\"\" width=\"797\" height=\"198\" srcset=\"https:\/\/konstancjaopryszek.pl\/wp-content\/uploads\/2025\/04\/python-4.png 797w, https:\/\/konstancjaopryszek.pl\/wp-content\/uploads\/2025\/04\/python-4-300x75.png 300w, https:\/\/konstancjaopryszek.pl\/wp-content\/uploads\/2025\/04\/python-4-768x191.png 768w\" sizes=\"(max-width: 797px) 100vw, 797px\" \/><\/p><ul><li data-start=\"1158\" data-end=\"1257\"><strong>A Python script<\/strong> used <strong data-start=\"1281\" data-end=\"1293\">Selenium<\/strong> to log into the <strong data-start=\"1310\" data-end=\"1322\">SalesCRM<\/strong> system and simulate all necessary user actions to create the product automatically.<\/li><\/ul><p><img loading=\"lazy\" class=\"aligncenter wp-image-296 size-full\" src=\"https:\/\/konstancjaopryszek.pl\/wp-content\/uploads\/2025\/04\/python-3.png\" alt=\"\" width=\"931\" height=\"411\" srcset=\"https:\/\/konstancjaopryszek.pl\/wp-content\/uploads\/2025\/04\/python-3.png 931w, https:\/\/konstancjaopryszek.pl\/wp-content\/uploads\/2025\/04\/python-3-300x132.png 300w, https:\/\/konstancjaopryszek.pl\/wp-content\/uploads\/2025\/04\/python-3-768x339.png 768w\" sizes=\"(max-width: 931px) 100vw, 931px\" \/><\/p><ul><li data-start=\"1158\" data-end=\"1257\">Simultaneously, the script used <strong data-start=\"1441\" data-end=\"1462\">WooCommerce\u2019s API<\/strong> to create a product with the same information, including pricing, categories, and metadata.<\/li><\/ul><p><img loading=\"lazy\" class=\"aligncenter wp-image-298 size-full\" src=\"https:\/\/konstancjaopryszek.pl\/wp-content\/uploads\/2025\/04\/python-5.png\" alt=\"\" width=\"871\" height=\"814\" srcset=\"https:\/\/konstancjaopryszek.pl\/wp-content\/uploads\/2025\/04\/python-5.png 871w, https:\/\/konstancjaopryszek.pl\/wp-content\/uploads\/2025\/04\/python-5-300x280.png 300w, https:\/\/konstancjaopryszek.pl\/wp-content\/uploads\/2025\/04\/python-5-768x718.png 768w\" sizes=\"(max-width: 871px) 100vw, 871px\" \/><\/p><ul><li data-start=\"1158\" data-end=\"1257\">The process was scheduled and logged to ensure reliability and error tracing.<\/li><\/ul><p class=\"\" data-start=\"1636\" data-end=\"1916\">\ud83d\ude80 <strong data-start=\"1639\" data-end=\"1650\">Impact:<\/strong><br data-start=\"1650\" data-end=\"1653\" \/>\u2705 Fully eliminated manual product entry into both systems (so even a non-technical worker could easily create a product in the systems).<br data-start=\"1711\" data-end=\"1714\" \/>\u2705 Ensured data consistency across platforms.<br data-start=\"1758\" data-end=\"1761\" \/>\u2705 Saved significant time per product added \u2014 especially important during new product launches.<br data-start=\"1855\" data-end=\"1858\" \/>\u2705 Enabled scaling without increasing operational workload.<\/p><p class=\"\" data-start=\"1918\" data-end=\"2231\">This project highlighted how automation can overcome even the absence of an API and showed the power of combining <strong data-start=\"2032\" data-end=\"2065\">browser automation (Selenium)<\/strong> with <strong data-start=\"2071\" data-end=\"2091\">API integrations<\/strong> to streamline end-to-end processes. It was a perfect example of how to turn a tedious, error-prone task into a seamless, scalable workflow.<\/p><\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t<div class=\"elementor-element elementor-element-59be555 elementor-widget elementor-widget-spacer\" data-id=\"59be555\" data-element_type=\"widget\" data-widget_type=\"spacer.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t<div class=\"elementor-spacer\">\n\t\t\t<div class=\"elementor-spacer-inner\"><\/div>\n\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<section class=\"elementor-section elementor-inner-section elementor-element elementor-element-4b100b8 elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"4b100b8\" data-element_type=\"section\">\n\t\t\t\t\t\t<div class=\"elementor-container elementor-column-gap-default\">\n\t\t\t\t\t<div class=\"elementor-column elementor-col-100 elementor-inner-column elementor-element elementor-element-2f9ed64\" data-id=\"2f9ed64\" data-element_type=\"column\" data-settings=\"{&quot;background_background&quot;:&quot;classic&quot;}\">\n\t\t\t<div class=\"elementor-widget-wrap elementor-element-populated\">\n\t\t\t\t\t\t\t\t<div class=\"elementor-element elementor-element-c11f4d4 elementor-widget elementor-widget-heading\" data-id=\"c11f4d4\" data-element_type=\"widget\" data-widget_type=\"heading.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t<h2 class=\"elementor-heading-title elementor-size-default\">\ud83d\udd04 Automated Monthly Reporting<\/h2>\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-b04e58b elementor-widget elementor-widget-text-editor\" data-id=\"b04e58b\" data-element_type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t<p>Python (selenium), Power BI (with RLS), Power Automate<\/p>\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-07972ce elementor-widget elementor-widget-text-editor\" data-id=\"07972ce\" data-element_type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t<p>Designed and implemented an automated system for generating PDFs and emailing 52 reports monthly, <strong>saving over<\/strong>\u00a0<strong>192 hours<\/strong> of manual work per month. The process included data scraping, automated report filtering, PDF generation, and distribution via email.<\/p>\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-a2cfd02 elementor-widget elementor-widget-toggle\" data-id=\"a2cfd02\" data-element_type=\"widget\" data-widget_type=\"toggle.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t<div class=\"elementor-toggle\" role=\"tablist\">\n\t\t\t\t\t\t\t<div class=\"elementor-toggle-item\">\n\t\t\t\t\t<div id=\"elementor-tab-title-1701\" class=\"elementor-tab-title\" data-tab=\"1\" role=\"tab\" aria-controls=\"elementor-tab-content-1701\" aria-expanded=\"false\">\n\t\t\t\t\t\t\t\t\t\t\t\t<span class=\"elementor-toggle-icon elementor-toggle-icon-left\" aria-hidden=\"true\">\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<span class=\"elementor-toggle-icon-closed\"><i class=\"fas fa-caret-right\"><\/i><\/span>\n\t\t\t\t\t\t\t\t<span class=\"elementor-toggle-icon-opened\"><i class=\"elementor-toggle-icon-opened fas fa-caret-up\"><\/i><\/span>\n\t\t\t\t\t\t\t\t\t\t\t\t\t<\/span>\n\t\t\t\t\t\t\t\t\t\t\t\t<a href=\"\" class=\"elementor-toggle-title\">Click here to see more details<\/a>\n\t\t\t\t\t<\/div>\n\n\t\t\t\t\t<div id=\"elementor-tab-content-1701\" class=\"elementor-tab-content elementor-clearfix\" data-tab=\"1\" role=\"tabpanel\" aria-labelledby=\"elementor-tab-title-1701\"><p class=\"\" data-start=\"69\" data-end=\"477\">One of the automations I am really proud of was the <strong data-start=\"127\" data-end=\"200\">full automation of a monthly data entry performance reporting process<\/strong> at SGS. This process was previously a <strong data-start=\"239\" data-end=\"339\">time-consuming, manual task that involved eight employees working for three full days each month<\/strong>. The team had to manually update PowerPoint reports, generate <strong data-start=\"402\" data-end=\"413\">52 PDFs<\/strong>, and send <strong data-start=\"424\" data-end=\"448\">52 individual emails<\/strong> to the correct recipients.<\/p><p class=\"\" data-start=\"479\" data-end=\"713\"><strong data-start=\"479\" data-end=\"496\">\ud83d\udca1 Challenge:<\/strong><br data-start=\"496\" data-end=\"499\" \/>The existing process was highly inefficient, requiring significant manual effort, which not only consumed valuable working hours but also introduced the risk of human errors in report generation and distribution.<\/p><p class=\"\" data-start=\"715\" data-end=\"881\"><strong data-start=\"715\" data-end=\"731\">\u2699\ufe0f Solution:<\/strong><br data-start=\"731\" data-end=\"734\" \/>I designed and implemented a <strong data-start=\"763\" data-end=\"791\">fully automated solution<\/strong> by integrating <strong data-start=\"807\" data-end=\"878\">Python, Power BI, Power Automate Desktop, and Power Automate Online<\/strong>:<\/p><p data-start=\"715\" data-end=\"881\"><em>Note: Due to access limitations, no code snippets are available for this project.<\/em><\/p><ul><li data-start=\"884\" data-end=\"991\"><strong data-start=\"884\" data-end=\"901\">Python script<\/strong> performed <strong data-start=\"912\" data-end=\"929\">data scraping<\/strong> from an internal site and saved the data to <strong data-start=\"974\" data-end=\"988\">SharePoint (as flat files)<\/strong>.<\/li><li data-start=\"884\" data-end=\"991\">Developed\u00a0<strong>Power BI report<\/strong><strong> with RLS<\/strong> (row-level security) to ensure that the data can be filtered to specific countries \/ regions for specific people.<\/li><li data-start=\"884\" data-end=\"991\"><strong data-start=\"994\" data-end=\"1017\">Power Automate flow<\/strong> refreshed the data in <strong data-start=\"1040\" data-end=\"1052\">Power BI<\/strong>, ensuring real-time accuracy.<\/li><li data-start=\"884\" data-end=\"991\"><strong data-start=\"1087\" data-end=\"1118\">Another Power Automate flow<\/strong> used a <strong data-start=\"1126\" data-end=\"1148\">configuration file<\/strong> to filter reports for each country (52 total), automatically generated <strong data-start=\"1220\" data-end=\"1228\">PDFs<\/strong>, and stored them in <strong data-start=\"1249\" data-end=\"1263\">SharePoint<\/strong>.<\/li><li data-start=\"884\" data-end=\"991\"><strong data-start=\"1269\" data-end=\"1298\">The final automation step<\/strong> sent <strong data-start=\"1304\" data-end=\"1327\">personalized emails<\/strong> with the correct PDF attachment to the appropriate recipients based on the configuration file.<\/li><\/ul><p class=\"\" data-start=\"1426\" data-end=\"1784\"><strong data-start=\"1426\" data-end=\"1440\">\ud83d\ude80 Impact:<\/strong><br data-start=\"1440\" data-end=\"1443\" \/>\u2705 <strong data-start=\"1445\" data-end=\"1482\">Saved 192 working hours per month<\/strong>, allowing the team to focus on higher-value tasks.<br data-start=\"1533\" data-end=\"1536\" \/>\u2705 <strong data-start=\"1538\" data-end=\"1577\">Completely eliminated manual effort<\/strong>, reducing errors and ensuring consistency.<br data-start=\"1620\" data-end=\"1623\" \/>\u2705 <strong data-start=\"1625\" data-end=\"1659\">Streamlined reporting workflow<\/strong>, improving turnaround time and data accuracy.<br data-start=\"1705\" data-end=\"1708\" data-is-only-node=\"\" \/>\u2705 <strong data-start=\"1710\" data-end=\"1745\">Scalable and adaptable solution<\/strong>, reducing dependency on manual work.<\/p><p class=\"\" data-start=\"1786\" data-end=\"2111\">This automation <strong data-start=\"1802\" data-end=\"1876\">significantly improved operational efficiency and resource utilization<\/strong> while showcasing the power of <strong data-start=\"1907\" data-end=\"1958\">automation and digital transformation<\/strong>. Seeing the impact of this project reinforced my passion for <strong data-start=\"2020\" data-end=\"2108\">process improvement, automation, and leveraging technology to drive business success<\/strong>.<\/p><\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t<div class=\"elementor-element elementor-element-4ec5ede elementor-widget elementor-widget-spacer\" data-id=\"4ec5ede\" data-element_type=\"widget\" data-widget_type=\"spacer.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t<div class=\"elementor-spacer\">\n\t\t\t<div class=\"elementor-spacer-inner\"><\/div>\n\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<section class=\"elementor-section elementor-inner-section elementor-element elementor-element-2935065 elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"2935065\" data-element_type=\"section\">\n\t\t\t\t\t\t<div class=\"elementor-container elementor-column-gap-default\">\n\t\t\t\t\t<div class=\"elementor-column elementor-col-100 elementor-inner-column elementor-element elementor-element-5471611\" data-id=\"5471611\" data-element_type=\"column\" data-settings=\"{&quot;background_background&quot;:&quot;classic&quot;}\">\n\t\t\t<div class=\"elementor-widget-wrap elementor-element-populated\">\n\t\t\t\t\t\t\t\t<div class=\"elementor-element elementor-element-7f2fdc0 elementor-widget elementor-widget-heading\" data-id=\"7f2fdc0\" data-element_type=\"widget\" data-widget_type=\"heading.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t<h2 class=\"elementor-heading-title elementor-size-default\">\ud83d\udcca Financial Monitoring Dashboard<\/h2>\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-0f7cba4 elementor-widget elementor-widget-text-editor\" data-id=\"0f7cba4\" data-element_type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t<p>Power BI, Fakturownia (importing data via API)<\/p>\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-b6d4478 elementor-widget elementor-widget-text-editor\" data-id=\"b6d4478\" data-element_type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t<p>Created a Power BI report to monitor revenue and costs using data pulled via API from Fakturownia. Automated updates allow for near real-time tracking of financial performance, <strong>enabling faster decision-making and better budget control<\/strong>.<\/p>\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-c5d0724 elementor-widget elementor-widget-toggle\" data-id=\"c5d0724\" data-element_type=\"widget\" data-widget_type=\"toggle.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t<div class=\"elementor-toggle\" role=\"tablist\">\n\t\t\t\t\t\t\t<div class=\"elementor-toggle-item\">\n\t\t\t\t\t<div id=\"elementor-tab-title-2071\" class=\"elementor-tab-title\" data-tab=\"1\" role=\"tab\" aria-controls=\"elementor-tab-content-2071\" aria-expanded=\"false\">\n\t\t\t\t\t\t\t\t\t\t\t\t<span class=\"elementor-toggle-icon elementor-toggle-icon-left\" aria-hidden=\"true\">\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<span class=\"elementor-toggle-icon-closed\"><i class=\"fas fa-caret-right\"><\/i><\/span>\n\t\t\t\t\t\t\t\t<span class=\"elementor-toggle-icon-opened\"><i class=\"elementor-toggle-icon-opened fas fa-caret-up\"><\/i><\/span>\n\t\t\t\t\t\t\t\t\t\t\t\t\t<\/span>\n\t\t\t\t\t\t\t\t\t\t\t\t<a href=\"\" class=\"elementor-toggle-title\">Click here to see more details<\/a>\n\t\t\t\t\t<\/div>\n\n\t\t\t\t\t<div id=\"elementor-tab-content-2071\" class=\"elementor-tab-content elementor-clearfix\" data-tab=\"1\" role=\"tabpanel\" aria-labelledby=\"elementor-tab-title-2071\"><p class=\"\" data-start=\"241\" data-end=\"507\">I created a Power BI dashboard for tracking revenue and costs in real-time, directly connected to the company\u2019s invoicing system (<strong data-start=\"371\" data-end=\"386\">Fakturownia<\/strong>) via API. The goal was to replace time-consuming manual exports with an automated, always-up-to-date reporting solution.<\/p><p class=\"\" data-start=\"509\" data-end=\"793\">\ud83d\udca1 <strong data-start=\"512\" data-end=\"526\">Challenge:<\/strong><br data-start=\"526\" data-end=\"529\" \/>The business needed a reliable way to monitor its financial performance. Fakturownia\u2019s API, however, limited requests to a single page of results, making full data extraction complex. The existing process relied on manual checks and delayed decision-making.<\/p><p class=\"\" data-start=\"795\" data-end=\"883\">\u2699\ufe0f <strong data-start=\"798\" data-end=\"811\">Solution:<\/strong><br data-start=\"811\" data-end=\"814\" \/>I built a custom data pipeline within <strong data-start=\"852\" data-end=\"882\">Power BI using Power Query<\/strong>:<\/p><ul><li data-start=\"886\" data-end=\"983\">Designed a loop function to paginate through up to <strong data-start=\"937\" data-end=\"954\">100 API pages<\/strong>, pulling the entire dataset.<\/li><\/ul><p><img loading=\"lazy\" class=\"aligncenter wp-image-270 size-full\" src=\"https:\/\/konstancjaopryszek.pl\/wp-content\/uploads\/2025\/04\/PQ-function.png\" alt=\"\" width=\"1005\" height=\"355\" srcset=\"https:\/\/konstancjaopryszek.pl\/wp-content\/uploads\/2025\/04\/PQ-function.png 1005w, https:\/\/konstancjaopryszek.pl\/wp-content\/uploads\/2025\/04\/PQ-function-300x106.png 300w, https:\/\/konstancjaopryszek.pl\/wp-content\/uploads\/2025\/04\/PQ-function-768x271.png 768w\" sizes=\"(max-width: 1005px) 100vw, 1005px\" \/> <img loading=\"lazy\" class=\"aligncenter wp-image-269 size-full\" src=\"https:\/\/konstancjaopryszek.pl\/wp-content\/uploads\/2025\/04\/PQ-loop.png\" alt=\"\" width=\"996\" height=\"206\" srcset=\"https:\/\/konstancjaopryszek.pl\/wp-content\/uploads\/2025\/04\/PQ-loop.png 996w, https:\/\/konstancjaopryszek.pl\/wp-content\/uploads\/2025\/04\/PQ-loop-300x62.png 300w, https:\/\/konstancjaopryszek.pl\/wp-content\/uploads\/2025\/04\/PQ-loop-768x159.png 768w\" sizes=\"(max-width: 996px) 100vw, 996px\" \/><\/p><ul><li data-start=\"886\" data-end=\"983\">Transformed and structured the data directly in Power Query.<\/li><li data-start=\"886\" data-end=\"983\">Built a dynamic dashboard showing <strong data-start=\"1083\" data-end=\"1111\">key financial indicators<\/strong>, cost breakdowns, and revenue trends.<\/li><\/ul><p><em>Examples of some DAX measures:<\/em><\/p><p><img loading=\"lazy\" class=\"aligncenter wp-image-305 size-full\" src=\"https:\/\/konstancjaopryszek.pl\/wp-content\/uploads\/2025\/04\/measure-1.png\" alt=\"\" width=\"819\" height=\"114\" srcset=\"https:\/\/konstancjaopryszek.pl\/wp-content\/uploads\/2025\/04\/measure-1.png 819w, https:\/\/konstancjaopryszek.pl\/wp-content\/uploads\/2025\/04\/measure-1-300x42.png 300w, https:\/\/konstancjaopryszek.pl\/wp-content\/uploads\/2025\/04\/measure-1-768x107.png 768w\" sizes=\"(max-width: 819px) 100vw, 819px\" \/><\/p><p><img loading=\"lazy\" class=\"aligncenter wp-image-306 size-full\" src=\"https:\/\/konstancjaopryszek.pl\/wp-content\/uploads\/2025\/04\/measure-2.png\" alt=\"\" width=\"493\" height=\"258\" srcset=\"https:\/\/konstancjaopryszek.pl\/wp-content\/uploads\/2025\/04\/measure-2.png 493w, https:\/\/konstancjaopryszek.pl\/wp-content\/uploads\/2025\/04\/measure-2-300x157.png 300w\" sizes=\"(max-width: 493px) 100vw, 493px\" \/><\/p><p class=\"\" data-start=\"1151\" data-end=\"1437\">\ud83d\ude80 <strong data-start=\"1154\" data-end=\"1165\">Impact:<\/strong><br data-start=\"1165\" data-end=\"1168\" \/>\u2705 Eliminated manual data exports and improved report accuracy.<br data-start=\"1230\" data-end=\"1233\" \/>\u2705 Provided real-time visibility into business performance.<br data-start=\"1296\" data-end=\"1299\" \/>\u2705 Empowered decision-makers with clear, interactive dashboards.<br data-start=\"1362\" data-end=\"1365\" \/>\u2705 Created a scalable and reusable data model for future reporting needs.<\/p><p class=\"\" data-start=\"1439\" data-end=\"1643\">This project demonstrated how API limitations can be solved creatively using <strong data-start=\"1516\" data-end=\"1560\">Power BI\u2019s advanced Power Query features<\/strong>.<\/p><\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t<div class=\"elementor-element elementor-element-581cfe4 elementor-widget elementor-widget-spacer\" data-id=\"581cfe4\" data-element_type=\"widget\" data-widget_type=\"spacer.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t<div class=\"elementor-spacer\">\n\t\t\t<div class=\"elementor-spacer-inner\"><\/div>\n\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<section class=\"elementor-section elementor-inner-section elementor-element elementor-element-448d4dd elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"448d4dd\" data-element_type=\"section\">\n\t\t\t\t\t\t<div class=\"elementor-container elementor-column-gap-default\">\n\t\t\t\t\t<div class=\"elementor-column elementor-col-100 elementor-inner-column elementor-element elementor-element-6bf330a\" data-id=\"6bf330a\" data-element_type=\"column\" data-settings=\"{&quot;background_background&quot;:&quot;classic&quot;}\">\n\t\t\t<div class=\"elementor-widget-wrap elementor-element-populated\">\n\t\t\t\t\t\t\t\t<div class=\"elementor-element elementor-element-aa1bcd0 elementor-widget elementor-widget-heading\" data-id=\"aa1bcd0\" data-element_type=\"widget\" data-widget_type=\"heading.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t<h2 class=\"elementor-heading-title elementor-size-default\">\ud83d\udd14 Stripe to Google Sheets Automation<\/h2>\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-8727e28 elementor-widget elementor-widget-text-editor\" data-id=\"8727e28\" data-element_type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t<p>Zapier, Stripe, Google Sheets<\/p>\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-9e20136 elementor-widget elementor-widget-text-editor\" data-id=\"9e20136\" data-element_type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t<p>Used Zapier to automate the tracking of Stripe transactions. New and failed payments are automatically logged into Google Sheets, <strong>providing up-to-date visibility into payment activity and reducing the need for manual reconciliation.<\/strong><\/p>\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-4582057 elementor-widget elementor-widget-toggle\" data-id=\"4582057\" data-element_type=\"widget\" data-widget_type=\"toggle.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t<div class=\"elementor-toggle\" role=\"tablist\">\n\t\t\t\t\t\t\t<div class=\"elementor-toggle-item\">\n\t\t\t\t\t<div id=\"elementor-tab-title-7281\" class=\"elementor-tab-title\" data-tab=\"1\" role=\"tab\" aria-controls=\"elementor-tab-content-7281\" aria-expanded=\"false\">\n\t\t\t\t\t\t\t\t\t\t\t\t<span class=\"elementor-toggle-icon elementor-toggle-icon-left\" aria-hidden=\"true\">\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<span class=\"elementor-toggle-icon-closed\"><i class=\"fas fa-caret-right\"><\/i><\/span>\n\t\t\t\t\t\t\t\t<span class=\"elementor-toggle-icon-opened\"><i class=\"elementor-toggle-icon-opened fas fa-caret-up\"><\/i><\/span>\n\t\t\t\t\t\t\t\t\t\t\t\t\t<\/span>\n\t\t\t\t\t\t\t\t\t\t\t\t<a href=\"\" class=\"elementor-toggle-title\">Click here to see more details<\/a>\n\t\t\t\t\t<\/div>\n\n\t\t\t\t\t<div id=\"elementor-tab-content-7281\" class=\"elementor-tab-content elementor-clearfix\" data-tab=\"1\" role=\"tabpanel\" aria-labelledby=\"elementor-tab-title-7281\"><p class=\"\" data-start=\"2952\" data-end=\"3158\">Keeping track of incoming and failed payments is essential, especially for smaller teams without dedicated finance staff. I created an automation that made it effortless to stay on top of every transaction.<\/p><p class=\"\" data-start=\"3160\" data-end=\"3369\">\ud83d\udca1 <strong data-start=\"3163\" data-end=\"3177\">Challenge:<\/strong><br data-start=\"3177\" data-end=\"3180\" \/>The client used Stripe for payments but lacked a clear, accessible view of which payments were successful, pending, or failed. Manually checking Stripe was inefficient and easy to overlook.<\/p><p class=\"\" data-start=\"3371\" data-end=\"3447\">\u2699\ufe0f <strong data-start=\"3374\" data-end=\"3387\">Solution:<\/strong><br data-start=\"3387\" data-end=\"3390\" \/>I implemented a <strong data-start=\"3406\" data-end=\"3427\">Zapier automation<\/strong> to streamline this:<\/p><p data-start=\"3371\" data-end=\"3447\"><em>Note: Due to access limitations, no snippets are available for this project.<\/em><\/p><ul><li data-start=\"3450\" data-end=\"3503\">New or failed transactions in Stripe triggered a Zap.<\/li><li data-start=\"3450\" data-end=\"3503\">Transaction details (customer, amount, status, date) were added to a live <strong data-start=\"3580\" data-end=\"3596\">Google Sheet<\/strong>.<\/li><li data-start=\"3450\" data-end=\"3503\">Filters and color coding made it easy to distinguish between transaction types.<\/li><\/ul><p class=\"\" data-start=\"3681\" data-end=\"3946\">\ud83d\ude80 <strong data-start=\"3684\" data-end=\"3695\">Impact:<\/strong><br data-start=\"3695\" data-end=\"3698\" \/>\u2705 Provided a single, always-updated view of all transactions.<br data-start=\"3759\" data-end=\"3762\" \/>\u2705 Reduced reliance on logging into Stripe manually.<br data-start=\"3813\" data-end=\"3816\" \/>\u2705 Enabled team members without Stripe access to stay informed.<br data-start=\"3878\" data-end=\"3881\" \/>\u2705 Supported better customer follow-up and reduced missed revenue.<\/p><p class=\"\" data-start=\"3948\" data-end=\"4061\">This automation brought clarity, speed, and visibility to financial operations \u2013 with minimal effort and no code.<\/p><\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t<div class=\"elementor-element elementor-element-fec0ae4 elementor-widget elementor-widget-spacer\" data-id=\"fec0ae4\" data-element_type=\"widget\" data-widget_type=\"spacer.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t<div class=\"elementor-spacer\">\n\t\t\t<div class=\"elementor-spacer-inner\"><\/div>\n\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<section class=\"elementor-section elementor-inner-section elementor-element elementor-element-4574673 elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"4574673\" data-element_type=\"section\">\n\t\t\t\t\t\t<div class=\"elementor-container elementor-column-gap-default\">\n\t\t\t\t\t<div class=\"elementor-column elementor-col-100 elementor-inner-column elementor-element elementor-element-dab2341\" data-id=\"dab2341\" data-element_type=\"column\" data-settings=\"{&quot;background_background&quot;:&quot;classic&quot;}\">\n\t\t\t<div class=\"elementor-widget-wrap elementor-element-populated\">\n\t\t\t\t\t\t\t\t<div class=\"elementor-element elementor-element-00fdb93 elementor-widget elementor-widget-heading\" data-id=\"00fdb93\" data-element_type=\"widget\" data-widget_type=\"heading.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t<h2 class=\"elementor-heading-title elementor-size-default\">\ud83d\udce7 Newsletter Automation with Follow-up Logic<\/h2>\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-c46e2a3 elementor-widget elementor-widget-text-editor\" data-id=\"c46e2a3\" data-element_type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t<p>MailerLite<\/p>\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-7bcd457 elementor-widget elementor-widget-text-editor\" data-id=\"7bcd457\" data-element_type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t<p>Built a newsletter signup automation where a subscriber receives a free PDF gift upon sign-up. If the PDF isn\u2019t opened within 48 hours, it\u2019s resent; if it is opened, a feedback request is triggered after 48 hours. <strong>This flow increased engagement and helped gather useful insights from subscribers<\/strong>.<\/p>\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-ce6d72c elementor-widget elementor-widget-toggle\" data-id=\"ce6d72c\" data-element_type=\"widget\" data-widget_type=\"toggle.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t<div class=\"elementor-toggle\" role=\"tablist\">\n\t\t\t\t\t\t\t<div class=\"elementor-toggle-item\">\n\t\t\t\t\t<div id=\"elementor-tab-title-2161\" class=\"elementor-tab-title\" data-tab=\"1\" role=\"tab\" aria-controls=\"elementor-tab-content-2161\" aria-expanded=\"false\">\n\t\t\t\t\t\t\t\t\t\t\t\t<span class=\"elementor-toggle-icon elementor-toggle-icon-left\" aria-hidden=\"true\">\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<span class=\"elementor-toggle-icon-closed\"><i class=\"fas fa-caret-right\"><\/i><\/span>\n\t\t\t\t\t\t\t\t<span class=\"elementor-toggle-icon-opened\"><i class=\"elementor-toggle-icon-opened fas fa-caret-up\"><\/i><\/span>\n\t\t\t\t\t\t\t\t\t\t\t\t\t<\/span>\n\t\t\t\t\t\t\t\t\t\t\t\t<a href=\"\" class=\"elementor-toggle-title\">Click here to see more details<\/a>\n\t\t\t\t\t<\/div>\n\n\t\t\t\t\t<div id=\"elementor-tab-content-2161\" class=\"elementor-tab-content elementor-clearfix\" data-tab=\"1\" role=\"tabpanel\" aria-labelledby=\"elementor-tab-title-2161\"><p class=\"\" data-start=\"295\" data-end=\"496\">I designed a behavioral email automation flow that not only delivered a lead magnet, but also adapted based on user engagement \u2013 creating a more intelligent and personalized experience for subscribers.<\/p><p class=\"\" data-start=\"498\" data-end=\"755\">\ud83d\udca1 <strong data-start=\"501\" data-end=\"515\">Challenge:<\/strong><br data-start=\"515\" data-end=\"518\" \/>The goal was to deliver a PDF gift upon newsletter signup, but also ensure that the recipient actually accessed the file. We wanted to follow up accordingly: remind users who hadn\u2019t downloaded it, and ask for feedback from those who had.<\/p><p class=\"\" data-start=\"757\" data-end=\"883\">\u2699\ufe0f <strong data-start=\"760\" data-end=\"773\">Solution:<\/strong><br data-start=\"773\" data-end=\"776\" \/>Using <strong data-start=\"782\" data-end=\"816\">Mailerlite\u2019s automation system<\/strong>, I built a conditional workflow that tracked <strong data-start=\"862\" data-end=\"880\">click activity<\/strong>:<\/p><ul><li data-start=\"886\" data-end=\"968\">After signing up, subscribers received an email with a link to download the PDF.<\/li><li data-start=\"886\" data-end=\"968\">If they <strong data-start=\"979\" data-end=\"996\">did not click<\/strong> the download link within 48 hours, they received a <strong data-start=\"1048\" data-end=\"1066\">reminder email<\/strong> with the link again.<\/li><li data-start=\"886\" data-end=\"968\">If they <strong data-start=\"1100\" data-end=\"1126\">clicked and downloaded<\/strong> the file, they received a <strong data-start=\"1153\" data-end=\"1173\">feedback request<\/strong> after 48 hours.<\/li><\/ul><p>\u00a0<em>Note: Due to access limitations, an exemplary flow is shown below<\/em><\/p><p><img loading=\"lazy\" class=\"aligncenter wp-image-276 size-full\" src=\"https:\/\/konstancjaopryszek.pl\/wp-content\/uploads\/2025\/04\/ml-p1.png\" alt=\"\" width=\"379\" height=\"645\" srcset=\"https:\/\/konstancjaopryszek.pl\/wp-content\/uploads\/2025\/04\/ml-p1.png 379w, https:\/\/konstancjaopryszek.pl\/wp-content\/uploads\/2025\/04\/ml-p1-176x300.png 176w\" sizes=\"(max-width: 379px) 100vw, 379px\" \/><img loading=\"lazy\" class=\"aligncenter wp-image-275 size-full\" src=\"https:\/\/konstancjaopryszek.pl\/wp-content\/uploads\/2025\/04\/ml-p2.png\" alt=\"\" width=\"760\" height=\"573\" srcset=\"https:\/\/konstancjaopryszek.pl\/wp-content\/uploads\/2025\/04\/ml-p2.png 760w, https:\/\/konstancjaopryszek.pl\/wp-content\/uploads\/2025\/04\/ml-p2-300x226.png 300w\" sizes=\"(max-width: 760px) 100vw, 760px\" \/><\/p><p class=\"\" data-start=\"1193\" data-end=\"1454\">\ud83d\ude80 <strong data-start=\"1196\" data-end=\"1207\">Impact:<\/strong><br data-start=\"1207\" data-end=\"1210\" \/>\u2705 Improved engagement and content delivery accuracy.<br data-start=\"1262\" data-end=\"1265\" \/>\u2705 Increased download rates through smart reminders.<br data-start=\"1316\" data-end=\"1319\" \/>\u2705 Collected valuable user feedback, informing future content strategy.<br data-start=\"1389\" data-end=\"1392\" \/>\u2705 Fully automated \u2013 no manual checking or segmentation needed.<\/p><p class=\"\" data-start=\"1456\" data-end=\"1672\">This project highlighted how a simple piece of logic \u2013 tracking clicks \u2013 can turn a basic email flow into an adaptive, user-centric experience. It showed how marketing automation can be both effective and thoughtful.<\/p><\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t<div class=\"elementor-element elementor-element-ff56448 elementor-widget elementor-widget-spacer\" data-id=\"ff56448\" data-element_type=\"widget\" data-widget_type=\"spacer.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t<div class=\"elementor-spacer\">\n\t\t\t<div class=\"elementor-spacer-inner\"><\/div>\n\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<section class=\"elementor-section elementor-inner-section elementor-element elementor-element-f57cc3b elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"f57cc3b\" data-element_type=\"section\">\n\t\t\t\t\t\t<div class=\"elementor-container elementor-column-gap-default\">\n\t\t\t\t\t<div class=\"elementor-column elementor-col-100 elementor-inner-column elementor-element elementor-element-5ab4724\" data-id=\"5ab4724\" data-element_type=\"column\" data-settings=\"{&quot;background_background&quot;:&quot;classic&quot;}\">\n\t\t\t<div class=\"elementor-widget-wrap elementor-element-populated\">\n\t\t\t\t\t\t\t\t<div class=\"elementor-element elementor-element-b523483 elementor-widget elementor-widget-heading\" data-id=\"b523483\" data-element_type=\"widget\" data-widget_type=\"heading.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t<h2 class=\"elementor-heading-title elementor-size-default\">\ud83e\udd16 Personalized Product Suggestion via Chat<\/h2>\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-9335487 elementor-widget elementor-widget-text-editor\" data-id=\"9335487\" data-element_type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t<p>Manychat<\/p>\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-4ab6532 elementor-widget elementor-widget-text-editor\" data-id=\"4ab6532\" data-element_type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t<p>Designed a chat automation where users answer a few quick questions, and based on their responses, receive a direct link to the most relevant product. This <strong>improved conversion rates and customer satisfaction<\/strong> by offering highly targeted recommendations.<\/p>\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-747d4a4 elementor-widget elementor-widget-toggle\" data-id=\"747d4a4\" data-element_type=\"widget\" data-widget_type=\"toggle.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t<div class=\"elementor-toggle\" role=\"tablist\">\n\t\t\t\t\t\t\t<div class=\"elementor-toggle-item\">\n\t\t\t\t\t<div id=\"elementor-tab-title-1221\" class=\"elementor-tab-title\" data-tab=\"1\" role=\"tab\" aria-controls=\"elementor-tab-content-1221\" aria-expanded=\"false\">\n\t\t\t\t\t\t\t\t\t\t\t\t<span class=\"elementor-toggle-icon elementor-toggle-icon-left\" aria-hidden=\"true\">\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<span class=\"elementor-toggle-icon-closed\"><i class=\"fas fa-caret-right\"><\/i><\/span>\n\t\t\t\t\t\t\t\t<span class=\"elementor-toggle-icon-opened\"><i class=\"elementor-toggle-icon-opened fas fa-caret-up\"><\/i><\/span>\n\t\t\t\t\t\t\t\t\t\t\t\t\t<\/span>\n\t\t\t\t\t\t\t\t\t\t\t\t<a href=\"\" class=\"elementor-toggle-title\">Click here to see more details<\/a>\n\t\t\t\t\t<\/div>\n\n\t\t\t\t\t<div id=\"elementor-tab-content-1221\" class=\"elementor-tab-content elementor-clearfix\" data-tab=\"1\" role=\"tabpanel\" aria-labelledby=\"elementor-tab-title-1221\"><p class=\"\" data-start=\"4150\" data-end=\"4321\">Helping users find the right product through conversation can feel personal \u2013 and automated. I built a flow that turned a basic Q&amp;A into a mini recommender engine.<\/p><p class=\"\" data-start=\"4323\" data-end=\"4505\">\ud83d\udca1 <strong data-start=\"4326\" data-end=\"4340\">Challenge:<\/strong><br data-start=\"4340\" data-end=\"4343\" \/>Users visiting a product page often weren\u2019t sure which item was right for them. The goal was to guide them to the best option based on simple, friendly questions.<\/p><p class=\"\" data-start=\"4507\" data-end=\"4576\">\u2699\ufe0f <strong data-start=\"4510\" data-end=\"4523\">Solution:<\/strong><br data-start=\"4523\" data-end=\"4526\" \/>In <strong data-start=\"4529\" data-end=\"4541\">Manychat<\/strong>, I created an interactive chatbot:<\/p><p data-start=\"4507\" data-end=\"4576\"><em>Note: Due to access limitations, no snippets are available for this project.<\/em><\/p><ul><li data-start=\"4579\" data-end=\"4647\">Users answered 2\u20133 short questions (e.g., goal, experience level).<\/li><li data-start=\"4579\" data-end=\"4647\">Based on answers, the flow sent them a tailored link to 3 most relevant products.<\/li><li data-start=\"4579\" data-end=\"4647\">The flow could be updated easily as new products were added.<\/li><\/ul><p class=\"\" data-start=\"4799\" data-end=\"5067\">\ud83d\ude80 <strong data-start=\"4802\" data-end=\"4813\">Impact:<\/strong><br data-start=\"4813\" data-end=\"4816\" \/>\u2705 Increased conversions by directing users to exactly what they needed.<br data-start=\"4887\" data-end=\"4890\" \/>\u2705 Enhanced user experience with a helpful, conversational tool.<br data-start=\"4953\" data-end=\"4956\" \/>\u2705 Reduced decision fatigue for customers.<br data-start=\"4997\" data-end=\"5000\" \/>\u2705 Provided insight into user preferences through response tracking.<\/p><p class=\"\" data-start=\"5069\" data-end=\"5184\">This project demonstrated how conversational automation can enhance customer experience while directly supporting sales goals through personalized recommendations.<\/p><\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t<section class=\"elementor-section elementor-top-section elementor-element elementor-element-03a3650 elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"03a3650\" data-element_type=\"section\">\n\t\t\t\t\t\t<div class=\"elementor-container elementor-column-gap-default\">\n\t\t\t\t\t<div class=\"elementor-column elementor-col-100 elementor-top-column elementor-element elementor-element-586463b\" data-id=\"586463b\" data-element_type=\"column\">\n\t\t\t<div class=\"elementor-widget-wrap elementor-element-populated\">\n\t\t\t\t\t\t\t\t<div class=\"elementor-element elementor-element-776ec65 elementor-widget-divider--view-line elementor-widget elementor-widget-divider\" data-id=\"776ec65\" data-element_type=\"widget\" data-widget_type=\"divider.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t<div class=\"elementor-divider\">\n\t\t\t<span class=\"elementor-divider-separator\">\n\t\t\t\t\t\t<\/span>\n\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-08c46c9 elementor-widget elementor-widget-heading\" data-id=\"08c46c9\" data-element_type=\"widget\" data-widget_type=\"heading.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t<h2 class=\"elementor-heading-title elementor-size-default\">How I Work<\/h2>\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-5ca1b6c elementor-widget elementor-widget-alert\" data-id=\"5ca1b6c\" data-element_type=\"widget\" data-widget_type=\"alert.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t<div class=\"elementor-alert elementor-alert-info\" role=\"alert\">\n\t\t\t<span class=\"elementor-alert-title\">\ud83d\udca1 I explain complex things in a simple way.<\/span>\n\t\t\t\t\t\t\t<span class=\"elementor-alert-description\">\u2699\ufe0f I always ask: can we automate this? <br>\n\ud83d\udcc8 Data is only useful when it helps people make better decisions.<\/span>\n\t\t\t\t\t\t\t\t\t\t<button type=\"button\" class=\"elementor-alert-dismiss\">\n\t\t\t\t\t<span aria-hidden=\"true\">&times;<\/span>\n\t\t\t\t\t<span class=\"elementor-screen-only\">Dismiss alert<\/span>\n\t\t\t\t<\/button>\n\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t<section class=\"elementor-section elementor-top-section elementor-element elementor-element-dc435ad elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"dc435ad\" data-element_type=\"section\">\n\t\t\t\t\t\t<div class=\"elementor-container elementor-column-gap-default\">\n\t\t\t\t\t<div class=\"elementor-column elementor-col-100 elementor-top-column elementor-element elementor-element-b9add71\" data-id=\"b9add71\" data-element_type=\"column\">\n\t\t\t<div class=\"elementor-widget-wrap elementor-element-populated\">\n\t\t\t\t\t\t\t\t<div class=\"elementor-element elementor-element-2a9c609 elementor-widget-divider--view-line elementor-widget elementor-widget-divider\" data-id=\"2a9c609\" data-element_type=\"widget\" data-widget_type=\"divider.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t<div class=\"elementor-divider\">\n\t\t\t<span class=\"elementor-divider-separator\">\n\t\t\t\t\t\t<\/span>\n\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-e9aaaaf elementor-widget elementor-widget-heading\" data-id=\"e9aaaaf\" data-element_type=\"widget\" data-widget_type=\"heading.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t<h2 class=\"elementor-heading-title elementor-size-default\">Tools & Skills<\/h2>\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-d1a814b elementor-widget elementor-widget-text-editor\" data-id=\"d1a814b\" data-element_type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t<p><strong>Power BI<\/strong>\u00a0\u2013 dashboards, DAX, visualizations<br \/><strong>Python<\/strong>\u00a0\u2013 scripting, automation, data processing<br \/><strong>Excel\/VBA<\/strong>\u00a0\u2013 advanced reporting and macros<br \/><strong>Power Automate, Zapier<\/strong>\u00a0\u2013 flow automation<br \/><strong>MailerLite, Manychat<\/strong>\u00a0\u2013 no-code marketing tools<br \/><strong>WordPress, WooCommerce, Easycart <\/strong>&#8211; webiste and online shop<br \/><strong>ERP &amp; Business Systems <\/strong>&#8211;\u00a0SAP, O365<\/p>\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-3484268 elementor-widget elementor-widget-text-editor\" data-id=\"3484268\" data-element_type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t<p><strong>Business Analysis &amp; Documentation <\/strong>&#8211; requirements gathering, stakeholder interviews &amp; presentations, process mapping (Visio, draw.io), SOP creation<br \/><strong>Process Improvement &amp; Automation<\/strong> &#8211; finding ways to optimize and streamline business processes.<br \/><strong>Data Analysis<\/strong><br \/><strong>Soft Skills<\/strong> &#8211; problem solving, communication, facilitation, translating tech into business language<\/p>\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t<section class=\"elementor-section elementor-top-section elementor-element elementor-element-0b35a96 elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"0b35a96\" data-element_type=\"section\">\n\t\t\t\t\t\t<div class=\"elementor-container elementor-column-gap-default\">\n\t\t\t\t\t<div class=\"elementor-column elementor-col-100 elementor-top-column elementor-element elementor-element-8adee1d\" data-id=\"8adee1d\" data-element_type=\"column\">\n\t\t\t<div class=\"elementor-widget-wrap elementor-element-populated\">\n\t\t\t\t\t\t\t\t<div class=\"elementor-element elementor-element-8a53941 elementor-widget-divider--view-line elementor-widget elementor-widget-divider\" data-id=\"8a53941\" data-element_type=\"widget\" data-widget_type=\"divider.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t<div class=\"elementor-divider\">\n\t\t\t<span class=\"elementor-divider-separator\">\n\t\t\t\t\t\t<\/span>\n\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-f65ffde elementor-widget elementor-widget-heading\" data-id=\"f65ffde\" data-element_type=\"widget\" data-widget_type=\"heading.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t<h2 class=\"elementor-heading-title elementor-size-default\">Let\u2019s Work Together<\/h2>\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-76b44c1 elementor-widget elementor-widget-text-editor\" data-id=\"76b44c1\" data-element_type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t<p><strong>If you&#8217;re looking for someone who can connect tech with people \u2013 turning data into insights and manual work into automation \u2013 let&#8217;s talk!<\/strong><\/p>\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t","protected":false},"excerpt":{"rendered":"<p>Konstancja Opryszek Improvements | Data Analyst | Automation Specialist | Process optimization | Power BI | Python | Low-Codes Featured Projects \ud83d\uded2 Automating Product Creation \u2013 Bridging User Input with Two Systems Python (selenium, gspread, googleapiclient, python-dotenv, requests) One of the most technically rewarding automations I developed was a solution for automatically creating new products &hellip; <\/p>\n<p class=\"link-more\"><a href=\"https:\/\/konstancjaopryszek.pl\/index.php\/portfolio-2\/\" class=\"more-link\">Read more<span class=\"screen-reader-text\"> &#8220;Portfolio &#8211; Konstancja Opryszek&#8221;<\/span><\/a><\/p>\n","protected":false},"author":1,"featured_media":0,"parent":0,"menu_order":0,"comment_status":"closed","ping_status":"closed","template":"","meta":[],"_links":{"self":[{"href":"https:\/\/konstancjaopryszek.pl\/index.php\/wp-json\/wp\/v2\/pages\/235"}],"collection":[{"href":"https:\/\/konstancjaopryszek.pl\/index.php\/wp-json\/wp\/v2\/pages"}],"about":[{"href":"https:\/\/konstancjaopryszek.pl\/index.php\/wp-json\/wp\/v2\/types\/page"}],"author":[{"embeddable":true,"href":"https:\/\/konstancjaopryszek.pl\/index.php\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/konstancjaopryszek.pl\/index.php\/wp-json\/wp\/v2\/comments?post=235"}],"version-history":[{"count":68,"href":"https:\/\/konstancjaopryszek.pl\/index.php\/wp-json\/wp\/v2\/pages\/235\/revisions"}],"predecessor-version":[{"id":322,"href":"https:\/\/konstancjaopryszek.pl\/index.php\/wp-json\/wp\/v2\/pages\/235\/revisions\/322"}],"wp:attachment":[{"href":"https:\/\/konstancjaopryszek.pl\/index.php\/wp-json\/wp\/v2\/media?parent=235"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}