Today at 7:00pm Nigerian time I will be a guest on the Brasilian Cristiano Galvao's Excel Turbo show.

I have been doing some Portuguese lessons and intend to speak a few sentences I have learned. Come and watch me say Oi and Tchau (at the minimum).

Joining link is https://www.youtube.com/watch?v=dvRSlfHxnr4

I will also be sharing some personal stories that you probably don't know some of even if you have been reading my blog for 5 years now. I hope so, 'cos these days I find that difficult to achieve. Seems I have been oversharing on this blog before. 😁

I will also be sharing some uncommon Excel feature. Something I assure you that you've not tried before. So you don't want to miss all these.

See you this evening at https://www.youtube.com/watch?v=dvRSlfHxnr4

Te vejo em breve!



Join us this Friday as we take you through the career journeys of three experts who will show you practical insights into building your career in this exciting field of data analysis, business intelligence and financial modelling. These sessions are brought to you by UrBizEdge, do checkout our courses (we have online classes and physical classes)

Session 1: Financial Modeling Office Hour 5 (https://www.meetup.com/Financial-Modeling-Valuation-Learning-Community/events/ncwlsrybcjbzb/)




Agenda:
1. Expert Journey Interview - Abraham Durosawo
2. Industry Deep Dive
3. Other Questions & Answers

See you in the online live class session!

Joining link is https://vip.urbizedge.com/fin-mod-live

Abraham Durosawo is a veteran investment advisory professional. He possesses years of financial advisory and capital raising experience across power, oil & gas, infrastructure, insurance, manufacturing, technology, agriculture, financial services and real estate projects. He was a member of the team that developed the Economic Recovery and Growth Plan of the Federal Government.

He is a Certified Management Consultant and Fellow, Institute of Management Consultants. Enrolled in a dual Executive MBA at the Business School Netherlands and Quantic School of Business and Technology. He is a candidate in the CFA Program. He is a Director at Unicorn Capital, Consultant to the Investment Banking Institute New York, Business Mentor with the Bid Network Foundation, Netherlands, and a Mentor with the Google Launchpad Start. He is also the convener of the Finance Professionals Network, a community of future global leaders in finance. He is a specialist in equity and debt investment instruments with a core focus on private equity and venture capital investments. 

Abraham is an award-winning YALI Fellow, The Young African Leaders Initiative, where he won the 2018 star of Entrepreneurship.


LinkedIn https://www.linkedin.com/company/careers-in-finance/ 
Twitter: @FinProNetwork


Session 2: Microsoft Excel and Data Analysis Office Hour 5 (https://www.meetup.com/Microsoft-Excel-and-Data-Analysis-Learning-Community/events/hmzlsrybcjbzb/)




Agenda:
1. Expert Journey Interview - Kehinde Omisile
2. Special Demo
3. Other Questions

See you in the online live class session!

Joining link is https://vip.urbizedge.com/excel-live

Kehinde Omilise has a Bachelor's Degree in Mathematics and Master's Degree in Biostatistics. he developed flair for Excel as a diploma student of Agricultural Engineering sometime in 2003. First learnt to use Excel for analyzing Analysis of Variance (ANOVA). He uses Excel regularly for research, business solutions, visualization and analytics in the nonprofit sector.

You can connect with him via LinkedIn: https://www.linkedin.com/in/omisilekehindeolugbenga/
and
YouTube: https://www.youtube.com/c/OmisileKehindeOlugbenga 


Session 3: Power BI Office Hour 5 (https://www.meetup.com/Power-BI-Learning-Community/events/cmzlsrybcjbzb/)




Agenda:
1. Expert Journey Interview - Ahmed Oyelowo, MVP
2. Live Demo
3. Other Questions & Answers

See you in the online live class session!

Joining link is https://vip.urbizedge.com/power-bi-live

Ahmed is a Microsoft Most Valuable Professional (MVP), Microsoft Certified Solutions Associate (BI Reporting), Microsoft Certified Trainer (MCT) and a Certified Advanced Financial Modeler (AFM) from the Financial Modeling Institute, Ontario, Canada.

He has developed cutting edge solutions for companies and trained over 3,000 people on Business Intelligence and Financial Modeling.

He is also a contributor to the Power BI Community blog where he writes technical "how-to" articles. This combines with other articles he publishes on his blog and videos he posts on his YouTube channel.

His business website is https://foresightbi.com.ng/ and you can get more of his amazing tutorials on YouTube https://www.youtube.com/channel/UChdiVx41iPzoucPBiI_jy_A

image: forumchristian.org

Join us today at 2:00pm (WAT), 4:00pm (WAT) and 6:00pm (WAT) as I bring you exciting interviews and demo sessions from awesome data analysis experts who are making waves in their space.

Session 1
The first is my session with the special Bernard Obeng Boateng whose impact stretch from Ghana to Nigeria, claim your participation slot at https://www.meetup.com/Financial-Modeling-Valuation-Learning-Community/events/ncwlsrybcjbqb/

Agenda:
1. Expert Journey Interview - Bernard Obeng Boateng (BEST)
2. AFM (Advanced Financial Modeler) Certification
3. Other Questions & Answers

See you in the online live class session!

Joining link is https://vip.urbizedge.com/fin-mod-live

Bernard Obeng Boateng is a Financial Modeler and Data Analyst with work experience in Banking, Insurance and Business Development. Bernard is skilled in Business Analytics, Dashboards and building financial models for budgeting, business valuation, scenario planning and investments. He also provides consultancy services for SMEs (startups and existing) in financial management, business planning and research.

He is certified in Business Analytics, New Venture Financing and Risk Modeling and provides training in Financial Modeling, Analytics and Microsoft Excel for individuals and organizations.

Bernard is co-founder of Business Evolution Systems and Training Ltd (www.best-gh.com) an approved training provider in Ghana for the Financial Modeling Institute, Canada.

You can connect with him on LinkedIn at https://www.linkedin.com/in/bernardobengboateng/ and you should subscribe to his YouTube channel to get super useful Excel tips, https://www.youtube.com/channel/UC9wBo_091Lu_rvLSqDIoo6A


Session 2
Then, there is the session with MVP David Abiola at 4:00pm and you can claim your participantion slot at https://www.meetup.com/Microsoft-Excel-and-Data-Analysis-Learning-Community/events/hmzlsrybcjbqb/

Agenda:
1. Expert Journey Interview - David Abiola, MVP (Excel Jet Consult)
2. Excel Tricks
3. Other Questions & Answers

See you in the online live class session!


Abiola David is the founder of Excel Jet Consult. He has trained professionals from many organizations in Nigeria including Senior Staffs at Federal Ministry of Petroleum Resources, Rose of Sharon Foundation, Access Bank to mention few.

His love for Excel and desire to upscale the Excel knowledge of Nigerians, made him to partner with NGOs to deliver free Excel and Power BI training for students at different Federal Universities in Nigeria pro bono. An avid blogger, he regularly share his wide technical expertise on his website which attract thousands of visitors from around the world.

Abiola David has published two books on Excel: Microsoft Excel for Professionals and Microsoft Excel Advanced Masterclass for Professionals.

He is an active contributor in the Microsoft Forum and regularly share technical videos on Youtube, https://youtube.com/user/Born2begrait


Session 3
And at 6:00pm we get to hear from the indefatigable MVP Ayodeji Folarin you can claim your participantion slot at https://www.meetup.com/Power-BI-Learning-Community/events/cmzlsrybcjbqb/

Agenda:
1. Expert Journey Interview - Ayodeji Folarin, MVP
2. Live Demo
3. Other Questions & Answers

See you on the online live class session!


Ayodeji is a Microsoft Certified Trainer, BI Developer, Data Platform Evangelist, Data warehouse and Dashboard/Business Reporting Expert

With over 23 years in the computing arena, Ayodeji has focused on data platform solutions around Microsoft Azure and Office 365. He has helped many companies to migrate their systems to the cloud and get insight from their data source for the past 10 years.

Ayodeji has passion for teaching and community engagement. He is a well-known speaker at many local and international conferences like MCT Summits, Power BI User Groups, PASS Local Groups, Microsoft Student Partners Events and other meetups. He loves to be on stage both at large events and at smaller user groups meetings, exchanging ideas with other SQL and BI fans. He loves traveling for work and to engage with local user groups, so always watch out for his next event around you.

Ayodeji has been certified as a Microsoft Trainer for over 5 years. He has been involved in presenting, community speaking and helping other professionals in the better usage and taking advantage of Microsoft's data solutions from flat files to RDBMS for example Excel, Access, SQL server, Power BI, MSBI, Azure SQL and many more.

Starting as a developer back in 1994, programming COBOL, BASIC and FORTRAN, Ayodeji has helped companies in multiple countries in many business areas to design and deploy their computing solutions. His love for spreadsheet and application development made him develop a spreadsheet application with VB4 to compete with Lotus 123 then.

Achieving his first Microsoft certification in 2010 as SQL Server 2008 Database Administrator and DB Developer, that same year he got his certification on Microsoft.NET Framework 3.5 web and Desktop developer track. He now decides to focus his career around Microsoft's data platform. He is certified in recent release of SQL and Microsoft Power BI (Excel and Power BI Desktop).

You can connect with him on Linkedin via https://www.linkedin.com/in/ayodeji-folarin/ and be wowed by his one of a kind website, https://dejifolarin.com


Today we are running three special expert interview sessions. If you've ever felt lonely and almost frustrated in your data analysis mastery/competency journey then these sessions are the very medication you need to regain your motivation and get timely career help.




Session 1: https://www.meetup.com/Financial-Modeling-Valuation-Learning-Community/events/ncwlsrybcjbhb/

Friday, 5 June 2020 @ 2:00pm GMT+1

Agenda:
1. Expert Journey Interview - Charles Otoghile (High5)
2. Financial Analysis vs Financial Modeling
3. Questions & Answers

See you in the online live class session!

Joining link is https://vip.urbizedge.com/fin-mod-live



Session 2https://www.meetup.com/Microsoft-Excel-and-Data-Analysis-Learning-Community/events/hmzlsrybcjbhb/

Friday, 5 June 2020 @ 4:00pm GMT+1

Agenda:
1. Expert Journey Interview - Victor Momoh (ExcelMoments)
2. Pivot Table Tricks
3. Other Questions

See you in the online live class session!

Joining link is https://vip.urbizedge.com/excel-live



Session 3: https://www.meetup.com/Power-BI-Learning-Community/events/cmzlsrybcjbhb/

Friday, 5 June 2020 @ 6:00pm GMT+1

Agenda:
1. Expert Journey Interview - Evans Otalor
2. Power BI Admin Portal
3. Other Questions

See you in the online live class session!

Joining link is https://vip.urbizedge.com/power-bi-live

About our special guest:
Evans Otalor is currently a Data Science Consultant with Sterling Bank, before that he was Head of Data Analytics at IHS Towers, Nigeria. He is also a part-time lecturer at two foreign universities.

He is an experienced analytics professional with demonstrated track record successfully structuring and managing analytic projects across Banks, TELCOs, and FMCGs.

Evans holds a BSc in Industrial Mathematics from Ambrose Alli University and an MSc in Actuarial Science from Glasgow Caledonian University, Glasgow.

Highly skilled in the application of Mathematical and Statistical Methods to collect, organize, interpret, and summarize data for quantitative modelling projects that include both Data Analysis and Predictive Modelling to aid insight extraction, Risk Disclosure, Reporting, Measuring, Monitoring, and Predicting. Evans have over 10 years’ experience training in the Data Science space with over 13 years industry experience

Expert user of Python, R, Microsoft Applications (Including MS Excel, Power BI), SPSS Modeler, Alteryx, Knime, Tableau, and various Data Analytics/Visualization tools.



(c) www.urbizedge.com
For the Financial Modeling and Valuation training/support live session: https://vip.urbizedge.com/fin-mod-live



We would be handling questions people have asked:
1. Why we do not use TODAY() for the model date stamp
2. How to access the support resources
3. Calculation of the WACC
4. Understanding the Cashflow Statement
5. Other Questions

See you in the online live class session!

Joining link is https://vip.urbizedge.com/fin-mod-live



For the Power BI and Dashboards training/support live session: https://vip.urbizedge.com/power-bi-live




Agenda:
1. Making use of the shared Power BI pro account
2. Connecting Google Sheet to Power BI
3. Understanding the difference between the Power BI Desktop and Power BI Service
4. Access the practice files
5. Other Questions

See you in the online live class session!

Joining link is https://vip.urbizedge.com/power-bi-live 


For the Microsoft Excel and Data Analysis training/support live session: https://vip.urbizedge.com/excel-live



Agenda:
1. New Excel formulas
2. Connecting Google Sheet to Microsoft Excel
3. Downloading the training resources (practice files)
4. Using the new Excel Add-in store
5. Other Questions

See you in the online live class session!

Joining link is https://vip.urbizedge.com/excel-live


Cheers!
Felt this might be helpful to some of you. It was originally just for people who have taken our training courses but now I'm expanding the access to you and many other people who can benefit from it. Feel free to share with your friends and family.




Hello *Student*,
Here are some new important information for you to make the most out of our premium learning platform.
  1. Starting from May 2020, we will now have regular Online Office Hours where via a virtual meeting we will discuss what you've learned, challenges you are facing, career opportunities, tips, how to maximize value from the courses and everything that's going to be of value to you. 
  2. The joining link for Microsoft Excel and Business Data Analysis course's community where those Office Hours will hold is https://www.meetup.com/Microsoft-Excel-and-Data-Analysis-Learning-Community/
  3. The joining link for the Power BI (Business Intelligence) course's community where those Office Hours will hold is https://www.meetup.com/Power-BI-Learning-Community/
  4. The joining link for Financial Modeling course's community where those Office Hours will hold is https://www.meetup.com/Financial-Modeling-Valuation-Learning-Community/
  5. There will be occasional competitions and prize giveaways to spice things up and reward people for their time.
  6. My team will also use this as a platform for some of you to gain visibility in the global community. We are working on letting some of you become webinar hosts, community leaders and gain a ready audience/following to improve your career and be opened up to global opportunities.
  7. If you are taking the Power BI course, you can use our special Power BI pro account for your practice (if you don't have pro account from your company) so that you won't need to buy a separate Power BI pro account and will be able to practice all that I am teaching you. The email is xxxx@xxxx and the password is xxxxx and you login at https://powerbi.microsoft.com/en-us/

All the best!

To your success,
Michael Olafusi | +1-941-312-2149 | 0700ANALYTICS | 01-6311885
Yes, you read that right. In 10 mins you can publish your book on Amazon. And all you need is a ecopy of the book -- can be in Microsoft word version, HTML (web) version, plain text file or ePub.

So for all of you who have written a book or something close to a book and will like to share it with the world with the opportunity for you to earn some foreign currency too, then today's your special day.

You head to https://kdp.amazon.com/ and sign in with your Amazon account. If you don't have one; create one.


In the main page that comes up after you login, called Bookshelf, you get to create a new ebook or hard copy book. For hard copy book the process is similar. Amazon will print the book on demand and ship to the buyer for you. Meaning you don't need to print and warehouse large copies of your book to sell if you want people to buy hard copies of your book. Amazon will print the book and send to them while you just collect your share of the money. Awesome!


Make sure you have the electronic copy of your book within reach. 

Click on " + Kindle eBook".




Fill in the details for your book.  Click "Save and Continue" to move to the 2nd stage.



Upload the ecopy and the book cover design. When you click next, it will begin converting your book into the Kindle format.


Once this is done. Click on "Save and Continue" to set your price for the book.



And that's all!

Well almost.

How do you receive your payments in Nigeria?

Just as easy. Click on "Accounts" at the upper right. And put in your bank details. I use Payoneer, in case you want to know what I use to make it easy to receive the payments here in Nigeria.


All the best!
I am working on building a robust dataset of a Nigerian company that our training participants for Power BI can be able to use to perfect their data analysis skills in a more business relevant way.

I decided to get the much talked about and large company database: Adventure Works. And in order to use it and get some ideas from it for my own Naija Limited company dataset, I had to install SQL Server 2019 and do some bit of SQL-ing.



I recorded my entire installation process and below is the YouTube guide for anyone interested in playing with the SQL database.

Enjoy!



Are you preparing for Microsoft Power BI certification exam and feel discouraged by the study guide referring you to some practical tasks involving Adventure Works database?

Are you willing to practice your SQL and improve it on a corporate world relevant dataset?




And a bonus: 

How to bring in SQL Database Table data into Power BI and also how to connect to a live Google Sheet data table from Power BI.




Check out our training services at https://www.urbizedge.com

Enjoy!


If you got my yesterday post, then you would be aware that we got a new marketing tool that allows us to easily organize giveaways and reward our community members.



We have set up the first giveaway and if you are interested, you can give it a try: Access the Giveaway. Takes probably 1 or 2 minutes and you might win yourself a $10 gift card or the equivalent in Naira. That's getting one month data subscription or 2 months airtime or Apple music subscription or Google Play spend.

Access the Giveaway - https://vip.urbizedge.com/giveaway






These days I have been going to Appsumo a lot to find cheaper replacement for business tools we pay monthly for. I have swapped out our $29/month Hootsuite that handles our social media management with Publer which cost a one time charge of $39. Amazing, right? I've also founded a $39 Switchy as alternative to $29/month Rebrandly which handles our custom short urls, and this Switchy has some exclusive (relative Rebrandly) features that's made it godsend for us. I equally found adam.ai for managing our remote team meetings, signitic for centrally managing/setting our staff email signature to be uniform and awesomely designed, ideanote for generating ideas and collaborating on goals, startups for lifetime access to company building resources and training. And a couple others that are equally awesome.


There's also StackSocial.


Together, they help us find ways to swap out expensive tools for a one-off payment cheaper ones. Also, they help us get bargain priced tools that will help us become a more productive team especially as we all now work remotely.

There are however some products that are deals themselves without you having to check a deal aggregation site for them.

One such is Hubspot. We have moved to it at the price of $0/month from our $15/user/month Pipedrive CRM ($60 for a team of 4 users). Another is Wave Financials which we are exploring as an alternative to the $15/month Quickbooks we use.


These are tough times, and one must be looking for ways to make tough decisions that will help out outlast the tough times.