<?xml version="1.0" encoding="UTF-8"?><rss xmlns:dc="http://purl.org/dc/elements/1.1/" xmlns:content="http://purl.org/rss/1.0/modules/content/" xmlns:atom="http://www.w3.org/2005/Atom" version="2.0" xmlns:cc="http://cyber.law.harvard.edu/rss/creativeCommonsRssModule.html">
    <channel>
        <title><![CDATA[Stories by priscilla macaulay on Medium]]></title>
        <description><![CDATA[Stories by priscilla macaulay on Medium]]></description>
        <link>https://medium.com/@tegerimac?source=rss-b6c232330051------2</link>
        <image>
            <url>https://cdn-images-1.medium.com/fit/c/150/150/0*Nb4uolp3fSnkHdbk</url>
            <title>Stories by priscilla macaulay on Medium</title>
            <link>https://medium.com/@tegerimac?source=rss-b6c232330051------2</link>
        </image>
        <generator>Medium</generator>
        <lastBuildDate>Fri, 20 Nov 2026 09:00:40 GMT</lastBuildDate>
        <atom:link href="https://medium.com/@tegerimac/feed" rel="self" type="application/rss+xml"/>
        <webMaster><![CDATA[yourfriends@medium.com]]></webMaster>
        <atom:link href="http://medium.superfeedr.com/" rel="hub"/>
        <item>
            <title><![CDATA[Real-world Case Study: Comprehensive Application of Learned Skills(WAREHOUSE SALES AND RETAIL…]]></title>
            <link>https://medium.com/@tegerimac/real-world-case-study-comprehensive-application-of-learned-skills-warehouse-sales-and-retail-1d7e76986b7b?source=rss-b6c232330051------2</link>
            <guid isPermaLink="false">https://medium.com/p/1d7e76986b7b</guid>
            <dc:creator><![CDATA[priscilla macaulay]]></dc:creator>
            <pubDate>Sat, 30 Dec 2023 14:20:21 GMT</pubDate>
            <atom:updated>2023-12-30T21:33:21.504Z</atom:updated>
            <content:encoded><![CDATA[<h3>Real-world Case Study: Comprehensive Application of Learned Skills (WAREHOUSE SALES AND RETAIL SALES)</h3><p>The warehouse and retail sales dataset is a large data containing over 30000 rolls</p><p>Understanding this dataset requires first, familiarizing with the data’s structure, identifying the variables, their types, and relationships. Exploratory data analysis (EDA) helps by visualizing distributions, correlations, and outliers.</p><p>Feature engineering, selecting relevant attributes, and cleaning data by handling missing values and outliers also contribute to comprehension. Lastly, effective visualization aids in interpreting complex information.</p><h3>To clean the data the following were done</h3><p>Handling Missing Values<br>Dealing with Duplicates<br>Outlier Detection</p><p>Remove blanks</p><p>Merged year and month to form date column<br>Handling Inconsistent Data<br>Data Validation</p><p>After which Visualizations was done using PowerBi</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/1024/1*Lqca7fOK2Mh3rhw3Vclbkg.png" /><figcaption>Dashboard showing warehouse and retail sales</figcaption></figure><p>From the dashboard the following can be observed</p><ul><li>Beer had the highest warehouse sales by Item type</li><li>2019 was seen to have the highest sales both in warehouse sales and retail sales and 2018 had the least sales both in warehouse and retail sales</li><li>CROWN IMPORT were the highest warehouse sales supplier</li><li>Liquor had the highest Retail sales by Item type followed by wine and beer</li><li>E&amp;J GALLO INC had the highest Retail sales</li></ul><h3>Current Situation:</h3><p>The warehouse sales shows higher sales in relation to the retail sales <br>Retail sales experience inconsistent product availability, leading to lost sales.</p><h3>Solutions</h3><p>Addressing the inconsistent product availability in retail sales could involve implementing a centralized inventory management system across warehouses, optimizing distribution logistics could streamline the supply chain, reducing the chances of lost sales due to stock issues.</p><p>Understanding large datasets is a process that combines domain knowledge, analytical skills, and the right tools.</p><img src="https://medium.com/_/stat?event=post.clientViewed&referrerSource=full_rss&postId=1d7e76986b7b" width="1" height="1" alt="">]]></content:encoded>
        </item>
        <item>
            <title><![CDATA[SHOPPING TREND DISTRIBUTION DASHBOARD]]></title>
            <link>https://medium.com/@tegerimac/shopping-trend-distribution-dashboard-8eca893324b5?source=rss-b6c232330051------2</link>
            <guid isPermaLink="false">https://medium.com/p/8eca893324b5</guid>
            <dc:creator><![CDATA[priscilla macaulay]]></dc:creator>
            <pubDate>Tue, 26 Dec 2023 15:29:08 GMT</pubDate>
            <atom:updated>2023-12-27T12:00:08.747Z</atom:updated>
            <content:encoded><![CDATA[<p>The dataset on shopping trends shows the following columns Customer ID	,Age	,Gender	,Item Purchased	,Category,	Purchase Amount (USD)	,Location,	Size,	Color,	Season,	Review Rating	,Subscription Status	,Payment Method	,Shipping Type	,Discount Applied	,Promo Code Used	,Previous Purchases,	Preferred Payment Method	, and Frequency of Purchases ….. a total of 19 Columns containing 3901 Rows.</p><p>In this dataset the following data analysis will be derived using Visual representation</p><ul><li>Purchase by Season and shipping mode used</li><li>What category had the highest purchase</li><li>What state had the highest purchase</li><li>Purchase by Gender</li><li>Item purchased with highest Review</li><li>Review by colour</li><li>Location with highest purchase</li></ul><h3>Data Collection &amp; Exploration:</h3><p>Begin by collecting the shopping trend dataset and exploring it. Understand its structure, variables, and relationships between data points. Identify key metrics and patterns that might be relevant to the dashboard&#39;s purpose.</p><h3>Dashboard Design:</h3><p>Based on initial insights, plan the layout and components of the dashboard. Decide on the types of visualizations (charts, graphs, maps,columns) that effectively convey the data’s story and insights to the end-users.</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/1024/1*BxathJZfGp_mdD1V4gyKTQ.png" /><figcaption>Dashboard showing shopping trends distribution</figcaption></figure><p>Link 🔗 🔗 to dataset 👇🏼👇🏼👇🏼<a href="https://docs.google.com/spreadsheets/d/1z-2qVVU_2yerKZElfWq6Heiq8SsOzQxQ/edit?usp=drivesdk&amp;ouid=107921129434739081104&amp;rtpof=true&amp;sd=true">https://docs.google.com/spreadsheets/d/1z-2qVVU_2yerKZElfWq6Heiq8SsOzQxQ/edit?usp=drivesdk&amp;ouid=107921129434739081104&amp;rtpof=true&amp;sd=true</a></p><img src="https://medium.com/_/stat?event=post.clientViewed&referrerSource=full_rss&postId=8eca893324b5" width="1" height="1" alt="">]]></content:encoded>
        </item>
        <item>
            <title><![CDATA[Crafting Informative Dashboards and Reports]]></title>
            <link>https://medium.com/@tegerimac/crafting-informative-dashboards-and-reports-d9ba52d86ba4?source=rss-b6c232330051------2</link>
            <guid isPermaLink="false">https://medium.com/p/d9ba52d86ba4</guid>
            <dc:creator><![CDATA[priscilla macaulay]]></dc:creator>
            <pubDate>Tue, 26 Dec 2023 08:08:43 GMT</pubDate>
            <atom:updated>2023-12-26T12:26:24.176Z</atom:updated>
            <content:encoded><![CDATA[<h3>CRAFTING INFORMATIVE DASHBOARDS AND REPORTS ON SALES AND PROFIT</h3><p>Creating effective dashboards involves a balance between clarity and insight. Start by understanding your audience’s needs and focus on presenting relevant data. Use clear, concise visuals, like charts or graphs, and organize information logically. Remember, less is often more – avoid clutter and prioritize key insights to convey your message effectively.</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/792/1*soDj5t7G9RdeSrqgiE8sFQ.png" /><figcaption>Sales and Profits Distribution Dashboard</figcaption></figure><p>The Following insights were gotten from the Dashboard shown above</p><p>💥 The Pie charts shows Profit by category and Region, the Category and Region with highest Profit can easily be identified</p><p>💥The 2 D Colum provide visual representation of the sales and profits by city, the city with highest sales and profits can easily be identified</p><p>💥The Map shows the states with highest sales</p><p>💥The Bar Chart shows the sales and profits by Shipping mode</p><p>Profit and sales data are crucial metrics. Also, consider using color strategically to highlight important data points and always ensure the dashboard is intuitive for your audience to navigate.</p><p>Link 🔗🔗🔗 to dataset 👇🏼👇🏼👇🏼<a href="https://docs.google.com/spreadsheets/d/15M8aWVAXlfLP5j3jLJwsCuolayYBfoDD/edit?usp=drivesdk&amp;ouid=107921129434739081104&amp;rtpof=true&amp;sd=true">https://docs.google.com/spreadsheets/d/15M8aWVAXlfLP5j3jLJwsCuolayYBfoDD/edit?usp=drivesdk&amp;ouid=107921129434739081104&amp;rtpof=true&amp;sd=true</a></p><img src="https://medium.com/_/stat?event=post.clientViewed&referrerSource=full_rss&postId=d9ba52d86ba4" width="1" height="1" alt="">]]></content:encoded>
        </item>
        <item>
            <title><![CDATA[LEVERAGING MAP AND PIE CHART VISUALIZATION TO CONVEY GEOGRAPHICAL PATTERNS AND PROPORTIONAL DATA…]]></title>
            <link>https://medium.com/@tegerimac/leveraging-map-and-pie-chart-visualization-to-convey-geographical-patterns-and-proportional-data-396b75219856?source=rss-b6c232330051------2</link>
            <guid isPermaLink="false">https://medium.com/p/396b75219856</guid>
            <dc:creator><![CDATA[priscilla macaulay]]></dc:creator>
            <pubDate>Mon, 25 Dec 2023 13:04:39 GMT</pubDate>
            <atom:updated>2023-12-25T13:04:39.678Z</atom:updated>
            <content:encoded><![CDATA[<h3>LEVERAGING MAP AND PIE CHART VISUALIZATION TO CONVEY GEOGRAPHICAL PATTERNS AND PROPORTIONAL DATA EFFECTIVELY.</h3><p>Using maps can visually represent data by showing geographic patterns, while pie charts effectively demonstrate proportional data. Maps showcase geographical variations, like regional sales or population distribution, while pie charts show parts of a whole, like market shares or budget allocations. Combining these visualizations can help convey both geographical trends and proportional data in a comprehensive manner.</p><p>Maps are excellent for displaying geographical data due to their ability to visually represent spatial relationships. They showcase patterns, distributions, and relationships across regions. Various types of maps, such as choropleth maps (using color shading to represent data), proportional symbol maps (where symbols vary in size based on data), and dot distribution maps (using dots to represent quantities), offer diverse ways to illustrate different types of geographical information.</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/1024/1*OawlE-FikQTk71bsfXPRdg.png" /><figcaption>Map showing state with sales.... The state with the largest sales can easily be identified on the map</figcaption></figure><p><strong>Pie charts</strong> work well when representing proportional data where parts of a whole need to be compared visually. They’re great for showcasing percentages or proportions of a fixed total, highlighting the contribution of each component to the entire dataset.</p><p>They’re effective in scenarios like</p><ul><li><strong>Market Share:</strong> Displaying the share of different companies within a market</li><li><strong>Budget Allocation</strong>: Showing how funds are divided among various categories.</li><li><strong>Demographic Composition</strong>: Illustrating the composition of a population by age groups or genders.</li></ul><figure><img alt="" src="https://cdn-images-1.medium.com/max/852/1*XJ-yRHhQtbSGW85swXOe2Q.png" /><figcaption>Pie chart showing state with highest sales</figcaption></figure><ul><li><strong>Survey Responses</strong>: Depicting the distribution of responses for multiple-choice question<br>To interpret data effectively from a pie chart, focus on comparing the sizes of the sectors in relation to the whole pie.</li></ul><figure><img alt="" src="https://cdn-images-1.medium.com/max/1024/1*s3M6Tm5GgqG5rTxe2JGVqw.png" /></figure><p>Larger sections represent a larger proportion of the total, while smaller sections indicate a smaller share. Be cautious with too many segments in a pie chart, as it can become visually cluttered and challenging to interpret. If precise comparisons are needed, consider using other visualizations like bar charts or tables for better clarity.</p><p>Link 🔗 🔗 to dataset 👇🏼👇🏼👇🏼👇🏼</p><p><a href="https://docs.google.com/spreadsheets/d/1coUMOT_sIXDesbPzm6uPIjqlrWGzgeN2/edit?usp=drivesdk&amp;ouid=107921129434739081104&amp;rtpof=true&amp;sd=true">https://docs.google.com/spreadsheets/d/1coUMOT_sIXDesbPzm6uPIjqlrWGzgeN2/edit?usp=drivesdk&amp;ouid=107921129434739081104&amp;rtpof=true&amp;sd=true</a></p><img src="https://medium.com/_/stat?event=post.clientViewed&referrerSource=full_rss&postId=396b75219856" width="1" height="1" alt="">]]></content:encoded>
        </item>
        <item>
            <title><![CDATA[UTILIZING HISTOGRAMS AND SCATTER PLOTS FOR INSIGHTFUL DATA VISUALIZATION]]></title>
            <link>https://medium.com/@tegerimac/utilizing-histograms-and-scatter-plots-for-insightful-data-visualization-833803376228?source=rss-b6c232330051------2</link>
            <guid isPermaLink="false">https://medium.com/p/833803376228</guid>
            <dc:creator><![CDATA[priscilla macaulay]]></dc:creator>
            <pubDate>Sat, 23 Dec 2023 19:51:27 GMT</pubDate>
            <atom:updated>2023-12-24T18:25:20.777Z</atom:updated>
            <content:encoded><![CDATA[<p>Histograms are great for displaying the distribution of a single numerical variable. They show the frequency of data within different intervals or bins, giving a visual representation of how values are distributed across a range.</p><h3>Histograms are particularly useful for:</h3><ul><li>Understanding distribution: They help visualize the shape, center, and spread of a dataset. You can quickly identify whether data is skewed, symmetric, or has outliers.</li><li>Identifying patterns: Histograms allow for spotting modes or peaks in the data, indicating common ranges or concentrations of values.</li></ul><p>On the other hand, scatter plots are excellent for exploring relationships between two variables. Each point on the plot represents a pairing of values for the two variables, allowing you to observe patterns, correlations, or clusters within the data.</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/496/1*2lYbe4-XsP-NI6lrsk1ecA.png" /><figcaption>Histogram table</figcaption></figure><h3>The diagram above shows a student dataset between a science and Art mark and it can be observed easily the student with the highest mark using a histogram</h3><h3>Scatter plots, on the other hand, are valuable for:</h3><ul><li>Showing relationships: They reveal correlations or patterns between two variables. For example, you can see if there&#39;s a linear, quadratic, or no relationship between the variables.</li><li>Outlier detection: Scatter plots help in spotting outliers or unusual observations that don&#39;t follow the general pattern of the data.</li></ul><p>Both are crucial tools in data analysis, offering different perspectives on the characteristics and relationships within a dataset.</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/728/1*kYeHkeBl583KORhPUVjMCA.png" /><figcaption>A scatter plot</figcaption></figure><p>The diagram above shows a student dataset between a science and Art mark and it can be observed easily the student with the highest mark using a histogram</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/1024/1*Qznceow_SYRKXiS7Do5wjg.png" /></figure><p>Utilizing histograms and scatter plots together can offer a comprehensive view of your data, providing insights into both individual distributions and potential relationships between variables.Histograms delve into the nuances of individual variables, while scatter plots illuminate connections or dependencies between pairs of variables, ultimately providing a holistic view of patterns and correlations within datasets.</p><p>Link to dataset <a href="https://docs.google.com/spreadsheets/d/1G3JDy5GXLNRIYxc4U1yr1YAsfFake50C/edit?usp=drivesdk&amp;ouid=107921129434739081104&amp;rtpof=true&amp;sd=true">https://docs.google.com/spreadsheets/d/1G3JDy5GXLNRIYxc4U1yr1YAsfFake50C/edit?usp=drivesdk&amp;ouid=107921129434739081104&amp;rtpof=true&amp;sd=true</a></p><img src="https://medium.com/_/stat?event=post.clientViewed&referrerSource=full_rss&postId=833803376228" width="1" height="1" alt="">]]></content:encoded>
        </item>
        <item>
            <title><![CDATA[Line graphs are great for displaying trends or changes over time.]]></title>
            <link>https://medium.com/@tegerimac/line-graphs-are-great-for-displaying-trends-or-changes-over-time-3f96f2e40d60?source=rss-b6c232330051------2</link>
            <guid isPermaLink="false">https://medium.com/p/3f96f2e40d60</guid>
            <dc:creator><![CDATA[priscilla macaulay]]></dc:creator>
            <pubDate>Fri, 22 Dec 2023 10:43:03 GMT</pubDate>
            <atom:updated>2023-12-23T07:30:13.853Z</atom:updated>
            <content:encoded><![CDATA[<h3>EXPLORING THE FUNCTIONALITIES AND APPLICATIONS OF LINE AND AREA CHARTS IN DATA VISUALISATION</h3><p>Line graphs are great for displaying trends or changes over time. They’re useful for illustrating how data points are connected and how they fluctuate across different periods. Typically, they’re handy for showing continuous data sets, such as stock prices over months, temperature variations throughout a day, or population growth over years.</p><h3>Use of Line Charts:</h3><h3>Trend Identification:</h3><ul><li>They are ideal for showing trends or patterns over time, making them invaluable for tracking changes in data points sequentially.</li></ul><h3>Comparing Multiple Trends:</h3><ul><li>They can display multiple lines on the same graph, making it easy to compare trends and identify correlations or disparities between different data sets.</li></ul><h3>Highlighting Fluctuations:</h3><ul><li>Line charts effectively highlight fluctuations and variations in data, such as stock prices, weather changes, or user engagement metrics across time periods.</li></ul><h3>Interpolation between Data Points:</h3><ul><li>They help in visualizing the progression between discrete data points, providing a smoother representation of the data&#39;s movement.</li></ul><figure><img alt="" src="https://cdn-images-1.medium.com/max/1024/1*D-kHffo3bJT0_sHIJveY4g.png" /><figcaption>Line chart</figcaption></figure><h3>Area charts</h3><blockquote>are similar to line graphs but with the area below the line filled in, often in color. They’re excellent for showcasing cumulative totals and emphasizing the magnitude of change over time. These charts are effective for visualizing trends in data sets where the total is important, like displaying sales figures over time or illustrating the distribution of different elements contributing to a whole, such as market share among competitors over quarters.</blockquote><h3>Use of Area chart 📉</h3><h3>Emphasis on Magnitude:</h3><ul><li>Area charts, while similar to line charts, fill the area below the line, making them effective for emphasizing the magnitude of change or total values over time.</li></ul><h3>Cumulative Trends:</h3><ul><li>They are excellent for displaying cumulative data, illustrating how components contribute to a whole. For instance, displaying the growth of various product categories contributing to total sales over months.</li></ul><h3>Highlighting Proportions:</h3><ul><li>Area charts effectively demonstrate proportions and how different elements contribute to the whole, making them useful for showcasing market share, budget allocations, or resource distribution over time.</li></ul><h3>Visualizing Stacked Data:</h3><ul><li>Stacked area charts show the cumulative contribution of multiple variables, making them suitable for visualizing changes in compositions, like depicting the proportion of different crops in total agricultural production over years.</li></ul><figure><img alt="" src="https://cdn-images-1.medium.com/max/1024/1*c5k3-MSQJcmukn1b3hWoZA.png" /></figure><p>Link showing <a href="https://docs.google.com/spreadsheets/d/1Q_UUDvcjVlk2-qneth_j3e-vrRVZ8upw/edit?usp=drivesdk&amp;ouid=107921129434739081104&amp;rtpof=true&amp;sd=true">https://docs.google.com/spreadsheets/d/1Q_UUDvcjVlk2-qneth_j3e-vrRVZ8upw/edit?usp=drivesdk&amp;ouid=107921129434739081104&amp;rtpof=true&amp;sd=true</a></p><img src="https://medium.com/_/stat?event=post.clientViewed&referrerSource=full_rss&postId=3f96f2e40d60" width="1" height="1" alt="">]]></content:encoded>
        </item>
        <item>
            <title><![CDATA[Exploring Column and Bar Charts for Data Visualization]]></title>
            <link>https://medium.com/@tegerimac/exploring-column-and-bar-charts-for-data-visualization-ba9ca0c531e2?source=rss-b6c232330051------2</link>
            <guid isPermaLink="false">https://medium.com/p/ba9ca0c531e2</guid>
            <dc:creator><![CDATA[priscilla macaulay]]></dc:creator>
            <pubDate>Thu, 21 Dec 2023 17:02:51 GMT</pubDate>
            <atom:updated>2023-12-22T19:03:43.053Z</atom:updated>
            <content:encoded><![CDATA[<p>Column and bar charts are fantastic tools for visualizing data. Column charts display data vertically, while bar charts present data horizontally. They’re great for comparing different categories or showing changes over time. Column charts are often used for categorical data, like comparing sales figures for different products.</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/592/1*eEuQbnhdqhrBVq3FDQdftA.png" /><figcaption>Column chart<br>From the diagram above it can be observed clearly the month JULY and AUGUST had the highest number of passengers which can clearly be seen on the Column chart.</figcaption></figure><p>while bar charts are useful for comparing quantities of different categories, like comparing the populations of various cities.</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/503/1*ewJCDjc_76IL0_mQ-KEvRQ.png" /><figcaption>Bar chart showing clearly the month with the highest population which is also JULY and AUGUST.</figcaption></figure><p>The key is selecting the right chart that best represents your data for clear interpretation!</p><p>Link to the dataset 👇🏼👇🏼👇🏼</p><p><a href="https://docs.google.com/spreadsheets/d/14vYEdjTu5ECNR1oLALf9WKxhBdr2Fzow/edit?usp=drivesdk&amp;ouid=107921129434739081104&amp;rtpof=true&amp;sd=true">https://docs.google.com/spreadsheets/d/14vYEdjTu5ECNR1oLALf9WKxhBdr2Fzow/edit?usp=drivesdk&amp;ouid=107921129434739081104&amp;rtpof=true&amp;sd=true</a></p><img src="https://medium.com/_/stat?event=post.clientViewed&referrerSource=full_rss&postId=ba9ca0c531e2" width="1" height="1" alt="">]]></content:encoded>
        </item>
        <item>
            <title><![CDATA[DAX Basics in Data Analysis]]></title>
            <link>https://medium.com/@tegerimac/dax-basics-in-data-analysis-3f5c0d73a119?source=rss-b6c232330051------2</link>
            <guid isPermaLink="false">https://medium.com/p/3f5c0d73a119</guid>
            <dc:creator><![CDATA[priscilla macaulay]]></dc:creator>
            <pubDate>Thu, 21 Dec 2023 09:56:11 GMT</pubDate>
            <atom:updated>2023-12-21T10:09:01.881Z</atom:updated>
            <content:encoded><![CDATA[<p><strong>DAX Basics in Data Analysis</strong></p><figure><img alt="" src="https://cdn-images-1.medium.com/max/1024/1*Zb27BDVlhVu7VRVrpCx00w.png" /></figure><p>Data Analysis Expressions (DAX) are formulas used in Power BI, Excel Power Pivot, and Analysis Services to create custom calculations for data analysis. They’re used to manipulate and analyze data by creating measures, calculated columns, or tables. DAX functions allow users to perform tasks like aggregation, filtering, and manipulating data to derive meaningful insights.</p><p><strong>To calculate a measure in Power</strong> BI or Excel Power Pivot using DAX:</p><p>Open Power BI or Excel Power Pivot and go to the &quot;Data&quot; or &quot;Model&quot; view.</p><p>Select or create a table where you want to add the measure.</p><p>Go to &quot;New Measure&quot; or a similar option based on the platform.</p><p>Enter a DAX formula that defines the calculation for the measure.</p><p>Example: Let&#39;s say you want to create a measure called &quot;Total Sales&quot; that calculates the sum of sales amount:</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/1024/1*BZ8maSIkbIpbC0iluq1z7g.png" /><figcaption>Showing how to calculate a measure</figcaption></figure><p><strong>To calculate a new column</strong> in a dataset using DAX in Power BI or Excel Power Pivot, you’d typically use the CALCULATE function or create a calculated column.</p><p>For a calculated column:</p><p>In Power BI or Excel Power Pivot, go to the table where you want to add the calculated column.</p><p>Click on &quot;New Column&quot; or a similar option based on the platform.</p><p>Enter the DAX formula that defines the calculation for each row in the new column.n Power BI or Excel Power Pivot, you’d typically use the CALCULATE function or create a calculated column.</p><p>For a calculated column:</p><p>In Power BI or Excel Power Pivot, go to the table where you want to add the calculated column.<br>Click on &quot;New Column&quot; or a similar option based on the platform.<br>Enter the DAX formula that defines the calculation for each row in the new column.</p><p>The link below shows the dataset used for the calculated column <a href="https://drive.google.com/file/d/1l0YS2wEagehZd7oUfN7qcITddDUDCq2h/view?usp=drivesdk">https://drive.google.com/file/d/1l0YS2wEagehZd7oUfN7qcITddDUDCq2h/view?usp=drivesdk</a></p><figure><img alt="" src="https://cdn-images-1.medium.com/max/952/1*pH1LKUD1B54KUHeJGzWGDw.png" /><figcaption>This shows a calculated values added to a column</figcaption></figure><p>These examples demonstrate basic usage, but DAX offers a wide range of functions and capabilities for complex calculations based on your specific data analysis needs.</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/640/1*tM2x4xzMgmqGzyB3sW28ow.png" /><figcaption>Pivot table of dataset used with new column</figcaption></figure><img src="https://medium.com/_/stat?event=post.clientViewed&referrerSource=full_rss&postId=3f5c0d73a119" width="1" height="1" alt="">]]></content:encoded>
        </item>
        <item>
            <title><![CDATA[FUNDAMENTAL DATA MODELLING CONCEPTS….…]]></title>
            <link>https://medium.com/@tegerimac/fundamental-data-modelling-concepts-26e4968263ea?source=rss-b6c232330051------2</link>
            <guid isPermaLink="false">https://medium.com/p/26e4968263ea</guid>
            <dc:creator><![CDATA[priscilla macaulay]]></dc:creator>
            <pubDate>Wed, 20 Dec 2023 10:34:43 GMT</pubDate>
            <atom:updated>2023-12-20T10:36:04.169Z</atom:updated>
            <content:encoded><![CDATA[<p><strong>FUNDAMENTAL DATA MODELLING CONCEPTS….… EXPLORING THE CONCEPTS OF FACTS AND DIMENSIONS WITHIN DATASET</strong>.</p><p>In data modeling, a &quot;fact&quot; represents a measurable and quantitative piece of information, often numerical data, which is the focus of analysis. It typically represents an event or an occurrence that can be measured or observed.</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/1024/1*SGHopoi1S7cQJhJZjFP4tQ.png" /><figcaption>Picture showing examples of Facts</figcaption></figure><p>On the other hand, &quot;dimensions&quot; provide context and descriptive information about the facts. They are the characteristics or attributes that categorize, describe, or provide additional context to the facts.</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/1024/1*bfs7LBnBR-zZgnk93Eae2w.png" /><figcaption>Picture showing Dimensions</figcaption></figure><p>For example, in sales data, the fact could be the total sales amount, while dimensions could include things like date, product, customer, and location, providing context to the sales figure.</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/1024/1*XmbOsTRKllcRjpznWrqj0Q.png" /><figcaption>The highlighted picture shows the fact in the dataset given</figcaption></figure><p>This structure helps in creating a multidimensional view for analysis commonly known as a &quot;star schema&quot; or &quot;snowflake schema&quot; in data warehousing.</p><p>Link to Data<a href="https://docs.google.com/spreadsheets/d/1oYI-qsVLTfUv4VLDBWMszGaPiUhUerPf/edit?usp=drivesdk&amp;ouid=107921129434739081104&amp;rtpof=true&amp;sd=true">https://docs.google.com/spreadsheets/d/1oYI-qsVLTfUv4VLDBWMszGaPiUhUerPf/edit?usp=drivesdk&amp;ouid=107921129434739081104&amp;rtpof=true&amp;sd=true</a></p><figure><img alt="" src="https://cdn-images-1.medium.com/max/1024/1*uwaQ_2WmhS6mtl7oMw5mOA.jpeg" /></figure><figure><img alt="" src="https://cdn-images-1.medium.com/max/1024/1*G3DzsptcZylapsB1BD4wmA.png" /><figcaption>Power pivot showing relationship in the dataset given</figcaption></figure><img src="https://medium.com/_/stat?event=post.clientViewed&referrerSource=full_rss&postId=26e4968263ea" width="1" height="1" alt="">]]></content:encoded>
        </item>
        <item>
            <title><![CDATA[Working with Excel to implement "if" conditional statements]]></title>
            <link>https://medium.com/@tegerimac/working-with-excel-to-implement-if-conditional-statements-468e230c802e?source=rss-b6c232330051------2</link>
            <guid isPermaLink="false">https://medium.com/p/468e230c802e</guid>
            <dc:creator><![CDATA[priscilla macaulay]]></dc:creator>
            <pubDate>Tue, 19 Dec 2023 07:09:56 GMT</pubDate>
            <atom:updated>2023-12-19T07:11:58.894Z</atom:updated>
            <content:encoded><![CDATA[<p><strong>Working with Excel to implement &quot;if&quot; conditional statements</strong></p><p>“IF” conditional statements are regularly used in Excel to perform different actions, on today’s topic we will be diving into the world of IF conditional statements.</p><p><strong>What are “IF” conditional statements?</strong></p><p>IF&quot; conditional statements are programming constructs used to perform different actions based on whether a specified condition evaluates to true or false. In various programming languages, including Excel formulas, the &quot;IF&quot; statement evaluates a condition and executes one set of instructions if the condition is true and another if it’s false. It’s a fundamental way to control the flow of a program or a calculation, allowing for decision-making within the code based on specific criteria.</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/1024/1*f35xtQ4gTFxkMFInsiilCA.png" /><figcaption>Before use of IF conditional statements</figcaption></figure><p><strong>IF conditional statements are widely used for:</strong></p><ul><li><strong>Decision Making</strong>: Executing different code or actions based on whether a condition is true or false.</li><li><strong>Data Manipulation</strong>: Altering data based on certain conditions, like filtering, categorizing, or transforming values.</li><li><strong>Error Handling</strong>: Checking for errors or exceptional cases and executing appropriate actions.</li><li><strong>Calculations</strong>: Performing calculations based on varying conditions or criteria.</li><li><strong>Control Flow</strong>: Controlling the flow of a program or a process based on specific criteria or user input.</li><li><strong>Validation</strong>: Validating input or data against certain conditions and responding accordingly.</li></ul><p>These statements are fundamental in programming and data analysis, enabling dynamic and responsive behavior in code or spreadsheets</p><p>Link to spread sheet 👇🏼👇🏼👇🏼</p><p><a href="https://docs.google.com/spreadsheets/d/1YpY14vh_g5TMrEimyBJaF9DSURFfa2ky/edit?usp=drivesdk&amp;ouid=107921129434739081104&amp;rtpof=true&amp;sd=true">https://docs.google.com/spreadsheets/d/1YpY14vh_g5TMrEimyBJaF9DSURFfa2ky/edit?usp=drivesdk&amp;ouid=107921129434739081104&amp;rtpof=true&amp;sd=true</a></p><figure><img alt="" src="https://cdn-images-1.medium.com/max/1024/1*Id6NMLdcjJTK0KNNJRWMYA.png" /><figcaption>After the use of IF Conditional statements<br><br><br>.</figcaption></figure><img src="https://medium.com/_/stat?event=post.clientViewed&referrerSource=full_rss&postId=468e230c802e" width="1" height="1" alt="">]]></content:encoded>
        </item>
    </channel>
</rss>