Here are 100 clear, structured lines of must-know information for Microsoft Dynamics ERP 365, F&O, BC, Axapta, Navision, Great Plains:
Dynamics 365 ERP is Microsoft’s suite of enterprise resource planning solutions.
It integrates financial, operational, and HR processes.
It is cloud-first, but some versions allow hybrid or on-prem deployments.
Licensing is modular (Finance, SCM, HR, etc.).
Dynamics 365 Finance & Operations (F&O) is for large enterprises.
Dynamics 365 Business Central (BC) is for SMBs, evolved from Navision.
AX (Axapta) evolved into F&O within Dynamics 365.
Navision evolved into Dynamics NAV, then Business Central.
Great Plains evolved into Dynamics GP, still supported but not actively developed.
Uses Power Platform integration for Power BI, Power Automate, and Power Apps.
Supports multi-company and multi-currency capabilities.
Incorporates advanced security and role-based access control.
Uses Dataverse for data integration with CRM modules.
Allows API integration with external applications and e-commerce.
Embedded analytics dashboards through Power BI.
Cloud scalability on Azure with elasticity.
Supports workflow automation for approvals.
Utilizes AI for cash flow forecasting (Finance).
Uses One Version for continuous updates.
Requires careful update management due to monthly and wave updates.
Handles advanced financials, SCM, and manufacturing.
Supports global financial reporting standards.
Advanced warehouse management with mobile device support.
Production and manufacturing execution capabilities.
Asset management for equipment tracking.
Budgeting, cash flow forecasting, and financial planning.
Vendor collaboration portals.
Advanced project management and accounting.
Human Resources module for core HR functions.
Tax configurations for different jurisdictions.
Advanced inventory costing and tracking.
Transportation management module.
Integration with EDI solutions.
Embedded Power BI financial dashboards.
Lifecycle Services (LCS) for project deployment.
Retail and Commerce modules available for POS.
Batch job management for background processing.
Data entities used for imports/exports.
Dual-write integration with Dynamics 365 CE (CRM).
Extensible using X++ programming language.
Ideal for SMBs seeking financials, SCM, and CRM basics.
Easy migration from on-prem NAV to BC.
Uses AL programming language for extensions.
AppSource provides extensions and apps.
Handles core financial management.
Handles sales and purchase management.
Inventory management capabilities.
Project management with basic job costing.
Manufacturing module (simpler than F&O).
Service management module.
Integration with Office 365 for seamless Excel/Outlook.
Multi-currency support.
Automated bank reconciliation capabilities.
Cloud backup and disaster recovery handled via Azure.
Role Centers provide user-specific dashboards.
Customizable workflows for approvals.
Budgeting and basic cash flow analysis.
Easily integrates with Power BI for reporting.
SaaS with continuous updates from Microsoft.
Web client as primary UI, with mobile support.
Axapta was rebranded to Dynamics AX.
Known for advanced manufacturing and financial capabilities.
Supports complex supply chain operations.
Uses X++ language.
Previously on-premise before shifting to Dynamics 365.
Scalable for large enterprises.
Customization-heavy in earlier versions.
Known for its deep configuration capabilities.
Integrated reporting with SSRS and Management Reporter.
Retains legacy importance for many enterprises.
Transition path available to F&O on Dynamics 365.
Older AX versions require CU updates for compliance.
Heavy integration with SQL Server.
Advanced production scheduling capabilities.
Integrated HR, retail, and project accounting modules.
Originated in Denmark before Microsoft acquired it.
Became Dynamics NAV before evolving into BC.
Targeted SMBs needing robust financials.
Uses C/AL language in legacy NAV versions.
SQL Server backend with proprietary database in older versions.
Offers multi-language support.
Simple manufacturing and warehouse management.
Handles multi-currency and multi-company.
Popular in European SMB markets.
Migrated easily to BC cloud or on-prem solutions.
Acquired by Microsoft in the early 2000s.
Known for core financial management for SMBs.
Uses Dexterity language for customization.
Still supported with updates but not being innovated.
Commonly used in North America for accounting needs.
Understanding of financial accounting and supply chain processes is essential.
Experience with Azure and cloud security best practices.
Power BI report creation and integration knowledge is key.
Basic SQL Server query skills for report building.
Understanding the One Version update lifecycle.
Knowledge of data migration using RapidStart Services (BC) or Data Entities (F&O).
Familiarity with integration via OData and REST APIs.
AL, X++, or C/AL language understanding for extensions.
Basic understanding of Power Platform automation opportunities.
Licensing and environment management knowledge for sandbox, UAT, and production.
Here are 100 clear, structured lines of must-know Power BI information for your mastery, interviews, upskilling, or training plans:
Power BI is Microsoft’s business intelligence and data visualization tool.
It converts raw data into interactive dashboards and reports.
Power BI includes Power BI Desktop, Power BI Service, and Power BI Mobile.
Power BI Desktop is a free Windows application for report creation.
Power BI Service is the cloud-based platform for sharing and collaboration.
Power BI Mobile apps are available for iOS and Android.
Supports data modeling using relationships and data types.
Uses DAX (Data Analysis Expressions) for calculations and measures.
Uses Power Query (M language) for data transformation.
Can connect to hundreds of data sources (Excel, SQL, Azure, etc.).
Allows data refresh scheduling in the Power BI Service.
Supports row-level security for data protection.
Allows creation of calculated columns and measures.
Provides interactive visuals like bar, line, scatter, map charts.
Allows creation of dashboards by pinning report visuals.
Offers Q&A natural language queries for insights.
Integrates with Microsoft Teams for collaborative analysis.
Allows the use of bookmarks for storytelling.
Includes drill-down and drill-through capabilities.
Provides data alerts on dashboards.
Connects to Excel files and PowerPivot models.
Supports SQL Server, Azure SQL Database, and Azure Synapse.
Can pull data from cloud services like Salesforce, Google Analytics.
Uses OData feeds for flexible integration.
Allows direct query and import modes.
Direct Query keeps data in the source for real-time analysis.
Import mode stores data in Power BI for faster performance.
Can connect to REST APIs for custom data sources.
Supports SharePoint list and folder connections.
Can use Dataflows for ETL in the service.
Integration with Power Apps for write-back scenarios.
Integration with Power Automate for process automation.
Embeds Power BI visuals in custom applications.
Supports streaming datasets for real-time dashboards.
Azure Data Lake integration for large-scale data storage.
Analysis Services live connections supported.
SAP and Oracle connectors available.
GitHub and web scraping supported via Power Query.
Can use R and Python scripts for advanced data processing.
Integrates with Dataverse for Dynamics 365 data.
Star schema design improves performance in Power BI.
DAX is used for creating measures and calculated columns.
Common DAX functions: SUM, AVERAGE, CALCULATE, FILTER.
Time intelligence functions: SAMEPERIODLASTYEAR, TOTALYTD.
Relationship types: single-directional and bi-directional.
Use surrogate keys for complex models.
Hierarchies help in drill-down visualizations.
Use calculated tables for scenario analysis.
DAX variables improve readability and performance.
Understand context: row context and filter context.
Measures are dynamic calculations; calculated columns are static.
Model optimization improves refresh times.
Avoid complex nested DAX for performance reasons.
Use the Performance Analyzer to debug slow visuals.
Aggregations can optimize large datasets.
Utilize incremental refresh for large datasets.
Use USERELATIONSHIP for inactive relationships in calculations.
Use DISTINCTCOUNT for unique value analysis.
Time dimension tables are essential for accurate date analysis.
Use LOOKUPVALUE for fetching values from related tables.
Use consistent color palettes for brand alignment.
Tooltips provide additional information on hover.
Slicers allow user-driven filtering of visuals.
Sync slicers across multiple report pages.
Drill-down functionality enhances detailed analysis.
Drill-through pages allow deeper exploration of details.
Use conditional formatting for highlighting critical values.
Group visuals logically for better readability.
Use cards for displaying KPIs clearly.
Use stacked vs. clustered charts appropriately.
Avoid cluttering visuals with excessive categories.
Use maps for geographical data visualization.
Use scatter plots for correlation analysis.
Use waterfall charts for breakdown analysis.
Utilize custom visuals from AppSource if needed.
Use gauge charts for performance tracking.
Use matrix visuals for pivot-style tables.
Apply sorting on visuals to highlight insights.
Bookmark feature enables storytelling presentations.
Maintain accessibility with high-contrast colors and labels.
Publish reports from Power BI Desktop to the Service.
Workspaces organize content for teams.
Dashboards can pin visuals from multiple reports.
Apps allow packaging of reports and dashboards for users.
Use sharing options with internal or external users.
Configure data refresh schedules in the Service.
Use gateway for on-premise data refresh.
Set up row-level security before sharing reports.
Monitor usage metrics of reports and dashboards.
Certified and promoted datasets standardize data usage.
Power BI Free allows personal report creation and viewing.
Power BI Pro is required for sharing and collaboration.
Power BI Premium provides dedicated capacity.
Premium Per User (PPU) combines Pro features with Premium capacities.
Use deployment pipelines for report version control.
Sensitivity labels can enforce data protection policies.
Auditing and activity logs enhance governance.
Paginated reports are supported in Power BI Premium.
AI visuals like decomposition tree and key influencers aid analysis.
Integration with Azure ML allows advanced predictive analytics.
Here are 100 clear, structured lines on Excel Advanced, focusing on formulas you need to know to be considered an advanced Excel user, useful for your upskilling, teaching, or CV positioning:
VLOOKUP() – Vertical lookup within a range.
HLOOKUP() – Horizontal lookup within a range.
INDEX() – Returns value at a specific row and column.
MATCH() – Returns position of a value in a range.
XLOOKUP() – Modern replacement for VLOOKUP and HLOOKUP.
OFFSET() – Returns a reference offset from a starting point.
INDIRECT() – Returns a reference specified by a text string.
CHOOSE() – Returns a value from a list based on an index number.
LOOKUP() – Searches for a value in a range.
FILTER() – Filters a range based on criteria (Dynamic Arrays).
IF() – Basic conditional logic.
IFS() – Multiple conditions without nesting.
AND() – Checks if all conditions are TRUE.
OR() – Checks if any condition is TRUE.
NOT() – Reverses logical value.
IFERROR() – Returns a value if formula results in an error.
IFNA() – Returns a value if formula results in #N/A.
SWITCH() – Evaluates an expression against a list of values.
Combining IF with AND/OR for nested conditions.
Using ISNUMBER(), ISTEXT(), ISBLANK(), etc., for testing cell values.
LEFT() – Returns leftmost characters.
RIGHT() – Returns rightmost characters.
MID() – Returns characters from the middle of a string.
LEN() – Returns the length of a string.
TRIM() – Removes extra spaces.
CONCAT() – Joins multiple text strings.
TEXTJOIN() – Joins text with delimiters.
UPPER(), LOWER(), PROPER() – Changes case.
FIND() – Finds position of text within text.
SUBSTITUTE() – Replaces text within text.
TODAY() – Returns current date.
NOW() – Returns current date and time.
DATE() – Creates a date from year, month, day.
TIME() – Creates a time from hour, minute, second.
DAY(), MONTH(), YEAR() – Extracts date parts.
HOUR(), MINUTE(), SECOND() – Extracts time parts.
EDATE() – Returns date a specified number of months before/after.
EOMONTH() – Returns last day of month before/after.
DATEDIF() – Calculates difference between dates.
NETWORKDAYS() – Calculates working days between dates.
SUM() – Adds numbers.
SUMIF() – Adds based on a condition.
SUMIFS() – Adds based on multiple conditions.
AVERAGE() – Calculates average.
AVERAGEIF() – Averages based on a condition.
AVERAGEIFS() – Averages based on multiple conditions.
COUNT() – Counts numeric cells.
COUNTA() – Counts non-empty cells.
COUNTIF() – Counts cells meeting a condition.
COUNTIFS() – Counts cells meeting multiple conditions.
MIN(), MAX() – Finds minimum and maximum.
MEDIAN() – Finds the median value.
MODE() – Finds the mode of a dataset.
ROUND(), ROUNDUP(), ROUNDDOWN() – Rounding values.
INT() – Rounds down to integer.
MOD() – Returns remainder after division.
RAND() – Returns a random number between 0 and 1.
RANDBETWEEN() – Random number between two values.
ABS() – Absolute value.
POWER() – Raises a number to a power.
PMT() – Calculates payment for a loan.
PV() – Present value of investment.
FV() – Future value of investment.
NPV() – Net present value.
IRR() – Internal rate of return.
RATE() – Interest rate per period.
XNPV() – NPV with specific dates.
XIRR() – IRR with specific dates.
SLN() – Straight-line depreciation.
DB() – Fixed-declining balance depreciation.
{} – Array constants for manual arrays.
SEQUENCE() – Generates a sequence of numbers.
SORT() – Sorts an array.
SORTBY() – Sorts based on another range/array.
UNIQUE() – Returns unique values from a range.
TRANSPOSE() – Switches rows and columns.
RANDARRAY() – Returns an array of random numbers.
XMATCH() – Advanced matching in arrays.
XLOOKUP() with arrays for dynamic lookups.
Using array formulas for advanced calculations.
ISERROR() – Checks if value is error.
ISERR() – Checks for error excluding #N/A.
ISNA() – Checks for #N/A error.
ERROR.TYPE() – Returns a number corresponding to error type.
NA() – Returns #N/A.
TYPE() – Returns the type of value.
CELL() – Information about cell formatting, location, contents.
INFO() – Information about the environment.
FORMULATEXT() – Displays formula in a cell.
N() – Converts value to number.
Using Data Validation for dynamic data entry.
Creating Named Ranges for readability and reusability.
Using Tables to structure data for dynamic ranges.
Mastery of PivotTables for dynamic analysis.
Using PivotCharts for visual analysis.
Conditional Formatting with formulas for dynamic visuals.
Using Goal Seek for reverse calculation.
Using Solver for optimization problems.
Recording and editing Macros for automation.
Combining multiple advanced formulas to create dynamic, reusable models.