Config files for my GitHub profile.
Use Power Query, Power Pivot, DAX, & Excel's data visualization tools to build powerful Business Intelligence solutions.
Use Power Query to pull external datasets into Excel, and transform them into whatever shape is needed for your analysis. Master the art and science of Data Modeling in Excel, connecting your datasets from Power Query so they can be analyzed together. Build "Power" Pivot Tables to rapidly extract insights from your Data Model, whether your data tables have 10 rows or 10 million. Become proficient in the DAX formula language, to inject more sophisticated calculations and KPIs into your Pivot Tables than you even thought possible. Polish your calculations into professional presentations with data visualization tools like Pivot Charts and conditional formatting. Leverage Slicers and Timelines to engineer dynamic dashboards that maximize the amount of information you can present on a single screen. Proficient in the DAX formula language, to inject more sophisticated calculations and KPIs into your Pivot Tables than you even thought possible.
*Power Query for ETL Operations **Pivot Tables ***The Excel Data Model ****Analysing the Data Model With DAX *****Advanced DAX ******Data Visualization Techniques
*Case Study Linear Regression - Fake Data *Case Study House Price Data Regression Model *Case Study HR Analytics *Case Study Customer Life Time Value *Microsoft Excel for Business Managers