My favorite movies are ones where someone turns an adversity or a weakness or a disability or being an outcast into a source of strength. My favorite heroes are the zero to hero ones, the grass to grace ones and the ones who made it in spite of the odds/environment.

One question I didn't ponder about these heroes is - couldn't they have run away from the adversity or the demeaning environment? 

Today I am going to share the other side of my Nigerian coin. The other side of the gloom and doom that's eerily visible in the country.

I think being in this country gives us all the conditions and ingredients needed to be a hero. Whether one is successful or not is a different matter. 

We have all read about how the current most powerful country got that status a grace de World War 2. One of the lowest points for humans on earth, if there was life on Mars, moon and Venus, I think many of the people who put all their energy into making the most of the gloom would have shifted their focus to emigrating to Mars, moon and Venus.

Again, many of us have heard of Carlos Slim and many of the world richest men who got their big lift in life from staying + investing when others couldn't wait to get out. That was how Carlos Slim hit it big, he simply bought at very low prices from those hurrying to get out of Mexico during the lows of 1980s. Just like we are having our own lows right now.

Sometimes, like now, I tell myself that I have more to gain from staying than leaving. Yes, I can't argue away the risks that mount with the insecurity and poor leadership. If the other times don't overwhelm the sometimes, I hope to write novels that will capture life and our daily struggles so that the generations after us will read them to know what life was like for us (same way we read Charles Dickens to know what 19th century England was like, how Mark Twain captured 19th century America and how Molière captured 17th century France). I hope to also find many underpriced assets and investments to own and I hope to be very contented with the Nigeria I am served.

As for the topic of this post, it sure does take a good level of contentment to stay back to tap into the creativity that comes from dancing in the rain, calmly thinking while surrounded by a large conflagration and wealth often comes from tapping into opportunities people are too busy focused on something else to see. Most importantly, happiness comes from within. If you are not happy in the current Nigeria, you most likely won't be happy anywhere. There is always something to complain about in even the heaven to our Nigerian hell - tax, racism, cold, food, neighbours, strict laws and language. You are either a happy person or an unhappy person. Yes, an unhappy person can be temporarily happy -- it's his birthday, he won a lottery, something pleasant just happened to him. Events are always temporary happenings, and if they are the source of one's happiness then that happiness is a short lived one. True happiness comes from within. And I know that I am a happy person.

Are you?

Last month I installed the new Windows 11 on my Dell XPS 15 and it's been all wow. The look and features of Windows 11 are very impressive.

It brings the same beautiful look and slick appearance people always say make Mac a more lovely OS than Windows. 


The taskbar is now different looking in a beautiful way. If you ask me to describe how everything looks like on Windows 11, I can give you a one word answer: Amazing!





You can read up on the Windows 11 and its cool features: https://blogs.windows.com/windowsexperience/2021/06/24/introducing-windows-11/

The one I am most thrilled about is the ability to run Android apps on Windows 11.


 

We are thrilled to announce the launch of UrBizEdge’s Personalized for me, this special pack allows you to pick the topics/areas you want to master in Excel and Power BI to achieve your objectives and aspirations. You will also have a trainer take you through applying these to your reports. Our goal is to help you further develop your skills through a personalized learning experience.

With over 7 years of experience, UrBizEdge thus has a unique perspective on the evolution of jobs, industries, organizations, and skills over time. Today we are expanding our current programs by delivering a personalized, comprehensive, course designed just to fit your evolving business needs. Another key advantage of this special pack is having both consulting and training at the cost of just training. 

How to Get Started?

If interested, take a look through these topics listed below and let us know which ones you want to set up a customized one-on-one class around. 

Based on your selection we will then have the class structured into an appropriate number of days. The price for this premium offering is N50,000/day. For most people, 1 or 2 days cover their unique focus areas. We have had huge success delivering this model for many managers and super busy executives who would rather just have a class structured around their needs and usage scenarios with a very personalized touch.

