Skip to content
View BWiekiera's full-sized avatar
1 follower · 1 following

Block or report BWiekiera

Block user

Prevent this user from interacting with your repositories and sending you notifications. Learn more about blocking users.

You must be logged in to block users.

Content in all repositories owned by your account will be closed.
Maximum 250 characters. Please don’t include any personal information such as legal names or email addresses. This note will only be visible to you.
Report abuse

Contact GitHub support about this user’s behavior. Learn more about reporting abuse.

Report abuse
BWiekiera/README.md

Hi, I'm Bernardeta Wiekiera

Business experience + data analytics portfolio

I combine over 20 years of business experience with data analytics skills developed through practical portfolio projects. My background includes banking, mortgage advisory, real estate, financial consulting and business support for sales networks.

I focus on turning business processes and operational data into clear reports, dashboards and recommendations. I am especially interested in ETL processes, data visualization, reporting automation and the practical use of AI in business.

What I do

  • Build business-oriented reports and dashboards in Excel and Power BI
  • Prepare and transform data using Power Query / ETL
  • Create data models, KPI measures and analytical logic using Power Pivot and DAX
  • Use SQL to query, filter, join and aggregate data
  • Automate selected Excel workflows with VBA / macros
  • Translate business questions into measurable indicators, visualizations and practical conclusions

Tools and technologies

Excel · Power Query / ETL · Power Pivot · Power BI · DAX · SQL · VBA / Macros · SAP · Dashboarding · Reporting

Portfolio projects

Marketing Funding Committee CRM & Dashboard

An Excel-based business tool supporting the review of marketing funding applications, settlement control and program performance analysis.

The project includes synthetic business data, Power Query data preparation, a data model, KPI dashboards, operational worksheets and a VBA decision form.

Tools: Excel, Power Query, Power Pivot, VBA, KPI dashboards
Repository: marketing-funding-analytics
Case study: Portfolio project page

Marketing Funding Program Performance Analysis

A Power BI project showing the same business process from a management perspective. The report analyzes granted funding, margins, ROI, payback, initiative effectiveness, regional performance and settlement risks.

The project is focused on turning operational data into executive-level insights and business recommendations.

Tools: Power BI, Power Query, DAX, data model, KPI reporting
Repository: Power BI project repository
Case study: Portfolio project page

Professional background

Allianz | Business support and sales network processes

As a Regional Support Manager, I worked with sales network support, business process coordination, marketing budgets, reporting, application review processes and settlement control.

Own business | Real estate and financial consulting

For 7 years I ran my own business, combining real estate services with financial consulting. This gave me strong experience in client needs analysis, business decision-making and process ownership.

PKO Bank Polski | Banking and mortgage advisory

I spent 15 years in banking, working with financial documentation, credit risk assessment, mortgage advisory and team management.

Currently developing

I am currently strengthening my skills in:

  • advanced Power BI reporting and DAX measures,
  • SQL-based data analysis,
  • ETL and data preparation workflows,
  • business reporting and dashboard storytelling,
  • automation of repetitive analytical tasks,
  • practical use of AI in business and data work,
  • business English for data and reporting roles.

My approach

I believe data is valuable when it helps people understand a business situation and make better decisions. That is why I focus not only on charts, but also on context, process logic, risks, conclusions and clear communication with business users.

Contact

Popular repositories Loading

  1. BWiekiera BWiekiera Public

    GitHub profile README presenting my business background, data analytics portfolio and current learning path.

    1

  2. portfolio portfolio Public

    Personal portfolio website presenting my business experience, data analytics projects, certificates and career transition into data/reporting roles.

    HTML 1

  3. marketing-funding-analytics marketing-funding-analytics Public

    Excel-based CRM and dashboard supporting marketing funding application review, settlement control and program performance analysis.

    VBA

  4. marketing-funding-program-performance-analysis marketing-funding-program-performance-analysis Public

    Power BI report analyzing marketing funding program performance, profitability, regional results and settlement risk.

  5. maven-toys-sql-analysis maven-toys-sql-analysis Public

    SQL case study analysing sales, profitability, store performance, trends, and inventory for Maven Toys.

  6. customer-retention-segmentation-sql customer-retention-segmentation-sql Public

    Customer retention and segmentation analysis in PostgreSQL using RFM, cohort retention, lifecycle, reactivation, cancellation impact and seasonality.