₦airaland Forum

Nazgul:
Check your email

ManyThanks:
Hi bro, great work for your meaninful contribution. Can you help point me sample sql database/files one can download for practice? Will appreciate.

Nazgul:
After downloading SQL, search for adventure works 2022, Adventure works DW2022, adventure works LT2022.

Download them all. They're all sample database which you can import to Power BI or any other similar program and work with.

Nazgul:
After downloading SQL, search for adventure works 2022, Adventure works DW2022, adventure works LT2022.

Download them all. They're all sample database which you can import to Power BI or any other similar program and work with.

ManyThanks:
All downloaded. issue now is how to query data using SELECT & FROM in SQL. Also, all files ended with .bak. is that the proper format for sql files? thanks in advance. here is a snapshot;

Jp96:
Morning bosses. I started my data analysis journey on Monday. I'm taking free courses on coursera and udemy.
I'm learning excel, power bi, sql and python in that order.
I've downloaded all the softwares on my laptop except for sql, I don't understand something.
To learn sql, is it that I have to download ms sql or mysql on my laptop??
[/
How is it going? I I'm interested in venturing into data analysis.
Any advice for me.[quote author=Nazgul post=130530662]To query data using SELECT and FROM in SQL, you need to follow these steps:

Write create view. For instance if you want to create customer table, (write customer_table as) remember to but your underscore to connect both together.

Select * (the asterisk means you're selecting the whole table) if you don't want the whole table you can just write out the columns you want to work with.

From dim customer. Dim customer means that you want to create a customer table from dim customer. You'll hold it and drag it to your from, then highlight everything and execute.

As for the bak you asked means backup. Adventure works files are basically backups for the database hence the bak.

AnalysisGuru:
Good day all.
Does anyone here know about how to open an upwork account smoothly for a Nigerian user.
Get in touch let's discuss

AnalysisGuru:
Good day all.
Does anyone here know about how to open an upwork account smoothly for a Nigerian user.
Get in touch let's discuss

Ejiod:
A typical day in my 1st place as a data analyst was quite simple:
Tools used were
Python
Pandas
Matplotlib & Seaborn
Plotly
Excel
MySQL
PowerBI
ArcGIS.
Power point
Google sheet
Google Datastudio

A typical day as an analyst. You are always starring at data to get sense of what you would do. Your boss is on you asking you to do comparative analysis between cohorts. Correlation was the order of the day. Then PowerBI wasn’t active then, Matplotlib, seaborn and plotly was the main visualization tool.
Every Tuesday we always had meeting to present data and how the firm is doing. Your presentation skill must be classy and you have to master your data if not questions from novice and expert can throw you off balance. Such meeting last for 2hours. You just have to be prepared.

Nazgul:
Send me an email and I'll reply you before the end of the day.

UcLloyd:
Guys i need advice from you gurus. I want to get a tech skill(s) to make more money in this country. Problem is, I have zero knowledge of any of the skills. Can I pull through? I'm a graduate. Which skill is best to start with considering I'm an amateur? I intend to get a laptop by September. A friend is advising me to look for a tech school to register and learn, is it wise? Any input will greatly help please, I'm very determined to learn please

UcLloyd:
Guys i need advice from you gurus. I want to get a tech skill(s) to make more money in this country. Problem is, I have zero knowledge of any of the skills. Can I pull through? I'm a graduate. Which skill is best to start with considering I'm an amateur? I intend to get a laptop by September. A friend is advising me to look for a tech school to register and learn, is it wise? Any input will greatly help please, I'm very determined to learn please

UcLloyd:
Guys i need advice from you gurus. I want to get a tech skill(s) to make more money in this country. Problem is, I have zero knowledge of any of the skills. Can I pull through? I'm a graduate. Which skill is best to start with considering I'm an amateur? I intend to get a laptop by September. A friend is advising me to look for a tech school to register and learn, is it wise? Any input will greatly help please, I'm very determined to learn please

Omotaday:
Interesting, this great thread seems to be fading.

For me, it all started here, and now I’m a BI developer working outside Nigeria. Thanks to Ejiod and other early contributors.

I wil say one thing, Data analytics or Business Intelligence is not just about dashboards. In the Nigeria tech space, I have noticed that people seem to overlook data modelling (Fact & dimensions, star schema, snowflake) which is part of the most important knowlege when working with data and it's likely to come out during interviews. As a data analyst, your data won't always come from a single table, you could have 10 tables with million of rows just for a report, how do you connect them? To that effect, I will encourage new comers to glance through this topic as they navigate their journey in the field.

-------------------------

Having said that, would it be possible to form a small group of BI Developers, Data Analysts/scientists and Data Engineers who are currently working in the field?

It could be helpful to have like-minded individuals to discuss work-related topics, career journeys, and new opportunities with.

I will be mentioning a few people below who have contributed to this thread in one way or another and who seem to be in the field. Looking forward to hearing your thoughts:

CC: Ejiod, Cochtrane, AnalysisGuru, Hamzatfresh, Mcemmy0z, Abcruz, Heyf, Toppytek, Kaycee54321, DHaran, Hinokami, VicUkegbu, T4kbaba, Kunleiky, Nazgul

I remember peeping at this thread sometime in 2021 or so. At that time I was still at a job earning 65k AUD here in Australia, which at that time was like entry level or graduate level salary.

After seeing this thread, I decided to work on my skills. Note that I already had a bit of knowledge about SQL, Tableau and python.
However, I began learning and improving my python skills for automating things and then gradually started learning how to use it to ingest and analyse data.

I spent about 3 months building different data projects and learning many things along the way. Experience is really the best teacher, you learn how to and how not to do things.

Back then, there was no chatgpt, so had to look up and read documentation manually.

I visited kaggle and saw many data science projects and started to learn. Then proceeded to build my own machine learning projects.

I packaged all these projects and put them in my cv and started applying for jobs.

I got 5 job offers in the space of 1.5 months. Did many interviews, can't even remember how many.

Fast forward to today, I've grown and had multiple promotions - now earning close to 150k aud.

My advice to those starting out is to not spend too much time on tutorials. The best way I learnt quickly was to apply the knowledge by actually building stuff.

Apart from the technical skills, you also need need presentation skills, people skills (very important in the Australian corporate culture), story telling skills, etc.

I can't go in-depth. But like other people have mentioned, never give up. In those 3 months I spent building things, I never went out. I only go to the office, come back home and continue from where I stopped. I even used to take my personal laptop to work so I could continue learning and building during my lunch break.

It paid off big time!!!

Omotaday:
Interesting, this great thread seems to be fading.

For me, it all started here, and now I’m a BI developer working outside Nigeria. Thanks to Ejiod and other early contributors.

I wil say one thing, Data analytics or Business Intelligence is not just about dashboards. In the Nigeria tech space, I have noticed that people seem to overlook data modelling (Fact & dimensions, star schema, snowflake) which is part of the most important knowlege when working with data and it's likely to come out during interviews. As a data analyst, your data won't always come from a single table, you could have 10 tables with million of rows just for a report, how do you connect them? To that effect, I will encourage new comers to glance through this topic as they navigate their journey in the field.

-------------------------
CC: Ejiod, Cochtrane, AnalysisGuru, Hamzatfresh, Mcemmy0z, Abcruz, Heyf, Toppytek, Kaycee54321, DHaran, Hinokami, VicUkegbu, T4kbaba, Kunleiky, Nazgul

TMwise1942:
I want to install excel on my PC any help

Omotaday:
Interesting, this great thread seems to be fading.

For me, it all started here, and now I’m a BI developer working outside Nigeria. Thanks to Ejiod and other early contributors.

I wil say one thing, Data analytics or Business Intelligence is not just about dashboards. In the Nigeria tech space, I have noticed that people seem to overlook data modelling (Fact & dimensions, star schema, snowflake) which is part of the most important knowlege when working with data and it's likely to come out during interviews. As a data analyst, your data won't always come from a single table, you could have 10 tables with million of rows just for a report, how do you connect them? To that effect, I will encourage new comers to glance through this topic as they navigate their journey in the field.

-------------------------
CC: Ejiod, Cochtrane, AnalysisGuru, Hamzatfresh, Mcemmy0z, Abcruz, Heyf, Toppytek, Kaycee54321, DHaran, Hinokami, VicUkegbu, T4kbaba, Kunleiky, Nazgul

Toppytek:
Hmmm congratulations boss, I have not really been following the thread since I transitioned from Data thingy to Backend development, I learnt Django, then Dart/flutter but no opportunity until I was referred to a fintech company in order to work on Linux POS Terminals using c programming language, that didn't go far as well, I had to transitioned to Java backend, and that is what am doing till today using Spring framework...