DEV Community: Olanrewaju Oyinbooke

Land Your First Job Using SEO and Portfolio Vehicles

Olanrewaju Oyinbooke — Fri, 02 Sep 2022 10:10:40 +0000

Scrape Twitter Data Without Coding

Olanrewaju Oyinbooke — Mon, 29 Aug 2022 03:55:42 +0000

Follow me on Twitter https://twitter.com/theoyinbooke

Subscribe to my YouTube Channel here https://youtube.com/c/theoyinbooke

How Pranav Discovered Power Platform

Olanrewaju Oyinbooke — Sat, 27 Aug 2022 18:33:35 +0000

Follow Pranav here https://twitter.com/pranavkhuranauk

Meet Pranav Khurana

Olanrewaju Oyinbooke — Sat, 27 Aug 2022 18:26:03 +0000

You can follow Pranav on twitter here: https://twitter.com/pranavkhuranauk

Follow me on Twitter: https://twitter.com/theoyinbooke

How to Stay Accountable with Your Learning

Olanrewaju Oyinbooke — Tue, 19 Jul 2022 21:16:44 +0000

There are several accountabilities hacks out there and you might have tried some of them out in the past. The tips shared in this article will help you stay more accountable when others fail.

The Stake Model
As you will expect, if you get anything out of life, you need to stake something. For any successful learning adventure, you had to stake your time and probably let go of some fun or even miss events.

In the Stake Model, you simply find something valuable to you - either a certain amount of money or something of sentimental value to you that you don't want to let go of and give it to a trusted person with the following well clarified and understood:

The Learning objective: What exactly do you want to learn
Duration: How long will it take you to learn this
Success Criteria: What determines if you have successfully completed the learning adventure. You need to pay attention to this. If what you are learning is a technical skill like Power BI, for example, your acceptance criteria should include working on a Power BI Report and documenting this properly on GitHub or Medium. In fact, make sure you submit samples of how detailed your documentation should be. The key takeaway here is that you truly want to grow by pushing yourself to do what you haven't done before
Your Return on Lean: If you have any agreement with your accountability partner, you should clarify what the return will be for you. It is not a must that your accountability partner should give you something back.

Watch this short video to understand the Stake Model very well

Benefits of Using The Stake Model

If your parent is your accountability partner, this is a great way to show them your commitment to growth and they can go the extra lengths to get you the support needed for your growth.
If your mentor is your accountability partner, this is an excellent way to convince them of your commitment to growth and they can be encouraged to support you even when not convenient for them.
It is a way to get what you need for your next learning journey. as you share your growth with the community, it is easier for people to estimate the value of their investment in you. If you can do this with just a phone, with a PC, you can even do more. simple.
Sharing your journey can also connect you to the right mentor. there is no way to convince your potential mentor of your commitment if you don’t have evidence like this. You need to practice accountability in your learning and growth journey.

Learning Resource
30Days of Learning: https://aka.ms/30DLOnboardingRecap scroll down to the end of the page and click on the Data Analysis Track

Analyze Data with Excel in <60 Secs

Olanrewaju Oyinbooke — Sun, 17 Jul 2022 19:35:07 +0000

Note: This feature is only available in Microsoft 365 Excel.

You can create one by checking out this video

Create Power BI Dashboard in 60 Secs

Olanrewaju Oyinbooke — Sun, 17 Jul 2022 18:10:46 +0000

Creating shareable dashboard doesn't have to be a difficult task. With Power BI Integration to Microsoft List, you can create auto generated dashboard from your list and share with everyone in your organization.

This can come really handy for you.

How to Plan a Power Apps Development Project

Olanrewaju Oyinbooke — Sat, 16 Jul 2022 01:53:18 +0000

This is the first video in the Beginner Power Apps series

Ee Lane Yu will be sharing with us what to pay attention to starting from the Requirement workshop, wireframing, theming and branding, to accessibility and many more.

Requirement Workshop Process
Pay attention to the following

Preparation and planning

Read the Scope of Work
Get to know your client and who is the stakeholders
Find out the current environment landscape, business processes, data model organisation chart, user stories and app wireframe
Tailor the workshop questions