Modern Excel:

  • New Formulas in Excel
    • XLOOKUP which is the replacement for VLOOKUP, HLOOKUP, and INDEX + MATCH combo
    • UNIQUE to remove duplicates and create dynamic dashboards/reports
    • FILTER to have a dynamic filter and create dependent dropdowns
    • SEQUENCE
    • SORT, SORTBY
    • RANDARRAY
    • LAMBDA
  • Power Query – the ultimate data transformation and cleaning tool in Excel
    • Combining data/reports from multiple sheets super easily
    • Combining data/reports from multiple files super easily
    • Pulling data from multiple sources and cleaning/transforming them
    • Unpivot (a magical data transformation tool)
    • Unrivaled column splitting
      • Split to rows
      • Separate numbers from texts
      • Split by case change
      • Split on every x number of characters
    • AI Insights
      • Text Analytics
      • Vision
      • Azure Machine Learning
    • Groupby (SQL type action)
    • Append Queries
    • Merge Queries
      • Standard Merge
      • Fuzzy Match to handle inconsistent spellings
  • Power Pivot
    • Handling data of more than 1.05 million rows
    • Data Modeling (creating relationships between datasets and more)
    • DAX formulas
    • Integrating with Pivot Table
  • Deep Dive into Pivot Table and Pivot Charts
    • Using Pivot Table to create very interactive dashboards
    • Slicers and Timelines
  • Data visualization and Charts
    • Understanding all the new 18 charts in Microsoft Excel
    • Combo chart
    • Sparklines
    • Conditional formatting as a visual
    • Icons and smart arts (infographics)
  • Formulas Deep Dive
    • IF, AND, OR, IFS, SWITCH, XOR
    • SUMIFS, COUNTIFS with wildcards (especially * and ?)
    • ISNA, ISERROR, ISBLANK, ISLOGICAL, ISFORMULA, ISREF, ISTEXT, ISNUMBER
    • VLOOKUP, HLOOKUP, INDEX + MATCH combo
    • EDATE, EOMONTH, TODAY, NOW, DATE, TEXT, YEAR, MONTH, DAY, DATEDIF, NETWORKDAYS, 
    • CONCATENATE, CONCAT, TEXTJOIN, FIND, SEARCH, MID, LEFT, RIGHT
    • SUMPRODUCT to replace VLOOKUP, SUMIFS etc (a must know for anyone claiming Excel expert level)
    • INDEX (one of the most versatile formulas in Excel)
  • Creating Dashboards in Excel
  • Planning and Strategy Tools in Excel
    • Goal Seek
    • Scenario Manager
    • Data Table
    • Solver
  • Integrating Excel with Data Science tools
    • R (using BERT)
    • Python (using xlwings)
    • JavaScript Office APIs
  • Power Automate in Excel
  • Excel VBA
    • Recording macro
    • Coding from Scratch
      • Userforms
      • Modules
      • User-Defined Functions  VBA

Power BI: 

  • Mastering Power Query in Power BI
    • Power Query handbook with M codes
    • Advanced Editor use
    • Column profiling
    • Diving into the deep end of Merge and Append
    • Magic of Right Click
    • Mastering the Power Query interface
      • Enabling the Formula bar
      • Query Settings
      • Query Dependencies
  • DAX deep dive
    • Must know DAX formulas (CALCULATE, FILTER, SUMMARIZE etc)
    • DAX Studio
    • Debugging incorrectly working DAX formulas
    • Optimising your DAX
  • Data Modeling
    • Relationships
    • Cardinality
    • Direction
    • Synonyms
    • Date Table
  • Visuals and Report Creation
    • Native visuals
    • Imported/marketplace visuals
    • Symbols and Unicode icons
    • Report layouting
    • Row-level security
  • Report Publishing, Dashboards, and Power BI Service
  • AI in Power BI
  • Power BI Settings

In summary,

  1. You get to choose the topics you want to master.
  2. You get to choose the date to have the class.
  3. You get more options of venue (our place or your place).
  4. You get to have the trainer work on your report for you during the training.
  5. You get to improve on the new areas of data analysis you are weak at without being forced to go through areas not important to you as is often the case in general training classes.
  6. The best part is that we are setting the fees at a very affordable rate that’s the same as the general classes while you get a personalized training.

Don’t delay. Take advantage of this offer before the price is raised. Reply to us now or call Hope on 0703-990-2445 or Faith on 0913-137-0701.

 "Mike, don't look at the wall or the traffic cones, rather look where you want to go. That is the trick to riding a motorcycle. Don't look at the obstacle you want to avoid but at the clear path you want to take."

That is what my riding instructor said all throughout my learning to ride a motorcycle.

Today, I think it is true for riding through life itself. 

Everyday we are flooded with images and news of what is not going well for us or around us. There are too many things we want to avoid and steer clear off, but not everyone puts in the conscious effort to focus on where they want to go and not what they want to avoid.

As a friend, I want to share with you that important lesson I got from my instructor. At first, it sounded like a childish way of forcing me to act differently. I thought that no expert rider sees a pothole right on his path and takes his gaze away from it. That is not how we drive cars and I was sure that to avoid a pothole one needed to keep his eyes on it rather than away from it. But the more I ride, the more I find out that as unconventional as it sounds, it is actually the only way to ride a motorcycle.

You see a corner you want to take, you look beyond the corner. You see a path you want to take, you don't look at the cars you want to avoid but at that path between that truck on the right and the bus on the left as that is the way to ride between them.

I strongly believe that we should go through life with the same approach. If you want to go to Canada, don't look at all the roadblocks in front of you but have your gaze on the path you hope to take. If you want to enjoy Nigeria, then don't feast on the bad news streaming out daily rather set your face on the goodness you desire. If you want to marry a great person, then don't come up with why they don't exist, but set your mind at ease and open to finding him/her. If you want to have a great career don't let the stories of how hard it is be your daily meal rather let the inspiration from those already living that dream work life be your constant meal. 

If you love comparing, there will always be people doing more with less than you have and people doing less with more than you have. You can choose to beat yourself up and kill all joy on your way to getting to where you want to go, or you can choose to ignore the pressures and focus solely on where you want to go. Soak in the beauty around you, enjoy the journey, feel the breeze, let the gyrations flow through your body and open your senses. Sometimes the journey is just as important as the destination, don't let the obstacles ruin your ride.

