Mbakwe Chidera retweeted
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?
Mbakwe Chidera retweeted
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.
Mbakwe Chidera retweeted
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.
Mbakwe Chidera retweeted
I just published a new article on Medium:
How Data Analytics is Redefining Traditional Businesses
medium.com/@Splendor001/how-…
One for every data person and business both small and large.
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
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.
Mbakwe Chidera retweeted
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!!
Mbakwe Chidera retweeted
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.
Mbakwe Chidera retweeted
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
Mbakwe Chidera retweeted
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…
Mbakwe Chidera retweeted
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
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
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).
Mbakwe Chidera retweeted
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🥰
Mbakwe Chidera retweeted
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
🧵
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.
Mbakwe Chidera retweeted
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
Mbakwe Chidera retweeted
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
Mbakwe Chidera retweeted
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















