Do You Need a Personalized Premium One-on-one Data Analysis or Power BI Class?

How to Get Started?

Modern Excel:

  • New Formulas in Excel
  • XLOOKUP which is the replacement for VLOOKUP, HLOOKUP, and INDEX + MATCH combo
  • UNIQUE to remove duplicates and create dynamic dashboards/reports
  • FILTER to have a dynamic filter and create dependent dropdowns
  • SEQUENCE
  • SORT, SORTBY
  • RANDARRAY
  • LAMBDA
  • Power Query — the ultimate data transformation and cleaning tool in Excel
  • Combining data/reports from multiple sheets super easily
  • Combining data/reports from multiple files super easily
  • Pulling data from multiple sources and cleaning/transforming them
  • Unpivot (a magical data transformation tool)
  • Unrivaled column splitting
  • Split to rows
  • Separate numbers from texts
  • Split by case change
  • Split on every x number of characters
  • AI Insights
  • Text Analytics
  • Vision
  • Azure Machine Learning
  • Groupby (SQL type action)
  • Append Queries
  • Merge Queries
  • Standard Merge
  • Fuzzy Match to handle inconsistent spellings
  • Power Pivot
  • Handling data of more than 1.05 million rows
  • Data Modeling (creating relationships between datasets and more)
  • DAX formulas
  • Integrating with Pivot Table
  • Deep Dive into Pivot Table and Pivot Charts
  • Using Pivot Table to create very interactive dashboards
  • Slicers and Timelines
  • Data visualization and Charts
  • Understanding all the new 18 charts in Microsoft Excel
  • Combo chart
  • Sparklines
  • Conditional formatting as a visual
  • Icons and smart arts (infographics)
  • Formulas Deep Dive
  • IF, AND, OR, IFS, SWITCH, XOR
  • SUMIFS, COUNTIFS with wildcards (especially * and ?)
  • ISNA, ISERROR, ISBLANK, ISLOGICAL, ISFORMULA, ISREF, ISTEXT, ISNUMBER
  • VLOOKUP, HLOOKUP, INDEX + MATCH combo
  • EDATE, EOMONTH, TODAY, NOW, DATE, TEXT, YEAR, MONTH, DAY, DATEDIF, NETWORKDAYS,
  • CONCATENATE, CONCAT, TEXTJOIN, FIND, SEARCH, MID, LEFT, RIGHT
  • SUMPRODUCT to replace VLOOKUP, SUMIFS etc (a must know for anyone claiming Excel expert level)
  • INDEX (one of the most versatile formulas in Excel)
  • Creating Dashboards in Excel
  • Planning and Strategy Tools in Excel
  • Goal Seek
  • Scenario Manager
  • Data Table
  • Solver
  • Integrating Excel with Data Science tools
  • R (using BERT)
  • Python (using xlwings)
  • JavaScript Office APIs
  • Power Automate in Excel
  • Excel VBA
  • Recording macro
  • Coding from Scratch
  • Userforms
  • Modules
  • User-Defined Functions VBA

Power BI:

  • Mastering Power Query in Power BI
  • Power Query handbook with M codes
  • Advanced Editor use
  • Column profiling
  • Diving into the deep end of Merge and Append
  • Magic of Right Click
  • Mastering the Power Query interface
  • Enabling the Formula bar
  • Query Settings
  • Query Dependencies
  • DAX deep dive
  • Must know DAX formulas (CALCULATE, FILTER, SUMMARIZE etc)
  • DAX Studio
  • Debugging incorrectly working DAX formulas
  • Optimising your DAX
  • Data Modeling
  • Relationships
  • Cardinality
  • Direction
  • Synonyms
  • Date Table
  • Visuals and Report Creation
  • Native visuals
  • Imported/marketplace visuals
  • Symbols and Unicode icons
  • Report layouting
  • Row-level security
  • Report Publishing, Dashboards, and Power BI Service
  • AI in Power BI
  • Power BI Settings
  1. You get to choose the topics you want to master.
  2. You get to choose the date to have the class.
  3. You get more options of venue (our place or your place).
  4. You get to have the trainer work on your report for you during the training.
  5. You get to improve on the new areas of data analysis you are weak at without being forced to go through areas not important to you as is often the case in general training classes.
  6. The best part is that we are setting the fees at a very affordable rate that’s the same as the general classes while you get a personalized training.

--

--

Get the Medium app

A button that says 'Download on the App Store', and if clicked it will lead you to the iOS App store
A button that says 'Get it on, Google Play', and if clicked it will lead you to the Google Play store