This past two weeks I hooked up my Razer Blade Pro 17 model 2020 to Nicehash and have been mining crypto at the rate of about $2.5/day

So far I have made $15.49 from about 8 days of leaving my laptop to mine overnight when I am done with work for the day. My laptop's GPU is Nvidia RTX 2080 Super Max-Q and has a total power limit of 100W.

I get about 33 MH/s (mega hash per second) which is the way the crypto mining performance is measured. The more hash you can do, the more money you are basically printing.

Originally, I was doing about 28 MH/s then I read on Reddit that I can bring down my computer temperature and boost the MH/s if I overclock the GPU's memory and underclock the GPU's core clock. So I overclocked the memory by +895 and underclocked the core by - 502. And it worked as described - the laptop ran slightly cooler at 70 degrees Celsius and the hash rate jumped to 33 MH/s


I am feeling excited about the possibility of doing it on 24/7 scale but it would require getting a dedicated device (either GPU based setup or an ASIC miner).

After scouring the net, I found that one can buy an affordable and profitable dedicated miner, hook it to the internet and have it permanently on. For 3 days I was drawn to Goldshell Mini-DOGE miner that sells for $699 and makes you about $2.50/day. And it consumes a meagre 235W which is super impressive for a miner.


Sadly, it has been out of stock for weeks and no information on when one can grab one from the manufacturer's sales store. When I searched for other sellers, they have theirs listed at twice the official retail price. I settled on buying from a seller on Aliexpress who was selling his for $960 with a power supply unit (PSU) so he is not marking up his own very much as Goldshell sells at $750 (I heard) if its coming with a PSU but I am check to go click checkout for the past one week.

Now I am considering getting a GPU based miner. Maybe buy a gaming desktop with a Nvidia 30xx series GPU card. Saw one today that will mine me $4.70/day but is priced at N980,000. It's a great PC and can do more than just mining. 


I am sure the allure will wear off before I can sell my stocks to raise the money. But for sure, the mining bug has bite me.

How would you like to learn from industry experts from around the globe every week, investing just 1 hour each Sunday afternoon/evening?

Is it free? 

Yes and you get to win prizes from our sponsors. Prizes that range from $100 cash/coupon, mentorship, training resources, training coupons and physical gift items.

What do you have to do?

All you have to do is join the meetup community and attend the weekly 1 hour sessions. 

Join the Financial Modeling and Valuation Learning Community at https://www.meetup.com/Financial-Modeling-Valuation-Learning-Community and participate in the 1 hour interactive sessions that hold every Sunday at 2:00pm to 3:00pm UTC+1

Join the Microsoft Excel and Data Analysis Learning Community at https://www.meetup.com/Microsoft-Excel-and-Data-Analysis-Learning-Community and participate in the 1 hour interactive sessions that hold every Sunday at 4:00pm to 5:00pm UTC+1

Join the Power BI Learning Community at https://www.meetup.com/Power-BI-Learning-Community and and participate in the 1 hour interactive sessions that hold every Sunday at 6:00pm to 7:00pm UTC+1

Where can you see what the previous sessions have been like?

To see what you have been missing so far, you can check out the YouTube playlist, https://www.youtube.com/channel/UCidg3bIqr7TQHz6MEWWbLng , for all the past sessions. We have had speakers from all over the world: Nigeria, Ghana, Morocco, Pakistan, Australia, United States, United Kingdom, Ireland, Canada, Brazil, New Zealand and other countries. And big names like Bill Jelen, Marco Russo, Matt Allington, Reid Havens, Celia Alves, Chandoo, Danielle Fairhurst, Alan Murray, Liam Bastick, Ken Puls, Victor Momoh, George Lungu, Ahmed Oyelowo, Charles Otoghile, Evans Otalor, Microsoft internal team, Ramon Bello, Leon Gordon, Bernard Obeng and many others.

What do you stand to gain?


You get to learn new ways of doing things better, get to know what’s new, see how the experts use the tool you love, get new insights and be at the forefront of trends in this analytics space. And your productivity, career, exposure and skills will be better week on week.


Any extras for you?


Yes, we have onboarded many generous sponsors who are offering exam discount vouchers, training coupons, gift items, cash awards and many goodies to our community members. So don’t delay, join as many of the communities that interest you and be part of this sweepstakes weekly.


Can you have the joining details again?


Yes.

Join the Financial Modeling and Valuation Learning Community at https://www.meetup.com/Financial-Modeling-Valuation-Learning-Community and participate in the 1 hour interactive sessions that hold every Sunday at 2:00pm to 3:00pm UTC+1

Join the Microsoft Excel and Data Analysis Learning Community at https://www.meetup.com/Microsoft-Excel-and-Data-Analysis-Learning-Community and participate in the 1 hour interactive sessions that hold every Sunday at 4:00pm to 5:00pm UTC+1

Join the Power BI Learning Community at https://www.meetup.com/Power-BI-Learning-Community and and participate in the 1 hour interactive sessions that hold every Sunday at 6:00pm to 7:00pm UTC+1


We look forward to seeing you this Sunday!