Requirement Workshop

Understand use case and pain points that need to be addressed
Identify the users and their roles
Clarify the business process and to-be environment landscape
Confirm scope and interface design

Outcome

User Stories & Acceptance Criteria
App Storyboarding/Wireframe
Environment landscape design
Data Model Design
Backlog

And many others

canvasapp #powerapps #powerplatform

How to Install and Configure MySQL Database

Olanrewaju Oyinbooke — Fri, 15 Jul 2022 23:59:05 +0000

As a Data Analyst, you will need to demonstrate SQL your ability to work with databases to recruiters. In fact, several job interviewers have SQL questions and assessment in them.

One of the friendly way of starting is by Installing the database server on your PC.
In this video, I walk you through how to install and configure MySQL Database on your windows PC.

Connect Power BI to MySQL Database

Olanrewaju Oyinbooke — Fri, 15 Jul 2022 23:30:36 +0000

Connecting Microsoft Power BI to MySQL Database is not complex. In this video, I walk you through how to get this done.

Make sure you watch the previous video on how to set up MySQL Server on your Local Machine and also how to Install SQL Workbench to interact with it.

From Data Scientist to Power Platform Developer

Olanrewaju Oyinbooke — Fri, 15 Jul 2022 23:18:49 +0000

I know this might sound crazy to you. I am leaving the sexiest job of the century for something not known to all. I will like to share with you my reasons and journey on this path.

I am a very passionate Data Scientist, and I’ve delivered a couple of Machine Learning solutions. I began the first Data Science team at my place of work where I was able to standardize the team's activities with EXCOM supports.

So, Data Science is amazing!

The global lockdown in 2020 was a significant game changer as everything was hung on the cloud. Our on-prem infrastructures failed us.
We were all locked down.

We are all aware that software changes how we work, and in every century, the very nature of work itself changes. We are already on the verge of experiencing another major shift. It is the 2nd wave of digital transformation, and the lockdown accelerated it.

Deep down, my passion is to help people and organizations simplify processes and map innovative solutions to drive growth, reduce cost, and optimize operational processes. At the root of this passion is no attachment to a particular software or tool. Data Science was a technique I discovered that could help me deliver on this.

At the root of this passion is no attachment to a particular software or tool. Data Science was a technique I discovered that could help me deliver on this.

Why then did I make this Switch from Data Science
Reason No 1: My passion is not tied to technique but instead centred around people. This made it easier to consider a change of job title and use of a tool.

Back to the conversation on the global lockdown, I saw businesses shutting down, people losing jobs and loved ones (My heartfelt condolences to all families affected by the pandemic. It was too emotional for me), employees getting significant pay-cut, and so on.

I then realized how privileged I am to be working with AXA Nigeria where premium attention was given to all employees' wellbeing and mental health without any pay cut or lay-off. There were a thousand and one reasons to consider some of these options because revenue was dwindling at the time (at least not as projected).

My passion got redefined, and I found its pivot on love and empathy. I saw more reasons why I have to give all my best to the organization.

As a Data Scientist in the Nigerian market, we are limited in application and use cases because of data structures and management. Most of the available data in businesses today are not adequately managed to make them suitable for advanced analytics use cases (however, we were able to pick up a couple of use cases and delivered some during the pandemic).

We are aware that the lockdown accelerated the digitization need of every organization and AXA Nigeria wasn't an exemption. From a hard copy form that could no longer be filled and submitted to the next office, to the leads that can no longer be contacted in person. This led to more inefficient processes with limited capacity.

I hurriedly searched for sustainable tools (apps and services) that could help my organization streamline these processes and become more resilient, and I found Power Platform.

I was able to work with my team and managers' support, address significantly several processes within the organization, and bring relief to lots of teams (several team/divisions). The joy was immeasurable for me.

With the Microsoft Power platform and its integration to Microsoft 365 Apps and Services, I was able to leverage Microsoft Forms, SharePoint List, Power Automate, MS Teams, Power Apps and build working solutions in hours while some cases, in days (because of the learning gap).

With the capabilities of Microsoft Power Platform, I realized the workplace is changing rapidly.

