Data is the new oil and I live in an oil country where nobody is drilling --- Olanrewaju Oyinbooke (2019). I am so happy right now that I can share a quote that inspires me so much at the early stage of my career. Interestingly, this quote is also by myself.
You will agree with me that in Nigeria and Africa, we haven’t gotten the best value from the data around us yet and that is exactly what this track is trying to solve. By equipping you to be able to fill this gap. Did I just say Gap? Yes, there is a Data Gap.
What is Data Gap?
Data Gap is a way to represent the rate of data generation versus analysis. Daily, Data are being generated at an exponential rate but only few are being analyzed. What could cause this gap? a very obvious reason is unavailability of technical-know-how. we have fewer skilled data analyst compare to the available data.
To better understand the volume of data generated daily, let us check this data never sleeps chart by domo.
This huge data gap means opportunity. as predicted by Microsoft, between 2020-2025, there will be 43million job roles in the data analysis and related role space. This will however favour only the skillful and not beginners.
This post is the primary guideline for the Data Analysis Track and will help you to navigate the entire learning journey.
On the table below, you will find all the topics and link to the sessions
Day of the Week
•The World of Analytics – BI and Data Analysis •Start with Value and not the Tool •Few Steps to Take for all Your Data Analysis Projects •Microsoft Excel Repeating the Miracle •Excel VLOOKUP •Excel Pivot tables, Charts, Building reports
Exploring the world of Analytics Understanding Business Value Intro to MS Excel and Excel Look Up
Video Content on YouTube Link to Microsoft Excel Tips Link to Download COVID-19 Dataset through MS Excel
•Overview of Power BI Functionalities and installing Power BI Desktop •Connecting to different Data Sources in Power BI - Excel data, SharePoint List, Folder, Web, and Database Build a dashboard by dragging and dropping in Power BI Desktop
Power Query in Power BI, Getting Familiar and working with Power Query
•Import VS Direct Query in Power BI •Power Query Intro and PQ Editor Functionalities •Importing folders into Power B •Importing data into Query Editor •Formatting data in Query editor •Combining tables in Query editor
Data Modelling and Welcome to the World of Data Analysis Expression (DAX)
•Data Modelling – What is it? •Types of Relationships •Managing relationships. •Relationship cardinality •Introduction to DAX •Creating Calculated Columns and Measures Build Your 2nd Dashboard with Modelled Data and Calculated Column and Measures