I am an expert in Power BI, Looker Studio, Tableau and data processing architectures. I understand their strengths and weaknesses as well as how to integrate various other tools into automated data processing structures (data warehouse/data mart architecture). While designing these solutions, I also acknowledge that not all users should love to use tech, so it is important to make them as straightforward and streamlined as possible.
Data, Business Intelligence (BI) and Process Automation
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 Model 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 for user needs through constant consultation and communication.
Excel Dashboard - SuperStore Sample
Let us not downplay Excel here. In addition, PowerQuery, Power Pivot and MS Access are also powerful (and free) options for SMEs.
To use will require quite some manoeuvres though - like switching off autopilot for a manual flight.
Google Looker Studio
Apart from Power BI, I am an expert in Looker Studio within the Google Cloud ecology, in particular digital marketing metrics and dimensions. If BigQuery is too expensive, clever data blending in Looker Studio also offers some modeling capacity. The above example is a dashboard created for one of my workplace's clients.
Sharepoint - Report Portals
I have 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
This website is designed and created by me. If something here you don't like, leave a message and let me know! I will make sure to fix that.
Much Appreciated.
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 modeling in PowerBI using excel tables.
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.
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.
B&B Sales Analysis & Projections
The interactive analysis describes and predicts 2022-23 sales performance of a company's 10 offices across Australia. The storyboard answers some key questions from the management, such as who are the best salespersons in top-selling products. The analysis mainly involved using Excel data and Tableau.
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.