Without prior knowledge of Power Platform, I learned so much and accomplished so much in a matter of days. This was not the case some years ago.

Reason No 2:
As against Data Science projects, I could leverage the existing data in their raw form and simplify processes. Meanwhile, some Machine Learning projects were abandoned because the data available are not sufficient to deliver on the project's objectives.

Reason No 3:
The Smooth learning Curve. No software or tools have been more straightforward for me to learn (in terms of learning) like the Power Platform Applications. There are numerous learning resources that will address your needs and ever-growing learning communities all over the world.

Reason No 4:
Just You! While a team of ProDevs and Citizen Developers can come together to build a solution using Power Platform-tools (FusionDevs), you can single-handedly create a production-ready application without dependency on several teams as you would have in the traditional application development experience.

Reason No 5:
The Speed of Delivery: I can't express my feeling when I built a Power Apps application connecting to SharePoint List within an hour. It's a mind-blowing experience. Application development has been like rocket science to me for years until I started using PowerApps.

Reason No 6:
The Extensibility of the solution: The fact that I can customize my solution, build my connector, visualization card, themes, etc. was something I found intriguing.

Reason No 7:
It is no-code/low-code: How can I build a functional application without writing code or at most writing expressions similar to Microsoft Excel? This is so real!

Reason No 8:
You are not saying bye-bye to Machine Learning and AI solutions. With the AI Builder in Power Platform, you can easily infuse pre-trained Artificial Intelligence solutions into your application or flow. These AI solutions, in most cases, are more accurate than what you will develop, and you will need a lot of resources to achieve their level of accuracy.

Reason No 9:
Microsoft Power Platform is the future of workplace automation. PowerApps for application development, Power Automate for workflow automation, Power BI for analytics, and Power Virtual Agent for intelligent chatbot development. These solutions integrate natively to Microsoft 365, Dynamics 365, and Azure Services. You can see how big the vision is.

Reason No 10:

According to Microsoft Data Science Report curled from Linkedin (see the image above).
The world needs more software developers! either pro developers or citizen developers (users of low-code/no-code tools).

These developers will focus on building solutions that will address the increased digitization needs of the world. I want to be part of these people. I want to see the world rise again to its full potential.

Reason No 11:
You can learn for free. Learning Data Science is almost completely free, while a fraction is licensed, e.g. leveraging on cloud services. I got my fingers burnt several times with Azure Invoice at the end of the month 😊. But for Microsoft Power Platform, you have several options to learn utterly free with access to Premium features through its Power Apps Developer Plan.

There is also an amazing community in Nigeria led by Foyin Olajide-Bello, David Abu, Ibrahim Idowu and many others (of course, I am privilege to be among the team today).

Reza Dorrani has been an inspiring leader in this space. He do not only gave himself to this community, but he also motivates me daily. you can check out his YouTube Channel here . kindly subscribe and support his work.

I have said so much here, and I need to put things together.

I derive my satisfaction whenever I solve a business challenge, and with Microsoft Power Platform, I smile more often than before.

Today, I still oversee Data Science Projects in the organization as a Data Science Program Manager. I have seen the need to move closer to the business through Power Platform solution implementation.

I am learning every day, and I am confident that I am on the right path.

In my next post, I will introduce you to Microsoft Power Platform and show you the wonders of this amazing and god-gifted automation solution.

Resources:
My Youtube Channel: https://youtube.com/c/theoyinbooke . please subscribe 😊.
Images credit goes to amazing contributors at pixabay.com

SQL Data Cleaning Project Showcase

Olanrewaju Oyinbooke — Fri, 15 Jul 2022 22:40:23 +0000

It’s been estimated that almost 60% of data analyst and scientist time is spent on data cleaning for a given project so, this is a very relevant skill to showcase to your employer.

Unlike Data Visualization Project, it can be difficult to prove your SQL skill to potential employers or recruiters.

Your ability to carry out Data Cleaning with SQL can be a big add-on to your skill.

In this article, I review the work done by Jennifer Francis-Nkpornwi, one of the data community members. This project is really awesome and I would like you to add it to your portfolio too by doing something similar.

Follow me for more content on Tech, Data, and Lifestyle