Ezekiel Balogundatatech.hashnode.dev·7 hours agoData Cleaning ChallengesWhat challenges have you encounter while cleaning data for data analysis and visualization, and how did you resolve those challenges?Discuss·1 likeMy3MTT
Jogleen CaliponforData Visualizationjwork.hashnode.dev·Sep 10, 2024Sales Executive DashboardThis sample project explored sales trends from the fiscal years 2018 to 2020 to identify patterns and find business opportunities in today’s market. The dataset can be found and downloaded for your reference on Kaggle Tools Used for this Project: Pow...DiscussPowerBI
esProc Desktopesproc-desktop.hashnode.dev·Sep 9, 2024#60 - Find How Many Times Two Specified Members Will Be Contained in A Series of SetsProblem description & analysis: Below is an Excel table recording the groups in a competition. In the range of C1:V13, every 6 columns corresponds to a table having 4 players, and 1-16 represents numbers of 16 players. ABCDEFGHIJKLMNOPQRSTUV118141112...Discussexcl
M B A R Kmbarkt3sto.hashnode.dev·Sep 5, 2024Power BI: Decomposition Tree VisualIn this blog post, we’ll explore the Decomposition Tree visual in Power BI, show how to create it, and provide practical examples using a sales dataset. The examples will include actual results to demonstrate the visual’s full potential. What is a De...DiscussPowerBI
M B A R Kmbarkt3sto.hashnode.dev·Sep 4, 2024Power BI: TreeMap VisualIn this blog post, we’ll explore the TreeMap visual in Power BI, show you how to create it, and provide practical examples using a sales dataset. Each example will include results to help you better understand how to use TreeMaps effectively. What is...DiscussPowerBI
esProc Desktopesproc-desktop.hashnode.dev·Sep 4, 2024#57 - Concatenate Column Titles Corresponding to Empty CellsProblem description & analysis: An Excel table has column titles, and there are certain empty cells. ABCDEF1stat Astat Bstat Cstat Dstat Estat F2113XX4XXXX56XXX7XXXX8XX For each row, concatenate column titles corresponding to the empty cells with sl...Discussexcel
steve jacobstevejacob.hashnode.dev·Sep 3, 2024Integrating AI and Machine Learning Models into Power BI Reports: A Step-by-Step GuidePower BI, a robust business analytics tool from Microsoft, empowers organizations to visualize and share insights from their data. However, the real magic happens when you integrate AI and machine learning (ML) models into your Power BI reports. This...Discusspower bi report builder
esProc Desktopesproc-desktop.hashnode.dev·Sep 3, 2024#56 — Get The Same Rows from A TableProblem description & analysis: The Excel table below has 4 columns. If we regard columns from the 2nd to the 4th as a whole, there are duplicates, as shown below: ABCD 1#ProductNon ConfDate 21AppleWorms4-Mar-24 33AppleWorms4-Mar-24 42PearW...Discussexcel
M B A R Kmbarkt3sto.hashnode.dev·Aug 31, 2024Power BI DAX: SUMMARIZE FunctionIn this blog post, we’ll explore the SUMMARIZE function in DAX, explain how it works, and provide practical examples using a sales dataset. Each example will also show the resulting tables to give you a clearer understanding of how SUMMARIZE can be a...DiscussPowerBI
M B A R Kmbarkt3sto.hashnode.dev·Aug 31, 2024Power BI DAX: VariablesIn this blog post, we’ll explore the concept of variables in DAX, explaining how to define and use them with practical examples based on a sales dataset. What Are Variables in DAX? Variables in DAX are used to store the result of an expression so tha...DiscussPowerBI