<?xml version="1.0" encoding="UTF-8"?><rss xmlns:dc="http://purl.org/dc/elements/1.1/" xmlns:content="http://purl.org/rss/1.0/modules/content/" xmlns:atom="http://www.w3.org/2005/Atom" version="2.0" xmlns:cc="http://cyber.law.harvard.edu/rss/creativeCommonsRssModule.html">
    <channel>
        <title><![CDATA[Stories by Emmanuel Olukanni on Medium]]></title>
        <description><![CDATA[Stories by Emmanuel Olukanni on Medium]]></description>
        <link>https://medium.com/@oceanemm18?source=rss-1bab71344ddb------2</link>
        <image>
            <url>https://cdn-images-1.medium.com/fit/c/150/150/1*7iZ8PkgTbd_GYm-QbsDVvQ.jpeg</url>
            <title>Stories by Emmanuel Olukanni on Medium</title>
            <link>https://medium.com/@oceanemm18?source=rss-1bab71344ddb------2</link>
        </image>
        <generator>Medium</generator>
        <lastBuildDate>Fri, 20 Nov 2026 12:17:25 GMT</lastBuildDate>
        <atom:link href="https://medium.com/@oceanemm18/feed" rel="self" type="application/rss+xml"/>
        <webMaster><![CDATA[yourfriends@medium.com]]></webMaster>
        <atom:link href="http://medium.superfeedr.com/" rel="hub"/>
        <item>
            <title><![CDATA[Functional Distinctions Between CAC Registration and Trademark Rights]]></title>
            <link>https://medium.com/@oceanemm18/functional-distinctions-between-cac-registration-and-trademark-rights-28401246cf71?source=rss-1bab71344ddb------2</link>
            <guid isPermaLink="false">https://medium.com/p/28401246cf71</guid>
            <category><![CDATA[legal-insights]]></category>
            <category><![CDATA[company-registration]]></category>
            <category><![CDATA[trademark]]></category>
            <category><![CDATA[trademark-registration]]></category>
            <dc:creator><![CDATA[Emmanuel Olukanni]]></dc:creator>
            <pubDate>Wed, 28 Jan 2026 12:56:16 GMT</pubDate>
            <atom:updated>2026-01-28T12:56:16.362Z</atom:updated>
            <content:encoded><![CDATA[<figure><img alt="" src="https://cdn-images-1.medium.com/max/525/1*yRdwC0sbeyAT2kc0gs6pAA.jpeg" /></figure><p>The functional distinction between registration with the Corporate Affairs Commission and trademark registration lies at the heart of the conceptual confusion this article characterises as a malady. While both regimes employ the language of “registration” and confer a form of legal recognition, their objectives, legal consequences, and enforcement mechanisms differ fundamentally. CAC registration, whether by incorporation or business name registration, is concerned primarily with regulatory compliance, public notice, and the legal organisation of commercial activity. Trademark registration, by contrast, is intended to protect commercial identity, consumer perception, and proprietary goodwill in the marketplace.</p><p>The registration process under the <em>Companies and Allied Matters Act (CAMA) 2020</em> serves two distinct roles, either constitutive or declaratory, depending on the specific category of registration being pursued. The process of incorporation results in the formation of a legal entity that possesses a separate and distinct legal existence from its members, effectively shielding them from personal liability for the entity’s debts and obligations. In contrast, the registration of a business name primarily serves to formalise and document the identity under which an individual or partnership conducts business operations, without creating a separate legal entity.</p><p>Importantly, it should be noted that CAMA does not bestow exclusive proprietary rights over the registered name as a commercial identifier in either scenario. This intentional limitation is a critical aspect of the legislation. Specifically, Section 852 of CAMA expressly upholds the supremacy of trademark law and other intellectual property rights by clarifying that the registration of a business name does not authorise its use if such use infringes on existing trademark rights or constitutes passing off. This provision ensures that the rights of trademark holders are preserved, thereby preventing consumer confusion and protecting the integrity of established brands. <a href="#_ftn1">[1]</a> This statutory provision is a clear legislative acknowledgement that CAC registration and trademark protection operate on different legal planes.</p><p>Trademark registration, governed by the <em>Trademarks Act</em>, performs a fundamentally different function. It creates an enforceable monopoly over the use of a mark in relation to specific goods or services, grounded in the protection of source-identifying symbols in trade. The exclusive right conferred by section 5 of the Act is not merely administrative but proprietary, enabling the owner to restrain third parties, including duly incorporated companies, from using identical or confusingly similar marks in the course of trade. <a href="#_ftn2">[2]</a> This distinction explains why Nigerian courts have consistently refused to treat CAC registration as a defence to trademark infringement or passing off.</p><p>The jurisprudence on this point is well settled. In <em>Niger Chemists Ltd v Nigeria Chemists</em>, the Supreme Court rejected the argument that business name registration could legitimise the continued use of a confusingly similar trade name, holding that the decisive issue was the likelihood of deception and damage to goodwill, not the fact of registration. <a href="#_ftn3">[3]</a> The Court’s reasoning underscores the principle that CAC registration is evidentiary of compliance, not determinative of proprietary entitlement. Similarly, in <em>Ferodo Ltd v Ibeto Industries Ltd</em>, the court restrained the defendant from using a mark closely resembling that of the claimant, notwithstanding the defendant’s corporate existence and market presence, reaffirming that trademark rights trump corporate nomenclature where conflict arises. <a href="#_ftn4">[4]</a></p><p>This functional hierarchy is further illuminated by the remedial consequences available under each regime. CAC registration offers no direct enforcement mechanism against third-party misuse of a name. A registrant who discovers that another entity is trading under a similar or identical name cannot rely on CAMA alone to obtain injunctive relief or damages. At best, such a registrant must resort to passing off or trademark law, thereby conceding that the real source of protection lies outside the corporate registry framework. Trademark registration, on the other hand, grants direct access to infringement proceedings before the Federal High Court, with remedies including injunctions, damages, and accounts of profits. The availability of these remedies reinforces the proprietary nature of trademark rights and exposes the relative weakness of CAC registration as a brand-protection tool.</p><p>Comparative jurisprudence strengthens this conclusion. In <em>Ewing v Buttercup Margarine Co Ltd</em>, the English Court of Appeal restrained a company from trading under a name that misrepresented an association with the claimant, despite the defendant’s lawful incorporation. <a href="#_ftn5">[5]</a> Nigerian courts have repeatedly adopted this reasoning, reflecting the shared common law principle that incorporation cannot be used as an instrument of deception. The persuasive value of such authorities has been evident in Nigerian trademark and passing-off cases, where courts prioritise consumer protection and goodwill over formal registration status.</p><p>The persistence of confusion between these regimes is partly attributable to institutional practice. The CAC’s name availability checks are limited to its own register and do not extend to the trademark register maintained by the Trademarks Registry. Consequently, a name may be approved and registered at the CAC while simultaneously infringing a pre-existing trademark. This administrative fragmentation creates a false sense of security for businesses, many of which proceed to invest substantial resources in branding on the mistaken belief that CAC registration confers exclusivity. Academic commentary has criticised this regulatory disconnect as a systemic weakness that fuels avoidable disputes and undermines commercial certainty. <a href="#_ftn6">[6]</a></p><p>In conclusion, it is fundamentally critical to differentiate between Corporate Affairs Commission (CAC) registration and trademark rights, as this distinction extends beyond mere technicalities. CAC registration serves to identify the entities authorised to conduct business and the names under which they operate, thereby maintaining a public record. Conversely, trademark registration is designed to protect the identity and origin of a business name or symbol within the marketplace. A failure to comprehend this essential difference contributes to the ongoing conflation of corporate identity with proprietary brand rights. To mitigate the trademark disputes that arise from this misunderstanding, it is imperative for businesses, their advisors, and regulatory authorities to thoroughly understand and internalise this distinction. Only by doing so can we aspire to alleviate the burden that these disputes impose on the Nigerian courts and commercial entities.</p><p><a href="#_ftnref1">[1]</a> Companies and Allied Matters Act 2020, s 852.</p><p><a href="#_ftnref2">[2]</a> Trademarks Act, Cap T13, Laws of the Federation of Nigeria 2004, s 5.</p><p><a href="#_ftnref3">[3]</a> <em>Niger Chemists Ltd v Nigeria Chemists</em> (1961) 1 All NLR 171 (SC).</p><p><a href="#_ftnref4">[4]</a> <em>Ferodo Ltd v Ibeto Industries Ltd</em> (2004) 5 NWLR (Pt 866) 317.</p><p><a href="#_ftnref5">[5]</a> <em>Ewing v Buttercup Margarine Co Ltd</em> [1917] 2 Ch 1 (CA).</p><p><a href="#_ftnref6">[6]</a> A A Adebola, “Business Names, Trademarks and Regulatory Fragmentation in Nigeria” (2019) 3 <em>Nigerian Journal of Commercial Law</em> 45.</p><img src="https://medium.com/_/stat?event=post.clientViewed&referrerSource=full_rss&postId=28401246cf71" width="1" height="1" alt="">]]></content:encoded>
        </item>
        <item>
            <title><![CDATA[Game ROI: Strategic Console Sales & Marketing Analysis]]></title>
            <link>https://medium.com/@oceanemm18/game-roi-strategic-console-sales-marketing-analysis-c7367a45f39a?source=rss-1bab71344ddb------2</link>
            <guid isPermaLink="false">https://medium.com/p/c7367a45f39a</guid>
            <category><![CDATA[best-gaming-console]]></category>
            <category><![CDATA[data-analysis]]></category>
            <category><![CDATA[gaming]]></category>
            <category><![CDATA[hardcore-gamers]]></category>
            <dc:creator><![CDATA[Emmanuel Olukanni]]></dc:creator>
            <pubDate>Wed, 10 Dec 2025 09:34:04 GMT</pubDate>
            <atom:updated>2025-12-10T09:34:04.905Z</atom:updated>
            <content:encoded><![CDATA[<figure><img alt="" src="https://cdn-images-1.medium.com/max/1024/1*hO47z7MjUJ4t4AIiMabiDw.jpeg" /><figcaption>Unsplash</figcaption></figure><h3><strong>Introduction</strong></h3><p>The gaming console industry is highly competitive, shaped by evolving consumer preferences and aggressive marketing strategies. This project aims <em>to identify key revenue drivers, evaluate the impact of marketing efforts, and derive actionable insights for strategic growth in the gaming console industry.</em> By analysing sales performance, marketing efficiency, customer segments, and regional trends, the report provides a clear foundation for informed decision-making and future strategy.</p><h3><strong>Objectives</strong></h3><ol><li>Analyse sales performance;</li><li>Analyse customer behaviour;</li><li>Review marketing effectiveness</li><li>Analyse product quality across major gaming console brands in 2025.</li></ol><h3><strong>Work Done</strong></h3><ul><li>Imported and analysed the dataset containing <strong>100 records</strong> across brands, regions, customer segments, and sales channels.</li><li>Created and reviewed <strong>Pivot Tables and Dashboards</strong> summarising brand-wise, regional, and channel-specific performance.</li><li>Computed core KPIs and compared trends to assess profitability and marketing return on investment.</li><li>Examined customer segments and return rates to evaluate satisfaction and product quality.</li><li>Synthesised insights and recommendations aligned with business goals and market trends.</li></ul><h3><strong>Pivot Tables</strong></h3><figure><img alt="" src="https://cdn-images-1.medium.com/max/1024/1*BkCbRAnBqNynEn2D59Kguw.png" /><figcaption>Pivot tables</figcaption></figure><p>Pivot tables played a central role in organising and analysing the gaming console sales data by transforming raw figures into meaningful insights. They were used to calculate key performance indicators such as total marketing budget, total revenue, units sold, and average return rate, offering a clear snapshot of overall business performance. Additionally, pivot tables helped compare sales across console brands — Nintendo Switch, PlayStation 5, and Xbox Series X — highlighting which products generated the most revenue and how they performed month by month.</p><p>Beyond brand-level analysis, pivot tables were instrumental in evaluating regional contributions and marketing effectiveness. They summarised revenue by region, revealing Africa and Asia as top performers, and calculated return on marketing investment across different markets, with Asia showing the highest ROI. These insights enabled a deeper understanding of where marketing efforts were most effective and which regions offered the greatest growth potential, forming the basis for strategic recommendations.</p><h3>Data Visualization</h3><figure><img alt="" src="https://cdn-images-1.medium.com/max/1024/1*ze9qgrWKJErMx15UCAa4QQ.png" /><figcaption>Dashboard 1</figcaption></figure><p>We developed an interactive dashboard to visualise key metrics and trends in console data, which includes:</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/1024/1*mvljKyEOzcSE2mFUfFHKYA.png" /><figcaption>Dashboard 2</figcaption></figure><ul><li><strong>Overall KPIs</strong></li><li>Marketing budget: <strong>$2.52M</strong> generated <strong>$15.70 revenue</strong> from <strong>249.15K units sold</strong>, showing a strong <strong>467% average return rate</strong>.</li><li>This highlights highly efficient marketing spend across all consoles.</li></ul><p><strong>Console Brand Performance</strong></p><ul><li><strong>Nintendo Switch</strong>: <strong>$6.24M revenue</strong> (largest share), supported by a <strong>$1.02M marketing budget</strong>.</li><li><strong>PlayStation 5</strong>: <strong>$5.97M revenue</strong> with a leaner <strong>$845K marketing budget</strong>, making it the most efficient brand in terms of spend-to-revenue ratio.</li><li><strong>Xbox Series X</strong>: <strong>$4.49M revenue</strong> with <strong>$652K marketing budget</strong>, trailing behind but still profitable.</li><li>The dashboards show PlayStation 5 as the most cost-effective performer, while Nintendo Switch leads in absolute sales.</li></ul><p><strong>Regional Contribution &amp; ROI</strong></p><ul><li><strong>Africa</strong>: Highest revenue at <strong>$4.21M</strong>, with ROI of <strong>637%</strong>.</li><li><strong>Asia</strong>: Revenue of <strong>$3.24M</strong>, but the standout with <strong>867% ROI</strong>, proving the most efficient market.</li><li><strong>North America</strong>: <strong>$2.88M revenue</strong>, ROI <strong>748%</strong>, showing strong marketing impact.</li><li><strong>Europe</strong>: <strong>$2.83M revenue</strong>, ROI <strong>455%</strong>, relatively weaker efficiency.</li><li><strong>South America</strong>: <strong>$2.57M revenue</strong>, ROI <strong>748%</strong>, solid returns despite lower revenue.</li><li>Visuals highlight Africa as the largest revenue contributor, while Asia delivers the best marketing efficiency.</li></ul><p><strong>Monthly Sales Trends</strong></p><ul><li><strong>Nintendo Switch</strong> peaked in <strong>April ($902K)</strong> and <strong>July ($693K)</strong>, but dipped sharply in <strong>May ($175K)</strong> and <strong>September ($167K)</strong>.</li><li><strong>PlayStation 5</strong> had a major spike in <strong>September ($1.33M)</strong>, showing seasonal demand, but dropped drastically in <strong>October ($80K)</strong>.</li><li><strong>Xbox Series X</strong> also peaked in <strong>September ($1.11M)</strong>, with strong late-year performance in <strong>November–December ($637K each)</strong>.</li><li>Visualisations reveal September as a critical sales month across all consoles, suggesting seasonal or promotional drivers.</li></ul><p><strong>Marketing Efficiency by Brand</strong></p><ul><li>PlayStation 5 achieved the <strong>highest revenue-to-budget ratio</strong>, generating nearly <strong>7x returns</strong> on its spend.</li><li>Nintendo Switch, while leading in revenue, required the largest marketing budget, reducing efficiency compared to the PS5.</li><li>Xbox Series X showed moderate efficiency but lagged in overall revenue contribution.</li></ul><h3><strong>Insights</strong></h3><p>The PlayStation 5 stands out as the top-performing console, generating <strong>$5.97 million </strong>in revenue and selling over <strong>99,000 units</strong>. Its marketing efficiency is notable, achieving a return on investment of 706% from an <strong>$845,350</strong> budget, underscoring its strong market presence and consumer appeal. The Nintendo Switch, while slightly behind in total revenue at $5.24 million, demonstrates exceptional marketing efficiency with a 514% return on a $1.02 million budget, reflecting loyal customer engagement and cost-effective campaigns. In contrast, the Xbox Series X trails with the lowest unit sales at 65,000 and the highest average return rate of 501%, suggesting potential issues with product satisfaction or quality. Online sales channels have overtaken retail in revenue generation, contributing $8.2 million compared to $7.5 million from retail, although retail still leads in volume with 142,260 units sold versus 106,890 online, indicating the effectiveness of in-store promotions. Casual gamers are the largest contributors to unit sales, accounting for over 70,000 units and $4.44 million in revenue, despite a high return rate of 5.27%, while hardcore gamers, though fewer in number, are the most profitable segment with $2.18 million in revenue and lower return rates, highlighting their consistent purchasing behaviour and brand loyalty.</p><h3><strong>Recommendations</strong></h3><p>To strengthen market leadership, PlayStation 5 should receive increased marketing investment and supply chain expansion, with a particular focus on high-value regions such as Europe and Africa. Addressing Xbox Series X’s elevated return rates is critical; a structured initiative involving product quality assessments, customer feedback analysis, and enhanced post-purchase support will be necessary to restore consumer confidence. Marketing resources should be strategically reallocated toward online channels, which are delivering superior revenue performance compared to retail, while maintaining selective in-store promotions to preserve unit sales volume. Casual gamers, who represent the largest sales segment despite higher return rates, should be engaged through retention programs such as loyalty schemes and subscription bundles to drive repeat purchases and reduce churn. Finally, regional growth opportunities in Africa and Europe should be prioritised, with tailored promotional strategies and optimised inventory management to capture their strong sales potential and maximise profitability.</p><img src="https://medium.com/_/stat?event=post.clientViewed&referrerSource=full_rss&postId=c7367a45f39a" width="1" height="1" alt="">]]></content:encoded>
        </item>
        <item>
            <title><![CDATA[Pizza by the Numbers: Emmy’s Sales Dashboard Analysis]]></title>
            <link>https://medium.com/@oceanemm18/pizza-by-the-numbers-emmys-sales-dashboard-analysis-44da078cb075?source=rss-1bab71344ddb------2</link>
            <guid isPermaLink="false">https://medium.com/p/44da078cb075</guid>
            <category><![CDATA[profit-margin]]></category>
            <category><![CDATA[sales]]></category>
            <category><![CDATA[data-analysis]]></category>
            <category><![CDATA[pizza]]></category>
            <dc:creator><![CDATA[Emmanuel Olukanni]]></dc:creator>
            <pubDate>Mon, 08 Dec 2025 14:29:12 GMT</pubDate>
            <atom:updated>2025-12-08T14:29:12.413Z</atom:updated>
            <content:encoded><![CDATA[<figure><img alt="" src="https://cdn-images-1.medium.com/max/1024/1*fYI78RqxSGbLzazXiBc9Tw.jpeg" /><figcaption>Unsplash</figcaption></figure><h3>Introduction</h3><p>Emmy’s Pizza is a fast-growing pizza business that has implemented a data-driven approach to monitor and optimise its operations. This documentation outlines the analytical process and insights derived from a comprehensive dashboard that tracks sales performance, customer preferences, and operational trends. The dashboard serves as a critical tool for strategic decision-making, enabling the business to respond dynamically to market demands.</p><h3>Executive Summary</h3><p>The Emmy’s Pizza dashboard aggregates key metrics such as total orders, revenue, quantity sold, average price, pizza types, and categories. It provides granular insights into customer behaviour, pizza popularity, pricing strategies, and time-based sales trends. The analysis reveals that the business thrives during afternoon and evening hours, with large-sized pizzas being the most preferred. Chicken and Veggie categories dominate revenue and customer interest, highlighting targeted segments for growth.</p><h3>Objectives</h3><ol><li>To evaluate sales performance across different pizza types and categories with a focus on revenue contribution and quantity sold.</li><li>To identify customer preferences based on quantity, size, and dietary choices, and analyse patterns that influence purchasing behaviour.</li><li>To analyse time-based trends in orders and revenue to optimise operational efficiency and marketing efforts.</li><li>To provide actionable recommendations grounded in data analytics for improving sales, customer satisfaction, and inventory management.</li></ol><h3>Work Done</h3><p>a. Data collection from point-of-sale systems ensures comprehensive capture of transactional data.</p><p>b. Cleaning and preprocessing of sales data to remove inconsistencies and prepare for analysis.</p><p>c. Creation of pivot tables for categorical analysis, enabling multi-dimensional insights.</p><p>d. Development of an interactive dashboard using advanced visualisation tools to facilitate real-time monitoring.</p><p>e. Extraction of insights through statistical analysis and trend identification.</p><p>f. Formulation of strategic recommendations based on analytical findings.</p><h3>Pivot Tables</h3><figure><img alt="" src="https://cdn-images-1.medium.com/max/890/1*7ldmbvSf4UCWuBGCOFS_Fg.png" /></figure><ul><li><strong>Pizza Category vs Revenue</strong>: Highlights Veggie category’s disproportionate revenue contribution relative to its variety.</li><li><strong>Pizza Size vs Quantity Sold</strong>: Demonstrates customer preference skewed towards larger sizes.</li><li><strong>Time of Day vs Orders</strong>: Identifies peak sales windows in the afternoon and evening.</li><li><strong>Day of Week vs Orders</strong>: Shows weekdays dominate sales volume (73%), suggesting workday demand.</li><li><strong>Pizza Type vs Revenue and Quantity</strong>: Pinpoints top-performing pizzas like Thai Chicken and Classic Deluxe.</li><li><strong>Customer Preference vs Quantity Ordered</strong>: Reveals the majority of single pizza orders, indicating potential for promotional strategies.</li></ul><h3>Data Visualisation</h3><figure><img alt="" src="https://cdn-images-1.medium.com/max/1024/1*inrUFfKweEgmcwGByZy7_w.png" /><figcaption>Dashboard 1</figcaption></figure><ol><li><strong>Total Revenue from Top-Selling Pizzas</strong>: Thai Chicken leads with $45.2K, followed by Classic Deluxe at $42.7K, indicating strong customer preference.</li><li><strong>Quantity Sold for Top Pizzas</strong>: Thai Chicken sold 5.1K units, Classic Deluxe 4.8K units, confirming popularity in volume.</li><li><strong>Customer Preferences</strong>: 11.65K vegetarian orders (23.96%) versus 37.93K non-vegetarian orders (76.04%), showing a dominant non-vegetarian market.</li><li><strong>Order Quantity Distribution</strong>: 47.69K single pizza orders (98.13%) compared to 1.88K multiple pizza orders (1.87%), highlighting potential for upselling.</li><li><strong>Hourly Sales Trends</strong>: Peak sales occur between 12 PM–2 PM with 8.5K orders and 5 PM–6 PM with 7.2K orders, guiding staffing and marketing efforts.</li><li><strong>Order Distribution by Day and Time</strong>: Weekdays account for 35.5K orders (73%), with Friday afternoons showing the highest concentration at 6.1K orders.</li><li><strong>Pizza Size Popularity</strong>: Large size leads with 18.96K orders (38.24%), Medium at 15.64K (31.54%), Small at 14.40K (29.02%). XL and XXL sizes combined contribute less than 2% of sales, suggesting limited demand for extra-large sizes.</li></ol><figure><img alt="" src="https://cdn-images-1.medium.com/max/1024/1*XKB93zQW9FjVEskelxft0g.png" /><figcaption>Dashboard 2</figcaption></figure><h3>Insights</h3><ul><li>Afternoon and evening are peak sales periods, aligning with typical meal times and customer availability.</li><li>Weekdays account for 73% of total orders, indicating a strong demand during workdays.</li><li>Large pizzas are most preferred, followed by medium and small, suggesting value perception in size.</li><li>Veggie pizzas generate the highest revenue despite fewer types, pointing to a lucrative niche market.</li><li>Most customers order only one pizza per transaction, highlighting an opportunity to increase average order size.</li><li>Thai Chicken and Classic Deluxe pizzas are consistently top performers, underscoring their market appeal.</li></ul><h3>Recommendations</h3><ul><li>Increase inventory and staffing during peak hours (12 PM–2 PM and 5 PM–6 PM) to meet demand efficiently.</li><li>Promote combo deals and upselling strategies to encourage multiple quantity purchases and increase revenue.</li><li>Expand Veggie pizza offerings to capitalise on high revenue and growing vegetarian customer base.</li><li>Introduce loyalty programs targeting weekday customers to enhance retention and repeat business.</li><li>Optimise pricing and marketing for XL and XXL sizes to improve uptake and profitability.</li></ul><h3>Conclusion</h3><p>The Emmy’s Pizza dashboard provides a robust foundation for strategic decision-making. By leveraging detailed data insights and analytical rigour, the business can enhance customer satisfaction, streamline operations, and boost profitability. Continued monitoring and refinement of the dashboard will ensure sustained growth and responsiveness to evolving market trends.</p><img src="https://medium.com/_/stat?event=post.clientViewed&referrerSource=full_rss&postId=44da078cb075" width="1" height="1" alt="">]]></content:encoded>
        </item>
        <item>
            <title><![CDATA[Workforce Dynamics Unveiled: A Power BI HR Attrition Report]]></title>
            <link>https://medium.com/@oceanemm18/workforce-dynamics-unveiled-a-power-bi-hr-attrition-report-39a09b2c8f94?source=rss-1bab71344ddb------2</link>
            <guid isPermaLink="false">https://medium.com/p/39a09b2c8f94</guid>
            <category><![CDATA[analytics]]></category>
            <category><![CDATA[human-resources]]></category>
            <category><![CDATA[employee-attrition]]></category>
            <category><![CDATA[data-analysis]]></category>
            <dc:creator><![CDATA[Emmanuel Olukanni]]></dc:creator>
            <pubDate>Mon, 08 Dec 2025 14:28:53 GMT</pubDate>
            <atom:updated>2025-12-08T14:28:53.804Z</atom:updated>
            <content:encoded><![CDATA[<figure><img alt="" src="https://cdn-images-1.medium.com/max/1024/1*AmGBr2HsBl5AKZ0Zk0WqQg.jpeg" /><figcaption><a href="https://cultivateadvisors.com/blog/calculating-and-improving-employee-attrition-rate-a-guide/">https://cultivateadvisors.com/blog/calculating-and-improving-employee-attrition-rate-a-guide/</a></figcaption></figure><h3><strong>Introduction</strong></h3><p>The HR Attrition Report project was developed using Power BI to provide a comprehensive overview of employee-related metrics within an organisation. This dashboard serves as a strategic tool for HR professionals and management to monitor workforce dynamics, identify trends in attrition and promotion, and make data-driven decisions to improve employee retention and organisational efficiency.</p><h3><strong>Executive Summary</strong></h3><p>This project visualises key HR metrics such as employee demographics, job levels, income distribution, promotion eligibility, retrenchment rates, and departmental breakdowns. By leveraging Power BI’s interactive capabilities, the report enables stakeholders to filter data by gender and job level, uncovering granular insights into workforce composition and attrition patterns. The dashboard highlights areas of concern, such as departments with high retrenchment rates and roles with low promotion frequency, guiding targeted interventions.</p><h3><strong>Objectives</strong></h3><ol><li>To analyse employee attrition and promotion trends across departments and job roles.</li><li>To visualise workforce demographics, including gender, marital status, and job levels.</li><li>To identify departments and roles with high retrenchment or promotion rates.</li><li>To support HR decision-making with actionable insights.</li><li>To present data in an interactive and user-friendly format using Power BI.</li></ol><h3><strong>Work Done</strong></h3><p>ü Collected and cleaned HR data, including employee demographics, job roles, income, and status.</p><p>ü Designed a Power BI dashboard with slicers for gender and job level.</p><p>ü Created visualisations including bar charts, pie charts, doughnut charts, and tables.</p><p>ü Integrated metrics such as total employees, average monthly pay, and total pay.</p><p>ü Developed departmental breakdowns for promotion and retrenchment.</p><p>ü Highlighted high and low attrition rates across roles and departments.</p><h3><strong>Calculations</strong></h3><ul><li><strong>Total Employees</strong>: 1,470 employee records analysed.</li><li><strong>Gender Distribution</strong>: 882 males (60%) and 588 females (40%).</li><li><strong>Average Monthly Pay</strong>: Total pay of approximately 9.6 million divided by total employees, averaging about $6,530 per month.</li><li><strong>Promotion Eligibility</strong>: 72 employees (4.9%) are due for promotion, while 1,398 (95.1%) are not.</li><li><strong>Attrition Status</strong>: 117 employees (8%) have been retrenched, with 1,353 (92%) still in service.</li><li><strong>Distance Status</strong>: 940 employees are categorised as very close, 301 as close, and the remainder as far.</li><li><strong>Marital Status</strong>: 673 married (45.78%), 470 single (31.97%), and 327 divorced (22.24%).</li><li><strong>Overtime Status</strong>: 416 employees (28.3%) work overtime, while 1,054 (71.7%) do not.</li><li><strong>High vs Low Rate</strong>: 226 employees (15.4%) fall under high rate categories, with 1,244 (84.6%) in low rate categories.</li></ul><h3><strong>Power BI</strong></h3><p>Power BI was chosen for its robust data visualisation and interactive dashboard capabilities. Key features utilised include:</p><ul><li>Slicers for dynamic filtering by gender and job level, enabling users to drill down into specific workforce segments.</li><li>Drill-down functionality allows detailed departmental and role-based analysis.</li><li>Custom visuals such as doughnut charts representing overtime status, with 28.3% of employees working overtime.</li><li>Bar graphs illustrating promotion and retrenchment counts, for example, the Research &amp; Development department showing 74 retrenchments and 47 promotions.</li><li>Tables detailing job roles with corresponding retrenchment and promotion figures, highlighting managers with 44 retrenchments out of 102 employees.</li><li>Data modelling to calculate derived metrics, including average pay and attrition rates.</li><li>Navigation buttons for a seamless user experience.</li></ul><h3><strong>Data Visualisation</strong></h3><figure><img alt="" src="https://cdn-images-1.medium.com/max/1024/1*3sEujPniiANgklHrYEFTZg.png" /></figure><figure><img alt="" src="https://cdn-images-1.medium.com/max/1024/1*76NgqE604PbPvlUNVTsp8g.png" /></figure><p>a. Promotion counts by department: Research &amp; Development leads with 47 promotions, followed by Sales with 23, while Human Resources has the lowest promotion count.</p><p>b. Retrenchment counts by department: Research &amp; Development has the highest retrenchment at 74 employees, Sales follows with 36, and Human Resources reports the lowest retrenchment.</p><p>c. Gender-based income distribution: Males constitute 60% of employees with an average monthly pay of approximately $6,500, while females make up 40%.</p><p>d. Marital status distribution: Married employees represent 45.78% (673 individuals), singles 31.97% (470), and divorced 22.24% (327).</p><p>e. Overtime status: 416 employees (28.3%) work overtime, while 1,054 (71.7%) do not.</p><p>f. Job roles retrenchment and promotion: Managers have a high retrenchment count of 44 out of 102 total managers, indicating significant turnover. Healthcare Representatives and Sales Executives show moderate promotion eligibility with relatively low retrenchment.</p><p>g. Summary cards highlight total employees at 1,470, total pay of $9.6 million, and gender distribution with 60% male and 40% female.</p><h3><strong>Insights</strong></h3><ol><li>The Research &amp; Development department has the highest retrenchment count at 74 employees and promotion count at 47.</li><li>The sales department follows with 36 retrenchments and 23 promotions.</li><li>Human Resources department records the lowest retrenchment and promotion figures.</li><li>Managers exhibit a high retrenchment rate, with 44 out of 102 employees retrenched, suggesting leadership turnover.</li><li>Healthcare Representatives and Sales Executives show relatively low retrenchment but moderate promotion eligibility.</li><li>The majority of employees are married (45.78%), and most do not work overtime (71.7%).</li></ol><h3><strong>Recommendations</strong></h3><ol><li>Investigate the underlying causes of high retrenchment in Research &amp; Development and managerial roles.</li><li>Develop targeted retention programs for departments exhibiting high attrition rates.</li><li>Review and adjust promotion policies to ensure equitable career progression opportunities.</li><li>Consider employee engagement strategies tailored for married staff and those not working overtime.</li><li>Utilise dashboard insights to inform strategic workforce planning and HR initiatives.</li></ol><h3><strong>Conclusion</strong></h3><p>The HR Attrition Report built with Power BI provides a powerful lens into the organisation’s workforce dynamics. Through interactive visualisations and detailed metrics, it enables HR teams to proactively address attrition challenges, optimise promotion pathways, and enhance overall employee satisfaction. This project exemplifies the value of data-driven HR management in fostering a resilient and productive workforce.</p><img src="https://medium.com/_/stat?event=post.clientViewed&referrerSource=full_rss&postId=39a09b2c8f94" width="1" height="1" alt="">]]></content:encoded>
        </item>
        <item>
            <title><![CDATA[“Beyond Numbers: Strategic Insights from Splendor Investment Dashboards”]]></title>
            <link>https://medium.com/@oceanemm18/beyond-numbers-strategic-insights-from-splendor-investment-dashboards-b91aa78dba2c?source=rss-1bab71344ddb------2</link>
            <guid isPermaLink="false">https://medium.com/p/b91aa78dba2c</guid>
            <category><![CDATA[investment]]></category>
            <category><![CDATA[data-analysis]]></category>
            <category><![CDATA[employee-benefits]]></category>
            <category><![CDATA[employee-attrition]]></category>
            <category><![CDATA[employee-retention]]></category>
            <dc:creator><![CDATA[Emmanuel Olukanni]]></dc:creator>
            <pubDate>Thu, 04 Dec 2025 20:12:55 GMT</pubDate>
            <atom:updated>2025-12-04T20:12:55.761Z</atom:updated>
            <content:encoded><![CDATA[<p><em>Turning workforce data into smarter business decisions</em></p><figure><img alt="" src="https://cdn-images-1.medium.com/max/612/1*7DW6z4p3fOcd459fBZESdQ.jpeg" /><figcaption>Creator: Sakorn Sukkasemsakorn | Credit: Getty Images/iStockphoto</figcaption></figure><h3>Introduction</h3><p>This project’s main aim was to analyse employee data at Splendor Investments. In this project, you will work with a comprehensive dataset containing detailed information about employees within the company.</p><p>The task is to leverage SQL to explore and analyse the dataset, extracting valuable insights to aid in understanding the company’s workforce better.</p><h3><strong>Executive Summary</strong></h3><p>The <strong>Splendor Investment Report</strong> provides a comprehensive analysis of workforce demographics, compensation structures, and organisational performance across departments and business units. Drawing from detailed dashboards, the report highlights key trends in employee attrition, bonus distribution, salary progression, and workforce diversity.</p><p>Findings reveal notable disparities in departmental bonuses, early-career attrition challenges, and equity gaps in compensation across ethnic groups. Additionally, the data underscores the concentration of pay within specific business units and the ageing workforce in certain geographic regions.</p><p>This documentation translates these insights into actionable recommendations — ranging from strengthening onboarding programs and revising bonus structures to implementing succession planning and equity audits. Together, these strategies aim to enhance employee retention, foster inclusivity, and align compensation with organisational value creation.</p><h3>Project Objectives</h3><ol><li>Analyse employee data using SQL to uncover insights.</li><li>Transform the insights into meaningful KPIs.</li><li>Create an interactive dashboard to visualise the KPIs.</li></ol><h3>Processes</h3><p>The data was processed through a series of steps to ensure its successful completion, such as:</p><p><strong>Data Extraction and Query:</strong></p><ul><li>Computed averages and percentages for key indicators:</li><li><strong>Average bonus</strong> by department, age group, and ethnicity.</li><li><strong>Attrition rates</strong> (e.g., number of employees gone, tenure before exit).</li><li><strong>Salary trends</strong> across years and job titles.</li><li><strong>Business unit pay distribution</strong> in millions.</li><li>Identified <strong>outliers</strong> (e.g., top 5 earners, highest/lowest salaries)</li></ul><p><strong>Questions Answered:</strong></p><p>1. How many employees are there in each department?</p><p>2 . What is the average age of employees in the Sales department?</p><p>3. Who are the top 5 highest-paid employees in the company?</p><p>4. What is the distribution of employees across different genders and ethnicities?</p><p>5 . How has the average salary changed over the years?</p><p>6. Which department has the highest average bonus percentage?</p><p>7. Identify employees who exited the company within their first year.</p><p>8. Calculate the total annual salary expenditure for each business unit.</p><p>9. What is the average age of employees in each city?</p><p>10. Determine the average salary for each job title.</p><p>11. Compare the average bonus percentage between different departments.</p><p>12. How many employees have left the company, and what is their average tenure?</p><p>13. Identify employees who have been with the company for more than 10 years.</p><p>14 . Calculate the average bonus percentage for employees under the age of 30.</p><p>15. Compare the distribution of bonus percentages across different ethnicities.</p><p>Query:</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/1024/1*IedT_y7qq46rYd-3s3La4w.png" /><figcaption>Questions 1 to 5</figcaption></figure><figure><img alt="" src="https://cdn-images-1.medium.com/max/1024/1*NlvcvD1Gqy3QE9gC1_80AA.png" /><figcaption>Questions 6 to 10</figcaption></figure><figure><img alt="" src="https://cdn-images-1.medium.com/max/998/1*NSM1DVaVcwFS4OgxmvfABw.png" /><figcaption>Questions 10 to 15</figcaption></figure><p><strong>Data Visualisation &amp; Transformation:</strong></p><ul><li>Built interactive dashboards to display:</li><li>Departmental bonus comparisons.</li><li>Salary trends over time.</li><li>Workforce demographics (gender, ethnicity, city).</li><li>Attrition and tenure statistics.</li><li>Used charts, tables, and KPIs to highlight disparities and trends for easy interpretation.</li></ul><figure><img alt="" src="https://cdn-images-1.medium.com/max/1024/1*NAPklBnu2anSkUAdH2RG4w.png" /><figcaption>Dashboard 1</figcaption></figure><figure><img alt="" src="https://cdn-images-1.medium.com/max/1024/1*B-pVuzsZ5ixSk7D3pVAs5A.png" /><figcaption>Dashboard 2</figcaption></figure><p><strong>Insight Extraction</strong></p><ul><li>Analysed dashboards to identify <strong>patterns and anomalies</strong>:</li><li>Low bonuses in technical departments.</li><li>High attrition in early tenure.</li><li>Equity gaps in bonus distribution.</li><li>An ageing workforce in certain cities.</li><li>Concentration of pay in specific business units.</li><li>Compared metrics across categories to uncover <strong>strategic implications</strong>.</li></ul><p><strong>Recommendation Development</strong></p><ul><li>Translated insights into <strong>actionable strategies</strong>:</li><li>Adjust bonus structures for fairness and competitiveness.</li><li>Strengthen onboarding to reduce first-year exits.</li><li>Implement diversity and equity audits.</li><li>Plan succession strategies in ageing workforce regions.</li><li>Align compensation with business unit ROI.</li></ul><p><strong>Reporting/Presentation</strong></p><p>We created a presentation report, using Canva and Microsoft PowerPoint.</p><h3><strong>Insights:</strong></h3><p>The Splendor Investment Report highlights several interconnected workforce and compensation challenges. Attrition remains a pressing issue, with <strong>103 employees leaving overall and 33 exiting within their first year</strong>, suggesting gaps in onboarding and early engagement. At the same time, <strong>bonus disparities across departments</strong> are evident-technical teams like Engineering (5.87%) and IT (4.25%) receive significantly lower bonuses compared to Accounting (11.83%) and HR (11.48%), which may hinder retention of critical talent.</p><p>Equity concerns also emerge in compensation distribution, with <strong>Black employees receiving lower average bonuses (36%) compared to other ethnic groups (40%)</strong>, pointing to the need for fairer performance evaluation systems. Salary analysis shows clustering among top earners (~$258K) and concentration of pay within <strong>Speciality Products ($29.26M) and Corporate ($28.83M)</strong> units, raising questions about whether compensation aligns with strategic value creation.</p><p>Finally, demographic data reveals an <strong>ageing workforce in cities like Sao Paulo and Chongqing (avg. age 46)</strong>, while long-term employee retention is low (only 15 staff with over 10 years of service). Together, these insights underscore the importance of <strong>strengthening onboarding, revising bonus structures, implementing diversity audits, succession planning, and aligning pay with business outcomes</strong> to build a more resilient and equitable organisation.</p><h3><strong>Recommendations:</strong></h3><p>The Splendor Investment Report highlights several areas where strategic action can significantly improve workforce stability, equity, and organisational performance. To address high attrition-particularly the <strong>33 employees who exited within their first year-</strong>the company should invest in <strong>robust onboarding programs, mentorship initiatives, and structured early engagement activities</strong>. These measures will help new hires integrate more effectively and reduce early turnover.</p><p>Compensation structures require rebalancing, as <strong>technical departments such as Engineering and IT receive substantially lower bonuses</strong> compared to Accounting and HR. Revising bonus policies to ensure fair recognition of technical contributions will strengthen retention of critical talent. At the same time, <strong>diversity and equity audits</strong> should be conducted regularly to identify and correct disparities, such as the lower average bonuses received by Black employees. Transparent performance evaluation frameworks will ensure that rewards are distributed equitably across all groups.</p><p>Demographic analysis reveals an <strong>ageing workforce in cities like Sao Paulo and Chongqing</strong>, underscoring the need for <strong>succession planning and knowledge transfer programs</strong>. Preparing future leaders and capturing institutional expertise before retirements occur will safeguard operational continuity.</p><p>Finally, compensation distribution shows a heavy concentration in <strong>Speciality Products and Corporate units</strong>, raising questions about alignment with strategic value. A thorough <strong>ROI evaluation of business units</strong> should be conducted to ensure pay structures reflect actual performance outcomes. Differentiating compensation among top earners will also help reward exceptional contributions and prevent stagnation.</p><p>Together, these recommendations form a comprehensive roadmap: <strong>reduce attrition, rebalance incentives, promote equity, prepare for workforce transitions, and align pay with business value.</strong> Implementing these strategies will create a fairer, more competitive, and future-ready organisation.</p><h3><strong>Conclusion</strong></h3><p>The Splendor Investment Report provides a clear view of workforce dynamics, compensation structures, and organisational challenges. By analysing attrition patterns, bonus disparities, equity gaps, and demographic trends, the dashboards highlight areas requiring immediate attention and long-term planning. Implementing the recommended strategies-strengthening onboarding, rebalancing incentives, promoting diversity, preparing for succession, and aligning pay with business value-will not only improve employee retention and satisfaction but also enhance organisational resilience and performance. Ultimately, these insights serve as a roadmap for building a fair, competitive, and future-ready workforce.</p><img src="https://medium.com/_/stat?event=post.clientViewed&referrerSource=full_rss&postId=b91aa78dba2c" width="1" height="1" alt="">]]></content:encoded>
        </item>
        <item>
            <title><![CDATA[From Barrels to Billions: Unlocking Brewery Market Potential]]></title>
            <link>https://medium.com/@oceanemm18/from-barrels-to-billions-unlocking-brewery-market-potential-38dea5651531?source=rss-1bab71344ddb------2</link>
            <guid isPermaLink="false">https://medium.com/p/38dea5651531</guid>
            <category><![CDATA[marketing]]></category>
            <category><![CDATA[brewery]]></category>
            <category><![CDATA[sales]]></category>
            <category><![CDATA[brands]]></category>
            <category><![CDATA[data-analysis]]></category>
            <dc:creator><![CDATA[Emmanuel Olukanni]]></dc:creator>
            <pubDate>Thu, 04 Dec 2025 18:30:38 GMT</pubDate>
            <atom:updated>2025-12-04T18:30:38.526Z</atom:updated>
            <content:encoded><![CDATA[<figure><img alt="" src="https://cdn-images-1.medium.com/max/612/1*aMxW8z-FHUd6yqlMNQ-HQQ.jpeg" /><figcaption>Creator: cagkansayin | Credit: Getty Images/iStockphoto</figcaption></figure><h3>Introduction</h3><p>The main aim of this project was to analyse the Int. Breweries (Hypothetical) dataset, focusing on profit maximisation and key sales indices.</p><p>The task is to leverage SQL to explore and analyse the dataset, extracting valuable insights to aid in understanding the company’s profit generation across both Anglophone and Francophone countries.</p><h3>Executive Summary -Brewery Market Analysis</h3><p>This project provides a comprehensive analysis of brewery performance across multiple regions, highlighting consumption trends, brand preferences, and profitability patterns. The dashboards reveal that Senegal is a dominant market, with the highest beer consumption ($130K) and malt consumption (51k), underscoring its potential as a key growth driver. Francophone countries collectively contribute 60% of total profits, significantly outperforming Anglophone regions, which points to stronger cultural resonance and operational efficiency in these territories. Hero and Eagle Lager consistently rank among the top‑selling brands across several years and regions, demonstrating enduring consumer loyalty and brand strength. At the same time, Beta Malt has emerged as a competitive non‑alcoholic alternative, rivalling beer brands in Ghana and ranking among the highest‑selling products in 2019.</p><p>The findings emphasise the need for breweries to align their strategies with regional demand and consumer preferences. By deepening market penetration in Senegal, prioritising investment in Francophone territories, scaling up production and promotional efforts for Hero and Eagle Lager, and expanding malt offerings to target health‑conscious consumers, breweries can maximise both sales generation and long‑term profitability. These insights provide a roadmap for sustainable growth, ensuring that resources are directed toward high‑value markets, proven product lines, and emerging consumer trends.</p><h3>Project Objectives</h3><p>The primary objectives of this project were to:</p><p>A. Analyse the Int.B dataset to key insights;</p><p>B. Transform the insights into meaningful KPIs;</p><p>C. Create an interactive dashboard to visualise the KPIs.</p><h3>Processes</h3><ol><li>Data Extraction/Query;</li></ol><p><strong>Analysis $ Queries</strong></p><p><strong>Profit Analysis:</strong></p><p>1. Within the space of the last three years, what was the profit</p><p>worth of the breweries, inclusive of the anglophone and the</p><p>francophone territories?</p><p>2. Compare the total profit between these two territories for the territory manager, Mr. Stone make a strategic decision that will aid profit maximisation in 2020.</p><p>3. Country that generated the highest profit in 2019</p><p>4. Help him find the year with the highest profit.</p><p>5. What was the minimum profit in the month of December 2018?</p><p><strong>Query:</strong></p><figure><img alt="" src="https://cdn-images-1.medium.com/max/993/1*lrRseNwn_lURKuIHwHMJEg.png" /><figcaption>Profit Analysis Query</figcaption></figure><p>Brand Analysis</p><p>1. Within the last two years, the brand manager wants to</p><p>know the top three brands consumed in the francophone</p><p>countries 2. Find out the top two choices of consumer brands in Ghana</p><p>3. Favourite malt brand in the Anglophone region between 2018</p><p>and 2019</p><p>4. Which brands sold the highest in 2019 in Nigeria?</p><p>5. Beer consumption in Nigeria</p><p><strong>Query:</strong></p><figure><img alt="" src="https://cdn-images-1.medium.com/max/781/1*tQKUw7bYXAXP955ZO0UwSQ.png" /><figcaption>Brand Analysis Query</figcaption></figure><p><strong>Country Analysis:</strong></p><p>1. Country with the highest consumption of beer.</p><p>2. Country with the highest consumption of malt.</p><p>Query:</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/585/1*BeKDS2sL4ETtMXnwpKK_Kw.png" /><figcaption>Country Analysis Query</figcaption></figure><p>2. Data Visualisation &amp; Transformation;</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/1024/1*G7fhdT4CDOz0--3547LEDg.png" /><figcaption>Int.B. Sales Analysis Across Countries and Regions Dashboard 1</figcaption></figure><p>We developed interactive dashboards to visualise key metrics and trends in sales and profit generation across countries and regions (Anglophone and Francophone).</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/1024/1*4FLNv2s3mxxNqodWlfovag.png" /><figcaption>Int.B. Sales Analysis Across Countries and Regions Dashboard 2</figcaption></figure><p><strong>Slicers</strong>:</p><p>The utilisation of slicers in this report significantly enhances its interactivity, allowing us to filter and analyse data with greater precision.</p><p>3. Reporting/Presentation;</p><p><strong>Insights</strong></p><p>The analysis of brewery performance across multiple regions reveals clear consumption and profitability patterns that highlight opportunities for growth. Senegal emerges as a dominant market, recording the highest beer consumption at $130K and malt consumption at 51K, underscoring its strong demand for both alcoholic and non‑alcoholic beverages. Francophone countries collectively contribute 60% of total profits, significantly outperforming Anglophone regions, which suggests that cultural preferences, distribution efficiency, and consumer loyalty in Francophone territories are driving higher margins. Within brand performance, Hero and Eagle Lager consistently rank among the top‑selling products across several years and regions, demonstrating their strong consumer appeal and resilience in competitive markets. These findings point to the importance of focusing on high‑demand regions and leveraging proven brand loyalty to sustain profitability.</p><p>In addition to beer, malt products are showing competitive strength, particularly Beta Malt, which rivals beer brands in Ghana with 25k sales and ranks among the highest‑selling brands in 2019. This trend highlights the growing demand for non‑alcoholic alternatives, especially among health‑conscious consumers and diverse demographic groups. The dashboards also reveal that overall profitability has been robust, with $105.59Million generated in the last three years, though fluctuations such as the minimum profit of $38K in December 2018 indicate the need for stronger seasonal strategies. Taken together, these insights emphasise the importance of expanding malt offerings, scaling up production and promotional efforts for leading beer brands, and prioritising investment in Francophone markets. By aligning product diversification with regional demand and consumer preferences, breweries can maximise both sales generation and long‑term profit growth.</p><p><strong>Recommendations</strong></p><p>The analysis highlights four core strategies for driving growth and profitability. First, breweries should <strong>deepen market penetration in Senegal</strong>, leveraging its strong demand for both beer and malt by expanding distribution networks, introducing premium variants, and tailoring localised campaigns. Second, with <strong>Francophone countries contributing 60% of total profits</strong>, investment should be prioritised in these territories through supply chain optimisation, culturally aligned marketing, and strengthened local partnerships.</p><p>Third, the consistent popularity of <strong>Hero and Eagle Lager</strong> calls for scaling up production and promotional efforts, supported by loyalty programs, seasonal campaigns, and digital marketing initiatives to reinforce consumer loyalty. Finally, the rising success of <strong>Beta Malt</strong> demonstrates the importance of diversifying into non‑alcoholic alternatives. Expanding malt product lines, emphasising health benefits, and cross‑promoting with beer brands will capture health‑conscious consumers and broaden market reach. Together, these recommendations provide a roadmap for sustainable sales growth and long‑term profit maximisation.</p><h3><strong>Conclusion</strong></h3><p>This project demonstrates that the brewery industry’s path to growth lies in <strong>strategic focus, regional prioritisation, and product diversification</strong>. By capitalising on Senegal’s booming demand, leveraging the profitability of Francophone markets, scaling up proven winners like Hero and Eagle Lager, and expanding malt offerings to meet evolving consumer preferences, breweries can unlock new levels of performance.</p><p>Ultimately, the data tells a clear story: <strong>success is brewed where insight meets action</strong>. With the right mix of market penetration, brand loyalty, and innovation, breweries are positioned not just to maximise profits today, but to build a sustainable foundation for tomorrow’s competitive landscape.</p><h3><strong>Legal Disclaimer</strong></h3><p>The data, figures, and insights presented in this project are <strong>purely hypothetical</strong> and created solely for <strong>educational and illustrative purposes</strong>. They do not represent, reflect, or derive from any actual operational, financial, or market data of International Breweries or any of its affiliates. This documentation has no direct or implied connection to the real International Breweries company, its subsidiaries, or its official reports. <strong>Any resemblance to actual data, strategies, or outcomes is entirely coincidental.</strong></p><img src="https://medium.com/_/stat?event=post.clientViewed&referrerSource=full_rss&postId=38dea5651531" width="1" height="1" alt="">]]></content:encoded>
        </item>
        <item>
            <title><![CDATA[Driving Growth: Understanding Customer Patterns & Improving Operations Using Microsoft Excel]]></title>
            <link>https://medium.com/@oceanemm18/driving-growth-understanding-customer-patterns-improving-operations-using-microsoft-excel-1ede21bc7bf1?source=rss-1bab71344ddb------2</link>
            <guid isPermaLink="false">https://medium.com/p/1ede21bc7bf1</guid>
            <category><![CDATA[data-visualization]]></category>
            <category><![CDATA[data-manipulation]]></category>
            <category><![CDATA[data-modeling]]></category>
            <category><![CDATA[big-data-analytics]]></category>
            <category><![CDATA[data-analysis]]></category>
            <dc:creator><![CDATA[Emmanuel Olukanni]]></dc:creator>
            <pubDate>Thu, 02 Oct 2025 23:30:57 GMT</pubDate>
            <atom:updated>2025-10-02T23:34:56.479Z</atom:updated>
            <content:encoded><![CDATA[<figure><img alt="" src="https://cdn-images-1.medium.com/max/1024/0*FdkPdsZOJmgDv90s" /><figcaption>Photo by <a href="https://unsplash.com/@blakewisz?utm_source=medium&amp;utm_medium=referral">Blake Wisz</a> on <a href="https://unsplash.com/?utm_source=medium&amp;utm_medium=referral">Unsplash</a></figcaption></figure><h3>Introduction</h3><p>Over the past few weeks, I have embarked on an exciting journey into the world of Data Analysis, with Microsoft Excel as my first major tool. What started as a simple exercise in entering numbers into a spreadsheet has now evolved into a solid foundation in handling, analysing, and visualising data. This journey has not only improved my technical skills but also reshaped the way I approach data-driven problem-solving.</p><p>As challenging as this journey has been, one thing is certain for me: you will see more of my work here in the coming weeks. So, let’s take a deep dive into my first analytical project together.</p><h3>Project Objectives</h3><p>The primary objectives of this project were to:</p><p>a. Create and consolidate data from various worksheets</p><p>b. Compute essential metrics, including balance and rewards</p><p>c. Develop an interactive dashboard to visualise customer information.</p><h3>Work-Done</h3><p><strong>Data Cleaning</strong></p><p>a. We converted the range into tables to facilitate easier data formatting and manipulation</p><p>b. We also remove duplicate data within the tables.</p><p>c. Additionally, I standardise data formats and structures using data transformation techniques.</p><p><strong>Before</strong></p><figure><img alt="" src="https://cdn-images-1.medium.com/max/1024/1*yb39TKm2I5Zuc0r3DIHWrA.png" /><figcaption>Raw Data</figcaption></figure><p><strong>After</strong></p><figure><img alt="" src="https://cdn-images-1.medium.com/max/1024/1*pasd7MSr17aZIBYknewwQQ.png" /><figcaption>Clean Data</figcaption></figure><p>d. We discovered a text that could not be recognised or removed through standard data formatting techniques. To address this issue, we utilised the combination of the TRIM, CLEAN, and SUBSTITUTE functions, specifically targeting text identified as CHAR160.</p><p>e. Additionally, we identified the presence of blank spaces within a large dataset. To effectively highlight these blank spaces, we implemented conditional formatting, applying a rule that marked them in red for easy identification. This approach enabled us to analyse the dataset more thoroughly and address any inconsistencies.</p><p><strong>Data Manipulation</strong></p><p>We started by duplicating the Customer worksheet and renaming it to “All_customer_details.” Then, we used VLOOKUP to add columns from other worksheets:</p><p>a. *Account type* and *Opening balance* from Accounts worksheet</p><p>b. *Loan* from the Loan worksheet (for customers who took a loan)</p><p>c. *Transaction_date*, *Transaction type*, and *Transaction medium* from Transaction worksheet.</p><p><strong>Calculation</strong></p><p>We conducted an analysis to quantify the disparity between Current_deposit and Saving_deposit, creating a new column titled “Balance” to illustrate this difference. Furthermore, we implemented a promotional incentive, granting customers a 2% increase on balances exceeding #500,000 in their current accounts.</p><h3>Data Modelling</h3><figure><img alt="" src="https://cdn-images-1.medium.com/max/906/1*1Iul-p_l6cs8Zx9D8H74tg.png" /><figcaption>Data Modelling</figcaption></figure><p>In our analysis, we identified that effective data modelling is essential due to the inherent complexity of managing multiple tables within a database. This process entails not only organising and structuring the data but also establishing clear relationships among the various tables. By systematically defining these relationships, we enhance data integrity and streamline data retrieval processes, ultimately leading to more efficient data management and analysis.</p><h3>Power Pivot</h3><p>We leveraged Power Pivot, an advanced feature in Excel, to conduct a thorough analysis of the cleaned data by constructing a sophisticated data model and establishing relationships between various tables. This approach enabled us to systematically explore patterns in customer behaviour and account activity, providing deeper insights into trends and correlations that inform strategic decision-making. By integrating and analysing multiple data sources, we could identify key drivers of customer engagement and account performance, ultimately enhancing our understanding of user dynamics and potential areas for optimisation.</p><p><strong>Pivot Tables</strong></p><figure><img alt="" src="https://cdn-images-1.medium.com/max/1024/1*wJqhd9RS8G-Q2OxLmojRMA.png" /><figcaption>Pivot Tables</figcaption></figure><p>In our analysis, we employed pivot tables to emphasise the Key Performance Indicators (KPIs) and the corresponding visual representations. By leveraging pivot tables, we were able to facilitate a comprehensive data visualisation of the data, presenting it through various formats such as charts, bar graphs, pie charts, and scatter plots.</p><p>This approach not only assists in identifying trends and patterns within the data but also enhances the interpretability of the KPIs. The visualisations serve as effective tools for stakeholders to quickly grasp complex information, enabling informed decision-making based on clear, data-driven insights. Furthermore, the dynamic nature of pivot tables allows for real-time adjustments, ensuring that our visual representations remain relevant and accurate as new data emerges. Overall, this methodology enhances our analytical capabilities and provides a robust framework for assessing performance metrics.</p><h3>Data Visualization</h3><figure><img alt="" src="https://cdn-images-1.medium.com/max/1024/1*KC2jviVWVXH59CQoP2IgEQ.png" /><figcaption>Dashboard 1</figcaption></figure><figure><img alt="" src="https://cdn-images-1.medium.com/max/1024/1*owfRLWRJ7LtsRTabyxnKjw.png" /><figcaption>Dashboard 2</figcaption></figure><p>We developed an interactive dashboard to visualise key metrics and trends in customer data, including:</p><p>a. Distribution of customers by account type</p><p>b. Distribution of loans by customer</p><p>c. Transaction volume by medium</p><p>d. Balance distribution by customer, etc.</p><p><strong>Slicers</strong>:</p><p>The utilisation of slicers in this report significantly enhances its interactivity, allowing us to filter and analyse data with greater precision.</p><h3>Insights</h3><p>Through this project, we gained valuable insights into customer behaviour and account activity. Key findings include:</p><p><strong>Domiciliary Domination:</strong></p><p>The analysis provides a detailed overview of account types and the corresponding loan amounts associated with each. Notably, domiciliary account holders comprise a significant majority, with 1,023 accounts. These accounts collectively account for a substantial loan total of ₦337.32 billion. This dominance suggests that domiciliary accounts may be preferred for higher-value loans, possibly due to the benefits they offer in terms of foreign currency transactions. Further investigation could explore the factors driving this trend, as well as the implications for financial institutions catering to this clientele.</p><p><strong>Regional Loan Spread:</strong></p><p>Lagos, with ₦256 billion, leads significantly compared to other states, with Abuja at ₦84 billion and Osun at ₦80 billion, emphasising a strong dependence on commercial centres.</p><p><strong>Transaction trends:</strong></p><p>Most transactions take place through banking channels, underscoring the importance of a robust online banking infrastructure.</p><h3>Recommendations</h3><p>Based on our findings, we recommend the following:</p><p><strong>Enhance Market Penetration:</strong></p><p>Implement focused marketing initiatives in regions such as Kano, Anambra, and Osun, where loan adoption is limited, in order to diversify client base and decrease reliance on major urban centres like Lagos.</p><p><strong>Omni-channel Integration:</strong></p><p>Create a seamless experience across all channels (mobile, online, and in-branch) to ensure customers can switch between platforms effortlessly, enhancing overall satisfaction.</p><p><strong>Enhance Mobile Banking Engagement:</strong></p><p>Encourage the use of mobile banking apps and digital wallets by offering incentives such as referral bonuses, exclusive discounts, and gamified savings challenges. This can reduce foot traffic in branches and promote a more digital-centric banking experience.</p><img src="https://medium.com/_/stat?event=post.clientViewed&referrerSource=full_rss&postId=1ede21bc7bf1" width="1" height="1" alt="">]]></content:encoded>
        </item>
        <item>
            <title><![CDATA[We were blacks.]]></title>
            <link>https://medium.com/@oceanemm18/we-were-blacks-69827bd4b165?source=rss-1bab71344ddb------2</link>
            <guid isPermaLink="false">https://medium.com/p/69827bd4b165</guid>
            <dc:creator><![CDATA[Emmanuel Olukanni]]></dc:creator>
            <pubDate>Sun, 02 Feb 2020 23:49:49 GMT</pubDate>
            <atom:updated>2020-02-02T23:49:49.325Z</atom:updated>
            <content:encoded><![CDATA[<p>We were blacks.</p><p>A pint of dream;</p><p>Some fake fantasies.</p><p>A little dose of ecstacy;</p><p>Spread on a sandwich of feelings.</p><p>Some emotional lullaby.</p><p>A warm hug from Mrs Britswitch;</p><p>A cold cup of stale coffee,</p><p>On a freezing night.</p><p>Little bits of black sores;</p><p>Covered in white flakes.</p><p>A rigid fraying wall;</p><p>A crumbling truck of rotten flesh.</p><p>A low reverberating humm;</p><p>Sickening symphonies from lil fruit flies.</p><p>Old bootstrap Bill is on the match again.</p><p>An urgent shout; a pointy knot.</p><p>A dangling.</p><p>Some jerky kickings;</p><p>Short raspy gasps.</p><p>A heavy breathing;</p><p>A sudden static.</p><p>A &quot;soul&quot; escape...</p><p>It&#39;s time to pick up the shovel again.</p><p>Little Tim, up to the red tower came.</p><p>The smoke never stops,</p><p>We wear our ashes like second skins.</p><p>But Potatoes? Yeah we love Potatoes.</p><img src="https://medium.com/_/stat?event=post.clientViewed&referrerSource=full_rss&postId=69827bd4b165" width="1" height="1" alt="">]]></content:encoded>
        </item>
        <item>
            <title><![CDATA[‘Beware of the Hypocrisy of the King.’]]></title>
            <link>https://medium.com/@oceanemm18/beware-of-the-hypocrisy-of-the-king-175f4beebe77?source=rss-1bab71344ddb------2</link>
            <guid isPermaLink="false">https://medium.com/p/175f4beebe77</guid>
            <dc:creator><![CDATA[Emmanuel Olukanni]]></dc:creator>
            <pubDate>Sun, 02 Feb 2020 20:59:32 GMT</pubDate>
            <atom:updated>2020-02-02T23:43:58.525Z</atom:updated>
            <content:encoded><![CDATA[<p>‘Beware of the Hypocrisy of the King.’</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/665/1*0dAA0PAb6pdTgZlXkZpPFQ.jpeg" /></figure><p>Some hours ago, there was a broadcast of a picture of top Religious leaders in Nigeria protesting, A touch banner with the insignia ‘All live matters’. This is indeed a reaction to the recent case of kidnapping of one of the top members of CAN. This in its actual sense, can be liking to a ‘show in personam’ an overdue exercise in hypocrisy. Our beloved country has been rocked with a series of kidnappings, killings and vendetta between political moguls, that have wrapped around their fingers, the opium glazed nation called Nigeria. Many lives have been lost over the decades due to one terrorist incident or the other, yet nobody came out to lend credence to criticizing the ignominious state of security in the state. Not until ‘one of them’ fell victim, did they decide to come out en mass. And still, the society appraised them.I am not saying the action is not worthy of commendation. It sure is, nevertheless, it goes a long way to show the hypocritical role religion has come to play in our society through the agency of our so called ‘Religious Leader’. Don’t get me wrong. Religion in itself is a worthy course, being the belief in a power or force above and superior to one’s personality. But the ‘people’, who espouse religious virtue seems to have forgotten that the encounter is personal. So, they brainwash the masses through ‘selective orientation’ into thinking Religion can be narrowed down to what ‘my pastor says’. So we worship the robes, the person behind the words, the Religion Powerhouses. Turning them into demi gods. Patterning our lives towards the way they want us to live. Using it as an excuse for our day to day self destruction. ‘cause ‘our pastors say…’ it’s about time we wake up and open our eyes to reality. Even the bible warned of the Hypocrisy of the teachers of the Law.</p><p>To those who only find credence in the bible, this is for you.</p><p>Luke 20:46-47</p><p>46 “Beware of the teachers of the law. They like to walk around in flowing robes and love to be greeted with respect in the marketplaces and have the most important seats in the synagogues and the places of honor at banquets.</p><p>47 They devour widows’ houses and for a show make lengthy prayers. These men will be punished most severely.”</p><p>It is quite evident in modern day realities that religion is indeed a personal encounter as it relates to human lives. It is not for the church to indoctrinate one into a society that claim to know the basis of our existence. It’s for each individual to decipher the universal question of existence by looking into his inner self and evaluating his role as human. If we go doggedly into the night of words emanating from another human and piloting our existence in the same direction without question or subjecting such information to empirical proof or real life circumstances. Then how are we sure such words were not offspring of late night readings from so called inspirational volumes dotted with old candle stains, aconviction bored our of futile efforts in finding meaning into one’s purpose. We need to see the effect of these words if we are to be governed by them. Even the bible says;</p><p>3 Since they did not know the righteousness of God and sought to establish their own, they did not submit to God’s righteousness. (Romans 10-3).</p><p>No wonder the learned Mahatma Gandhi was prompted to make the submission;</p><ul><li>‘I like your Christ, I do not like your Christians. Your Christians are so unlike your Christ.’</li></ul><figure><img alt="" src="https://cdn-images-1.medium.com/max/485/1*iI_eubRcT6gphBswBPV27w.jpeg" /></figure><img src="https://medium.com/_/stat?event=post.clientViewed&referrerSource=full_rss&postId=175f4beebe77" width="1" height="1" alt="">]]></content:encoded>
        </item>
        <item>
            <title><![CDATA[The subtle art of giving zero fucks.]]></title>
            <link>https://medium.com/@oceanemm18/the-subtle-art-of-giving-zero-fucks-6e41a25a66c0?source=rss-1bab71344ddb------2</link>
            <guid isPermaLink="false">https://medium.com/p/6e41a25a66c0</guid>
            <dc:creator><![CDATA[Emmanuel Olukanni]]></dc:creator>
            <pubDate>Sat, 18 Jan 2020 20:25:31 GMT</pubDate>
            <atom:updated>2020-01-18T20:25:31.951Z</atom:updated>
            <content:encoded><![CDATA[<p>•	<strong>Tinderbox ( Roses are dead, love is fake, weddings are basically funerals with cake)</strong><br>I once saw a man; lounged on a balcony.<br>A grunchy little man, like an inception;<br>All confused and a little stupid.<br>Some crunchy saggy pants,<br>Hanging loose on his slender frame.<br>A brief dash, some urgent rustling.<br>A revelation of dried leaves;<br>wrapped in a dirty brown paper.<br>A shivery spark from a tinder box.<br>A long drag, a flayed bottle of whisky.<br>Some impatient gulps; a loud Belch.<br>He then went a’snoring, suddenly, a drop of the neck.<br>“ Life was once my favourite movie”<br>He whispered.<br>“Then I got married”<br>•<br>•	<strong>What’s a ‘mob&#39; to a king.</strong><br>Humans;<br>Mere plastic toys;<br>With synthetic hearts.<br>Always moving, always hurrying.<br>With face plastered to glass screens;<br>...hyperventilating.<br>Like a rising crescendo<br>We race through life,<br>Incepting, hurting,<br>Like wild flowers<br>In a field of tulips.<br>A misplaced lot;<br>Heading for an urgent implosion.<br>•<br>•<strong>	A brief comment about ‘nonsense</strong><br>Maybe out of some silly ignorance<br>I might say I want you,<br>Or maybe, I’m all painted;<br>Splattered on some royal blues<br>With a few dots of reds,<br>Emblazoned on a little wall.<br>A flayed ass wallpaper,<br>Of my favourite scientist,<br>And his wild eye Morty.<br>Getting Raggidi wrecked.<br>Spewing a stream of nonsense,<br>Or what I will call science;<br>‘love is dead<br>The status quo is a’hell of a’sham<br>Normal is basically an anecdote to pain’<br>•<br>•	<strong>You the Man of War.</strong><br>There is a certain stupidity to war<br>A violent escapade, fought with tin men.<br>A few oversized men; dissembling thousands of robots,<br>Over some fall outs, some brief exchange of words;<br>And a steaming cup of black coffee.<br>•<br>•	<strong>Collette (A brief Incest, Some little art)</strong><br>I have written so much about you.<br>That you feel quite like a miraggio;<br>That I’ve created,<br>To give meaning;<br>To my self-destruction.<br>“Now ;<br>When I despair,<br>I no longer expect my end,<br>But some bit of luck;<br>Some commonplace little miracle.<br>Which, like a glittering luck,<br>Will mend again; the necklace of my days.”<br>•<br>•	<strong>A Middle finger for a Royal ‘cunt’</strong><br>To them;<br>She was a sunset,<br>Some flushed oranges, and pastel lilacs.<br>And all the nameless colours,<br>Sex is made from.<br>But if I may have my say;<br>She feels quite’xactly,<br>Like a huge bouquet,<br>Of withering hibiscus.<br>A fish wife, with sticky bangs.<br>•<br>•	<strong>Let us get ‘Riggidi Wrecked’</strong><br>“Should we disco or should we hunt?<br>Should we smoke some Cuban cigars;<br>Over some hot shots of German Vodka.<br>Or should we lie naked,<br> amidst some French satins,<br>While listening to some Spanish acoustics,<br>Over the lingering scent<br> of your Italian cologne.<br>•<br>•	<strong>A simple tale of an awesome fly</strong>.<br>Mine is a wee bit of a grumpy tale.<br>A cacophony of silent screams;<br>An embroidery of old worn fabrics;<br>A simple dash of vanilla cream,<br>on black coffee mugs.<br>Some pretty sunsets;<br>With a hint of mandarin.<br>•</p><img src="https://medium.com/_/stat?event=post.clientViewed&referrerSource=full_rss&postId=6e41a25a66c0" width="1" height="1" alt="">]]></content:encoded>
        </item>
    </channel>
</rss>