DASHBOARD #powerbi #data #dataviz #dax

TRANSFORMING DATA Power query editor cleans data faster and handles larger datasets. #data #powerbi #powerqueryeditor

DATA VISUALIZATION It effectively represents data and communicates information clearly and efficiently through graphs, charts, plots, and other visual aids. One of the many data visualization tools available is POWER BI. #data #powerbi #dataviz

POWER QUERY EDITOR #data #excel #excelseries #spreadsheet #powerquery

POWER QUERY AND POWER PIVOT Power query imports (by extracting, transforming and loading) the data while with Power Pivot we create relationships, explore (using DAX) and visualise the data #excel #data #excelseries #spreadsheet #powerpivot #powerquery

DASHBOARD Today, I made an interactive sales dashboard of a fictional company. #excel #data #excelseries #spreadsheet

NESTED FUNCTION IF + AND IF + OR IFS + OR These and others allow to combine multiple functions in Excel to perform several calculations in a go. #excel #data #excelseries #spreadsheet

NESTED FUNCTION I used the IFS+ AND logic functions to give remarks to each patient's blood pressure reading based on JNC-7 classification. #excel #data #excelseries #spreadsheet

DATA CLEANING II #excel #data #excelseries #spreadsheet

PIVOT TABLE It summarises, calculates and analyses numerical datasets so that trends and patterns are easily seen especially when working on a large dataset. #excel #data #excelseries #spreadsheet

ADVANCED CHARTS Using the same dataset from the Bullet chart, I decided to visualize the data in a Combo Chart. This chart effectively combines both line and column charts. #excel #data #excelseries #spreadsheet

ADVANCED CHARTS The Waterfall Chart illustrates the net value change between two points. Financial data can be effectively visualized with this chart, as it provides a detailed breakdown of a company's expenses and profits. #data #excel #excelseries #sheets

ADVANCED CHART A scatter plot observes the correlation between two numeric variables. It is also useful in identifying patterns in data. The relationship between the variables could be linear or non linear, positive or negative, strong or weak. #excel

ADVANCED CHART I explored the column chart to show/depict the progress made by each sales representative. #excel #data #excelseries #spreadsheet

CUSTOM TABLE OF CONTENT Navigating sheets within a workbook can be a lot so I linked the sheet to the first page so all I need to do is click the sheet I am interested in. #excel #data #excelseries #spreadsheet

SHEET PROTECTION It maintains the integrity and privacy of the dataset by preventing others from changing, moving or deleting important data #data #excel #excelseries #spreadsheet

If you like after learning with 1 and doing project with 2 Don’t post it Nobody will see it in your computer Post it and tag me to it I will surely repost all and it will help you get feedbacks and visibility🔥 1 2

DATA VALIDATION I find data validation a very helpful tool especially in Data collection. It helps to ensure accurate and consistent data and reduces the burden of data cleaning. #excel #data #excelseries #spreadsheet

Happy World Pharmacists Day.❤️

I didn't plan for this so it came late and unfinished. Anyway, it's still the 25th of September so Happy World Pharmacists Day 🌍💊. Cheers to all the amazing Pharmacists out there 🥂