Ezekiel Balogundatatech.hashnode.dev·Oct 4, 2024Sales Performance DashboardWYSE-BUYER MEGA STORES I carried out this project for Wyse-Buyer Mega Stores by creating an advanced data visualization using Microsoft Excel. The process began with data extraction, where I managed databases by querying relevant information from pro...#3MTTNigeria
Jogleen Caliponjworkz.hashnode.dev·Sep 18, 2024HR Data Insights DashboardThis sample project examines trends in employee numbers, average annual salaries, hiring trends, employee count by department, employee tenure, and the job sources where most recruited employees applied. The dataset spans from 2006 to 2018, providing...61 readspower pivot
Jogleen Caliponjworkz.hashnode.dev·Sep 10, 2024Utility Report DashboardThis sample project examines the trend of payables over the past 5 years to identify any patterns that need attention. The dataset can be found and downloaded for your reference on Kaggle Tools Used for this Project: Power Pivot, Data Modeling, Power...79 readspowerpivot
Parth Ladthenavigatedata.com·Jun 22, 2024Avoid Repetitive Steps in MS Fabric Dataflow Gen2 with Custom FunctionsWhile working with Dataflow Gen2 or Power BI, If you keep finding yourself needing to apply the same transformations to different queries or values, making a custom function in Power Query can save you loads of time. It's like using SQL functions to ...Microsoft FabricMicrosoft
Parth Ladthenavigatedata.com·Dec 4, 2023Power Query's Missing IN OperatorThe IN operator is a common feature in programming languages, allowing users to check if a value exists within a specified list. While Power Query M doesn't have a built-in IN operator, we can still achieve the same functionality using alternative me...Power QueryDataFlowGen2
Nandita Kumarinandita28.hashnode.dev·Nov 29, 2023Cyclistic Bike Share AnalysisWelcome to the Cyclistic bike-share analysis case study! In this case study, I have performed many real-world tasks as a junior data analyst. I worked for a fictional company, Cyclistic. Cyclistic is a bike-share company in Chicago. The director of m...224 readsdataanalalytics
Viraj Rathnayakavirajr.hashnode.dev·Nov 26, 2023IF Statement using Power QueryIf you're stuck with a syntax error and looking for the short answer, here it is. if Condition 1 then results if true else results if false if Condition 1 then results if true else if Condition 2 then results if false ...27 readsPowerQuery
Viraj Rathnayakavirajr.hashnode.dev·Oct 8, 2023Select the relative dates (weeks, Months, Years) from a slicer.The dates filter is the most commonly used filter in Power BI Reports. We mostly add a simple drop-down or a slicer with dates, months quarters, etc. Instead of using specific date columns for filtering some users/projects may find it useful to have ...67 readsPowerQuery
The Analyst Geektheanalystgeek.hashnode.dev·Aug 17, 2023Just Steps to Append and Merge data using Power Query in Power BIDifference between Append and Merge Merge queries can combine tables with different numbers of columns(it is simply a), while append queries require tables to have the same number of columns. Appending Files and tables in Power BI (Power Query) Appe...PowerBI
Kasturi Mukherjeekmukherjee.hashnode.dev·Jul 12, 2023Power Query in Power BI Desktop!!What is Power Query? Power Query is all about cleaning and analyzing the data. It is an ETL Service tool (Extract, Transform and Load). It allows you to import data from various sources which we call Extraction of the data and then we Transform (clea...PowerBI
