Tips & tutorials
Videos and code notebooks with tips to help you on your analytics journey. All videos can be accessed through Matt's YouTube channel. Notebooks and other resources can be accessed through GitHub.Key business insights
Understand why it is better to have a dashboard with a well-thought set of KPI's instead of generic information in a business report, and learn three important aspects of demand forecasting, wich allows companies to optimize inventory by predicting future sales.
Παραδείγματα χρήσης Excel formulas, Python for Excel & Power BI datasets στο Excel
Πρώτες εντυπώσεις από την Python στο Excel και τρία διαφορετικά βίντεο που δείχνουν πώς υπολογίζουμε το ποσοστό των περιπτώσεων (π.χ. παραγγελιών) που μεταβαίνουν από την μία κατάσταση στην επόμενη (π.χ. συσκευασία → αποστολή → παράδοση) με φόρμουλες, Python & Power BI datasets στο Excel.
Tips on analytics and reporting on Power BI & Excel
Calculate percentage changes skipping dates with no values, combine in-budget and out-of-budget views, διερεύνηση δεδομένων στο Power BI και χρήση Power BI datasets στο Excel.
Technical tips on Power BI modelling
Why dimensional modelling & star schemas are important on Power BI data modelling, why it is important to use integer surrogate keys, and how you can reduce storage requirements by disabling the availability of columns for MDX based tools.
Microsoft Fabric tips & tutorial
Ingest into a Fabric Lakehouse using Power Query and visualize information with notebooks. Δωρέαν 60-day trial gia Microsoft Office 365, Microsoft Fabric & Power BI, ΧΩΡΙΣ εταιρικό email.
Advanced analytics tutorial on Cognitive Services, Power BI and Azure Synapse Analytics
This is a series of tutorials and accompanying report & notebook resources. On the relevant YouTube videos, we showcase how to perform sentiment analysis, text translation and key phrase extraction using Cognitive Services, Power BI and Azure Synapse Analytics. The end result is a Power BI report, supposingly used by the pizzeria owner to understand why sales change, based on the customer feedback and the sentiment it indicates. This report, as well as intermediate resources used to follow the tutorials, can be downloaded from the relevant GitHub repo.
GitHub Download the resources from my Github Repo
Slowly Changing Dimensions in Delta Lake
A tutorial in Jupyter Notebook format, on how to create a Type 2 SCD in Spark / Databricks, using Pyspark and Spark SQL
Covert status logs to availability per day
A tutorial in Jupyter Notebook format, on how to calculate the duration of service station outages within a day using status log files, in Spark / Databricks, using Pyspark and Spark SQL.
Complex metrics: Power BI vs. SQL
The aim of this notebook is to demonstrate the savings we have in productivity when we use DAX in Power BI (or SSAS) to calculate complex metrics, instead of T-SQL.