BI Highlights

Power BI - Reusable Post-campaign-Report (PCR) Templates

I designed PCR templates specifically for a client team to reduce their daily reporting workload. The templates are the last step in a five-stage automated data mart architecture.

The pipeline involves Google Sheets, Excel, PowerQuery, Dataflow(PowerQuery online), Power BI Service, and Power BI templates.

Power BI - Snowflake Data Modeling for Reporting

To facilitate the 10+ Power BI templates on different media data, I created a master snowflake model for data warehousing. The model is kept live and automatically refreshed on Power BI services, feeding real-time data connection to individual Power BI templates.

The model was tailored to user needs through constant consultation and communication.

Google Looker Studio - Realtime reporting

Apart from Power BI, I also excel in Looker Studio within the Google Cloud ecology, particularly in digital marketing metrics and dimensions.

I also found Looker Studio as a terrific quick tool for testing and cross-checking. Clever data blending in Looker Studio offers some modelling capacity that is much faster than coding and Tableau setting up.

Excel Dashboard - SuperStore Sample

Let us not downplay Excel. PowerQuery, Power Pivot and MS Access are also powerful (and free) options for SMEs. Though using will require quite some manoeuvres - like switching off autopilot for a manual flight.

Sharepoint - Report Portals

I designed project-based Sharepoint portals as the output parts of a data pipeline. I found the tool especially helpful if your organization is already using MS 365 suite.

This Website

I designed and created this website by myself. If something here you don't like, leave a message and let me know! I will make sure to fix that in the new design cycle. Much Appreciated.

Tableau - Standardization for Project Management

Maintaining a unified look and design is especially challenging in Tableau because of its desktop publishing formatting style.

It is truly a design process and I kept communicating standardization in mind while endeavouring for better designs.

Tableau - Multi-layer Rolling NPS Calculation with a Timeline

This NPS dash is an example of how a simple calculation can become super complex, involving more than one layer of calculation over base NPS: customised period, comparison with the preceding period, demographic groups, etc.

Tableau - An Example of Technical Problem-solving

I praise Tableau for its amazing flexibility. However, we have to acknowledge that it is designed very differently from MS and Google tools. This is an example of how a simple data source switch problem became a long headache until I came across a clue.

A Media Data Processing Architecture

Without precedence in the organization, I explored, researched, and designed this workflow (with every detail in connective steps, as well as data modelling in PowerQuery + Power BI service) three months into my work at a previous media corporation. This is also why I believe there's always more than "I know SQL", understanding not only the business but also how the data should be handled and refreshed for consistency and accuracy, which is the foundation for reporting insights.

Practices

Power BI - Star Schema Modelling for Marketing Insights

Constructing a star schema model in PowerBI I found automation is quite strong compared to SQL Server commands. The interactive viz shows gross margin and total revenue across product categories.

The analysis involved data modelling in PowerBI using Excel tables.

Shipping Destinations

Using the Superstore data, this analysis presents the shipping destinations and their respective total value across the global markets. The visualization provides very strong clues in national sales data.

The analysis was completed using Excel and Power BI.

U.S. Wind Power Operators -
Potential Investment Targets

I love to make the interactions interesting and intuitive. The dashboard shows competent wind power owners in the U.S. to be considered in a future investment portfolio. The map in the middle will automatically change and zoom in and out with the user selection of the companies. The interactive analysis mainly used Python and Tableau to generate insights.

Customer Churn Analysis

In the GA capstone project, I focused on analyzing a telecommunication company's customer churn in order to advise decision-making in future marketing plans.

The demographics analysis mainly involved using SQL, Python, the KNN model, and Tableau.

Sales Agents Performance

The analysis used a popular sample data Superstore to visualize sales agents' performances in major global markets. The viz assists in performance evaluation.

The analysis was completed using Excel and Power BI.