Tutorials

• Functions
  • CUBEVALUE – get directly values from Power Pivot data model
  • How to merge texts in Excel
  • IF – one IF nested in another IF
  • IF function in detail
  • IFS – select from multiple options
  • Merging of selected strings – something like CONCATENATEIFS, if it existed
  • NOW – automatically updated time
  • Percentages and their calculation in Excel
  • VLOOKUP – function to connect two tables
    • Comparison of two lists and finding differences
• Macros and VBA
  • Macros – quick start
• Microsoft Flow
  • Running of Microsoft Flow by cell phone button
• Other tutorials
  • AutoSave to cloud in Excel
  • Power Pivot is nearly in all versions of Excel
  • Saving to One Drive versus saving to Sharpoint
  • Scenarios in Excel
  • Simple Excel calculation of market basket analysis, I mean cross sell / up sell, I mean if someone buys A, will he buy B?
• Pivot tables
  • Pivot tables – quick start
  • Set default layout of pivot tables
• Power BI
  • Power BI – use cases
    • Comparison of a plan and a reality in Power BI
  • Power Pivot
  • Power Query – Get and Transform
    • Conditional column in Power Query and in Power Pivot queries
    • Connect Excel to Facebook
    • Copying of Power Query queries
    • Date modifications with Power Query
    • Evaluation of Google Analytics data in the light of another business data
    • How to merge content of all files in folder with Power Query (Get and Transform)
    • Merge data from all sheets in selected file
    • Merging of data from all sheets from files in some folder
    • Power Query – source reference as filepath in cell
    • Power Query – source with relative path
    • Power Query M language – basic principles
    • Text modifications with Power Query (Get and Transform)
    • Types of merging of queries in Power Query or in Power BI
    • Use Power Query as a Pivot Table datasource
  • Power View
  • Powerbi.com and Power BI Desktop
    • Data Model in Power BI
      • Cross filtering in Power BI – simple explanation
      • Groups in Power BI
      • Hierarchies in Power BI
      • How to create Dataflow and how to connect to it
      • New table (View) in Data Model
      • Power BI – Column From Example
      • Quick Measures in Power BI
    • DAX – query language for Power BI and Power Pivot
      • CALENDARAUTO – create time dimension automatically (DAX – Power Pivot, Power BI)
      • CONCATENATEX (DAX – Power Pivot, Power BI)
      • CONTAINSSTRING, CONTAINSSTRINGEXACT – finds text string in another text string (DAX – Power Pivot, Power BI)
      • CROSSJOIN – all combinations of two lists (DAX – Power Pivot, Power BI)
      • DATATABLE – create your data directly in Data Model with no connection (DAX – Power Pivot, Power BI)
      • DISTINCT (DAX – Power Pivot, Power BI)
      • DIVIDE – division handling zero (DAX – Power Pivot, Power BI)
      • EXCEPT – comparison of tables – finding of additional rows (DAX – Power Pivot, Power BI)
      • GROUPBY – aggregations in data model using DAX (DAX – Power Pivot, Power BI)
      • IN – operator recognizing presence in a list of values (DAX – Power Pivot, Power BI)
      • INTERSECT – finding of common rows in two tables (DAX – Power Pivot, Power BI)
      • LOOKUPVALUE – assigning of values from other table without relation (DAX – Power Pivot, Power BI)
      • MIN, MAX – highest and smallest values in range (DAX – Power Pivot and Power BI)
      • NEXTDAY, NEXTMONTH, NEXTQUARTER, NEXTYEAR, PREVIOUSDAY, PREVIOUSMONTH, PREVIOUSQUARTER, PREVIOUSYEAR – values from previous or next time period (DAX – Power Pivot, Power BI)
      • PATH, PATHLENGTH, PATHITEM, PATHITEMREVERSE, PATHCONTAINS – playing whith hierarchies (DAX – Power Pivot, Power BI)
      • Pearson correlation coefficient in Power BI
      • RANK.EQ – determine the order of value in some column (DAX – Power Pivot, Power BI)
      • RELATED (DAX – Power Pivot, Power BI)
      • RELATEDTABLE – assigning of table connected by relation (DAX – Power Pivot, Power BI)
      • ROUND, ROUNDUP, ROUNDDOWN, MROUND – rounding functions (DAX – Power Pivot, Power BI)
      • Running totals simply (DAX – Power Pivot, Power BI)
      • SAMEPERIODLASTYEAR – comparison with previous year (DAX – Power Pivot, Power BI)
      • SELECTCOLUMNS – select some columns from table (DAX – Power Pivot, Power BI)
      • SUMMARIZE – groupping in data models (DAX – Power Pivot, Power BI)
      • SUMX – summary with filter or additional calculation (DAX – Power Pivot, Power BI)
      • TOPN – first N rows from table (DAX – Power Pivot, Power BI)
      • TOTALYTD, TOTALQTD, TOTALMTD – cumulative subtotals in time (DAX – PowerPivot, Power BI)
      • UNION – appending of multiple tables in DAX (DAX – Power Pivot, Power BI)
      • Use of SAMEPERIODLASTYEAR (or similar DAX functions) together with filters and slicers
      • USERPRINCIPALNAME – show user name and use it in RLS (DAX – Power Pivot, Power BI)
      • Variables in DAXu
    • Power BI – first steps
      • My first report in Power BI
      • Power BI vs Excel – comparison and main differences
      • Scheme of Microsoft BI both in Excel and outside Excel
      • What is what – Power Query, Power Pivot, Power View
    • Power BI – publishing
      • Publishing from Powerbi.com to any webpage
      • Quick publishing from Excel to Powerbi.com and analysis of Powerbi.com data in Excel
    • Power BI charts and visualization
      • Bookmarks and links in Power BI
      • Conditional formatting in Power BI
      • Custom color schemes in Power BI
      • Custom color schemes in Power BI
      • Custom visuals for Power BI
      • Decision trees in Power BI
      • DRILLTHROUGH filtering in Power BI – short tutorial
      • Fishes – the funniest visual in Power BI
      • Flow schemes in map
      • Gantt chart (project schedule or something like this) in Power BI
      • How to add PowerApps to Power BI dashboard
      • Key influencers – a very smart visual in Power BI
      • KPI visual v Power BI
      • Moving Scatter plot / Scatter chart in Power BI
      • Parameters in Power BI visuals
      • Percents and decimals in visual – Power BI
      • Pivot Tables in Power BI
      • Power BI in phone
      • Pulse chart – beautiful visual for time series presentation
      • R script in Power BI visuals – super simple example
      • Remove filter in visuals
      • Show date and time of data refresh
      • Synoptic Panel – create working visual from your custom scheme
    • Power BI data sources
      • Addressing rows, columns and values in Power BI
      • Connect Power BI to a webpage
      • Connect Power BI with Google Analytics
      • Data quality and distribution check in queries
      • Fuzzy matching in Power BI queries
      • How to schedule updates in Power BI
      • How to simply connect Power BI to Excel file stored on SharePoint
      • How to user Power BI to monitor users activities in Office 365.
      • Merging of data from all files in folder in Power BI
      • Parameters in Power BI queries
      • PDF as a source for Power BI
      • Power BI – writing of data directly in Power BI Desktop
      • Power BI connected to Dynamics 365
      • Power Query – get value from previous row
      • Python in Power BI – how does it work
    • Show source rows in Power BI
• PowerApps
  • Basic PowerApps application
  • Basic use of variables in PowerApps
  • Compass – PowerApps function – info about cellphones heading
  • Radiobutton getting items itesm table
• R script
  • Getting data from Excel to R-script, using Windows clipboard
  • Matrices in R language
  • R-script as a data source in Power BI Desktop
  • The simplest linear regression in R
  • Use R language to modify query in Power BI
• Statistics and more complex data analysis
  • Linear regression in Excel