Her Data Project

Guided data analysis projects
YouTube -

[Her Data Project @herdataproject]

If you’ve ever connected PowerBI to a database, (I’ve only done this with Microsoft SQL Server), you might have encountered the choice between Import and Direct Query modes.

Here's an article that simplifies the differences
https://t.co/SmbA3leusB

[Her Data Project @herdataproject]

Measures, on the other hand, are calculations performed on the fly based on the data in the visualizations, often using functions like SUM, AVERAGE, or COUNT. They provide dynamic and interactive insights into your data. #PowerBI #DataAnalysis

[Her Data Project @herdataproject]

Power BI allows users to create calculated columns and measures. Calculated columns are like regular columns in a table, but their values are calculated based on a formula that can reference other columns in the same table. #PowerBI #DataAnalytics

[Her Data Project @herdataproject]

In summary, the order of operations is:

- WHERE clause filters records.
- GROUP BY clause groups the filtered records.
- HAVING clause filters the grouped records.

Learn more by doing this project
https://t.co/7gIynYtvgV

[Her Data Project @herdataproject]

Difference between WHERE and HAVING clauses.

WHERE clause is used to filter records before any groupings are made, while HAVING clause is used to filter records after the grouping has occurred.

Here's an example query >>

[Her Data Project @herdataproject]

3. The HAVING clause is applied after the GROUP BY clause, filtering out departments that have fewer than 5 employees.

[Her Data Project @herdataproject]

Difference between DELETE and TRUNCATE statements?

DELETE statement is used to delete rows from a table based on a condition, while TRUNCATE statement is used to remove all rows from a table, but the table structure and its columns, constraints, indexes, etc., remain unchanged.

[Her Data Project @herdataproject]

If you're looking to learn how to do data cleaning using #python, check out my latest video
https://t.co/lL4GMzAb47

I clean the FIFA21 dataset using #numpy and #pandas library.
#dataanalysischallenge

[Her Data Project @herdataproject]

Scholarship Alert!!
@DataCamp and @ishango_ai
Apply Now!!

DataCamp Donates x https://t.co/ZM1SO1K3YM Application Form
https://t.co/R0T7OIp3eX

#Scholarships #DataScience #DataAnalytics

[Her Data Project @herdataproject]

You will learn data cleaning using #SQL , how to use subqueries, aggregate functions and so much more and then finally visualize query results with #PowerBI

[Her Data Project @herdataproject]

Here's an SQL+PowerBI project for anyone looking to upskill or get inspiration for their next project.
https://t.co/KxRfhfwzR6

Retweet and share widely to help other people
#DataCleaningchallenge #DataAnalytics #PowerBI #SQL

[Her Data Project @herdataproject]

SCHOLARSHIP ALERT!!!
Learn Cybersecurity and how to build a career in it for FREE. Powered by @Ingressive4Good and @CiscoNetworking
Apply here- https://t.co/UYp0oyrCtf
Applications close on 16th April 2023
#IngressiveForGood #I4G #AfricanScholarships #I4GCybersecurityScholarship

[Her Data Project @herdataproject]

I've got a data analysis addiction. It's a serious line of regression. #DataAnalytics

[Her Data Project @herdataproject]

Data Analysis tip!!

Always start with a clear question or objective in mind. This will help guide your analysis and ensure that you are focusing on the most relevant data and insights.
#66daysofdata

[Her Data Project @herdataproject]

Data analysis is a lot like cooking - you need the right ingredients, the right tools, and a good recipe to follow. And sometimes, you end up with a little bit of a mess.

[Her Data Project @herdataproject]

Data cleaning may seem like a mundane task, but it's crucial for accurate analysis and decision-making. Take the time to clean your data properly, and you'll avoid costly errors down the line #DataCleaningchallenge

[Her Data Project @herdataproject]

Data cleaning is a repetitive process. You may need to repeat some of these steps several times until you are satisfied with the quality of your data.

Follow @herdataproject for more tips!!
Like and retweet.

[Her Data Project @herdataproject]

As you prepare for the #DataCleaning challenge by @PromiseNonso_ here is a #DataCleaning checklist:
A thread

[Her Data Project @herdataproject]

8. Document the cleaning process - Keep track of all the changes you make to your data during the cleaning process. Makes it easier to reproduce your results and understand the limitations of your analysis.