Articles with this tag assume a beginner knowledge within this category.
Ensuring expenses align with organizational goals Effectively managing resources allotted for I.T. is critical for the success of an organization, especially as competition for those resources continues. I.T. managers must utilize budgets as their primary strategy for managing these resources. Comprehensive budgets should include precision and categories which encompass the entire technological enterprise. Such categories…
Implementing Business Rules through Advanced Transformations In this article, I’ll continue from the article [Power Query – Transformations] and illustrate some advanced transformations available in the Query Editor. I’ll begin with the same data from the previous article. Split Column By Delimiter First, I wish to parse “Order ID” values so I end up with…
Implementing Business Rules through Transformations In this article, I’ll continue from the article Excel Power Query – Introduction and illustrate some transformations available in the Query Editor. I’ll begin with the data loaded into the Query Editor. Remove Columns Since I don’t need the field Ship Mode, I’ll use “Remove Columns” to remove this column. Split…
Leveraging Power Query to harness your data. The Power Query Add-On provides power capabilities to connect to multiple data sources, import data, query and transform data. Power Query allows you to load millions of rows into Excel’s Data Model which keeps the data in memory instead of numerous worksheets. This enormous data storage allows analysis…
Intuitively describing data patterns. When conducting statistical studies it is as important to present the results in an intuitive manner so users may understand and act on it as it is to conduct the study itself. In this article I will briefly describe the recommended uses for each method. Purpose Chart Type Displaying Trends Over…
Understanding event outcomes by their frequency. One of the most important patterns studied within statistical research are frequency distributions and their cumulativeness to understand events. In this example we’ll begin with a dataset illustrating adult student ages with the goal of understanding how often certain-aged students participate in school. Next, I’ll add to my spreadsheet…
Understanding event outcomes by their frequency. One of the most important patterns studied within statistical research are frequency distributions and their cumulativeness to understand events. In this example we’ll begin with a dataset illustrating adult student ages with the goal of understanding how often certain-aged students participate in school. Next, I’ll add to my spreadsheet…
