Dataknight
@DDataknight
Followers
8,223
Following
1,996
Media
839
Statuses
12,811
Explore trending content on Musk Viewer
Walz
• 3903196 Tweets
YouTube,YouTube
• 2845417 Tweets
Minnesota
• 1242229 Tweets
Vance
• 618468 Tweets
Minneapolis
• 443520 Tweets
Shapiro
• 439558 Tweets
National Guard
• 345861 Tweets
Iraq
• 298366 Tweets
Alberto
• 205549 Tweets
#TamponTim
• 195372 Tweets
Espanha
• 164155 Tweets
Tampons
• 150391 Tweets
Drake
• 139149 Tweets
Fabiola
• 111828 Tweets
Philadelphia
• 111507 Tweets
Marta
• 105526 Tweets
Philly
• 79632 Tweets
Marco Verde
• 51936 Tweets
Lorena
• 44954 Tweets
Alexia
• 36315 Tweets
#ラヴィット
• 29735 Tweets
MIND YOUR OWN DAMN BUSINESS
• 26025 Tweets
Sterling
• 22416 Tweets
Montse Tomé
• 17353 Tweets
Arthur Elias
• 17138 Tweets
#YanındayızKerem
• 15374 Tweets
Brahim
• 12891 Tweets
Kellie Harrington
• 12848 Tweets
スキャンダル
• 11412 Tweets
バナナの日
• 10664 Tweets
Google is offering free learning path for the following skills:
Cloud Engineering Data Path
Data Engineering Learning path
Data Analyst learning path
API dev learning path
*copied
80
2K
4K
Dear Hiring Manager
Trust this email finds you well
I am just checking in to see if there
were any updates on the job position I interviewed for.
I’m still interested in the position and I hope to hear back from you soon.
Regards.
17
581
3K
Here we go
Data Analyst -- Airline servicing ✅
People Analytics -- Banking ✅
people Analytics -- FMCG
Same role, different industry, New challenge.
Glory to God
74
97
1K
That 3 hours course is 3 - 4 years of experience.
Don't be so quick to complete a course, learn.
Note to self.
33
280
1K
Hard truth is you can't run away from Statistics if you are really doing Data Analytics.
39
122
724
Just signed a contract to teach SQL and People analytics (Excel, HRSS, Total rewards reporting) to a group of Data Analysts and HR Pros.
cheers to many long Saturdays ahead.
40
30
525
A beautiful 3 month of learning Data analytics with the guys at DevPartners came to an end today and I am really proud of what the learners have achieved in that short time.
I have displayed in the thread below projects done by some of the learners using Microsoft excel.
40
47
444
Never forger these order:
1. SELECT
2. FROM
3. WHERE
4. GROUPBY
5. HAVING
6. ORDERBY
Having comes in when you are filtering an aggregated column.
#SQL
14
90
389
It is one year since I got my first Data Job
Skills learnt on the job
1. Power apps
2. Power automate
3. Stakeholder management
4. Proper record keeping
5. Good mail etiquette
To mention a few.
13
68
392
I don't think any person can cram all the DAX functions available in PowerBI, but what everyone should know is that there are about 250 functions used in DAX and your ability to use them is dependent on your knowledge of the use case.
See DAX guides below ⬇️⬇️
22
124
391
2 resourceful web page to download Icons for PowerBI/PowerApps
1.
2.
18
117
363
♟Descriptive Analytics: Total number of employees, attrition rate, salary per grade.
♟Diagnostic: why are employees exiting the organization, how does employee pulse survey affect performance, is there a relationship between promotion/incentive and performance
9
99
342
Have you just finished a SQL course from datacamp,Mode, or Google? If yes, train those muscles with the beginner exercises on leetcode.
Join me in the 10days of leetcode basics
1/10
18
97
318
An awesome end - to - end data analytics project you can try out.
Drafted 18 questions that can be answered from our derived tables. So, pull out your fav viz tool and let's analyse.
step by step ELTL process :
Github:
* Webscraped data from 5 football leagues(scores, standing) **automated to run every weekend
* automated upload in AWS S3 with time stamps
* Transformed data in keboola using python
* loaded into a sql server
Found keboola after airflow frustrated me😆
gracias
@Opiano_1
11
10
81
3
88
310
Your Github can be a portfolio. Be you a Data analyst, Data scientist or Data engineer.
Customize a catchy page by adding links, gifs, images and thumbnails from other portfolio sources.
As a beginner you do not need to have a fancy website.
18
78
270
Excelling as a Data analyst in different domains
I’m going to
@jessica_xls
’s upcoming Space. Will you join too?
8
59
268
Once you've completed this, and would love to practice with live interview dataset, please drop your email under the thread.
WEEK 2-5: EXCEL
Learn basic maths and stats functions, conditional statements and formatting, data cleaning, lookup functions, charts, and dashboard building in Excel.
All of the videos below are beginner friendly and will help you master the Excel tool.👇🏽👇🏽
58
512
2K
121
70
249
Job role: People Analyst
Industry: Finance.
Pay range: 600-750k ngn.
Experience: 2-4yrs with managerial experience
Technical requirements: Microsoft PowerPlatform , statistics.
Send a dm
10
114
226
Interviewer: How has Data science helped you in your current role.
Me: Results of surveys I send out to employees are run though an NLP model to
1. Filter out unnecessary texts.
2. Perform Text analytics.
3. Identify sentiments.
#DataIsEverywhere
4
36
211
Find an interesting course on Coursera and it's expensive? why not apply for financial aid. In 2 weeks, if approved you get to study for free. Not a rigorous application if you ask me, just fill it appropriately and be sure to get approved for study.
11
50
204
Taking this time to brush up my core Data analytic skills
#Excel
#PowerBI
#Sql
#Python
#PowerApps
#PowerAutomate
Learning
#DataModelling
#ETL
#DataWarehousing
(cloud)
I want to focus on being a senior other than waste time learning unrelated tools/skills
7
40
195
Set a reminder for my upcoming Space! with co-host
@GiftOjeabulu_
It's gonna be mind blowing.
Learn Data analytics, Data Engineering, Ml the right way.
I will update the profiles of the professionals that would speak under this thread.
23
102
196
Challenge By:
@MavenBI
Link to challenge:
tool used: SQL, PowerBI, PowerPoint
Link to sql query:
20
34
200
Data Viz Challenge
Tool used: PowerBI
Dataset: USA outbound flight 1990-2021
Dax challenge: Calculating Moving Averages.
Color used on Map: Divergent max (Tomato red) lol
12
34
200
I was today year old when I learned another use of the Coalesce DAX function.
= COALESCE(SUM(FactInternetSales[SalesAmount]), 0)
the function converts all values that return "Blank" to "0" or any other assigned value. Having Blanks in a report is distracting.
19
55
191
If Sql is that easy, why then do people fail SQL tests in interview?
39
24
178
Learning on the Job is a real thing. No harm in that.
Came here knowing Just Excel and PowerBI, Rn I have added Power Apps and Power Automate to the stack.
Albeit, I can't say that is my strong skill asset but I've got enough knowledge to go by.
#AlwaysaStudent
8
59
172
Since Ore came into my DMs asking about SQL I have been all about it. Just got the Hackerrank Advanced
#SQL
certification.
12
13
172
The reason why you are most likely feeling overwhelmed rn is because you are learning anyhow(unstructured learning).
What are your learning objectives? and what are your learning goals?
Pros and newbies alike. I mean even for entry level jobs pros still feel nervous and...
13
49
159
A little knowledge is a dangerous thing.
If you must learn it, learn it, and learn it well
📝 to self.
4
40
144
Class today...
"Greatest tool for a DA is his Head"
The analytical mindset
11
11
142
No 5 got me thinking and relates to an earlier tweet I made.
6
35
136
It took me a bad interview to know that Data analytics is more than visualization. Visualization is actually a beautiful distraction. Thank God I wasn't interviewing for Microsoft. Another technical distraction is wanting to become every thing data has to offer...
12
37
135
Ready to take your PowerBI game to the next level??
Join alejandro in the PowerBI week as he builds his ever-amazing dashboard. Join, and take the lessons before they expire. The lesson will cover the seven pillars highlighted in the image below.
2
45
131
Webscrape Spotify's data using the Spotipy python library
Read full article here:
14
23
137
Excel is great, but I need to plug in my dashboard to PowerApps.
PowerBI leads again.
No competition between the two great tools but what is with the unnecessarily long formulas in Excel?🫤
19
25
127
Data analysts looking to explore the AFCON data, I may just have something for you. Please let me know which other country data you would like added to the pipeline.
#MicrosoftFabric
13
25
128
Analysts don't get paid to analyze data.
They don't get paid to design dashboards, draft measurement plans, or build data models either.
That's WHAT an analyst does, but it's the WHY that matters.
Think about it...
WHY do you create reports and dashboards?
5
30
127
@wizkidayo
too much noise about this
#Manya
song. Had to listen and I must say, Wizzy issa talent
1
17
103
Role: Business performance Analyst
Sector: Banking
Age: <=25yrs
Exp: 0-1yr
Please send CVS to
22
67
117
Data modeling is one of the Basics about Data Analytics
Join the class now
With
@AhmedOyelowo
@TheOyinbooke
2
31
111
Who are People Analysts, what tools do they use and how do they use people data to make informed business decisions?
These group of people are mostly found in the HR department of big organizations and they are custodians of employee data..
What are their functions?
🧵
4
38
108
Working with DateTime in SQL
EXTRACT (YEAR FROM date) AS Year
EXTRACT (MONTH FROM date)
EXTRACT (DAY FROM date) AS Day
DATE_TRUNC('day', date) AS day
DATE_TRUNC('minute', date)
7
38
99
A good pitch for your next interview, will be having in your portfolio a project that goes through the full cycle of Extraction, transformation and loading.
This time not with Python or R but with Power Query.
see how to here:
7
26
103
Do you need to be a Jack of all trade to Land a Job in Data Analytics?
Are we fast losing proficiency in a tool because we don't want to be caught slacking?
@AhmedOyelowo
is a pro in PowerBI
@DavidAbu_
is a pro, made a name in PowerBI
@TheOyinbooke
made a name in Power Automate
7
48
102
Always remember you are not only paid to describe data. You are paid to also
1. Use data to make better informed, fact-based decisions
2. Help your business understand its customers and market
3. Use data to offer smarter services and more intelligent product
⤵️⤵️
3
35
94
Tools and skills are getting a little complicated but please, Data/BI Analytics skills are still very much valid.
Check out these Analyst roles
1. People and Process Analysts(HR folks)
2. Financial model analyst
3. Geospatial Analyst
4. Marketing/ad analyst (check google jobs)
6
23
87
Check out Danny Ma 8 week SQL course
4
28
84
I intend to build a dashboard app that runs on the following tech stack:
Dagster: Data pipeline
DBT: Transformation
DuckDB: Database
Dash: Dashboard
Deployed on Docker or AWS
😂😂 Crazy but doable. Hopefully I get to do it 🤞.
Let's collaborate if you want to.
21
10
88
HR enthusiasts interested in analytics (People Analytics) should cop the course on people analytics from coursera. This goes beyond just 'Attrition models' and 'data keeping' it explains analytics in core HR practices. Link to the course...
8
33
85
I acquired HSE 1-111, PMP, First aid, CPR, and all the other NYSC inspire to perspire certificates and thought I was doing myself a favor.
Rubbish.
38
12
88
Taking hints on a Datacamp course is cool but getting addicted to 'show answers'😵
Deliver me oh lord and touch my brain 🤲
20
7
84
Colors will either mar or liven your dashboards/reports.
Do you worry a lot about color combination, and go hard on yourself because you know only the primary colors?
Worry no more, these cool websites have got you covered.
Copy the Hex or use the paint brush of your viz tool.
4
33
84
* Webscraped data from 5 football leagues(scores, standing) **automated to run every weekend
* automated upload in AWS S3 with time stamps
* Transformed data in keboola using python
* loaded into a sql server
Found keboola after airflow frustrated me😆
gracias
@Opiano_1
11
10
81
MD wants to see my app😲
God abeg🙏
Microsoft Powerapps wants to get me the promotion☻
16
6
74
@MrOdanz
Conspiracy theories have a way of building itself around facts. Some are true, some aren't. Let's just be open about it After all we can only decide in a few years time if China planned it all or it's a devil's curse.
1
9
72
Love every chapter
Functions, lists, dictionaries, data types all coming together into a beautiful whole.
13
13
64
Full sql case study
3
20
63
I need help replicating this query in SQL
On the Right is the result in POWERBI and on the left is the DAX.
Main issue is, I am looking for a workaround to the LASTDATE function in SQL
11
19
68
Spice up your analysis with rates.
E.g if a city has 80 vehicles thefts and a population of 15,000 you can calc d rate of vehicle thefts per 1000 people as follows
(80/15000)×1,000=
5.3 vehicle thefts per thousand residents.
4
6
67
Project going on well.
PowerBI Dashboard on PowerApps.
I wanted a report where I can easily navigate pages but turns out I could only import a dashboard.
Difference between a Dashboard and a Report -- A dash is viewed on One page while a Report can have any number of pages.
5
6
61
Nuggets from the movie
#Anikulapo
1. When a woman loves you, she loves for real.
2. When you betray that trust, and she leaves you, she leaves for real.
3. Women don't simp, they make sacrifices
6
4
61
I am looking for a PowerBI developer to take a one-off PowerBI class on saturday and sunday 3rd & 4th December respectively.
Pay: 45 USD
Day/Time: Saturday 10am - 2pm (physical)
& Sunday 3pm - 5:30pm (virtual)
Send me dm and expect a reply today.
14
31
56
I believe using Job specific vocabularies helps you articulate better and vaunts your communication skills.
Instead of saying
"I CARRIED data from the Azure sql warehouse"
A better vocab would be
"I MIGRATED data from..."
Check out some easy vocabs below and add yours.
8
23
59
@OgbeniDipo
You always somehow seem to leave your fingerprints on every tribalistic topic and attack. It interests you a lot
6
1
53
Many of us have dwelled too much on the wins of yesterday. An arrival mentality has crept in, and we no longer pressure ourselves to learn and grow, thereby impairing our potential for growth.
Nobody claps twice for you over the same thing.
4
22
53
It's going to be one year with
@AltSchoolAfrica
🤔
What's there to lose? Besides, Cloud computing is making data analytics and data management more simpler for Data scientist.
I'll join the clique.
5
6
52
If you're finding it difficult to stay motivated and have noticed a decrease in your productivity, it might be helpful to focus on improving your time management skills. By learning effective time management techniques, you can enhance your productivity and regain your motivation
2
14
52
We will be awarding a cash prize of 100,000 naira and hiring three graduates as interns for data analytics at the upcoming graduation ceremony this month.
I am incredibly proud of what we have accomplished.
A beautiful 3 month of learning Data analytics with the guys at DevPartners came to an end today and I am really proud of what the learners have achieved in that short time.
I have displayed in the thread below projects done by some of the learners using Microsoft excel.
40
47
444
2
2
51
*information as gotten from an ex employee.
IHS is global. You can check their official website for vacancies specific to your region.
4
12
50
Good things happen to, and for me.
Great opportunities come to me easily & effortlessly.
I have the grace & strength to give my best to & get the best out of every opportunity I get.
I have the spirit of excellence & life gives her best to me.
Everywhere I go, I find favour.
0
9
50
Remember sterling is hiring an entry level Data Scientist, and I am sure other sponsors and recruiters will be on the look out.
However, you can pull a Haaland--a brace or an hat trick even
I heard you guys are coming to
#DataFestAfrica22
to look for fine data bros and data sis. Make sure you don’t lose focus 😎😎.
9
5
58
5
11
51
Vacancy!
Hi everyone, looking to hire an excellent data analyst at Seven Up.
Location: Enugu
Please send your CV to careers
@sevenup
.org if you're interested and someone on the team will reach out to you.
7
36
51
wow...was robbed today at computer village.
Two hoodlums waylaid me on the road, and instinctively, I positioned to defend myself. A scuffle ensued, lasting for about a minute with a few shoves here and there. I thought I had done my village people proud, but little did I know...
48
5
47
Fr Fr
M-code, Dax measures, Data Modelling, power query, and a million other API connections
4
13
49
A Matrix or Table visual in PowerBI
Use Case
Your supervisor wants a reports where he can drill down to see the revenue of each Salesperson by Year/Quarter/Month/days(if available), which of the two visuals will be most appropriate?
17
7
47
Dear 9-5ers.
This week, avoid taking any tasks home. You have 9 office hours to handle all of them.
Cut the unnecessary chit chat with office bae and finish your To-do's
8
9
46
Tech skill dev at the local church
@DavidAbu_
inspired this.
2nd pic: Relaxing moment with the guys after a good morning
5
4
45