Mbakwe Chidera (@SleekQueency) header
Mbakwe Chidera (@SleekQueency) profile picture

Data Scientist ✍️ Machine learning engineer ✍️ Data analyst ✍️ infact everything DATA 🥰🥰I wake up and sleep with DATA

Nigeria
Joined February 2016
Photo by Mbakwe Chidera (@SleekQueency)Photo by Mbakwe Chidera (@SleekQueency)Photo by Mbakwe Chidera (@SleekQueency)Photo by Mbakwe Chidera (@SleekQueency)Photo by Mbakwe Chidera (@SleekQueency)Photo by Mbakwe Chidera (@SleekQueency)Photo by Mbakwe Chidera (@SleekQueency)Photo by Mbakwe Chidera (@SleekQueency)Photo by Mbakwe Chidera (@SleekQueency)Photo by Mbakwe Chidera (@SleekQueency)
This is how i export my visualizations from Excel or Power BI without making it blurry: - Export/Save your visual as PDF - Go to ilovepdf.com - Select the option of PDF to JPG image - And download(Select High Quality), enjoy your high quality image When you post on twitter, long press or click the option button to load the image in 4K for better quality Are there any other methods you know?
8
34
1
113
6,806
Technology has actually become insaneeeee! People who died 20 years ago will not believe the kind of witchcraft that is currentlyunraveling. Also, this is one tech that can take all my money.
193
1,513
243
3,913
205,441
This is an example of one of the reasons for this survey. Here is link to the survey: forms.office.com/e/TgJMZweB3… Will take you less than 60 seconds to complete. This project is open to collaboration from fellow analysts, data professionals and general public. Send in your responses 🤍 Please make sure to retweet and share.
how can you say 4M naira monthly is a small money what’s going on in this app gan? 48M yearly oh 😭😭
6
14
2,262
Mbakwe Chidera retweeted
Get this ebook for your SQL practice if you have not already done so. 135+ business cases with solutions. To get your copy: 📌Retweet 📌Like & reply "yes" 📌Follow 📌DM me your email
563
580
5
1,038
165,903
Mbakwe Chidera retweeted
If you’re looking for a REMOTE JOB, I have collated over 40 COMPANIES/AGENCIES that are HIRING NOW, All these companies are hiring REMOTELY. Apply, RT and tag anyone looking for a remote job.
57
847
7
2,001
419,612
Trying to learn Power BI? The fastest way is by building projects! I have datasets on each of these different kinds of analysis using Power BI. All you got to do is comment the one you need, and I will provide it. Sales Performance Dashboard in PowerBI: - Tracking sales KPIs, conversion rates, and pipeline analysis. - Implementing drill-down features for detailed sales rep performance. - Visualizing regional and product-wise sales trends. Supply Chain Analytics with PowerBI: - Creating a supply chain dashboard for inventory management. - Monitoring supplier performance and lead times. - Using predictive analytics for demand forecasting. Human Resources Analytics in PowerBI: - Designing HR dashboards for workforce planning and diversity analytics. - Visualizing employee turnover rates and retention strategies. -Utilizing sentiment analysis for employee engagement. Marketing Campaign Analysis with PowerBI: - Measuring the effectiveness of marketing campaigns. - Analyzing customer acquisition costs and ROI. - Creating a dashboard for tracking social media engagement. Energy Consumption Analysis with PowerBI: - Building dashboards for monitoring energy consumption patterns. - Implementing real-time analytics for energy efficiency. - Visualizing trends in renewable energy production. E-commerce Analytics in PowerBI: - Creating a dashboard for tracking online sales and customer behavior. - Analyzing product popularity and conversion rates. - Implementing cohort analysis for customer retention. Project Management Dashboard with PowerBI: - Monitoring project timelines, milestones, and resource allocation. - Utilizing Gantt charts for visual project planning. Implementing risk analysis and mitigation strategies. Let's go!!
154
170
4
492
82,758
In my OPINION, as a DATA ANALYST you don't need to overwhelm yourself to learn SQL. You only need this much: 1. Intro to SQL - Definition - Purpose - Relational DBs - DBMS 2. Basic SQL Syntax - SELECT - FROM - WHERE - ORDER BY - GROUP BY 3. Data Types - Integer - Floating-Point - Character - Date - VARCHAR - TEXT - BOOLEAN 4. Data Definition - CREATE - ALTER - DROP - Indexes 5. Data Manipulation - INSERT - UPDATE - DELETE 6. Query Filtering and Sorting - WHERE - AND - OR Conditions - ORDER BY (Ascending) - ORDER BY (Descending) 7. Data Aggregation - SUM - AVG - COUNT - MIN - MAX 8.Joins and Relationships - INNER JOIN - LEFT JOIN - RIGHT JOIN - FULL OUTER JOIN 9.Subqueries - Subqueries used in filtering data - Correlated Subqueries 10. Views - Creating - Modifying - Dropping Views 11. Advanced SQL Queries - Window Functions - Common Table Expressions (CTEs) 12. Data Import and Export - Importing and Exporting Data (CSV, JSON) 13. Database Design - Entity-Relationship Diagrams (ERDs) - Normalization Techniques 14. Data Integrity - Primary Key - Foreign Key 15.Optimizations - Query Optimization And you don't need to master them in one year! All you need to do is constantly learn and practice on it with real projects. This will improve your skills and also increase your ability to solve problem with the tool. Also, I teach SQL and I have a 1 Month class coming up, it's not expensive. Kindly send me a DM for more details.
35
188
19
599
65,272
Excel functions you should know when upskilling -Data manipulation -Data cleaning functions -Sorting and filtering -Conditional formatting -Aggregate functions -Removing duplicates -Vlookup -Xlookup -Power Query -Pivot table
1
17
30
1,691
Data storytelling steps Step 1 - Define the Objective └── Key Tasks └── Identify the purpose of the data story ├── Determine the target audience └── Establish the key message to convey Step 2 - Gather Data └── Key Tasks ├── Collect relevant data sources └── Ensure data quality and accuracy ├── Organize the data for analysis Step 3 - Analyze Data └── Key Tasks └── Apply statistical methods ├── Identify patterns and trends └── Use data visualization techniques Step 4 - Structure the Story └── Key Tasks └── Create a storyline ├── Decide on the narrative flow └── Select the most effective visualizations Step 5 - Craft the Visuals └── Key Tasks ├── Design engaging charts and graphs └── Choose a color scheme for clarity └── Incorporate relevant images or illustrations Step 6 - Present and Share └── Key Tasks └── Prepare a compelling presentation ├── Tailor the delivery to the audience └── Encourage interaction and feedback
I just published a new article on the topic: From Numbers to Narrative: A Step-by-Step Guide to Data Storytelling Very important for every data professional! Check it out here: medium.com/@Splendor001/from…
35
1
101
5,936
Few examples of the different type of Analysis you might meet on your job: Financial Analysis └── Budgeting └── Monthly Budget Tracker │ └── Expense Analysis Report └── Investment Analysis └── Stock Portfolio Performance ├── ROI Calculation for Projects Sales Analysis └── Sales Performance Dashboard └── Monthly Sales Report ├── Sales Forecasting Model └── Customer Segmentation └── RFM Analysis ├── Market Basket Analysis Marketing Analysis └── Campaign Performance Analysis ├── ROI of Marketing Campaigns └── Customer Acquisition Cost Analysis └── Social Media Engagement Analysis ├── Engagement Rate Tracking └── Competitor Analysis Dashboard HR Analysis └── Employee Turnover Analysis ├── Attrition Rate Calculation └── Retention Strategies Evaluation └── Performance Appraisal Analysis ├── Performance Score Distribution └── Skill Gap Analysis Operational Analysis └── Inventory Management Analysis ├── Inventory Turnover Ratio Calculation └── Stockout Analysis └── Production Efficiency Analysis ├── OEE Calculation (Overall Equipment Effectiveness) └── Downtime Analysis
12
83
4
225
36,298
Mbakwe Chidera retweeted
Some of the outstanding Data Science certifications to consider if you are just starting out: 1. SAS Certified Data Scientist 2. Certified Data Science Professional (CDSP™) 3. IBM Data Science Professional Certificate
3
57
190
21,983
Mbakwe Chidera retweeted
Languages for Data Professionals Query languages: are designed for accessing and manipulating data in a database (SQL) Programming languages: are designed for developing applications and controlling application behavior (Python, R, Java) Shell and Scripting languages: are ideal for repetitive and time-consuming operational tasks (Unix/Linux Shell, PowerShell).
5
15
57
3,321
Do you want to learn SPSS from the basics for DATA ANALYSIS and RESEARCH ?…. Here is the perfect playlist to get you started ⬇️ youtube.com/playlist?list=PL… Kindly retweet, like, follow and THANK ME LATER🥰
2
79
162
13,195
Over the last few days I’ve interviewed over 15 people seeking an internship role in data analytics and here are some very important tips to learn when attending an interview 🧵
23
79
302
37,232
Mbakwe Chidera retweeted
Learn Excel- done ✅ Learn Power BI/Tableau -done ✅ Learn SQL - done ✅ Do projects (few done) although those few are not enough… keep doing.✅ Then…….? This the stage most people give up on the journey. No interview, no opportunities are coming… See, go back to that learning and keep improving yourself. Get some industry trusted certifications. Yes certifications could help you put at least a foot in the door… Other things you must check at this stage is evaluating your CV is it passing through the ATS with a good score? What do you have in that CV? Get someone to check it out if you can’t figure it out yourself. Getting interviewed and not passing: that’s a stage everyone mostly go through, so give it time. But if you’re feeling your interviewing skills are lacking, watch several free training on YouTube it changed the way I get into interviews. Plus be patient. It will come if you persist.
14
48
147
10,208
4 websites to learn SQL for free:
3
121
2
468
62,728
Best YouTube Channels To Learn… Cybersecurity - John Hammond Networking - David Bombal Linux - Learn Linux Tv Python - Code With Harry React - Codevolution UI/UX - GFXMentor JavaScript - Traversy Media Java - kunal kushwaha DevOps - Techworld with Nana Blockchain - Telusko AI/ML- Krish Naik Web Development - Traversy Media AWS - Code With Harry
27
1,099
9
3,503
307,182
Best YouTube channels for Data Science: ❯ Python ➟ Corey Schafer ❯ SQL ➟ Joey Blue ❯ MS Excel ➟ Chandoo ❯ PowerBI ➟ Guy in a Cube ❯ Data Analyst ➟ AlexTheAnalyst ❯ Mathematics ➟ 3Blue1Brown ❯ Machine Learning ➟ sentdex ❯ Most Valuable ➟ Krish Naik
16
308
6
1,042
91,247
Every Ctrl Shortcut you need to know in Microsoft Excel 🧵 Ctrl Shortcuts (ABC) Ctrl+A > Select All Ctrl+B > Bold Ctrl+C > Copy Ctrl+D > Fill Down Ctrl+E > Flash Fill Ctrl+F > Find Ctrl+G > Go to Ctrl+H > Replace Ctrl+I > Italic Ctrl+K > Insert Hyperlink Ctrl+L > Create Table Ctrl+N > New Workbook Ctrl+O > Open Ctrl+P > Print Ctrl+Q > Quick Analysis Ctrl+R > Fill Right Ctrl+S > Save Ctrl+T > Create Table Ctrl+U > Underline Ctrl+V > Paste Ctrl+W > Close Ctrl+X > Cut Ctrl+Y > Repeat Ctrl+Z > Undo
9
296
8
609
58,233