<?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 Keerthi Kadiyala on Medium]]></title>
        <description><![CDATA[Stories by Keerthi Kadiyala on Medium]]></description>
        <link>https://medium.com/@keerthikadiyala91?source=rss-4b45a522fdef------2</link>
        <image>
            <url>https://cdn-images-1.medium.com/proxy/1*TGH72Nnw24QL3iV9IOm4VA.png</url>
            <title>Stories by Keerthi Kadiyala on Medium</title>
            <link>https://medium.com/@keerthikadiyala91?source=rss-4b45a522fdef------2</link>
        </image>
        <generator>Medium</generator>
        <lastBuildDate>Sat, 21 Nov 2026 07:41:15 GMT</lastBuildDate>
        <atom:link href="https://medium.com/@keerthikadiyala91/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[Exploratory Data Analysis using Power BI]]></title>
            <link>https://medium.com/@keerthikadiyala91/exploratory-data-analysis-using-power-bi-58f32cba84d0?source=rss-4b45a522fdef------2</link>
            <guid isPermaLink="false">https://medium.com/p/58f32cba84d0</guid>
            <category><![CDATA[dataset]]></category>
            <category><![CDATA[power-bi]]></category>
            <category><![CDATA[python]]></category>
            <category><![CDATA[eda]]></category>
            <category><![CDATA[data-science]]></category>
            <dc:creator><![CDATA[Keerthi Kadiyala]]></dc:creator>
            <pubDate>Thu, 05 Sep 2024 01:24:03 GMT</pubDate>
            <atom:updated>2024-09-05T01:24:03.966Z</atom:updated>
            <content:encoded><![CDATA[<figure><img alt="" src="https://cdn-images-1.medium.com/max/975/1*FC8Wp03Aw00rLTwIRYFKDw.png" /></figure><p><strong>Exploratory Data Analysis (EDA)</strong> is a technique used to understand a dataset before we actually start to model it. Some people refer to EDA as data exploration. In other words, EDA is the process of summarizing important characteristics of data in order to gain better understanding of the dataset. The main objective of the EDA is to understand the data.</p><p>The EDA is performed to make sure that the data is clean and does not have any redundancies or missing value or null value. We should also identify the most important variable in the data set and remove all the unnecessary noise which may actually hinder the accuracy when building the model.</p><p>Before we begin exploratory data analysis, let’s understand few key terms:</p><p><strong>Value:</strong> A data value which is informative such as number or a date.</p><p><strong>Variable:</strong> A data variable is an attribute which can be measured, such as weight or income.</p><p><strong>Distribution:</strong> The distribution of a dataset is how the whole dataset is arranged.</p><p><strong>Outlier:</strong> An outlier is a data value that is significantly different, can be much higher or lower, from the rest of a dataset.</p><p><strong>Data model:</strong> A data model is a method of organizing data and building relationships between values in a dataset.</p><p><strong>How to conduct Exploratory Data Analysis?</strong></p><p><strong>Steps involved in EDA are-</strong></p><figure><img alt="" src="https://cdn-images-1.medium.com/max/681/1*tGzFfoqsFyZ6ayT_QHcfeQ.png" /></figure><p><strong><em>1.</em></strong> <strong><em>Understand the Data</em></strong></p><p>The first step to conduct EDA is to understand the dataset at a high level. Start by determining the size of the dataset that includes number of rows and columns.</p><p><strong><em>2.</em></strong> <strong><em>Clean the Data</em></strong></p><p>Data clean refers to cleaning the data from redundancies and replacing some missing values. Redundancy can be irregularity of the data including some variables or columns not necessary for making our conclusions or interpretations which we can simply remove or delete the columns. Missing values can be replaced with estimates by finding the cause for missing.</p><p><strong><em>3.</em></strong> <strong><em>Categorize the data</em></strong></p><p>After finding missing values, categorize values to determine which statistical methods and charts visuals can be used. Values are divided into 3 categories.</p><p>a) <strong>Categorical:</strong> These variables can have limited set of values.</p><p>b) <strong>Continuous:</strong> These variables can have infinite set of values.</p><p>c) <strong>Discrete:</strong> These variables are fixed set of values which are numeric.</p><p><strong><em>4.</em></strong> <strong><em>Determine the form of the dataset</em></strong></p><p>Analyzing the data distribution, identifying skewness, and locating any gaps will assist in detecting patterns and trends that will eventually form the dataset.</p><p><strong><em>5.</em></strong> <strong><em>Identify relationships in the dataset</em></strong></p><p>Correlations between variables can be used to gain significant insights. Scatter plots are excellent for displaying and understanding these interactions.</p><p><strong><em>6.</em></strong> <strong><em>Detect Outliers</em></strong></p><p>Detecting outliers is the dataset is another crucial step in EDA. Outliers are significantly different from rest of the values and it can be on higher or lower side. Outliers can be located by observing graphs or sorting the data in numerical order during EDA.</p><p><strong>Types of exploratory data analysis</strong></p><p><strong>There are four primary types of EDA-</strong></p><p><strong>Univariate non-graphical</strong>: This is simplest form of data analysis, where the data being analyzed consists of just one variable. Since it’s a single variable, it doesn’t deal with causes or relationships. The main purpose of univariate analysis is to describe the data and find patterns that exist within it.</p><p><strong>Univariate graphical:</strong> The non-graphical methods don’t provide a full picture of the data. Graphical methods are therefore required. Common types of univariate graphics include:</p><p><strong>Stem-and-leaf plots</strong>, which show all data values and the shape of the distribution.</p><p><strong>Histograms</strong>, a bar plot in which each bar represents the frequency (count) or proportion (count/total count) of cases for a range of values.</p><p><strong>Box plots</strong>, which graphically depict the five-number summary of minimum, first quartile, median, third quartile, and maximum.</p><p><strong>Multivariate nongraphical:</strong> Multivariate data arises from more than one variable. Multivariate non-graphical EDA techniques generally show the relationship between two or more variables of the data through cross-tabulation or statistics.</p><p><strong>Multivariate graphical:</strong> Multivariate data uses graphics to display relationships between two or more sets of data. The most used graphic is a grouped bar plot or bar chart with each group representing one level of one of the variables and each bar within a group representing the levels of the other variable.</p><p><em>Other common types of multivariate graphics include:</em></p><p><strong>Scatter plot</strong>, which is used to plot data points on a horizontal and a vertical axis to show how much one variable is affected by another.</p><p><strong>Run chart</strong>, which is a line graph of data plotted over time.</p><p><strong>Bubble chart</strong>, which is a data visualization that displays multiple circles (bubbles) in a two-dimensional plot.</p><p><strong>Heat map</strong>, which is a graphical representation of data where values are depicted by color.</p><p><em>Let’s perform Exploratory Data Analysis on the Netflix userbase dataset.</em></p><figure><img alt="" src="https://cdn-images-1.medium.com/max/1013/1*Iz32yCrslAyxQ1D5jlBuTg.png" /></figure><p>The dataset contains various fields, including user ID, subscription type, monthly revenue, joining date, last payment date, country, age, gender, device, and plan duration.</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/665/1*BYXGoQY3L3gkPLetFY0FgQ.png" /><figcaption>Netflix User Database</figcaption></figure><p>To get started, I import the data from a CSV file using the “get data” feature in Power BI. Once loaded, all fields will be available for visualization.</p><p><em>We will begin our analysis by creating various visualizations:</em></p><p>The <strong>“Basic Statistical Analysis”</strong> dashboard is created by using a column chart to display the count and distinct count of all records for all primary variables. Numeric values are displayed as average, minimum, and maximum, taking into account Age, Gender, Country, Revenue, and Subscription type.</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/823/1*ZepW_iU6XYzKQTxraGL75A.png" /></figure><p>In our next dashboard, <strong>“Fields Analysis”</strong> we will perform exploratory analysis on the main fields or columns in our dataset by choosing histogram, column and donut charts.</p><p>Firstly, we need to import a histogram by using the import visual feature. Once import is successful add visual to the dashboard.</p><p>· A histogram displaying the distribution of customer ages.</p><p>· A column chart displaying the number of customers by country.</p><p>· A donut chart showing the number of customers by device and gender.</p><p>· A histogram analyzing the number of days since joining and last payment.</p><p>· A histogram analyzing monthly revenue.</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/792/1*sQIfEUqKUbtrmI0yrWR8DQ.png" /></figure><p>Next dashboard named <strong>“Country Analysis”</strong> is created to show customers by country.</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/861/1*wf7essPsBgBV8xOLAzlKXg.png" /></figure><p>From the analysis, key insights are high usage of Netflix usage by customers in USA and France followed by Canada.</p><p>To analyze devices by country, let’s create a dashboard named <strong>“Devices by Country”.</strong></p><figure><img alt="" src="https://cdn-images-1.medium.com/max/913/1*CPdp9q4u04qHcxG4CG25QQ.png" /></figure><p>In this dashboard, devices type and its count is analyzed in all countries.</p><p>From the analysis, found that Spain ranks highest for Smart TV, USA for Laptop and Canada for Tablets.</p><p>Our Next dashboard is <strong>“Gender by Country”</strong> where gender is shown in numbers in all countries.</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/892/1*A7LBZPut3uaPUQMkvHM-Nw.png" /></figure><p>From the analysis, found that Spain country has more females who use Netflix, USA with equal proportion among male and female, Canada with male numbers on higher side.</p><p>In next dashboard, we will see about <strong>“Subscription Type by Country”.</strong></p><figure><img alt="" src="https://cdn-images-1.medium.com/max/867/1*3EUE3shPGTqN0nB5mPFwMQ.png" /></figure><p>From the analysis, found that Spain country lists highest for Premium subscription, and Italy, Germany, USA, Brazil, Canada with highest Basic subscriptions whereas Mexico and United Kingdom ranks highest for Standard subscription.</p><p>Final dashboard explains about <strong>“Subscription Type by Gender Analysis”.</strong></p><figure><img alt="" src="https://cdn-images-1.medium.com/max/946/1*aaZhr4L9sS2CLyaC9EnOXQ.png" /></figure><p>Through our analysis, Female marked highest for Basic subscription and Laptop usage.</p><p><strong>Tools for Exploratory Data Analysis</strong></p><p>Some of the most common data science tools to create an EDA are Python, R, Power BI and Excel.</p><p><strong>Why is Exploratory Data Analysis important in Data Science?</strong></p><p>The main purpose of EDA is to look at data before making any assumptions. It can help identify obvious errors, as well as better understand patterns within the data, detect outliers or anomalies, find interesting relations among the variables.</p><p>We can use exploratory analysis to ensure the results we got are valid and applicable to any desired business outcomes and goals. EDA also helps stakeholders by confirming they are asking the right questions. EDA can help answer questions about standard deviations, categorical variables, and confidence intervals. Once EDA is complete and insights are drawn, its features can then be used for more sophisticated data analysis or modeling, including machine learning.</p><p><strong>Conclusion</strong></p><p>Exploratory Data Analysis offers invaluable insights and paves the path for informed decision- making. By delving into data distributions, correlations, and anomalies, EDA empowers data professionals to drive initiatives to success.</p><img src="https://medium.com/_/stat?event=post.clientViewed&referrerSource=full_rss&postId=58f32cba84d0" width="1" height="1" alt="">]]></content:encoded>
        </item>
        <item>
            <title><![CDATA[How Can Artificial Intelligence and Power BI Derive Smarter Insights ?!]]></title>
            <link>https://medium.com/@keerthikadiyala91/how-can-artificial-intelligence-and-power-bi-derive-smarter-insights-283f3667199f?source=rss-4b45a522fdef------2</link>
            <guid isPermaLink="false">https://medium.com/p/283f3667199f</guid>
            <category><![CDATA[power-bi]]></category>
            <category><![CDATA[ai-capabilities]]></category>
            <category><![CDATA[artificial-intelligence]]></category>
            <category><![CDATA[better-business-decisions]]></category>
            <category><![CDATA[data-insights]]></category>
            <dc:creator><![CDATA[Keerthi Kadiyala]]></dc:creator>
            <pubDate>Mon, 02 Sep 2024 22:54:21 GMT</pubDate>
            <atom:updated>2024-09-03T01:53:20.324Z</atom:updated>
            <content:encoded><![CDATA[<h3><strong>How Can Artificial Intelligence and Power BI Derive Smarter Insights?!</strong></h3><figure><img alt="" src="https://cdn-images-1.medium.com/max/1024/1*sg11MamTGA2a9KAHMZSADA.jpeg" /><figcaption>The Rise of AI in Power BI. Image source is Sparity.com</figcaption></figure><p>Power BI is a business analytics tool that helps businesses make better decisions. In recent times, Power BI’s AI capabilities have been discussed a lot. <br> <br> This blog explains significant AI-driven features like Q&amp;A functionality, predictive analysis, and AI visuals.</p><p><strong>1. AI-Generated Graphics</strong></p><p>Power BI provides two essential visuals powered by artificial intelligence that assist users in gaining insights from data with little effort.</p><p>a) <strong>Key Influencers Visual:</strong> This tool helps to understand how different metrics affect a chosen statistic in the data.<strong> </strong>In other words, it analyses the data and determines which are the most impactful individual contributing factors and what their significance is. It clearly explains the distribution and cause of the values increasing or decreasing.</p><p>Let’s see how the key influencers’ visual is created.</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/437/1*IzT9er-0fMbNyLZRQ8Eo8w.png" /><figcaption>Key Influencers Chart</figcaption></figure><p>· Under Build Visual on the Visualizations pane, select the Key Influencers icon.</p><ul><li>Move the metric to investigate into the Analyze field.</li><li>Using a nutrition score as an example, we can see that the status of the nutrition score can be explained by using a key analyzer, high-calorie diet, hemoglobin diet, breakfast meal, afternoon snack, cookies, vegetables, supper, and lunch meal.</li></ul><p><strong>Image_1:</strong></p><figure><img alt="" src="https://cdn-images-1.medium.com/max/631/1*jkypigzTv1ZfSyEE-jrdYQ.png" /><figcaption>Healthy Nutrition Score explained in Key Influencers chart</figcaption></figure><p>· As shown in image_1, Vegetables are the top influencers and they impact positively with a Nutrition score classified as “Healthy”. It increases the likelihood by 3.92 times.</p><p>· The bar chart on the right shows that the percentage of “Healthy” nutrition scores is higher when vegetables are part of the diet.</p><p>· The average percentage without vegetables in a dotted line is at 22.33%</p><p><strong>Image_2:</strong></p><figure><img alt="" src="https://cdn-images-1.medium.com/max/611/1*ecILWgkrodQNHxcwm7QSBw.png" /><figcaption>Unhealthy Nutrition Score explained in Key Influencers chart</figcaption></figure><ul><li>This image_2 displays that having a low Hgb (Hemoglobin) diet is the top negative influencer contributing to an “Unhealthy” nutrition score of 6.86 times.</li><li>Absence of meals and snacks contributes to an “Unhealthy” nutrition score.</li><li>The bar chart on the right shows that a low Hgb diet is the significant factor for the higher percentage of “Unhealthy” nutrition scores.</li><li>The average percentage without Hgb diet is indicated by a dotted line at 11.83%</li></ul><p><strong>Image_3:</strong></p><figure><img alt="" src="https://cdn-images-1.medium.com/max/544/1*mJhyQRRF6HexAEbVZMNemA.png" /><figcaption>Top Healthy Segments</figcaption></figure><ul><li>Three key segments were identified based on the percentage of Nutrition scores rated as “Healthy”.</li><li>Segments 1 and 2 with population count of 68 and 34 respectively have a higher percentage of a healthy nutritional score of 100%.</li><li>Segment 3 has a lower percentage of healthy nutritional scores (79.1%) with a population count of 43.</li></ul><p><strong>Image_4:</strong></p><figure><img alt="" src="https://cdn-images-1.medium.com/max/666/1*3I45HJMnEzD96gl2tbG4VA.png" /><figcaption>Top Unhealthy Segments</figcaption></figure><ul><li>Image_4 identified 4 segments based on a percentage of Nutrition Scores classified as “Unhealthy” and given their population count.</li><li>Segment 1 has the highest percentage of bad nutrition scores, despite being the smallest segment of the 18 population count.</li><li>Segment 2 is notable because of its high percentage of unhealthy scores (87.9%) and moderate population size (33), making it an important group for focused nutritional interventions.</li><li>Despite being the largest group, Segment 4 had the lowest percentage of unhealthy scores among the four, indicating that different intervention tactics are required than in the other segments.</li></ul><p><strong>Image_5:</strong></p><figure><img alt="" src="https://cdn-images-1.medium.com/max/703/1*mphAWnM0ZfVsbmhQyQVueg.png" /><figcaption>Characteristics of Unhealthy Segments</figcaption></figure><p>· For an example, let’s see the characteristics of one of the top segments for “Unhealthy Nutritional Score” from the image_5.</p><p>· In Segment 2, 87.9% of the Nutrition Score is “Unhealthy”. Image_5 suggests that the absence of snacks may correlate with an unhealthy nutrition score.</p><p><strong>b) Decomposition Tree Visual: </strong>The Decomposition Tree visual is used to drill down into multiple dimensions of the data and investigate the root cause of a certain condition by selecting the highest or lowest values. The visualization requires two types of input:</p><p><strong>Analyze</strong> — the metric you would like to analyze. It must be a measure or an aggregate.</p><p><strong>Explain</strong> — one or more dimensions you would like to drill down into.</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/822/1*ooF2r73ddRigsXo1A4QC9Q.png" /><figcaption>Decomposition Tree Chart</figcaption></figure><p>After dragging the measure into the field, the visual updates showcase the aggregated measure. In the example below, we are visualizing the count of patients with specific medical conditions and root causes.</p><p>The analysis can work in two ways depending on your preferences. Using the supply chain sample again, the default behavior is as follows:</p><p>· <strong>High Value:</strong> Looks at all fields and determines which one to drill into to get the highest value of the measure being analyzed.</p><p>· <strong>Low Value:</strong> The lowest value of the measure is analyzed after examining all fields.</p><p><strong>2.</strong> <strong>Q&amp;A Feature</strong></p><p>The Q&amp;A feature in Power BI explores data in our own words, as a result, it gives the answers to the questions that are asked in natural language. Q&amp;A is available on dashboards in the Power BI service and can be added to reports in the Power BI service or Power BI Desktop.</p><p>Q&amp;A can be added to your reports in a couple of ways.</p><p>· Select from the viz pane as shown below.</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/243/1*KSdsZd7qPnJCJa_aFLYTTQ.png" /><figcaption>Q&amp;A in Viz Pane</figcaption></figure><p>Double-clicking into the background of reports.</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/443/1*c4LX5dNtw2KtpK5Hp3_zoA.png" /><figcaption>Q&amp;A in Ribbon</figcaption></figure><p>· Use the insert Tab and see Q&amp;A, there are other AI visuals built into Power BI here along with Q&amp;A.</p><p>· There’s even a Q&amp;A option to select from the Buttons tab if you would like to create a smaller version of this in your report.</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/257/1*cw5Gr3QIQ0rYt-7IYlKJOw.png" /><figcaption>Q&amp;A from Buttons</figcaption></figure><p><strong>How It Operates:</strong></p><p><strong>The Q&amp;A feature allows users to ask natural language queries for example “total systolic BP change over time?” as shown in the image below. Then, depending on the query, Power BI selects the suitable visual automatically.</strong></p><figure><img alt="" src="https://cdn-images-1.medium.com/max/569/1*ohm5kUGMe3Hk1pMoIKTx8Q.png" /><figcaption>Line Chart</figcaption></figure><p><strong>Suggestions:</strong> An additional option is to select a question from a highlighted list of ideas.</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/621/1*MThCYv3qrgFv5AUKcayzgQ.png" /><figcaption>Suggestions pane</figcaption></figure><p><strong>Convert icon:</strong> Select this icon to convert a Q&amp;A visual into a regular visual with the edit view option.<br> <br> <strong>Gear Icon:</strong> The Gear Icon is utilized to access the Q&amp;A Tooling pane, which gives us the ability to adjust the natural language engine. Only in the Edit view is the gear icon accessible.</p><p><strong>Q&amp;A button in a report: </strong>Add a Q&amp;A button to reports and open the Power BI Q&amp;A Explorer window. Visuals created using the Q&amp;A button are for exploration only, they can’t be saved to the report or dashboard and the Q&amp;A button is only available in Reading mode.</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/123/1*97jSxfJJl3xpj76kaiVmRg.png" /><figcaption>Q&amp;A button</figcaption></figure><p><strong>Limitations:</strong> At the moment, Power BI can only support English natural language queries.</p><p><strong>3.</strong> <strong>Predictive Analysis with Power BI</strong></p><p>Predictive analysis in Power BI uses machine learning to estimate future trends using historical data. This is especially useful for businesses seeking to make proactive decisions.</p><p><strong>Forecasting:</strong> Power BI has built-in forecasting tools that predict future data trends based on past patterns. For example, you can forecast future revenues, customer growth, and inventory needs. Power BI’s forecasting model may be adjusted by changing parameters like forecast length, confidence intervals, and seasonality. Forecasting with Power BI may aid with informed decision-making, resource management, and risk minimization.</p><p><strong>AI Insights:</strong> Power BI’s AI Insights feature works with Azure Machine Learning, allowing users to apply machine learning models throughout the platform. Users can connect to pre-trained models or construct new models in Azure, to use with Power BI data sets.</p><p><strong>Text analytics:</strong> The AI Insights tool can be used to analyze text data. This feature can be used to extract insights from unstructured data and detect trends and sentiments.</p><p><strong>Anomaly Detection:</strong> Anomaly is defined as “an unexpected change within the data patterns, or an event that does not conform to the expected data pattern”. In short, Anomalies are abnormalities. Anomaly detection aims at finding unexpected or rare events in time series data streams.</p><p><strong>Why should we detect Anomalies?</strong></p><p>The anomalies indicate major variations and deviations from the expected trend. The variations might be due to errors in data collection or technical glitches.</p><p><strong>Methods for Finding Anomalies using Power BI:</strong></p><p>· Using the Gestational Diabetes Dataset, abnormalities can be found by taking the two columns named “Date of form signed” and “25-OHD result date”.</p><p>Create a line graph with “Date of form signed” on the x-axis and “25- OHD Result date” on the y-axis. Below is the reference picture.</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/495/1*TIoX6PvpDzlykoD_hE_Wbg.png" /><figcaption>Line Chart</figcaption></figure><p>· To detect Anomalies, go to the Analytics Pane and turn on “Find Anomalies”. Change the sensitivity according to your requirements.</p><p>· If there is an increase in sensitivity, the algorithm is more sensitive to changes in the data. Even a slight deviation is marked as an anomaly.</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/251/1*N57Hbw_BOS3MO95t5wQsIg.png" /><figcaption>Sensitivity Option</figcaption></figure><p>· Now, note the change in your line chart. The anomalies are marked with a marker that can be formatted. Here, one anomaly has been detected.</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/559/1*XX-xyeRVKUU7Qk39mRd0Hg.png" /><figcaption>Identified Red square Anomaly</figcaption></figure><p>· Red colored square is an anomaly detected.</p><p><strong>Limitations:</strong></p><p>· It is only supported for line charts with time series data on one axis and more than three data points on the other axis.</p><p>· The line chart visual does not support secondary values, multiple values, or legends.</p><p><strong>Conclusion:</strong></p><p>The combination of Power BI with AI and Machine Learning represents a dramatic shift in business analytics. It enables enterprises to transition from static reports to proactive tools to ensure success. The combination of these technologies will have a huge impact. Businesses can now use Power BI to not just analyze the present but also predict and change their futures.</p><img src="https://medium.com/_/stat?event=post.clientViewed&referrerSource=full_rss&postId=283f3667199f" width="1" height="1" alt="">]]></content:encoded>
        </item>
        <item>
            <title><![CDATA[Understanding Schemas in Power BI: An Overview]]></title>
            <link>https://medium.com/@keerthikadiyala91/understanding-schemas-in-power-bi-an-overview-bc65de38a570?source=rss-4b45a522fdef------2</link>
            <guid isPermaLink="false">https://medium.com/p/bc65de38a570</guid>
            <category><![CDATA[snowflake]]></category>
            <category><![CDATA[schema]]></category>
            <category><![CDATA[star-schema]]></category>
            <category><![CDATA[data-analysis]]></category>
            <category><![CDATA[power-bi]]></category>
            <dc:creator><![CDATA[Keerthi Kadiyala]]></dc:creator>
            <pubDate>Sat, 29 Jun 2024 00:15:31 GMT</pubDate>
            <atom:updated>2024-06-29T00:15:31.727Z</atom:updated>
            <content:encoded><![CDATA[<p>Let’s explore schemas in Power BI and learn how they work.</p><p><strong>What is a Schema?</strong></p><p>In the context of Power BI, a schema is a logical blueprint that defines the structure, organization, and relationships of tables within a dataset. It serves as a framework to facilitate querying and reporting by establishing meaningful and well-defined relationships between tables. Normalization, a key process in schema design, involves organizing and structuring data to eliminate redundancy and improve data integrity. This is achieved by breaking down larger tables into smaller, more focused tables and establishing relationships between them.</p><p><strong>Types of Schemas</strong></p><p>There are three primary types of schemas commonly used in Power BI:</p><ol><li>Flat Schema</li><li>Star Schema</li><li>Snowflake Schema</li></ol><p><strong>Flat Schema</strong></p><p><strong>Overview</strong></p><p>A flat schema is the simplest form of database design, where all data is stored in a single table. In this schema, each row represents a unique record, and each column represents the record’s attributes.</p><p><strong>Example:</strong></p><p><em>“Adventure Works”</em> is a company who has decided to use Power BI for its data analytics. The company must design a schema with several interconnected tables to analyze and visualize its data effectively. Some of the tables in the company schema are as follows:</p><p>· <strong>Reseller</strong>: A table with reseller ID, contact information, and demographic data.</p><p>· <strong>Regions</strong>: Stores geographical location about the customers like region, country and city.</p><p>· <strong>Sales</strong>: Captures transaction data like date, sale amount, transaction ID, and quantities sold.</p><p>· <strong>Products</strong>: Stores data about various products, categories, and subcategories with Product ID.</p><p>· <strong>Salesperson</strong>: Records data about salespersons, employee ID, hiring data, and designation.</p><p>Let’s review the components of various schema using <em>“Adventure Works”</em> schema as our example.</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/1024/0*FCyshsnbTmYIwz__.png" /></figure><p>In the Adventure Works Sales table, each row represents a sales transaction, while the various columns specify who bought the product, the date on which it was sold, and so on. Since there is only one table in the schema, you don’t need to manage relationships between different tables.</p><p><strong>Advantages:</strong></p><ol><li><strong>Simple Data Retrieval:</strong> All data is contained within one table, making it easy to understand, design, and maintain.</li><li><strong>Less Complex Data Analysis:</strong> Querying the database is straightforward as no joins or complex queries are required.</li><li><strong>Simpler Data Visualization:</strong> Since all data is in one place, visualizing it is more straightforward.</li></ol><p><strong>Disadvantages:</strong></p><ol><li><strong>Requires Large Datasets:</strong> Flat schemas are often unsuitable for handling and analyzing complex data.</li><li><strong>Issues with the Data:</strong> They can lead to data redundancy, as the same data may be repeated across multiple rows, resulting in increased storage requirements and potential data inconsistencies.</li><li><strong>Unsuited to Complex Datasets:</strong> Establishing meaningful relationships and hierarchies between data elements is difficult, making detailed analysis challenging.</li></ol><p><strong>Star Schema</strong></p><p><strong>Overview</strong></p><p>A star schema is a more advanced approach to structuring and organizing quantitative, or measurable, data in Power BI. It allows for multiple tables to be connected through one central table, known as the fact table. The fact table is linked to dimension tables that contain records for customers, employees, dates, and marketing campaigns. Let us understand how fact and dimension tables are defined?</p><p><strong>Fact tables</strong> consists of the measurements, metrics, or facts of a business process. In other words, they hold quantifiable measurable data. Example: order id, product id, product price, quantity.</p><p><strong>Dimension tables</strong> are typically textual fields and provide descriptive attributes related to fact data. Dimension tables are linked to the fact table and include date, employee, sales, and product data.</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/656/0*gAYA86ud9UTS6od7.png" /></figure><p><strong>Advantages:</strong></p><ol><li><strong>Reduces Data Redundancy:</strong> By separating facts and dimensions into distinct tables.</li><li><strong>Boosts Query Performance:</strong> More efficient querying and aggregation of data, as dimension tables are typically smaller and can be indexed to improve performance.</li><li><strong>Easy to Understand:</strong> The fact table serves as the focal point, and all other tables are linked to it through clear relationships.</li></ol><p><strong>Disadvantages:</strong></p><ol><li><strong>Lacks Flexibility:</strong> Actions like adding new dimensions or modifying existing ones may require extensive changes to the schema.</li><li><strong>Struggles with Complexity:</strong> May not be suitable for handling complex relationships between dimensions.</li></ol><p><strong>Snowflake Schema</strong></p><p><strong>Overview</strong></p><p>A snowflake schema is an extension of the star schema. It breaks down the dimension tables into multiple related tables, forming a hierarchical structure that resembles a snowflake. This process, known as normalization, reduces data redundancy and improves data integrity.</p><p><strong>Example:</strong> In the Adventure Works schema, each dimension table is connected to one or more related tables.</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/1024/0*e1G-oqRmGRLq_l7x.png" /></figure><p><strong>Advantages:</strong></p><ol><li><strong>Efficient Storage:</strong> Reduced data redundancy through normalization.</li><li><strong>Improved Data Integrity:</strong> Better data integrity due to more focused tables.</li><li><strong>Offers Scalability:</strong> Greater flexibility in handling complex relationships between dimensions, as new tables can be easily added to accommodate new relationships.</li></ol><p><strong>Disadvantages:</strong></p><ol><li><strong>Complex Data Analysis:</strong> More difficult to perform data analysis because of the extra relationships.</li><li><strong>Challenging to Understand and Manage:</strong> The schema is harder to understand and maintain due to its complexity.</li><li><strong>Slower Queries:</strong> Multiple join operations may be required to retrieve data from the related tables, resulting in slower query performance.</li></ol><p><strong>The Importance of Choosing the Right Schema</strong></p><p>Understanding schemas and the available types is crucial for effective database design and management. Each schema type has its own advantages and limitations:</p><ul><li><strong>Flat Schema:</strong> Simple and easy to work with but may not be suitable for complex data relationships or large datasets.</li><li><strong>Star Schema:</strong> Popular choice for dimensional modeling, offering reduced data redundancy and intuitive design, though less flexible with complex relationships.</li><li><strong>Snowflake Schema:</strong> Provides greater flexibility and improved data integrity through normalizing dimension tables, but its complexity can make it more challenging to understand and query.</li></ul><p><strong>Conclusion</strong></p><p>Choosing the right schema depends on the specific needs and requirements of the analysis, and the complexity of the data and relationships involved. By understanding the advantages and limitations of each schema type, you can make informed decisions on the best schema design for your data analysis. This leads to more efficient and effective data storage and management, ultimately enhancing your ability to analyze and visualize data using Power BI.</p><img src="https://medium.com/_/stat?event=post.clientViewed&referrerSource=full_rss&postId=bc65de38a570" width="1" height="1" alt="">]]></content:encoded>
        </item>
    </channel>
</rss>